Open data downloads

Data should be open and sharable.

OurAirports has RSS feeds for comments, CSV and HXL data downloads for geographical regions, and KML files for individual airports and personal airport lists (so that you can get your personal airport list any time you want).

Microsoft Excel users should read the special instructions below.

Downloads

Picture of a spreadsheet

For more intense work, we have a CSV-formatted data dump of all our airports, countries, and top-level administrative subdivisions (regions), which we update every night. You can download these files and open them with almost any spreadsheet program or import them into your own database. You can even use them to set up your own, competing airport web site if you'd like! We'd love you to give us credit, like we give credit to our sources, but you're not required to.

Terms of use

All data is released to the Public Domain, and comes with no guarantee of accuracy or fitness for use.

Datasets

For information about the columns and values in the datasets, please visit the data dictionary and map legend (for airport and navaid types).

Effective 3 November 2021, the download files are stored on GitHub, in the repository davidmegginson/ourairports-data. The old download links redirect to there. Cloning that repository is an alternative way to access the data.

airports.csv (8,396,127 bytes, last modified Nov 13, 2019)
Large file, containing information on all airports on this site.
airport-frequencies.csv (1,209,861 bytes, last modified Nov 13, 2019)
Large file, listing communication frequencies for the airports in airports.csv.
airport-comments.csv (0 bytes, last modified )
Large file, listing member comments for the airports in airports.csv.
runways.csv (3,025,820 bytes, last modified Nov 13, 2019)
Large file, listing runways for the airports in airports.csv.
navaids.csv (1,536,372 bytes, last modified Nov 13, 2019)
Large file, listing worldwide radio navigation aids.
countries.csv (20,648 bytes, last modified Nov 13, 2019)
A list of the world's countries. You need this spreadsheet to interpret the country codes in the airports and navaids files.
regions.csv (363,904 bytes, last modified Nov 13, 2019)
A list of all countries' top-level administrative subdivisions (provinces, governorates, states, etc.). You need this spreadsheet to interpret the region codes in the airport file.

Workarounds for Microsoft Excel

The CSV files above use the Unicode UTF-8 character encoding to represent a wide range of non-English characters, such as Hellenic, Cyrillic, Han Chinese, and Arabic scripts, as well as accented Latin characters.

Unfortunately, Microsoft Excel does not detect the character encoding of CSV files, and does not allow you to specify the encoding when you open them, always assuming a proprietary Microsoft character encoding. As a result, if you simply open the CSV files in Excel, any non-English characters will be scrambled.

There are two workarounds available:

  1. Create a new, blank spreadsheet first, then use Excel's text import tool to load the CSV file into the blank spreadsheet.
  2. Rename the CSV file's extension to ".txt" before opening it with Excel.

In both cases, Excel will give you an opportunity to specify the field separator (",") and the character encoding ("UTF-8"), and then accented and other non-English characters should appear without problem.

These workarounds are not necessary for OpenOffice Calc, which always prompts for the character encoding when opening a CSV file (just choose "UTF-8").