Status

Serving release 2026-10-21, built October 21, 2026, schema 0.10.0.

Source	Records	As of
AD final rules	20,181	Fetched Oct 20
Emergency ADs	291	Fetched Oct 20
AD notices of proposed rulemaking	8,289	Fetched Oct 20
Special Airworthiness Information Bulletins	1,338	Fetched Oct 20
Type Certificate Data Sheets	8,116	Fetched Oct 20
Supplemental Type Certificates	83,470	Fetched Oct 20
Advisory Circulars	1,687	Fetched Oct 20
Airworthiness Concern Sheets	95	Fetched Oct 20
Part 39 documents	24,316	Issues through Oct 19
Registered aircraft	317,759	File of Oct 20
Deregistered aircraft (cancelled registrations)	383,637	File of Oct 20
Service difficulty reports (32 yearly files)	1,767,519	Fetched Oct 20
Accident and incident reports (ASIP search API)	234,247	Fetched Oct 20
JASC code table	547	File of Oct 27, 2008
Aviation investigations, from NTSB's public API	180,553	Fetched Oct 20
Aviation database, 1962 to 1981 (PRE1982.zip, Microsoft Access)	87,039	Fetched Oct 20
Aviation database, 1982 to 2007 (Pre2008.zip, Microsoft Access)	63,002	Fetched Oct 20
Aviation database, 2008 on (avall.zip, Microsoft Access)	31,303	Fetched Oct 20
Docket index: 192,398 files, linked but not copied	25,649	Fetched Oct 20
Census places (U.S. Census Bureau), for geocoding	32,363	Fetched Oct 20
Census state boundaries (U.S. Census Bureau), for geocoding	56	Fetched Oct 20
Census ZIP areas (U.S. Census Bureau), for geocoding	33,791	Fetched Oct 20
FAA airports (NASR) (FAA), for geocoding	19,427	Fetched Oct 20
GNIS domestic names (USGS), for geocoding	284,162	Fetched Oct 20
GNIS historical features (USGS), for geocoding	15,334	Fetched Oct 20
OurAirports airports (OurAirports), for geocoding	86,258	Fetched Oct 20

File	Size
openair.duckdb	821 MB
openair.sqlite.zst	663 MB (3.7 GB unpacked)
openair-sdr.sqlite.zst	298 MB (1.6 GB unpacked)
faa_directive.parquet	6.1 MB
faa_directive_section.parquet	29.9 MB
faa_directive_product.parquet	1.0 MB
faa_directive_relation.parquet	29 KB
faa_proposed_directive.parquet	2.2 MB
faa_saib.parquet	1.4 MB
faa_saib_product.parquet	177 KB
faa_concern_sheet.parquet	93 KB
faa_advisory_circular.parquet	248 KB
faa_advisory_circular_page.parquet	46.1 MB
faa_directive_ac.parquet	5 KB
faa_type_certificate.parquet	116 KB
faa_type_certificate_model.parquet	81 KB
faa_stc.parquet	5.6 MB
faa_stc_model.parquet	1.4 MB
faa_stc_file.parquet	26.2 MB
faa_directive_stc.parquet	12 KB
faa_aircraft_registration.parquet	16.6 MB
faa_aircraft_deregistration.parquet	18.5 MB
faa_aircraft_model.parquet	2.6 MB
faa_engine_model.parquet	116 KB
faa_aircraft_model_directive.parquet	422 KB
faa_engine_model_directive.parquet	78 KB
faa_aircraft_model_saib.parquet	57 KB
faa_engine_model_saib.parquet	26 KB
faa_incident_report.parquet	33.2 MB
faa_service_difficulty_report.parquet	162 MB
faa_jasc_code.parquet	47 KB
ntsb_case_detail.parquet	7.1 MB
ntsb_aircrafts.parquet	7.3 MB
ntsb_narratives.parquet	81.7 MB
ntsb_findings.parquet	989 KB
ntsb_events.parquet	970 KB
ntsb_occurrences.parquet	680 KB
ntsb_sequenceofevents.parquet	2.0 MB
ntsb_injuries.parquet	773 KB
ntsb_crew_and_occupants.parquet	848 KB
ntsb_pilots_flight_time_matrix.parquet	3.0 MB
ntsb_flight_time_summary.parquet	338 KB
ntsb_engines.parquet	1.2 MB
ntsb_owner_operators.parquet	2.7 MB
ntsb_aircraft_accidents.parquet	620 KB
ntsb_airworthiness_certificates.parquet	307 KB
ntsb_airports.parquet	1.8 MB
ntsb_approaches.parquet	599 KB
ntsb_itinerary.parquet	1.3 MB
ntsb_weather_conditions.parquet	2.0 MB
ntsb_weather_precipitations.parquet	53 KB
ntsb_data_dictionary.parquet	11 KB
ntsb_docket.parquet	1.7 MB
ntsb_docket_item.parquet	9.0 MB
ntsb_pre1982_first_half.parquet	6.1 MB
ntsb_pre1982_second_half.parquet	4.4 MB
ntsb_pre1982_occurrences.parquet	1.3 MB
ntsb_pre1982_seq_of_events.parquet	2.8 MB
ntsb_pre1982_codes.parquet	32 KB
ntsb_access_events.parquet	6.0 MB
ntsb_access_admin.parquet	1.1 MB
ntsb_access_aircraft.parquet	7.7 MB
ntsb_access_engines.parquet	1.5 MB
ntsb_access_flight_crew.parquet	1.9 MB
ntsb_access_data_dictionary.parquet	117 KB
geo_ntsb_case.parquet	2.7 MB
geo_faa_incident_report.parquet	4.2 MB
geo_faa_aircraft_registration.parquet	4.8 MB
geo_faa_aircraft_deregistration.parquet	4.2 MB
source_document.parquet	8.6 MB
source_file.parquet	19.6 MB