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.

N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465N338EEHansen Carl A · Bowie, MDBuilt 1965 · S/N 588N338SJMiller Space A · Simi Valley, CAS/N 38-79A0500N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690N3390XPrince Aviation LLC · Las Vegas, NVS/N 3385N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691N3391XDunham Seth Aaron · Acampo, CABuilt 1966 · S/N 3386N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3393XJohnson Terence A · Caldwell, IDBuilt 1966 · S/N 1102N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3396XS R Gilliam Construction Inc · Carthage, NCS/N 3388N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697N3398XWinkers John W Jr · Woodstown, NJBuilt 1966 · S/N 1105N339DGRegistered aircraftS/N P21000434N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784N33BP33bp LLC · Sand Springs, OKBuilt 1992 · S/N 691-92N33BYSellmeyer Flying Service · Knobel, ARBuilt 2005 · S/N 990-2005N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33GRHeadrick John Eric · Eolia, MOS/N 259-76N33GSFish N Fly LLC · Hobe Sound, FLS/N 15281292N33LDLeahey Thomas C · Huntington Beach, CAS/N R18201807N33LJUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 15282023N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N33YPFlight Control Services Of Florida Inc · Milton, FLS/N 17272269N33YZJenkins Blake T · Lakeland, FLBuilt 1978 · S/N 24-0631N33ZZNmfc Inc · Branchburg, NJBuilt 1977 · S/N 20-1231N34005Hinckley David D · Belton, TXFirst renewal noticeBuilt 1970 · S/N 17701590N34011Cross Charles W Jr · Willoughby, OHBuilt 1970 · S/N 17701594N34012Cap Flyers Aero Club LLC · Ocala, FLBuilt 1970 · S/N 17701595N34014Rupp Gregory J · Deltona, FLBuilt 1976 · S/N 177RG0949N34015Leftwich Brian · Savannah, GABuilt 1970 · S/N 17701597N34019Kortum Ronald L · Williamstown, NJBuilt 1970 · S/N 17701599N34029Rigdon William K · Hazel Green, WIBuilt 1970 · S/N 17701605N34030Sommer Greg J · Maryville, ILBuilt 1976 · S/N 177RG0953N34038B&B Cardinal LLC · Alexandria, VABuilt 1970 · S/N 17701608N34039Snedeker Andrew · Jackson, NJBuilt 1976 · S/N 177RG0954N3403XWenkman Michael J · Madison, WIBuilt 1966 · S/N 1108N34041Lange Charles A · Portageville, MOBuilt 1970 · S/N 17701610N34043Wrg Flyers LLC · Denver, COBuilt 1970 · S/N 17701611N34045Ackerman Mark R · Box Elder, SDBuilt 1970 · S/N 17701612N34049Osetek James · Harbor Springs, MIBuilt 1971 · S/N 17701616N3404THaik Kevin Jerome · Ozark, MOS/N 17700704N3404XAero Nautical Electronics Inc · Starke, FLBuilt 1966 · S/N 1109N34052Bauerle William L · Imperial, NEBuilt 1971 · S/N 17701617N34058Dodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 177RG0956
Back to AD 80-25-07 R1