Data wants to be free

I’ve finally gotten around to adding free data downloads to OurAirports. You can now download nightly CSV-formatted data dumps of all the airports, countries, and regions in OurAirports at

These will open with most spreadsheet and database programs (make sure you import them as UTF-8).

All data is released into the Public Domain and comes with no warranty. If you have any corrections or additions, please make them in the spreadsheet and then send them back to me.

This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

4 Responses to Data wants to be free

  1. Paul Tomblin says:

    What country code is that you’re using? I’m guessing it’s ISO 3166-1 Alpha-2. uses FIPS 10-4.

  2. david says:

    Paul: Thanks right, it’s ISO 3166-1 alpha 2. That does have its issues (including slower ammendments when countries change), but it’s well-known internationally, while FIPS 10-4 is used mainly in the U.S. ISO 3166 is also well-known from domain names (modulo the UK/GB difference).

  3. sidx says:

    When you’re classifying the airports as Small/Medium/Large, what criterion are you using? The reason I ask is that it doesn’t seem to hold based on the length of the longest runway or the MTOW of the heaviest aircraft that can land there (for a few airports I know). Is it categorized according to traffic?

  4. david says:

    sidx: Originally, I used a variety of inputs to set a score automatically, including number and length of runways, published instrument approaches, possession of ICAO and IATA codes (IATA is worth more because it’s rarer), presence in the top 100 airports list, and one or two other things. I then set cutoffs for the three sizes. Since then, however, I’ve been editing some of them by hand, and I hope to open that up before too long. I think that they’re right most of the time, but some are obviously off by a category.

Comments are closed.