OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,350

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.

N1008EEdwards Gregory S · Guthrie, OKS/N 1202-77N100BVHoward Keith · Fayetteville, NCBuilt 1978 · S/N 38-78A0262N100XXAskew Stell Blake III · Durham, NCBuilt 1975 · S/N AA1B-0578N1010RKaneair LLC · Hayes, VABuilt 1968 · S/N 591N1011TPedersen Michael · Bakersfield, CABuilt 1972 · S/N 863-72N1012GForwalt Lucas A · Chesapeake, VABuilt 1969 · S/N AA1-0122N1014EMeade Lance M · Stinson Beach, CABuilt 1977 · S/N 1203-77N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208N101BVMundwiler David · Hemet, CAS/N 674N101SXCattrell Jeff S · Church Hill, TNBuilt 2002 · S/N 576N1021EYoung David S · San Jose, CABuilt 1977 · S/N 1204-77N1027Wilson David R · Riggins, IDBuilt 1992 · S/N PT1027N102ELFurniss Kenneth F · Orondo, WABuilt 1999 · S/N 75005LFN102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N1034ENexga Aircraft Inc · Greensboro, NCBuilt 1977 · S/N 1205-77N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243N1042EPerez Alexander · Palmer, AKBuilt 1977 · S/N 1207-77N1047XHuber Frank B · Maple Grove, MNBuilt 1977 · S/N AA1C-0050N1048CPalmer Gretchen · Knoxville, TNBuilt 1976 · S/N 1153-76N104DMiller Charles H Jr · Cape Carteret, NCS/N A101N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308N105TPeterson Nathan C · Cordova, TNBuilt 1952 · S/N 18-2219N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998N106UCInsuraclaim LLC · Boca Raton, FLBuilt 1981 · S/N 15285419N1073EMurphys Flying Service LLC · Thomasville, GABuilt 1977 · S/N 1209-77N1075EWeiland Adam W · Evergreen, COBuilt 1977 · S/N 1214-77N107JMCyphers Sam K · Sequim, WABuilt 2005 · S/N 6-5658N107RZShick Kenneth W · Oxnard, CAS/N 685N108PCRegistered aircraftBuilt 1948 · S/N 16-322N108TOlson Isaac B · Forestburg, SDBuilt 1952 · S/N 18-2222N1090ECrouse John A · Sterling, AKBuilt 1977 · S/N 1210-77N109CFMarigi William Kihara · Worcester, MABuilt 1978 · S/N 15282332N109RWMcpherson Michael A · Stephenville, TXBuilt 1971 · S/N AA1A-0250N10BWAce Aircraft Co Inc · Toccoa, GABuilt 1992 · S/N 9665N10FAFlanigan Marie C · Lockport, NYBuilt 1972 · S/N AA1A-0337N10GRHannagan Collin · Saint Elmo, ILS/N 1N10VFAce Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282873N10XRRatzlaff Ray P · Redmond, ORBuilt 1990 · S/N 1845-LN1102ELee Robert J Trustee · Denver, NCBuilt 1977 · S/N 1211-77N1103EPhantom Flyer LLC · Yelm, WABuilt 1977 · S/N 1212-77N11071Foster Frank B · Goldsboro, NCBuilt 1965 · S/N 7ECA-51N11085Morgan Richard L · Chula Vista, CABuilt 1966 · S/N 264N1109JOrton Aviation LLC · Walker, MNBuilt 1950 · S/N 18-392N1114EGetz Darrel P · Colfax, WABuilt 1977 · S/N 1213-77N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429N112RSarlan Robert A · Cameron Park, CAS/N 0112R
Back to AD 80-25-02 R2