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.

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 N661JAAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 145766 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 N688AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500849 N689ECAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500853 N690AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500858 N691AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500860 N692AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500866 N693AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500868 N694AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500869 N695AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500870 N696AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500874 N697ABAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500875 N697EEEmbraer Executive Aircraft Inc · Melbourne, FLS/N 145-1197 N698CBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500877 N699AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500883 N70VAAdvanced Air LLC · Statesville, NCBuilt 2001 · S/N 145397 N825HKBank Of Utah Trustee · Salt Lake City, UTS/N 145510 N832HKCbg LLC · Wilsonville, ORBuilt 2003 · S/N 145771 N835HKCbg LLC · Wilsonville, ORBuilt 2003 · S/N 145670 N842HKAerovision Aircraft Services LLC · Muskegon, MIBuilt 2004 · S/N 14500830

Back to AD 2000-07-01