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.

N6031QWhittier Frank · Las Vegas, NVBuilt 1965 · S/N 876N6032RMatecumbe Flying Service Inc · Immokalee, FLBuilt 1976 · S/N 18802734TN6033QHerfield Colton · Lawton, OKBuilt 1965 · S/N 878N6034QBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 3237N6035QWylie Warren J · Montague, NJS/N 3238N6036LCrestair Air LLC · Dover, DEBuilt 1975 · S/N 0713N6039QEagar Mark A · Cameron Park, CABuilt 1965 · S/N 3239N6041QDonohue Mark A · Red Lodge, MTBuilt 1965 · S/N 882N6042QMacfie Andrew · Richmond, CABuilt 1965 · S/N 883N6044QOliver Nicholas R · Arroyo Grande, CABuilt 1965 · S/N 3241N6046QRed Desert Aviation LLC · Hurricane, UTBuilt 1965 · S/N 885N6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172TN6049QBudgett Stephen A · Gilbert, AZBuilt 1965 · S/N 3243N6051EMathews James L · Menlo Park, CABuilt 1983 · S/N 18268342N6051QWhite Jeffrey M · Carlsbad, CABuilt 1965 · S/N 888N6052QCash Alan B · Fort Worth, TXBuilt 1965 · S/N 889N6053LHenson Randolph C · Spring, TXFirst renewal noticeBuilt 1976 · S/N 0727N6054LTriple-R-Biplane Inc · Andover, NJBuilt 1975 · S/N 0715N6055QGlenn Howard Anderson Jr · Wakefield, RIBuilt 1965 · S/N 3246N6056CFlight Contract Services Inc · Las Vegas, NVBuilt 1978 · S/N R18200365N6057QKennedy Kyle R · Berrien Springs, MIBuilt 1966 · S/N 892N6059QSchoenleben Thomas J · Stevensville, MTBuilt 1965 · S/N 3247N605JTKiefer Matthew J · Xenia, OHBuilt 1974 · S/N 22-0039N6061QThurston David H · Cincinnati, OHBuilt 1965 · S/N 894N6063ELawrence Aviation LLC · Overland Park, KSS/N 17271987N6063QTaylor Alan M · Nekoosa, WIBuilt 1965 · S/N 896N6064QWilliams Rodney K · Stacy, MNBuilt 1965 · S/N 3249N6065QShick Douglas Todd · Chester, VAS/N 3250N6066QArmagost James C · Belton, TXBuilt 1965 · S/N 897N6067QFrantz Joseph M · Gill, COBuilt 1965 · S/N 898N6068QPressley Jerry · Morristown, TNBuilt 1965 · S/N 899N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136N606GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15284058N606RWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 177RG0980N606WLarson Bernard J · Mt Vernon, WABuilt 1965 · S/N 3172N6070QOdenbach Eric J · Eureka, SDBuilt 1966 · S/N 3328N6071QHaven Hospitatlity LLC · San Marino, CABuilt 1965 · S/N 900N6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CABuilt 1965 · S/N 901N6074QMiranda Edward G · Prescott Valley, AZBuilt 1965 · S/N 3253N6075LChandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 0716N6078CKtoa Rentals LLC · Torrance, CABuilt 1978 · S/N R18200370N6079CAllen William H Trustee · Big Bear City, CAS/N R18200371N6081CShannon Jeanette M · Marathon, FLS/N R18200372N6082QIrvine Brooklyn L · Sacramento, CABuilt 1965 · S/N 907N6083JB&R Aircraft LLC · Wadsworth, OHBuilt 1980 · S/N 17273853N6083QAjirogi Michael T · Pearl City, HIBuilt 1965 · S/N 908N6083VScholz Francis M · Atchison, KSBuilt 1980 · S/N 172RG0571N6084MGrider Charles H III · Belleville, ILBuilt 1980 · S/N 15284615N6084QHammond Edward M · Grass Valley, CABuilt 1965 · S/N 3257N6085MWood Mark D Trustee · New Berlin, WIBuilt 1980 · S/N 15284616
Back to AD 80-25-07 R1