Skip to content

Registered aircraft · 383

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:2015-02-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:2015-02-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:2015-02-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:2015-02-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:2015-02-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:2015-02-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.

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 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 N262JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145533 N263JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145399 N264JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145264 N26549Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145571 N266JXDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145726 N268JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145499 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

Back to AD 2015-02-13