Registered aircraft · 24

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

N11ETGeygan Thomas J · Cincinnati, OHBuilt 1970 · S/N EJ9-13-23T N187PSMorrissey John C Col · Lees Summit, MOBuilt 1979 · S/N 2187 N19HCVista I Inc · Smithville, OHBuilt 1982 · S/N 2266 N262PDGritter Richard J · Catlett, VABuilt 1991 · S/N 01 N2788Tippit Larry Jack · Grand Prairie, TXBuilt 1970 · S/N 30P N28PBIpme Management Corp · Jefferson, GABuilt 1974 · S/N 2069 N29KTManary Norman L · Rialto, CAS/N 2082 N2JDHauf Daniel Ray · Jack, ALS/N JM-1 N31PMEverything Pitts LLC · Queen Creek, AZBuilt 1976 · S/N 1-0040 N35PJKucel R Scott · Dallas, TXS/N 1-0048 N41ACPitts Flying Club Of Stoughton · Stoughton, WIBuilt 1979 · S/N 321G N427ZRCampbell Glen R · Phoenix, AZS/N 17P N450GMMyers Shawn Lee · Rincon, GAS/N 2201 N466YYSmith Brent A · Macomb, ILBuilt 1975 · S/N 20P N49BROlmsted Aviation LLC · Santa Paula, CAS/N 2212 N51STCnc Aerobatics LLC · Ada, MIBuilt 1981 · S/N 2253 N56KLAircraft Partner Holdings Inc Trustee · BerlinS/N 100 N6WChase Roy M · Limington, MEBuilt 1970 · S/N 29P N714HRegistered aircraftS/N 15P N719APPeros Dino · Pipersville, PABuilt 1981 · S/N 2245 N73CFFredette Catherine · Beaverton, ORS/N 2215 N8671Plane Fun Inc Tr Trustee · Snellville, GAS/N 25P N88WSChamberlain Donald R · Simsbury, CTBuilt 1974 · S/N 1 N922PBillester Stephen E M · Parker, COBuilt 1974 · S/N 271H

Back to AD 76-16-08