Bembridge do not appear to be currently very aviation friendly
Depends on your idea of "Aviation Friendly".
I often fly to Bembridge ...
Call the Vectis GC, leave message and contact number along with callsign and ETA.
Fly over , Blind call , fly the appropiate circuit, Land and park on grass North of Runway, walk round to Propellor Inn/ Hangar deposit Landing Fee.
Leaving , check windsock , Blind call intentions ,Taxi to whatever end of Runway and depart ..........
What more do you need ?
I call this extremely Aviation Friendly !
Only wish more airfields could operate like this !
Good idea by the OP, but fear the market might be quite small so return on investment would take a long time.
Static Caravan would not be as appealing as ,say, a Timber Lodge style home
Need to cater for Aviators bring their own home with them ( Tents ! )
Shobdon do this very well
Biggest bonus that Bembridge ( or any other Airfield for that matter ) could provide would be a number of Hire cycles located on the airfield