The Red River Fault Zone is a large-scale right-lateral strike-slip fault zone with relatively strong activity during the Quaternary Period. This fault, located on the southeastern margin of the Qinghai‒Tibetan Plateau, plays a key role in the extrusion, rotation and escape of the continental blocks constituting the Qinghai‒Tibetan Plateau. Furthermore, this fault represents the southwestern boundary of the Sichuan–Yunnan Block, which has experienced strong deformation and frequent seismic activity. The northern segment of the Red River Fault Zone is the most active part of the whole fault. However, surface erosion and vegetation coverage have obscured the activity of the northern segment; therefore, the study of its activity has obviously been insufficient. There is still controversy over whether all the secondary faults on the northern segment are active Holocene faults. Studying the activity characteristics of the northern segment, which is densely populated, is particularly important for seismic risk prevention in this area. Based on remote sensing interpretations and field geological surveys, this paper describes the latest activity characteristics of the Cangshan Piedmont Fault, Fengyi–Dingxiling Fault and Midu Basin Margin Fault, including their spatial distributions and kinematic characteristics. According to the ages of the offset strata in profiles, the above three secondary faults were all active in the late Holocene. The latest active age of the Cangshan Piedmont Fault was later than 543-494 cal BP, and two palaeoseismic events that occurred in this section during the Holocene occurred at 2700 and 473 cal BP. The latest active age of the Fengyi–Dingxiling Fault was later than 2760–2700 cal BP; in this section, one Holocene palaeoseismic event occurred between 1777 cal BP and 2730 cal BP, another occurred between 2730 cal BP and 5664 cal BP, and the third occurred between 6449 cal BP and 8360 cal BP. The latest active age of the Midu Basin Margin Fault was later than 558-510 cal BP, and two Holocene palaeoseismic events occurred later than 2318-2114 cal BP and 558-510 cal BP. Based on the results of this paper and previous studies, we believe that the Fengyi–Dingxiling Fault on the northern segment of the Red River Fault Zone is at risk for future strong earthquakes. Additionally, abundant geological and geomorphologic evidence suggests that the northern segment is dominated by normal faults, reflecting the local strain response to secondary clockwise rotation of the Sichuan–Yunnan Block along the boundary fault. This finding is in line with the eastwards extrusion and escape of materials on the Qinghai‒Tibetan Plateau caused by the northwards and northeastwards pushing of the Indian Plate. To a certain extent, these observations reflect the tectonic deformation coordination between block rotation and boundary fault slip in the Sichuan–Yunnan Block in the context of continental block extrusion on the Qinghai–Tibetan Plateau.