It's tricky, especially these days when the overall quality and affordability of DSLR cameras has improved. The small sensor (physical size, not megapixels) of a compact camera introduces issues which need to be overcome, mainly noise/grain. Slow response time, both with focus and on shutter activation can also be a problem.
You'd be much better advised to go for a DSLR if you want to make aviation photography a significant part of your photography experience. Even the lowest end budget DSLR should give better results than a compact, at least for here. If you can't afford one today, waiting and saving up might be a good idea if you can.
Nothing wrong with compacts, they have a role to play. Budgets may dictate that you have no choice. We have a Panasonic Lumix which is much handier for general use than a DSLR. My wife even got a photo on here with it (we decided to see if she could get one on, she is not really interested in aircraft generally), but the post-processing work needed to bring it up to scratch needed more care, that's for sure.
It was always tricky to get decent moving shots with the non-DSLR's I've owned and I think that is even more true today than back then. For static shots, they were ok, but you must fill the frame and post-processing demands are higher.
As a little experiment, I recently went back to my 2005 shots from Fairford to see what I could do with some that were not uploaded back then. I've learned more about editing in the last 4 years and I wanted to see what I could do. Back then I was using a 5 megapixel non-DSLR, the Panasonic FZ-20. Going back, boy was it grainy compared to my Canon 350D! I was pleased with the improvement I was able to make with my post-processing compared to back then, but even so, there were a significant number of rejections when uploaded to here. Still, several made it in and I'm even happy with the ones that didn't - they have brushed up nicely for my own collection, so it was worthwhile overall. So it is still possible to take successfull shots for here with a relatively out-classed camera. But, all the shots were of aircraft in static displays, good natural lighting, the original filled the frame (allowing some defects to be lost when resizing for here), significant post-processing was required and you can still see issues that would not appear with a DSLR. Some were good enough, but only just.
Best regards,
Jim