Skip to content

Registered aircraft · 250

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:2001-12-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:2001-12-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:2001-12-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:2001-12-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:2001-12-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:2001-12-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.

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 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 N959JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145465 N960JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145479 N961JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145605 N962JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145618 N963JXDelux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145633 N970DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500837 N971DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500821 N972DCCbg LLC · Wilsonville, ORBuilt 2004 · S/N 14500812 N973DCCbg LLC · Wilsonville, ORBuilt 2001 · S/N 145393 N976DCCbg LLC · Englewood, COBuilt 2001 · S/N 145514 N977DCCbg LLC · Englewood, COBuilt 2001 · S/N 145370

Back to AD 2001-12-13