A man who shot himself after killing three women in England on New Year’s Day was a licensed holder of firearms, it has emerged.