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.

N235LKCluff Dustin · Saint Helens, ORS/N 128N235MKWright Curtis B · Roy, UTBuilt 2003 · S/N 9904-0183N235TBossert Brett · Tucson, AZBuilt 1953 · S/N 18-2349N235TJDickerson Timothy J · Woodlake, CABuilt 2013 · S/N S95010090N2361MSutter Tim C · Glennallen, AKBuilt 1946 · S/N 12-1615N2361NBrewer Philip T · Bartlett, TNBuilt 1979 · S/N 38-79A0807N2362MCanfield James R · South Gibson, PABuilt 1946 · S/N 12-1616N2363NGeneral Aviation Support Corp · Rosamond, CANon-citizen corporation, flight hours not reportedS/N 38-79A0809N2363PRoybal Jesse U · Kingman, AZBuilt 1979 · S/N 38-79A0963N2364NNess Timothy J · Alexandria, MNBuilt 1979 · S/N 38-79A0810N2365ADavedish LLC · South Fork, COBuilt 1978 · S/N 38-78A0657N2365DSpurlock James D · Headland, ALBuilt 1978 · S/N 38-79A0284N2368MOconnor Sarah A · Franklin, WIBuilt 1946 · S/N 12-1500N2369MBoberg James J · Littleton, COBuilt 1946 · S/N 12-1501N236JTRecord John · Apison, TNBuilt 1970 · S/N 786-71N236LSV & P Aviation LLC · Queen Creek, AZS/N 90741N236MCChristler Lockie E · Enumclaw, WABuilt 1999 · S/N 01N236TStickley John E · Lothian, MDBuilt 1953 · S/N 18-2350N23701Jackson Ramman S · Los Angeles, CABuilt 1939 · S/N 7170N2370BStrawberry Aviation Inc · Watsonville, CABuilt 1978 · S/N 38-79A0028N2372AOquinn Timothy M · Tehachapi, CABuilt 1978 · S/N 38-78A0661N2372KKremer Charles A · Mckinney, TXS/N 38-79A0597N23738Laureano Reynaldo · Murfreesboro, TNBuilt 1979 · S/N 38-79A1049N2374LFrederick Calvin · Homestead, FLBuilt 1979 · S/N 38-79A0687N2376MHuberd Kyle A · Wilsonville, ORBuilt 1946 · S/N 12-1504N2378BEssler Kim L · Garrison, NDBuilt 1978 · S/N 38-79A0029N2378MLacher Louis R Jr · Wasilla, AKBuilt 1946 · S/N 12-1623N2379GDesselle Howard J III · Marksville, LAS/N 38-79A0509N2379MThies Trevor H · Seattle, WABuilt 1946 · S/N 12-1624N2379PHendrix Kim R · Cheboygan, MIBuilt 1979 · S/N 38-79A0970N23800Adams Michael S · Huntsville, ALBuilt 1979 · S/N 38-79A1055N2380KPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0603N2381KCarolinas Energy Associates LLC · Hays, NCBuilt 1979 · S/N 38-79A0605N2381NHoyt Vance E Jr · Marina, CAS/N 38-79A0817N2382VAnywhere Atp LLC · Mount Juliet, TNBuilt 1982 · S/N 38-82A0061N2383FLaminar Aerospace LLC · Waukegan, ILBuilt 1978 · S/N 38-79A0411N2384MDiedrich Steve · Sandpoint, IDS/N 12-1510N2385KHaynes Vincent L · Maumelle, ARBuilt 1979 · S/N 38-79A0610N2385MLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1946 · S/N 12-1627N2386NHoelzle Paul R · Fremont, OHS/N 38-79A0820N2387KClipper Properties LLC · Saratoga, WYBuilt 1979 · S/N 38-79A0833N2387MOlson Catherine R · Two Rivers, AKBuilt 1946 · S/N 12-1630N2388BN2388b LLC · Salem, ORBuilt 1978 · S/N 38-79A0031N2388MVotaw Kristina M · Anchorage, AKBuilt 1947 · S/N 12-1631N2388TSlatner John W · Sims, NCBuilt 1978 · S/N 38-78A0787N2389DRowland James E Jr · Pennsville, NJBuilt 1978 · S/N 38-79A0293N2389FDavenport Jimmy J · Hayesville, NCBuilt 1978 · S/N 38-79A0413N2389TForeman O Dean · Springfield, TNBuilt 1978 · S/N 38-78A0789N238THoffer William T · Orr, MNBuilt 1953 · S/N 18-2352N2393BReiley Hunter W · Harlingen, TXS/N 38-79A0035
Back to AD 80-25-02 R2