OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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

N3KBJobe Dwaine B · Chilhowee, MOBuilt 1967 · S/N 28-3872N3NLBaez Rafael · Stafford, VABuilt 1964 · S/N 28-1826N400FLSouthard Joseph P · Greer, SCBuilt 1971 · S/N 28-7125174N400JCRegistered aircraftBuilt 1965 · S/N 28-2121N400JWAirfleet Holdings LLC · Beverly Hills, CABuilt 1974 · S/N 28-7405276N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N4024JKeleti Laurie · Lakewood, NJBuilt 1975 · S/N 28-7525271N4035RMoreau Donald G · Dayton, TXBuilt 1970 · S/N 28-5796N4036RN4036r LLC · Quinton, ALBuilt 1970 · S/N 28-5663N404UXSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28-5423N405ASJagadeesh Akhil V · Chicago, ILBuilt 1972 · S/N 28-7205263N405FLRiggin Flight Service Inc · Madison, SDBuilt 1971 · S/N 28-7125181N406AFN406af LLC · Fort Pierce, FLBuilt 1966 · S/N 28-21837N40704Dikun Paul M · Bensalem, PABuilt 1973 · S/N 28-7425147N40718Datchair LLC · Chattanooga, TNBuilt 1973 · S/N 28-7425150N40735Magsig Joel S · Huntsville, ALBuilt 1973 · S/N 28-7425152N40740Veit John · Port Jefferson, NYBuilt 1973 · S/N 28-7405062N40752Jourdan Frank E · Overland Park, KSBuilt 1973 · S/N 28-7425155N40767Bart Steven C · Highland, CABuilt 1973 · S/N 28-7405064N40776Third Coast Aircraft LLC · Mobile, ALBuilt 1973 · S/N 28-7425163N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176N4083QStroemsvik Kristian · Strasburg, VAS/N 28-7725235N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178N40856Griggs Gerald A · Blairsville, GABuilt 1973 · S/N 28-7425180N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184N40881Hsu Feng · Albuquerque, NMS/N 28-7425185N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193N40972Terry Aaron D · Glendale, AZS/N 28-7425196N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199N40993Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405159N409AFThomas Douglas M Jr · Blue Bell, PABuilt 1966 · S/N 28-21915N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4108JMetoyer Eric D · Yukon, OKBuilt 1966 · S/N 28-22421N410SFKoehler Gregory S · Burlington, NCBuilt 1965 · S/N 28-21000N41108Winney Andrew J · Gothenburg, NES/N 28-7505195N4111JWarmuth Richard J · West Harrison, INBuilt 1966 · S/N 28-22426N4113JParnell Jerry L Jr · Panama City, FLBuilt 1966 · S/N 28-22429N4114JCrader Air LLC · Jackson, MOBuilt 1966 · S/N 28-22430
Back to AD 96-10-01 R1