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.

N16501Corporate Flight Management Inc · Smyrna, TNBuilt 1999 · S/N 145145 N16502Corporate Flight Management Inc · Smyrna, TNBuilt 1999 · S/N 145166 N16510Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145251 N16511Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145267 N16525Corporate Flight Management DBA · Smyrna, TNBuilt 2001 · S/N 145403 N16541Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145542 N16981Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145208 N16987Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145261 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 N17513Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145292 N17984Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145246 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 N215MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145580 N224LDCloud Enterprise Holdings LLC · Roslyn Heights, NYFirst renewal noticeBuilt 2006 · S/N 14500971 N23139United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145731 N234BZRvr Air Charter LLC · Fort Worth, TXBuilt 2001 · S/N 145388 N24103United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145645 N24128United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145700 N241BCIbc Airways Inc · Fort Lauderdale, FLBuilt 1998 · S/N 145.077 N241JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145391 N242JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145304 N243JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145345 N244JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145331 N245JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145355 N246JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145443 N247JXDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145763 N25134Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145714 N251JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145235 N252JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145276 N253JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145328 N254JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145275 N256JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145211 N257JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145314 N258JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145386 N259JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145402 N25VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145131 N260JXDelux Public Charter LLC · Dallas, TXS/N 145504 N26141United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145733 N261JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145512

Back to AD 2004-25-21