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.

N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982N3883HMovshin Mikhail · Aiken, SCBuilt 1980 · S/N 24-0976N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983N3884QWrangell Mountain Air Inc · Palmer, AKBuilt 1971 · S/N 17259984N3886HBerkebile Matthew · Midland, TXBuilt 1980 · S/N 24-0977N3886PUncanny Valley Films Inc · Arroyo Seco, NMBuilt 1978 · S/N P21000068N3889QRegistration Pending · White, GARegistration pendingBuilt 1971 · S/N 17259989N388JFAspire Aviation LLC · Farmingdale, NYS/N 17276182N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525N3891HJohn R Loar · Kemp, TXBuilt 1980 · S/N 24-0978N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996N3898HTrue Course Holdings LLC · Ruston, LABuilt 1979 · S/N 24-0893N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998N3899QFlight Inc · Gastonia, NCBuilt 1971 · S/N 17259999N389CLCanaan Land Church Inc · Autaugaville, ALBuilt 1972 · S/N 17260700N389DCJehn Frank · Jackson, NJS/N 24-0639N38ACCesafsky Allen A · Trinity Center, CABuilt 1990 · S/N 643-90N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516N38CKHartsfield Amy G · Pace, FLS/N 17263959N38FRHenry Scott · Kingman, AZBuilt 1978 · S/N 17270698N38HSHenderson State University · Arkadelphia, ARBuilt 1997 · S/N 1366-98N38LTStevens Richard D · Isola, MSBuilt 1993 · S/N 718-93N38MBWest Joseph A · Ballston Lake, NYBuilt 1993 · S/N 715-93N38PAMarine Flyer LLC · Eddyville, KYBuilt 1977 · S/N 17270182N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979N38PRK&M Industry LLC · Winston Salem, NCS/N 38-78A0780N38SURiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15285144N38WHButler David · Palos Park, ILBuilt 1995 · S/N 748-95N38WKFoley Stephen T · Kerrville, TXBuilt 1979 · S/N 1133-79N3901NMgg Airplane LLC · Lewes, DES/N 680148N3904QKern Bruce A · Collinsville, OKBuilt 1971 · S/N 17260004N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005N3906NPoe Robert · Lincoln, CABuilt 1968 · S/N 680003N3908HVu Ai T · Aiea, HIBuilt 1979 · S/N 24-0896N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009N390ACEtcheverry Raymond L · Sunriver, ORS/N 491-2006N390PEBoney Grady F · Rhine, GABuilt 2015 · S/N 1156-2015N390XDDecathlon Xtreme Inc Trustee · Wilmington, DEBuilt 2014 · S/N 1144-2014N3910NStratus Aviation Group LLC · Washington, DCBuilt 1968 · S/N 680058N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011N3912NChiwaya Brandon · Philadelphia, PABuilt 1968 · S/N 680059N3912PRegistered aircraftBuilt 1978 · S/N P21000074N3914NBradford Michael G · San Jose, CABuilt 1968 · S/N 680060N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014
Back to AD 80-25-07 R1