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.

N5361HNall Melvin J · Luthersville, GABuilt 1949 · S/N 16-168N5364POwens Flight Training LLC · Lafayette, LABuilt 1981 · S/N 15284929N5364ZHughes Tony W · Irmo, SCBuilt 1961 · S/N 22-9094N5365HVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1949 · S/N 16-171N5366HShannon Harry D · Bartow, FLBuilt 1949 · S/N 16-173N5366MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284566N5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1961 · S/N 22-9099N5368MPacific Union College · Angwin, CABuilt 1980 · S/N 15284567N5368ZTevik Michael A · Provo, UTBuilt 1961 · S/N 22-9100N5369HValdiosera Octavio · Tracy, CABuilt 1980 · S/N 15284094N536CBZelner Gregory · Merritt Island, FLS/N 200015N5370HGodec David E · Waunakee, WIBuilt 1949 · S/N 16-177N5371HMacdonald Randall N · Weidman, MIBuilt 1949 · S/N 16-178N53740Gardner Robert J · Orwigsburg, PABuilt 2004 · S/N 1211N53745Speth Kerry G · Oak Harbor, WAS/N 1111-75N5374ZMyers Kenneth Jerome · Haines, ORBuilt 1961 · S/N 22-9140N53764Push To Talk Aviation LLC · Burr Ridge, ILBuilt 1975 · S/N 1112-75N53769Holcomb Garry · Greenville, TXS/N 1113-75N53773Brock Edwin G · Hawthorne, FLBuilt 1975 · S/N 1114-75N5377HSchmid Gerhard G · New Smyrna Beach, FLBuilt 1949 · S/N 16-183N5377ZTurner Edward J III · Mokena, ILBuilt 1961 · S/N 22-9139N53781Hayden Aviation LLC · Rhome, TXBuilt 1975 · S/N 1116-75N5378BDraper Floyd L · El Paso, TXBuilt 1979 · S/N 15283855N5379ZMcelwee Glenda A · Lake City, FLS/N 22-9146N537NMasure Jason F · St Helena Is, SCBuilt 1979 · S/N 38-79A0428N53801Stegman Edward L · Oceanside, CABuilt 1975 · S/N 1119-75N53804Bell Cody R · North Pole, AKBuilt 1975 · S/N 1120-75N5380HBaughman Neil F · Harrisburg, PABuilt 1949 · S/N 16-187N5380ZHerrema James M · Fountain, MIBuilt 1961 · S/N 22-9147N5381ZRasmussen Mark · Hogeland, MTBuilt 1961 · S/N 22-9149N53823Ferguson Carrie L · Palo Alto, CABuilt 1975 · S/N 1126-76N5382HZefting Brett M · Bellingham, WAS/N 16-189N53832Kalis Dakota E · Blue Earth, MNBuilt 1975 · S/N 1127-76N53836Tailwheel Solutions LLC · Chagrin Falls, OHBuilt 1975 · S/N 1124-75N5383MSunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15284572N53847Driftless Aviation LLC · Burlington, WIBuilt 1975 · S/N 1128-76N5384HDeleon Joseph M · Saint Petersburg, FLBuilt 1949 · S/N 16-191N5384PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284934N53852Cohran Enterprise LLC · Pineville, LABuilt 1975 · S/N 1129-76N53855Messmore Michael H · Toledo, WAS/N 1149-76N5386HMcwhorter Ag LLC · Searcy, ARS/N 16-193N5386ZKetcham Blake L · Turtle Creek, PABuilt 1961 · S/N 229154N53871Walker Benjamin L · Muscle Shoals, ALBuilt 1975 · S/N 1133-76N53872May Chris H · Owensboro, KYBuilt 1975 · S/N 1134-76N53874Sloan Donald W · Dover, DEBuilt 1975 · S/N 1135-76N5387BHuffman Jacob M III · Burleson, TXBuilt 1979 · S/N 15283857N5387CGoral William W · Redlands, CABuilt 1950 · S/N 15520N5387ZHester Nathan A · El Centro, CABuilt 1961 · S/N 22-9156N53887Lawson Bradley K · Plymouth, MIBuilt 1975 · S/N 1138-76N5388HRamsey Brian D · Van Nuys, CABuilt 1949 · S/N 16-195
Back to AD 80-25-02 R2