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 : 11479 / File size : 120 kB

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



8 thoughts on “International Airport codes download

  1. 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
    DLI

    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
    SHA

  2. 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. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>