Skip to content

Registered aircraft · 250

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:2001-12-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:2001-12-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:2001-12-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:2001-12-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:2001-12-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:2001-12-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.

N259JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145402 N25VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145131 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 N26549Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145571 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 N290MADodson Parts International Inc · Rantoul, KSS/N 145434 N29917Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145414 N304CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 145326 N376MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145420 N3DEChampion Air LLC · Mooresville, NCBuilt 2002 · S/N 145626 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 N410MADodson Parts International Inc · Rantoul, KSS/N 145313 N438MANewcastle Aviation Partners LLC · Fort Myers, FLS/N 145232 N43VAAdvanced Air LLC · Statesville, NCBuilt 1998 · S/N 145061 N443MANewcastle Aviation Partners LLC · Fort Meyers, FLS/N 145255 N46VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145103 N47VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145110 N48901Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145501 N49VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145.151 N508RHHms Holdings LLC · Charlotte, NCBuilt 2003 · S/N 145769 N509RHHms Holdings LLC · Charlotte, NCBuilt 2001 · S/N 145517 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 N600BPAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145044 N602AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145048 N603KCAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145055 N604AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145058 N605KSAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145059 N606AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145062 N607AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145064 N608JYD Aircraft Leasing Company LLC · Wilmington, DES/N 145231 N608LMAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145068 N609DPAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145069 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 N614AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145086 N615AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145087 N616AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145092 N617AEAmerican Airlines Inc · Fort Worth, TXBuilt 1998 · S/N 145093

Back to AD 2001-12-13