It's a JP 4 (the aerodynamic balance tab on the fin is a giveaway
) originally delivered to the RAF in December 1962.
Subsequently became a "maintenance airframe" used for training (the location of the quarry may help work out where) under the serial 9031 M.
[Edited to add:]
This website adds that it was sunk at the Delph Diving Centre, Lancs in August 2005.