OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N588SRegistered aircraftBuilt 2005 · S/N L2K-125N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N5890JBengal Lawrence W · Upland, CABuilt 1965 · S/N D-7877N5894SV Tail Therapy LLC · Seattle, WABuilt 1965 · S/N D-7765N5895SBurson Lloyd R · Anthony, NMBuilt 1965 · S/N D-7773N5896SPreston Robert J · Pittstown, NJBuilt 1965 · S/N D-7826N5897SPrecision Aviation LLC · Califon, NJBuilt 1965 · S/N D-7828N5899JSchuyler Paul E · Morgan Hill, CABuilt 1965 · S/N D-7880N5899SNvl Properties LLC · Wilmington, DEBuilt 1965 · S/N D-7769N5899TBrignac Flying Service LLC · Columbus, MSBuilt 1965 · S/N 1850799N589CSpringville Flying Club · Spanish Fork, UTBuilt 1988 · S/N CE-1224N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384N589LBMcleod Douglas D · Jupiter, FLBuilt 2011 · S/N TH-2307N589PUniversity Of Central Missouri · Warrensburg, MOBuilt 1989 · S/N TH-1559N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N589RCSkyflite LLC · Hillsboro, ORBuilt 2004 · S/N 0871N589SFWings Sunward LLC · Port Orange, FLBuilt 2003 · S/N L2K-108N58AGHorsager Trading Co · Saint Paul, MNBuilt 2020 · S/N E-4144N58ARAnnis Aviation LLC · Gray, GABuilt 1987 · S/N TH-1525N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58BSJordan Corporation · Jackson, MIS/N TH-1142N58BYFry Shawn Trustee · Baxter, TNBuilt 1970 · S/N TH-25N58CHChase Brandon C · Plains, KSBuilt 1978 · S/N TH-949N58CKMajestic Fleet LLC · Miami, FLBuilt 1974 · S/N TH-567N58CLLottman Aviation LLC · Beatrice, NEBuilt 2011 · S/N TH-2327N58DAUniversity Of Central Missouri · Warrensburg, MOBuilt 1984 · S/N TH1402N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920N58DLHam John T · Murfreesboro, TNBuilt 1975 · S/N TH-692N58DZUmca Air LLC · Simi Valley, CABuilt 2008 · S/N TH-2256N58ELN1107u LLC · Lewisville, NCBuilt 1979 · S/N TH-1003N58GFCollier Air LLC · Fernandina Beach, FLBuilt 2004 · S/N TH-2095N58GKMvm LLC · Lewes, DEBuilt 1976 · S/N TH-763N58GLRokene Aviation LLC · Marblehead, OHBuilt 2007 · S/N TH-2176N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N58HCMedina Sky LLC · Medina, OHBuilt 1975 · S/N TH-637N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58HESoaring Ventures LLC · La Quinta, CABuilt 1977 · S/N TK-59N58HGAircw LLC · Charlotte, NCBuilt 2014 · S/N TH-2432N58HMA Great Bonanza LLC · Manchaca, TXBuilt 1979 · S/N TJ-205N58JASunergy Solutions LLC · Londonderry, NHBuilt 1975 · S/N 3400521N58JDGrossman Kenneth R · Merced, CABuilt 1977 · S/N TK-19N58JMLucky 7 Operating LLC · Many, LAS/N TK-142N58JZAcv Group LLC · Mckinleyville, CABuilt 1976 · S/N TH-710N58KERacego Corp · San Juan, PRBuilt 1978 · S/N TH-921N58KTBarron Equipment Leasing LLC · Port Washington, NYBuilt 2000 · S/N TH-1955N58LFAckley Ray · Charlotte, NCBuilt 1972 · S/N TH-237N58LGMorgan Farms LLC · Twin Falls, IDBuilt 1981 · S/N TJ-393N58LKTennessee Aviation Services LLC · Sevierville, TNBuilt 2013 · S/N TH-2365N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481
Back to AD 86-13-04 R3