AD 75-17-16

Registered aircraft · 3,631

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-17-16')
    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-17-16')
  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.

N11MFCroom Aviation LLC · Port Saint Joe, FLBuilt 1972 · S/N 9-72N11XXOconnell John · Custer, SDS/N 245-72N1206EStrassburg Wayne W · Galena, AKFirst renewal noticeS/N 990-77N1217EJohnston Jason · Chugiak, AKS/N 255-77N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N121SGTaliaferro Leigh · Abilene, TXBuilt 2006 · S/N 1036-2007N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272N12208Shepard John A · Thornville, OHBuilt 1972 · S/N 300-72N1223EBatzer Chad M · Pewaukee, WIBuilt 1977 · S/N 325-77N1225WWaak Pamela J · Cleveland, WIBuilt 1998 · S/N 812-98N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005N123BYRegistered aircraftBuilt 2003 · S/N 915-2003N123DAVanderpool Tyler · Edinburg, TXS/N 798-71N123SFKraemer Daniel H F · Albany, ORBuilt 1998 · S/N 415-98N123WAAshem Aviation LLC · Wilmington, DEBuilt 1993 · S/N 726-94N124MCMonteleone Gene R · Mont Vernon, TXBuilt 1979 · S/N 502-79N124RDD'Agostini Robert J · Basking Ridge, NJBuilt 2007 · S/N 1440-2007N124SCK2 Worldwide Inc · Simi Valley, CAS/N 8822001N124SGFull Props LLC · Ridgeland, SCBuilt 2008 · S/N 1071-2008N124WDKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 444-2000N125CMKuester Austin · Oshkosh, WIBuilt 2005 · S/N 1392-2005N125RSAlexander William F · Chapmansboro, TNBuilt 1991 · S/N 657-91N125WB90er LLC · Wilmington, DEBuilt 2008 · S/N 505-2008N1267TTroxel Jeffrey L · Menomonee Falls, WIBuilt 2020 · S/N 1477-2020N126WBFlying Blank LLC · La Crosse, WIBuilt 2005 · S/N 983-2005N127BDRegistered aircraftBuilt 2022 · S/N 620-2022N127SAVintage Tailwheel LLC · Wilmington, DEBuilt 2006 · S/N 1026-2006N127TMPlane Air LLC · Paducah, KYBuilt 2001 · S/N 427-2001N128DMTransnovia LLC · Haslett, MIBuilt 1999 · S/N 1375-99N128SMHafford Jay T · Stevenson, WAS/N 1162-79N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60N12TNEgret Aero Inc · Colorado Springs, COBuilt 2013 · S/N 1127-2013N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75N131DWWeitz David M · Caldwell, IDBuilt 2015 · S/N 569-2015N131GSStanley Gerald L · Littleton, COBuilt 1999 · S/N 839-99N131PMDodge Sean · Littleton, NHS/N 462-2004N131RAFlorida Institute Of Technology · Melbourne, FLBuilt 2003 · S/N 1389-2003N131RCNordman Clay DBA · Catheys Valley, CAFirst renewal noticeBuilt 1996 · S/N 376-96N131SEHouseman Steven · Chillicothe, OHBuilt 2006 · S/N 490-2006N131SGPrewitt Thomas R · Hope Mills, NCBuilt 2002 · S/N 1324-2002N1322XGrecor LLC · Ashville, ALBuilt 2015 · S/N 1163-2015
Back to AD 75-17-16