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.

N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256N333WDanarich LLC · Rancho Mirage, CABuilt 1979 · S/N TE-1172N333WAPowell Jay · Columbia, MSBuilt 1969 · S/N E-176N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906N333XJpg Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-266N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N334Jeffrey Mark · Clayton, MIBuilt 1967 · S/N D-8467N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140N3344MSmith Andrew L · Hillsboro, TXBuilt 1993 · S/N CE-1731N3345BR Farms LLC · Wilmington, DEBuilt 1994 · S/N E-2865N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145N3346LHarper Matthew Clay · Anchorage, AKS/N 185-1274N3347LAcumen Aerotech LLC · Rogers, TXBuilt 1967 · S/N 185-1275N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147N3349ADoherty David R · Thief River Falls, MNBuilt 1970 · S/N CE-306N3349JRegistration Pending · Quincy, OHRegistration pendingS/N T18803632TN334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962N334CPRws Aviation LLC · Indianapolis, INBuilt 1977 · S/N E-1003N334DBrady Michael H Trustee · Healdton, OKBuilt 1993 · S/N CE-1756N334FLChampionx LLC · Sugar Land, TXBuilt 2004 · S/N 290334N334HPN334hp LLC · Sheridan, WYBuilt 1974 · S/N CE-519N334JDGolden Bear Properties LLC · Lakeside, AZBuilt 1993 · S/N CE-1718N334KWRoberts Dorel Lynn · Sheridan, WYS/N CE-523N334MBSutherland Scott G · Longmont, COBuilt 1982 · S/N CE-1012N334PBConway Brian · Denver, COBuilt 1990 · S/N CE-1543N334PCMagic Valley Auction LLC · Jerome, IDBuilt 1990 · S/N CE-1534N334PWGary Bass Restorations LLC · Monett, MOBuilt 1974 · S/N CE-488N334RN566rw LLC · Hensley, ARBuilt 1991 · S/N CE-1561N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499N334TXMagic Mentor LLC · Canyon, TXS/N G-26N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331N334WSStengl William R · Minocqua, WIBuilt 1966 · S/N CE-79N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150N3351LGagnon Philip F · Anchorage, AKBuilt 1967 · S/N 185-1303N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156N3357LMark II Aviation LLC · Corvallis, MTBuilt 1967 · S/N 185-1309N3358AWagner Richard L · Willis, TXBuilt 1969 · S/N D-9062N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N335DDJab Aviation Inc · Wilmington, DEBuilt 1980 · S/N 335-0049N335HPOlympus Leasing LLC · Bremerton, WABuilt 1992 · S/N CE1663N335JAAstrologo Joseph A Jr · Tullahoma, TNBuilt 1964 · S/N D-7576N335KHSerafini Transportation LLC · Ringwood, NJBuilt 1979 · S/N 335-0025
Back to AD 86-13-04 R3