[dba-Tech] VIN Coding/Decoding?

MartyConnelly martyconnelly at shaw.ca
Thu Jun 30 02:45:46 CDT 2005



Shamil Salakhetdinov wrote:

>Hi All,
>
>Is there anywhere VIN coding/decoding decription and information?
>Is that an open(free) information or it has to be bought from somewhere?
>I did find this http://yarchive.net/car/vin.html but it's incomplete.
>
>Thank you in advance for any additional information on VIN decoding!
>
>Shamil
>
>
>  
>
 I have only messed around with this but I don't think you want to do 
this from scratch
The data is updated monthly by car manufacturers. Some US government 
department may
have a full database, like the FBI, but commercially it is generally 
being done by a web service.
Most commercial ones are not yet complete and still being built to 
include heavy trucks, RV's and motorcycles.
Some web services will give you proper complete info anywhere between 
67% to 95 % of the time
depending on which one you use. You will have to get quotes on cost per 
web  transaction
but it is probably around $0.50 to a $1.

And things like a 1964 Corvette have only 9 digit VINS. Who knows what 
is on a East German Trabant.

Maybe you can pick up a free VIN database from NewZealand or Australia
I have an Access database with the US NHTSA Safety and Manufacturers 
Vehicle Recalls
and that is available on line as a text delimited file.

I have seen PDA's that use these VIN database  web services at some of 
the larger car auctions.
They also hook into a state's license bureau to track titles and 
accident info, as well, from the VIN
not just decoding the info from the VIN number.

This company makes a standalone program or web service that delivers
XMLVIN  info for US  compliant VIN's as below
Cost is about $300 US with updates.
www.vinpower.com

Here is an explanation of what is involved in producing the info from a 
vin decoder
from another VIN web service supplier.
 These guys even provide jpeg pictures of auto in the xml
http://dataonesoftware.com/vinDecoderHome.php

Explanation of  a VIN database
http://www.dataonesoftware.com/sources/DecoderBrochure.pdf

Other sites with basic VIN breakdown and checkdigit methods

http://www2.vinpower.com/VINInformation.aspx
http://www.washingtonwatchdog.org/documents/cfr/title49/part565.html
http://www.nhtsa.dot.gov/cars/problems/salvage/

Here is some sample XML web service output.

<?xml version="1.0" encoding="ISO-8859-1"?>
<REPORTS>
   <REPORT type="OPTION">
      <VinPOWER version="1.0.0">
         <DATABASE version="2004.11.008">
            <MODULE name="PASSENGER, MPV, LIGHT TRUCK" 
version="2004.11.005"/>
            <MODULE name="EXT. BASIC JATO 20041104_101058" 
version="2004.11.005"/>
         </DATABASE>
         <VIN number="1B3EJ46X11N602989">
            <DECODED Model_Year="2001" Make="Dodge" Model="Stratus" 
Trim_Level="SE">
               <KEY name="Model Year" value="2001"/>
               <KEY name="Make" value="Dodge"/>
               <KEY name="Model" value="Stratus"/>
               <KEY name="Body Type" value="4 Door Sedan"/>
               <KEY name="Trim Level" value="SE"/>
               <KEY name="Engine Type" value="L4, 2.4L; DOHC 16V"/>
               <KEY name="Country" value="UNITED STATES"/>
               <KEY name="Assy. Plant" value="Sterling Heights, MI"/>
               <KEY name="Production Seq. Number" value="602989"/>
               <KEY name="Check Digit" value="1"/>
               <KEY name="Drive Line Type" value="FWD"/>
               <KEY name="Manufacturer" value="DaimlerChrysler 
Corporation"/>
               <KEY name="Restraint System" value="Dual Air Bag; 
Automatic Belts"/>
               <KEY name="Vehicle Type" value="Passenger Car"/>
               <KEY name="Vehicle Class" value="Mid-size Car"/>
               <KEY name="Fuel Type" value="Gasoline"/>
               <KEY name="JATO" value="157146"/>
            </DECODED>
         </VIN>
      </VinPOWER>
         <VEHICLES Year="2001" Make="DODGE" Model="STRATUS">
            <VEHICLE Model_Year="2001" Make="DODGE" Model="STRATUS" 
Trim_Level="SE" Version_Name="SE" Driven_Wheels="F" Number_of_Doors="4" 
Vehicle_id="15714620010216">
               <BASIC_INFO>
                  <ITEM item_name="vehicle_id" item_value="15714620010216"/>
                  <ITEM item_name="Unique Identity" item_value="157146"/>
                  <ITEM item_name="Researcher initials" item_value="JH"/>
                  <ITEM item_name="Data date" item_value="20010216"/>
                  <ITEM item_name="Date of change" item_value="20010216"/>
                  <ITEM item_name="Research date" item_value="20010507"/>
                  <ITEM item_name="Conclude date" item_value="20010730"/>
                  <ITEM item_name="Data status" item_value="4"/>
                  <ITEM item_name="Model year" item_value="2001"/>
                  <ITEM item_name="Country" item_value="USA"/>
                  <ITEM item_name="Responsible market UID" 
item_value="157146"/>
                  <ITEM item_name="Date physically checked" item_value="0"/>
                  <ITEM item_name="Make group" 
item_value="DAIMLERCHRYSLER"/>
                  <ITEM item_name="Make" item_value="DODGE"/>
                  <ITEM item_name="Local make name" item_value="Dodge"/>
                  <ITEM item_name="Model" item_value="STRATUS"/>
                  <ITEM item_name="Local model name" item_value="Stratus"/>
                  <ITEM item_name="Model descriptor" item_value="-"/>
                  <ITEM item_name="Version name" item_value="SE"/>
                  <ITEM item_name="Local version name" item_value="SE"/>
                  <ITEM item_name="Special/limited edition" item_value="-"/>
                  <ITEM item_name="Trim level" item_value="SE"/>
                  <ITEM item_name="local trim level" item_value="SE"/>
                  <ITEM item_name="trim classification" item_value="B1"/>
                  <ITEM item_name="Pricing descriptor" item_value="-"/>
                  <ITEM item_name="Number of doors" item_value="4"/>
                  <ITEM item_name="local number of doors" item_value="4"/>
                  <ITEM item_name="Body type" item_value="SA"/>
                  <ITEM item_name="local body type" item_value="SA"/>
                  <ITEM item_name="cab type" item_value=""/>
                  <ITEM item_name="roof type" item_value=""/>
                  <ITEM item_name="wheelbase type" item_value=""/>
                  <ITEM item_name="Driver location" item_value=""/>
                  <ITEM item_name="Driven wheels" item_value="F"/>
                  <ITEM item_name="Transmission type" item_value="A"/>
                  <ITEM item_name="Liters" item_value="2.4"/>
                  <ITEM item_name="Maximum power kW" item_value="112"/>
                  <ITEM item_name="Maximum power hp/PS" item_value="150"/>
                  <ITEM item_name="Fuel type" item_value="U"/>
                  <ITEM item_name="Compressor" item_value=""/>
                  <ITEM item_name="Seating capacity" item_value="5"/>
                  <ITEM item_name="Price currency" item_value="USD"/>
                  <ITEM item_name="Override option price currency" 
item_value=""/>
                  <ITEM item_name="Override attribute price currency" 
item_value=""/>
                  <ITEM item_name="MSRP" item_value="17830"/>
                  <ITEM item_name="Dealer Invoice" item_value="16582"/>
                  <ITEM item_name="Wholesale price" item_value="15587.1"/>
                  <ITEM item_name="Wholesale price" item_value="15587.1"/>
                  <ITEM item_name="MSRP including delivery charge" 
item_value="18425"/>
                  <ITEM item_name="Net prices" item_value="-"/>
                  <ITEM item_name="Country of assembly" item_value="USA"/>
                  <ITEM item_name="Date version introduced" 
item_value="20000717"/>
                  <ITEM item_name="Date model introduced" 
item_value="20000717"/>
                  <ITEM item_name="Vehicle type" item_value="N"/>
                  <ITEM item_name="Manufacturer's code" 
item_value="JRDH41"/>
                  <ITEM item_name="First research date" 
item_value="20010222"/>
                  <ITEM item_name="Data status research date" 
item_value="20010507"/>
                  <ITEM item_name="VIN" item_value="1B3AJ42B"/>
                  <ITEM item_name="Make continent group" item_value="USA"/>
                  <ITEM item_name="Model group" item_value="DODGE STRATUS"/>
                  <ITEM item_name="Version information" item_value="S"/>
                  <ITEM item_name="Latest price list date/number" 
item_value="20010216-4"/>
                  <ITEM item_name="Release date" item_value="20010222"/>
                  <ITEM item_name="Indicative prices only" item_value=""/>
                  <ITEM item_name="Cash/Net price" item_value="0"/>
                  <ITEM item_name="Finance price" item_value="0"/>
                  <ITEM item_name="Source of price list" item_value=""/>
                  <ITEM item_name="Make code" item_value="-"/>
                  <ITEM item_name="Model code" item_value="-"/>
                  <ITEM item_name="Model generation" item_value="2"/>
                  <ITEM item_name="Date body type introduced" 
item_value="0"/>
                  <ITEM item_name="Date number of doors introduced" 
item_value="0"/>
                  <ITEM item_name="Previous model name" 
item_value="STRATUS"/>
                  <ITEM item_name="Previous version name" item_value="SE"/>
                  <ITEM item_name="Date version was linked" item_value="0"/>
                  <ITEM item_name="Version id" item_value="15714601"/>
                  <ITEM item_name="JATOCode1" item_value=""/>
                  <ITEM item_name="JATOCode2" item_value=""/>
                  <ITEM item_name="Secondary Price currency" 
item_value="EUR"/>
                  <ITEM item_name="Secondary MSRP" item_value="14671.9"/>
                  <ITEM item_name="Secondary Dealer Invoice" 
item_value="13644.9"/>
                  <ITEM item_name="Secondary Wholesale price" 
item_value="12826.2"/>
                  <ITEM item_name="Secondary Wholesale price" 
item_value="12826.2"/>
                  <ITEM item_name="Secondary MSRP including delivery 
charge" item_value="15161.5"/>
                  <ITEM item_name="JATO global segment" item_value="-5"/>
                  <ITEM item_name="JATO regional segment" item_value="-22"/>
               </BASIC_INFO>
               <STANDARD_EQUIPMENT>
                  <ITEM item_name="Trim" item_value="Trim level: SE"/>
                  <ITEM item_name="Body style" item_value="Four-door 
sedan body style"/>
                  <ITEM item_name="Seating" item_value="Seating: five 
seats"/>
                  <ITEM item_name="Speakers" item_value="Four speaker(s)"/>
                  <ITEM item_name="Antenna" item_value="Fixed mast 
antenna"/>
                  <ITEM item_name="Audio system" item_value="Audio 
system with cassette"/>
                  <ITEM item_name="Coefficient of drag" 
item_value="Coefficient of drag: 0.31"/>
                  <ITEM item_name="Body side molding" item_value="Body 
side molding"/>
                  <ITEM item_name="Chrome/bright trim" 
item_value="Chrome/bright trim on side of body"/>
                  <ITEM item_name="Disc brakes" item_value="Four disc 
brakes including two ventilated discs"/>
                  <ITEM item_name="Bumpers" item_value="Body color front 
and rear bumpers"/>
                  <ITEM item_name="Delivery charges" item_value="Fixed 
delivery charges: 595"/>
                  <ITEM item_name="Remote trunk/hatch release" 
item_value="Electric remote trunk/hatch release"/>
                  <ITEM item_name="Cruise control" item_value="Cruise 
control"/>
                  <ITEM item_name="Courtesy lights" 
item_value="Delayed/fade courtesy lights"/>
                  <ITEM item_name="Vanity mirror" item_value="Driver and 
passenger vanity mirror"/>
                  <ITEM item_name="External dimensions" 
item_value="External dimensions: overall length (inches): 191.2, overall 
width (inches): 70.6, overall height (inches): 54.9, wheelbase (inches): 
108, front track (inches): 60.2, rear track (inches): 60.2 and curb to 
curb turning circle (feet): 36.8"/>
                  <ITEM item_name="Internal dimensions" 
item_value="Internal dimensions: front headroom (inches): 37.6, rear 
headroom (inches): 35.8, front hip room (inches): 52.5, rear hip room 
(inches): 53.1, front leg room (inches): 42.3, rear leg room (inches): 
38.1, front shoulder room (inches): 55.2, rear shoulder room (inches): 
54.7 and interior volume (cu ft): 94"/>
                  <ITEM item_name="Cargo capacity" item_value="Cargo 
capacity: all seats in place (cu ft): 16"/>
                  <ITEM item_name="Drive" item_value="Front-wheel drive"/>
                  <ITEM item_name="Engine" item_value="2,429 cc 2.4 
liters in-line 4 engine with 87.5 mm bore, 101 mm stroke, 9.4 
compression ratio, double overhead cam and four valves per cylinder"/>
                  <ITEM item_name="Emission control level" 
item_value="Emission control level FED"/>
                  <ITEM item_name="Fuel system" item_value="Multi-point 
injection fuel system"/>
                  <ITEM item_name="Fuel" item_value="Unleaded fuel"/>
                  <ITEM item_name="Fuel tank" item_value="16 gallon main 
unleaded fuel tank"/>
                  <ITEM item_name="Tachometer" item_value="Tachometer"/>
                  <ITEM item_name="Low fuel level warning" 
item_value="Low fuel level warning"/>
                  <ITEM item_name="Clock" item_value="Clock"/>
                  <ITEM item_name="Headlights" item_value="Complex 
surface lens halogen bulb headlights"/>
                  <ITEM item_name="Headlight control" 
item_value="Headlight control"/>
                  <ITEM item_name="Tires" item_value="Front and rear 
tires with 205 mm tire width, 65% tire profile and T tire rating"/>
                  <ITEM item_name="Power locks" item_value="Internal 
button power locks"/>
                  <ITEM item_name="Paint" item_value="Metallic paint , 
black paint , gloss paint , pearl paint"/>
                  <ITEM item_name="Power" item_value="Power: 112 kW , 
150 HP SAE @ 5,200 rpm; 167 ft lb , 226 Nm @ 4,000 rpm"/>
                  <ITEM item_name="Fuel economy" item_value="Fuel 
economy EPA highway (mpg): 30 and EPA city (mpg): 20"/>
                  <ITEM item_name="Front airbag" item_value="Driver and 
passenger front airbag"/>
                  <ITEM item_name="Head restraints" item_value="Two 
height adjustable head restraints on front seats"/>
                  <ITEM item_name="Front seat belts" item_value="Height 
adjustable 3-point reel front seat belts on driver seat and passenger 
seat with pre-tensioners"/>
                  <ITEM item_name="Rear seat belts" item_value="3-point 
reel rear seat belts on driver side, passenger side and center side"/>
                  <ITEM item_name="Seat upholstery" item_value="Cloth 
seat upholstery"/>
                  <ITEM item_name="Front seat center armrest" 
item_value="Front seat center armrest"/>
                  <ITEM item_name="Front seat" item_value="Bucket driver 
and passenger seat"/>
                  <ITEM item_name="Rear seats" item_value="Three 
asymmetrical bench front facing rear seats"/>
                  <ITEM item_name="Steering wheel" item_value="Plastic 
steering wheel with tilt adjustment"/>
                  <ITEM item_name="Power steering" item_value="Power 
steering"/>
                  <ITEM item_name="Glove compartment" 
item_value="Lockable glove compartment"/>
                  <ITEM item_name="Door pockets/bins" item_value="Door 
pockets/bins for driver seat and passenger seat"/>
                  <ITEM item_name="Cup holders" item_value="Front seats 
and rear seats cup holders"/>
                  <ITEM item_name="Suspension" item_value="Wishbone 
front suspension independent with stabilizer bar and coil springs , 
multi-link rear suspension independent with stabilizer bar and coil 
springs"/>
                  <ITEM item_name="Transmission" item_value="Automatic 
four-speed transmission with lock-up, electronic control and shift lever 
on floor"/>
                  <ITEM item_name="Ventilation system" 
item_value="Ventilation system with recirculation setting"/>
                  <ITEM item_name="Air conditioning" item_value="Air 
conditioning"/>
                  <ITEM item_name="Rear view mirror" item_value="Rear 
view mirror"/>
                  <ITEM item_name="Door mirrors" item_value="Driver and 
passenger power black door mirrors"/>
                  <ITEM item_name="Rear window" item_value="Rear window 
with defogger"/>
                  <ITEM item_name="Tinted glass" item_value="Tinted 
glass on cabin"/>
                  <ITEM item_name="Heat reflective glass" 
item_value="Heat reflective glass"/>
                  <ITEM item_name="Windshield wipers" 
item_value="Windshield wipers with variable intermittent wipe"/>
                  <ITEM item_name="Power windows" item_value="Front 
power windows with one one-touch , rear power windows"/>
                  <ITEM item_name="Warranty whole vehicle" 
item_value="Full car warranty: duration (months): 36 or distance 
(miles): 36,000"/>
                  <ITEM item_name="Warranty powertrain" 
item_value="Powertrain warranty: duration (months): 36 or distance 
(miles): 36,000"/>
                  <ITEM item_name="Warranty anti-corrosion" 
item_value="Anticorrosion warranty: duration (months): 60 or distance 
(miles): 100,000"/>
                  <ITEM item_name="Warranty roadside assistance" 
item_value="Road-side assistance warranty: duration (months): 36 or 
distance (miles): 36,000"/>
                  <ITEM item_name="Weights" item_value="Weights: curb 
weight (lbs) 3,226"/>
                  <ITEM item_name="Wheels" item_value="Front and rear 
steel wheels with 15 inch rim diam, 6 inch rim width and full wheel 
covers"/>
                  <ITEM item_name="Spare wheel" item_value="Spacesaver 
steel rim internal spare wheel"/>
                  <ITEM item_name="Console" item_value="Full dashboard 
console with open storage box , full floor console with covered storage 
box"/>
                  <ITEM item_name="Date introduced" item_value="Date 
introduced 20,000,717 and 20,000,717"/>
               </STANDARD_EQUIPMENT>
              
            </VEHICLE>
         </VEHICLES>
   </REPORT>
</REPORTS>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the dba-Tech mailing list