OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N944DHSouth Delta Aviation Inc · West Helena, ARBuilt 1981 · S/N P21000712N944RRancifer Rodney M · Lithonia, GABuilt 1970 · S/N 17258933N944TLAims Community College · Loveland, COBuilt 2019 · S/N 1180-2018N94500Training Planes LLC · Tampa, FLBuilt 1983 · S/N 15285692N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702N9451TRegistration Pending · Austin, TXRegistration pendingBuilt 1978 · S/N 38-78A0104N94528Daedalus Flight School Inc · P. FokaiaS/N 15285705N9452EDew Jason L · Krum, TXBuilt 1979 · S/N 17272268N9452HFreeland Thomas W · Early, TXBuilt 1975 · S/N 17266162N9452VFriesen Dwayne Phillip · Overton, TXBuilt 1970 · S/N 700052N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707N9453VNavflight Inc · Fort Worth, TXBuilt 1969 · S/N 700001N94553Delta State University · Cleveland, MSBuilt 1983 · S/N 15285718N94569Chester Charter Inc · Chester, CTBuilt 1983 · S/N 15285731N9456DMajka Marc · San Carlos, CABuilt 1984 · S/N 172RG1171N9456VSnover Darryl A · Cherryville, PABuilt 1970 · S/N 700037N94570Richmor Aviation Inc · Hudson, NYBuilt 1983 · S/N 15285732N94573Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 15285735N94577Ace Aircraft Leasing Inc · Nazareth, PABuilt 1983 · S/N 15285736N9457DN1705r Inc · Cobb, CAS/N 172RG1172N94584Sale Reported · West Lafayette, INSale reportedBuilt 1983 · S/N 15285738N94585Aviation Trade Inc · Castroville, TXBuilt 1983 · S/N 15285739N94589Haverlock Aircraft LLC · Willoughby, OHBuilt 1983 · S/N 15285740N9459TAdventures In The Sky Aviation LLC · Fresno, CABuilt 1978 · S/N 38-78A0105N945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1980 · S/N R18201484N945KMSkypros East Kansas City · Grain Valley, MOBuilt 1977 · S/N 15280816N945RCR&C Aviation Partners LLC · Tucson, AZBuilt 1978 · S/N P21000084N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742N945TC R Transport Inc · Wilmington, DES/N 17265082N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742N9460VDodie Aviation LLC · Sheridan, WYBuilt 1970 · S/N 700038N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461VZembraski Jeffrey · Nocona, TXBuilt 1970 · S/N 700056N94626New Horizons Aviation Inc · Goshen, INS/N 15285747N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463VHatcher Mark F · Aloha, ORBuilt 1970 · S/N 700057N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176N9465YWof Investments LLC · Dover, DES/N 21064515N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272N9467Allen Lanny Dean · Indianapolis, INBuilt 1970 · S/N 700036N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169
Back to AD 80-25-07 R1