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.

N9622MRegistered aircraftBuilt 1966 · S/N 670199N9622QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265707N9623GBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802596TN9623MHerb Adam W · Phoenix, AZBuilt 1966 · S/N 670200N9623VSchreder Peter T · Joseph, ORS/N 17264403N9625MGreen Evan Michael · Midland, TXBuilt 1966 · S/N 670202N9625QMars Aerospace Inc · Bay Shore, NYBuilt 1975 · S/N 17265709N9625SYoung Robert A Jr · Cass, WVBuilt 1966 · S/N 57N9625VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 17264405N9626BAirgo Inc · Centralia, ILBuilt 1981 · S/N 172RG0927N9626HRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 17266274N9626QChambers Matthew A · Tehachapi, CABuilt 1975 · S/N 17265710N9627HSuperbuyer Inc · San Jose, CABuilt 1975 · S/N 17266275N9627TRegistration Pending · Sunny Isles Beach, FLRegistration pendingS/N 38-78A0147N9628HT3 Aerosports LLC · Vian, OKBuilt 1975 · S/N 17266276N9628MMeyer Michael A Trustee · Phoenix, AZBuilt 1966 · S/N 670205N9629GSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 18801570N9629SSchick Jason · Faulkton, SDS/N 59N962ACMccrary Ryan Michael · Greensburg, INBuilt 2001 · S/N 877-2000N962AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 177RG0464N962AMInternational Air Services Inc · Carson City, NVBuilt 1976 · S/N 177RG1054N9630QKelley Aircraft LLC · Weyers Cave, VABuilt 1975 · S/N 17265714N9630VN275508 LLC · Margate, FLBuilt 1974 · S/N 17264410N9631BPercy Flyers LLC · Dexter, MIBuilt 1981 · S/N 172RG0930N9631MOrvin Sanden Inc · Wyndmere, NDBuilt 1966 · S/N 670208N9631QHuntsman Ferral Don · Juneau, AKBuilt 1975 · S/N 17265715N9631SFreedom Aviation Of America LLC · Newcastle, TXBuilt 1966 · S/N 39N9631VHarrold Bruce E · Greybull, WYBuilt 1974 · S/N 17264411N9632HSweitz-Air Inc · Stewartstown, PAS/N 17266279N9632MAvimar · Marina Del Rey, CABuilt 1966 · S/N 670209N9633HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266280N9633MGould Zachary · Pleasant Hill, MOBuilt 1966 · S/N 670210N9634MBig Sky Flying Inc · Napa, CAS/N 670211N9634QDubois County Flight Services Inc · Huntingburg, INBuilt 1975 · S/N 17265718N9635BFisher Frank L · San Diego, CABuilt 1981 · S/N 172RG0933N9635HArizona Aircraft Leasing LLC · Mesa, AZBuilt 1975 · S/N 17266282N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592N9635MN9635m LLC · Cumming, GABuilt 1966 · S/N 670212N9635QRozynski Jason K · Malabar, FLBuilt 1975 · S/N 17265719N9635SPake Bradley P · Felton, MNBuilt 1966 · S/N 374N9635V35 Victor LLC · Decatur, GABuilt 1974 · S/N 17264415N9636HMontanez Orlando · Guaynabo, PRBuilt 1975 · S/N 17266283N9636MBistline Leland K · Fredonia, AZBuilt 1966 · S/N 670213N9636VNaperville Flying Club · Woodridge, ILBuilt 1974 · S/N 17264416N9636YCarranza Chris J · Stanfield, AZBuilt 1981 · S/N 21064566N9637QWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17265721N9638HHatbright Farm LLC · Wilmington, DEBuilt 1975 · S/N 17266285N9638MPinheiro Rodrigo P · Albuquerque, NMBuilt 1967 · S/N 670109N9638QPeterson John E · Benton, KSBuilt 1975 · S/N 17265722N9638VCrazy Aces LLC · St George, UTBuilt 1974 · S/N 17264418
Back to AD 80-25-07 R1