Differences between revisions 13 and 14
Revision 13 as of 2009-04-16 14:32:03
Size: 5669
Revision 14 as of 2009-04-22 17:26:36
Size: 5843
Deletions are marked like this. Additions are marked like this.
Line 7: Line 7:
[http://bazaar.launchpad.net/%7Eszybalski/insurancecycle/trunk/annotate/head%3A/insurancecycle/insurancecycle/lib/vin/nhtsa/49cfr565/49cfr565.5.pdf 49cfr565 vin decoding]


How to Decode a VIN

Initial explanation taken from [http://www.angelfire.com/ca/TORONTO/VIN/VINcode.html Source1], [http://www.autoinsurancetips.com/decoding-your-vin source2]

When decoded, the VIN tells the country and year of manufacture; make, model and serial number; assembly plant; and in some cases it even identifies equipment specifications. The system goes something like this: sequence for characters is first A to Z, then 1 to 9, and last 0. The letters "I", "O" and "Q" are typically omitted from system. [http://www.access.gpo.gov/nara/cfr/waisidx_05/49cfr565_05.html VIN USA Requirements] [http://bazaar.launchpad.net/%7Eszybalski/insurancecycle/trunk/annotate/head%3A/insurancecycle/insurancecycle/lib/vin/nhtsa/49cfr565/49cfr565.5.pdf 49cfr565 vin decoding]

The vehicle identification number is divided into four parts:

  1. The World Manufacturer's Identification (WMI - VIN(1-3 characters);
  2. The Vehicle Description Section (VDS - VIN(4-8) five characters);
  3. The check digit; VIN(9)
  4. The Year of the car VIN(10)
  5. The Plant where the car was build: VIN(11)
  6. The Vehicle Identification Section (VIN(12-17)

Federal Motor Vehicle Safety Standard #115 ( 565) [http://www.nhtsa.dot.gov/cars/rules/maninfo/newManf.pdf New Manufacturer Information]

  1. [http://edocket.access.gpo.gov/cfr_2008/octqtr/pdf/49cfr565.15.pdf 49cfr565.15 Vehicle Year]

565.1 Purpose and scope.
565.2 Application.
Subpart B—VIN Requirements
565.10 Purpose and scope.
565.11 Applicability.
565.12 Definitions.
565.13 General requirements.
565.14 Motor vehicles imported into the
United States.
565.15 Content requirements.
565.16 Reporting requirements.
Subpart C—Alternative VIN Requirements In
Effect for Limited Period
565.20 Purpose and scope.
565.21 Applicability.
565.22 Definitions.
565.23 General requirements.
565.24 Motor vehicles imported into the
United States.
565.25 Content requirements.
565.26 Reporting requirements.

When decoded, the VIN tells the

  1. Country;
  2. Year of manufacture;
  3. Make,
  4. Model/Some equipment specifications.
  5. Assembly plant
  6. Serial number;

World Manufacturer’s Identification (WMI)

[http://www.nhtsa.dot.gov/cars/rules/manufacture/ NHTSA Manufacture's Database] [http://www.sae.org/standardsdev/groundvehicle/vin.htm SAE Standard $500 for a database]

The first character in the WMI sequence represents the country where the vehicle was manufactured. Countries like the United States (1 or 4), Canada (2) and Mexico (3) are represented by numbers while other countries such as Germany (W), Italy (Z) and Japan (J) are represented by letters.

The second character refers to the manufacturer. The characters can be either letters or numbers. For example: Jaguar (A), Dodge (B), Chrysler (C), Jeep (J), Buick (4), Cadillac (6) or Saturn (8).

The third character represents the vehicle type or manufacturing division.

For Programmers

apt-get install mdbtools
  • [Optional] Graphic fronted so you can browse the web.

apt-get install mdbtools-gmdb
  • Create mysql database and then tables

mysqladmin -u root -p create manufacturer
mdb-schema database.mdb | mysql -u username -p database_name
  • Export

mdb-export -I manufacturer.mdb WMI | sed -e 's/)$/)\;/' |mysql -u username -p database_name
mdb-export -I manufacturer.mdb WMI | sed -e 's/)$/)\;/' > WMI.mysql  
mdb-export manufacturer.mdb WMI >WMI.csv                   

Vehicle Description Section (VDS) and Check Digit

[http://www.nhtsa.dot.gov/cars/rules/manufacture/ NHTSA Manufacture's Database] includes these databases:

  1. [http://www.nhtsa.dot.gov/cars/rules/regrev/evaluate/808062.html Plasti-glass windows]

  2. New Tire and re-treaded tires.
  3. [http://www.nhtsa.dot.gov/cars/rules/import/FAQ%20Site/ 565] -NHTSA information the agency will need to decipher the manufacturer’s vehicle identification number or “VIN” format

  4. [http://www.nhtsa.dot.gov/cars/rules/import/FAQ%20Site/ 566] -letter to NHTSA identifying the manufacturer’s name, address, and the products it manufactures that are subject to the Federal motor vehicle safety standards

The vehicle description section consists of five characters (the 4th to 8th characters) which identify everything from the body style, engine type, and braking system to model, series, restraint system, etc. The 9th character is a VIN accuracy check digit which verifies the previous VIN numbers. It is determined by carrying out a mathematical computation developed by the Department of Transportation (DOT). Vehicle Identification Section (VIS)

The vehicle identification section includes the last eight characters in the VIN number. The numbers identify the model year (10th character) and the assembly plant for the vehicle (11th character). A number or letter may represent the model year. For example: 1998 (W), 2000 (Y), 2007 (7) or 2008 (8).

The 12th to 17th characters are the actual serial number of the vehicle—these last 6 digits make the vehicle unique (think of DNA). It can also help to identify whether the vehicle was the first, the hundredth, or the last vehicle off the manufacturer’s assembly line. This is valuable information for collectors.

So, the next time you see that long number printed on your registration papers or stamped across your dashboard, you’ll know how to decode it. This will give you a better understanding of where your unique vehicle actually came from!

Classic Cars


move data to mysql

import MySQLdb
>>> db=MySQLdb.connect(host="localhost",user="myuser",passwd="mypassword",db="manufacture")
>>> import csvtosql

MyWiki: VIN (last edited 2009-09-06 02:50:27 by localhost)