The California Bureau of Automotive Repair – our friendly emissions laws enforcers – have an online database which indicates past smog check history on vehicles within the state…searchable by VIN number or license plate number. In California, an emissions test and smog certificate are required to register a vehicle for use on public roads. Regarding 914s, the 1970-74 cars are now exempt from testing, and the ’75 cars will be exempt in January 2004.

I am interested in the 1974 LE cars in particular, so the database should be very current, they only became exempt in January 2003. I sequentially entered individual VINs covering the known VIN range of the LE cars – VINs 4742914000 through 4742917000 (about 2.7% of all 914s ever produced) and got back some interesting results. Any statisticians in the house? I realize this is a small sample compared to the total population of 914s produced, so what degree of error might there be with these extrapolations?

Of the 3000 VINs I checked, 262 (8.7%) had a smog cert history:

144 cars (4.8%) had valid smog certificates on December 31, 2002, the last date they were required to have smog certificates in this state. This means that only these 4.8% of the 914s produced within that VIN range, were legally allowed to operate on California roads on December 31, 2002.

An additional 118 cars (3.9%) had recent smog certificate history, where I define ‘recent’ to mean that these cars had previously received a smog cert or had attempted to get a smog cert and failed, at various dates between 1996 and 2002, but the smog cert had expired and was not in effect on December 31, 2002. These cars would not be allowed to operate on California roads on January 1, 2003 or after, without first getting new registration, but as of that date they became exempt from emissions testing, so registration for these cars would now be possible if they were still roadworthy. The BAR online records go back as far as August 1996, which includes the last seven years history.

The database also lists the location where the last emissions test occurred. Surprisingly (or maybe not), the surviving 914s within this VIN range are about evenly distributed between Northern and Southern California based on the BAR records. 120 cars (46%) had smog cert history listed from Northern California cities, and 142 cars (54%) from Southern California cities.

Conclusions

If these percentages for California cars hold true for all 4 cylinder 914s made from 1970-76, using 115,000 total 914/4 cars produced, this smog certificate database suggests that on or about January 1, 2003:

1. 4.8% of all 914s made (~5,520 cars) may have been registered and operational in California on January 1, 2003. This would require them to be essentially in stock form, with working stock fuel injection and an engine in good enough condition to pass an emissions test.

2. Potentially as many as an additional 3.9% of all 914s made (another~4,485 cars) may also exist and become registered and operational in California, when all model years of the 914 cars become exempt from smog certificate requirements (January 1, 2005). These cars include all the 914s that had emissions testing history as far back as 1996 as potential candidates for registration now that they are smog-cert exempt.

3. So California itself may have between a minimum of about 6,000 to a maximum of 10,000 914s surviving, licensed, registered and on the road. And our goal for the June ’04 West Coast Classic is only 100 914s, where are all the other 914s hiding? Its probably reasonable to assume that the total number is more realistically around 7,000 or 8,000 surviving, drivable-condition cars statewide, the rest are basically parts cars. Note also that this data indicates that about half of all 914s in California are stock FI cars, which doesn’t make sense from personal experience. Stock FI cars are the exception, the majority of 914s we see have been modified in some way, making the modified cars technically unregisterable in California if they were ever to be inspected.

4. How many of these California cars ARE NOW on the LE Registry? There are 14 known LE cars located in California at present, but only 11 have any sort of smog cert history, so 3 of those 14 cars have fallen off the BAR database. I only know the VINs and last smog test location of about half of these LE cars, but have no current owner information on several of them. Can anyone run the VINS or license plates for me and get owner info? (legally?)

5. How many of these California cars within the known LE VIN range COULD POTENTIALLY BE on the LE Registry? There are 187 cars with smog cert history in California, within the VIN range of known LE cars, some of which may be LE cars. Note that there are many cars on the LE Registry that their current whereabouts are not known…there are most certainly more LE cars in California as well as in other states.

6. The data suggests that both NorCal and SoCal regions might have as many as 5,000 cars each, but remember that only about half of the surviving cars may be drivable.

The caveats

The 914/6 cars are not included in this study because they use a different VIN sequence and they have been smog cert exempt in California for many years.

This database of course can offer no insight to the number of 1974 (and earlier) model year cars that are track-only, registered non-op, cars shipped out of state or parts cars that have simply fallen out of the BAR database. So the 500 cars at Rich Bontempis house are not included in these ‘survivor’ numbers. They are donors. 8^)

Its possible that if a non-op car was in pretty good shape but couldn’t or didn’t pass a smog check before January 1, 2003, that they may have come alive again after the smog cert requirement was dropped and are now registered and back on the street.

I extrapolated these percentages on a limited sample of total VINs and applied them across all years 914s produced with the assumption that the percentage of surviving cars would be relatively consistent across all model years. That’s a big assumption. However there are not likely to be as many early (1970-72) or late (1975-76) cars around (because fewer were made than the 1973-74 cars). So the percentage of 73-74 cars surviving as reflected in the BAR data, may be somewhat greater than the overall percentage of all surviving 914 cars across all model years. This may tend to make the maximum number of 10,000 surviving 914s in California optimistic.

Obviously, not all of these cars are in California or even exist anymore…some have been shipped out of state, parts cars, ‘converted to off-road use only’, or otherwise destroyed…

To think about: So how do we define what a ‘surviving’ 914 is? Is a surviving 914 only a licensed, registered, drivable car? Is a tub roller or an incomplete parts car considered a surviving 914 in its current condition? How about a bunch of boxes of parts necessary to assemble a 914? Then of course there is Brads tube car…looks like a 914 but isn’t…let the philosophers speak up…

Hey,

Ought we build an automated tool that scrapes all the possible VIN numbers and sticks them in a database???

What are all the valid VINs?

l8r,

Fiid.

I only have the 262 specific VINs which turned up during the 3000 VIN range search. The other VINS could be searched...but someone else will have to do it...

Jeff, you are a nut.

This is a compliment.


M

OT. I get a notice from the Cal, BAR every few years saying that I can scrap my 70 914 and get 500$. I got sniffed as a gross polluter a few years ago. The BAR sent me a notice asking me to bring my car in for a Smog Test. I never did..

Bring your car in and do what with it ?

Smog Test.

Yeah, I know....Brad thinks I am anal too...but I dont really understand that term...

What I mean is - how do you decode a 914 VIN? How would I generate a valid one?

If it's like: YYYYWWXX (YEAR, WEEK, NUMBER) - then I can generate them by starting at 19700000 and incrementing through to 19765299 - right? So if I write a piece of code to do that, then punch that number into their website and record the result, then I would have a db that I can then make searchable (and we can mine it for info.)

Could be a fun project.

Fiid.

Anal is when you get one LE and then want to get the remaining 999.

DaveP

I took a quick look at it. It would be easy enough to extract the data. But, what's the purpose?

The purpose is so Jeff can know EVERYTHING THERE IS TO KNOW about LE's.

Next he will being going to each state's DMV doing the same thing.

A man with a mission.

Paul

i have a 76 complete bone stock legally smogged teener on which everything works .
i also am a resident of cali .
what is the range of the vins# for the LE model ?
i have yet to see a stock 76 that ran and smogged in cali since i bought my car.

jt

The VINs gotta be added one at a time...

I had a friend (Miles Julihn) who had a nice 49 state 76 car...but he had to put a cat on it to sell it...so it would pass smog.



4742914375 to 4742916598 so far...I have that memorized...maybe I am...anXX...oh and I only own 2 LE cars right now and one is FS!



Cool Paul...hadn't thought of that one...yet...

If we write a piece of code to do this we could crawl all the state DMVs automatically.

Fiid.

Sounds amazing and impossible. I've been here for 6 years...bought a 76 2.0Lin year 2 -Bonnano is now making it a great car...and have a 73 1.7 right now...

During the 4 years I owned the 76 I only had to smog it 2 times, so would the car have appeared in your search?? Once in 99 and once in 2001.

Also, as often as us Californians drive around and around, I admit I havent seen many 914's. There are a fair amount of cars in garages and driveways. One time in downtown San Diego I nearly cried as I walked by a lot that had at least 3 914's in need of a lot of attention. Then one time, at band camp...

Seems we should see more cars considering your conclusions but...I dont know. In Mira Mesa there are at least 5 cars for sure..I bump into the drivers every so often and ask them if they are members of 914world.com so perhaps they have joined. I dont know, I'm just enjoying rambling..

Yes, thats just what I think. I don't think a rusty tub sitting in someones front yard is a 914. Ya can't drive it!

Geoff

You guys are either math gods or internet gods, or both (only one of you I'm sure of). Sounds like the digital equivalent of "you can't turbo a 914" - "you can't hack all 50 DMV's". I imagine some 914 vendors would pay to see those cards. Hell, I bet some 911 vendors would pay big bucks to see those cards, especially if they're sorted by year and model... And what about Chevy's and Fords for chrissakes??? When's the IPO?

Interesting data. I'll ask at the local DVM if they can search their data base for 914's. I know they are cross linked with other provinces, but not sure if they are crossed linked with all of them. They charge a fee to search a title for a specific car, so i'm not sure if they will to do a mass search by model (or if they can)

Only one of the five I own would show up in their (Canadian) data base. Another would show up in the Texas data (last reg. March 2002 and another in the California data (last reg. 1999) The other two unknown.

From a legal standpoint a 914 is still a 914 untill the vin tags/numbers are surrendered as a destroyed car. (made into a cube/cut up, ect)

My evil step-mother-in-law works for AAA, think they have the ability to search the CA DMV records for 914's ????

I've personally cut-up/thrown away 3 complete 914's...we need a database for those that are forever lost

The change on smog requirements that went from 67 - 73 occured when I owned the "Rocket".....that was when my twins were in diapers.....sooooooo....it wasn't THAT long ago that the /6 were exempt and should still be in the database. If they ARE NOT, they should be in a purge file that is accessible via the California Public Records Act at the BAR.....but what do I know.....

BTW...those files should be accesible for 30 + years....ya might wanna hurry.

Yes all the 76 cars should be in the BAR database...as well as any car that has had a California smog test in the last 7 years.

Here is the webite link, try it yo'sef...:

http://smogcheck.ca.gov/vehtests/pubtstqry.aspx

I just tried to search for smog test history on two original sixes that are in my area...Carls and KRKs. there is no data available for either of these two known sixes.

Love the analysis. As an engineer who does a lot of this, I'd say your review of 3000 Vin queried should carry nicely forward to the 115,000 total.
It Raises a favourite question of mine...Can anyone estimate how many 914s survive in the US? I'd be amazed if it is more than 10% being 30+ years out
I'm in Massachusetts, north west of Boston and I only know of 3 on the road in our area.

Cheers
Doug

There is more than that in the greater boston/new hampshire area....

Mark S, Richard T. Matt R. Mine, etc. etc....I am guessing about ~20?

I remember Brad posting an estimate of remaining teeners early this year, though most of them were sold in CA, so most of the survivors will be in CA. I am aware of a half dozen or so driveable teeners here in sunny (at least it was a few months ago) Connecticut.

Last night (from 4am to 7am) I wrote the code for reading entries out of the Ca BAR database over the web. It is non trivial, because they generate a cookie on each page that you have to send back to the server. Grrr.

I found the following VIN info, which I think will allow me to generate all the possible vins (seems pretty straightforward).


/**
* http://www.porschedecals.com/history914w.htm
*
* 914 VINs
* 470 29 00001-470 29 13312
* 471 29 00001-471 29 16231
* 472 29 01400-472 29 21580
* 473 29 00001-473 29 27660
* 474 29 00001-474 29 21379
* 475 29 00001-475 29 11369
* 476 29 00001-476 29 04100
*
* 914/6
* 914 043 0011-914 043 2668
* 914 143 0011-914 143 0443
* 914 243 0011-914 243 0260
*
* 916
* 914 233 0011 - 914 233 0020
* Prototype 914 143 0195
*
*/

Does this look right? I guess we are looking at about 140,000 queries - so if we do a query every 10 seconds (trying not to arouse too much suspicion) it will take 16 days to query the entire vin pool.

Is this illegal? The terms on the website say that the info is available for personal and non-profit use, so it seems okay to me.

Fiid.

Easier to ask forgiveness than permission.....hopefully the inquiries will not be construed as a denial of service attack.....good luck.

Nope - I was thinking of restricting it down to 1 every 10 seconds or so. That way it's not really any extra load for their server.

Fiid.

we have ALL the possible VIN numbers in our club info section

http://www.914world.com/specs/chasnrs.php

hope you didn't spent too much time searching the web.
Andy

interesting!

just ran my VIN and got a result:

Station Name	License	VIN	Make	Model	Year	Date / Time	Pass / Fail	Certificate
MC GUINNESS MECHANICS SAN RAFAEL	3MEP345	4702912181	PORSC	914	70	02/06/97 09:53 a.m.	P
MC GUINNESS MECHANICS SAN RAFAEL	3MEP345	4702912181	PORSC	914	70	02/06/97 09:06 a.m.	F

I ran the 71s vin (Tennessee) it was last reg in California in 99 (on the title) but there is no listing in the BAR database.

Could you have a car reg but it not be in the BAR database?

in your case yes, look at my record.
97 was the last entry for the '70 ...

yours is '71, so it was smog excempt in 99 ...
Andy

But wouldn't it be in the BAR database from previous years? Or do they (BAR) purge their data after the exemption comes into effect?

Of the 3,000 VINS I entered, the oldest record was from August 1996. They surely must purge records...looks like about 7 years back is all they keep.

There are also cars here in CA that I know exist, but have fallen off the BAR database and are not registered.

Not for that. All the time was taken with this:



I do have to clean it up though.

gawd, i hate it when people don't put a space between the
IF and the ( ....

am i a geek?
Andy

You're a geek - but I knew that anyway. :-) Everyone likes their code to look slightly different, so I make no apologies; for this project I don't have to adhere to any coding standards. JBuilder will re-arrange it anyway I tell it anyway, so it's not a worry!

Fiid.

what ever happend to DIY ???

what's wrong with using VI (or notepad for windoof users) and a command line compiler ???

kids
Andy

Nothing wrong with that. I grew up on emacs (or xemacs). I can do it all by hand - it just takes longer.

Same reason you had your car sandblasted instead of using Sand paper and wire brushes!

Oh yeah - there are command line code formatting tools out there if you prefer.

In JBuilder it's Right-Click -> Format All.

FREAKS.

Fiid.. how are you with PHP ?? You could have 914 parts at ost for the rest of your life ..LOL


B