Said al-Shihri, described as the second-in-command of al-Qaeda in the Arabian Peninsula, is killed in an operation in Yemen, officials say.