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.

N35BWCauthen Joe A · Canton, MSBuilt 1992 · S/N 678-92N35BYSuper D LLC · Broomfield, COBuilt 2005 · S/N 998-2005N35ELB&W Air LLC · Lincoln, NEBuilt 1990 · S/N 24-3142N35GElias 48 LLC · Morristown, AZS/N R18201785N35LABohachevsky John V · Bloomfield, KYBuilt 1966 · S/N 670184N35MLNelson Aircraft Sales Inc · Minot, NDBuilt 1974 · S/N 428-74N35RXRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 496-79N35WSRegistered aircraftS/N R18200346N36008Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 268-73N36009Svanda Roger D · Tyndall, SDBuilt 1973 · S/N 924-73N36010Eskildsen Chris A · Connell, WAS/N 535-73N36011Titus Larry E · Springview, NEBuilt 1973 · S/N 536-73N36013Jones Joseph D · Broken Arrow, OKBuilt 1973 · S/N 98-73N3601ELsn Air LLC · Morrison, COBuilt 1978 · S/N 17271603N3601HStay Tuned LLC · Nashville, TNBuilt 1977 · S/N 20-1239N36028Armstrong Robert Reno · Lakin, KSS/N 264-73N36031Markey William C Trustee · Wenatchee, WABuilt 1973 · S/N 540-73N36035Hilstad Steve D · Mayville, NDBuilt 1973 · S/N 100-73N3603HLewis Paul Jr · West Chester, PABuilt 1977 · S/N 20-1240N3604HDobbelaere Bros Inc · Oakwood, OHS/N 20-1241N3604LWalker Carol L · Ennis, TXBuilt 1978 · S/N 0812N3604XJones Bryan David Kingsley · San Diego, CABuilt 1977 · S/N 0767N3605HChilders Matthew W · Scottsdale, AZBuilt 1977 · S/N 20-1242N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040N3606EMiller Robert J · Casselton, NDBuilt 1978 · S/N 17271604N3607EPalm Cedric C · St Francisville, LABuilt 1978 · S/N 17271605N3609EBismarck Aero Center Corp · Bismarck, NDBuilt 1978 · S/N 17271606N3610EOrange County Flyers Inc · Mission Viejo, CAS/N 17271607N3610HScheffing Glenn J · Palm Beach Gardens, FLBuilt 1977 · S/N 20-1246N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247N3611NDowden Frank D · Fallbrook, CABuilt 1967 · S/N 680010N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73N36138Smith Brian Lee · Solvang, CABuilt 1973 · S/N 382-73N36139Flying Sportsmen Inc · Sussex, NJBuilt 1973 · S/N 105-73N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011N36140Phillips James M · Wilmington, NCBuilt 1973 · S/N 957-73N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012N3616NDe Masters Jasper · Bakersfield, CABuilt 1967 · S/N 680013N36173Schuster Darin D · New Castle, DEBuilt 1973 · S/N 546-73N36174Meise Fred W · Moses Lake, WABuilt 1973 · S/N 958-73N36176Otte Duane P · Plainfield, INBuilt 1973 · S/N 101-73N36178California Flyers Training Solutions LLC · Sun City, CABuilt 1973 · S/N 383-73N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278N3618NYoung Donald Colin · West Plains, MOBuilt 1967 · S/N 680014N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565TN3619NChiques Aero Corporation · Lancaster, PABuilt 1967 · S/N 680015N361ACBond Robert E · Kingsville, MOBuilt 1974 · S/N 497-75N3620CSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N R18200279N3620NMooney N3620n LLC · Chesterfield, MOBuilt 1967 · S/N 680016
Back to AD 80-25-07 R1