Registered aircraft · 21

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:2006-25-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-25-07') 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:2006-25-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-25-07')
  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:2006-25-07')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-25-07')
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.

N14933Spectre Air Capital LLC · Horseshoe Bay, TXBuilt 1997 · S/N 145018 N15509Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145238 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 N241BCIbc Airways Inc · Fort Lauderdale, FLBuilt 1998 · S/N 145.077 N268JXDelux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145499 N27512Corporate Flight Management Inc · Smyrna, TNBuilt 2000 · S/N 145274 N47VAAdvanced Air LLC · Statesville, NCBuilt 1999 · S/N 145110 N500DEChampion Air LLC · Mooresville, NCBuilt 1998 · S/N 145084 N538MMenards Inc · Eau Claire, WIBuilt 2001 · S/N 145467 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 N81EXExodus Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 145053 N926FMRvr Air Charter LLC · Fort Worth, TXBuilt 2001 · S/N 145466

Back to AD 2006-25-07