Each sensor vehicle is different. In general, the level of detail seen in the image and geolocational accuracy will be better for orthophoto flown from aircraft. Satellite imagery is superior in that new imagery can be collected and delivered on much shorter notice anywhere in the world, and includes more spectral bands outside the visible range.