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.

N385TDHomestead Helicopters Inc · Missoula, MTBuilt 1965 · S/N T210-0072N3862PBrown Travis Trustee · Columbia, MOS/N P21000065N3862RToco Inc · Healdsburg, CABuilt 1981 · S/N EA-217N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355N3869SPeterson Kurtley D · Gunnison, UTBuilt 1981 · S/N EA-223N3872W6 Chicks Aviation LLC · Santa Maria, CABuilt 1981 · S/N EA-225N3875GBurnett Ross L · Riggins, IDBuilt 1967 · S/N U206-0875N3885GRichland Aviation Inc · Sidney, MTBuilt 1976 · S/N 340A0220N3886PUncanny Valley Films Inc · Arroyo Seco, NMBuilt 1978 · S/N P21000068N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786N388SPWeber Donald E · Saint David, AZS/N 340-0337N3891GTangent Aviation LLC · Oro Valley, AZBuilt 1967 · S/N U206-0891N3895GMike Kilo Aviation LLC · Garden Ridge, TXBuilt 1967 · S/N U206-0895N389CSSahi Carl R · Coventry, CTBuilt 1985 · S/N 250860N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023N38CMSale Reported · Fay-Aux-LogesSale reportedBuilt 1979 · S/N 340A0901N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N38LPN38lp LLC · Jacksonville, FLBuilt 1977 · S/N 414-0960N38NTYorkavitz James B · Valley City, OHBuilt 1980 · S/N TJ-270N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38PKDeininger Robert · Apopka, FLS/N EA-467N390RSSchoene Edward C · Springfield Center, NYBuilt 1976 · S/N 21061514N3912PRegistered aircraftBuilt 1978 · S/N P21000074N391PT7640 Drilling LLC · Amarillo, TXBuilt 1973 · S/N 21060097N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237N393DW3 Delta Whiskey LLC · Superior, WIBuilt 1979 · S/N U20605261N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203N39501Jw & Jl Aviation LLC · Phoenix, AZBuilt 1982 · S/N U206-06452N3959POmaha Aircraft LLC · Blair, NES/N P21000075N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207N397DJRickenbach Andreas N · Truckee, CABuilt 1967 · S/N U206-0881N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106N3992GFlat Earth LLC · Kalispell, MTS/N U2060992N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995N399CAHoman Mark A · Wake Forest, NCBuilt 1988 · S/N EA-478N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246N39HCTherapy Air LLC · Midland, TXS/N 414-0469N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722
Back to AD 75-09-13