Usage & Publication License: database price dollar sign99.00

9,478 World Airports Data: IATA, ICAO, FAA, Phone, Lat & Lon

9,478 world airports data: country, city, airport, IATA, ICAO, FAA, phone, Lat & Lon

database structure screenshot of 9,478 World Airports Data: IATA, ICAO, FAA, Phone, Lat & Lon

Description: This 9,478 airport database is the one you need if you want to quickly find the airport information of any city in the world. These airports are grouped by 26 categories. Each airport record contains the airport name, airport code, IATA code, location city, country abbreviation, longitude, and latitude.

Data Samples (JSON, CSV, XML, Excel):

Related DBs:

Database Statistics

  • Size: 4.42 MB
  • Tables: 3
  • Records: 9,478
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
category_1 26
  1. id
  2. ts
  3. title
airport 9,478
  1. id
  2. ts
  3. airpot
  4. city
  5. country
  6. iata
  7. icao
  8. faa
  9. iata_code
  10. icao_code
  11. faa_code
  12. phone
  13. fax
  14. latitude
  15. longitude
  16. time_zone
  17. wac
  18. email
  19. twitter
  20. facebook
  21. runway_1
category_1_x_airport 9,478
  1. id
  2. ts

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:


  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • J
  • K
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • X
  • Y
  • Z

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.

Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email:

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. The 3 letter word for what we breathe?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!

Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.