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.

N389SLively Kirk D · Cresson, TXBuilt 1969 · S/N D-9083N38DKCullinan Robert B · Rch Palos Vrd, CABuilt 1965 · S/N D-7899N390HWRojecki Stephen T Trustee · Navarre, FLBuilt 1967 · S/N D-8608N3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093N392SPlocher Corey · Port Orchard, WABuilt 1968 · S/N D-8752N3952ARegistered aircraftBuilt 1969 · S/N D-9090N3957ARegistration Pending · Denton, TXRegistration pendingBuilt 1970 · S/N D-9186N3958AHinton Richard D · Colleyville, TXBuilt 1970 · S/N D-9194N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406N399PTDethomas John V Trustee · Boise, IDBuilt 1968 · S/N D-8727N3BGHildreth James D · Kennedy, ALBuilt 1967 · S/N D-8612N3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N D-9447N3BW4rc LLC · Kenedy, TXBuilt 1976 · S/N D-9870N3DXMchugh Michael J Trustee · Hailey, IDBuilt 1973 · S/N D-9531N3HFHughes Farms Inc · Fayette, MOBuilt 1975 · S/N D-9791N3JWJason Flood · Vineland, NJBuilt 1964 · S/N D-7591N3MDMcdavid James J · Weatherford, TXBuilt 1965 · S/N D-7856N3MYLee Brian E · Peoria, AZBuilt 1974 · S/N D-9661N3SVYoung Karen Sue · Cincinnati, OHBuilt 1967 · S/N D-8426N3XTHammock Jerry G · Waxahachie, TXBuilt 1970 · S/N D-9156N4004APrice Jason R · Lillington, NCBuilt 1970 · S/N D-9098N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4013AGeoghagan Dewayne · Indianapolis, INBuilt 1970 · S/N D-9115N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705N406TLevel Wings LLC · Jefferson City, MOBuilt 1966 · S/N D-8240N406WCCebulski Wade E · Seeley Lake, MTBuilt 1964 · S/N D-7723N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4083A4083a LLC · Wilmington, DES/N D-9110N4084CKrech Gordon L · Rolla, NDBuilt 1979 · S/N D-10184N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343N40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184
Back to AD 75-01-07