OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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.

N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735N1743VRegistered aircraftBuilt 1974 · S/N 17263736N1746Mclain Mitchell J · Southaven, MSBuilt 1986 · S/N 24-1598N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544N1749VVance Nicholas D · Bluffton, OHS/N 17263737N174DVVosters Gary A · Nevada City, CABuilt 1977 · S/N 177RG1268N174GPLittle Terry J · New Port Richey, FLBuilt 1979 · S/N R18201136N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850N174RAWelke Gregory E · Chippewa Falls, WIBuilt 2005 · S/N 1390-2005N174RCCarsey Rick · Fowler, CAS/N 576-73N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174N174SGMoore Stan · Amarillo, TXBuilt 2008 · S/N 1441-2007N174TBOwen Harold E Jr · Collierville, TNBuilt 2017 · S/N 1173-2017N1751RB&E Flying LLC · Morse Bluff, NEBuilt 1978 · S/N R18200545N1754VAviation Specialist Inc · Apison, TNBuilt 1974 · S/N 17263739N1755RMchugh Charles D · Gilbert, AZBuilt 1978 · S/N R18200547N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739N1757RKemna Barry J · Dallas, TXBuilt 1978 · S/N R18200548N1758VKrickhahn Kermit O · Marion, TXBuilt 1974 · S/N 17263740N1759VFelbaum Jill E · Tecumseh, MIS/N 17263741N175HDEdens Kenneth L · Hot Springs, ARBuilt 1975 · S/N 0708N175KAAir Cruiser LLC · New York, NYBuilt 1973 · S/N 17262117N175KTTurney Gerald E · Oakland, CABuilt 1962 · S/N 2382N175MTMeyer David A · Broomall, PABuilt 1977 · S/N 17702662N175RABrabec Frank F · Indio, CABuilt 2002 · S/N 1332-2002N175RLPerera Nandana L · Logan, OHBuilt 1995 · S/N 761-95N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743N1765RPlane Pro Aviation LLC · Shelby, NCBuilt 1978 · S/N R18200553N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554N1774DDj Brandt LLC · Cedar City, UTS/N 17702028N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284N177AAKnowles Mark A · Gun Barrel City, TXBuilt 1975 · S/N 177RG0765N177AMAdler A Michael · Bend, ORBuilt 1976 · S/N 177RG0941N177APThunderbird Aviation LLC · Littleton, COBuilt 1972 · S/N 177RG0304N177ARHull Jared Gene · Redondo Beach, CABuilt 1975 · S/N 177RG0782N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967N177AVMy Airline LLC · Harrods Creek, KYBuilt 1976 · S/N 177RG0889N177AWFarni Edward C III · Billings, MTBuilt 1970 · S/N 17701516N177BStocks Aviation And Machine Inc · Wilmington, DES/N 17702350N177BAAnderson David J · Saint Johns, FLS/N 17701449
Back to AD 80-25-07 R1