Posts are locked for different reasons. Some are in effect permanent ("historical significance", wiki-lock), some are meant to be temporary ("disputes are being resolved", "off-topic comments"). Sometimes, posts of the latter category remain in locked state long after any comments or debates are forgotten. Unless someone finds them and asks a moderator to unlock, that is.
One can search for locked posts both via SEDE and site search. But it appears impossible to search for a particular lock category. For example, one can't filter out historical locks which can't even be flagged.
I didn't find the reason for locking anywhere in SEDE (looked at all columns of the PostHistory table entries of locked posts.) I propose adding lock reasons to SEDE, either as a LockReasonTypeId or as the text of the lock notice.