Registered aircraft · 20

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

N353KKAerospace Trust Management LLC Owner Trustee · Wilmington, DES/N 900-00073 N368PAPapillon Airways Inc · Boulder City, NVBuilt 1994 · S/N 900-00012 N451CJTurbines Ltd · West Point, NES/N 900-00077 N70431Aertrust Services Corp Trustee · Wilmington, DES/N 900-00069 N806LBBrim Equipment Leasing LLC · Ashland, ORBuilt 1995 · S/N 900-00025 N881LTArk Angels LLC · Austin, TXBuilt 2006 · S/N 900-00117 N883NDDodson International Parts Inc · Rantoul, KSS/N 900-00010 N900MDNevada Aircraft Corp · Henderson, NVS/N 900-00040 N900MHBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 900-00008 N902CHLester E Cox Medical Centers · Springfield, MOBuilt 1996 · S/N 900-00042 N902EAKenai Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 900-00076 N902GBGremlin Air Inc Trustee · Wilmington, DEBuilt 2001 · S/N 900-00089 N902GGHawcs International · Camarillo, CANon-citizen corporation, flight hours not reportedBuilt 1995 · S/N 900-00023 N902JSApex Heli-Support LLC · Phoenix, AZBuilt 2000 · S/N 900-00072 N902LCLester E Cox Medical Centers · Springfield, MOBuilt 2007 · S/N 900-00118 N902TXBurl & Bob Aircraft Leasing LLC · Ashland, ORBuilt 2001 · S/N 900-00092 N904AFLeopard Aviation LLC · Ashland, ORBuilt 2001 · S/N 900-00101 N912LHBrim Equipment Leasing LLC · Ashland, ORBuilt 2001 · S/N 900-00095 N922SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1995 · S/N 900-00022 N931SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1996 · S/N 900-00031

Back to AD 2002-15-07