AD 75-15-08

Registered aircraft · 10,106

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-15-08')
    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-15-08')
  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.

N10956Flying Toad LLC · Red Oak, TXBuilt 1973 · S/N 15075166N10961Mcphillips Flying Service Inc · Beaver Island, MIS/N 15075171N10971Finley James O · Greenville, TXBuilt 1973 · S/N 15075176N10975Conover William C · Pittsburg, CABuilt 1973 · S/N 15075179N10980Knelson Jan · Lutz, FLS/N 15075184N10992Totm Holdings LLC · Harbor Springs, MIBuilt 1973 · S/N 15075186N10993Bryant Lyle W · Ellinwood, KSS/N 15075187N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160N10EVCafiero Vincent · Haskell, OKBuilt 1955 · S/N D-4186N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636N10GGMartinelli Alexander Joseph · Waco, TXBuilt 1947 · S/N D-1065N10GSMaye Darren Alvaro · Jacksonville, FLBuilt 1964 · S/N 15060587N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306N10RRLeonard Christopher S · Moravia, NYBuilt 1954 · S/N D-3706N1102YSass James Louis Jr · Abilene, TXBuilt 1962 · S/N 15059502N11092Mikulichek Richard L · Silver Lake, MNBuilt 1973 · S/N 15075197N11097Airborne Aviation LLC · Anchorage, AKBuilt 1973 · S/N 15075198N1109YKoller Keith S · Grosse Ile, MIBuilt 1962 · S/N 15059509N110EACenterline Holdings · Camden, DEBuilt 1971 · S/N A1500309N11104Elliott Frank F · Mojave, CAFirst renewal noticeBuilt 1973 · S/N 15075200N1110CGriffith Danny E · Little Rock, ARS/N D-5117N1111YAeronautical Technical Service Inc · Collierville, TNBuilt 1962 · S/N 15059511N1111ZHamburger Ronald O · Terrebonne, ORBuilt 1960 · S/N CD-276N11126Laird Charles L · Adelanto, CABuilt 1973 · S/N 15075209N11128Fletcher Jason · Camden, ARS/N 15075211N11135Wicks Floyd · Laurelville, OHBuilt 1973 · S/N 15075212N11138Wen Su Ephraim · Fullerton, CABuilt 1973 · S/N 15075215N11139Olson Philip D · Garden Plain, KSBuilt 1973 · S/N 15075216N1113YPrecision Design Inc · Weatherford, OKS/N 15059513N11142Galion Air Inc · Galion, OHBuilt 1973 · S/N 15075218N11144Hawkins Larue S · Carrollton, MOBuilt 1973 · S/N 15075220N11145Martin Walter J · Ocala, FLBuilt 1973 · S/N 15075221N11146Williams Ryan C · East Helena, MTBuilt 1973 · S/N 15075222N11149Schmitt Rudy · Brookshire, TXS/N 15075225N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846N1114YThompson Randy L · Anderson, CABuilt 1962 · S/N 15059514N11156Mayer Randal J · Argusville, NDBuilt 1973 · S/N 15075230N11157Patel Rahul G · Austin, TXBuilt 1973 · S/N 15075231N1115YSmith Phillip · Arlington, TXS/N D-4248N11169Cooper Donald L Jr · El Granada, CABuilt 1973 · S/N 15075236N11173Miller William L Jr · Corinth, MSBuilt 1973 · S/N 15075238N11183Stancil James T · Jasper, GAS/N 15075243N11186Round Engine Aero · Nashville, MIS/N 15075245N11196Clark Joseph C · Avondale, PABuilt 1973 · S/N 15075250N111BWKnudsen Kent A · Rosenberg, TXBuilt 1954 · S/N D-3780N111KFrizzell Kim F · Lakeville, MNBuilt 1961 · S/N D6786N111TBNeswest Inc · Los Angeles, CABuilt 1968 · S/N 15069477N111YBVanicek Nicholas Andrew · Whispering Pines, NCBuilt 1962 · S/N D-6962N11204Hudson Daryl J · Redwood Valley, CABuilt 1973 · S/N 15075252N11208Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1973 · S/N 15075255
Back to AD 75-15-08