Skip to content

Registered aircraft · 75

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:2016-25-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:2016-25-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:2016-25-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:2016-25-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:2016-25-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:2016-25-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.

N20904United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34824 N26902United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34822 N26906United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34829 N26909United Airlines Inc · Chicago, ILBuilt 2014 · S/N 34827 N26910United Airlines Inc · Chicago, ILBuilt 2014 · S/N 34826 N27901United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34821 N27903United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34823 N27908United Airlines Inc · Chicago, ILBuilt 2013 · S/N 36400 N28912United Airlines Inc · Chicago, ILBuilt 2014 · S/N 34828 N29907United Airlines Inc · Chicago, ILBuilt 2013 · S/N 34830 N30913United Airlines Inc · Chicago, ILBuilt 2014 · S/N 35879 N45905United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34825 N780AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 37502 N781AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 37503 N782AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 37165 N782AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37504 N783AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 37167 N783AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37505 N784AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 37506 N785AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 37507 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, MDBuilt 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 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 N816AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 40634

Back to AD 2016-25-21