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.

N9178YPurdy Louis John · Pahrump, NVBuilt 1996 · S/N 3307N9182AAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0102N9188LSodowsky Jim L · Ponca City, OKBuilt 1971 · S/N 814-72N918UGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285441N91906Martin Jonathan B · Alamogordo, NMS/N 12-15N91908Hollingsworth Lloyd Dan · Anchorage, AKBuilt 1946 · S/N 12-17N91911Messinger Donald E · Wasilla, AKS/N 12-20N9191LMeyer Gordon L · Knoxville, TNBuilt 1971 · S/N 815-72N9193LAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 817-72N9194LRussell Keith M · Ivoryton, CTBuilt 1971 · S/N 818-72N9199AArgos Retail LLC · Mcallen, TXBuilt 1982 · S/N 38-82A0111N919GPRegistration Pending · Fairburn, GARegistration pendingBuilt 1970 · S/N AA1-0390N91EWToussaint David F · Lakeville, MNS/N WA-30N91HLWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1982 · S/N 15285648N91JCAdams Rodney M · Garner, NCBuilt 1990 · S/N 1357N91RZSacco Anthony · Folsom, CABuilt 2003 · S/N 20-1014N91WBMoe Michael J · Detroit Lakes, MNBuilt 1991 · S/N 1989N9205LJarog Terence A · Denton, TXBuilt 1971 · S/N AA1A-0105N9206LHohner Jack B · Spokane Valley, WABuilt 1971 · S/N AA1A-0106N9207LLindquist Steve · Granite Falls, MNBuilt 1971 · S/N AA1A-0107N920BEGalaxy Aviation LLC · Nantucket, MABuilt 1979 · S/N 15283538N9210LMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N AA1A-0110N9212LSmith Randall G · Salem, ORBuilt 1971 · S/N AA1A-0112N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371N9214ATerhune Larry W · Saginaw, TXBuilt 1982 · S/N 38-82A0116N9215LDipietro Ian · Westfield, MABuilt 1971 · S/N AA1A-0115N9216LLawrence Guy A · Bakersfield, CAS/N AA1A-0116N9216TLudwigson Joel · Inver Grove Hts, MNBuilt 1978 · S/N 38-78A0279N92194Ace Aeromotive Inc · Miami, FLS/N 16635N9219LHart Gene E · Ridgecrest, CABuilt 1971 · S/N AA1A-0119N9222LTyler Timothy C · Wyoming, OHS/N AA1A-0122N9223LHogan Fredrick C · Oviedo, FLBuilt 1971 · S/N AA1A-0123N9224LAnalytical Technologies Inc · Miami, FLBuilt 1971 · S/N AA1A-0124N92258Mendez Leonel Jr · Corpus Christi, TXBuilt 1978 · S/N 38-79A0014N9225LTerry Mark B · Henderson, NCBuilt 1971 · S/N AA1A-0125N92296Raymes Billy F · Stedman, NCBuilt 1995 · S/N 200007N922AKSanderson David C · Fort Davis, TXBuilt 1978 · S/N 15281807N922WSWerth Jill · Canandaigua, NYBuilt 1973 · S/N 947-73N9232LLuquette Harley M · Abbeville, LABuilt 1971 · S/N AA1A-0132N9233LGreen Samuel B · Clifton Park, NYBuilt 1971 · S/N AA1A-0133N9235LKidd Jeffrey A · Norcross, GABuilt 1971 · S/N AA1A-0135N9237TVann Dudley C DBA · Greenville, NCBuilt 1978 · S/N 38-78A0286N923SASunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283708N9240LRollins Loftis J · Lakeland, FLBuilt 1971 · S/N AA1A-0140N9241LMurray Bradley R · Rockingham, NCBuilt 1971 · S/N AA1A-0141N9244LLanza Philip R Sr · Modesto, CAS/N AA1A-0144N9246LBeery Bruce M · Lakeland, FLBuilt 1971 · S/N AA1A-0146N924CSobrado Victor M · Norman, OKBuilt 1992 · S/N 002N924SAGiber Sharon G · New Port Richey, FLBuilt 1978 · S/N 38-78A0178N92508Pierce Stuart · Ridgefield, WABuilt 1946 · S/N 12-31
Back to AD 80-25-02 R2