Is there a history of tail numbers, such as YP14, assigned to aircraft serial numbers, such as 148788?
http://www.joebaugher.com/navy_serials/navyserials.html
This is as close as I can get you.It has some info to squadrons, but that's it
Associating tail numbers with particular Bureau Numbers is something I've been trying to do for the Sikorsky HRS at my site, www.hrs-helicopter.com. My source material comes primarily from photographic evidence. The trouble is that every airframe would have been assigned to more than one squadron if it had a "normal" service life which means it would have carried a different tail code for every squadron or every time it cycled through the same squadron. Squadron logs or recordsmay contain the data and those may be held by the Naval Historical Center.
Buno/Tail no.
Unfortunately, when these aircraft were transfered from squadron to squadron the side number would change to whatever fit each squadrons needs. If they needed a YW-11, or an ET-20 that's what it became. I don't know of a registry that shows all of them, birth to retirement.