It would be interesting to compare service parameters between a compressor and a plain bearing spindle, since you also need to lubricate rings and other sliding elements, and bearing loadings may be somewhat different, but I have no doubt whatsoever that 'compressor' oil (and IIRC there is some definitional ambiguity in the SAE specs for that term, BTW) of the right viscosity would work fine in a