Chewy,
As already mentioned the nearest flying club is Hull Aero Club but in the local area there is also Mount Airey but i'm not sure if there are any aircraft available for hire there.
Within an hours drive there is Humberside airport (3 clubs), Sandtoft, Breighton, Full Sutton, and possible Sherburn. Not sure if anywhere will be willing to hire without membership costs due to insurance requirements but you can always give them a call.
CBK