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.

N849AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 145716 N850AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 145722 N852AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 145736 N853AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 145742 N856AEAvi Sales & Leasing Services LLC · Muskegon, MIBuilt 2003 · S/N 145748 N857AEDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145752 N8587HUp Management LLC · Rock Island, ILS/N 14501175 N861BBCorporate Flight Management DBA · Smyrna, TNBuilt 2004 · S/N 14500861 N877SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 145789 N87VAAdvanced Air LLC · Statesville, NCBuilt 2001 · S/N 145430 N882ACBd Advisors LLC · Beaumont, TXBuilt 2004 · S/N 145770 N888ATAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2004 · S/N 14500802 N88MFDmjg Holdings LLC · Wallace, NCBuilt 2010 · S/N 14501117 N89LDMckee Foods Transportation LLC · Collegedale, TNBuilt 2005 · S/N 145648 N900AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500885 N900EMEwm Investments LLC · Las Vegas, NVBuilt 2006 · S/N 14500976 N902BCAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500887 N904FLFlight Options LLC · Cleveland, OHS/N 145780 N905FLCorporate Flight Management Inc DBA · Smyrna, TNS/N 145775 N905JHAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500892 N906AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500894 N907AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500895 N908AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500897 N909AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500899 N909TTTranscon International Inc · Wilmington, DEBuilt 2008 · S/N 14501044 N912JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145527 N913JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145558 N914JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145595 N915JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145603 N916JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145611 N917JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145636 N918AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500902 N918JXDelux Public Charter LLC · Dallas, TXS/N 145598 N919JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145472 N922AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500906 N922JXDelux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145202 N923AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500907 N925AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500908 N926FMRvr Air Charter LLC · Fort Worth, TXBuilt 2001 · S/N 145466 N926JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145455 N928AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500911 N928JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145438 N92VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145149 N931AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500912 N931JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145612 N932AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500915 N932JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145630 N933JNAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500918 N933JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145511 N934JXDelux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145171

Back to AD 2004-25-21