The poor real-time performance and high maintenance costs of the dynamometer card (DC) sensors have been significant obstacles to the timely fault diagnosis in the sucker rod pumping system (SRPS). In contrast to the DCs, the motor power curves (MPCs), which are accessible easily and highly associated with the entire system, have been attempted to predict the working conditions of the SRPS in recent years. However, the lack of labeled MPCs limits the successful applications in the industrial scenario. Thereby, this paper presents an unsupervised fault diagnosis methodology to leverage the generated MPCs of different working conditions to diagnose the actual unlabeled MPCs. Firstly, the MPCs of six working conditions are generated with an integrated dynamics mathematical model. Secondly, a framework named mechanism-assisted domain adaptation network (MADAN) is proposed to minimize the distribution discrepancy between the generated and actual MPCs. Specifically, benefiting from introducing the mechanism analysis to label the collected MPCs preliminarily, a conditional distribution discrepancy metric is defined to guarantee a more accurate distribution matching with respect to different working conditions. Eventually, validation experiments are performed to evaluate the mathematical model and the diagnosis method with a set of actual MPCs collected by a self-developed device. The experimental result demonstrates that the proposed method offers a promising approach for the unsupervised diagnosis of the SRPS.