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.

N5203ZWeigel Gary R · Valley City, OHBuilt 1961 · S/N 22-8873N5204ZGodbey Patrick E T · St Simons Island, GABuilt 1961 · S/N 22-8874N5206HMccallum Michael C · Delta, COBuilt 1949 · S/N 16-7N5206MAeropaws Aviation LLC · Front Royal, VABuilt 1980 · S/N 15284504N5206ZFord Dustin D · Clear Brook, VABuilt 1961 · S/N 22-8876N5208HSweet Richard S · Prior Lake, MNBuilt 1949 · S/N 16-10N5208ZArnold Tyler S · Montgomery, LAS/N 22-8878N5209HCook James F · Portland, ORBuilt 1949 · S/N 16-11N5212ZYetter Mark A · Georgetown, PABuilt 1961 · S/N 22-8884N5214HVagabond Flight Corporation · Decatur, ILBuilt 1949 · S/N 16-15N5215HDavis Ted E · Brodhead, WIBuilt 1949 · S/N 16-17N5216HWatkins John W · Somers, CTBuilt 1944 · S/N 16-18N5219XBlack Mark A · Lawsonville, NCBuilt 1969 · S/N 695N5219ZGarrett Joe · Saint Jacob, ILBuilt 1961 · S/N 22-8894N521QJJacobi John W · Fort Collins, COBuilt 2016 · S/N 001N5220MCummings Brian · Opelousas, LABuilt 1980 · S/N 15284506N5222HDavidson Gerald W · Okatie, SCBuilt 1949 · S/N 16-24N5222ZSaltzman John D · Gilbert, AZBuilt 1961 · S/N 22-8897N5223HSzorek Evelyn Personal Representative · Fairbanks, AKBuilt 1949 · S/N 16-25N5223LN5223l LLC · Cheyenne, WYBuilt 1980 · S/N 15284279N5225ZLamon Bruce G · Castle Rock, WABuilt 1961 · S/N 22-8901N5226HJockos Sleigh LLC · Fort Worth, TXBuilt 1949 · S/N 16-28N5226ZHale Michael E · Grass Valley, CABuilt 1961 · S/N 22-8902N52271Horizon Aviation · Seneca, PABuilt 1945 · S/N 860N5227HBowman Brent W · Sebewaing, MIS/N 16-31N5227ZPayne Robert A · Duluth, MNBuilt 1961 · S/N 22-8903N5229BPisha Vincent R · Kendall, WIBuilt 1979 · S/N 15283812N522EZSkyjiro Forge Corp · Artesia, CANon-citizen corporation, flight hours not reportedS/N 522N5230HSeneca Aeronautical Services LLC · Wilmington, DES/N 16-34N5231ZKawasaki Clyde H · Carson City, NVS/N 22-8908N5232ZGilmore Thomas E · Mesa, AZBuilt 1961 · S/N 22-8910N5233PAero Quest LLC · Olive Branch, MSBuilt 1981 · S/N 15284898N5233RVranicar Franklin E · Corona Del Mar, CABuilt 1946 · S/N 7AC-6567N5234XZonneveld Case M · Hanford, CABuilt 1969 · S/N 684N5235HMoore Jeffrey D · Cleveland, NYBuilt 1949 · S/N 16-39N5235XOrtu Gerard · East Hanover, NJBuilt 1969 · S/N 698N5236HCarter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15284070N5236ZPlank Larry B · Perkins, OKBuilt 1961 · S/N 22-8916N5238ZMayer David J · Ingleside, ILS/N 22-8918N5239BGanim Rose B · Haydenville, MABuilt 1980 · S/N 15284366N5239ZMellor Brad A · Spanish Fork, UTBuilt 1961 · S/N 22-8919N523EZJackmond Matthew B · Olympia, WABuilt 1994 · S/N 865N5240HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 16-44N5240XPaulson Ricky R · Hudson, WIBuilt 1969 · S/N 703N5240ZReise Robert A · Meredith, NHBuilt 1961 · S/N 22-8920N5241PAtwater John G · Vero Beach, FLS/N 15284899N5241QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285088N5242HJohnson Steven D · Oklahoma City, OKFirst renewal noticeBuilt 1949 · S/N 16-46N5242XMilone Colin B · West Glacier, MTS/N 182N5242ZLund Thomas S · Boulder, COBuilt 1961 · S/N 22-8924
Back to AD 80-25-02 R2