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.

N5741LWienclaw David E · Boise, IDBuilt 1969 · S/N AA1-0141N57420Florida Man Aviation LLC · Saint Petersburg, FLBuilt 1973 · S/N 942-73N5742LGjorvad Steven A · Punta Gorda, FLS/N AA1-0142N57430Swanson Michael D · Council Bluffs, IABuilt 1973 · S/N 944-73N5743LHead William J · Verona, KYBuilt 1969 · S/N AA1-0143N57440Frankel Daniel A · Madison, OHBuilt 1973 · S/N 946-73N5745HManos Theodore W II · Omaha, NEBuilt 1949 · S/N 16-358N57461Hall Willard · Beaumont, TXBuilt 1973 · S/N 949-73N57469Miller Christopher A · Chico, CABuilt 1973 · S/N 951-73N57474Harding William R Jr · Quinlan, TXBuilt 1973 · S/N 950-73N57481Bartels Pamela K · Marion, NCBuilt 1973 · S/N 952-73N5749NPickerell Brian E · Longmont, COBuilt 1955 · S/N 0003N5749ZTroy Michael J · Albion, NYBuilt 1963 · S/N 22-9588N5750ZFaux George F 11 · Newcastle, MEBuilt 1963 · S/N 22-9592N5751LWoodward Stephen · Fountain Hills, AZBuilt 1972 · S/N AA1B-0051N5752LLamas Frank A · Brackettville, TXBuilt 1972 · S/N AA1B-0052N5753HLindberg Samuel L · Odebolt, IAS/N 16-364N5754HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-365N5754ZKumley William A · Camarillo, CABuilt 1963 · S/N 22-9596N5755ZSkibinski James J · Senoia, GABuilt 1963 · S/N 22-9597N5757HWahlquist Andrew J · Honey Grove, TXBuilt 1949 · S/N 16-369N5758ZColt 135 LLC · Lexington, NEBuilt 1963 · S/N 22-9600N5759ZBuds Auto Parts Ltd · Gowen, MIBuilt 1963 · S/N 22-9601N575WAKnapczyk Brian D · Apopka, FLBuilt 1984 · S/N 575N5760HPickering Jarold A · Columbus, KSBuilt 1949 · S/N 16-372N57627Foothill Sport Aviation LLC · Cameron Park, CABuilt 1973 · S/N 986-74N5762ZGulley Gordon L · Manteno, ILS/N 22-9604N5763ZCarlton Marvin R · Tomahawk, WIBuilt 1963 · S/N 22-9605N57646Turner Steven G · Clearwater, KSBuilt 1973 · S/N 991-74N5764LBanks Jeffery L · Pensacola, FLBuilt 1969 · S/N AA1-0164N5764ZModra Anthony K · Fredonia, WIS/N 22-9606N57655Bekanich Jason · Camden, NCBuilt 1973 · S/N 993-74N57661Hornbeck Richard L · Bowdoinham, MEBuilt 1973 · S/N 996-74N57674Benton Timothy C · Lepanto, ARBuilt 1973 · S/N 998-74N5767HSereg John Michael · Indianola, IABuilt 1949 · S/N 16-381N5768HHatton George L · Talihina, OKBuilt 1949 · S/N 16-380N5768LWilliams Charles J · Murfreesboro, TNBuilt 1969 · S/N AA1-0168N57694Bishop David DBA · Butlerville, INBuilt 1973 · S/N 1000-74N5769ZFox John F Jr · Mc Cormick, SCS/N 22-9611N5770HBellino Dominic P · Florence, COBuilt 1949 · S/N 16-386N5771ZDavenport Brad E · Eagle River, AKBuilt 1963 · S/N 22-9613N5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeBuilt 1949 · S/N 16-385N5774LHickman Robert D · Mobile, ALS/N AA1-0174N5774ZLiming Danny O · Andrews, TXS/N 22-9610N5776HMastre Joshua M · Soldotna, AKBuilt 1949 · S/N 16-389N5776LCollins Timothy · Northfield, MNBuilt 1969 · S/N AA1-0176N5777LSessums David L · Seabrook, TXBuilt 1969 · S/N AA1-0177N5778ZWhelan Cynthia Vs · Seneca, SCBuilt 1963 · S/N 22-9623N5779HKelly David L · Pendleton, ORBuilt 1949 · S/N 16-395N5779ZSvec Adolph R · Marengo, ILBuilt 1963 · S/N 22-9624
Back to AD 80-25-02 R2