What you get.
16 tables. 182 fields. Every change carries two dates. Every dataset we collect.
Coverage
- History starts
- March 19, 2026
- Snapshots
- 150 snapshot dates held, 147 usable. 2 truncated files and 1 copy of an older FAA file excluded. November 18, 2026
- FAA publications held
- 117 of 175. See every one. November 18, 2026
- Aircraft
- 319,451 records in the registry file. 309,577 valid registrations. November 18, 2026
- Entities
- Companies mapped to aircraft. Corporate jets tied to tickers. Transfers, exports included, since March 19, 2026. November 18, 2026
Drones registered under the FAA’s small drone rule (14 CFR part 48) are not in this file. Methodology · Sources
Update cadence
- The FAA
- Publishes five days a week, Tuesday to Saturday.
- Capture
- Each new file at 5:55 AM Mountain; nearly every version since August 2023 held.
Delivery formats
- Files
- CSV and Parquet, every table in both.
- Manifest
- Row counts and a SHA-256 checksum for every file.
- Delivery
- A secure link, or a private storage bucket that works with standard S3 tools.
- Revisions
- An export is never overwritten. A correction ships as a new, numbered revision.
Data dictionary
Every table and every field a subscriber receives. The full dictionary, with the meaning of each field and of each empty value, is in the sample pack.
- company_directory
-
One row per company. Subsidiaries roll up to their ultimate parent.
company_id, display_name, legal_name, public_private, ticker, exchange, cik, lei, sp500, sector_tags, primary_sector, aircraft_today, fleet_by_category, aircraft_held_as_lessor_or_trustee, change_30d, change_90d, change_180d, n_numbers_reserved, first_seen_date, last_activity_faa_date, last_activity_first_seen, as_of
- company_fleet
-
Each company’s aircraft, by category.
company_id, category, aircraft, as_of
- corporate_jet_directory
-
Business jets registered to S&P 500 companies or their subsidiaries.
ticker, company, n_number, make, model, year, manufacturer_held, registrant_as_filed, resolution_method, confidence, evidence_url, first_seen_date, last_change_faa_date, last_change_first_seen, last_change_type, as_of
- aircraft_daily
-
Every organization-registered aircraft on the as-of date. One row per tail number.
snapshot_date, n_number, company_id, company, ticker, is_lessor_or_trustee, captive_finance_or_leasing, registrant_as_filed, type_registrant, category, is_business_jet, make, model, year, status_code, cert_issue_date, state, match_method, confidence
- change_events
-
The change log: dated registry changes where at least one side maps to a company.
event_key, event_type, n_number, faa_event_date, faa_date_field, first_seen_date, company_id, company, ticker, to_is_lessor_or_trustee, from_company_id, from_company, from_holder_type, to_holder_type, name_change_classification
- new_entrants
-
A company’s first aircraft in a sector.
company_id, company, ticker, sector_tag, first_n_number, first_seen_date, first_cert_issue_date, company_aircraft_today
- sector_weekly
-
Weekly aircraft counts, by sector and by category.
week_end, snapshot_used, basis, sector, aircraft
- going_dark_counts
-
Monthly counts of owner records withheld or returned. Cells under 5 are hidden.
month, event, aircraft_category, holder_group, aircraft, aircraft_display, suppressed
- going_dark_daily
-
Withheld owner records per snapshot. Counts only.
snapshot_date, withheld_records, master_records
- deregistrations
-
Cancelled registrations from the FAA deregistered file, cancel dates from 2020.
n_number, make, model, category, year, cancel_date, export_country, status_code, last_registrant, last_holder_type, company_id, ticker, first_seen_date, in_latest_file
- exports_by_country
-
Monthly counts of registrations cancelled for export, by country and category.
month, export_country, aircraft_category, aircraft
- transfers
-
Every change of holder on an airframe, plus exports.
n_number, previous_n_number, from_holder, from_holder_type, from_ticker, to_holder, to_holder_type, to_ticker, category, is_business_jet, make, model, faa_event_date, first_seen_date, evidence_of_ownership_date, transfer_type
- deliveries_weekly
-
New deliveries by week, manufacturer and model family.
week_start, manufacturer, model_family, category, deliveries, business_jets
- event_ledger
-
Dated public events, each with its source.
company, company_id, event, event_type, public_date, source_url, added_by
- drone_imports_monthly
-
U.S. imports of heavy drones by month and country, from the Census Bureau.
month, hts_code, hts_description, country_code, country, general_imports_value_usd, imports_for_consumption_value_usd, general_imports_quantity, imports_for_consumption_quantity, quantity_unit, census_pull
- sample_events
-
One row per registry event in the 90 days before the as-of date. The buyer sample.
event_type, faa_event_date, faa_date_field, first_seen_date, n_number, previous_n_number, make, model, category, is_business_jet, in_corporate_jet_directory, company_id, company, ticker, match_method, confidence, from_holder, from_holder_type, from_ticker, to_holder, to_holder_type, to_ticker, evidence_of_ownership_date, export_country, source_table
Two dates on every change: faa_event_date, the FAA’s own date, and first_seen_date, the first snapshot that showed it. drone_imports_monthly uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.