you will need to buy more than just a compressor.
research carefully and make a list if the items you will need to make sure you can supply clean dry air to your airbrush.
I have a friend that is a professional car painter/airbrush artist, I have seen him use both tank and compressor, but he uses the co2 tank mostly for mobile work.
I'm not an expert but I know one, his work has been on magazine covers multiple times, an airplane he painted (and painted a mural on was displayed in the San Diego Museum of Modern Art a few years ago).