Skip to content

Registered aircraft · 146

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:2004-09-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:2004-09-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:2004-09-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:2004-09-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:2004-09-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:2004-09-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.

N14125United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145690 N14143United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145739 N14148United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145751 N14153United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145761 N14158United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145791 N14162United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500808 N14168United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500840 N14173United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500872 N14174United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500876 N14177United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500888 N14179United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500896 N14180United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500900 N14186United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500924 N14188United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500929 N14198United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500951 N14203United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500964 N14204United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500968 N145DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501045 N157MGValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 14500999 N16147United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145749 N16149United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145753 N16151United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145758 N16170United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500850 N16178United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500889 N16183United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500914 N17138United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145727 N17146United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145746 N17159United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145792 N17169United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500844 N17185United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500922 N17196United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500945 N18114Enterprise Aircraft Finance LLC · Clayton, MOBuilt 2002 · S/N 145664 N18120Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145681 N21129United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145703 N21130Avtran LLC · Clayton, MOBuilt 2003 · S/N 145704 N21144United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145741 N21154United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145772 N21197United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500947 N224LDCloud Enterprise Holdings LLC · Roslyn Heights, NYFirst renewal noticeBuilt 2006 · S/N 14500971 N23139United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145731 N24103United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145645 N24128United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145700 N25134Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145714 N26141United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145733 N27152United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145759 N27190United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500934 N271BCIbc Airways Inc · Fort Lauderdale, FLBuilt 2002 · S/N 145660 N27200United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500956 N284CPConocophillips Co · Houston, TXBuilt 2013 · S/N 14501178 N291BCIbc Airways Inc · Fort Lauderdale, FLBuilt 2004 · S/N 145782

Back to AD 2004-09-13