A global directory of airports with their IATA and ICAO identifier codes, associated city and country, and geographic coordinates. Use this dataset to power flight search autocomplete, validate airport codes in booking systems, or calculate distances between airports for logistics and travel applications.
Pro tip: Use the latitude and longitude columns with the Haversine formula to calculate great-circle distances between any two airports — perfect for estimating flight times or shipping costs.
Select which columns to include in your download.
About the Airport Codes Dataset
This dataset provides a comprehensive directory of airports worldwide, each identified by its IATA (International Air Transport Association) three-letter code and ICAO (International Civil Aviation Organization) four-letter code. The data includes the airport name, the city and country it serves, and precise geographic coordinates. Coverage spans commercial airports, regional airfields, and major military bases that handle civilian traffic.
Common Use Cases
Airport code lookups are fundamental to travel technology and logistics. Here are some of the most practical applications:
- Flight search autocomplete: Let users type a city name and show matching airports with their IATA codes, providing a familiar booking experience.
- Booking validation: Verify that origin and destination airport codes entered by users or received from GDS systems are valid IATA/ICAO identifiers.
- Distance calculation: Use the latitude and longitude fields to compute great-circle distances between airports for fare estimation, fuel planning, or carbon footprint calculations.
- Logistics routing: Map shipment origins and destinations to the nearest airports for air freight planning and transit time estimation.
Column Reference
Each row represents a single airport with its identification codes and location data:
- iata_code — The three-letter IATA airport code used in passenger ticketing and baggage handling (e.g. "LAX", "JFK", "LHR").
- icao_code — The four-letter ICAO airport code used in flight plans and air traffic control (e.g. "KLAX", "KJFK", "EGLL").
- airport_name — The official name of the airport (e.g. "Los Angeles International Airport").
- city — The city or metropolitan area the airport primarily serves.
- country — The country where the airport is located, using the common English name.
- latitude — The geographic latitude of the airport in decimal degrees (positive = north, negative = south).
- longitude — The geographic longitude of the airport in decimal degrees (positive = east, negative = west).
Understanding Airport Code Systems
IATA codes are the familiar three-letter identifiers printed on boarding passes and luggage tags. They are assigned by the International Air Transport Association and are designed for commercial aviation use. ICAO codes are four-letter identifiers maintained by the International Civil Aviation Organization, used primarily in flight planning, air traffic control, and meteorological reporting. The first letter of an ICAO code indicates the region (K for the contiguous US, C for Canada, E for Northern Europe, etc.), making them useful for geographic grouping. Not every airport has both codes — smaller airfields may only have an ICAO code.
Integration Tips
For autocomplete, index both the IATA code and city name so users can search by either. The JSON format makes a compact lookup table for frontend applications — key by IATA code for instant resolution. For distance calculations, use the coordinates with the Haversine formula or a geospatial library. When importing as SQL, create indexes on both iata_code and icao_code columns for fast lookups from either code system.