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.

N2320VAlpha Aviation Holdings Group LLC · Raleigh, NCS/N 38-82A0040N2322MJohnson Walter H · White Stone, VABuilt 1946 · S/N 12-1482N2324DGrove Thomas T · Midlothian, TXBuilt 1978 · S/N 38-79A0274N2324GHadley Everett F · Dayville, CTBuilt 1979 · S/N 38-79A0497N2325MSharp Frank J DBA · Windermere, FLBuilt 1946 · S/N 12-1491N2326EKirk Jeff R · Colorado Springs, COBuilt 1978 · S/N 38-78A0443N2326MNapoleon Christopher D · Allegany, NYBuilt 1946 · S/N 12-1490N2326NDilts Airplane Leasing LLC · Wichita Falls, TXBuilt 1979 · S/N 38-79A0790N2327KForrest John L · Weatherford, TXS/N 38-79A0576N2327MPence Dale E · Richmond, MOBuilt 1946 · S/N 12-1390N2328CZimmerman Jeremy Jerard · Riverside, CAS/N 38-79A0154N2328KWilliams Robert W · Lees Summit, MOS/N 38-79A0577N2328MDraveliing Larry J · Wasilla, AKBuilt 1946 · S/N 12-1483N2329MWard Doran L · Glennallen, AKBuilt 1946 · S/N 12-1391N232WWells Garry L · Scotia, NEBuilt 1946 · S/N 12-701N2330DDemeyer Garrett J · Fort Walton Beach, FLBuilt 1978 · S/N 38-79A0276N2330MSquiers Jeffrey S · Independence, MNS/N 12-1393N2331PGamble Caleb · Rock Hill, SCS/N 38-79A0948N2333PHuffman Marshal · Spruce Pine, NCBuilt 1979 · S/N 38-79A0949N2337BJohnson John Jay · Wasilla, AKBuilt 1978 · S/N 3637N2339LVadnais Dennis J Sr · Fort Edward, NYBuilt 1979 · S/N 3879A0728N233RJJohnson Richard Lee · Topeka, KSS/N 233N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714N2341MMarcum Raymond A · Anchorage, AKS/N 12-1604N2341PJohnson Freddie III · Stafford, VAS/N 38-79A0952N2344MHershey Eric F · Wasilla, AKBuilt 1946 · S/N 12-1485N2346MHendrickson Gary A DBA · Gold Beach, ORS/N 12-1609N2346VGauvreau Paul J · Lafayette Hill, PABuilt 1981 · S/N 38-82A0058N2348BHuff Michael W · Fair Grove, MOBuilt 1978 · S/N 38-79A0020N2348FBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 38-79A0400N2348MSurgent Richard L · Wall Township, NJBuilt 1947 · S/N 12-1607N2349LPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0729N2349MMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 12-1494N234SCScholey Alex M · Woodland, CAS/N 286N234WYEdgeington Randall K · Riverton, WYBuilt 2013 · S/N S9910-0221N2351AChapman Thomas N · Harvard, ILBuilt 1978 · S/N 38-78A0649N2351TAc Holdings II Inc · Arlington, TXS/N 38-78A0778N2352PFriedman Samuel · Tamuning, GUS/N 38-79A0957N2354PS M R Racing & Aviation Inc · Wilmington, DEBuilt 1979 · S/N 38-79A0960N2355AScott Wilson A · Norman, OKBuilt 1978 · S/N 38-78A0650N2357PDix Walter R Jr · Winter Haven, FLBuilt 1979 · S/N 38-79A0961N2359DRobbins Aviation LLC · Moravia, NYS/N 38-79A0281N235ACLetourneau University · Longview, TXBuilt 2005 · S/N 1394-2005N235AUNorcross Ashley S · Anchorage, AKS/N 22-9772N235BDDondi Beda C · Fort Lauderdale, FLBuilt 2011 · S/N 1686NN235ECMoore Dylan D · Lakeville, MABuilt 2011 · S/N 1001N235FBFlorida Power And Light · West Palm Beach, FLBuilt 2021 · S/N TRC0001N235GHHunter Gary A · Lake Jackson, TXBuilt 1984 · S/N 1855N235JWMax Power Aircraft LLC · Kenosha, WIBuilt 2008 · S/N 059N235KMckinney Steve R · Hamersville, OHBuilt 2005 · S/N 2
Back to AD 80-25-02 R2