International Airport codes download

During a recent project I needed a database of IATA airport codes. Airports around the world are universally known by a unique three-letter code: the “International Air Transport Association (IATA) Location Identifier”. It is much easier for pilots, travel agents, frequent flyers, baggage handlers and anyone having anything to do with airlines to say and write LGA then the full “New York, NY – La Guardia Airport“.

A sample is shown below.

Airport			Code
Aalborg, Denmark 	AAL
Aalesund, Norway	AES
Aasiaat, Greenland 	JEG
Abadan, Iran 		ABD
Abakan, Russia		ABA

After scouting around for a while I stumbled upon a HTML list at orbitz. To make it usable in PHP I further converted the data to various formats (CSV, SQL, XML) for ease of use. The complete list of files is available below for download. The files contain codes for 3592 international airports sorted by name. This can be useful if your web application needs to convert airport names to their respective IATA codes.

Download IATA Airport Codes (sql, csv, xml)
Downloads : [downloadcounter(airport-codes)] / File size : [downloadsize(airport-codes)]

Further Reading:
Airport ABCs: An Explanation of Airport Identifier Codes

8 thoughts to “International Airport codes download”

  1. Thanks a lot for sharing this. Very helpful!

    Btw do you have the list of all airline codes?

  2. Thanks for the list. Was very useful!

    Just FYI, for anyone who might have issues, I had to make the following quick-fix in the XML:

    Dalat, Viet Nam – Lienkhang

    The original entry had an error.

    I also added this airport (the only airport that I have personally required, which wasn’t in the list):

    Shanghai Hongqiao International

  3. Thanks for sharing.
    Are you sure this is a complete list? Almost complete?
    Where did you get it?

    Thanks man!

Leave a Reply

Your email address will not be published.