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.

N645AEAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 145212 N645PMPag Management LLC · White Plains, NYBuilt 2006 · S/N 14500974 N646AEAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 145213 N647AEAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 145222 N648AEAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 145225 N649PPAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 145234 N650AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145417 N650JFWasatch Aviation Group Six LLC · Sandy, UTBuilt 2015 · S/N 14501215 N650LYValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 14500825 N650MLValiair Lc Trustee · Casper, WYS/N 14500967 N650RJTvpx Aircraft Solutions Inc Trustee · Salt Lake City, UTBuilt 2013 · S/N 14501174 N650TBBorland Caryn H Trustee · Prescott, AZBuilt 2017 · S/N 14501204 N651AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145422 N652RSAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145432 N653AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145433 N654AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145437 N655AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 145452 N656AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145740 N657AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145744 N658AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145760 N659AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145762 N660CLAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145764 N661ECPalu Aviation LLC · Oklahoma City, OKBuilt 2007 · S/N 14501001 N661JAAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145766 N661JMSas Aviation Holdings LLC · Scottsdale, AZBuilt 2003 · S/N 145730 N662EHAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145777 N663ARAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145778 N664MSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145779 N665BCAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145783 N667GBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145784 N668HHAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145785 N669MBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145788 N670AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145790 N671AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145793 N672AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145794 N673AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145797 N675AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500806 N676AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500807 N677AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500810 N678AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500813 N679AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500814 N67VAAdvanced Air LLC · Statesville, NCBuilt 2000 · S/N 145354 N680AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500820 N681AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500824 N682AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500826 N683AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500833 N684JWAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500835 N685AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500836 N686AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500843 N687JSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500846

Back to AD 2004-25-21