Skip to content

Registered aircraft · 1,327

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:2001-26-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:2001-26-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:2001-26-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:2001-26-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:2001-26-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:2001-26-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.

N872UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1986 N873UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 2004 N874UAUmb Bank Na Trustee · Salt Lake City, UTS/N 2008 N875UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2200 N876UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2203 N877UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 2232 N878UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2371 N879UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2408 N880UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2426 N881UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2435 N882UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2505 N883UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2574 N884UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2579 N889UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2667 N890UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2815 N891UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2901 N892UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2940 N893UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2948 N894UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2969 N895UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3020 N896UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3144 N897UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3269 N898UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3311 N899UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3342 N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617 N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636 N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519 N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566 N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909 N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255 N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387 N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420 N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427 N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443 N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479 N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490 N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523

Back to AD 2001-26-21