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.

N787DRBad Aire LLC · Aledo, TXS/N 414A0503N787GSwirsding David J · Chalfont, PABuilt 1979 · S/N 340A0961N787JKMark M Jackson Do LLC · Sarasota, FLS/N E-1159N787JVRegistered aircraftBuilt 1977 · S/N D-10082N787LLDouglas Aviation Ltd · South Barrington, ILS/N CE-1182N787MRMoon Aviation LLC · Oklahoma City, OKBuilt 1997 · S/N E-3144N787RMJohnson Plane Services · Greenbrier, TNBuilt 1993 · S/N CE-1719N7880LSw Aviation Group LLC · Dover, DEBuilt 1966 · S/N CE-106N7881RCustom Farm Systems Inc · Luverne, MNBuilt 1969 · S/N CE-264N7883LJinnette James G · Raleigh, NCBuilt 1966 · S/N D-8301N7883RMcdaniel Kennard J · Kansas City, MOBuilt 1969 · S/N E-138N7885CS Tec Corp · Mineral Wells, TXBuilt 1966 · S/N TE-72N7885LGriffin Brad W · Salome, AZBuilt 1966 · S/N D-8303N7886LN7886l LLC · Brighton, COBuilt 1968 · S/N E-10N7888SHangar One Lc · Clear Lake, IABuilt 1989 · S/N CE-1368N788BTPowers Elbie L · Roseboro, NCFirst renewal noticeBuilt 1976 · S/N 18802583N788CF3w Group Inc · Hot Springs, ARBuilt 1977 · S/N TH-870N788DMSts Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 340A0461N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851N788KRegistered aircraftBuilt 1977 · S/N D-9992N788MAir First LLC · Kalispell, MTBuilt 1986 · S/N 46-8608040N788WFStudebaker Investments LLC · Boise, IDBuilt 2003 · S/N 0720N7891LGrr Aviation LLC · Grand Rapids, MIBuilt 1966 · S/N CE-107N7892RCutler Sewall C Jr · Fredericksburg, TXBuilt 1969 · S/N D-8944N7893LLilya Trever L · Mesa, AZBuilt 1966 · S/N D-8306N7894RMaul Russell L · Jacksonville, ILBuilt 1969 · S/N D-8946N7895LRemington Pierce S · De Kalb, MOS/N D-8297N7896SPanepinto Lane · Lafitte, LABuilt 1967 · S/N U2060814N789AAGpie Inc · Sugar Land, TXBuilt 2001 · S/N 0123N789AMGal Aviation LLC · Winchester, MABuilt 2005 · S/N 1492N789BDTroy Farms Lp · Delano, CAFirst renewal noticeBuilt 1973 · S/N 310Q0922N789DLTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1732N789FMRadio Flyer LLC · Fox Point, WIBuilt 2000 · S/N EA-652N789JArr Planes LLC · Chattanooga, TNBuilt 1984 · S/N E-2145N789JHThomas Matthew S · Denver, COBuilt 1969 · S/N E-167N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021N789NTjb Ent LLC · Spokane, WABuilt 1982 · S/N 18504390N789PDSwords Steven T · Rancho Mirage, CABuilt 1966 · S/N D-8290N789PPBloom Zachary Aaron · Lago Vista, TXFirst renewal noticeBuilt 2002 · S/N 3RX110N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N789PZWalters Aviation Group LLC · San Diego, CABuilt 1984 · S/N TH-1424N789RDomeracki Douglas P · Elgin, ILBuilt 1965 · S/N D-7777N789RGBonanza N789rg LLC · Oro Valley, AZBuilt 1973 · S/N D-9483N789RMSidfrid Jeff S · Houston, TXBuilt 1968 · S/N TE-659N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009N789SLRoye Bart Laine · Slaton, TXBuilt 1975 · S/N TJ-12N789SPReed David Allen Trustee · Pinedale, WYBuilt 2003 · S/N 0742N789VBFsq Aviation LLC · Dover, DEBuilt 2004 · S/N 0806N789WBDale Scott A · Baltimore, MDBuilt 2001 · S/N 40029N789ZParish Charles L · Tullahoma, TNBuilt 1978 · S/N 18503644
Back to AD 86-13-04 R3