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.

N331CDDay Charles L · Edison, NJBuilt 1999 · S/N 333N331CMCard Donald J · Dallas, TXBuilt 1999 · S/N 1N331GZN331gz LLC · Fort Myers, FLBuilt 1980 · S/N WA-116N331HTTope Loren C · Cody, WYBuilt 1989 · S/N HT-1N331TShimkus Stanley M · N Huntingdon, PABuilt 1953 · S/N 18-2445N3320MFena Daniel J · Side Lake, MNBuilt 1947 · S/N 12-2177N3324MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2183N333Grullon Guarocuya · Van Buren Twp, MIBuilt 1980 · S/N A1520963N3332MFlaugher Jeffrey R · Lake Orion, MIBuilt 1947 · S/N 12-2190N3335MRiggin Flight Service Inc · Madison, SDS/N 12-2193N3338MSyverson Rodney E · Ada, MNBuilt 1947 · S/N 12-2196N333GHRieken Alyson V · Reno, NVBuilt 1953 · S/N 18-2447N333NEEarle Norman R · Hastings, FLS/N A1520852N333SSCumulus Aviation Services LLC · Port Orange, FLBuilt 1980 · S/N 15284311N333UMUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1980 · S/N 15284751N3340MScheer Darin B · Farson, WYBuilt 1947 · S/N 12-2200N3341MShoemaker Taj · Fairbanks, AKBuilt 1947 · S/N 12-2051N3342MMorris John B · Sterling, AKS/N 12-2201N3348MSpeerstra Adam W · Glennallen, AKBuilt 1947 · S/N 12-2207N334LFRiley Chance · Waxahachie, TXS/N 20-1026N3353Mcnamara John P · Brewster, WABuilt 1970 · S/N 001N3357MSmith James R · Toney, ALBuilt 1947 · S/N 12-2049N335ERunia Allan D Trustee · Gold Hill, ORBuilt 1992 · S/N 246N3361MTrinkle Chris · Heyburn, IDS/N 12-2240N3368Big Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 100N3369MCallen Jerry R Jr · Jerome, IDBuilt 1947 · S/N 12-2218N3370MPetrie Charles W III · Pahala, HIBuilt 1947 · S/N 12-2242N3375MScott Rudee L · Anchorage, AKBuilt 1947 · S/N 12-2224N337TJeanes Douglas G · Frisco, TXBuilt 1953 · S/N 18-2451N3381MAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1947 · S/N 12-2230N3382MGarber Linn A · Custer, SDBuilt 1947 · S/N 12-2229N3388MPatton Derek L · Fort Wainwright, AKBuilt 1947 · S/N 12-2056N338SJMiller Space A · Simi Valley, CAS/N 38-79A0500N338TSiegford Riley E · Anchorage, AKBuilt 1953 · S/N 18-2452N3392MOwens Gary R · Talkeetna, AKBuilt 1947 · S/N 12-2236N3394MBrown Harold J · Hobbs, NMBuilt 1947 · S/N 12-2059N3395MPapendick Greg J · Hudsonville, MIS/N 12-2237N3397MSievert Randall L · Storm Lake, IABuilt 1947 · S/N 12-2248N339EZPico Andres V · Hollywood, MDS/N 1339N33BGifford Steven K · Buskirk, NYBuilt 1946 · S/N 12-784N33GSFish N Fly LLC · Hobe Sound, FLS/N 15281292N33LJUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 15282023N3400GKirk John C · Bakersfield, CAS/N P-361N3407MBausch Wayne A · Ames, IABuilt 1947 · S/N 12-2253N340SXHeavy Metal Air LLC · Farmingdale, NYBuilt 1981 · S/N 15285141N34132Randall Kelly J · Independence, ORBuilt 1947 · S/N 1844N3414MNebrig & Associates Inc · Denton, TXBuilt 1947 · S/N 12-2061N3416MBaker Marianne J · Raeford, NCS/N 12-2263N3417MZiehvein Robert L Trustee · Belle Plaine, MNBuilt 1947 · S/N 12-2068N3418MGrabin Joseph S · Jermyn, PABuilt 1947 · S/N 12-2281
Back to AD 80-25-02 R2