Thank you for the nice answer. I suppose that Fano threefolds are the only class of threefolds whose explicit classification is known. Calabi-Yau threefolds must be very difficult and general ones are even worse, I guess.