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.

N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357N2081WN5724v LLC · Kalispell, MTBuilt 1965 · S/N D-8007N2082WRegistered aircraftBuilt 1965 · S/N D-8008N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908N2090LBarnes Seth M · Hot Springs, ARS/N D-10074N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411N2105LBishop William E · Fredericksburg, TXBuilt 1976 · S/N D-9912N210RMace Steven B · Ocala, FLBuilt 1967 · S/N D-8463N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918N211EEV35a Speedsters LLC · Henderson, COBuilt 1968 · S/N D-8888N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913N212RJBishop Mike · Rifle, COBuilt 1964 · S/N D-7467N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077N213QHardcopf Robert W · Apple Valley, MNBuilt 1965 · S/N D-7929N214DRMarsh David · Flower Mound, TXBuilt 1969 · S/N D-8997N214QHassenger Management Strategies Inc · San Antonio, TXBuilt 1965 · S/N D-7932N214RCWhitcomb David · Morrisville, VTS/N D-7453N215BFWiederhoeft Dustin L · Fairmont, MNBuilt 1964 · S/N D-7665N215QSooter Craig A · Sedgwick, KSS/N D-7600N215YHodgson Mark · Fox Point, WIBuilt 1967 · S/N D-8495N217QLasc Aviation Inc · Callaway, FLBuilt 1964 · S/N D-7680N21914Autumn Air LLC · Prescott, AZBuilt 1977 · S/N D-10078N219QBoe John · Langdon, NDBuilt 1965 · S/N D-7790N21SHFlight Less LLC · Helena, MTBuilt 1986 · S/N D-8423N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940N221ABFlying Banana LLC · Onsted, MIS/N D-9064N221TLLogan Thomas D · Incline Village, NVBuilt 1964 · S/N D-7652N222CBNiki Hankins Consulting LLC · Colorado Springs, COBuilt 1968 · S/N D-8786N222DRGoodknight Gregory W · Nevada City, CABuilt 1967 · S/N D-8604N222DTClipper Sky LLC · Las Vegas, NVS/N D-10130N222SPresley Wilber L · Columbus, OHBuilt 1969 · S/N D-9008N222SMMacknight James G · Morgan Hill, CABuilt 1976 · S/N D-9958N224HPNguyen Cody · Richmond, CABuilt 1965 · S/N D-7806N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152N2255NMalard Darren L · Bismarck, NDBuilt 1974 · S/N D-9580N225SPGross Flying Service Inc · Larned, KSBuilt 1964 · S/N D-7488N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939
Back to AD 75-01-07