I'm looking for a database that contains all (most, many...as many as it can) world airports. I know of one such set available - http://www.world-airport-database.com/database.php - but the terms state that it's for internal use only...which kind of defeats the purpose.

The data would need to have the airport code, name, location (country, city, state/locale, zip/postal, lat/lon).

Do you know of such a set? Certainly willing to purchase such a set, free is always great too.

10 Answers 10


We've got that OurAirports data on WeoGeo Market where you can order a small subsection.


You could just take this link and place an order for that area of florida and look at what the data provides. It's a pretty good dataset.


OpenFlights Licence is favourable.

"Licensing and disclaimer The OpenFlights Airport, Airline and Route Databases are made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.

Airport data derived OurAirports and DAFIF, as well as route data from Airline Route Mapper, is in the public domain. Airline data derived from Wikipedia may be subject to the GNU Free Documentation License. Whether these databases pass the threshold of originality and are thus copyrightable in the United States is an open question, and Contentshare does not assert the validity or lack thereof of such a claim. This data is not suitable for navigation. OpenFlights does not assume any responsibility whatsoever for its accuracy, and consequently assumes no liability whatsoever for results obtained or loss or damage incurred as a result of application of the data. OpenFlights expressly disclaims all warranties, expressed or implied, including but not limited to implied warranties of merchantability and fitness for any particular purpose."


Download: airports.dat (~350 KB)

(a donation is suggested to help maintain the database)


I would have thought that OpenStreetMap would have pretty comprehensive coverage, certainly for major airports. You can see for yourself here. According to this, OpenStreetMap contains approx 96000 aeroways (i.e. airports), so it depends how comprehensive you want to be.

Your problem then becomes:

  • extracting the airports from the entire world file (20GB bz2 compressed) (see here for some pointers)
  • how to get the metadata, which may be far from complete

It ought to be easy to get the country and name as a minimum (can you define "city" anyway -- don't some airports serve two?).


I wouldn't go with OSM.As already mentioned the processsing of the planet.osm would be time consuming - but may be a use of osmosis and filter the data could help out. My experience shows that the airports data are not complete if speaking about the attribution and its often really hard to filter the data to make some valuable output. I would recomend the geonames.org source - the data are pretty good and consist all the major civilan/ millitary airport worldwide.


Naturalearthdata.com has this set in shapefile format. Contain name, IATA code, GPS code, link:

Derives from Mile High Club, a detailed GIS compilation of world wide airports that is in the public domain.



There's really only one database out there if you want it for operational purposes. Most of the ones we came across before this were for Flight Simulators.

This one is used by an actual Flight Planning organisation so the data is correct and useful. And there's a sample you can see before you purchase. I think there are about 6000 airports in it, which is about right for international ops.

Go here: http://flightservicebureau.org/world-airports-database/

And the sample is here: http://shop.fsbureau.org/online/database


Take a look at this site. http://ourairports.com/data/ You can download as CSV and they update the data regularly.
Otherwise, it's per Country and each Countries datasets or Region like EuroControl for Europe, FAA for USA. You can also check open data sites for airport data.


Do you have access to the ESRI Data DVD's - which you should if you are a customer. There is pretty rich set of worldwide data there.


We have a worldwide airport database with additional information such as airport facilities, photos, transportation, airport parking etc. Airport codes and location are also included.

See https://travel.sygic.com/en/b2b/airport-data for more info.


I downloaded my airport database from www.aviation-edge.com. They have a complete database of airports with more than 10.000 airports with interesting information about those airports. They aren't free though but for 39$ I didn't find anything more extensive than theirs. Check out their complete list on https://aviation-edge.com/aviation-api-list/

You can connect through API and get it for free if you just want the list of airports, or you can download/subscribe for the full information

  • 1
    Are you affiliated with the sites you reference? – Aaron Jan 13 '18 at 20:35
  • Hi, I'm not. I used their data and they asked me to share it if possible. – Jan vd Kerk Jan 15 '18 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.