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.

N4378MWilson Robert A · England, ARS/N 12-3314N437NGAschinger John S · Beacon, IABuilt 2011 · S/N 6025N4380MTalkeetna Aviation LLC · Talkeetna, AKS/N 12-3316N4387EAlbergotti James M III · Orangeburg, SCBuilt 1978 · S/N 38-78A0585N4387MBedard Michael J Trustee · Madison, ALBuilt 1947 · S/N 12-3325N4395MCurenton Brett · Elmore, ALS/N 12-3334N4399MN4399m LLC · Morgan, UTBuilt 1947 · S/N 12-3339N43RLWhitehead Michelle W · Centralia, WAFirst renewal noticeBuilt 1977 · S/N 1925N44048Beets Larry J · Columbia, MSBuilt 1998 · S/N 1998N4406MSmith Matthew E · St Charles, ILBuilt 1947 · S/N 12-3358N4408MGlen John Robert · Anchorage, AKBuilt 1947 · S/N 12-3360N440ACColeman Ben · Lakeland, FLBuilt 1997 · S/N 1364-97N440JDMullenax Larry W · Cuchillo, NMBuilt 2020 · S/N 75-10806N4410MAyresouth Aviation Inc · Lithia Springs, GABuilt 1947 · S/N 12-3362N4412MSwinden Jonathan E · Danville, PABuilt 1947 · S/N 12-3363N4413MWings Of The North · Eden Prairie, MNBuilt 1947 · S/N 12-3364N4417AMiller Edward L · Santa Rosa, CABuilt 1984 · S/N F-1506N4417BWilkins Raymond E · Osceola, IAS/N F-1507N4417EDeaton David B · De Berry, TXBuilt 1985 · S/N F-1022N4417HBalunek Konrad K · Avon, OHBuilt 1986 · S/N F-1516N4417NMeis Joseph M · Elgin, NES/N F1509N4417PRegistered aircraftS/N F1510N4417QBaldwin Eileen J · Shady Cove, ORS/N F1511N4418FMcclure John M · Fairbanks, AKS/N F1514N4418MFeder Trent T · Madelia, MNS/N F1515N4418VMiddleton Mace D · Tulia, TXS/N F-1520N4418YMilano Vito R Trustee · Middletown, MDS/N F-1521N4419PAircraft B52 LLC · Lewes, DEBuilt 1991 · S/N 2209N4423MBarts Flying Service Inc · Storm Lake, IABuilt 1947 · S/N 12-3374N4424MPeedin John J · Littleton, NCBuilt 1947 · S/N 12-3377N4425MCoxon Allan · Ford, WABuilt 1947 · S/N 12-3376N4428MMittelstadt Garret A · Oakfield, WIBuilt 1947 · S/N 12-3380N4432EMeyer Reed J · Moses Lake, WABuilt 1978 · S/N 38-78A0599N4435MMerrill Patrick A · Winston Salem, NCBuilt 1947 · S/N 12-3387N4436MKelsey Mike · Carey, IDBuilt 1947 · S/N 12-3389N4437MStrawn Richard B · Fruitland, IDS/N 12-3388N4441MJohnson Arnold R · Mina, SDBuilt 1947 · S/N 12-3394N4441PMartinson Dominick T · Valdez, AKS/N 5-603N4445MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-3399N4447EFucito Daniel Ross · Lexington Park, MDS/N 38-78A0609N4447MIndiana Aviation Inc · Nicktown, PAS/N 12-3403N4449MMoore David P · Chugiak, AKBuilt 1947 · S/N 12-3401N444MRBuxbaum Mark Edward · Hot Springs, SDBuilt 1995 · S/N 563N4451MMartin Kenneth Lloyd · Palmer, AKBuilt 1947 · S/N 12-3406N4454MTwitchell Matt D · Venice, UTBuilt 1947 · S/N 12-3405N4457MLunceford Jerry W · Corpus Christi, TXBuilt 1947 · S/N 12-3410N4458MRickard William A · Virginia Beach, VABuilt 1947 · S/N 12-3413N445WDGurcan Bulent K · Point Roberts, WABuilt 1987 · S/N 445N4460MScheibe Mark E · Lakeville, OHBuilt 1947 · S/N 12-3412N4461MHamm Gregory S · Cordova, AKBuilt 1947 · S/N 12-3414
Back to AD 80-25-02 R2