Skip to content

Registered aircraft · 709

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

N850MTBank Of Utah Trustee · Salt Lake City, UTS/N 25159 N8543ZSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 63587 N854DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31965 N8563ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64172 N859AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 32796 N865DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 31976 N870DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31981 N880DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31991 N881DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31992 N882DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31994 N883DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31993 N883VInnovation First Intl Research & Development Inc · Greenville, TXBuilt 2008 · S/N 36852 N885DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31996 N885LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2001 · S/N 32775 N886DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31998 N888TYTy Air Inc · Wilmington, DEBuilt 2000 · S/N 29749 N889DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 62774 N890DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62775 N891DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32001 N893DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32002 N894DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62776 N896DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62777 N897DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32004 N898DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62778 N899DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32005 N900DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62779 N901ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29503 N902ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29504 N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505 N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509 N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510 N909ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29511 N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513 N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514 N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515 N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516 N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517 N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518 N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519 N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522 N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523 N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524 N923TRCareer Aviation Co Inc · Wilmington, DES/N 28923

Back to AD 97-09-02 R2