OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N80722Benzinger Fay A · Bethesda, MDS/N CE-295N8072DLong Jill A · Apo, AES/N E-2728N8073HFrye Lloyd H · Zachary, LAS/N CE-1682N8073WKilo Mike LLC · Nancy, KYBuilt 1992 · S/N E-2730N8074RHilde Chadwick Q · Statesboro, GABuilt 1969 · S/N D-8982N8074ZTurner Robin L · Irwin, PABuilt 2003 · S/N 1346N8075GVaughns Flying Service Inc · Reese, MIBuilt 1973 · S/N 18801226TN8076ZHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0476N8077MKriessler Scott C · Port Clinton, OHBuilt 1990 · S/N E-2565N8077XTudor George J · Mecca, CABuilt 1990 · S/N E-2534N8079GBoney Grady · Rhine, GABuilt 1973 · S/N 18801227TN8079ZParker Larry E Jr · Lumber Bridge, NCBuilt 1992 · S/N EA-538N807DJGreat West Produce Co Inc · Commerce, CABuilt 2001 · S/N E-3371N807LWLocke Jeffrey · The Plains, VABuilt 1978 · S/N CE-807N807RBAscensio LLC · Tyler, TXBuilt 2001 · S/N 40009N807TKelly Michael J · Overgaard, AZBuilt 1964 · S/N D-7691N807THSan Mateo Real Estate Inc · San Mateo, CABuilt 1977 · S/N TH-807N807WCEt Fly Home LLC · Auburn, ALBuilt 1977 · S/N 21061775N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300N8080CMelo Clayton · Westport, CTS/N 0646N8080NStratz Gregory A · Port Orange, FLBuilt 1992 · S/N CE-1688N8080PPiper Llp · Decatur, ALBuilt 1992 · S/N E-2736N8080RKubit John · Edgewood, TXS/N D-8993N8080VTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 188-0330N8081EFlying Horseman Ranch LLC · Stuart, VABuilt 1974 · S/N 18502329N8081RCook Marvin R · Portales, NMBuilt 1969 · S/N D-8994N8081VStorm Flying Service LLC · David City, NEBuilt 1968 · S/N 188-0331N8082RJ M Rowland Aviation LLC · Eastman, GABuilt 1969 · S/N E-152N8083RR And P Air LLC · Cimarron, KSBuilt 1992 · S/N CE-1689N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506N8087RCavanaugh Robert K · Valparaiso, INBuilt 1992 · S/N E-2738N8088JPhillips Robert Carroll III · Waxhaw, NCBuilt 1990 · S/N E-2502N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004N808CDC M Alvarez Inc · Baton Rouge, LABuilt 2001 · S/N 0114N808DFShape Aviation LLC · Dallas, TXBuilt 2017 · S/N E-4111N808GWWahrman Wayne · Calabasas, CABuilt 2005 · S/N 1374N808LCHulsey Michael · Prescott, AZBuilt 1980 · S/N TJ-319N808NHAkers Gary L · Eden, NCS/N E-2817N808RGLampasso Paul · Palm Harbor, FLFirst renewal noticeBuilt 2006 · S/N L2K-269N808TSGross Andrew · Mooresville, NCBuilt 1968 · S/N CJ-1N808TWVa Office Of Emergency Service LLC · Hampton, VABuilt 1977 · S/N 340A0304N808WMCarney Adam S · Middletown, NJBuilt 1995 · S/N 29-0072N808WRAlta Aviation LLC · Baileys Harbor, WIBuilt 2004 · S/N E-3570N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369N8091TTranski Tyler · Del Mar, CABuilt 1992 · S/N CE-1655N8091ZFahlbusch Marius J · Snohomish, WABuilt 1966 · S/N U206-0491N8092RBoogers In Flight LLC · Ada, OKS/N E-161N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544N8093RBrand David E · Touchet, WABuilt 1969 · S/N D-8996N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230
Back to AD 86-13-04 R3