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.

N401VFSchoenberger Neil J · Saint Petersburg, FLBuilt 2013 · S/N 91486N4021HToth Richard C · Tinley Park, ILBuilt 1947 · S/N 12-3448N4022MBeautte James Edward · Fairland, OKBuilt 1947 · S/N 12-2899N4023LCenteno Ramon A · Oak Creek, WIBuilt 1973 · S/N AA1B-0267N4023MObrien William D · Duluth, MNBuilt 1947 · S/N 12-2905N4024MSale Reported · Monroeville, ALSale reportedS/N 12-2909N4026HParker Gerald L · Stevensville, MDBuilt 1947 · S/N 12-3454N4027HEhrenfelt Linda Mae · Pierre, SDBuilt 1947 · S/N 12-3455N4027MBoyle Fred W · Cape May, NJBuilt 1947 · S/N 12-2911N4028HSanoski Gregory G · Talkeetna, AKBuilt 1947 · S/N 12-3456N4029MCochrane Timothy A · Chippewa Lake, OHS/N 12-2913N4030MVan Bortel Howard G · Victor, NYBuilt 1947 · S/N 12-2914N4038HWilliams Rourke Co · Fairbanks, AKBuilt 1947 · S/N 12-3465N4039HReese William A Jr · Waynesboro, TNBuilt 1947 · S/N 12-3466N4039MTodd Gary L · Kasilof, AKBuilt 1947 · S/N 12-2922N4040HDevil Dusters Inc · Artesia, NMBuilt 1947 · S/N 12-3467N4041MSessions John L · Kirbyville, TXBuilt 1947 · S/N 12-2924N4043HWeggel Roger F · Fairbanks, AKS/N 12-3470N404ZMuehlberg Stephen E · Newcastle, OKBuilt 2025 · S/N 75-10404N4052AWard Daniel W · Boonville, NCBuilt 1979 · S/N DV0100N4057MUsac Airways 693 LLC DBA · Fort Lauderdale, FLBuilt 1947 · S/N 12-2940N4060MStall Aero LLC · Burnsville, MNBuilt 1947 · S/N 12-2943N4064QPasseno Mark A · Cheboygan, MIBuilt 2002 · S/N 296N40700Nelson Krista K · Cedar Falls, IABuilt 1941 · S/N 5-1132N4071MHigh Exposure Inc · Wilmington, DEBuilt 1947 · S/N 12-2954N40720Luthe Carl E · Austin, MNBuilt 1941 · S/N 5-1152N4075HWessel Paul Rinehardt · Honolulu, HIS/N 12-3506N4076MBendza Matthew J · Bonner, MTBuilt 1947 · S/N 12-2958N4077MSummers Gary D · Rexburg, IDBuilt 1947 · S/N 12-2959N40803R&Cb Aviation LLC · Shelby, NCBuilt 1941 · S/N 7500N4080HEarle Brian S · Two Rivers, AKBuilt 1947 · S/N 12-3508N4086KRobinson Mark V · Vacaville, CABuilt 1966 · S/N 1N4089MViens Ernest W · Eagle River, AKBuilt 1947 · S/N 12-2978N408EZKoester David P · Newport, ORS/N 709N408JNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1966 · S/N 58N40940Williams Richard S · Longview, TXBuilt 2009 · S/N TB-001N4094MVaughn Charles M · Titusville, FLBuilt 1946 · S/N 12-3028N409WMKlink John A Jr · Farmington, PABuilt 2012 · S/N 66870N40EBWegman Jacob L · Rochester, MNBuilt 1985 · S/N 984N40EZMaui Aero LLC · Yelm, WAS/N 69N40HDDrollinger David H · Kennewick, WABuilt 1987 · S/N 040N4103MMills Air Service Inc · Marstons Mills, MABuilt 1947 · S/N 12-3000N4105MMameli Laurie K · Thomaston, GABuilt 1947 · S/N 12-2999N4109HSchamber Thomas D · Oklahoma City, OKS/N 12-3545N410BBBranscomb Brian K · El Granada, CABuilt 1985 · S/N 856N4110YHeiderscheidt Cory · Sleepy Eye, MNBuilt 1976 · S/N 1175-76N4111HWhalen Mark P · Millington, MDBuilt 1947 · S/N 12-3547N41171Wilco Aviation LLC · Jonesboro, ARS/N 735-70N4121MMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1947 · S/N 12-3019N4121YStotts Jimmy W · Jonesboro, ARBuilt 1976 · S/N 1176-76
Back to AD 80-25-02 R2