What on earth makes the likes of Salmond imagine that ANY of the oil revenue would flow the way of an independent Scotland? The way that international borders are worked out would mean that the vast majority of the North Sea oil fields would be English with a smattering being Norwegian, Dutch and Danish.
In that case then the oil revenue would go exactly where it goes right now, straight to the City of London.
Oh, and cazatou, I think that you have your Northern England airfields mixed up. Ouston is now Albermarle barracks and the airfield a training and exercise area, no building on the airfield of housing. I think you may be thinking of the former RAF Thornaby, which has been built on.
As to reopening Acklington, kinda difficult as the airfield has been removed from the face of the earth by vast open cast mining and is now restored to farmland while what remains of the technical and domestic area is a prison.