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.

N405KCS H S Corporation · Indianola, IABuilt 1984 · S/N 46-8408044N406BKN406bk LLC · Nantucket, MABuilt 1984 · S/N 402C0807N406GAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0329N406RCIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 402C0470N4070LDesert Air LLC · Hagerman, NMBuilt 1968 · S/N 421-0070N4074LEminent Technology · Tallahassee, FLBuilt 1968 · S/N 421-0074N4078QGerker Carl J · Palmdale, CAS/N 320C0046N4079CCalled To Care Residential Facility LLC · Avondale, AZBuilt 1978 · S/N 310R1364N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241N40PGFunanich Jon J Trustee · Fairfield, CABuilt 1980 · S/N TJ-309N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576N41085421 Bravo LLC · Marine City, MIS/N 421B0440N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184N411JGKern County Aviation Leasing LLC · Bakersfield, CABuilt 1986 · S/N EA-461N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099N411TBLewis Nathan · North Plains, ORS/N 421B0481N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482N4123TRace Dean · Chicken, AKBuilt 1966 · S/N 320D0023N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N412CAAirswiss Inc · Wilmington, DES/N 402C0005
Back to AD 75-09-13