OpenAirDocs.org
AD 75-09-08

Registered aircraft · 3,035

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
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:75-09-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:75-09-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.

N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035N10ADTeerlink Randall S · Hanover, VABuilt 1976 · S/N 20-1221N10CHGulf Coast Rail Service Inc · Victoria, TXBuilt 1969 · S/N 690048N10HVRegistered aircraftBuilt 1965 · S/N 715N111MJJohn D Chinchen Md Pa · Mountain Home, ARBuilt 1968 · S/N 680147N112PHRegistered aircraftBuilt 1967 · S/N 670466N1133XBristol Aircraft Leasing LLC · Willoughby, OHBuilt 1967 · S/N 670504N117RWAli Mohammad Usman · Fort Worth, TXBuilt 1962 · S/N 2014N118RCAscent Aviation LLC · Lander, WYBuilt 1966 · S/N 670036N119LMRegistered aircraftBuilt 1971 · S/N 22-0001N11RYMsk Air Transport LLC · Mankato, MNBuilt 1965 · S/N 3173N1200XLacola Joseph D · Commerce Township, MIBuilt 1963 · S/N 103N1201XSimmons Herbert H Trustee · Pasadena, CABuilt 1963 · S/N 2604N1202XBrady Creative Services LLC · Forsyth, MOBuilt 1963 · S/N 2605N1203XMcelwain Russell D · Lancaster, KSBuilt 1963 · S/N 2606N1204XMcdonald Monroe · Aguila, AZBuilt 1963 · S/N 2607N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183N1206XNlw 1 LLC · Washington, UTS/N 184N1208XCartaya Lazaro C · Miami, FLBuilt 1963 · S/N 2611N1210XDowdy Joseph N · Blacksburg, VABuilt 1963 · S/N 185N1212XLogsdon Dale L · Alva, OKBuilt 1963 · S/N 2615N1214XCouch Troy L · Westcliffe, COBuilt 1963 · S/N 2617N1215XCella Joseph · Sewell, NJBuilt 1963 · S/N 2618N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187N1218XSmith II Richard D · Luthersville, GABuilt 1963 · S/N 2621N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191N1223XAirspeed Consulting LLC · Mounds, OKBuilt 1963 · S/N 194N1224XAlpha Aviation Mission Outreach Center Inc · Muskogee, OKBuilt 1963 · S/N 195N1225XSuda Inc · Lindsborg, KSBuilt 1963 · S/N 196N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099N1232WMilam David N · Hannibal, MOBuilt 1967 · S/N 670088N1234KLatiolais Travis · Breaux Bridge, LABuilt 1966 · S/N 995N1235XRudy Alan J · Phoenix, NYBuilt 1963 · S/N 108N1236XFull Mooney LLC · Camden, DES/N 109N1238XAljo Aircraft Corp · Arroyo Grande, CAS/N 111N1239XAircraft Ownership Solutions LLC · Kokomo, INS/N 112N123FAGlas Robert Sean · Lompoc, CABuilt 1966 · S/N 1204N123FKSchumacher Perry W · Clearwater, FLBuilt 1965 · S/N 3003N123PGFinlayson William S · Annapolis, MDBuilt 1965 · S/N 3154N1240XPioneer Aviation LLC · Boise, IDBuilt 1963 · S/N 113N1242XCarpenter Charles P · Tarzana, CAS/N 115N1244XLackey Lance Harold · New Braunfels, TXBuilt 1963 · S/N 117
Back to AD 75-09-08