OurAirports — airports with ICAO codes

Public domain11k rowsReport an issue

Meridian maintains this dataset from OurAirports’ public files. It sits in library, Meridian’s curated namespace.

Data from OurAirports, whose maintainers release it to the public domain with no guarantee of accuracy. Meridian prepared this table from OurAirports' files, and OurAirports does not endorse it.

One row per ICAO code, read from OurAirports' icao_code column: airports without an ICAO code are not included. ident and gps_code are OurAirports' other identifiers and are not always the ICAO code; join other data on code.

IATA's three-letter airport codes are left out, since IATA's code list is not open data: OurAirports' iata_code column is not read into the table, and its keywords column, which carries IATA codes, is dropped.

The data is as of the date in its release column, the day of the last change OurAirports made to its files before Meridian read them. OurAirports' airport file changes nightly; Meridian refreshes this dataset fortnightly in place under one name.

Meridian's table lists OurAirports' airports that carry a four-letter code from the International Civil Aviation Organization (ICAO), one row per code.[1][2] Air traffic control and airline operations such as flight planning use the four-letter ICAO code to name an airport.[2]

varchar
varchar
varchar
AGAFAGAFairport0Afutara AerodromeAfutara Aerodrome2026-11-16ourairports301649AGAFsmall_airport-9.191389160.94861123OCSBSolomon IslandsSB-MLMalaita ProvinceBilafalseAGAFhttps://en.wikipedia.org/wiki/Afutara_Airport
AGARAGARairport0Ulawa AirportUlawa Airport2026-11-16ourairports302290AGARsmall_airport-9.86054358262161.97954654740OCSBSolomon IslandsSB-MKMakira-Ulawa ProvinceAronafalseAGARhttps://en.wikipedia.org/wiki/Ulawa_Airport
AGATAGATairport0Uru Harbour AirportUru Harbour Airport2026-11-16ourairports35172AGATsmall_airport-8.87333161.011002OCSBSolomon IslandsSB-MLMalaita ProvinceAtoififalseAGAThttps://en.wikipedia.org/wiki/Uru_Harbour_Airport
AGBAAGBAairport0Barakoma AirportBarakoma Airport2026-11-16ourairports32570AGBAsmall_airport-7.912779808044434156.70599365234375OCSBSolomon IslandsSB-WEWestern ProvinceBarakomafalseAGBA
AGBTAGBTairport0Batuna AerodromeBatuna Aerodrome2026-11-16ourairports302402AGBTsmall_airport-8.56202777778158.11930555624OCSBSolomon IslandsSB-WEWestern ProvinceBatuna Mission StationfalseAGBT
AGEVAGEVairport0Geva AirportGeva Airport2026-11-16ourairports31524AGEVsmall_airport-7.575829982757568156.5970001220703OCSBSolomon IslandsSB-WEWestern ProvinceLiangiafalseAGEV
AGGAAGGAairport0Gwaunaru'u AirportGwaunaru'u Airport2026-11-16ourairports30634AGGAsmall_airport-8.70257160.6820075OCSBSolomon IslandsSB-MLMalaita ProvinceAukitrueAGGAhttps://en.wikipedia.org/wiki/Auki_Airport
AGGBAGGBairport0Bellona/Anua AirportBellona/Anua Airport2026-11-16ourairports302047AGGBsmall_airport-11.302222222200001159.79833333360OCSBSolomon IslandsSB-RBRennell and Bellona ProvinceAnuatrueAGGBhttps://en.wikipedia.org/wiki/Bellona/Anua_Airport
AGGCAGGCairport0Choiseul Bay AirportChoiseul Bay Airport2026-11-16ourairports302291AGGCsmall_airport-6.711944156.396111OCSBSolomon IslandsSB-CHChoiseul ProvinceChoiseul BaytrueAGGChttps://en.wikipedia.org/wiki/Choiseul_Bay_Airport
AGGEAGGEairport0Ballalae AirportBallalae Airport2026-11-16ourairports30678AGGEsmall_airport-6.990745155.8866565OCSBSolomon IslandsSB-WEWestern ProvinceBallalaetrueAGGEhttps://en.wikipedia.org/wiki/Balalae_Airport
AGGFAGGFairport0Fera/Maringe AirportFera/Maringe Airport2026-11-16ourairports35167AGGFsmall_airport-8.1075159.5769969OCSBSolomon IslandsSB-ISIsabel ProvinceFera IslandtrueAGGFhttps://en.wikipedia.org/wiki/Fera_Airport
AGGHAGGHairport0Honiara International AirportHoniara International Airport2026-11-16ourairports3AGGHlarge_airport-9.428160.05499328OCSBSolomon IslandsSB-GUGuadalcanal ProvinceHoniaratrueAGGHhttps://en.wikipedia.org/wiki/Honiara_International_Airport
AGGIAGGIairport0Babanakira AirportBabanakira Airport2026-11-16ourairports31885AGGIsmall_airport-9.7475159.839005OCSBSolomon IslandsSB-GUGuadalcanal ProvinceMbambanakirafalseAGGIhttps://en.wikipedia.org/wiki/Mbambanakira_Airport
AGGJAGGJairport0Avu Avu AirportAvu Avu Airport2026-11-16ourairports301837AGGJsmall_airport-9.868333160.41055625OCSBSolomon IslandsSB-GUGuadalcanal ProvinceAvu AvufalseAGGJ
AGGKAGGKairport0Ngorangora AirportNgorangora Airport2026-11-16ourairports31686AGGKsmall_airport-10.449700355500001161.89799499554OCSBSolomon IslandsSB-MKMakira-Ulawa ProvinceKirakiratrueAGGKhttps://en.wikipedia.org/wiki/Kirakira_Airport
AGGLAGGLairport0Santa Cruz/Graciosa Bay/Luova AirportSanta Cruz/Graciosa Bay/Luova Airport2026-11-16ourairports32275AGGLsmall_airport-10.7203165.79499818OCSBSolomon IslandsSB-TETemotu ProvinceSanta Cruz/Graciosa Bay/LuovatrueAGGLhttps://en.wikipedia.org/wiki/Luova_Airport
AGGMAGGMairport0Munda AirportMunda Airport2026-11-16ourairports4AGGMmedium_airport-8.32797157.26310OCSBSolomon IslandsSB-WEWestern ProvinceMundatrueAGGMhttps://en.wikipedia.org/wiki/Munda_Airport
AGGNAGGNairport0Nusatupe AirportNusatupe Airport2026-11-16ourairports31563AGGNsmall_airport-8.09778022766156.86399841313OCSBSolomon IslandsSB-WEWestern ProvinceGizotrueAGGNhttps://en.wikipedia.org/wiki/Nusatupe_Airport
AGGOAGGOairport0Mono AirportMono Airport2026-11-16ourairports31932AGGOsmall_airport-7.41694155.56500235OCSBSolomon IslandsSB-WEWestern ProvinceStirling IslandtrueAGGOhttps://en.wikipedia.org/wiki/Mono_Airport
AGGPAGGPairport0Parasi AirportParasi Airport2026-11-16ourairports32174AGGPsmall_airport-9.641670227050781161.4250030517578OCSBSolomon IslandsSB-MLMalaita ProvinceParasifalseAGGP
AGGRAGGRairport0Rennell/Tingoa AirportRennell/Tingoa Airport2026-11-16ourairports35171AGGRsmall_airport-11.55160.062778550OCSBSolomon IslandsSB-RBRennell and Bellona ProvinceRennell IslandtrueAGGRhttps://en.wikipedia.org/wiki/Tingoa_Airport
AGGSAGGSairport0Sege AirportSege Airport2026-11-16ourairports30989AGGSsmall_airport-8.57889157.876007OCSBSolomon IslandsSB-WEWestern ProvinceSegefalseAGGShttps://en.wikipedia.org/wiki/Seghe_Airport
AGGTAGGTairport0Santa Ana AirportSanta Ana Airport2026-11-16ourairports308425AGGTsmall_airport-10.847994162.4541083OCSBSolomon IslandsSB-MKMakira-Ulawa ProvinceSanta Ana IslandtrueAGGThttps://en.wikipedia.org/wiki/Santa_Ana_Airport_(Solomon_Islands)
AGGUAGGUairport0Marau AirportMarau Airport2026-11-16ourairports32238AGGUsmall_airport-9.86167160.8249973OCSBSolomon IslandsSB-GUGuadalcanal ProvinceMarautrueAGGUhttps://en.wikipedia.org/wiki/Marau_Airport
AGGVAGGVairport0Suavanao AirportSuavanao Airport2026-11-16ourairports32564AGGVsmall_airport-7.58556158.73100320OCSBSolomon IslandsSB-ISIsabel ProvinceSuavanaotrueAGGVhttps://en.wikipedia.org/wiki/Suavanao_Airport
AGGYAGGYairport0Yandina AirportYandina Airport2026-11-16ourairports302292AGGYsmall_airport-9.092816159.2184160OCSBSolomon IslandsSB-CECentral ProvinceYandinatrueAGGYhttps://en.wikipedia.org/wiki/Yandina_Airport
AGINAGINairport0Isuna HeliportIsuna Heliport2026-11-16ourairports594690AGINheliport-9.805809159.96272226OCSBSolomon IslandsSB-GUGuadalcanal ProvinceVeravaulofalseAGIN
AGKGAGKGairport0Kaghau AirportKaghau Airport2026-11-16ourairports35169AGKGsmall_airport-7.3305157.58530OCSBSolomon IslandsSB-CHChoiseul ProvinceKagau IslandtrueAGKGhttps://en.wikipedia.org/wiki/Kaghau_Airport
AGKUAGKUairport0Kukudu AirportKukudu Airport2026-11-16ourairports310179AGKUsmall_airport-8.0262156.9478332OCSBSolomon IslandsSB-WEWestern ProvinceKolombangara IslandfalseAGKU
AGKWAGKWairport0Kwailabesi AirportKwailabesi Airport2026-11-16ourairports308424AGKWsmall_airport-8.360508160.77512752OCSBSolomon IslandsSB-MLMalaita ProvinceKwailabesifalseAGKW
AGLMAGLMairport0Lomlom AirportLomlom Airport2026-11-16ourairports524977AGLMsmall_airport-10.296828166.32732255OCSBSolomon IslandsSB-TETemotu ProvinceLomlomfalseAGLMhttps://en.wikipedia.org/wiki/Lomlom_Airport
AGNAAGNAairport0Nana AirportNana Airport2026-11-16ourairports310002AGNAsmall_airport-10.6758162.204960OCSBSolomon IslandsSB-MKMakira-Ulawa ProvinceStar HarborfalseAGNA
AGOBAGOBairport0Manaoba AirportManaoba Airport2026-11-16ourairports508090AGOBsmall_airport-8.325008160.8005114OCSBSolomon IslandsSB-MLMalaita ProvinceManaobatrueAGOB
AGOKAGOKairport0Gatokae AerodromeGatokae Aerodrome2026-11-16ourairports35168AGOKsmall_airport-8.738358158.20283670OCSBSolomon IslandsSB-WEWestern ProvinceGatokaetrueAGOKhttps://en.wikipedia.org/wiki/Gatokae_Aerodrome
AGRCAGRCairport0Ringi Cove AirportRingi Cove Airport2026-11-16ourairports32211AGRCsmall_airport-8.12639045715332157.14300537109375OCSBSolomon IslandsSB-WEWestern ProvinceRingi CovefalseAGRC
AGRMAGRMairport0Ramata AirportRamata Airport2026-11-16ourairports35170AGRMsmall_airport-8.168060302734375157.64300537109375OCSBSolomon IslandsSB-WEWestern ProvinceRamatatrueAGRMhttps://en.wikipedia.org/wiki/Ramata_Airport
AGTIAGTIairport0Tulaghi HeliportTulaghi Heliport2026-11-16ourairports306999AGTIheliport-9.108160.1491666673OCSBSolomon IslandsSB-CECentral ProvinceTulaghi IslandfalseAGTI
AGVHAGVHairport0Viru Harbour AirstripViru Harbour Airstrip2026-11-16ourairports32578SB-VIUsmall_airport-8.508457157.689986130OCSBSolomon IslandsSB-WEWestern ProvinceVirufalseAGVH
ANYNANYNairport0Nauru International AirportNauru International Airport2026-11-16ourairports8ANYNmedium_airport-0.547893166.91952522OCNRNauruNR-14YarenYarentrueANYNhttps://www.nauruair.com/https://en.wikipedia.org/wiki/Nauru_International_Airport
AYAAAYAAairport0Ama AirportAma Airport2026-11-16ourairports301676AYAAsmall_airport-4.10111111111141.67145OCPGPapua New GuineaPG-ESWEast Sepik ProvincefalseAYAAAMA
AYABAYABairport0Ambaluwa AirstripAmbaluwa Airstrip2026-11-16ourairports301692PG-0013small_airport-5.720278144.9211116568OCPGPapua New GuineaPG-JWKJiwaka ProvinceAmbuluafalseAYABABU
AYACAYACairport0Akwom AirstripAkwom Airstrip2026-11-16ourairports301674PG-0003small_airport-3.94141.832778160OCPGPapua New GuineaPG-SANSandaun ProvinceAkwomfalseAYAC
AYADAYADairport0Ande AirstripAnde Airstrip2026-11-16ourairports301696PG-0015small_airport-7.020833145.8222225400OCPGPapua New GuineaPG-EHGEastern Highlands ProvinceSindenifalseAYADANDE
AYAEAYAEairport0Mount Aue AirportMount Aue Airport2026-11-16ourairports301736AYAEsmall_airport-6.229978144.6641814250OCPGPapua New GuineaPG-JWKJiwaka ProvinceAuefalseAYAEAUE
AYAFAYAFairport0Afore AirstripAfore Airstrip2026-11-16ourairports301665AYAFsmall_airport-9.13867148.3907012500OCPGPapua New GuineaPG-NPPNorthern ProvinceAforefalseAYAFAFEhttps://en.wikipedia.org/wiki/Afore_Airstrip
AYAGAYAGairport0Agaun AirportAgaun Airport2026-11-16ourairports301668AYAGsmall_airport-9.927715149.3899513200OCPGPapua New GuineaPG-MBAMilne Bay ProvinceAgaunfalseAYAGAUNhttps://en.wikipedia.org/wiki/Agaun_Airport
AYAHAYAHairport0Ali AirstripAli Airstrip2026-11-16ourairports301675PG-0004small_airport-7.925845142.34345680OCPGPapua New GuineaPG-WPDWestern ProvinceAlifalseAYAH
AYAIAYAIairport0Aitape AirportAitape Airport2026-11-16ourairports301672AYAIsmall_airport-3.143611142.34680610OCPGPapua New GuineaPG-SANSandaun ProvinceAitapefalseAYAIAPEhttps://en.wikipedia.org/wiki/Aitape_Airport
AYAJAYAJairport0Ambua AirstripAmbua Airstrip2026-11-16ourairports301691PG-0012small_airport-5.961487143.0604036600OCPGPapua New GuineaPG-HLAHela ProvinceAmbua Lodge - TarifalseAYAJABA
AYAKAYAKairport0Aiambak AirportAiambak Airport2026-11-16ourairports301654AYAKsmall_airport-7.342777777779999141.267590OCPGPapua New GuineaPG-WPDWestern ProvinceAiambakfalseAYAKAMBhttps://en.wikipedia.org/wiki/Aiambak_Airport

Summary

Counted from every row of this dataset, as of 16 November 2026.

Airports by type

How many ICAO codes OurAirports files under each of its airport types, and how many of those airports it records as having scheduled airline service, as of 16 November 2026.

TypeAirportsScheduled service
Large airport1,1731,152
Medium airport3,5792,106
Small airport5,549730
Heliport41523
Seaplane base189

Airports by continent

ICAO codes by OurAirports' continent code, as of 16 November 2026.

CodeContinentAirports
AFAfrica1,713
ANAntarctica7
ASAsia2,057
EUEurope2,138
NANorth America2,523
OCOceania1,234
SASouth America1,062

Countries with the most ICAO codes

The ten countries or territories with the most ICAO codes, by iso_country and OurAirports' name for each, as of 16 November 2026. The list covers 239 countries and territories in all.

CodeCountryAirports
United States (US)United States1,775
Australia (AU)Australia561
Canada (CA)Canada369
Brazil (BR)Brazil308
Papua New Guinea (PG)Papua New Guinea298
China (CN)China295
Indonesia (ID)Indonesia276
Germany (DE)Germany254
South Africa (ZA)South Africa254
Russia (RU)Russia216

Background

What an ICAO airport code is

The ICAO airport code, or ICAO location indicator, is a four-letter code that the International Civil Aviation Organization (ICAO) defines for aerodromes around the world.[2] ICAO publishes the codes quarterly in ICAO Document 7910, Location Indicators.[2] ICAO's API Data Service 2.0 offers the location indicators of Document 7910 as one of its services.[3] The selection of ICAO codes is partly delegated to authorities in each country.[2] ICAO codes also identify other aviation facilities, such as weather stations and area control centres, whether or not they are located at airports.[2]

The first one or two letters of an ICAO code indicate the country or a large region of a country, and the remaining letters identify the airport.[2] London Heathrow Airport's ICAO code is EGLL, where EG reflects that the airport is in the United Kingdom.[2] An ICAO code's first letter indicates the region: for example, K for the contiguous United States, C for Canada, E for northern Europe and Y for Australia.[4] ICAO airport codes do not begin with I, J, Q or X, though J has a ceremonial use for the planet Mars.[2] ICAO ceremonially assigned the designation JZRO to the place on Mars from which the Ingenuity helicopter took off for its first flight.[2] ICAO codes are sometimes updated: Johannesburg's airport changed from FAJS to FAOR when it was renamed O. R. Tambo International Airport.[2] Some airports have two ICAO codes, usually when civilian and military users share the airport.[2] The pseudo-code ZZZZ is used in flight plans for an aerodrome with no ICAO code assigned.[2]

The International Air Transport Association (IATA) defines IATA airport codes, three-letter codes designating many airports, cities and metropolitan areas around the world.[5] ICAO codes are separate and different from IATA's three-letter codes, which are generally used for airline timetables, reservations and baggage tags.[2] IATA codes are usually derived from the name of the airport or the city it serves, while ICAO codes are distributed by region and country.[2] IATA codes have no geographic structure and must be decided centrally by IATA.[2] Far more aerodromes have ICAO codes than IATA codes.[2] The assignment of IATA airport codes is governed by IATA Resolution 763, and the codes are published semi-annually in the IATA Airline Coding Directory.[5] In the contiguous United States and Canada, many airports have ICAO codes that are copies of their three-letter IATA codes with the geographical prefix added.[2]

Meridian reads each airport's ICAO code from OurAirports' icao_code column, not its ident column, because the two can differ.[1] Meridian keeps ident as a column of its own, as it does ourairports_id, OurAirports' record id, which joins back to OurAirports' runways, frequencies and other files.[1]

Who uses it

Air traffic control agencies use ICAO location indicators to identify airports, and weather agencies use them to produce METAR weather reports.[4] The METAR code depends wholly on the ICAO identifier system.[4]

The Federal Aviation Administration (FAA) location identifier is a three- to five-character alphanumeric code identifying aviation-related facilities inside the United States.[4] In the United States the IATA identifier usually equals the FAA identifier, but this is not always the case.[4] Meridian's local_code column holds the code a country's own aviation authority gives the airport, which in the US is the FAA's location identifier.[1]

Each refresh of Meridian's table deletes the ICAO codes OurAirports no longer lists.[1]

What we found building it

In OurAirports' airports.csv, Batha Airport has the ident AE-0001 and the ICAO code OEBT.[6] Meridian found that no closed airport or balloonport in OurAirports' data carries an ICAO code.[1] Meridian drops OurAirports' keywords column, a free-text field in which IATA codes appear alongside city codes and former codes.[1]

Where it comes from

The recommendations for ICAO airport codes were adopted on 24 March 1959 and came into force on 1 October the same year.[2] Airport codes arose in the 1930s, when pilots in the United States first used two-letter codes of the National Weather Service before a three-letter system was implemented.[5]

OurAirports publishes its open-data downloads in the GitHub repository davidmegginson/ourairports-data.[7] OurAirports generates the files every day, but GitHub updates a file's date only when its contents have changed.[7] People who create a free OurAirports account can add new airports or update existing ones, and their updates appear in the next daily data dump to GitHub.[7] OurAirports does not merge pull requests to the repository, because the next data dump would overwrite them.[7] OurAirports' data repository carries the Unlicense, which releases its contents into the public domain.[7][8]