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.

N2958LStormo Jarrod M · Indianapolis, INBuilt 1967 · S/N 670092N2958XCooper Ronald C · Fowlerville, MIBuilt 1968 · S/N 17700358N29592Reyner Matthew J · Georgetown, TXBuilt 1968 · S/N 17700978N29593Else John J · Toledo, IABuilt 1968 · S/N 17700979N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981N2959LMcphillips Jess H · Port Arthur, TXBuilt 1967 · S/N 670093N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359N295ACFanjoy James Michael · Nehalem, ORBuilt 1995 · S/N 756-95N29617Abbott Barry · Tempe, AZS/N 17700994N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2962LAllen Marcus I · Little Elm, TXBuilt 1967 · S/N 670096N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N2962ZMull Jason E · Chester, NYBuilt 1978 · S/N 379-78N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966LCarpenter Robert E · Huntsville, ALBuilt 1967 · S/N 670100N29673Olson Andrew S · Copper Canyon, TXBuilt 1968 · S/N 17701018N2967EBme N2967e LLC · Clearwater, FLBuilt 1978 · S/N 17271391N2967GMcallister A J Trustee · Buford, GABuilt 1967 · S/N 488N2967L2967lima LLC · Scott City, MOS/N 670101N2968XJansen Edward M · Hummelstown, PABuilt 1967 · S/N 17700368N2969LSeegers Matt J · Westlake Village, CABuilt 1967 · S/N 670328N296ACNewton Thomas L Jr · Fredericksburg, VAS/N 770-96N296DDDouglass Darrell C · Jamestown, CAS/N 24-0198N2970ESparrowhawk Aviation · Manvel, TXBuilt 1978 · S/N 17271393N2970XMonroe William R · Hawk Point, MOBuilt 1967 · S/N 17700370N2971LRegistered aircraftBuilt 1967 · S/N 680002N2972LMorris Russell K · Cameron Park, CABuilt 1967 · S/N 670331N2973ZLandrum Erik G · Austin, TXBuilt 1978 · S/N 359-78N29742Payne David T · Monticello, ILBuilt 1980 · S/N 618-80N2974XAnderson Keith · Covington, TNS/N 1346-80N2975QWorker Timothy M · Fairbanks, AKBuilt 1980 · S/N 346-80N2975WFoldesi Dennis · Merritt Island, FLBuilt 1980 · S/N 620-80N29762Davis Evan A · Fairbanks, AKS/N 352-80N29763Wilson Woodie J · Collins, MSS/N 1208-80N2976CGarrett John G · Conway, WABuilt 1980 · S/N 1204-80N2976LRichardson Samuel O · Villa Rica, GABuilt 1967 · S/N 670136N2976XPechota Steven F · Palmer, AKBuilt 1980 · S/N 1206-80N2976ZEvans James · Millbrae, CAS/N 380-78N29772Sublett John L · Georgetown, TXBuilt 1980 · S/N 1210-80
Back to AD 80-25-07 R1