AD 75-09-13

Registered aircraft · 4,787

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-13')
    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-13')
  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.

N5793XSchmick Kenneth Richard · Fond Du Lac, WIS/N 320-0093N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564N57CXDmdt Ventures LLC · Victor, NYBuilt 1986 · S/N 46-8608013N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300N57TWBc & Tw Flying Service LLC · Hot Springs, ARBuilt 1982 · S/N EA-288N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343N584MBCenterline Holdings Inc · Camden, DES/N TK-151N5858PMatherne David M · Houma, LAS/N TJ446N5859MJasper County Properties LLC · Jasper, TXBuilt 1972 · S/N 340-0057N5868CShimomura & Co Cpas Pc · New York, NYBuilt 1980 · S/N 340A0977N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058N5878MKodiak Helo LLC · Kodiak, AKBuilt 1972 · S/N 340-0059N587GFReher David P · Arlington, TXBuilt 1975 · S/N 310R0246N587MWHammonds Mark · N Richlnd Hls, TXBuilt 1974 · S/N 421B0587N5889MKinney James R · Vermillion, SDBuilt 1969 · S/N 310P0189N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58JASunergy Solutions LLC · Londonderry, NHBuilt 1975 · S/N 3400521N58JDGrossman Kenneth R · Merced, CABuilt 1977 · S/N TK-19N58JMLucky 7 Operating LLC · Many, LAS/N TK-142N58LGMorgan Farms LLC · Twin Falls, IDBuilt 1981 · S/N TJ-393N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237N58MDLicandro Rudolph · Prospect, KYBuilt 1979 · S/N TJ-248N58PHangar Seven LLC · Penn Yan, NYBuilt 1980 · S/N TJ-303N58PADwt Air LLC · Lakeland, FLBuilt 1981 · S/N TJ-348N58PCGrooms David C · Gallatin, TNBuilt 1977 · S/N TJ-101N58PDFoley Jeffrey William · Scappoose, ORBuilt 1976 · S/N TJ-86N58PECenice LLC · Eagle, COBuilt 1982 · S/N TJ-435N58PRQuinlan John H · Claxton, GABuilt 1978 · S/N TJ-149N58PZMiller Paul David · Dallas, TXBuilt 1981 · S/N TJ-360N58RAGibbs Ron · Parker, AZBuilt 1975 · S/N TJ-14N58TBTaylor Scott · Bg Bnd Ntl Pk, TXS/N TJ-113N58TCN58tc LLC · Gibsonton, FLBuilt 1984 · S/N TJ-455N58TEGtk Services LLC · Carbondale, ILBuilt 1980 · S/N TJ-326N58TFFlying Matters LLC · Cedarburg, WIBuilt 1980 · S/N TJ-292N58TKTwa Partners LLC · Billings, MTBuilt 1979 · S/N TK-107
Back to AD 75-09-13