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.

N814ESExseptional Services Inc · New London, NCBuilt 2016 · S/N E-4082N814JCSports Medicine Consulting LLC · Midlothian, VABuilt 1966 · S/N TE-55N814JGKrahulik Jon L · Fredericksburg, TXBuilt 1991 · S/N E-2622N814LAAkamo Abiodun T · Line Lexington, PABuilt 1994 · S/N E-2849N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197N814TDWesley Roy W · Carmichael, CABuilt 1977 · S/N E-1085N8150FOutatime Air LLC · Clarksville, INBuilt 2003 · S/N 0701N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050N8150VSchindler Flying Inc · Neligh, NEBuilt 1968 · S/N 188-0400N8151QMiller James A Md · Merino, COS/N 414-0051N8151REnterprise Aviation Holdings LLC · Wilmington, DEBuilt 1974 · S/N TH-510N8151YFaesco Inc DBA · Ventura, CABuilt 2003 · S/N 0703N8152TDud Stud Aviation LLC · Bremen, GABuilt 2003 · S/N 0696N8152XFly Dc Air LLC · Plantation, FLBuilt 2003 · S/N 0686N8153GValenzuela Aviation LLC · Little Rock, ARBuilt 1990 · S/N E-2583N8153HT Money Aviation LLC · St George, UTBuilt 2003 · S/N 0702N8153RPleasantwood Corp · North Canton, OHS/N 0708N8153VRed River Leasing LLC · Memphis, TNBuilt 2003 · S/N 0709N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025N8157VReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N 188-0407N8158RFullerton Vtail Partners LLC · Mission Viejo, CABuilt 1974 · S/N D-9665N8159RWiencke John K · San Francisco, CABuilt 1974 · S/N CE-527N815ACHakes Thomas A · Suring, WIBuilt 1975 · S/N 310R0597N815CDHotrod Aviation LLC · Greencastle, INS/N 0149N815HCHci Leasing Inc · Merritt Island, FLBuilt 2004 · S/N 1199N815JDBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0543N815JTL G T LLC · Bronwood, GABuilt 1976 · S/N CE-688N815LAGarrettgobo LLC · Saint Augustine, FLBuilt 1994 · S/N E-2850N815MKEasley Michael · Colorado Springs, COBuilt 2004 · S/N ESSS-174N815QSumo Tails Ltd · Wilmington, DEBuilt 1966 · S/N D-8286N815TGBenelux Inc · Wilmington, DEBuilt 2007 · S/N E-3781N815TMBoughman Micheal · Gastonia, NCBuilt 2008 · S/N E-3851N815VNordic Air LLC · Petersburg, AKBuilt 1973 · S/N 18502331N8162DWc&R LLC · Austin, TXBuilt 1991 · S/N E-2589N81631Kelly Jon B · Anchorage, AKBuilt 1981 · S/N U20606371N8163FCalugar Ronald C · Bunnell, FLBuilt 1991 · S/N E-2590N8163RFoothills Insurance Services LLC · Marion, NCBuilt 2003 · S/N 0744N8163VPerleberg Patrick M · Cedar Grove, INBuilt 2003 · S/N 0748N81640Miller Ralph G Trustee · Napa, CABuilt 1991 · S/N CE-1591N8164FVander Ark Jan R Trustee · Chandler, AZBuilt 2003 · S/N 0749N8165EWw Air LLC · Templeton, CABuilt 1998 · S/N E-3193N8165HNext Centennial Holdings LLC · Alexandria, VABuilt 2003 · S/N 0747N8165QStewart Robert Page · Monroe, NCS/N E-2592N8166GRohrer John D · Belmont, CABuilt 1993 · S/N EA-546N8166WScope Leasing Inc · Columbus, OHBuilt 1991 · S/N E-2593N8167AMagic Aviation LLC · Joplin, MOBuilt 1991 · S/N E-2594N8167KHues Oulton A · Norwood, MABuilt 1993 · S/N EA-547N8167QCedar Pine Construction Inc · Sturgis, SDBuilt 1975 · S/N U20603099N8168FSnyder Jeffrey L · Clarkston, MIBuilt 1991 · S/N E-2596N8168QRucks Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 0805
Back to AD 86-13-04 R3