DataBrighten

    Airport codes list: IATA and ICAO

    4,007airports with scheduled service · 8,799 with an IATA code

    Every airport with an IATA code, with ICAO code, city, country and coordinates, as CSV, Excel or JSON. Updated 19 November 2026.

    textnumberdateyes/no
    IATA airports8,799in the file
    Scheduled4,007airline service
    Countries233with scheduled service
    LicencePublic domainOurAirports

    What is in the file

    The download has 8,799 airports that have a three-letter IATA code; 4,007 of them in 233 countries have scheduled airline service (1,151 large, 2,094 medium and 762 small). Each row has the IATA and ICAO codes, the airport name, the city it serves, its region and country, the OurAirports size class, a scheduled-service flag, coordinates and elevation. Heliports, seaplane bases and closed airports are left out.

    Countries with 20 or more airports with scheduled service have their own page, 43 in all. The United States has the most (634).

    Countries with their own list

    The 1,151 large airports

    IATAAirportCountry
    AACEl Arish International AirportEgypt
    AAEAnnaba Rabah Bitat AirportAlgeria
    AALAalborg AirportDenmark
    AANAl Ain International AirportUnited Arab Emirates
    AARAarhus AirportDenmark
    ABAAbakan International AirportRussia
    ABBAsaba International AirportNigeria
    ABDAbadan Ayatollah Jami International AirportIran
    ABJFélix-Houphouët-Boigny International AirportCôte d'Ivoire
    ABQAlbuquerque International SunportUnited States
    ABVNnamdi Azikiwe International AirportNigeria
    ABZAberdeen International AirportUnited Kingdom
    ACAGeneral Juan N. Álvarez International AirportMexico
    ACCKotoka International AirportGhana
    ACECésar Manrique-Lanzarote AirportSpain
    ADBAdnan Menderes International AirportTurkey
    ADDAddis Ababa Bole International AirportEthiopia
    ADEAden International AirportYemen
    ADJMarka International (Amman Civil) AirportJordan
    ADLAdelaide International AirportAustralia
    ADZGustavo Rojas Pinilla International AirportColombia
    AEPAeroparque Jorge NewberyArgentina
    AERSochi International AirportRussia
    AESÅlesund AirportNorway
    AEYAkureyri International AirportIceland
    AGAAl Massira AirportMorocco
    AGPMálaga-Costa del Sol AirportSpain
    AGTGuaraní International AirportParaguay
    AGUAguascalientes International AirportMexico
    AHBAbha International AirportSaudi Arabia
    AJFAl-Jawf International AirportSaudi Arabia
    AKLAuckland International AirportNew Zealand
    AKXAktobe International AirportKazakhstan
    ALAAlmaty International AirportKazakhstan
    ALBAlbany International AirportUnited States
    ALCAlicante-Elche Miguel Hernández AirportSpain
    ALGHouari Boumediene AirportAlgeria
    ALPAleppo International AirportSyria
    AMDSardar Vallabh Patel International AirportIndia
    AMMQueen Alia International AirportJordan

    Find the nearest airport

    With latitude and longitude in the file, the haversine formula gives the distance from any point. In SQL engines with trigonometry functions:

    SELECT iata, name,
      2 * 6371 * ASIN(SQRT(POWER(SIN(RADIANS(latitude - 40.71) / 2), 2) +
        COS(RADIANS(40.71)) * COS(RADIANS(latitude)) * POWER(SIN(RADIANS(longitude + 74.01) / 2), 2))) AS km
    FROM airport_codes
    WHERE scheduled_service = 'yes'
    ORDER BY km
    LIMIT 5;   -- the 5 nearest to (40.71, -74.01)