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.

N36336Mierzejewski Karl · State College, PABuilt 1973 · S/N 965-73N36349Richardson Thomas R · Valleyford, WABuilt 1973 · S/N 967-73N36353Mcbride Mark · Sutton, MABuilt 1973 · S/N 968-73N3635MSomd Seaplanes LLC · Lexington Park, MDBuilt 1947 · S/N 12-2479N3638MWadlington Robert S · Colorado City, COBuilt 1947 · S/N 12-2482N3640MDeaton Mark A · Gig Harbor, WABuilt 1947 · S/N 12-2495N36412Martinsen John James · Aberdeen, WABuilt 1973 · S/N 970-73N3647MMeier Wayne N · Eagan, MNBuilt 1947 · S/N 12-2600N3648MWatercub LLC · Minnetonka, MNBuilt 1947 · S/N 12-2605N364DCClowes Delbert · Shafter, CABuilt 2014 · S/N 75-7639-001N3650MJarvis Ty N · Kinnear, WYBuilt 1947 · S/N 12-2603N3651MAtlanta Airmotive Inc · Franklin, NCBuilt 1947 · S/N 12-2601N3651NGreer Guy A · Wasilla, AKS/N 12-1902N3652MSorensen Parker J · Homer, AKBuilt 1947 · S/N 12-2602N3654MLunoe Finn · Anchorage, AKBuilt 1947 · S/N 12-2526N3654ZSandland Christopher A · North Pole, AKBuilt 1959 · S/N 18-7184N3658MHowker John A · Louisville, KYBuilt 1947 · S/N 12-2608N3658NUnivair Aircraft Corp · Aurora, COBuilt 1947 · S/N 12-1911N3660NJinnette Michael E · Lafayette, COS/N 12-1909N3662MKerzen Properties LLC · Fayetteville, ARBuilt 1947 · S/N 12-2613N3662NLarsen Kevin L · Firth, IDBuilt 1947 · S/N 12-1913N3663Carter Jay M · Mountain Home, ARBuilt 2017 · S/N C75-10112N3665MErnie Hall Aviation Museum Inc · Warren, OHBuilt 1947 · S/N 12-2530N36671Kiefer Karl F · The Woodlands, TXBuilt 1973 · S/N 002N3667NLong Michael C · Seattle, WABuilt 1946 · S/N 12-1918N3668NConnors Sean P · Tampa, FLS/N 12-1919N3669MMitrzyk Gary L · Anchorage, AKBuilt 1947 · S/N 12-2621N3671NTin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-1922N36747Gavagan Harold R Jr · Chandler, AZS/N 8147N3674MHunt James D · Seneca, SCFirst renewal noticeBuilt 1947 · S/N 12-2624N3675MSchwietz Thomas · Strasburg, VAS/N 12-2625N3676NAbrams John E · Eagle River, AKBuilt 1947 · S/N 12-1927N3680MStadman Tyrel W · Eagle River, AKBuilt 1947 · S/N 12-2631N3684MWood Jeannette C · Raeford, NCBuilt 1947 · S/N 12-2632N3689KAirspace Aerial Media LLC · Saint Louis, MOBuilt 1946 · S/N 22380N3693NLucky 20 Gourmet And Adventure Club LLC · Syracuse, INBuilt 1947 · S/N 12-1943N3696NCentral Virginia Flyers LLC · Palmyra, VABuilt 1947 · S/N 12-1947N3697MOrtland Tanner Dodd · Anchorage, AKBuilt 1947 · S/N 12-2641N369GBStork 1 LLC · Green Cove Springs, FLBuilt 1981 · S/N 15285103N369RPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 369N36MXDevlin William Lee · Greeley, COBuilt 1982 · S/N 280N3706WAshby Sharon · Flora, INBuilt 1980 · S/N WA-178N3707BSampson Gary W · Cedar Rapids, IABuilt 1980 · S/N WA-177N3707GHooker Kenneth R · Sheridan, ARBuilt 1980 · S/N WA-184N3712MChristy Alan M · Pendleton, ORS/N 12-2658N3713MBurger Craig B · Sisters, ORS/N 12-2539N3717MLeonard David J · Bettles Field, AKBuilt 1947 · S/N 12-2659N372Bufkin Ray B · Grand Prairie, TXBuilt 1993 · S/N 596N3721MCape May Aerial Advertising LLC · Rio Grande, NJBuilt 1947 · S/N 12-2662N37259Krystofiak Steven · Scottsdale, AZBuilt 1980 · S/N WA-128
Back to AD 80-25-02 R2