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.

N7829HGardom Brandon D · Spirit Lake, IDBuilt 1946 · S/N 12-729N7834HWilde Air Service-Huron LLC · Volga, SDBuilt 1946 · S/N 12-734N7841HCross Thomas Ad · Yacolt, WABuilt 1946 · S/N 12-741N7842HMcgregor Daniel A · Denali Park, AKS/N 12-742N7842SDoyle Terry W · Grapevine, TXBuilt 1976 · S/N 1173-76N78442Sullivan Darrell L · New Plymouth, IDBuilt 1947 · S/N 12-1953N78447Larson Larry L Trustee · Molt, MTBuilt 1947 · S/N 12-1957N78449Svendsen Gregory R · Anchorage, AKBuilt 1947 · S/N 12-1959N78450Gage Farms Inc · Stanberry, MOBuilt 1947 · S/N 12-1962N78453Sale Reported · None, OKSale reported, canceledBuilt 1947 · S/N 12-1963N78454Powell Sherman B · Falkville, ALBuilt 1947 · S/N 12-1964N78459Sutton George G · Richland Center, WIBuilt 1947 · S/N 12-1970N78465Rands Douglas W · Golden, MOBuilt 1947 · S/N 12-1976N7846HDebilt Spraying Inc · Berthold, NDS/N 12-746N78471Hinaman Arthur W · Locust Grove, GABuilt 1947 · S/N 12-1982N78480Vockner Max B · Girdwood, AKS/N 12-1990N78481Canoe Bay Outfitters LLC · Chugiak, AKBuilt 1947 · S/N 12-1992N7848HTruly Ty B · Monroe, WABuilt 1946 · S/N 12-748N78492Hamilton Fred C · Fairbanks, AKBuilt 1947 · S/N 12-3903N78495Forbes James A · Monkton, MDBuilt 1947 · S/N 12-3906N78496Starnes James · Beaufort, SCBuilt 1947 · S/N 12-3907N78497Hudson Thomas D · Lagrange, GABuilt 1947 · S/N 12-3908N7849HWelch Troy O · Graford, TXBuilt 1946 · S/N 12-749N785Noonan Kenneth R · Altoona, PAS/N 1156N78532Resop Jason L · Chandler, AZS/N 12-3914N78535Langrell Sterline S · Aurora, ORBuilt 1947 · S/N 12-3916N78536Jazun Carlos Walter · Parker, COBuilt 1947 · S/N 12-3917N78541Ayres Jon S · Ijamsville, MDBuilt 1947 · S/N 12-3919N78546Haeuser Edwin J · Rochester, MNFirst renewal noticeBuilt 1947 · S/N 12-3922N78547Jerry Luttrell And Associates Inc · Kearney, MOBuilt 1947 · S/N 12-3923N78554Sullivan Shaun K · Midwest City, OKFirst renewal noticeBuilt 1947 · S/N 12-3929N78555Schultes James F Jr · West Deptford, NJBuilt 1947 · S/N 12-3930N78561Gayler Larry · Thermal, CABuilt 1947 · S/N 12-2645N78565Sousa Gerald L · Talkeetna, AKBuilt 1947 · S/N 12-3940N78567Frazier Forrest Alan · Taylors, SCS/N 12-3942N78573Hohmann Courtney P · Jacksonville, FLBuilt 1947 · S/N 12-3949N7857HCompton Delmer Dale Jr · Pocahontas, ILBuilt 1946 · S/N 12-758N78581Weber Jacob H · Hartford, WIS/N 12-3967N78582Gibbs Luther A · Fremont, OHBuilt 1947 · S/N 12-3968N78586Krup Inc · Milligan, NEBuilt 1947 · S/N 12-3972N78588Mackey Jacob E · Big Piney, WYS/N 12-3957N78589Sanstead Peter N · Tulsa, OKBuilt 1947 · S/N 12-3956N78594Pyne James L · Streator, ILFirst renewal noticeS/N 12-3975N7859HSly Duane D · Platte, SDBuilt 1946 · S/N 12-760N785GMJanssen Daniel P · Dayton, ORBuilt 2016 · S/N 10785N7860HCrockett Donald Richard · Artesia, NMBuilt 1946 · S/N 12-761N78635Horn Adriane L · Kodiak, AKBuilt 1947 · S/N 11-1396N7864HDevil Dusters Inc · Artesia, NMS/N 12-767N78667Rendel James L · Rock Hill, SCBuilt 1947 · S/N 11-1428N78685Smith James A · Lyle, WAS/N 111446
Back to AD 80-25-02 R2