I don't think your table is normalized. Your have two entities, cars and parts. One car can have several parts, on part can be used in several cars. That's an m:n-relationship. This has to be realized by two 1:n-relationships.
You're right it wasn't normalized, that why i needed the query to do an insert into the new normalized table.
My new structure looks like the one you suggested.