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.

N445WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29841 N446WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29842 N447WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 33720 N448WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 33721 N449WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32469 N451WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32495 N452WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 29846 N453WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 29847 N454WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 29851 N455WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32462 N456WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32463 N457WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33856 N458WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33857 N459WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32497 N460WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32464 N461WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32465 N462WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32466 N463WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32467 N464WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32468 N465WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33829 N467WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33830 N468WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33858 N469WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33859 N470WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33860 N472WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33831 N473WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33832 N474WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33861 N475WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32474 N476WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32475 N477WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33988 N478USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 30677 N478WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33989 N479WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33990 N480WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33998 N481WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 29853 N482WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 29852 N483WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32472 N485WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32473 N486WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33852 N487WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33854 N488WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33853 N489WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33855 N491WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33867 N494WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33868 N495WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 33869 N497WNSouthwest Airlines Co · Dallas, TXBuilt 2004 · S/N 32479 N498WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32480 N499WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32481 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953 N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022

Back to AD 97-09-02 R2