OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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.

N797LLetourneau University · Longview, TXBuilt 2014 · S/N 1410-2014N797MPJezierski Michael David · Westfield, INBuilt 1969 · S/N AA1-0211N7983HThomas Ian C · Fairbanks, AKBuilt 1946 · S/N 12-877N7985HPolovitch Rex L · Crown Point, INBuilt 1946 · S/N 12-879N7986HBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N 12-857N7987HBrook Gary · Cocolalla, IDBuilt 1946 · S/N 12-900N798LLetourneau University · Longview, TXBuilt 2005 · S/N 1393-2005N798LALong Island Aviators LLC · Farmingdale, NYBuilt 1978 · S/N 15281645N7994HErickson David L · Anchorage, AKBuilt 1946 · S/N 12-1142N79YTSpringer James G · Antioch, ILBuilt 1985 · S/N 1356N7BZHartland Antique Aviation LLC · Hartland, MIBuilt 1943 · S/N 75-5304N7CBrennan Joseph · Shirley, NYBuilt 1972 · S/N AA1A-0345N7FCDubner Joseph L Trustee · Independence, ORS/N 62RAN7QJDeremer Eric B · Kissimmee, FLBuilt 1978 · S/N 38-79A0308N7WBLemon Jeffrey D · Port Orchard, WABuilt 1992 · S/N 135N800FTChaddon Troy M · Shawnee, OKBuilt 1988 · S/N 723N800TYAvcorp Holdings Inc · Jackson, MIBuilt 1978 · S/N 15282202N800VHWunsch Donald L · Reedsville, WIBuilt 2003 · S/N 20-1012N80146Chapter 15 Aviation Inc · Homer Glen, ILBuilt 1981 · S/N 15285354N801VHYang Puyu · Palacios, TXS/N 20-1011N801YLand Management Of New York LLC · Highland, NYBuilt 1979 · S/N WA-59N8029MDixon Kenneth P · Arvada, COS/N KD 002N8032HWintringham Henry J Jr · Max Meadows, VABuilt 2003 · S/N 6-4186N803ABAlo Aviation LLC · Titusville, FLBuilt 1978 · S/N 15282246N8040ZZilinsky Robert F · Willowbrook, ILBuilt 1980 · S/N 072040N8055WBarbulescu Marcel A · Arlington, VABuilt 1978 · S/N AA1C-0095N80587Malilay Jurrel Albino A · East Palo Alto, CABuilt 1981 · S/N 15285366N80690Flight Foundation · Unicoi, TNBuilt 1981 · S/N 15285367N8071LRogers Jonathan T · College Place, WABuilt 1959 · S/N 16-550N8077ULeavitt Erin G · Lewiston, IDBuilt 1947 · S/N 12-1084N808JRTexas Air Museum Inc · San Antonio, TXS/N 84N8094EHaas Robert F · Elbert, COBuilt 1994 · S/N 2N80BWBuhlig Myles A · Lexington, KYBuilt 1999 · S/N 1999N80DLJetstream Aeronautics LLC · San Antonio, TXBuilt 1979 · S/N 15283230N80KJAlbert Lea Airport Inc · Albert Lea, MNBuilt 2010 · S/N 75-7602N80PBMulrooney William G · Mooresville, NCS/N 1262N80SDLake Area Technical College · Watertown, SDBuilt 2005 · S/N 1397-2007N8104VUnited Aviation LLC · Missoula, MTS/N GWA466N810BDJewula Stanley J · Indianapolis, INBuilt 1999 · S/N BD-001-HMN8124GWilliamson Joel B · Goleta, CAS/N 536N812JBKrall Jeff P · Mitchell, SDBuilt 2000 · S/N 9604-0178N812SPHayes Edward B · Cedar Rapids, IAS/N 1499N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828N814BJRancifer Rodney M · Lithonia, GABuilt 2009 · S/N 001N814GPJackson Jefferey W · Milledgeville, GABuilt 1974 · S/N AA1B-0503N81577Juhl Wilbur D · Roundup, MTBuilt 1945 · S/N 7AC-196N8176Lewandowski Mark J · Wilton, CABuilt 1971 · S/N 1207N8183KSchleicher Richard A · Rch Palos Vrd, CABuilt 1986 · S/N RAF-717N8186WStough Stephen A · Reno, NVBuilt 1965 · S/N 28-2313N81878Mcclave Wilkes III · Hanover, NHBuilt 1946 · S/N 7AC-501
Back to AD 80-25-02 R2