SELECT modelname, brand, year FROM model
WHERE modelname NOT IN (

SELECT  DISTINCT modelname FROM car
INNER JOIN model USING (modelid)
WHERE registrationdate IS NOT NULL)