U.S. Airports and Aviation Facilities Database

Official FAA NASR aviation data delivered in cumulative CSV, JSON, and SQLite tier bundles with schemas, samples, statistics, and documentation.

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated September 3, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Core DirectoryUse under the established product license.
$49.00
Complete AviationUse under the established product license.Current update offer$10.00For eligible earlier Master purchases
$249.00
Records
19,411
Version
2.0.0
Release date
Sep 3, 2026
Before you choose
Explore the samples
U.S. Airports and Aviation Facilities Database List

U.S. Airports and Aviation Facilities Database v.2.0.0

19,411 Database Records

U.S. Airports and Aviation Facilities Database catalog icon U.S. Airports and Aviation Facilities Database Download
U.S. Airports and Aviation Facilities Database artwork

Official FAA NASR aviation data

U.S. airports, runways, communications, and facility data in developer-ready formats

Build maps, directories, logistics tools, aviation-service applications, research projects, and location intelligence with a normalized database of 19,411 FAA airports and other landing facilities across the United States and territories.

19,411Facilities
23,174Runways
37,151Frequencies
8Related tables

What is included in the database

The database starts with one authoritative facilities table and adds related operational tables through stable FAA identifiers. One airport or landing facility can have multiple runways, runway ends, attendance schedules, communications records, services, and weather-station relationships without repeating or flattening the parent facility record.

TableRecordsWhat it provides and how it connects
facilities19,411The parent directory of airports, heliports, seaplane bases, gliderports, balloonports, and ultralight facilities. Includes FAA site and location identifiers, ICAO codes where available, name, type, status, use, ownership, jurisdiction, coordinates, elevation, sectional chart, tower indicator, and runway summary.
runways23,174One-to-many runway records linked to facilities by the stable facility key and FAA site number. Includes runway ID, length, width, surface, condition, treatment, lighting, and source metadata.
runway_ends39,816Individual runway-end details linked to both a facility and runway. Includes coordinates, elevation, true alignment, traffic pattern, markings, approach lighting, visual glide-slope indicators, and declared distances.
attendance17,933Published attendance schedules linked to facilities, including month, day, hours, sequence, and effective-cycle metadata.
atc_facilities3,550Airport-associated air traffic control facility records with facility type and ID, names, tower calls, tower hours, and primary approach and departure calls.
control_services1,015Control-service relationships connected through the facility and ATC identifiers.
weather_stations2,555ASOS and AWOS station relationships linked to airport facilities, with station type, commissioning date, coordinates, elevation, remarks, and cycle metadata.
frequencies37,151Airport-linked communications and frequency records with serviced facility ID, frequency, use, calls, sectorization, remarks, and effective date.

Choose the tier that matches your project

Core Directory

$49

The complete facilities directory for internal reference, development, analysis, mapping, and local project use. Includes facility identity, codes, classifications, location fields, coordinates, elevation, chart, runway summary, and cycle metadata.

Usage license · 1 table · CSV, JSON, SQLite

Operations

$129

Everything in Core Directory plus normalized runways and runway ends. Designed for applications, publishing, mapping, logistics, aviation services, and research that need defensible facility-to-runway relationships.

Publication license · 3 tables · Cumulative bundle

Complete Aviation

$249

Everything in Operations plus attendance schedules, ATC facilities, control services, airport-linked frequencies, and ASOS/AWOS weather relationships. This is the broadest dataset and established license offered for the release.

Master license · 8 tables · Update eligibility

Files and documentation delivered with every tier

  • UTF-8 CSV tables for portable analysis and import
  • Structured JSON for applications and APIs
  • SQLite database for immediate querying and relationships
  • Machine-readable JSON and XML schema documentation
  • Public samples and verified release statistics
  • README, tier manifest, rights notice, and source documentation
  • Tier-specific protected ZIP with an exact entitlement mapping
  • Two completed downloads allowed for the purchased version

Buyer information and licensing

Core Directory uses the established Usage license, Operations uses the Publication license, and Complete Aviation uses the Master license. The tiers are cumulative, so each higher tier contains every table delivered in the tiers below it. Purchasing a tier grants access only to that tier's protected bundle. Complete Aviation customers are eligible to purchase future database updates for $10.00 under the established update terms. Review the license comparison above for allowed modification, importing, exporting, web use, multiple-system use, distribution, and copyright endorsement.

Designed for practical data work

  • Airport and landing-facility directories
  • GIS mapping and geospatial analysis
  • Routing, logistics, and service-area research
  • Aviation software and internal tools
  • Facility, runway, frequency, and weather research
  • Data enrichment using stable FAA identifiers

Source cycle and responsible use

Version 2.0.0 is generated reproducibly from the official FAA 28-Day NASR Subscription effective September 3, 2026, using the APT, ATC, AWOS, and FRQ source groups. FAA identifiers are preserved as text, missing ICAO identifiers remain valid null values, and duplicate names or municipalities are not falsely merged.

This is reference data only. It is not for navigation, flight planning, dispatch, air traffic control, or operational decision-making. Use current authorized aeronautical publications, NOTAMs, and qualified aviation sources for flight operations. No FAA or U.S. Government endorsement is implied.

19,411 Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Churches Police Departments Attractions Banks Post Offices Campgrounds

License Database Purchase Options

MASTER

Complete Aviation

$249.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

U.S. Airports and Aviation Facilities Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#240
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
facilities19411facility_key, faa_site_number, faa_location_id, icao_identifier, facility_name, facility_type, facility_status, ownership_type, facility_use, city, county, state_code, country_code, latitude_decimal, longitude_decimal, elevation_feet, sectional_chart, control_tower, number_of_runways, longest_runway_feet, effective_date
runways23174facility_key, faa_site_number, runway_id, length_feet, width_feet, surface_type, condition, treatment, lighting, length_source, length_source_date, effective_date
runway_ends39816facility_key, faa_site_number, runway_id, runway_end_id, latitude_decimal, longitude_decimal, elevation_feet, true_alignment, right_hand_traffic, marking_type, marking_condition, visual_glide_slope_indicator, approach_light_system, takeoff_run_available_feet, landing_distance_available_feet, effective_date
attendance17933facility_key, faa_site_number, schedule_sequence, month, day, hours, effective_date
atc_facilities3550facility_key, faa_site_number, facility_type, facility_id, icao_identifier, facility_name, tower_call, tower_hours, primary_approach_call, primary_departure_call, effective_date
control_services1015facility_key, faa_site_number, facility_type, facility_id, control_service, effective_date
weather_stations2555facility_key, faa_site_number, weather_station_id, station_type, commissioned_date, latitude_decimal, longitude_decimal, elevation_feet, remark, effective_date
frequencies37151facility_key, faa_site_number, serviced_facility_id, frequency_mhz, frequency_use, facility_type, tower_or_communication_call, primary_approach_call, sectorization, remark, effective_date

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for U.S. Airports and Aviation Facilities Database.

19,411Facilities
23,174Runways
39,816Runway Ends
17,933Attendance
3,550Atc Facilities
1,015Control Services
2,555Weather Stations
37,151Frequencies

Table and column statistics

Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.

facilities19,411 records · 21 fields
facility_key
Distinct
19,411
Missing
0 (0.0%)
faa_site_number
Distinct
19,410
Missing
0 (0.0%)
faa_location_id
Distinct
19,411
Missing
0 (0.0%)
icao_identifier
Distinct
2,726
Missing
16,685 (86.0%)
facility_name
Distinct
18,246
Missing
0 (0.0%)
facility_type
Distinct
6
Missing
0 (0.0%)
facility_status
Distinct
3
Missing
0 (0.0%)
ownership_type
Distinct
6
Missing
0 (0.0%)
facility_use
Distinct
2
Missing
0 (0.0%)
city
Distinct
7,954
Missing
0 (0.0%)
county
Distinct
1,802
Missing
0 (0.0%)
state_code
Distinct
59
Missing
147 (0.8%)
country_code
Distinct
16
Missing
0 (0.0%)
latitude_decimal
Distinct
19,349
Missing
0 (0.0%)
longitude_decimal
Distinct
19,384
Missing
0 (0.0%)
elevation_feet
Distinct
6,434
Missing
0 (0.0%)
sectional_chart
Distinct
57
Missing
435 (2.2%)
control_tower
Distinct
6
Missing
0 (0.0%)
number_of_runways
Distinct
13
Missing
0 (0.0%)
longest_runway_feet
Distinct
3,164
Missing
0 (0.0%)
effective_date
Distinct
1
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

facilitiesDownload this sample CSV
facility_keyfaa_site_numberfaa_location_idicao_identifierfacility_namefacility_typefacility_statusownership_typefacility_usecitycountystate_codecountry_codelatitude_decimallongitude_decimalelevation_feetsectional_chartcontrol_towernumber_of_runwayslongest_runway_feeteffective_date
00103.|A00103.0J0ABBEVILLE MUNIAOPUPUABBEVILLEHENRYALUS31.60172027-85.23854472468.3NEW ORLEANSNON-ATCT150002026-09-03
00106.|A00106.2A8ADDISONAOPRPUADDISONWINSTONALUS34.21714166-87.15815833786.0ATLANTANON-ATCT126442026-09-03
00108.|A00108.AL03STRICKLAND/SMALLEY FLDAOPRPRAKRONHALEALUS32.8475-87.71388888369.0ATLANTANON-ATCT220022026-09-03
00110.01|H00110.01AL39SHELBY MEDICAL CENTERHOPRPRALABASTERSHELBYALUS33.25222222-86.81222222510.0ATLANTANON-ATCT1502026-09-03
00110.|A00110.EETKEETSHELBY COUNTYAOPUPUALABASTERSHELBYALUS33.17777777-86.78322222585.6ATLANTANON-ATCT150002026-09-03
00112.1|A00112.1BFZKBFZALBERTVILLE RGNL/THOMAS J BRUMLIK FLDAOPUPUALBERTVILLEMARSHALLALUS34.22910888-86.255756111032.3ATLANTANON-ATCT161142026-09-03
00116.01|H00116.0133ALRUSSELL MEDICALHOPRPRALEXANDER CITYTALLAPOOSAALUS32.93007777-85.97090833703.0ATLANTANON-ATCT1452026-09-03
00116.|A00116.ALXKALXTHOMAS C RUSSELL FLDAOPUPUALEXANDER CITYTALLAPOOSAALUS32.91475-85.96294444685.8ATLANTANON-ATCT154222026-09-03
00119.|A00119.AIVKAIVGEORGE DOWNERAOPUPUALICEVILLEPICKENSALUS33.10674444-88.197175150.0MEMPHISNON-ATCT150012026-09-03
00124.|A00124.79JSOUTH ALABAMA RGNL AT BILL BENTON FLDAOPUPUANDALUSIACOVINGTONALUS31.30836111-86.39222222310.2NEW ORLEANSNON-ATCT160002026-09-03
00128.01|H00128.01AL42REGIONAL MEDICAL CENTER ANNISTONHOPRPRANNISTONCALHOUNALUS33.65600555-85.82444444844.0ATLANTANON-ATCT1502026-09-03
00128.02|H00128.0204ALANNISTON ARMY DEPOT HELIPADHOMRPRANNISTONCALHOUNALUS33.62638888-85.96722222686.0ATLANTANON-ATCT1602026-09-03
00128.|A00128.ANBKANBANNISTON RGNLAOPUPUANNISTONCALHOUNALUS33.58817-85.858115612.1ATLANTANON-ATCT170022026-09-03
00133.5|A00133.551ALARDMOREAOPRPRARDMORELIMESTONEALUS34.9790748-86.88328483922.0ATLANTANON-ATCT127002026-09-03
00134.|H00134.90KYMOTHER NATURE SPRING WATERHOPRPRASHCAMPPIKEKYUS37.25874722-82.461477771000.0CINCINNATINON-ATCT1452026-09-03
00135.01|H00135.010AL2CLAY COUNTY HOSPITALHOPUPRASHLANDCLAYALUS33.27721666-85.824819441040.0ATLANTANON-ATCT1242026-09-03
00135.|A00135.26AASHLAND/LINEVILLEAOPUPUASHLAND/LINEVILLECLAYALUS33.28419722-85.808965271065.0ATLANTANON-ATCT140232026-09-03
00137.|A00137.AL60DUGGER'S FLDAOPRPRASHVILLEST CLAIRALUS33.83870972-86.21136527560.0ATLANTANON-ATCT118002026-09-03
00139.01|A00139.0156ALBEECHWOOD AIRPARKAOPRPRATHENSLIMESTONEALUS34.77277777-87.17458333646.8ATLANTANON-ATCT126302026-09-03
00139.|H00139.5AL9ATHENS-LIMESTONE HOSPITAL HELIPADHOPRPRATHENSAUTAUGAALUS34.80281666-86.98060555693.0NON-ATCT1602026-09-03

Records Information

The Core Directory contains 19,411 FAA airports and other landing facilities, including airports, heliports, seaplane bases, gliderports, balloonports, and ultralight facilities. Operations adds 23,174 runway records and 39,816 runway-end records. Complete Aviation adds 17,933 attendance schedules, 3,550 ATC facility records, 1,015 control-service records, 37,151 airport-linked frequency records, and 2,555 ASOS/AWOS weather-station relationships. Duplicate facility names and municipalities remain separate using stable FAA site identifiers, while missing ICAO codes remain valid null values.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details