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.

N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222N97705Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276223N9770BCastle Michael Bernard · Raleigh, NCS/N 172RG1024N9771TTrevisan Hugo S · Polk City, FLS/N 38-78A0200N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225N9774BWagner Michael D · Winter, WIBuilt 1981 · S/N 172RG1028N9774WAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17264500N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029N9775TDawson John D · Garland, TXBuilt 1978 · S/N 38-78A0203N97766Wiggins Air Patrol LLC · Wichita, KSBuilt 1984 · S/N 17276228N9776YShinn William K · Newburgh, INBuilt 1981 · S/N 21064595N97779Kool Wings Leasing LLC · Indianapolis, INBuilt 1984 · S/N 17276230N9777FStubstad Garrett · New Town, NDBuilt 1981 · S/N 24-1078N97789Delta State University · Cleveland, MSBuilt 1984 · S/N 17276231N9779B79b Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG1031N9779VCoombs Eric S · Louisburg, NCBuilt 1974 · S/N 17264501N977DSPeninsula Flight Services LLC · Bremerton, WABuilt 1976 · S/N 22-1354N977KJFalcon Aviation Inc · Southfield, MIS/N 17261987N977LAGillian Michael Thaddeus · Chicago, ILBuilt 1978 · S/N R18200413N977SDSt Denis Elizbeth A · Fairbanks, AKBuilt 1975 · S/N 156-75N977SQFrech Egon Trustee · Lexington Park, MDBuilt 1979 · S/N 17272303N9780MConstantine Lucas L · Anchorage, AKBuilt 1968 · S/N 680197N97811Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276232N9782MHorstman Edward B · Bigfork, MTBuilt 1968 · S/N 680199N9782VOn Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1974 · S/N 17264502N9783PKent State University · Stow, OHBuilt 1984 · S/N 17276234N9784BRecycleworx LLC · Sun City, AZBuilt 1981 · S/N 172RG1034N9784MWright Earl A · Saginaw, MIBuilt 1968 · S/N 680201N9785BWebber Thomas W · Placerville, CABuilt 1981 · S/N 172RG1035N9786BTri State Airmotive LLC · Berryville, ARS/N 172RG1036N9786LPerun Av LLC · Cliffside Park, NJBuilt 1986 · S/N 17276612N97873Kent State University · Stow, OHBuilt 1984 · S/N 17276236N9787BRiemer Thomas H · Winchester, VABuilt 1981 · S/N 172RG1037N9787MDulin Morgan L · Midland, TXS/N 680204N97883Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276237N9788MHenkel Matthew G · Colorado Springs, COBuilt 1968 · S/N 680196N9789MSmith Norman D · Irving, TXBuilt 1968 · S/N 680205N978BCEvans Jennifer · Bozeman, MTBuilt 2025 · S/N 646-2025N9790GIsaac Gerald B · Spencerport, NYBuilt 1979 · S/N 17273636N9790MMoseley Samuel C · Arlington, TXBuilt 1968 · S/N 680197N97919Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276239N9791BHicks Keith · Sweetwater, TNS/N 172RG1039N9791MThird Row LLC · White Rock, NMS/N 680206N97921Flywell Aviation LLC · Bowling Green, KYS/N 17276240N9792MHall Seth M · Waldoboro, MES/N 680198N9792VHavu Aviation LLC · Irvine, CABuilt 1974 · S/N 17264504N97945Kent State University · Stow, OHBuilt 1984 · S/N 17276241N97947Civil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 17276242
Back to AD 80-25-07 R1