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

N13161United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500805 N13202United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500962 N135SCBallator Equipment Leasing LLC · Beech Mountain, NCBuilt 2006 · S/N 14500972 N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706 N135SKZed Aerocapital LLC · Dover, DEBuilt 2007 · S/N 14500989 N135SLZed Aerocapital LLC · Dover, DEBuilt 2003 · S/N 145711 N135SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 145728 N138DEChampion Air LLC · Mooresville, NCS/N 145129 N13975Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145163 N13978Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145180 N13979Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145181 N13988Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145265 N13989Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145271 N13992Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145284 N14105Delux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145649 N14116United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145672 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 N14542Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145547 N145DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 14501045 N14904Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145477 N14916Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145415 N14933Spectre Air Capital LLC · Horseshoe Bay, TXBuilt 1997 · S/N 145018 N15509Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145238 N15527Corporate Flight Management Inc · Smyrna, TNBuilt 2001 · S/N 145413 N157MGValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 14500999 N15912Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145439 N15983Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145239 N15VAAdvanced Air LLC · Statesville, NCBuilt 1998 · S/N 145072 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

Back to AD 2004-25-21