Skip to content

Registered aircraft · 214

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-03-21')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N780AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 37502 N780HAHawaiian Airlines Inc · Seattle, WABuilt 2024 · S/N 66428 N781AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 37503 N781HAHawaiian Airlines Inc · Seattle, WABuilt 2023 · S/N 66429 N782AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 37165 N782AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37504 N782HAAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 66430 N783AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 37167 N783AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37505 N783HAHawaiian Airlines Inc · Seattle, WABuilt 2025 · S/N 66431 N784AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 37506 N784HAHawaiian Airlines Inc · Seattle, WABuilt 2025 · S/N 66432 N785AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 37507 N785HAAlaska Airlines Inc · Seattle, WAS/N 66469 N786AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 37508 N7874Boeing Co · Renton, WABuilt 2010 · S/N 40693 N787BXBoeing Co · Renton, WABuilt 2010 · S/N 40692 N787WERegistered aircraftS/N 35508 N791AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 37509 N792AVWells Fargo Trust Co Na Trustee · Columbiae City, MDBuilt 2016 · S/N 37510 N793AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 37511 N794AVWells Fargo Trust Co Na Trustee · Columbia, MDFirst renewal noticeBuilt 2017 · S/N 39406 N795AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 39407 N796AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 65315 N798AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 34795 N799AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 34796 N800ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40618 N800AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 36526 N801ACAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40619 N802ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40620 N803ALAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40621 N804ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40622 N805ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40623 N806AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40624 N807AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40625 N808ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40626 N809AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40627 N810ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40628 N81105United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68651 N81107United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68653 N81110United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68656 N81113United Airlines Inc · Chicago, ILBuilt 2026 · S/N 68658 N81116United Airlines Inc · Chicago, ILS/N 68660 N81119Boeing Co · Renton, WAS/N 68678 N811ABAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40629 N812AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 40630 N813ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40631 N814AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40632 N815AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40633 N815AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 60305

Back to AD 2022-03-21