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.
For more intense work, we have a CSV-formatted data dump of all our airports, countries, and 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.
DOWNLOAD AND USE AT YOUR OWN RISK! We hereby release all of these files into the Public Domain, with no warranty of any kind — By downloading any of these files, you agree that OurAirports.com, Megginson Technologies Ltd., and anyone involved with the web site or company hold no liability for anything that happens when you use the data, including (but not limited to) computer damage, lost revenue, flying into cliffs, or a general feeling of drowsiness that persists more than two days.
Do you agree with the above conditions? If so, then download away!
For information about the columns and values in the datasets, please visit the Data dictionary page.
- airports.csv (8,651,943 bytes, last modified Sep 18, 2020)
- Large file, containing information on all airports on this site.
- airport-frequencies.csv (1,217,959 bytes, last modified Sep 18, 2020)
Large file, listing communication frequencies for the
- runways.csv (3,044,000 bytes, last modified Sep 18, 2020)
Large file, listing runways for the airports in
- navaids.csv (1,526,655 bytes, last modified Sep 18, 2020)
- Large file, listing worldwide radio navigation aids.
- countries.csv (20,663 bytes, last modified Sep 18, 2020)
- A list of the world's countries. You need this spreadsheet to interpret the country codes in the airports and navaids files.
- regions.csv (366,104 bytes, last modified Sep 18, 2020)
- A list of all countries' regions (provinces, 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:
- Create a new, blank spreadsheet first, then use Excel's text import tool to load the CSV file into the blank spreadsheet.
- 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").
navaids.csvlisting worldwide radio navigation aids.
runways.csvto share new communication and runway data.
- There are new columns in all CSV pages, region codes are now full ISO 3316-2 codes (e.g. "US-NY" instead of "NY"), and some names have changed in regions.csv. Please check the files carefully before using.