Civilian Aviation

G'day all,
I'm having trouble trying to sort out the plethora of designations that the above give their aircraft. In particular, tying up a designation to a 'popular name'.
For example the BD, CRJ/CL and Gulfstream series. Does anyone know of a reference table or website that might help?

Many thanks
V1

It does not help explain the methods used, but try this for bizjets ----


https://www.laasdata.com/corpjet/

Always very up to date. Credit to LAASI club.
Pete.