Skip to content

Registered aircraft · 882

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:2002-02-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:2002-02-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:2002-02-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:2002-02-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:2002-02-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:2002-02-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.

N427WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29831 N428WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29844 N429WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 33658 N431WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 29845 N435WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32455 N436WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32456 N437WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29832 N438USEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1990 · S/N 24560 N438WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29833 N439WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29834 N440LVSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29835 N441WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29837 N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888 N442WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32459 N443WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29838 N444WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29839 N445WNSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 29841 N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046 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 N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051 N451PEPa Msn 1451 LLC · Dallas, TXBuilt 2001 · S/N 01451 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

Back to AD 2002-02-13