AD 75-01-07

Registered aircraft · 2,118

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-01-07')
    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-01-07')
  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.

N35YRTonini Farm And Cattle Co · San Luis Obispo, CABuilt 1982 · S/N D-10397N360TThroop Greg J · Spokane, WABuilt 1967 · S/N D-8427N3627AHint Mart H · Peachtree City, GABuilt 1969 · S/N D-9079N3629ADarrow Mark A Trustee · Mukilteo, WABuilt 1969 · S/N D-9080N362TBarnett Blake C · Boynton Beach, FLBuilt 1977 · S/N D-10025N3632APauly Adam · Macomb, MIBuilt 1969 · S/N D-9081N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748N363BCBig Cha Inc · Wilmington, DES/N D-9763N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N3676YYesco Administration LLC · Salt Lake City, UTBuilt 1980 · S/N D-10306N3692ABva Bonanza LLC · Keizer, ORBuilt 1969 · S/N D-9091N3693AC And F Enterprise L L C · Milford, MIBuilt 1964 · S/N D-7384N36MZWestfall Thadd W · Three Lakes, WIBuilt 1966 · S/N D-8378N3702QBonander Jeremy Ray · Tucson, AZBuilt 1966 · S/N D-8363N3704QRipley Robert G · Griffin, GABuilt 1966 · S/N D-8365N3705QCourts Data Center Consulting LLC · Lakeway, TXBuilt 1967 · S/N D-8419N3706QSteed George W III · Silverdale, WABuilt 1966 · S/N D-8367N3707QTroutman Shaun · Johnson, KSBuilt 1966 · S/N D-8368N3713QAirborne Adventures LLC · Clive, IABuilt 1966 · S/N D-8370N3715QShellington Justin R · Columbus, NJBuilt 1966 · S/N D-8375N3720QM M & O Aviation Inc · Northglenn, COBuilt 1966 · S/N D-8373N3728AAc Bonanza LLC · Carrollton, TXBuilt 1969 · S/N D-9084N3731QMoore J D · Lawson, MOBuilt 1966 · S/N D-8374N3735BBas Part Sales LLC · Greeley, COBuilt 1982 · S/N D-10403N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394N3762QHarris Randal Glenn · Sedona, AZS/N D-8398N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399N3770QTaylor Zachary S · Shawnee, OKBuilt 1967 · S/N D-8403N3772QBoav8r LLC · Marana, AZBuilt 1967 · S/N D-8405N3781QWelch Michael R · Roanoke, TXBuilt 1967 · S/N D-8417N3785QGo Fly Missoula LLC · Missoula, MTBuilt 1967 · S/N D-8413N3788QSale Reported · Oklahoma City, OKSale reported, canceledBuilt 1967 · S/N D-8410N3789QHercules Jesse T · Memphis, TNS/N D8412N378JRay Preston C · Chula Vista, CABuilt 1967 · S/N D-8421N3793QMartin Tully T · Idalou, TXBuilt 1967 · S/N D-8418N3797QKolb Norman R · Tijeras, NMBuilt 1967 · S/N D-8415N3798QMartin-Fosters Fuel Service Inc · Seminole, OKBuilt 1967 · S/N D-8416N3799QDtb Aviation Inc · Los Gatos, CABuilt 1967 · S/N D-8433N37KBMccraw Michael · Myakka City, FLBuilt 1966 · S/N D-8046N37MKSkyhoundmedia Inc · Royal Oak, MIBuilt 1970 · S/N D-9168N3803MRegistered aircraftBuilt 1980 · S/N D-10357N38065Boyd David · Havasu, AZBuilt 1980 · S/N D-10361N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364N3847XCrowder Jonathan Slade · Columbus, INS/N D-10368N3868URegistered aircraftBuilt 1981 · S/N D-10372N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786N389MCCarstetter Melvin D · Lakebay, WABuilt 1978 · S/N D-10150
Back to AD 75-01-07