OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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-02-R2')
    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-02-R2')
  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.

N2602ABrisker Geoffrey H · Wheelersburg, OHBuilt 1978 · S/N 38-78A0772N2603BCafiero Vincent B · Haskell, OKBuilt 1978 · S/N 38-79A0147N2603NMonroe James C Jr · Winston Salem, NCBuilt 1947 · S/N 12863N26045Wyant James O · Sanford, NCBuilt 1981 · S/N 38-81A0112N2605DRealty Investment Co Ltd · Hilo, HIBuilt 1978 · S/N 38-79A0392N2606LMatts Services LLC · Chicago, ILBuilt 1979 · S/N 38-79A0778N2607NPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0940N2608GStrom Gordon B Md · Paris, TXBuilt 1967 · S/N 450N2608MEhrenfelt Linda Mae · Pierre, SDBuilt 1946 · S/N 12-1074N2609EMakotyn Andrzej · Northbrook, ILBuilt 1978 · S/N 38-78A0486N260EZMurphy John F · Ann Arbor, MIBuilt 1991 · S/N 260N2612MGreenhalgh Janna L · Caldwell, IDBuilt 1946 · S/N 12-964N2615MKelsey Mike · Carey, IDBuilt 1946 · S/N 12-1079N26284Rupke Curtis · Winterville, NCS/N 7570N2634GDavis Michael W · Richland, WABuilt 1967 · S/N 476N2638MBooth Wade W · Palmer, AKBuilt 1946 · S/N 12-981N2639MPense Douglas H · Fairbanks, AKBuilt 1946 · S/N 12-977N263AMCarmichael Joel E · Greensboro, NCS/N 20-1049N2641MGeorge Gary D · Humble, TXBuilt 1946 · S/N 12-983N2645MSchwenke-Cram Kim · Madison, SDBuilt 1946 · S/N 12-979N2646MBelanger Bette · Wasilla, AKBuilt 1946 · S/N 12-1143N264AMX Aviation Ventures Corp · Granville, TNS/N 20-1050N264TPm Aviation LLC · Missoula, MTBuilt 1953 · S/N 18-2378N26508Truitt Walter V Jr · Raleigh, NCBuilt 1975 · S/N 523N2650ZFrederick James H · Springfield, OHBuilt 1977 · S/N 1223-77N2655MRenneke Wiest Lynnette E · Le Sueur, MNBuilt 1946 · S/N 12-978N2656MHaggstrom Daryl V · Fairbanks, AKBuilt 1946 · S/N 12-968N2659ZWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284521N2666MBurt David R Jr · Justin, TXBuilt 1946 · S/N 12-1109N2666ZBig Falls Flying Club Inc · Intl Falls, MNS/N 1224-78N266PJJohnson Philip T · Waxhaw, NCBuilt 1996 · S/N 266N2671GAas LLC · Ovid, MIBuilt 1967 · S/N 316N2671MZoch Lori R · Port Orange, FLBuilt 1946 · S/N 12-972N2674MStarr LLC · Superior, WIBuilt 1946 · S/N 12-1107N2682MDavis Philip L · Spring Hill, TNBuilt 1946 · S/N 12-1113N2683MBeach Banners Inc · Jacksonville, FLBuilt 1946 · S/N 12-1114N2683ZAmmlim LLC · Vacaville, CABuilt 1978 · S/N 1227-78N2684GBlair Daniel S · Perrysburg, OHS/N 546N2686MCummings Scott Alan · Monitor, WABuilt 1946 · S/N 12-999N2687MWilkes Gary W · Lakeland, FLBuilt 1946 · S/N 12-1117N2689MKuehni Steven A · Stanley, WIBuilt 1946 · S/N 12-1200N268TCline David R · Maryville, TNBuilt 1953 · S/N 18-2382N2691MHartmaier Robert S Jr · Monroe Township, NJBuilt 1946 · S/N 12-1121N2692MOnstott Norman V · Mount Pleasant, MIBuilt 1946 · S/N 12-1122N26946Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-16N2694MSwartz William L · Cumb Foreside, MEBuilt 1946 · S/N 12-1206N2696GGrabeman Allan · Fishers, INBuilt 1967 · S/N 325N2696ZAdriatic Holdings LLC · Cheyenne, WYBuilt 1978 · S/N 1230-78N269ACBurks Aviation Inc · Hattiesburg, MSBuilt 2002 · S/N 1386-2002N269AMBekraoui Hicham · Pasadena, CABuilt 2004 · S/N 20-1036
Back to AD 80-25-02 R2