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.

N557CACci Air LLC · Dell Rapids, SDBuilt 2005 · S/N 1594N557CEBce Aviation Llp · Lexington, KYBuilt 1977 · S/N TH-864N557RMWest Street Partners Ltd · Litchfield, CTBuilt 2000 · S/N 29-0210N557SASouthard Dennis W Trustee · Tulsa, OKBuilt 2002 · S/N E-3457N557VKG&S Construction & Farms Inc · Elsberry, MOBuilt 2014 · S/N E-4055N557VTRobert Anderson LLC · Midland, TXBuilt 2010 · S/N E-3933N5581TChristenson Timothy M · Scituate, MABuilt 1989 · S/N CE-1350N5582XAlpe Holding LLC · Van Nuys, CABuilt 1989 · S/N CE-1353N5585KMacias Aviation LLC · Canadian, TXBuilt 1989 · S/N CE-1385N5585YBlacklock Beech Boys LLC · Langlois, ORS/N CE-1389N558CDSr Global Partners LLC · Laguna Beach, CABuilt 2005 · S/N 1414N558MKSandy River Air LLC · Wilmington, DEBuilt 2014 · S/N E-4026N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67N558RT558rt LLC · Rocky Mount, NCBuilt 1993 · S/N TH-1691N558THScannelli Jeff · Southampton, NYBuilt 2001 · S/N TH-2000N558USNorth Central Dakota Partners LLC · West Fargo, NDBuilt 2005 · S/N 290358N558WHRex Aero LLC · Wilmington, DEBuilt 1982 · S/N TH-1356N5591ABig Dog I LLC · Wallace, MIBuilt 1989 · S/N TH-1566N5591VCortese Michael C · South Chatham, MABuilt 1989 · S/N E-2501N5593CSouth Coast Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1989 · S/N E-2493N5594CNovember Inc · Murfreesboro, TNBuilt 1991 · S/N E-2685N5598GNorth River Investments Inc · Palmetto, FLBuilt 1990 · S/N EA-503N5599PAd Ventures LLC · Camden, DEBuilt 1989 · S/N CE-1344N559MCBkjm LLC · Blanchard, OKBuilt 1978 · S/N 18503479N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038N55AEFreer Lawrence C III · Puyallup, WABuilt 1966 · S/N TE-84N55BFrankel Cary S · Harrison, NYBuilt 1979 · S/N 310R1830N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423N55CVCavu LLC · Charleston, WVBuilt 1977 · S/N TE-1114N55DBFletcher William J Trustee · Carson City, NVBuilt 1969 · S/N TE-716N55EZSummit Aviation Resources LLC · Akron, OHBuilt 1970 · S/N TE-785N55JBHigh Point Management Co · Graford, TXBuilt 1990 · S/N CE-1493N55JUDakota & Skyy LLC · Louisville, COBuilt 2019 · S/N E-4131N55KMbi · Indn Hbr Bch, FLBuilt 1979 · S/N E-1601N55KCBloch Jeremy · San Francisco, CABuilt 1976 · S/N D-9930N55KPJm Waypoint LLC · Fresno, CABuilt 1970 · S/N D-9173N55KSPerlan LLC · Melbourne, FLBuilt 2003 · S/N 0550N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926N55LWLeeward Aero Sales Corp · Ocala, FLS/N 1851185N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015N55RHMccarthy Michael E · Martinez, CABuilt 1969 · S/N P206-0584N55RSCrop-Serv Inc · Meade, KSBuilt 1966 · S/N TE-151N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586N55SPJ&D Flying LLC · Clinton, MOBuilt 1966 · S/N D-8084N55TLRegistered aircraftBuilt 1976 · S/N TE-1079
Back to AD 86-13-04 R3