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.

N999DCTbm Avenger Inc · Peru, ILBuilt 1976 · S/N 340A0035N999DPRobinson Aviation Holdings LLC · Houston, TXBuilt 1971 · S/N D-9263N999DXJourneyman Aviation LLC · Louisville, KYBuilt 2003 · S/N 0582N999EBEngines Inc · Jonesboro, ARBuilt 1979 · S/N 340A0951N999ETJet Aero LLC · Montoursville, PABuilt 2003 · S/N 0476N999FBDelia Salvatore · Rocky Point, NYBuilt 1979 · S/N E-1495N999GTJet Air Inc · Iowa City, IABuilt 1964 · S/N D-7686N999HQProclaim Aviation Ministries · Worthington, MNBuilt 1976 · S/N 310R0720N999JLFlying Swan LLC · Ashland, NHBuilt 1973 · S/N 414-0479N999JWWazney Aviation LLC · Willoughby, OHBuilt 2003 · S/N 29-0293N999KAHarlan John M · Cedar Park, TXBuilt 1967 · S/N D-8644N999KMMaule Aviation LLC · Las Vegas, NVBuilt 1979 · S/N P21000387N999LCJust Plane Aviation LLC · Baldwin, MIS/N 40032N999PCFlying T LLC · Albuquerque, NMBuilt 1972 · S/N 21059694N999PGRegistered aircraftBuilt 1995 · S/N E-2955N999PLFalcon Wheels LLC · Wilmington, DEBuilt 2011 · S/N E-3952N999PZBs Starbellies LLC · Austin, TXBuilt 1979 · S/N E-1483N999RKTcg Aviation LLC · Pelham, ALBuilt 1974 · S/N 414-0610N999SGHuskey Eugene Donald Jr · Leesburg, TXBuilt 1981 · S/N E-1963N999SKWkqm LLC · Wilmington, DEBuilt 1997 · S/N TH-1815N999ZWBlue Water Aviation LLC · Oakman, ALBuilt 2011 · S/N TH-2323N99AWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N CE-420N99BDOcm Aviation LLC · Garner, NCBuilt 1977 · S/N E-1147N99BRAircorps Aviation LLC · Bemidji, MNBuilt 1980 · S/N E-1688N99BYAirria Holdings LLC · BerlinBuilt 2004 · S/N 0825N99CDPapa'S Hatchn Enterprises Inc · Wilmington, DEBuilt 2002 · S/N 0283N99DAAuburn Aero Holdings LLC · Auburn, INBuilt 1975 · S/N TH-619N99DGBrooks Conoly O III · San Angelo, TXBuilt 1978 · S/N CE-823N99DPCmt Properties LLC · Laurel, MSBuilt 1966 · S/N TE-158N99DSToutant Roland J · Woodstock, CTBuilt 1972 · S/N 210-59608N99EMFreedom Alliance LLC · Olathe, KSS/N CE-34N99GBBright Edgar H · Collegeville, PABuilt 1973 · S/N 21060115N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99LGWashington Enterprises LLC · Little Rock, ARBuilt 1987 · S/N CE 1157N99MFly Buy LLC · Kalispell, MTBuilt 1972 · S/N CE-414N99MKHigh Mountain Healthcare LLC · Blairsville, GABuilt 1977 · S/N CE-742N99MQPlacide Aircraft LLC · Canton, MIBuilt 1968 · S/N TE-527N99MSLubell Daniel R · Bothell, WABuilt 1998 · S/N 29-0157N99NPColonial Export Inc · Pompton Plains, NJBuilt 1976 · S/N E-809N99NTEdwards Mark A · Sedalia, MOBuilt 1965 · S/N D-8019N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99QTNielsen4 LLC · Seattle, WABuilt 1968 · S/N U206-1017N99RFEcho Bravo Aviation LLC · Nashville, TNBuilt 1974 · S/N TH-463N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649N99RLThompson Nigel J · Ann Arbor, MIBuilt 1970 · S/N D-9108N99SBBonanza Service Ltd Co · Bethany, OKBuilt 1971 · S/N E-281N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641N99TMMagdabenja Holdings LLC · Corona, CABuilt 1977 · S/N 21061712N99VBC&S Aviation Partners LLC · Thibodaux, LABuilt 1980 · S/N EA-154
Back to AD 86-13-04 R3