Registered aircraft · 17

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

N109HNPrestige Air LLC · Aliso Viejo, CABuilt 2000 · S/N 11087 N274SMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1998 · S/N 11034 N290SFBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1998 · S/N 11022 N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064 N7UCTristate Care Flight LLC · Greenwood Village, COBuilt 2000 · S/N 11088 N806LBBrim Equipment Leasing LLC · Ashland, ORBuilt 1995 · S/N 900-00025 N831LFInhs Leasing Co LLC · Aurora, ORBuilt 1998 · S/N 0073 N883NDDodson International Parts Inc · Rantoul, KSS/N 900-00010 N900MDNevada Aircraft Corp · Henderson, NVS/N 900-00040 N902CHLester E Cox Medical Centers · Springfield, MOBuilt 1996 · S/N 900-00042 N902EAKenai Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 900-00076 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 N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095 N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018 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 2004-17-03