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.

N340FJBurris D Rob Trustee · Tucson, AZBuilt 1976 · S/N 340A0060N340FKMichelesaire Inc · Wilmington, DEBuilt 1980 · S/N 340A1007N340FMVogel Mark E · Orange City, IABuilt 1980 · S/N 340A1032N340FRS&S Sky LLC · Thatcher, AZBuilt 1976 · S/N 340A0039N340GDurango Air LLC · Portland, ORBuilt 1980 · S/N 340A1006N340GBMbw Aviation LLC · Bay City, MIS/N 340A0618N340GCShupe David L · Dayton, NVS/N 340A-0369N340GGMarlowe Clifford Gray · Maxwelton, WVBuilt 1979 · S/N 340A0916N340GKRiv Desert Sun LLC · Phoenix, AZBuilt 1979 · S/N 340A0625N340GSRelevance Capital Management LLC · Brentwood, TNBuilt 1972 · S/N 340-0183N340GWThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1979 · S/N 340A0706N340HESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 340A1503N340HWHartung Stefan · Greenville, SCBuilt 1976 · S/N 340A0265N340JOkla-Tex Energy Corp · Tyler, TXS/N 340-0171N340JDWescott Aviation LLC · Prospect, KYBuilt 1972 · S/N 340-0100N340JMHunter Pilot Services LLC · Hollister, CABuilt 1978 · S/N 340A0640N340JPOlive Aviation LLC · Anchorage, AKBuilt 1973 · S/N 3400232N340KRegistered aircraftBuilt 1979 · S/N 340A0792N340KCRegistered aircraftBuilt 1980 · S/N 340A0959N340KGAero Vulcan LLC · Moody, ALBuilt 1982 · S/N 340A1505N340KSDavieation III LLC · St Simons Is, GABuilt 1981 · S/N 340A1501N340KTN44fu LLC · Oklahoma City, OKBuilt 1977 · S/N 340A0356N340KYE Lite Aviation Inc · Cordova, TNFirst renewal noticeBuilt 1978 · S/N 340A0622N340L310 Air Ltd · Seville, OHBuilt 1978 · S/N 340A0518N340LBSteed Dan E Trustee · Groom, TXBuilt 1972 · S/N 340-0053N340LHAviation Limited Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 340A0409N340LLFrank Leasing LLC · Scottsbluff, NES/N 340A1228N340LMCrawford William K · Indianapolis, INBuilt 1978 · S/N 340A0478N340LQDownwind Flight LLC · San Antonio, TXBuilt 1976 · S/N 340A0020N340LZWestern Radiation Oncology Assoc Pc · Great Falls, MTFirst renewal noticeBuilt 1975 · S/N 340-0537N340MBRecon Real Estate Consultants Inc · El Paso, TXBuilt 1982 · S/N 340A1508N340ME58gp Wing LLC · Wilmington, DEBuilt 1978 · S/N 340A0550N340MFMerrill Farms · Corral De Tierra, CABuilt 1982 · S/N 340A1542N340MGN340mg LLC · Highlands Ranch, COS/N 340A0769N340MHFlying High Llp · Williston, NDBuilt 1981 · S/N 340A-1214N340MJAll-Star Executive Aviation Inc · Pomona, CABuilt 1993 · S/N 340A1521N340MKMilbern Aircraft Corporation · Brooklyn, NYBuilt 1982 · S/N 340A1541N340MLD & L Airlines LLC · West Chester, OHBuilt 1979 · S/N 340A0729N340MSSprings1781 LLC · Colorado Springs, COBuilt 1979 · S/N 340A0760N340NN-Number Inc · Santa Fe, NMBuilt 1982 · S/N 340A1540N340NGCentral Virginia Aviation Inc · Petersburg, VAS/N 340-0042N340PCDouble J Aviation LLC · Burlington, WIBuilt 1979 · S/N 340A0962N340PFSharon Leasing Co · Ludington, MIBuilt 1977 · S/N 340A0225N340PJPremier Jets Inc · Hillsboro, ORBuilt 1975 · S/N 340-0539N340PLSummit Aircraft Sales LLC · Akron, OHS/N 340-0546N340PPRegistered aircraftBuilt 1979 · S/N 340A0747N340PTMach Air LLC · Townsend, GABuilt 1972 · S/N 340-0014N340RBCorcoran Kim C Trustee · Burrton, KSBuilt 1978 · S/N 340A0498N340RDDeaton Courtney · London, KYS/N 340-0019N340RFN340rf LLC · Denver, COBuilt 1976 · S/N 340A0212
Back to AD 75-09-13