PDA

View Full Version : Color Combo Data for All ZR-1's


QB93Z
02-04-2010, 12:49 AM
I have completed a project to gather the color, interior color and roof option data for all ZR-1's. The data was obtained by entering all of the ZR-1 VIN's at a website that gives the RPO codes for any GM VIN. http://www.compnine.com/vid.php?vin=1G1YZ23J0L5802556



Here is a summary of the data:

http://i407.photobucket.com/albums/pp152/QB93Z/COLORDAT.jpg


The complete year-by-year lists for all cars will be posted on the ZR-1 Net Registry Website soon. http://www.zr1netregistry.com/. It may take a little while to get the data formatted and posted.

There are still 16 VIN's that I didn't find data for (16-1990). If anyone has another way to search GM VIN's let me know and I will provide the VIN's of the missing cars. Maybe somebody can stop by the NCM and look at the build sheets.

Since the 1994 and 1995 cars were all researched and listed by Art Wong some time ago, I did not redo that project.

I make no gaurantee that the data is correct. There may be errors. If any errors are found, please let me know so that I can correct the database.

I know that there are a lot of people here that maintain ZR-1 data lists. I will be glad to provide an Excel file of the data to members of the ZR-1 Net Registry. Please contact me at my email address: jim@gizmosart.com.

As a part of this project, I generated a list of the VIN's for all the ZR-1's. I can provide that list also, if you contact me.

Enjoy

Jim

phrogs
02-04-2010, 02:52 AM
Thats alot of work!! I think we need to find you a new hobby

QB93Z
02-04-2010, 09:38 AM
Thats alot of work!! I think we need to find you a new hobby

Well said Johnny!

Now that I am done, I can get back to my real hobby, driving the ZR-1's. :dancing

bobbyhi
02-04-2010, 09:53 AM
Great job Jim.:handshak: Thanks for all of your hard work....:cheers:

ZZZZZR1
02-04-2010, 09:54 AM
I can personally tell you he put in a ton of man hours on this one...


Way to go Captian!


:thumbsup:


David

Hammer
02-04-2010, 09:11 PM
I have them done by the years for interior and extrior but I was missing a few VIN's for some color combos. I don't know how to post spreadsheets or I would have. Let me know and I can do that. Better yet I'll send mine to Jim.

Here it comes.

gbrtng
02-04-2010, 09:33 PM
The number of 91 turqs and other colors looks correct here. The number of cars and the number of cars by color did not agree in much earlier published totals. Thanks for the great job, Jim.

jrd1990zr1
02-04-2010, 09:34 PM
Thank you for your efforts!!!

Are you missing information on specific VINs? Maybe you should post the VINs and the owner will step forward????

I am especially interested to find out how many 1990 Charcoal met. exterior came with light gray interior.

:cheers:

QB93Z
02-04-2010, 11:46 PM
Thank you for your efforts!!!

Are you missing information on specific VINs? Maybe you should post the VINs and the owner will step forward????

I am especially interested to find out how many 1990 Charcoal met. exterior came with light gray interior.

:cheers:

There are 44 Charcoal with Gray interior in 1990.

eMail sent.

Jim

95 LT5
02-05-2010, 12:47 AM
Also check the thread in the other fourm for info on the '95 Cars

bdw18_123
02-05-2010, 01:35 AM
There are 44 Charcoal with Gray interior in 1990.

eMail sent.

Jim

I have a spreadsheet that I think you sent me a couple months ago but I'm not sure. It's very incomplete (at least for 90-93 it is), although I have been adding cars as I come across them on the internet. Have you completed that spreadsheet? If you could send me an updated copy, that would be cool!

I'm interested to know about the number of white/red '90 Z's.

GrayZ
02-05-2010, 09:45 AM
Jim:

Thanks for going above the call of duty to share you're research. :cheers:

QB93Z
02-05-2010, 10:02 AM
I'm interested to know about the number of white/red '90 Z's.

There were 66 Arctic White with Red interior made in 1990.

Red was the most popular interior color for white ZR-1's in 1990.

Have you ever seen an Arctic White with the Blue interior? There were 5 made in 1990 and 15 made in 1991, but I have never found one.

Jim

Z Factor
02-05-2010, 10:21 AM
Great job Jim. :thumbsup:

As I said to Art many years ago, your efforts will help countless people interested in the ZR-1 and it's history.

On behalf of us all, thank you.

JIM

:cheers:

QB93Z
02-05-2010, 10:58 AM
The chart on the original post has been updated.

:thumbsup: Thanks to Dave (WVZR-1) for adding the data for the two 1991's that I was missing.

1991 #005 is Bright Red / Black with the clear top
1991 #006 is Bright Red / Red with the clear top

He is working on the sixteen 1990's that are missing, but they didn't come up in his initial attempt.

Jim

rudolph schenker
02-05-2010, 11:17 AM
Thanks for the chart and info! :cheers:

bdw18_123
02-05-2010, 05:21 PM
There were 66 Arctic White with Red interior made in 1990.

Red was the most popular interior color for white ZR-1's in 1990.

Have you ever seen an Arctic White with the Blue interior? There were 5 made in 1990 and 15 made in 1991, but I have never found one.

Jim

Out of 3,049 '90s, 66 white/reds isn't that many. Comes out to about 2.2% of the total 1990 ZR-1 production. So it's a somewhat rare color combo.

Interesting, white/steel blue combo? No, I have never see a white '90 with that interior. Over at CF, someone posted up a black '91 Z that has the steel blue interior though. It's on ebay right now, bidding is at $21K.

I sent you an email for the list.

bdw18_123
02-05-2010, 11:58 PM
I noticed that '93 ZR-1's #1 & #2 are missing. Are they unknown or did they just get accidentally deleted?

QB93Z
02-06-2010, 12:50 AM
I noticed that '93 ZR-1's #1 & #2 are missing. Are they unknown or did they just get accidentally deleted?

Yes, it was an accident when I put the header on the page.

Thanks, I will correct that page.

1993 #1 is Competition Yellow/Gray with both tops and RPO VS7
1993 #2 is Polo Green II/Black with a clear top only and RPO VS7

(RPO VS7 designates a Performance Evaluation Program vehicle)

Jim

WVZR-1
02-14-2010, 09:39 AM
I don't believe there were builds beyond #3032 and all of those I believe are accounted for. For the "assumed" missing information I used the VIN's compiled by the VIN generator Jim used. I also confirmed this information using a second VIN generator/comparator.

There's NO RPO information for any of these VIN's. Using the same information there are NO records using CARFAX for transactions regarding these VIN's and as a final check there was a seatbelt recall that was specified for ALL VIN's. A GM inquiry for these VIN's revealed "NO INFORMATION". Sales and build history is deleted after maybe 10 years but RECALLS that aren't completed remain recorded as "open" until completed by a GM dealer.

It's difficult to believe that the GM RPO information isn't found, there's no CARFAX records for any of these builds and that the RECALL information was "skipped" by the GM VIS (Vehicle Information System).

After this research I also found this article:

http://www.vettefinders.com/index.cfm/fuseaction/corvette.Vette101Story/ID/6

I'd say it's safe to assume the color combination information for MY '90 is complete?

I believe Jim was going to attempt a confirmation from the NCM but I haven't heard from him for a few days.

Thoughts??

QB93Z
02-14-2010, 10:28 AM
You have done some great research Dave. I agree with your conclusion that there were 3032 1990 ZR-1's built. I am going to start a new thread to get more visibilty on this issue.

Jim

Aurora40
02-14-2010, 11:17 AM
Yeesh man, you manually punched in 6000+ VINs (including calculating the check digit) by hand?? If you try to do something similar again, let me know. I suspect it could have been automated. Good work, though!

QB93Z
02-14-2010, 12:10 PM
Yeesh man, you manually punched in 6000+ VINs (including calculating the check digit) by hand?? If you try to do something similar again, let me know. I suspect it could have been automated. Good work, though!

I "automated" the VIN generation and Web search link creation using Excel. But I had to scroll down and read the RPO data manually. Then I had code that would quickly record the results. If you know someone who can code javascript, I would be interested in finding a way to extract the perninent RPO data and record it. Then I could run all the data again to get the other interesting data such as AC control and "export cars".

Also I could double check my data. Another WAZOO member checked my data for the 1992's and found 4 errors. So a validation run would be apppropriate.

Jim

Aurora40
02-14-2010, 12:56 PM
Hey Jim,

I wouldn't do it in javascript, that is a browser-executed language and I don't know it that well (I can figure out what stuff does but am not familiar enough to code up anything). But I get what you are saying.

If you are not in any rush, I'll take a whack at pulling the relevant info out (paint, interior, roof panel, anything else?) and sticking it in a small database. I could then export it to a CSV or something if you prefer excel. I'll mess around with it when I have free time, it might take a while as I'd probably try some things I've wanted to try just for the sake of trying them (I do this for a living, and am always interested in learning some new skills).

QB93Z
02-14-2010, 01:31 PM
Hey Jim,

I wouldn't do it in javascript, that is a browser-executed language and I don't know it that well (I can figure out what stuff does but am not familiar enough to code up anything). But I get what you are saying.

If you are not in any rush, I'll take a whack at pulling the relevant info out (paint, interior, roof panel, anything else?) and sticking it in a small database. I could then export it to a CSV or something if you prefer excel. I'll mess around with it when I have free time, it might take a while as I'd probably try some things I've wanted to try just for the sake of trying them (I do this for a living, and am always interested in learning some new skills).

I agree Bob, it was a challenge I tackled just to see if I could do it.

Here is the website link:

http://www.compnine.com/vid.php?vin=1G1YZ23J0L5802556 (http://www.compnine.com/vid.php?vin=1G1YZ23J0L5802556)

The resulting page lists the RPO codes and then a listing of RPO meanings and frequency data that we don't need.

If you "View Source" on the page above and look at line 362, you will find the HTML code for the table and all of the RPO data embedded. If you could pull out that block of HTML code and save it, we could fairly easily extract all the RPO data we wanted from it.

If you need the VIN generator program, I have it as an Excel file.

Jim

Aurora40
02-14-2010, 07:25 PM
Hey Jim,

So I am running through the 1990 cars at a rate of about 1 every two seconds (I'll do the other years later, I have to manually check the valid VIN range because I'm too lazy to write robust detection of that case). I'm putting them in a relational database that just associates cars with options. So all RPOs are accounted for, but can be searched and cataloged more easily than a big blob of HTML associated with each car.

The biggest pain was writing the damn VIN check digit generator...

Anyway, once it's done I can pretty easily do queries. I could probably set up some kind of web interface as well. Or if you are familiar with databases, I could just export it as BCP files that you could load in a database, or I could turn them into excel-compatible CSV's, or whatever is the most useful. If nothing else, I can tell you how my color totals compare to yours.

QB93Z
02-14-2010, 08:26 PM
Hey Jim,

So I am running through the 1990 cars at a rate of about 1 every two seconds (I'll do the other years later, I have to manually check the valid VIN range because I'm too lazy to write robust detection of that case). I'm putting them in a relational database that just associates cars with options. So all RPOs are accounted for, but can be searched and cataloged more easily than a big blob of HTML associated with each car.

The biggest pain was writing the damn VIN check digit generator...

Anyway, once it's done I can pretty easily do queries. I could probably set up some kind of web interface as well. Or if you are familiar with databases, I could just export it as BCP files that you could load in a database, or I could turn them into excel-compatible CSV's, or whatever is the most useful. If nothing else, I can tell you how my color totals compare to yours.

That is great Bob!

CSV files would work best for my use.

You have done much more in one afternoon than I did with ~70 hours of work. Well Done.

I will contact you by eMail.

Jim

-=Jeff=-
02-14-2010, 10:34 PM
Cool.. So in the info you acquired. How many 1990 ZR-1s had the C60 RPO??

I know that is still a mystery, Also how many Black with Red interior 90s?

and if you have the C60 info, how many Black with red with C60?

Aurora40
02-15-2010, 09:38 AM
Cool.. So in the info you acquired. How many 1990 ZR-1s had the C60 RPO??

I know that is still a mystery, Also how many Black with Red interior 90s?

and if you have the C60 info, how many Black with red with C60?
It wasn't done yesterday, the site slowed down a lot (not surprising I suppose).

124 cars have C60 manual air. 37 are black, and 5 of those have red interiors:

1G1YZ23J6L5800598
1G1YZ23J9L5801051
1G1YZ23J5L5801581
1G1YZ23J9L5802491
1G1YZ23J5L5802679

There are 71 black/red 1990's of 907 black cars total

QB93Z
02-15-2010, 09:42 AM
Cool.. So in the info you acquired. How many 1990 ZR-1s had the C60 RPO??

I know that is still a mystery, Also how many Black with Red interior 90s?

and if you have the C60 info, how many Black with red with C60?

Bob answered the question while I was typing my reply.

Jim

-=Jeff=-
02-15-2010, 09:46 AM
THANKS GUYS!!!

so my 1990 Black Red C60 car is 1 of 5 !!!!

AWESOME

scholtmj
02-15-2010, 07:12 PM
I just checked out the data on the net.registry member site...WOW =D>

Obviously lots of time spent researching and organizing data.

Interesting finds:
My car was originally a painted top car even though I bought it with a bronze top. I'll have to double check the NCM window sticker

Lots of rare 1 of 1 or 1 of 2 93' color combos due to the Ruby option that year.

Had no idea that many Z's were ordered with a white interior.

PhillipsLT5
02-15-2010, 10:30 PM
Where do I find the info on ZR-1.net

QB93Z
02-15-2010, 10:39 PM
Where do I find the info on ZR-1.net

Go to the ZR-1 Net Registry Site:

http://www.zr1netregistry.com/

Click on the Members Only link (located on the blue bar right below the gold ZR-1)

You will need the new password to enter the members area.

The links to the pages are on the left side of the members area home screen.

Jim

Blue Flame Restorations
02-15-2010, 10:45 PM
Is there any recorded data for the 88 and 89 prototypes? I suppose that the build sheets for the prototypes would show this data. This info could be obtained from the NCM if the vins are known. Tyler may have this info already??

QB93Z
02-16-2010, 12:03 AM
Is there any recorded data for the 88 and 89 prototypes? I suppose that the build sheets for the prototypes would show this data. This info could be obtained from the NCM if the vins are known. Tyler may have this info already??

If the prototype cars were built with a VIN, we can try looking them up.

Jim

BlackWidow#2
02-16-2010, 12:35 PM
Hi Jim,
Although I never owned a Z with a white interior, I have always been intrigued by them. Finally I can see how many and what the combinations built were!
Thanks for all your hard, time consuming work.
George