Registered aircraft · 16

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140 N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084 N200YClassic Lear Jet Foundation · Wichita, KSS/N 23-003 N23BYYounkin Matthew A · Siloam Springs, ARBuilt 1965 · S/N 23-009 N24SAClark Lloyd E · Hanover, MDS/N 24-117 N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101 N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123 N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104 N473TCTulsa Technology Center School District #18 · Tulsa, OKBuilt 1969 · S/N 043 N477KRegistered aircraftBuilt 1965 · S/N 23036 N564CLDavid Copperfield Project Magic Fund · Las Vegas, NVBuilt 1976 · S/N 25-060 N68LULewis University · Romeoville, ILBuilt 1968 · S/N 163 N711CWPremier Jets Inc · Hillsboro, ORBuilt 1965 · S/N 055 N73CEYanks Air Museum · Baldwin Park, CABuilt 1965 · S/N 23068 N823LJArtemis Aviation Group LLC · Kalispell, MTS/N 23-082A N929JGPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 035

Back to AD 69-15-06