To investigate the influence of dynamic loads on the shear behavior of the Pisha sandstone-concrete interface, field investigations were carried out on numerous wind turbines and bridges in Ordos City, Inner Mongolia Autonomous Region. The investigations provided data on the layout and embedment depth of concrete piles. Based on these data, shear tests were conducted in the laboratory using a dynamic direct shear apparatus to induce dynamic loading conditions. The effects of load cycle number, shear displacement amplitude, and initial normal load on the shear behavior of the interface were analyzed. Results indicate that as the number of cyclic shear cycles increases, the peak shear stress, dynamic shear stiffness, and damping ratio at the interface undergo a gradual decline. A comparison of the peak shear stresses following the 1st and 30th cycles indicates that the maximum decrease in peak shear stress (41.7%) occurs under an initial normal load of 200 kPa and a displacement amplitude of 2 mm. Conversely, the smallest decrease in peak shear stress (18.5%) is observed under an initial normal load of 50 kPa and a displacement amplitude of 5 mm. Under identical loading conditions, the hysteretic curves of shear stress versus shear displacement exhibit similar characteristics. As the load increases, the normal displacement gradually increases, reaching a maximum value of 1.912 mm at an initial normal load of 400 kPa and a shear displacement amplitude of 5 mm. The soil samples demonstrate a phenomenon of shear shrinkage during the process of shearing, accompanied by a progressive reduction in peak shear stress. The findings can be used to predict the deformation trends of bridges and wind turbines during long-term operation and provide important technical support for ensuring the safe operation of such structures in the Pisha sandstone distribution area of Ordos.