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.

N69232Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282575N69238Hall David D · Des Moines, WABuilt 1978 · S/N 15282579N69247Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282583N692SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282577N693ARFlexfly LLC · Las Vegas, NVS/N 15282613N6969WJones Robert · Winter Haven, FLBuilt 1965 · S/N 28-21166N6972HWoodstock Aviation LLC · Anchorage, KYBuilt 1946 · S/N 20214N697FCBlackhawk Holding Corp · Wilmington, DES/N 726-70N69AAStauber Michael G · Manhattan Beach, CABuilt 1987 · S/N 436N69KVNichols James D DBA · Williamson, GABuilt 1974 · S/N AA1B-0409N69NDShannon Christopher R · Nome, AKS/N 2204N6ADBurchinal Issac Newton · Paris, TXS/N 12-730N6CGHarvey Benjamin A · Mountain View, CABuilt 1995 · S/N 310N6DSSmith Dwight K · Canby, ORBuilt 1961 · S/N 22-8898N6FARichards Donald D Jr · Cookeville, TNBuilt 1972 · S/N AA1A-333N6QKRobb Jeffery A · Hebron, OHBuilt 1982 · S/N WA-306N6YEExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1997 · S/N 2557N700PAW Patrick Enterprises Inc · Wilmington, DEBuilt 1946 · S/N 12-1400N70139Plyler Aviation Lp · Sherman, TXS/N 17118N701HGGeorgia Aviation Authority · Eastman, GABuilt 1997 · S/N 1365-97N7020ZMeyering Clinton · Southgate, MIBuilt 1985 · S/N S18N70267Evans Michael J · Rowlett, TXBuilt 1946 · S/N 17248N7034KMorrison Robert H · Fort Denaud, FLBuilt 2003 · S/N 2756N7047QRivera Juan R · San Antonio, TXBuilt 1989 · S/N 73N70555Hecht Waldo E · Vassar, MIBuilt 1946 · S/N 17564N705DCDoucette Patrick S · Malta, MTBuilt 2004 · S/N 5N7060KMaxson Lee V · Mesa, AZS/N 20-176N70643Flying S Ranch LLC · Adrian, MOBuilt 1946 · S/N 17661N70659Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 17679N706LGRegistered aircraftBuilt 1972 · S/N AA1A0414N70718Youkey John N · Yuma, AZBuilt 2003 · S/N 037N7072LPolsin Thomas H · Lowell, WIBuilt 1993 · S/N 05N70739Morey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 15282595N707GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279648N707RRRudd David L · Asotin, WABuilt 2025 · S/N 12345N7088AChocolas John · Redding, CABuilt 2004 · S/N TM-27N70HALong David A · Yamhill, ORBuilt 1998 · S/N 19250N71039Stan Lucian M · Sacramento, CAS/N 18060N7106KClark Patrick C · Charlotte, NCBuilt 1950 · S/N 18-322N7109KSheffield Vana Riggs Executrix · Amarillo, TXS/N 18-328N710TLBarker John Van · Smyrna, GABuilt 2007 · S/N 1398-2007N7110LNorris Bobby L · Ocala, FLBuilt 1976 · S/N AA1B-0610N7115KHuseby Terry L · Hulett, WYBuilt 1950 · S/N 18-333N7117KKlutsch Joseph R · King Salmon, AKS/N 18-340N711GJohnson Harold V · Bayfield, COBuilt 1968 · S/N 5822-40N7122KMacleod Gary G · Valentine, NES/N 18-335N7124KBlackburn Douglas W · Auke Bay, AKBuilt 1950 · S/N 18-342N7134KMcalister Mark H · Medford, ORBuilt 1950 · S/N 18-352N713CMLevy Jeremy · Apopka, FLBuilt 1947 · S/N 12-3915N7140BEstep James B · Chillicothe, OHBuilt 1977 · S/N A1520740
Back to AD 80-25-02 R2