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.

N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861N2862XMathews Nancy M · Englewood, TNS/N 17700262N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866N2866XFeller Gerald A · Long Beach, CAS/N 17700266N2867XThrush Air Lc · Mason City, IABuilt 1967 · S/N 17700267N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868N2868ZWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 1237-78N2869GRay Richard A · Morristown, NJBuilt 1967 · S/N 533N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875N2876GPalmer Matthew B · Riverside, CABuilt 1967 · S/N 522-68N2877XJim Doherty Trucking Inc · Sacramento, CABuilt 1967 · S/N 17700277N2877ZCliff Robinson Real Estate Corp · Madison, INBuilt 1978 · S/N 373-78N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879N2879XGregoire Louis Bernard III · Blairsville, GABuilt 1967 · S/N 17700279N2879ZRitchie Rex W · Lopez Island, WABuilt 1978 · S/N 1019-78N287BWDaniels Kelly M · Humble, TXBuilt 1979 · S/N R18201329N287DKHemphill Holdings LLC · Hemphill, TXBuilt 2017 · S/N 1170-2017N287EBBoorom Mikel E · Jackson, MIBuilt 1978 · S/N 1265-78N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358N2880GDixon Walter G · Fuquay Varina, NCBuilt 1967 · S/N 457N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881N2883GSmith Kenneth W · Bedford, INS/N 109N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283N2884ZSpurgeon Paul M · Brooksville, MSBuilt 1978 · S/N 1239-78N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885N2885ZMclaughlin Paul E · Mansfield, OHS/N 374-78N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287N2888QChilds William C · Bridgeport, ALS/N 17259888N2888ZHonkomp Daniel · Euless, TXBuilt 1978 · S/N 1270-78N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289N288RTSavonen Stephen D · Ukiah, CABuilt 1967 · S/N 7KCAB-43N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890
Back to AD 80-25-07 R1