World Airports Database

Global airports database with ICAO/IATA codes, coordinates, city, country, elevation, and timezone. 7,900+ airports.

What is this?

This repository provides a ready-to-use database of world airports database with 7,914 records. Available as SQLite database and SQL dumps — ideal for developers, data analysts, and fintech applications.

Downloads

Format	Description	Link
SQLite	Single database file, ready to query	Releases
SQL	SQL dump, import into MySQL/PostgreSQL/etc.	Releases
Excel / CSV / PDF	Formatted spreadsheets	listbase.org

Database Schema

CREATE TABLE airports (
  icao TEXT,
  iata TEXT,
  name TEXT NOT NULL,
  city TEXT,
  state TEXT,
  country TEXT NOT NULL,
  elevation INTEGER,
  lat REAL,
  lon REAL,
  tz TEXT
);
CREATE INDEX idx_airports_iata ON airports (iata);
CREATE INDEX idx_airports_icao ON airports (icao);
CREATE INDEX idx_airports_country ON airports (country);

Stats

• 7,914 records
• 1 datasets
• Updated: 2026-07-30

Preview

icao	iata	name	city	state	country	elevation	lat	lon	tz
06N7	NYS	New York Skyports Seaplane Base	New York	New York	US		40.73399083	-73.97291638	America/New_York
19AK	ICY	Icy Bay Airport	Icy Bay	Alaska	US	50	59.96900177	-141.662002563	America/Anchorage
2AK6	HGZ	Hog River Airport	Hogatza	Alaska	US	534	66.2161026	-155.6690063	America/Anchorage
38WA	BYW	Blakely Island Airport	Blakely Island	Washington	US	66	48.5789985657	-122.825996399	America/Los_Angeles
3IS8	BDF	Rinkenberger Restricted Landing Area	Bradford	Illinois	US	808	41.2308998108	-89.6156997681	America/Chicago
65LA	BCS	Southern Seaplane Airport	Belle Chasse	Louisiana	US		29.8661003113	-90.0222015381	America/Chicago
7NC2	DUF	Pine Island Airport	Corolla	North Carolina	US	16	36.2535018921	-75.7884979248	America/New_York
82CL	FOB	Fort Bragg Airport	Fort Bragg	California	US	71	39.4743003845	-123.79599762	America/Los_Angeles
AGAF	AFT	Afutara Aerodrome	Bila	Malaita	SB	23	-9.1913888889	160.948611111	Pacific/Guadalcanal
AGAR	RNA	Ulawa Airport	Arona		SB	40	-9.8605435826	161.979546547	Pacific/Guadalcanal
AGAT	ATD	Uru Harbour Airport	Atoifi		SB		-8.8733301163	161.0110015869	Pacific/Guadalcanal
AGBA	VEV	Barakoma Airport	Barakoma		SB		-7.912779808	156.7059936523	Pacific/Guadalcanal
AGBT	BPF	Batuna Aerodrome	Batuna Mission Station	Western Province	SB	24	-8.5620277778	158.119305556	Pacific/Guadalcanal
AGEV	GEF	Geva Airport	Liangia		SB		-7.5758299828	156.5970001221	Pacific/Guadalcanal
AGGA	AKS	Auki Airport	Auki		SB	5	-8.7025699616	160.682006836	Pacific/Guadalcanal
...	...	...	...	...	...	...	...	...	...

Showing 15 of 7,914 records

Release Files

File	Records	Description
world-airports.db	7,914	SQLite database (all data)
world-airports.sql	1-7,914	SQL dump

Usage

SQLite

sqlite3 world-airports.db "SELECT iata, name, city, country FROM airports WHERE country = 'TH' ORDER BY name;"

Import SQL (MySQL)

mysql -u root -p your_database < world-airports.sql

Import SQL (PostgreSQL)

psql -U postgres -d your_database -f world-airports.sql

Use Cases

• Flight search apps — Look up airports by IATA/ICAO code or city name
• Distance calculation — Use lat/lon coordinates to compute distances between airports
• Travel planning — Find airports near a destination with timezone info
• Logistics & cargo — Map airport locations for freight routing
• Data enrichment — Enrich flight data with airport names, cities, and countries

FAQ

What is an IATA code?

An IATA code is a 3-letter airport identifier assigned by the International Air Transport Association (e.g., LAX, NRT, BKK). It is used in airline tickets, baggage tags, and flight booking systems.

What is an ICAO code?

An ICAO code is a 4-letter airport identifier assigned by the International Civil Aviation Organization (e.g., KLAX, RJTT, VTBS). It is used in air traffic control and flight plans.

How often is this data updated?

The database is updated monthly. Check the Releases page for the latest version.

Can I use this data commercially?

Yes. This data is released under the MIT License — free to use for any purpose, including commercial applications.

How do I find airports in a specific country?

SELECT iata, name, city FROM airports WHERE country = 'JP' ORDER BY name;

How do I search for an airport by name?

SELECT * FROM airports WHERE name LIKE '%Heathrow%';

Countries (1)

Country	Code	Records	Details
United States of America	US	1,777	View
Australia	AU	528	View
Canada	CA	405	View
Brazil	BR	331	View
China	CN	238	View
Russian Federation	RU	196	View
Indonesia	ID	174	View
France	FR	164	View
India	IN	147	View
United Kingdom of Great Britain and Northern Ireland	GB	114	View
Germany	DE	111	View
Colombia	CO	100	View
Argentina	AR	99	View
Japan	JP	97	View
Papua New Guinea	PG	92	View
Mexico	MX	88	View
South Africa	ZA	82	View
Iran, Islamic Republic of	IR	76	View
Italy	IT	67	View
Türkiye	TR	66	View
Philippines	PH	63	View
Congo, Democratic Republic of the	CD	61	View
Norway	NO	57	View
New Zealand	NZ	57	View
Madagascar	MG	56	View
Pakistan	PK	56	View
Venezuela, Bolivarian Republic of	VE	56	View
Malaysia	MY	56	View
Spain	ES	55	View
Sweden	SE	53	View
Chile	CL	50	View
Peru	PE	48	View
French Polynesia	PF	47	View
Greece	GR	45	View
Thailand	TH	45	View
Myanmar	MM	44	View
Algeria	DZ	42	View
Nepal	NP	42	View
Ethiopia	ET	40	View
Bolivia, Plurinational State of	BO	40	View
Iceland	IS	38	View
Saudi Arabia	SA	36	View
Angola	AO	35	View
Finland	FI	34	View
Ukraine	UA	34	View
Bahamas	BS	33	View
Cuba	CU	32	View
Solomon Islands	SB	31	View
Kenya	KE	31	View
Costa Rica	CR	30	View
Vanuatu	VU	30	View
Tanzania, United Republic of	TZ	28	View
Ecuador	EC	28	View
Burkina Faso	BF	27	View
Poland	PL	26	View
Gabon	GA	26	View
Egypt	EG	26	View
Korea, Republic of	KR	26	View
Viet Nam	VN	26	View
Portugal	PT	25	View
Kazakhstan	KZ	25	View
Honduras	HN	24	View
Afghanistan	AF	24	View
Namibia	NA	23	View
Morocco	MA	23	View
Côte d'Ivoire	CI	22	View
Nigeria	NG	22	View
Congo	CG	22	View
Sudan	SD	22	View
Fiji	FJ	22	View
Guyana	GY	22	View
Central African Republic	CF	21	View
Zambia	ZM	21	View
Cameroon	CM	20	View
Guatemala	GT	20	View
Kiribati	KI	20	View
Taiwan, Province of China	TW	20	View
Ireland	IE	19	View
Mozambique	MZ	19	View
Mauritania	MR	18	View
Romania	RO	18	View
Mongolia	MN	18	View
Denmark	DK	17	View
Lesotho	LS	17	View
Somalia	SO	17	View
Maldives	MV	17	View
Switzerland	CH	16	View
Suriname	SR	16	View
Botswana	BW	15	View
Chad	TD	15	View
Panama	PA	15	View
New Caledonia	NC	15	View
Oman	OM	15	View
Yemen	YE	15	View
Uzbekistan	UZ	15	View
Greenland	GL	14	View
Senegal	SN	14	View
Libya	LY	14	View
Israel	IL	14	View
Lao People's Democratic Republic	LA	14	View
Netherlands, Kingdom of the	NL	13	View
Sri Lanka	LK	13	View
Bangladesh	BD	13	View
Malawi	MW	12	View
Mali	ML	12	View
Bulgaria	BG	12	View
Czechia	CZ	12	View
Uruguay	UY	12	View
Tunisia	TN	11	View
Zimbabwe	ZW	11	View
Guinea	GN	11	View
Uganda	UG	11	View
Dominican Republic	DO	11	View
United Arab Emirates	AE	11	View
Iraq	IQ	11	View
Paraguay	PY	11	View
Cambodia	KH	11	View
Cabo Verde	CV	10	View
Nicaragua	NI	10	View
Puerto Rico	PR	10	View
Belgium	BE	9	View
Liberia	LR	9	View
Croatia	HR	9	View
Sierra Leone	SL	8	View
Hungary	HU	8	View
Slovakia	SK	8	View
Cook Islands	CK	8	View
Azerbaijan	AZ	8	View
Lithuania	LT	7	View
Austria	AT	7	View
Serbia	RS	7	View
Turks and Caicos Islands	TC	7	View
French Guiana	GF	7	View
Belarus	BY	7	View
Turkmenistan	TM	7	View
Timor-Leste	TL	7	View
Benin	BJ	6	View
Niger	NE	6	View
Seychelles	SC	6	View
Jamaica	JM	6	View
Haiti	HT	6	View
Tonga	TO	6	View
Syrian Arab Republic	SY	6	View
Guadeloupe	GP	6	View
Ghana	GH	5	View
Estonia	EE	5	View
Djibouti	DJ	5	View
Rwanda	RW	5	View
Marshall Islands	MH	5	View
Saint Vincent and the Grenadines	VC	5	View
Latvia	LV	4	View
Comoros	KM	4	View
Eritrea	ER	4	View
South Sudan	SS	4	View
Cyprus	CY	4	View
Bosnia and Herzegovina	BA	4	View
Samoa	WS	4	View
Jordan	JO	4	View
Micronesia, Federated States of	FM	4	View
Georgia	GE	4	View
Tajikistan	TJ	4	View
Singapore	SG	4	View
Korea, Democratic People's Republic of	KP	4	View
Western Sahara	EH	3	View
Burundi	BI	3	View
Slovenia	SI	3	View
Montenegro	ME	3	View
Cayman Islands	KY	3	View
American Samoa	AS	3	View
Qatar	QA	3	View
Northern Mariana Islands	MP	3	View
Bonaire, Sint Eustatius and Saba	BQ	3	View
Virgin Islands (British)	VG	3	View
Kyrgyzstan	KG	3	View
Bhutan	BT	3	View
Togo	TG	2	View
Guernsey	GG	2	View
Falkland Islands (Malvinas)	FK	2	View
Eswatini	SZ	2	View
Equatorial Guinea	GQ	2	View
Saint Helena, Ascension and Tristan da Cunha	SH	2	View
Mauritius	MU	2	View
Réunion	RE	2	View
Sao Tome and Principe	ST	2	View
Guinea-Bissau	GW	2	View
Albania	AL	2	View
Saint Pierre and Miquelon	PM	2	View
Moldova, Republic of	MD	2	View
North Macedonia	MK	2	View
El Salvador	SV	2	View
Belize	BZ	2	View
Wallis and Futuna	WF	2	View
Kuwait	KW	2	View
Lebanon	LB	2	View
Guam	GU	2	View
United States Minor Outlying Islands	UM	2	View
Antigua and Barbuda	AG	2	View
Dominica	DM	2	View
Grenada	GD	2	View
Virgin Islands (U.S.)	VI	2	View
Saint Kitts and Nevis	KN	2	View
Saint Lucia	LC	2	View
Trinidad and Tobago	TT	2	View
Armenia	AM	2	View
Nauru	NR	1	View
KS	KS	1	View
Jersey	JE	1	View
Isle of Man	IM	1	View
Faroe Islands	FO	1	View
Luxembourg	LU	1	View
British Indian Ocean Territory	IO	1	View
Mayotte	YT	1	View
Gambia	GM	1	View
Malta	MT	1	View
Gibraltar	GI	1	View
Tuvalu	TV	1	View
Niue	NU	1	View
Bahrain	BH	1	View
Palau	PW	1	View
Antarctica	AQ	1	View
Barbados	BB	1	View
Martinique	MQ	1	View
Saint Martin (French part)	MF	1	View
Saint Barthélemy	BL	1	View
Aruba	AW	1	View
Curaçao	CW	1	View
Sint Maarten (Dutch part)	SX	1	View
Anguilla	AI	1	View
Montserrat	MS	1	View
Bermuda	BM	1	View
Hong Kong	HK	1	View
Macao	MO	1	View
Brunei Darussalam	BN	1	View
Cocos (Keeling) Islands	CC	1	View
Christmas Island	CX	1	View
Norfolk Island	NF	1	View

Browse Online

Explore and download individual datasets at listbase.org.

License

MIT — Free to use for any purpose.

Source

OurAirports, OpenFlights, and public aviation registries

---

Made with data from ListBase.org — Free Reference Tables & Lists