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.

N2614GNorthern Air Inc · Bonners Ferry, IDBuilt 1967 · S/N 64N2614VMorris Daniel J · Bossier City, LABuilt 1974 · S/N 177RG0632N2615WSturgis Joel B · Pensacola, FLBuilt 1965 · S/N 3292N2616WDenney David W · Fowler, COBuilt 1965 · S/N 962N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707N2619WSmith Cecil · Fort Pierce, FLS/N 963N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295N2623CDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N R18200179N2623WThornhill Jeff P · Goodyear, AZBuilt 1966 · S/N 3296N2624WWilkins James K · Owens Cross Roads, ALBuilt 1966 · S/N 966N2625SSierra Aviation LLC · Plaza, NDBuilt 1979 · S/N R18201350N2625WPatton William D · Sheridan, WYBuilt 1966 · S/N 967N2626SDelta Aero LLC · Sarasota, FLBuilt 2026 · S/N 1226-2026N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53N2629VEyw Flying LLC · Key West, FLBuilt 1974 · S/N 177RG0635N2629WHogan James C DBA · Cameron Park, CABuilt 1966 · S/N 970N262ACLavelle Jeffrey · Kenmore, WABuilt 1996 · S/N 766-96N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183N2631WPlanes & Parts Inc · Weston, FLBuilt 1966 · S/N 3299N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184N2632WKrapp Transfer · Jamestown, NDBuilt 1966 · S/N 3300N2633CWalusz Bernice J · Linden, NJS/N R18200185N2634GDavis Michael W · Richland, WABuilt 1967 · S/N 476N2634WGuerrero Aircraft LLC · Newport, WABuilt 1966 · S/N 973N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186N2635WElam Brent R · Woodford, VABuilt 1966 · S/N 974N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188N2637WCox James L · Fort Worth, TXBuilt 1966 · S/N 3302N2638VWells Larry C · Flowood, MSBuilt 1974 · S/N 177RG0638N2639CClear And Seven LLC · Santa Teresa, NMBuilt 1978 · S/N R18200189N2639VBowen Keith S · Lyle, WABuilt 1974 · S/N 177RG0639N2639WBrown Jeffrey R · Leesburg, FLBuilt 1966 · S/N 976N263MAMacair Aviation LLC · Xenia, OHBuilt 2004 · S/N 968-2004N2640VBube Douglas G · Clarkston, WABuilt 1974 · S/N 177RG0640N2641WRampini Daniel G · Cleveland, OHBuilt 1966 · S/N 3303N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931N2643VGorman Sean P · Superior, COBuilt 1974 · S/N 177RG0641N2644WMoran Robert D Jr · Plano, TXBuilt 1966 · S/N 979N2648VWhite Jeffrey W · Macon, GABuilt 1974 · S/N 177RG0642N2648WDeghetto Richard D · Hopkinsville, KYBuilt 1966 · S/N 981N2649WTeeter Joseph Jerald · Lisbon, OHBuilt 1966 · S/N 982
Back to AD 80-25-07 R1