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.

N76XGreen Steven L · Fairbanks, AKBuilt 1948 · S/N 12-4036N7701HRenshaw Raymond E · Huntersville, NCBuilt 1946 · S/N 12-592N7703HWatt Ernie T · Scooba, MSS/N 12-594N7704SHolte Bruce C · Thief River Falls, MNBuilt 1976 · S/N 1172-76N7706HSgarrella William G Jr · Lovettsville, VABuilt 1946 · S/N 12-598N7708HJohnson Stephen C · Bonney Lake, WABuilt 1946 · S/N 12-600N7709HNewberg Curtis G · Willmar, MNS/N 12-601N7712HMiller Kevin T · Wasilla, AKBuilt 1946 · S/N 12-604N7719HBurks Richard H · Protem, MOBuilt 1946 · S/N 12-612N7721HRegistration Pending · Juneau, AKRegistration pendingS/N 12-614N7729HHayes Daniel S · Waupaca, WIS/N 12-1981N77396Galindo Don Ronald Jr · Walnut Grove, CABuilt 1946 · S/N 11837N7740HDrum Danny R · Anchorage, AKS/N 12-636N7743HDavis Lawrence J · Wasilla, AKBuilt 1946 · S/N 12-639N7744HCreglow Jacob A · Anchorage, AKBuilt 1946 · S/N 12-640N7748HTurnbull Douglas M · Bloomfield, NYBuilt 1946 · S/N 12-644N7753HMarvin Carlton R · Tomahawk, WIBuilt 1946 · S/N 12-651N7754HLa Paloma LLC · Bozeman, MTBuilt 1946 · S/N 12-652N7755HGoos Lynn · Aguila, AZFirst renewal noticeBuilt 1946 · S/N 12-653N7756HLarkin Marion J · Salome, AZBuilt 1946 · S/N 12-662N7758HDillon John · Waitsfield, VTBuilt 1946 · S/N 12-655N775JPWentworth Philip C II · Nashport, OHBuilt 1979 · S/N 38-79A0884N775VKoewler Stephen T · Sacramento, CABuilt 1975 · S/N 1EPKN7763HBrown F Wilson · Bedford, VAS/N 12-660N7764HVadakin Jeffrey M · Dover, DEBuilt 1946 · S/N 12-661N7765HT R C Inc · Fairbanks, AKBuilt 1946 · S/N 12-663N7769HCallahan Brian C · Marenisco, MIBuilt 1946 · S/N 12-669N7770HTregellas William B · Booker, TXBuilt 1946 · S/N 12-668N7775HDunshee Kevin G · Laluz, NMBuilt 1946 · S/N 12-673N7777HSale Reported · Jennings, LASale reportedBuilt 1946 · S/N 12-709N7779HRenfro Jacqueline L · Bethel, AKBuilt 1946 · S/N 12-677N7779JLehrkamp Mike C · Caputa, SDBuilt 1966 · S/N 536N777DJMartin Dale A · Lewiston, IDBuilt 1985 · S/N 1259N777HJBallantyne Benjamin J · South China, MEBuilt 1972 · S/N 841-72N777LKMathena Gregory H · Guilford, INBuilt 1980 · S/N LK-1N777MRRutherford Michael A · Medina, OHBuilt 1974 · S/N 1068-75N7781HMittelstadt Kevin J · Oakfield, WIBuilt 1946 · S/N 12-679N7785HR&L Enterprises · Highland, UTBuilt 1946 · S/N 12-683N778JHCurran Michael · Gallatin, TNBuilt 1980 · S/N WA-156N7795HSheard Thaddeus G · Saylorsburg, PABuilt 1946 · S/N 12-692N77DWTop Flight Detail LLC · Middlebury, INBuilt 1949 · S/N 16-287N77LFWallace Dustin A · Vacaville, CABuilt 1979 · S/N 1268N77PSClelland Belinda S Executor · Tucson, AZS/N 119N77XZRed Rocket Holding Co LLC · Boca Raton, FLS/N 38-78A0033N7801HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 12-698N7811HCatto Air LLC · Jackson, CABuilt 1946 · S/N 12-715N7813HBevan John E · Spokane, WAFirst renewal noticeS/N 12-711N7817HHalunen Arlie John Jr · Naples, NYBuilt 1946 · S/N 12-713N7818HWest Stephen T · Chapel Hill, NCBuilt 1946 · S/N 12-716N7828Lionel Long · Liberty, KYBuilt 1995 · S/N 373
Back to AD 80-25-02 R2