Skip to content

Registered aircraft · 431

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:2005-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-23-13') 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:2005-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-23-13')
  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:2005-23-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-23-13')
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.

N10156United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145786 N1023CAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2001 · S/N 145550 N106ECAurogold Aviation Inc Trustee · Wilmington, DEBuilt 2009 · S/N 14501106 N10HCKba LLC · Dover, DEBuilt 2008 · S/N 14501080 N11106United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145650 N11107United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145654 N11113United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145662 N11119United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145677 N11121United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145683 N11127United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145697 N11140United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145732 N11150United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145756 N11164United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500817 N11165United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500819 N11176United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500881 N11181United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500904 N11184United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500917 N11187United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500927 N11189United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500931 N11191United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500935 N11192United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500936 N11193United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500938 N11194United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500940 N11199United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500953 N11526Corporate Flight Managment Inc · Smyrna, TNBuilt 2001 · S/N 145410 N11535Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145518 N11536Bank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145520 N11539Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145536 N11565Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145621 N12122Untied Airlines Inc · Chicago, ILBuilt 2003 · S/N 145684 N12126Avtran LLC · Clayton, MOBuilt 2003 · S/N 145693 N12135United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145718 N12136United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145719 N12142United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145735 N12145United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145745 N12157United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145787 N12160United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145799 N12163United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500811 N12166Delux Public Charter LLC · Dallas, TXBuilt 2004 · S/N 14500831 N12167United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500834 N12172United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500864 N12175United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500878 N12195United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500943 N12201United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500959 N12540Dulux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145537 N12552Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145583 N13123Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145688 N13124United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145689 N13132United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145708 N13133United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145712

Back to AD 2005-23-13