Skip to content

Registered aircraft · 211

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:2000-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-01') 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:2000-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-01')
  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:2000-07-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-01')
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.

N861BBCorporate Flight Management DBA · Smyrna, TNBuilt 2004 · S/N 14500861 N87VAAdvanced Air LLC · Statesville, NCBuilt 2001 · S/N 145430 N900AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500885 N902BCAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500887 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 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 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 N935AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500920 N935JXDelux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145175 N937JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145254 N939AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500923 N940JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145295 N941LTAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500926 N942LLAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500930 N947JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145610 N948JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145638 N949JXDelux Public Charter LLC · Dallas, TXS/N 145639 N950JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145640 N952JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145476 N954JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145632 N955JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145496 N956JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145459 N957JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145278 N958JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145289

Back to AD 2000-07-01