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.

N786FMSantosaircraft LLC · Fort Lauderdale, FLBuilt 1979 · S/N 15283894N78702Celestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1947 · S/N 12-3981N78704Buhler Brian · Wasilla, AKBuilt 1947 · S/N 12-3963N78705Olsen Victor L · Nome, AKBuilt 1947 · S/N 12-3962N78708Davies Thomas V · Chula Vista, CABuilt 1947 · S/N 12-3984N7871Aderman Nick · Palmer, AKBuilt 1947 · S/N 12-3986N78713Hamilton Robert M · Saint Louis, MOBuilt 1997 · S/N HK002N78735Holt Bill R · Ralph, SDBuilt 1947 · S/N 11-1487N78772Egrass Robert Dean · Mc Grath, AKFirst renewal noticeBuilt 1947 · S/N 11-1550N78787Largent Walter S · Fairbanks, AKS/N 12-3948N7879HLorence Joshua J · Soldotna, AKBuilt 1946 · S/N 12-782N787EZKordel Kade France · Allen, TXBuilt 1985 · S/N 1217N787FMMelillo Vince · Belvidere, ILBuilt 1978 · S/N 15281802N78827Latshaw Elizabeth H · Catawba, NCBuilt 1947 · S/N 11-1601N78828Dotter Henry C · North Pole, AKS/N 11-1602N7883TMarlu Enterprises Inc · Foristell, MOBuilt 1991 · S/N 2211N7885HFisher Joel F IV · Rockville, MDS/N 12-788N7890HTwo Feathers Industries LLC · Baker City, ORFirst renewal noticeBuilt 1946 · S/N 12-794N7891AAce Aeromotive Inc · Miami, FLS/N 11-1466N7896HKiser Gerald S · Christiana, TNBuilt 1946 · S/N 12-798N7898HOdean Steve6663 · Palmer, AKS/N 12-802N78AKFreytag Ronald D · Stockton, CAS/N 075N78LLLawnchair Pilots Association LLC · Wilmington, DES/N SSVTS-001N78MTBrady William P · Banner, WYBuilt 1998 · S/N 199N78WSHjelmstad David J · Burnsville, MNBuilt 1978 · S/N 38-78A0179N7900HMartin Robert C · Farmington, MEBuilt 1946 · S/N 12-804N7906HCarter Sheradon Royce · Sumner, TXS/N 12-810N790LLetourneau University · Longview, TXBuilt 2011 · S/N 1408-2011N7914HJamrock Leasing LLC · Schenectady, NYBuilt 1946 · S/N 12-818N7915HHanna Bay Holdings LLC · Hayward, WIBuilt 1946 · S/N 12-819N791DSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 3879A1021N791JWilson Cliff · Harrison, IDS/N 633747N7921HLloyd Chelsea M · Wasilla, AKS/N 12-823N7924HBourland Kenneth C · Waller, TXBuilt 1946 · S/N 12-830N7925HMedary Thomas A · Corpus Christi, TXBuilt 1946 · S/N 12-831N792THbhis LLC · Gnadenhutten, OHS/N 1024 74N7930HMorris Sidney H · Kenai, AKBuilt 1946 · S/N 12-834N7933HNeal Clarence W · Markham, TXBuilt 1946 · S/N 12-836N793LLetourneau University · Longview, TXBuilt 2014 · S/N 1409-2014N7941HLugten John B · Walnut Creek, CABuilt 1946 · S/N 12-845N7949HButterfield Mike · Yakima, WAS/N 12-855N7955HHudson Tom J · Kasilof, AKBuilt 1946 · S/N 12-858N795LLetourneau University · Longview, TXBuilt 2023 · S/N 1413-2023N7961HCox James D Trustee · Maryville, MOBuilt 1946 · S/N 12-866N7964HParker Nathaniel C · Wasilla, AKS/N 12-869N7970HMcneill Steven H · Santa Fe, NMS/N 12-887N7972HAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1946 · S/N 12-875N7973HMessinger Donald C · Wasilla, AKBuilt 1946 · S/N 12-876N7977HMmwbc LLC · Hamilton, MTBuilt 1946 · S/N 12-873N7979HDeuling Jarrett R · Haines, AKS/N 12-864
Back to AD 80-25-02 R2