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.

N3532MToth Richard C · Tinley Park, ILS/N 12-2376N35374Phelan Ricky R · Jefferson, ORBuilt 1941 · S/N 5-625N3537MWade Mark C · Bonham, TXBuilt 1947 · S/N 12-2100N35381Pss Air Inc · Middlesboro, KYS/N 5-630N35394Acs Aviation LLC · Burlington, VTBuilt 1941 · S/N 5-643N35409Sandvik Randall L · Palmer, AKBuilt 1941 · S/N 5-660N3541MPhillips Alan Roger · Anchorage, AKBuilt 1947 · S/N 12-2388N35424Terkeurst William J IV · Gurley, ALBuilt 1941 · S/N 5-675N3542MRobertson Keith A · Wasilla, AKBuilt 1947 · S/N 12-2099N3550MJopson Charles M · Etna, CABuilt 1947 · S/N 12-2395N3553VBellmann Carl W · Bryan, OHBuilt 1948 · S/N 14828N3555MCade Chris · Canton, TXS/N 12-2403N3556MHubbert Robert · Azle, TXS/N 12-2501N3558MHale Mitchell D · Chugiak, AKFirst renewal noticeS/N 12-2404N355AAAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N 15284224N35604Welch Troy O · Graford, TXS/N 5697N3563MInternational Air Services Inc Trustee · Carson City, NVS/N 12-2411N3568MLong Douglas J · Wolf Point, MTBuilt 1947 · S/N 12-2504N3571MCasazza Christian G · Anchorage, AKBuilt 1947 · S/N 12-2419N3571VLutz Paul A · Seville, OHBuilt 2026 · S/N 05210100N35721Bakken Al J · Belgrade, MTBuilt 1941 · S/N 5-762N3573MCheney Klyn W · Gooding, IDBuilt 1947 · S/N 12-2420N357FPJenson Michael N · Nevis, MNBuilt 1961 · S/N 22-7334N357HAWagner Rickey J · Stacy, MNBuilt 2008 · S/N NEICO AVIATION #90N3580MHall Garrett J · Homer, AKS/N 12-2510N3584MBurcham Aaron T · Soldotna, AKBuilt 1947 · S/N 12-2431N3586MKoskovich Thomas D · Shakopee, MNBuilt 1947 · S/N 12-2509N3591MScheibe Marvin E · Wooster, OHBuilt 1947 · S/N 12-2437N3594MThacker William E · Chenoa, ILS/N 12-2439N3598MOlmstead Dorothy E · Talkeetna, AKBuilt 1947 · S/N 12-2444N359MJSkyway Leasing Inc · Lakeland, FLBuilt 1982 · S/N WA-304N35FWWilliams Francis B · Edgewater, MDS/N 119N35TMJewett Thomas E · Morrison, COBuilt 1986 · S/N 1233N35VLMelkers Edgar · Tucson, AZS/N 975N35ZAStark Timothy R · Livermore, CABuilt 1997 · S/N 20-0035N36009Svanda Roger D · Tyndall, SDBuilt 1973 · S/N 924-73N3604MKelsey Mike O · Carey, IDBuilt 1947 · S/N 12-2453N3607MWick Air Inc · Palmer, AKBuilt 1947 · S/N 12-2516N3611MPozanac Charles J · Riverside, CABuilt 1947 · S/N 12-2543N3613MHall Gary L · Delta Junction, AKBuilt 1947 · S/N 12-2459N36140Phillips James M · Wilmington, NCBuilt 1973 · S/N 957-73N3616MPrince Benjamin D · Lincoln, MTBuilt 1947 · S/N 12-2462N36174Meise Fred W · Moses Lake, WABuilt 1973 · S/N 958-73N3619MMartinson Douglas E · Nome, AKBuilt 1947 · S/N 12-2517N3621MLazor Ronald · Middlefield, CTBuilt 1947 · S/N 12-2470N3622MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-2471N36285Schreiber Ray R · New Palestine, INBuilt 1973 · S/N 964-73N3629MPazsint Joseph J · Wasilla, AKBuilt 1947 · S/N 12-2476N362RBMillsap Christopher J · Castro Valley, CABuilt 1975 · S/N 123288117N36336Mierzejewski Karl · State College, PABuilt 1973 · S/N 965-73
Back to AD 80-25-02 R2