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.

N2931EHoward Charles O · Sonoma, CABuilt 1978 · S/N 17271376N2931XRegistered aircraftBuilt 1967 · S/N 17700331N29320Triple G Aviation LLC · South Point, OHBuilt 1968 · S/N 17700810N29321Render Jeff · Peoria, ILBuilt 1968 · S/N 17700811N29329Hill Edward J Jr · Dover, DEBuilt 1968 · S/N 17700815N2932LBcs Aviation LLC · Dothan, ALBuilt 1967 · S/N 670326N29330Rucinski Edward A · Climax, NCBuilt 1968 · S/N 17700816N29334Burger Cale L · Hampden, MEBuilt 1968 · S/N 17700820N29335Sale Reported · Lebanon, ORSale reportedBuilt 1968 · S/N 17700821N29340Hodges Michael T · Myrtle Beach, SCBuilt 1968 · S/N 17700823N29343Aeromech Incorporated · Mukilteo, WABuilt 1968 · S/N 17700826N29344P & P Aviation LLC · Trout Run, PAS/N 17700827N29345Bailey Daniel L · Gibsonville, NCBuilt 1968 · S/N 17700828N29350Cardinal Flyers LLC · Amherst, VAS/N 17700833N29356Rohwer Celia · Fairbanks, AKBuilt 1968 · S/N 17700836N2935LCrc Medical Staffing Inc · Mansfield, LAS/N 670069N2935XStelzer David C · Vermilion, OHBuilt 1967 · S/N 17700335N29362Registered aircraftBuilt 1968 · S/N 17700840N29366Bond Joseph C · Arlington, TXBuilt 1968 · S/N 17700843N29367Dulin Jim · Valparaiso, INBuilt 1968 · S/N 17700844N2936LWencko Paul Andrei · Saint Petersburg, FLBuilt 1967 · S/N 670070N29377Duncan John M · Owingsville, KYS/N 17700849N29379Sattler Russell P · Brooksville, FLBuilt 1968 · S/N 17700851N29389Otc Aviation LLC · Deer Creek, MNS/N 17700858N2938LAmend Keith R · Hagerman, IDBuilt 1967 · S/N 670072N29395Hand Randall A · Bonifay, FLBuilt 1968 · S/N 17700861N2939LDonahue Paul · West Palm Beach, FLS/N 670073N2939XDahl Skye T · Camas, WABuilt 1967 · S/N 17700339N293ACWeaver Roger D · Sarasota, FLBuilt 1995 · S/N 1355-95N293CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266259N293MAKrogman James D · Danube, MNBuilt 2004 · S/N 1377-2004N293MJLittle Dock Aviation LLC · Water Valley, MSBuilt 1982 · S/N 17275845N29400Registration Pending · Wakefield, RIRegistration pending, pending cancellationS/N 17700864N29409Nimmo David G · Ponder, TXBuilt 1968 · S/N 17700869N2940GDakota Air Spray LLC · Huron, SDBuilt 1967 · S/N 69N2940LFlyingchamp LLC · Missoula, MTBuilt 1967 · S/N 670074N29415Dahlen Jeffrey P · Devils Lake, NDBuilt 1968 · S/N 17700873N29422Kmz Transport & Leasing Services LLC · Bradenton, FLBuilt 1968 · S/N 17700878N2942LMurphy Paul James · Falls Church, VABuilt 1967 · S/N 670076N2942XLewellen Mark A · Pensacola, FLBuilt 1967 · S/N 17700342N29430Mcvicker Max W · Sand Springs, OKBuilt 1968 · S/N 17700882N29432Waddell Bhrent E Trustee · Collinsville, OKBuilt 1968 · S/N 17700883N29434Salvi Marcos · Phoenix, AZS/N 17700884N29436Echelon Sport Aviation LLC · Los Angeles, CAS/N 17700886N29439Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700888N2943GVan Ness James A · Buckley, WABuilt 1968 · S/N 517N2943XMccormack Robert · Sacramento, CAS/N 17700343N29440Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700889N29441Chan Luen Hei · Hacienda Heights, CABuilt 1968 · S/N 17700890N29442Nance David B · Quinton, VABuilt 1968 · S/N 17700891
Back to AD 80-25-07 R1