Well, I think the road may be at its end.
The Excel file should have all 350 ZL1 VINs now if I'm correct (which I'm betting I am)
Excel file (linked on first post)
I'll explain my process since no new cars were being posted on social media for the missing Mexico cars. I thought to cut down on a lot of guesswork the best way would be to find the sequence of the other cars that were built off of Lansing Grand River Plant. The only other two are the Cadillac CT4 and CT5, with a few changes to the script I'm pulling the data on them (it's been almost a week and I'm almost done, why does Cadillac have so many different variations). When it's finished I'll give a visit to their respective forums to see if anyone's interested in that.
I added the 2024 Camaro data to the 2024 CT4/CT5 data I pulled and the sequences line up perfectly in many cases. I used the gaps between known CE ZL1 cars as starting points and tried to find anything.
Unfortunately, since the Mexico cars aren't kept in the US VIN systems, I couldn't find any way to verify if a VIN was right. Until I found the warranty check site from GM.
https://experience.gm.com/ownercenter/recalls?vin=
While not an API endpoint like the window stickers, I was able to test the potential cars against that. Again the information the site gives isn't much but I did see a pattern.
CE #001:
https://experience.gm.com/ownercente...FJ1R6XR0100021
Results in a 2024 Chevrolet Camaro A with active warranties.
For example a test VIN:
https://experience.gm.com/ownercente...F91R65R0103028
Results in "Currently, there are no recalls or warranties for your vehicle..." etc.
So not a match there. But the match can be found here:
https://experience.gm.com/ownercente...F91R68R0100043
"2024 Chevrolet Camaro A" and if you scroll down the warranties say Mexico.
Thankfully it seems the missing ZL1 cars were the only ZL1s sent as I didn't find anything that didn't match the missing CE ### ranges. (Minus #112 which is potentially one of two VINs. Both Mexico ZL1's and both match in the range of 112)
My minor obsession with 'find them all' is over.
For now...