Skip to content

Registered aircraft · 77

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

N1023CAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2001 · S/N 145550 N11526Corporate Flight Managment Inc · Smyrna, TNBuilt 2001 · S/N 145410 N135SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 145728 N15509Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145238 N15527Corporate Flight Management Inc · Smyrna, TNBuilt 2001 · S/N 145413 N16501Corporate Flight Management Inc · Smyrna, TNBuilt 1999 · S/N 145145 N16502Corporate Flight Management Inc · Smyrna, TNBuilt 1999 · S/N 145166 N16510Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145251 N16511Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145267 N16525Corporate Flight Management DBA · Smyrna, TNBuilt 2001 · S/N 145403 N17513Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145292 N234BZRvr Air Charter LLC · Fort Worth, TXBuilt 2001 · S/N 145388 N251JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145235 N252JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145276 N253JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145328 N254JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145275 N256JXBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145211 N257JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145314 N258JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145386 N259JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145402 N260JXDelux Public Charter LLC · Dallas, TXS/N 145504 N261JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145512 N262JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145533 N263JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145399 N264JXDelux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145264 N266JXDelux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145726 N268JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145499 N27512Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145274 N304CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145326 N402ATAero Technologies Inc · Van Nuys, CABuilt 2003 · S/N 145702 N403RWRvr Air Charter LLC · Ft Worth, TXBuilt 2000 · S/N 145262 N404ATAero Aircraft Holdings LLC · Van Nuys, CABuilt 2003 · S/N 145715 N47VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145110 N509GUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 145535 N530CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145425 N531CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145469 N532CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145519 N534CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145531 N535CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145489 N538MMenards Inc · Eau Claire, WIBuilt 2001 · S/N 145467 N540MMenard Inc · Eau Claire, WIBuilt 2006 · S/N 14500977 N548MGa-Erj135 LLC · Seiling, OKBuilt 2000 · S/N 145364 N607AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145064 N610AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145073 N611AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145074 N612AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145079 N613AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145081 N697EEEmbraer Executive Aircraft Inc · Melbourne, FLS/N 145-1197 N704PGBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 145174 N712AEAero Aircraft Holdings LLC · Van Nuys, CAS/N 145247

Back to AD 2002-08-21