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.

N4202YAll Sports Aviation LLC · Cocolalla, IDBuilt 1977 · S/N 603-77N42033State Of Alaska · Anchorage, AKBuilt 1974 · S/N 17264154N42035Paulsen Hans J · Cedartown, GABuilt 1974 · S/N 17264155N4203QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260103N4204YCharles Tim W · Caldwell, IDBuilt 1977 · S/N 293-77N4205YDrobshoff Alex · Livermore, CABuilt 1977 · S/N 1195-77N42061Muhle Gerald A · Lincoln, NEBuilt 1974 · S/N 17264156N42062Parker Jo K Trustee · Ardmore, OKBuilt 1974 · S/N 17264157N4206QOsmonovich Michael · Kent, WABuilt 1971 · S/N 17260106N4207EDohnke Frederick William · Tehachapi, CABuilt 1978 · S/N 38-78A0489N4207YAnderson John A · Palmer, AKBuilt 1977 · S/N 972-77N4208YScout Towing Company · Omaha, NEBuilt 1977 · S/N 243-77N42095Cpkb · Summit, NJBuilt 1974 · S/N 17264158N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109N4209YShilt Jerry C · El Dorado Springs, MOBuilt 1977 · S/N 1197-77N420RFritz David W · Kerrville, TXBuilt 1979 · S/N R18200948N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160N42118Walsh Air LLC · Live Oak, FLBuilt 1976 · S/N 177RG1088N4211HRn Roofing LLC · Brandon, MSS/N 24-0662N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162N4212HG And H Aviation · Louisville, KYBuilt 1978 · S/N 24-0663N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113N4213YFandrich Edward I · Payson, AZS/N 341-77N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114N4214YAngran Nate J · Albia, IABuilt 1977 · S/N 1199-77N4215YCg Air LLC · Mason City, IABuilt 1977 · S/N 968-77N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77N4218HGenna Aviation LLC · Newfield, NJBuilt 1978 · S/N 24-0665N4218QSavant John D · Kinder, LAS/N 17260118N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119N421ACCroft Dennis W · Spencerville, OHBuilt 1966 · S/N 1066N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437N421LJAaces Flight Operation LLC · Ellisville, MOBuilt 2010 · S/N 1095-2010N4220HHutchinson Keith M · Lancaster, TXBuilt 1978 · S/N 24-0666N42212Caves Xxi Properties LLC · Virginia Beach, VABuilt 1974 · S/N 17264163N4221QRegistered aircraftBuilt 1971 · S/N 17260121N4222Barry Edwin R · Apple Valley, CAS/N 24-0655N4222HCre Aviation Holdings LLC · Ramona, CABuilt 1978 · S/N 24-0667N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122N4224HWharton William R Jr · Dresden, OHBuilt 1978 · S/N 152-80324N4224NPeterson Dominic S · Los Alamos, NMBuilt 1974 · S/N 220065N4224QPressley Aviation LLC · New London, NCBuilt 1971 · S/N 17260124N4225QBraddock Karrol L · Globe, AZBuilt 1971 · S/N 17260125N4227HMccharters LLC · Hobe Sound, FLBuilt 1978 · S/N 24-0670N4227QSchoenfeld Paul E · Midvale, UTBuilt 1971 · S/N 17260127N4228ETomahawk 4228e LLC · Tucson, AZS/N 38-78A0497N4228QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260128
Back to AD 80-25-07 R1