OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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.

N6102RAerospace Aviation Services Inc · Wilmington, DEBuilt 1979 · S/N 172RG0084N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715N6103SJohnson Robert J · Santa Barbara, CABuilt 1980 · S/N R18201611N6104QSorby Jerry N · Fort Ransom, NDBuilt 1981 · S/N 15285129N6105QAero Quest LLC DBA · Olive Branch, MSBuilt 1981 · S/N 15285130N6105SMy Sky LLC · Hays, KSBuilt 1980 · S/N R18201612N6105VSchlesinger Henry R · Castalian Springs, TNBuilt 1980 · S/N 172RG0580N6106QSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285131N610ACHybird Inc · Corpus Christi, TXS/N 17264912N610AMSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 17270193N610HPValor View Aviation LLC · Midland, TXBuilt 1981 · S/N 172RG0892N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N610MTMooney Flyers Inc · Sault Sainte Marie, MIBuilt 1966 · S/N 1086N6111QAces High Aviation LLC · Long Beach, CABuilt 1981 · S/N 15285136N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6112SHall Metal Corp · Fort Pierce, FLBuilt 1980 · S/N R18201615N6113RColorado Northwestern Community College · Rangely, COBuilt 1979 · S/N 172RG0086N6113VLegacy Lsa LLC · Plainview, TXBuilt 1980 · S/N 172RG0581N6114SGoral William W · Redlands, CABuilt 1980 · S/N R18201616N6115NHartwick John H · Goodyear, AZS/N 18267789N6115SGan Specialties Inc · Pocatello, IDBuilt 1980 · S/N R18201617N6116YSaab35 Draken Inc · Pocono Pines, PAS/N 21064256N6117MFayette Hawks Flying Club Inc · Somerville, TNBuilt 1980 · S/N 15284625N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N611APDobry Robert S · Crescent City, FLBuilt 1979 · S/N 317-79N611BDClement Aviation Inc · Tea, SDS/N 17266692N611BRKnick Michael J · Camarillo, CABuilt 1969 · S/N 700033N611CAWilliams Todd A · Littleton, COBuilt 1977 · S/N 17269022N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611DXRegistered aircraftBuilt 1967 · S/N 149N611EAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1979 · S/N 17272471N611PSPc Simonton Egineering LLC · Greensboro, GAS/N 24-1278N611TMWest Michigan Skybirds Inc · Battle Creek, MIBuilt 1978 · S/N 21063037N6120SLash Gary L · Round Rock, TXBuilt 1980 · S/N R18201618N6121TMcalilly Stephen L · Tupelo, MSBuilt 1982 · S/N R18201909N6121VPugmire Marsh C · Saint Charles, IDBuilt 1980 · S/N 172RG0582N6122DBudde Bobby M Jr · San Jose, CAFirst renewal noticeBuilt 1979 · S/N 17272607N6122SBusiness Jet Managers Inc · Canton, MIBuilt 1980 · S/N R18201619N6123FJws Aviation LLC · Edina, MNBuilt 1979 · S/N 17273153N6124DWegener Flying Services LLC · Indialantic, FLBuilt 1979 · S/N 17272608N6124TBanjo Ben Aviation LLC · Kilgore, TXS/N R18201911N6125BBv Road And Site LLC · Penfield, NYBuilt 1979 · S/N 15283904N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260N6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583N6128TStone Mark · Scotts Valley, CABuilt 1982 · S/N R18201912N612APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 286-78N612BZDerby City Aviation LLC · Vero Beach, FLBuilt 1979 · S/N 17272084N612CAOmni Aero LLC · Wilkesboro, NCBuilt 1978 · S/N 15282495N612DMRegistered aircraftBuilt 1977 · S/N 177RG1212N612HKDickey Stephen H · De Leon, TXBuilt 1977 · S/N 177RG1303
Back to AD 80-25-07 R1