How to analyse the sound of Motor
In my opinion, using the STFT (or spectrogram) as you already did is a good start. Try to change the parameters of your STFT, i.e. window size and frame shift until you are able to detect certain frequencies and their repetitions.

This is an example for a decelerating car on the highway. The inertial sensor (not a microphone) was placed at the axle: