OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N3052TGrahn Rupert W · Sahuarita, AZBuilt 2003 · S/N 359 A-BN3056MGrald Jonathan A · New Hampton, NYS/N 12-1744N3058MMcguire Patrick · Greenleaf, WIS/N 12-1585N305DWPugleasa William Hunter · Lowell, ARBuilt 1982 · S/N 15285502N3061MSchmidt Anthony D Jr · Jordan, MNBuilt 1947 · S/N 12-1749N3062MRegistered aircraftS/N 12-1583N3067MKing Nolan · River Falls, WIBuilt 1947 · S/N 12-1754N3069MBrons Andrew S · Newfolden, MNBuilt 1947 · S/N 12-1755N306TWulle Bernard W · Battle Ground, INBuilt 1953 · S/N 18-2420N3071MTraverse Air Inc · Traverse City, MIBuilt 1947 · S/N 12-1757N3072MMunter Craig A · Fontana, WIBuilt 1947 · S/N 12-1758N30735Johnson Brent A · Oregon, ILS/N 5074N3074GOver The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 466N3076GFowler Gerald M · Hernando, FLBuilt 1968 · S/N 509N3080MSuper Cruiser LLC · Palm City, FLS/N 12-1768N3085MCooley Pamela C · New Durham, NHBuilt 1947 · S/N 12-1773N3088MFreeland Chris G · Brownwood, TXS/N 12-1777N3089MErickson Mark D · Valley Springs, SDBuilt 1947 · S/N 12-1778N308DW8dw LLC · Glendale, CABuilt 1985 · S/N 15285940N308TSchanilec Matthew J · Park River, NDBuilt 1953 · S/N 18-2422N3092MGeeslin James Welch III · Sterling, AKS/N 12-1781N3098MMorrison Robert H · Fort Denaud, FLBuilt 1947 · S/N 12-1784N309AAEvans Luis · Locust Grove, GABuilt 1968 · S/N AA1-0002N309TWest Coast Aircraft LLC · Carson City, NVBuilt 1953 · S/N 18-2423N30NAPerryman Ronald William · Purmela, TXS/N AA1C-0010N30VBukolsky Ivan · Silt, COBuilt 1955 · S/N 12-333N30WPBanquer Douglas J · Denham Springs, LABuilt 1983 · S/N 1236N30ZAJohn Caleb Aviation · Lafayette, LABuilt 1992 · S/N 200030N3100MHennessy John P · Bigfork, MTBuilt 1947 · S/N 12-1786N3101MThompson Curtis Lee · Chugiak, AKBuilt 1947 · S/N 12-1788N3102GTaylor Stephen G · Bixby, OKS/N GH-001N3102MCaldwell Bryan S · Litchfield Park, AZBuilt 1947 · S/N 12-1789N3103MTygart Michael J · Olive Branch, MSBuilt 1947 · S/N 12-1793N3108MGlover Thomas B · Marana, AZS/N 12-1796N310TManiatis Michael · Milton, NYS/N 18-2424N310UCMahoney Anthony J · Dorrance, KSS/N 8747N3111MGritzo Russell · Edgewood, NMBuilt 1947 · S/N 12-1799N3114MFarber Adam J · Odessa, TXS/N 12-1807N311ELashuay Donald I · Midland, MIBuilt 1946 · S/N 12-411N311TLark Aircraft Leasing · Port Townsend, WABuilt 1953 · S/N 18-2425N3123MLeroy Raymond S · Anchorage, AKBuilt 1947 · S/N 12-1823N31259Rowlett Jeffery B · Tuckerman, ARBuilt 1972 · S/N 883-72N3125BKinkema James A · Milwaukee, WIS/N 777N3125MSale Reported · Elizabeth, COSale reported, pending cancellationS/N 12-1825N31264Campbell Michael W · Hayden, ALS/N PT1149N31267Kieffaber Thomas M · Sagamore Hills, OHBuilt 1972 · S/N 887-72N31269Happenstance LLC · Cabot, ARBuilt 1972 · S/N 885-72N31281Citabria 1972 LLC · Soldotna, AKBuilt 1972 · S/N 888-72N31298Rivers Jerry M · Chesterfield, SCBuilt 1972 · S/N 891-73N3129MHaggstrom Daryl V · Fairbanks, AKBuilt 1947 · S/N 12-1819
Back to AD 80-25-02 R2