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.

N3848MHogan Resources Inc · Bedford Hills, NYBuilt 1947 · S/N 12-2570N38498Hinckley David D · Belton, TXBuilt 1941 · S/N 5-984N3851MSyverson Michael B · Waubun, MNBuilt 1947 · S/N 12-2571N3851ZPurcell Jmes Patrick III · Bayville, NJBuilt 1981 · S/N WA-241N3852MSkluzacek Paul D · Prescott, WIBuilt 1947 · S/N 12-2765N38532Fellman Lukas H · Anchorage, AKS/N 5-1394N3853MSly Duane A DBA · Platte, SDBuilt 1947 · S/N 12-2766N3857DGill Michael T · Little Rock, ARS/N WA-248N3857MRyans Float Flying LLC · Canby, ORS/N 12-2574N385PMurphy Patrick · Brooksville, FLBuilt 1978 · S/N 15281108N385SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282997N3860BFlight Club LLC · Middle River, MDS/N WA-273N3860MMasek Lawrence J Jr · Cuyahoga Falls, OHBuilt 1947 · S/N 12-2770N38634Engler Eric M DBA · Cass City, MIBuilt 1941 · S/N 5-1018N3866MKirk Robert C · Chandler, AZBuilt 1947 · S/N 12-2775N3868JParker Fred E · Portola, CABuilt 1981 · S/N WA-258N3868KBeaver Mark · Valparaiso, INBuilt 1981 · S/N WA-259N38698Worldwide Technical Services Inc · Bulger, PABuilt 1941 · S/N 5-1055N3869MJohnson Don S · Sterling, AKBuilt 1947 · S/N 12-2784N3870UJsn Aviation LLC · Huntersville, NCBuilt 1981 · S/N WA-260N3874MGott Michael · Fairbanks, AKBuilt 1947 · S/N 12-2785N3875MSky Ad Inc · Greenwich, CTBuilt 1947 · S/N 12-2786N3881MBaratto John Maynard · Cohasset, MNS/N 12-2779N3882MBrabson Andrew R · Eagle River, AKBuilt 1947 · S/N 12-2778N3888MBennett Rhonda R · Callaway, NEBuilt 1947 · S/N 12-2792N3889MSeitenreich William F Jr · Wasilla, AKBuilt 1947 · S/N 12-2581N388ZThornburg Steven D · Northville, MIBuilt 1997 · S/N 095N3891MHall David B · Newburg, NDBuilt 1947 · S/N 12-2793N3896MBehm Jerome William · Burlington, NDBuilt 1947 · S/N 12-2796N3898MCosta Air Service LLC · Painted Post, NYS/N 12-2798N38HSHenderson State University · Arkadelphia, ARBuilt 1997 · S/N 1366-98N38PRK&M Industry LLC · Winston Salem, NCS/N 38-78A0780N38SURiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15285144N38ZAHagen Jerald L · Welcome, MNBuilt 1998 · S/N 200038N39006Captain Someday Inc · Wilmington, DES/N AA1C0180N39007Cooper Sean Patrick Whittington · Walnut Creek, CABuilt 1978 · S/N AA1C0181N3900MStewart Stewart D · South Egremont, MABuilt 1947 · S/N 12-2799N39010Askew Stell B III · Durham, NCS/N AA1C0183N39014Stegmann Scott A · Port Orange, FLFirst renewal noticeBuilt 1978 · S/N AA1C0184N39016Fortnight Aviation LLC · Philadelphia, PABuilt 1978 · S/N AA1C0185N39020Diegoli John E DBA · Camp Connell, CABuilt 1978 · S/N AA1C0188N39021Landes Charles · Independence, ORS/N AA1C0189N39022Hetem Steven · Atlantic Highlands, NJBuilt 1978 · S/N AA1C0190N3902MVigdal Carl B · Keller, TXBuilt 1947 · S/N 12-2801N39030Wright Thomas · Bend, ORBuilt 1978 · S/N AA1C0193N39038Stansberry Charles A · Saint Charles, MOBuilt 1978 · S/N AA1C0197N3903MNaugle Anthony · Schellsburg, PABuilt 1947 · S/N 12-2802N39043Mcmahon Jamin T · Gig Harbor, WABuilt 1978 · S/N AA1C0201N39046Paradis Robert J · Jackson, CABuilt 1978 · S/N AA1C0176N3904MCowan Drew P · Anchorage, AKBuilt 1947 · S/N 12-2803
Back to AD 80-25-02 R2