AD 75-09-08

Registered aircraft · 3,035

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-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-09-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.

N1344WVortex Aviation LLC · Biloxi, MSS/N 2625N1345WHendricks John E · Heber Springs, ARBuilt 1963 · S/N 2626N1346WUnal Alper Cevat · Las Vegas, NVBuilt 1963 · S/N 2627N1351WAllen Mark S · Reno, NVBuilt 1963 · S/N 2632N1355WBloch Matthew William · Marquette, MIS/N 2636N1358WDavis Charles S · Fairfield Bay, ARBuilt 1964 · S/N 2722N1359WKroll Richard · Laguna Niguel, CABuilt 1963 · S/N 2640N135JCNelson Bradley L · Portland, ORBuilt 1967 · S/N 670337N1360WRiggs Aviation LLC · Heath, TXS/N 2641N1364WTriple B Properties Ltd · Aledo, TXS/N 2645N1367WSelover Richard D · Colusa, CABuilt 1963 · S/N 2648N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654N1374WWade Deborah D · Mineral Wells, TXBuilt 1963 · S/N 2655N1375WAndrews Kevin M · Hermitage, TNBuilt 1963 · S/N 2656N1376WMarling Russell Cole · Highlands, NCS/N 2657N1380WOverstreet Jeffrey D · Bentonville, ARBuilt 1964 · S/N 2661N1381WReed Michael S · Sweetwater, OKBuilt 1964 · S/N 2662N1384WTz Aviation LLC · Enterprise, ALBuilt 1964 · S/N 2665N1388WM30c 2666 LLC · Jenks, OKBuilt 1964 · S/N 2666N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675N13MDMoorstein Mark A · Manassas, VABuilt 1967 · S/N 680025N13TMSuntech LLC · St George, UTBuilt 1963 · S/N 115N14038Eagle Aviation And Logistics LLC · Cheyenne, WYS/N 700017N141TTActon Paul W · Blue Mound, KSBuilt 1965 · S/N 591N142EJAskwig Michael C · Lincoln, MIS/N 372N142WHendry James W · Cortez, COS/N 2219N14483Amar John D · Las Vegas, NVBuilt 1976 · S/N 22-1405N147EBMalott David · Glade Park, COBuilt 1975 · S/N 20-1165N14TWAllbid Inc · Opelousas, LAS/N 670148N151DB1 Zero Sierra Whisky LLC · Helena, MTBuilt 1965 · S/N 832N160DPrice Paul L · Lancaster, VABuilt 1966 · S/N 3448N165AZBoyko Flying Services LLC · Ruso, NDBuilt 1964 · S/N 433N167LDRegistered aircraftS/N 670105N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149N16DRHibner Christopher J · Canton, MIBuilt 1964 · S/N 416N175KTTurney Gerald E · Oakland, CABuilt 1962 · S/N 2382N177FDSale Reported · Bowling Green, KYSale reportedBuilt 1967 · S/N 680040N177TCCaram John M · Saint Leonard, MDBuilt 1975 · S/N 221231N17ACPressley Brent DBA · Morristown, TNBuilt 1967 · S/N 670329N17ADOlear Daniel J · Warren, MIBuilt 1968 · S/N 690008N17HTSund Kenneth · Edmonds, WABuilt 1975 · S/N 20-1172N17WJAngel Wings Flyers LLC · Wilson, NCBuilt 1964 · S/N 2881N184JLPeters Bryan · Corpus Christi, TXBuilt 1963 · S/N 129N185DCWood Ronal D Jr · Clarksville, FLS/N 2239N187JWBriley Christopher P · Lynchburg, VABuilt 1970 · S/N 700056N187TATech Air LLC · Lexington Park, MDBuilt 1964 · S/N 2688
Back to AD 75-09-08