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.

N6862UCromer Chet T · Anderson, SCBuilt 1963 · S/N 2566N6863TBering Capital LLC · Anchorage, AKBuilt 1973 · S/N 17262470N6863UHoppe Joel A · Mankato, MNBuilt 1963 · S/N 2567N6863VCarr James Bradley · Hazlehurst, MSS/N 22-1256N6864HMay Jeffrey N · Ocala, FLBuilt 1975 · S/N 17265618N6864NStensen Craig J · Mount Juliet, TNBuilt 1968 · S/N 680144N6864UKuch Jonathan · Capitola, CAS/N 2568N6865NRegistered aircraftBuilt 1968 · S/N 680122N6866HParrish Michael C Trustee · Lakeland, FLBuilt 1975 · S/N 17265619N6866NMancini Peter A · Kenmore, NYBuilt 1968 · S/N 680145N6867NKnox Robert W Jr · Hazlehurst, GABuilt 1968 · S/N 680146N6867UMesquite Metro Flying Club · Dallas, TXFirst renewal noticeBuilt 1963 · S/N 2571N68688Registered aircraftS/N 15282322N6868VSign Maxx LLC · Larksville, PAS/N 22-1261N6869UHostetler Kevin J · Green Forest, ARBuilt 1963 · S/N 2573N686DBAnderson Bruce Robert · Mena, ARS/N 172-68334N686RWBetancourt Ernest B · Lascassas, TNBuilt 1999 · S/N 1256-98N6870UTahirovic Elmaz · Sharpsburg, GABuilt 1965 · S/N 2574N6870VRegistration Pending · Santa Cruz, CARegistration pendingBuilt 1975 · S/N 22-1263N68713Hillsboro Aero Academy LLC · Hillsboro, ORS/N 15285331N68714Registration Pending · Iuka, ILRegistration pendingBuilt 1981 · S/N 15285332N6872NVivian Rodney E · Cincinnati, OHBuilt 1968 · S/N 680149N6872V36 Delta Delta LLC · Albany, GABuilt 1975 · S/N 22-1265N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346N6873NWhitfield Jesse Leigh · Anacortes, WABuilt 1968 · S/N 680150N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358N6875NKatlin Ethan W · Payson, AZBuilt 1968 · S/N 680151N6875VSmolko Tod A · Greensboro, NCBuilt 1975 · S/N 22-1268N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622N6876NCunneen Casey Joseph · Studio City, CABuilt 1968 · S/N 680152N6876UVan Der Hart Mark H · Tekamah, NEBuilt 1963 · S/N 2580N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623N6877NElliott John O · Lathrop, MOBuilt 1968 · S/N 680126N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382N6879VBurke Jonathan · Berkeley, CABuilt 1975 · S/N 22-1272N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384N6880NLawrence John J · Cypress, TXBuilt 1968 · S/N 680127N6880VCraft Steven W · Port Saint Lucie, FLBuilt 1975 · S/N 20-1167N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388
Back to AD 80-25-07 R1