MySQL vs Redshift Test 2

SELECT state, vehicle_date, COUNT(*) AS total
                        FROM master WHERE vehicle_date BETWEEN 2000 AND 2005 AND vehicle_make IN ('ACURA', 'BMW', 'TOYOTA', 'BUICK', 'CADILLAC', 'AUDI', 'CHEVROLET', 'CHRYSLER', 'DODGE', 'FORD', 'GMC', 'HONDA', 'HYUNDAI', 'INFINITI', 'JEEP', 'KIA', 'LINCOLN', 'LEXUS', 'MAZDA', 'MERCURY', 'MERCEDES BENZ', 'MERCEDES-BENZ', 'MITSUBISHI', 'NISSAN', 'OLDSMOBILE', 'PONTIAC', 'SAAB', 'SATURN', 'SMART', 'VOLKSWAGEN', 'VOLVO', 'MINI', 'JAGUAR', 'SUBARU', 'RAM') AND CONCAT(vehicle_make, CONCAT('-', vehicle_model)) NOT IN ('ADVANCE MIXER-ADVANCE MIXER', 'ALFA ROMEO-164', 'ALFA ROMEO-8C COMPETIZIONE', 'FORD-GT', 'ALFA ROMEO-MILANO', 'ALFA ROMEO-SPIDER', 'ALFA ROMEO-VELOCE', 'AMERICAN GENERAL-H1', 'AMERICAN IRON HORSE-10TH ANNIVERSARY', 'AMERICAN IRON HORSE-BANDERA', 'ELECTRIC VEHICLE TECHNOLOGIES-CLASSIC', 'AMERICAN IRON HORSE-CLASSIC CHOPPER', 'AMERICAN IRON HORSE-JUDGE', 'ACURA-LEGEND', 'AMERICAN IRON HORSE-LSC', 'POLARIS-OUTLAW', 'FORD-RANGER', 'TESLA-ROADSTER', 'AMERICAN IRON HORS E-SLAMMER', 'AMERICAN IRON HORSE-STALKER', 'AMERICAN IRON HORSE-TEJAS SJ', 'AMERICAN IRON HORSE-TEXAS CHOPPER', 'AMERICAN LA FRANCE-CONDOR', 'AMERICAN LA FRANCE-EAGLE', 'AMERICAN LA FRANCE-METROPOLITAN', 'AMERICAN MOTORS-ALLIANCE', 'AMERICAN MOTORS-CONCORD', 'AMERICAN MOTORS-ENCORE', 'DODGE-SPIRIT', 'APRILIA-ATLANTIC', 'APRILIA-CAPO NORD', 'APRILIA-DORSODURO', 'APRILIA-ETV 1000', 'APRILIA-MANA', 'APRILIA-MOJITO', 'APRILIA-MXV', 'APRILIA-RALLY', 'APRILIA-RS', 'APRILIA-RST FUTURA', 'APRILIA-RSV', 'APRILIA-RSV4', 'APRILIA-RXV', 'APRILIA-SCARABEO', 'APRILIA-SHIVER', 'APRILIA-SL1000', 'APRILIA-SPORTCITY', 'APRILIA-SPORTCITY 250', 'APRILIA-SR50', 'APRILIA-SXV', 'APRILIA-TUONO', 'ARO-HUNTER 244', 'ASTON MARTIN-DB7', 'ASTON MARTIN-DB9', 'ASTON MARTIN-DBS', 'ASTON MARTIN-Rapide', 'ASTON MARTIN-V12 VANTAGE', 'ASTON MARTIN-V8', 'ASTON MARTIN-VANQUISH', 'ASTON MARTIN-VIRAGE', 'ATK-110', 'KTM-125', 'MACK-250', 'ATK-350', 'ATK-406', 'ATK-450', 'ATK-490', 'ATK-50', 'ATK-503', 'ATK-605', ' AUDI-R8', 'VOLVO-ACL', 'WHITE/GMC-ACM', 'AUTOCAR-AT', 'AUTOCAR -C / DC', 'AUTOCAR-CONSTRUKTOR', 'AUTOCAR-DK', 'AUTOCAR-DS', 'AUTOCAR-S', 'AUTOCAR LLC.-XPEDITOR', 'AUTOCAR LLC.-XSPOTTER-OFF', 'AUTOCAR LLC.-XSPOTTER-ON', 'AVANTI-AVANTI', 'AZURE DYNAMICS-Transit Connect E', 'BASHAN-BASHAN ATV', 'BASHAN-BASHAN DIRT BIKE', 'BASHAN-BASHAN MOTORCYCLE', 'BASHAN-BASHAN SCOOTER', 'BENTLEY-ARNAGE', 'BENTLEY-AZURE', 'BENTLEY-BROOKLANDS', 'BENTLEY-CONTINENTAL', 'ROLLS-ROYCE-CORNICHE', 'BENTLEY-EIGHT', 'BENTLEY-MULSANNE', 'BENTLEY-TURBO', 'BERING-HD67MX', 'BERING-LD15A', 'BERING-MD23M', 'BERING-MD26M', 'BIG BEAR CHOPPERS-ATHENA', 'BIG BEAR CHOPPERS-BEAR BONES', 'BIG BEAR CHOPPERS-DEVILS ADVOCATE', 'BIG BEAR CHOPPERS-GTX', 'BIG BEAR CHOPPERS-MERC', 'BIG BEAR CHOPPERS-MISS BEHAVIN', 'BIG BEAR CHOPPERS-PARADOX', 'BIG BEAR CHOPPERS-RAGE', 'BIG BEAR CHOPPERS-REAPER', 'BIG BEAR CHOPPERS-SCREAMIN DEMON', 'BIG BEAR CHOPPERS-THE SLED', 'BIG BEAR CHOPPERS-VENOM', 'BIG DOG-AEROGLIDE', 'BIG DOG-AEROSPORT', 'BIG DOG-BOXER', 'BIG DOG-BULLDOG', 'BIG DOG-CHOPPER',  'BIG DOG-COYOTE', 'BIG DOG-HUSKY', 'BIG DOG-K-9', 'BIG DOG-K9', 'BIG DOG-MASTIFF', 'BIG DOG-MUTT', 'BIG DOG-PITBULL', 'BIG DOG-PROGLIDE', 'BIG DOG-PROSPORT', 'BIG DOG-RIDGEBACK', 'BIG DOG-VINTAGE', 'BIG DOG-WOLF', 'BLUE BIRD-INCOMPLETE VEHICLE', 'BLUE BIRD-MPV', 'BLUE BIRD-SCHOOL BUS / TRANSIT BUS', 'BMW-C600', 'BMW-C650', 'BMW-F1200', 'FORD-F650', 'FORD-F700', 'FORD-F800', 'BMW-G450', 'BMW-G650', 'BMW-HP2', 'BMW-HP4', 'BMW-K1', 'BMW-K100', 'BMW-K1100', 'BMW-K1200', 'BMW-K1300', 'BMW-K1600', 'BMW-K75', 'BMW-R100', 'BMW-R1100', 'BMW-R1150', 'BMW-R1200', 'BMW-R65', 'BMW-R650', 'BMW-R80', 'BMW-R850', 'BMW-R900', 'BMW-S 1000', 'BUELL-1125', 'BUELL-BLAST', 'BUELL-CYCLONE', 'BUELL-FIREBOLT', 'BUELL-LIGHTNING', 'BUELL-RS SERIES', 'BUELL-THUNDERBOLT', 'BUELL-ULYSSES', 'BUELL-WHITE LIGHTNING', 'BUELL-XB12SCG', 'BUELL-XB9SX', 'BUGATTI-VEYRON', 'BUS & COACH INTL (BCI)-FALCON 45', 'WORKHORSE CUSTOM CHASSIS-COMMERCIAL CHASSIS', 'CADILLAC-PROFESSIONAL CHASSIS', 'CAGIVA-CAGIVA', 'CAGIVA-W XC', 'CAN-AM-COMMANDER', 'CAN-AM-MAVERICK', 'CAN-AM-OUTLANDER', 'CAN-AM -OUTLANDER MAX', 'CAN-AM-RENEGADE', 'CAN-AM-SPYDER ROADSTER', 'CAPACITY OF TEXAS-PHETT', 'CAPACITY OF TEXAS-TJ5000', 'CAPACITY OF TEXAS-TJ6500T', 'CAPACITY OF TEXAS-TJ7000', 'CAPACITY OF TEXAS-TJ9000', 'CATERPILLAR-CT660', 'EAGLE TRANSIT BUSES-TRANSIT BUS', 'INTERNATIONAL-7000', 'GMC-B-SERIES', 'GMC-B7T042', 'CHEVROLET-C4500', 'CHEVROLET-C5000', 'CHEVROLET-C5500', 'CHEVROLET-C6000', 'CHEVROLET-C6500', 'CHEVROLET-C7500', 'CHEVROLET-C8500', 'CHEVROLET-C65', 'GMC-CUTAWAY VAN', 'CHEVROLET-D10', 'CHEVROLET-D30', 'CHEVROLET-EXPRESS CUTAWAY', 'CHEVROLET-EXPRESS G1500', 'CHEVROLET-EXPRESS G2500', 'CHEVROLET-EXPRESS G3500', 'CHEVROLET-EXPRESS G4500', 'CHEVROLET-EXPRESS VAN', 'GMC-HI-CUBE VAN', 'CHEVROLET-K30', 'CHEVROLET-P20', 'CHEVROLET-P30', 'GMC-PS4500', 'CHEVROLET-PS6500', 'CHEVROLET-S6000', 'CHEVROLET-T-SERIES', 'CHEVROLET-TILT MASTER W35042', 'CHEVROLET-TILT MASTER W4S042', 'CHEVROLET-TILT MASTER W4T042', 'CHEVROLET-TILT MASTER W5R042', 'CHEVROLET-TILT MASTER W5S042', 'CHEVROL ET-TILT MASTER W5T042', 'CHEVROLET-TILT MASTER W6R042', 'CHEVROLET-TILT MASTER W7R042', 'CHEVROLET-TILT MASTER W7R042HV', 'CHEVROLET-V3500', 'COUNTRY COACH MOTORHOME-AFFINITY', 'COUNTRY COACH MOTORHOME-ALLURE', 'COUNTRY COACH MOTORHOME-INSPIRE', 'COUNTRY COACH MOTORHOME-INTRIGUE', 'COUNTRY COACH MOTORHOME-ISLANDER', 'COUNTRY COACH MOTORHOME-LEXA', 'COUNTRY COACH MOTORHOME-LTC CHASSIS', 'COUNTRY COACH MOTORHOME-MAGNA', 'MAZDA-TRIBUTE', 'CPI MOTOR COMPANY-GTR', 'CPI MOTOR COMPANY-OLIVER CITY', 'CRANE CARRIER-CENTURION', 'CRANE CARRIER-CENTURY II', 'CRANE CARRIER-DRILL RIG', 'CRANE CARRIER-EQUIPMENT CARRIER', 'GMC-GLIDER KIT', 'CRANE CARRIER-INTER FRONT LOADER', 'CRANE CARRIER-INTER REAR LOADER', 'CRANE CARRIER-INTER SIDE LOADER', 'CRANE CARRIER-LOW ENTRY', 'CRANE CARRIER-RECYCLE EQUIPMENT', 'CROWN COACH-SCHOOL BUS', 'FREIGHTLINER-CHASSIS', 'DAEWOO-LANOS', 'DAEWOO-LEGANZA', 'DAEWOO-NUBIRA', 'DAIHATSU-CHARADE', 'DAIHATSU-ROCKY', 'DATSUN-200SX', 'DATSUN-280ZX', 'NISSAN-300ZX', ' PETERBILT-310', 'DATSUN-510', 'DATSUN-720', 'DATSUN-810', 'DATSUN-B210', 'DATSUN-MAXIMA', 'DATSUN-MICRA', 'NISSAN-PULSAR', 'NISSAN-SENTRA', 'NISSAN-STANZA', 'DERBI-ATLANTIS 50', 'DERBI-BOULEVARD 151', 'GIANT-C116', 'DIAMOND REO-C120', 'DODGE-D-SERIES', 'DODGE-Ram 4500', 'DODGE-Ram 5500', 'DODGE-RAM VAN', 'DODGE-RD200 / RD250', 'DUCATI-1098', 'DUCATI-1198', 'KTM-620', 'DUCATI-748', 'DUCATI-749', 'BMW-750', 'DUCATI-848', 'DUCATI-851', 'DUCATI-888', 'DUCATI-900', 'DUCATI-906', 'DUCATI-907', 'DUCATI-916', 'DUCATI-996', 'DUCATI-999', 'DUCATI-DESMOSEDICI RR', 'DUCATI-DIAVEL', 'DUCATI-E900', 'DUCATI-HYPERMOTARD', 'DUCATI-M600', 'DUCATI-M750', 'DUCATI-M900', 'DUCATI-MONSTER', 'DUCATI-MULTISTRADA', 'DUCATI-SPORTCLASSIC', 'DUCATI-ST2', 'DUCATI-ST3', 'DUCATI-ST4', 'DUCATI-STREETFIGHTER', 'DUCATI-SUPERBIKE', 'DUCATI-SUPERSPORT', 'DUPLEX-DUPLEX', 'EAGLE-MEDALLION', 'EAGLE-PREMIER', 'EAGLE-SUMMIT', 'EAGLE-TALON', 'EAGLE-VISION', 'EL DORADO-AXESS', 'EL DORADO-E-Z RIDER', 'EL DORADO-E-Z RIDER II', 'EL DORADO-ESCORT', 'EL DORADO-TRANSMARK', 'EL DORADO-TRANSMAR K XHF', 'POLARIS-SPORT', 'EMERGENCY ONE-FIRETRUCK', 'EVOBUS-417', 'EVOBUS-SETRA', 'FEDERAL MOTORS-FEDERAL MOTORS', 'FERRARI-308', 'PETERBILT-348', 'FERRARI-360', 'FERRARI-430', 'FERRARI-456', 'FERRARI-458 ITALIA', 'FERRARI-458 SPIDER', 'FERRARI-512TR', 'FERRARI-512TR / F512M', 'FERRARI-575', 'FERRARI-599', 'FERRARI-612', 'MOTO GUZZI-CALIFORNIA', 'FERRARI-ENZO', 'FERRARI-F12 BERLINETTA', 'FERRARI-F355', 'FERRARI-F40', 'FERRARI-F430', 'FERRARI-F50', 'FERRARI-F550', 'FERRARI-F575', 'HINO-FF', 'FERRARI-MONDIAL', 'FERRARI-TESTAROSSA', 'FIAT-124', 'FIAT-500L', 'FIAT-BERTONE', 'FIAT-BRAVA', 'FIAT-PININFARINA', 'FIAT-STRADA', 'FIAT-X 1/9', 'FISKER AUTOMOTIVE-KARMA', 'CHEVROLET-C-SERIES', 'FORD-CL-SERIES', 'FORD-ECONOLINE', 'FORD-F450', 'FORD-F53', 'FORD-F530', 'FORD-F59', 'FORD-F590', 'FORD-F600', 'FORD-F6000', 'FORD-F7000', 'FORD-F750', 'FORD-F8000', 'FORD-FESTIVA', 'FORD-FIESTA', 'FORD-FT800', 'FORD-FT8000', 'FORD-FT900', 'FORD-H-SERIES', 'FORD-L-SERIES', 'FORD-LOW CAB FORWARD',  'FORD-LOW TILT CARGO', 'FORD-N-SERIES', 'FORD-P600', 'FORD-P800F', 'FOR D-Transit Connect', 'FORETRAVEL MOTORHOME-MOTORHOME', 'FREIGHTLINER-108SD', 'FREIGHTLINER-114SD', 'FREIGHTLINER-ARGOSY', 'FREIGHTLINER-CASCADIA 113', 'FREIGHTLINER-CASCADIA 125', 'FREIGHTLINER-COE', 'FREIGHTLINER-COLUMBIA', 'WESTERN STAR/AUTO CAR-CONVENTIONAL', 'FREIGHTLINER-HC CARGO', 'SUBARU-LEGACY', 'FREIGHTLINER-M2', 'FREIGHTLINER-MEDIUM CONVENTIONAL', 'FREIGHTLINER-RIV', 'FREIGHTLINER-SPORT CHASSIS', 'MERCEDES-BENZ-SPRINTER', 'FWD CORPORATION-AMERICA', 'FWD CORPORATION-BXU', 'FWD CORPORATION-CB', 'FWD CORPORATION-CRANE CARRIER', 'HINO-FD', 'FWD CORPORATION-RB', 'GENESIS TRANSIT BUSES-GENESIS', 'GENUINE SCOOTER CO.-Blur', 'GENUINE SCOOTER CO.-Buddy', 'GENUINE SCOOTER CO.-Roughhouse', 'GENUINE SCOOTER CO.-Stella', 'GEO-METRO', 'GEO-PRIZM', 'GEO-SPECTRUM', 'GEO-STORM', 'CHEVROLET-TRACKER', 'GIANT-2WM', 'GILLIG-INCOMPLETE MOTORHOME CHASSIS', 'OSHKOSH MOTOR TRUCK CO.-SHUTTLE BUS', 'GILLIG-SUBURBAN BUS', 'STERLING-825', 'GLOBAL ELECTRIC MOTORS-E2', 'GLOBAL ELECTRIC MOTORS-E4 ', 'GLOBAL ELECTRIC MOTORS-E6', 'GLOBAL ELECTRIC MOTORS-EL', 'GLOBAL ELECTRIC MOTORS-ES', 'GM EV1-EV1', 'INTERNATIONAL-4000', 'AUDI-5000', 'GMC-5500', 'PONTIAC-6000', 'GMC-C3500', 'GMC-C6400', 'GMC-C7000', 'GMC-D9500', 'GMC-F9500', 'GMC-FORWARD CONTROL CHASSIS', 'GMC-H7500', 'GMC-H9500', 'GMC-J7500', 'GMC-J9500', 'GMC-M9500', 'GMC-ME6000', 'GMC-ME6500', 'GMC-MOTOR HOME CHASSIS', 'GMC-N9500', 'GMC-P6S042', 'GMC-W3500', 'GMC-W4500', 'HARLEY-DAVIDSON-FLD', 'HARLEY-DAVIDSON-FLH80', 'HARLEY-DAVIDSON-FLHP', 'HARLEY-DAVIDSON-FLHPE', 'HARLEY-DAVIDSON-FLHPEI', 'HARLEY-DAVIDSON-FLHPI', 'HARLEY-DAVIDSON-FLHR', 'HARLEY-DAVIDSON-FLHR/I', 'HARLEY-DAVIDSON-FLHRC', 'HARLEY-DAVIDSON-FLHRCI', 'HARLEY-DAVIDSON-FLHRI', 'HARLEY-DAVIDSON-FLHRS', 'HARLEY-DAVIDSON-FLHRSE3', 'HARLEY-DAVIDSON-FLHRSE4', 'HARLEY-DAVIDSON-FLHRSEI', 'HARLEY-DAVIDSON-FLHRSEI1', 'HARLEY-DAVIDSON-FLHRSI', 'HARLEY-DAVIDSON-FLHS', 'HARLEY-DAVIDSON-FLHT', 'HARLEY-DAVIDSON-FLHTC', 'HARLEY-DAVIDSON-FLHTC/I', 'HARLEY-DAVIDSON-FL HTCI', 'HARLEY-DAVIDSON-FLHTCSE', 'HARLEY-DAVIDSON-FLHTCSE2', 'HARLEY-D AVIDSON-FLHTCU', 'HARLEY-DAVIDSON-FLHTCU/I', 'HARLEY-DAVIDSON-FLHTCUI', 'HARLEY-DAVIDSON-FLHTCUSE', 'HARLEY-DAVIDSON-FLHTCUSE3', 'HARLEY-DAVIDSON-FLHTCUSE4', 'HARLEY-DAVIDSON-FLHTCUSE5', 'HARLEY-DAVIDSON-FLHTCUSE6', 'HARLEY-DAVIDSON-FLHTCUSE7', 'HARLEY-DAVIDSON-FLHTCUTG', 'HARLEY-DAVIDSON-FLHTI', 'HARLEY-DAVIDSON-FLHTK', 'HARLEY-DAVIDSON-FLHTP', 'HARLEY-DAVIDSON-FLHTPI', 'HARLEY-DAVIDSON-FLHX', 'HARLEY-DAVIDSON-FLHXI', 'HARLEY-DAVIDSON-FLHXSE', 'HARLEY-DAVIDSON-FLHXSE2', 'HARLEY-DAVIDSON-FLHXSE3', 'HARLEY-DAVIDSON-FLHXXX', 'HARLEY-DAVIDSON-FLS', 'HARLEY-DAVIDSON-FLST', 'HARLEY-DAVIDSON-FLSTC', 'HARLEY-DAVIDSON-FLSTCI', 'HARLEY-DAVIDSON-FLSTF', 'HARLEY-DAVIDSON-FLSTFB', 'HARLEY-DAVIDSON-FLSTFI', 'HARLEY-DAVIDSON-FLSTFSE', 'HARLEY-DAVIDSON-FLSTI', 'HARLEY-DAVIDSON-FLSTN', 'HARLEY-DAVIDSON-FLSTNI', 'HARLEY-DAVIDSON-FLSTS', 'HARLEY-DAVIDSON-FLSTSB', 'HARLEY-DAVIDSON-FLSTSC', 'HARLEY-DAVIDSON-FLSTSE', 'HARLEY-DAVIDSON-FLSTSE2', 'HARLEY-DAVIDSON-FLSTSE3', 'HARLEY-DAVIDSON-FLSTSI', 'HARLEY-DAVIDSON-FLT', 'HARLEY-DAVIDSON-FLTC', 'HARLEY-DAVIDSON-FLTCUI', 'HARLEY-DAVIDSON-FLTR', 'HARLEY-DAVIDSON-FLTRI', 'HARLEY-DAVIDSON-FLTRSE3', 'HARLEY-DAVIDSON-FLTRSEI', 'HARLEY-DAVIDSON-FLTRSEI2', 'HARLEY-DAVIDSON-FLTRU', 'HARLEY-DAVIDSON-FLTRUSE', 'HARLEY-DAVIDSON-FLTRX', 'HARLEY-DAVIDSON-FLTRXSE', 'HARLEY-DAVIDSON-FXB', 'HARLEY-DAVIDSON-FXCW', 'HARLEY-DAVIDSON-FXCWC', 'HARLEY-DAVIDSON-FXD', 'HARLEY-DAVIDSON-FXDB', 'HARLEY-DAVIDSON-FXDBI', 'HARLEY-DAVIDSON-FXDBP', 'HARLEY-DAVIDSON-FXDC', 'HARLEY-DAVIDSON-FXDCI', 'HARLEY-DAVIDSON-FXDF', 'HARLEY-DAVIDSON-FXDF2', 'HARLEY-DAVIDSON-FXDFSE', 'HARLEY-DAVIDSON-FXDFSE-2', 'HARLEY-DAVIDSON-FXDG', 'HARLEY-DAVIDSON-FXDI', 'HARLEY-DAVIDSON-FXDI35', 'HARLEY-DAVIDSON-FXDL', 'HARLEY-DAVIDSON-FXDLI', 'HARLEY-DAVIDSON-FXDP', 'HARLEY-DAVIDSON-FXDS', 'HARLEY-DAVIDSON-FXDSE', 'HARLEY-DAVIDSON-FXDSE2', 'HARLEY-DAVIDSON-FXDWG', 'HARLEY-DAVIDSON-FXDWG2', 'HARLEY-DAVIDSON-FXDWG3', 'HARLEY-DAVIDSON-FXDWGI', 'HARLEY-DAVIDSON-FXDX', 'HARLEY- DAVIDSON-FXDXI', 'HARLEY-DAVIDSON-FXDXT', 'HARLEY-DAVIDSON-FXE', 'HARLE Y-DAVIDSON-FXEF', 'HARLEY-DAVIDSON-FXLR', 'HARLEY-DAVIDSON-FXR', 'HARLEY-DAVIDSON-FXR2', 'HARLEY-DAVIDSON-FXR3', 'HARLEY-DAVIDSON-FXR4', 'HARLEY-DAVIDSON-FXRC', 'HARLEY-DAVIDSON-FXRD', 'HARLEY-DAVIDSON-FXRDG', 'HARLEY-DAVIDSON-FXRP', 'HARLEY-DAVIDSON-FXRP-F', 'HARLEY-DAVIDSON-FXRP-W', 'HARLEY-DAVIDSON-FXRS', 'HARLEY-DAVIDSON-FXRT', 'HARLEY-DAVIDSON-FXS', 'HARLEY-DAVIDSON-FXSB', 'HARLEY-DAVIDSON-FXSBSE', 'HARLEY-DAVIDSON-FXST', 'HARLEY-DAVIDSON-FXSTB', 'HARLEY-DAVIDSON-FXSTBI', 'HARLEY-DAVIDSON-FXSTC', 'HARLEY-DAVIDSON-FXSTD', 'HARLEY-DAVIDSON-FXSTDI', 'HARLEY-DAVIDSON-FXSTDSE', 'HARLEY-DAVIDSON-FXSTDSE2', 'HARLEY-DAVIDSON-FXSTI', 'HARLEY-DAVIDSON-FXSTS', 'HARLEY-DAVIDSON-FXSTSB', 'HARLEY-DAVIDSON-FXSTSI', 'HARLEY-DAVIDSON-FXSTSSE2', 'HARLEY-DAVIDSON-FXSTSSE3', 'HARLEY-DAVIDSON-FXWG', 'HARLEY-DAVIDSON-FXWG-CA', 'HARLEY-DAVIDSON-MT500', 'HARLEY-DAVIDSON-VRSCA', 'HARLEY-DAVIDSON-VRSCAW', 'HARLEY-DAVIDSON-VRSCAWA', 'HARLEY-DAVIDSON-VRSCB', 'HARLEY-DAVIDSON-VRSCD', 'HARLEY-DAVID SON-VRSCDA', 'HARLEY-DAVIDSON-VRSCDX', 'HARLEY-DAVIDSON-VRSCDXA', 'HARLEY-DAVIDSON-VRSCF', 'HARLEY-DAVIDSON-VRSCR', 'HARLEY-DAVIDSON-VRSCSE', 'HARLEY-DAVIDSON-VRSCX', 'HARLEY-DAVIDSON-VRSCXA', 'HARLEY-DAVIDSON-XL1200', 'HARLEY-DAVIDSON-XL883', 'HARLEY-DAVIDSON-XLH', 'HARLEY-DAVIDSON-XLH1100', 'HARLEY-DAVIDSON-XLH1200', 'HARLEY-DAVIDSON-XLH883', 'HARLEY-DAVIDSON-XLS', 'HARLEY-DAVIDSON-XLX', 'HONDA-XR100', 'HARLEY-DAVIDSON-XR1200', 'HENDRICKSON-BULLET', 'NORTH AMERICAN BUS INDUSTRIES (NABI)-BUS', 'HENDRICKSON-CRANE/DRILL RIG', 'HENDRICKSON-DOCKMASTER', 'HENDRICKSON-GLIDER', 'HENDRICKSON-H', 'NISSAN-TRUCK', 'HENDRICKSON-VT-100', 'HINO-155', 'HINO-195', 'HINO-198/258/268', 'HINO-238/258', 'HINO-258', 'HINO-258/268', 'HINO-308/338', 'HINO-338/358', 'HINO-358', 'HINO-FA', 'HINO-FB', 'MITSUBISHI FUSO TRUCK OF AMERICA INC-FE', 'MITSUBISHI FUSO TRUCK OF AMERICA INC-FG', 'HINO-GC', 'HINO-HINO 145', 'HINO-HINO 165', 'HINO-HINO 185', 'HINO-HINO 238', 'HINO-HINO 268', 'HINO-HINO 308', ' HINO-HINO 338', 'HINO-SF', 'HINO-SG', 'HONDA-ATC110', 'HONDA-ATC125', ' HONDA-ATC185', 'HONDA-ATC200', 'HONDA-ATC250', 'HONDA-ATC350', 'HONDA-ATC70', 'HONDA-C70', 'HONDA-CB1000', 'HONDA-CB1100', 'HONDA-CB125', 'HONDA-CB250', 'HONDA-CB400', 'HONDA-CB450', 'HONDA-CB500', 'HONDA-CB550', 'HONDA-CB559', 'HONDA-CB600', 'HONDA-CB650', 'HONDA-CB700', 'HONDA-CB750', 'HONDA-CB900', 'HONDA-CBR1000', 'HONDA-CBR1100', 'HONDA-CBR250', 'HONDA-CBR500', 'HONDA-CBR600', 'HONDA-CBR900', 'HONDA-CBR929', 'HONDA-CBX', 'HONDA-CBX250', 'HONDA-CBX550', 'HONDA-CH125', 'HONDA-CH150', 'HONDA-CH250', 'HONDA-CH50', 'HONDA-CH80', 'HONDA-CHF50', 'HONDA-CM200', 'HONDA-CM250', 'HONDA-CM400', 'HONDA-CM450', 'HONDA-CMX250', 'HONDA-CMX450', 'HONDA-CN250', 'HONDA-CR125', 'HONDA-CR250', 'HONDA-CR450', 'HONDA-CR480', 'HONDA-CR500', 'HONDA-CR60', 'HONDA-CR80', 'HONDA-CR85', 'HONDA-CRF100', 'HONDA-CRF110', 'HONDA-CRF125', 'HONDA-CRF150', 'HONDA-CRF230', 'HONDA-CRF250', 'HONDA-CRF450', 'HONDA-CRF50', 'HONDA-CRF70', 'HONDA-CRF80', 'HONDA-CT110', 'HONDA-CT1100', 'HONDA-CT70', 'HONDA-CTX70 0', 'HONDA-CX500', 'HONDA-CX650', 'HONDA-EV PLUS', 'HONDA-EZ90', 'HONDA-FL250', 'HONDA-FL350', 'HONDA-FL400', 'HONDA-FSC600', 'HONDA-FT500', 'HONDA-GB500', 'HONDA-GL1100', 'HONDA-GL12', 'HONDA-GL1200', 'HONDA-GL1500', 'HONDA-GL1800', 'HONDA-GL500', 'HONDA-GL650', 'HONDA-MB50', 'HONDA-MUV700', 'HONDA-NA50', 'HONDA-NB50', 'HONDA-NC50', 'HONDA-NC700X', 'HONDA-NCH50', 'HONDA-NH125', 'HONDA-NH80', 'HONDA-NHX110', 'HONDA-NN50', 'HONDA-NPS50', 'HONDA-NQ50', 'HONDA-NRX1800', 'HONDA-NS400', 'HONDA-NS50', 'HONDA-NSA700', 'HONDA-NSF250R', 'HONDA-NSS250', 'HONDA-NSS300', 'HONDA-NT650', 'HONDA-NT700', 'HONDA-NU50', 'HONDA-NX125', 'HONDA-NX250', 'HONDA-NX50', 'HONDA-NX650', 'HONDA-PA50', 'HONDA-PC800', 'HONDA-PCX', 'HONDA-PS250', 'HONDA-QR50', 'HONDA-RVF750', 'HONDA-RVT1000', 'HONDA-SA50', 'HONDA-SA50 - SB50P', 'HONDA-SB50', 'HONDA-SE50', 'HONDA-SH150', 'HONDA-ST1100', 'HONDA-ST1300', 'HONDA-SXS', 'HONDA-TG50', 'HONDA-TLR200', 'HONDA-TR200', 'HONDA-TRX 700', 'HONDA-TRX125', 'HONDA-TRX200 ', 'HONDA-TRX250', 'HONDA-TRX300', 'HONDA-TRX350', 'HONDA-TRX400', 'HON DA-TRX420', 'HONDA-TRX450', 'HONDA-TRX50', 'HONDA-TRX500', 'HONDA-TRX650', 'HONDA-TRX680', 'HONDA-TRX70', 'HONDA-TRX90', 'HONDA-VF1000', 'HONDA-VF1100', 'HONDA-VF500', 'KAWASAKI-VF700', 'HONDA-VF750', 'HONDA-VFR1200', 'HONDA-VFR700', 'HONDA-VFR750', 'HONDA-VFR800', 'HONDA-VT1100', 'HONDA-VT1300', 'HONDA-VT500', 'HONDA-VT600', 'HONDA-VT700', 'HONDA-VT750', 'HONDA-VT800', 'HONDA-VTR1000', 'HONDA-VTR250', 'HONDA-VTX1300', 'HONDA-VTX1800', 'HONDA-XL100', 'HONDA-XL125', 'HONDA-XL185', 'HONDA-XL200', 'HONDA-XL250', 'HONDA-XL350', 'HONDA-XL500', 'HONDA-XL600', 'HONDA-XL80', 'HONDA-XR200', 'HONDA-XR250', 'HONDA-XR350', 'HONDA-XR400', 'HONDA-XR50', 'HONDA-XR500', 'HONDA-XR600', 'HONDA-XR650', 'HONDA-XR70', 'HONDA-XR80', 'HONDA-Z50', 'HONDA-ZA50', 'HONDA-ZB50', 'HUMMER-H1 ALPHA', 'HUMMER-H2', 'HUMMER-H2 SUT', 'HUMMER-H3', 'HUMMER-H3T', 'HUSABERG-499', 'HUSABERG-501', 'HUSABERG-FC400', 'HUSABERG-FC450', 'HUSABERG-FC501', 'HUSABERG-FC600', 'HUSABERG-FE250', 'HUSABERG-FE350', 'HUSABERG- FE390', 'HUSABERG-FE400', 'HUSABERG-FE450', 'HUSABERG-FE450 / FS450', 'HUSABERG-FE450/FX450', 'HUSABERG-FE501', 'HUSABERG-FE550', 'HUSABERG-FE570', 'HUSABERG-FE600', 'HUSABERG-FE650', 'HUSABERG-FS450', 'HUSABERG-FS600', 'HUSABERG-FS650', 'HUSABERG-FX400', 'HUSABERG-FX600', 'HUSABERG-FX650', 'HUSABERG-TE250', 'HUSABERG-TE300', 'HUSQVARNA-610', 'HUSQVARNA-CR', 'HUSQVARNA-SM', 'HUSQVARNA-SMS', 'HUSQVARNA-TC', 'HUSQVARNA-TE', 'HUSQVARNA-TXC', 'HUSQVARNA-WR', 'HYOSUNG-GT250', 'HYOSUNG-GT650', 'HYOSUNG-GV250', 'HYOSUNG-GV650', 'HYOSUNG-MS3-250', 'HYOSUNG-SD50', 'HYOSUNG-SF50', 'HYOSUNG-TE-450', 'INTERNATIONAL-1000', 'IC CORPORATION-3000', 'INDIAN MOTORCYCLE CO.-CENTENNIAL', 'INDIAN MOTORCYCLE CO.-CHIEF', 'INDIAN MOTORCYCLE CO.-SCOUT', 'INDIAN MOTORCYCLE CO.-SPORT CHIEF', 'INDIANA PHOENIX-MIXER', 'INTERNATIONAL-2000', 'INTERNATIONAL-5600', 'INTERNATIONAL-5900', 'MACK-700', 'INTERNATIONAL-8000', 'INTERNATIONAL-8300', 'INTERNATIONAL-9000', 'INTERNATIONAL-9100', 'INTERNATIONAL-9200',  'INTERNATIONAL-9300', 'INTERNATIONAL-9370', 'INTERNATIONAL-9400', 'INT ERNATIONAL-9600', 'INTERNATIONAL-9670', 'INTERNATIONAL-9900', 'INTERNATIONAL-CARGOSTAR', 'INTERNATIONAL-CF', 'INTERNATIONAL-CO 9600', 'INTERNATIONAL-CO 9670', 'INTERNATIONAL-CO 9700', 'INTERNATIONAL-CO-LFE', 'INTERNATIONAL-CO-PAYSTAR', 'INTERNATIONAL-CO-TRANSTAR', 'INTERNATIONAL-ESTAR', 'INTERNATIONAL-LONESTAR', 'INTERNATIONAL-METRO II', 'INTERNATIONAL-PAYSTAR', 'INTERNATIONAL-PROSTAR', 'INTERNATIONAL-PROSTAR LMTD', 'INTERNATIONAL-PROSTAR PREMIUM', 'INTERNATIONAL-S-SERIES', 'INTERNATIONAL-S-SERIES RHD', 'INTERNATIONAL-TERRASTAR', 'INTERNATIONAL-TRANSTAR', 'INTERNATIONAL-X-CO MDLS', 'INTERNATIONAL-X-CON', 'INTERNATIONAL-XT SERIES', 'ISUZU-AMIGO', 'ISUZU-ASCENDER', 'ISUZU-AXIOM', 'ISUZU-FRR', 'ISUZU-FSR', 'ISUZU-FTR', 'ISUZU-FTR / FVR', 'ISUZU-FTR / FVR / EVR', 'ISUZU-FVR / EVR', 'ISUZU-HOMBRE', 'ISUZU-HTR', 'ISUZU-HVR', 'ISUZU-HXR', 'ISUZU-I-280', 'ISUZU-I-290', 'ISUZU-I-350', 'ISUZU-I-370', 'ISUZU-I-MARK', 'ISUZU-IMPULSE', 'ISUZU-KS22', 'STERLING TRUCK-LT', 'ISUZU-MR', 'ISU ZU-NPR', 'ISUZU-NQR', 'ISUZU-NRR', 'ISUZU-OASIS', 'ISUZU-PUP', 'ISUZU-RODEO', 'ISUZU-STYLUS', 'ISUZU-T6F042-FTR', 'ISUZU-T7F042-FVR', 'ISUZU-T8F042-FXR', 'ISUZU-T8F064-FXR', 'ISUZU-TROOPER', 'ISUZU-VEHICROSS', 'IVECO-EURO', 'IVECO-Z100', 'IVECO-Z110', 'IVECO-Z120', 'IVECO-Z220', 'IVECO-Z230', 'IVECO-Z340', 'IVECO-Z450', 'IVECO-MAGIRUS-MAGIRUS', 'JOHN DEERE-COMMERCIAL', 'JOHN DEERE-TYPE A', 'KALMAR-CYT 30', 'KALMAR-CYT 50', 'KALMAR-CYT 60T', 'KALMAR-OTTAWA 4X2', 'KALMAR-OTTAWA 6X4', 'KAWASAKI-1600', 'KAWASAKI-AR50', 'KAWASAKI-AR80', 'KAWASAKI-BN125', 'KAWASAKI-EJ650', 'KAWASAKI-EL250', 'KAWASAKI-EL650', 'KAWASAKI-EN450', 'KAWASAKI-EN500', 'KAWASAKI-ER650', 'KAWASAKI-EX250', 'KAWASAKI-EX300', 'KAWASAKI-EX305', 'KAWASAKI-EX500', 'KAWASAKI-EX650', 'KAWASAKI-KAF300', 'KAWASAKI-KAF400', 'KAWASAKI-KAF550', 'KAWASAKI-KAF620', 'KAWASAKI-KAF920', 'KAWASAKI-KAF950', 'KAWASAKI-KD80', 'KAWASAKI-KDX175', 'KAWASAKI-KDX200', 'KAWASAKI-KDX220', 'KAWASAKI-KDX250', 'KAWASAKI-KDX420', 'KAWASAK I-KDX450', 'KAWASAKI-KDX50', 'KAWASAKI-KDX80', 'KAWASAKI-KE100', 'KAWAS AKI-KE125', 'KAWASAKI-KE175', 'KAWASAKI-KEF300', 'KAWASAKI-KL250', 'KAWASAKI-KL600', 'KAWASAKI-KL650', 'KAWASAKI-KLE650', 'KAWASAKI-KLF110', 'KAWASAKI-KLF185', 'KAWASAKI-KLF220', 'KAWASAKI-KLF250', 'KAWASAKI-KLF300', 'KAWASAKI-KLF400', 'KAWASAKI-KLT110', 'KAWASAKI-KLT160', 'KAWASAKI-KLT185', 'KAWASAKI-KLT200', 'KAWASAKI-KLT250', 'KAWASAKI-KLX110', 'KAWASAKI-KLX125', 'KAWASAKI-KLX140', 'KAWASAKI-KLX250', 'KAWASAKI-KLX300', 'KAWASAKI-KLX400', 'KAWASAKI-KLX450', 'KAWASAKI-KLX650', 'KAWASAKI-KM100', 'KAWASAKI-KRF-750', 'KAWASAKI-KRT750', 'KAWASAKI-KSF250', 'KAWASAKI-KSF400', 'KAWASAKI-KSF450', 'KAWASAKI-KSF50', 'KAWASAKI-KSF80', 'KAWASAKI-KSF90', 'KAWASAKI-KSV700', 'KAWASAKI-KVF300', 'KAWASAKI-KVF360', 'KAWASAKI-KVF400', 'KAWASAKI-KVF650', 'KAWASAKI-KVF700', 'KAWASAKI-KVF750', 'KAWASAKI-KVS700', 'KAWASAKI-KX100', 'KAWASAKI-KX125', 'KAWASAKI-KX250', 'KAWASAKI-KX420', 'KAWASAKI-KX450', 'KAWASAKI-KX500', 'KAWASAKI-KX60', 'KAWASAKI-KX65', 'KAWASAKI-KX80', 'KAWASAKI-KX85', 'KAWASAKI -KXF250', 'KAWASAKI-KXT250', 'KAWASAKI-KZ1000', 'KAWASAKI-KZ1100', 'KAWASAKI-KZ1300', 'KAWASAKI-KZ250', 'KAWASAKI-KZ305', 'KAWASAKI-KZ440', 'KAWASAKI-KZ550', 'KAWASAKI-KZ650', 'KAWASAKI-KZ700', 'KAWASAKI-KZ750', 'KAWASAKI-LE650', 'KAWASAKI-NINJA ZX', 'KAWASAKI-VN1500', 'KAWASAKI-VN1600', 'KAWASAKI-VN1700', 'KAWASAKI-VN2000', 'KAWASAKI-VN700', 'KAWASAKI-VN750', 'KAWASAKI-VN800', 'KAWASAKI-VN900', 'KAWASAKI-VULCAN 2000', 'KAWASAKI-ZG1000', 'KAWASAKI-ZG1200', 'KAWASAKI-ZG1400', 'KAWASAKI-ZL1000', 'KAWASAKI-ZL600', 'KAWASAKI-ZL900', 'KAWASAKI-ZN1100', 'KAWASAKI-ZN1300', 'KAWASAKI-ZN700', 'KAWASAKI-ZN750', 'KAWASAKI-ZR1000', 'KAWASAKI-ZR1100', 'KAWASAKI-ZR1200', 'KAWASAKI-ZR550', 'KAWASAKI-ZR750', 'KAWASAKI-ZX1000', 'KAWASAKI-ZX1100', 'KAWASAKI-ZX1200', 'KAWASAKI-ZX1400', 'KAWASAKI-ZX550', 'KAWASAKI-ZX600', 'KAWASAKI-ZX636', 'KAWASAKI-ZX750', 'KAWASAKI-ZX900', 'KENWORTH-CONSTRUCTION', 'KENWORTH-EXPORT', 'KENWORTH-K260/K360', 'KENWORTH-K270/K370', 'KENWORTH-OFF HIGHWAY', 'KTM-105 ', 'KTM-1190', 'KTM-125 / 200', 'KTM-125/150', 'KTM-150', 'KTM-300', 'M ERCEDES-BENZ-380', 'DODGE-400', 'KTM-50 / 65', 'PEUGEOT-505', 'KTM-520', 'KTM-625', 'KTM-65/85', 'KTM-690', 'KTM-85', 'KTM-950', 'KTM-990', 'KTM-DESERT', 'KTM-ENDURO', 'KTM-MOTOCROSS', 'KTM-ROAD', 'KTM-TRIAL', 'KYMCO USA INC-AGILITY', 'KYMCO USA INC-COMPAGNO', 'KYMCO USA INC-DOWNTOWN', 'KYMCO USA INC-Grand Vista', 'KYMCO USA INC-LIKE', 'KYMCO USA INC-MOVIE', 'KYMCO USA INC-PEOPLE', 'KYMCO USA INC-Quannon', 'KYMCO USA INC-SENTO', 'KYMCO USA INC-Sting 50', 'KYMCO USA INC-SUPER 8', 'KYMCO USA INC-Super 9 50', 'KYMCO USA INC-Venox', 'KYMCO USA INC-VITALITY', 'KYMCO USA INC-XCITING', 'KYMCO USA INC-YAGER', 'LAFORZA-LAFORZA', 'LAMBORGHINI-Aventador', 'LAMBORGHINI-COUNTACH', 'LAMBORGHINI-DIABLO', 'LAMBORGHINI-GALLARDO', 'LAMBORGHINI-JALPA', 'LAMBORGHINI-LM', 'LAMBORGHINI-MURCIELAGO', 'LANCIA-BETA', 'LANCIA-ZAGATO', 'LAND ROVER-DEFENDER', 'LAND ROVER-DISCOVERY', 'LAND ROVER-DISCOVERY II', 'LAND ROVER-FREELANDER', 'LAND ROVER-LR2', 'LAND ROVER-LR3', 'LAND ROVER-LR4', 'LAND ROVER-RAN GE ROVER', 'LAND ROVER-Range Rover Evoque', 'LAND ROVER-RANGE ROVER SPORT', 'LODAL-ECO', 'LODAL-EDS', 'LODAL-EVO', 'LOTUS-ELAN', 'LOTUS-ELISE', 'LOTUS-ESPRIT', 'LOTUS-EVORA', 'LOTUS-EXIGE', 'MACK-800', 'MACK-SAVAGE', 'MAHINDRA AND MAHINDRA-TR20', 'MAHINDRA AND MAHINDRA-TR40', 'MARMON HARRINGTON-CAB OVER ENGINE', 'MARMON HARRINGTON-CCV', 'MARMON HARRINGTON-CONVENTIONAL HEAVY DUTY', 'MARMON HARRINGTON-CONVENTIONAL LIGHTWEIGHT', 'MASERATI-228', 'MASERATI-425', 'MASERATI-BITURBO', 'MASERATI-GHIBLI', 'MASERATI-GRANSPORT', 'MASERATI-GRANTURISMO', 'MASERATI-QUATTROPORTE', 'MASERATI-SPYDER', 'MAXIM-CEMENT MIXER', 'MAYBACH-MAYBACH', 'MCLAREN AUTOMOTIVE-MP4-12C', 'MERCEDES-BENZ-L', 'MERCEDES-BENZ-G', 'MERCEDES-BENZ-LP', 'MERCEDES-BENZ-LPS', 'LEXUS-LS', 'MERKUR-SCORPIO', 'MERKUR-XR4TI', 'MITSUBISHI FUSO TRUCK OF AMERICA INC-FH', 'MITSUBISHI FUSO TRUCK OF AMERICA INC-FK', 'MITSUBISHI FUSO TRUCK OF AMERICA INC-FM', 'MOTO GUZZI-BREVA', 'TRIUMPH MOTORCYCLE-DAYTONA', 'MOTO GUZZI-GRISO', 'M OTO GUZZI-NEVADA', 'MOTO GUZZI-NORGE', 'MOTO GUZZI-STELVIO', 'MOTO GUZZ I-V10 CENTAURO', 'MOTO GUZZI-V11', 'MOTO GUZZI-V7', 'MOTORRAD UND ZWEIRADWERK-COUNTRY', 'MOTORRAD UND ZWEIRADWERK-SILVERSTAR', 'MOTORRAD UND ZWEIRADWERK-SKORPION', 'MOTORRAD UND ZWEIRADWERK-TOUR', 'NEOPLAN-ADVANCED', 'NEOPLAN-CITYLINER', 'NEOPLAN-JETLINER', 'NEOPLAN-SKYLINER', 'NEOPLAN-SPACELINER', 'NISSAN-NV', 'NISSAN-NV200', 'CHEVROLET-VAN', 'NISSAN DIESEL-CLA83', 'NISSAN DIESEL-CMA83', 'NISSAN DIESEL-CPB12', 'NISSAN DIESEL-CPC12', 'NISSAN DIESEL-UD1000', 'NISSAN DIESEL-UD1200', 'NISSAN DIESEL-UD1300', 'NISSAN DIESEL-UD1400', 'NISSAN DIESEL-UD1800', 'NISSAN DIESEL-UD2000', 'NISSAN DIESEL-UD2300', 'NISSAN DIESEL-UD2600', 'NISSAN DIESEL-UD2800', 'NISSAN DIESEL-UD3000', 'NISSAN DIESEL-UD3300', 'NISSAN DIESEL-UD550', 'NISSAN DIESEL-UD600', 'ONTARIO BUS-ORION I', 'ORION BUS-ORION II', 'ORION BUS-ORION V', 'ORION BUS-ORION VI', 'ORION BUS-ORION VII', 'OSHKOSH MOTOR TRUCK CO.-FORWARD MOUNTED', 'OSHKOSH MOTOR TRUCK CO.-JOHN DEERE', 'OSHKOSH MOTOR TRUCK CO.-LOW TILT', 'OSHKOSH MOT OR TRUCK CO.-S SERIES', 'OTTAWA-FIRE CAB CHASSIS', 'OTTAWA-ROGUE', 'OTTAWA-YT', 'PETER PIRSCH & SONS CO.-PETER PIRSCH', 'PETERBILT-210', 'PETERBILT-220', 'PETERBILT-270', 'PETERBILT-320', 'PETERBILT-330', 'PETERBILT-335', 'PETERBILT-337', 'PETERBILT-340', 'PETERBILT-349', 'PETERBILT-352', 'PETERBILT-353', 'PETERBILT-357', 'PETERBILT-359', 'PETERBILT-362', 'PETERBILT-365', 'PETERBILT-367', 'PETERBILT-372', 'PETERBILT-375', 'PETERBILT-376', 'PETERBILT-377', 'PETERBILT-378', 'PETERBILT-379', 'PETERBILT-382', 'PETERBILT-384', 'PETERBILT-385', 'PETERBILT-386', 'PETERBILT-387', 'PETERBILT-388', 'PETERBILT-389', 'PETERBILT-397', 'PETERBILT-579', 'PETERBILT-587', 'PEUGEOT-405', 'PEUGEOT-504', 'PEUGEOT-604', 'PIAGGIO-BV', 'PIAGGIO-FLY', 'PIAGGIO-MP3', 'GMC-TYPHOON', 'PIAGGIO-X9 EVOLUTION', 'PIERCE MFG. INC.-PIERCE', 'PLYMOUTH-ACCLAIM', 'PLYMOUTH-ARROW', 'PLYMOUTH-BREEZE', 'PLYMOUTH-CARAVELLE', 'PLYMOUTH-CHAMP', 'DODGE-COLT', 'DODGE-CONQUEST', 'PLYMOUTH-GRAN FURY', 'PLYMOUTH-GRAND VO YAGER', 'PLYMOUTH-HORIZON', 'CHRYSLER-LASER', 'PLYMOUTH-NEON', 'CHRYSLE R-PROWLER', 'PLYMOUTH-RELIANT', 'PLYMOUTH-SAPPORO', 'PLYMOUTH-SCAMP', 'PLYMOUTH-SUNDANCE', 'PLYMOUTH-TRAILDUSTER', 'PLYMOUTH-VOYAGER', 'POLARIS-ALL TERRAIN PICKUP', 'POLARIS-BIG BOSS', 'POLARIS-DIESEL', 'POLARIS-GEN', 'POLARIS-HAWKEYE', 'POLARIS-MAGNUM', 'PONTIAC-PHOENIX', 'POLARIS-PREDATOR', 'POLARIS-SAWTOOTH', 'POLARIS-SCRAMBLER', 'POLARIS-SPORTSMAN', 'POLARIS-TRAIL BLAZER', 'POLARIS-TRAIL BOSS', 'POLARIS-X2', 'POLARIS-XPEDITION', 'POLARIS-XPLORER', 'POLARIS-XPRESS', 'PORSCHE-911', 'PORSCHE-911 NEW GENERATION', 'PORSCHE-924', 'PORSCHE-928', 'PORSCHE-944', 'PORSCHE-968', 'PORSCHE-BOXSTER', 'PORSCHE-CARRERA', 'PORSCHE-CAYENNE', 'PORSCHE-CAYMAN', 'PORSCHE-Panamera', 'RAM-4500', 'RAM-PROMASTER 1500', 'RAM-PROMASTER 2500', 'RAM-PROMASTER 3500', 'RENAULT-18I', 'RENAULT-FUEGO', 'RENAULT-LECAR', 'RENAULT-SPORTWAGON', 'ROADMASTER RAIL-AE-STACKED RAIL', 'ROADMASTER RAIL-DYANASTER', 'ROADMASTER RAIL-EXECUTIVE SIGNATURE', 'ROADMASTER RAIL-LF4F', 'ROADMASTER RAIL-M-SERIES', 'ROADMASTE R RAIL-MAGNUM B-SERIES', 'ROADMASTER RAIL-MAGNUM C-SERIES', 'ROADMASTER RAIL-MAGNUM M-SERIES', 'ROADMASTER RAIL-MAGNUM S-SERIES', 'ROADMASTER RAIL-MONOCOQUE', 'WORKHORSE CUSTOM CHASSIS-MOTORHOME CHASSIS', 'ROADMASTER RAIL-RAISED RAIL', 'ROADMASTER RAIL-STRAIGHT RAIL', 'ROLLS-ROYCE-CARMAQUE', 'ROLLS-ROYCE-FLYING SPUR', 'ROLLS-ROYCE-GHOST', 'ROLLS-ROYCE-PARK WARD', 'ROLLS-ROYCE-PHANTOM', 'ROLLS-ROYCE-SILVER DAWN', 'ROLLS-ROYCE-SILVER SERAPH', 'ROLLS-ROYCE-SILVER SPIRIT', 'ROLLS-ROYCE-SILVER SPUR', 'ROLLS-ROYCE-TOURING LIMO', 'SAVAGE-CONCRETE VEHICLE', 'SCANIA-COE HIGH', 'SCANIA-COE LOW', 'SEAGRAVE FIRE APPARATUS-SEAGRAVE', 'SPARTAN MOTORS-AMBULANCE', 'SPARTAN MOTORS-CONCRETE MIXER', 'SPARTAN MOTORS-DIAMOND', 'SPARTAN MOTORS-FURION', 'SPARTAN MOTORS-SPECIALTY', 'SPARTAN MOTORS-STEP VAN', 'SPRINTER-2500 Sprinter', 'SPRINTER-3500 Sprinter', 'STERLING-827', 'STERLING TRUCK-A', 'STERLING TRUCK-ACTERRA', 'STERLING TRUCK-LC', 'STERLING TRUCK-M', 'STERLING TRUCK-MITSUBISHI CHASSIS CO E', 'LEXUS-SC', 'STERLING TRUCK-ST', 'SUZUKI-AERIO', 'SUZUKI-ALT125', ' SUZUKI-ALT185', 'SUZUKI-ALT50', 'SUZUKI-AN400', 'SUZUKI-AN650', 'SUZUKI-C50', 'SUZUKI-C90', 'SUZUKI-DL100', 'SUZUKI-DL1000', 'SUZUKI-DL650', 'SUZUKI-DR-Z110', 'SUZUKI-DR-Z125', 'SUZUKI-DR-Z250', 'SUZUKI-DR-Z400', 'SUZUKI-DR-Z70', 'SUZUKI-DR100', 'SUZUKI-DR125', 'SUZUKI-DR200', 'SUZUKI-DR250', 'SUZUKI-DR350', 'SUZUKI-DR500', 'SUZUKI-DR600', 'SUZUKI-DR650', 'SUZUKI-DR750', 'SUZUKI-DS100', 'SUZUKI-DS125', 'SUZUKI-DS185', 'SUZUKI-DS250', 'SUZUKI-DS50', 'SUZUKI-DS80', 'SUZUKI-EQUATOR', 'SUZUKI-ESTEEM', 'SUZUKI-FA50', 'SUZUKI-FORENZA', 'SUZUKI-FS50', 'SUZUKI-FZ50', 'SUZUKI-GN125', 'SUZUKI-GN250', 'SUZUKI-GN400', 'SUZUKI-GR650', 'SUZUKI-GRAND VITARA', 'SUZUKI-GS1000', 'SUZUKI-GS1100', 'SUZUKI-GS1150', 'SUZUKI-GS250', 'SUZUKI-GS300', 'SUZUKI-GS400', 'SUZUKI-GS450', 'SUZUKI-GS500', 'SUZUKI-GS550', 'SUZUKI-GS650', 'SUZUKI-GS700', 'SUZUKI-GS750', 'SUZUKI-GS850', 'SUZUKI-GSF1200', 'SUZUKI-GSF1250', 'SUZUKI-GSF400', 'SUZUKI-GSF600', 'SUZUKI-GSF650', 'SUZUKI-GSX', 'SUZUKI-GSX-R1000', 'SU ZUKI-GSX-R1100', 'SUZUKI-GSX-R600', 'SUZUKI-GSX-R750', 'SUZUKI-GSX1100', 'SUZUKI-GSX1250', 'SUZUKI-GSX1300', 'SUZUKI-GSX600', 'SUZUKI-GSX650', 'SUZUKI-GSX750', 'SUZUKI-GV1200', 'SUZUKI-GV1400', 'SUZUKI-GV700', 'SUZUKI-GZ250', 'SUZUKI-JIMNY', 'SUZUKI-JR50', 'SUZUKI-JR80', 'SUZUKI-KIZASHI', 'SUZUKI-LS650', 'SUZUKI-LT-A400', 'SUZUKI-LT-A450', 'SUZUKI-LT-A50', 'SUZUKI-LT-A500', 'SUZUKI-LT-A700', 'SUZUKI-LT-A750', 'SUZUKI-LT-F160', 'SUZUKI-LT-R450', 'SUZUKI-LT-V700', 'SUZUKI-LT-Z250', 'SUZUKI-LT-Z400', 'SUZUKI-LT-Z50', 'SUZUKI-LT-Z90', 'SUZUKI-LT125', 'SUZUKI-LT160', 'SUZUKI-LT185', 'SUZUKI-LT230', 'SUZUKI-LT250', 'SUZUKI-LT300', 'SUZUKI-LT50', 'SUZUKI-LT500', 'SUZUKI-LT80', 'SUZUKI-LTF', 'SUZUKI-LTF230', 'SUZUKI-LTF250', 'SUZUKI-LTF300', 'SUZUKI-LTF4', 'SUZUKI-LTF400', 'SUZUKI-LTF500', 'SUZUKI-M109R / VZR1800', 'SUZUKI-M50', 'SUZUKI-PE175', 'SUZUKI-PE250', 'SUZUKI-PE400', 'SUZUKI-QUV620', 'SUZUKI-RB50', 'SUZUKI-RENO', 'SUZUKI-RF600', 'SUZUKI-RFR900', 'SUZUKI-RG250', 'SUZUKI-RG5 00', 'SUZUKI-RM-Z250', 'SUZUKI-RM-Z450', 'SUZUKI-RM100', 'SUZUKI-RM125', 'SUZUKI-RM2450', 'SUZUKI-RM250', 'SUZUKI-RM465', 'SUZUKI-RM500', 'SUZUKI-RM60', 'SUZUKI-RM65', 'SUZUKI-RM80', 'SUZUKI-RM85', 'SUZUKI-RMX250', 'SUZUKI-RS175', 'SUZUKI-RS250', 'SUZUKI-SA310', 'SUZUKI-SAMURAI', 'SUZUKI-SFV650', 'SUZUKI-SIDEKICK', 'SUZUKI-SP100', 'SUZUKI-SP125', 'SUZUKI-SP200', 'SUZUKI-SP250', 'SUZUKI-SP500', 'SUZUKI-SP600', 'SUZUKI-SV1000', 'SUZUKI-SV650', 'SUZUKI-SWIFT', 'SUZUKI-SX4', 'SUZUKI-TL1000', 'SUZUKI-TS100', 'SUZUKI-TS125', 'SUZUKI-TS185', 'SUZUKI-TS250', 'SUZUKI-TU250', 'SUZUKI-VERONA', 'SUZUKI-VITARA', 'SUZUKI-VL1500', 'SUZUKI-VL800', 'SUZUKI-VLR1800', 'SUZUKI-VS1400', 'SUZUKI-VS700', 'SUZUKI-VS750', 'SUZUKI-VS800', 'SUZUKI-VX800', 'SUZUKI-VZ1500', 'SUZUKI-VZ1600', 'SUZUKI-VZ800', 'SUZUKI-VZR1800', 'SUZUKI-X90', 'SUZUKI-XL7', 'SUZUKI-XN85', 'TESLA-MODEL S', 'TOYOTA-PICKUP COMMERCIAL / CAMPER', 'TRANSPORTATION MFG CORP.-102A3', 'TRANSPORTATION MFG CORP.-102C3', 'TRANSPORTATION MFG CORP.-9623', 'TRANSPORTATION MFG CORP.-96A3', 'TRANSPORTATION MFG C ORP.-MC-9', 'TRANSPORTATION MFG CORP.-T-30', 'TRANSPORTATION MFG CORP.-T70206', 'TRANSPORTATION MFG CORP.-T706', 'TRANSPORTATION MFG CORP.-T70608', 'TRANSPORTATION MFG CORP.-T802', 'TRANSPORTATION MFG CORP.-T806', 'TRIUMPH CAR-TR7', 'TRIUMPH CAR-TR8', 'TRIUMPH MOTORCYCLE-ADVENTURER', 'TRIUMPH MOTORCYCLE-BONNEVILLE', 'TRIUMPH MOTORCYCLE-LEGEND TT', 'TRIUMPH MOTORCYCLE-ROCKET III', 'MAZDA-SPEED', 'TRIUMPH MOTORCYCLE-SPEED TRIPLE', 'TRIUMPH MOTORCYCLE-SPEEDMASTER', 'TRIUMPH MOTORCYCLE-SPRINT', 'TRIUMPH MOTORCYCLE-STREET TRIPLE', 'TRIUMPH MOTORCYCLE-SUPER III', 'TOYOTA-T100', 'TRIUMPH MOTORCYCLE-T509', 'TRIUMPH MOTORCYCLE-T595', 'TRIUMPH MOTORCYCLE-THRUXTON', 'FORD-THUNDERBIRD', 'TRIUMPH MOTORCYCLE-TIGER', 'TRIUMPH MOTORCYCLE-TRIDENT', 'TRIUMPH MOTORCYCLE-TROPHY', 'TRIUMPH MOTORCYCLE-TT600', 'TVR-TVR', 'UNIMOG-3350', 'UNIMOG-3900', 'VAN HOOL-C2045', 'VAN HOOL-T2100', 'VAN HOOL-T800', 'VAN HOOL-T809', 'VAN HOOL-T815', 'VAN HOOL-T900', 'VAN HOOL-TD925', 'VESPA-C161C', 'VESPA-GTS', 'LEXUS-LX', 'VESPA-M198F', 'VESPA-PX', 'VICTORY MOTORCYCLES-ANESS', 'VICTORY MOTORCYCLES-BOARDWALK', 'VICTORY MOTORCYCLES-CNESS', 'VICTORY MOTORCYCLES-CROSS COUNTRY', 'VICTORY MOTORCYCLES-CROSS ROADS', 'VICTORY MOTORCYCLES-DELUXE TOURING', 'VICTORY MOTORCYCLES-HAMMER', 'VICTORY MOTORCYCLES-HARD-BALL', 'VICTORY MOTORCYCLES-HIGH-BALL', 'VICTORY MOTORCYCLES-JACKPOT', 'VICTORY MOTORCYCLES-KINGPIN', 'VICTORY MOTORCYCLES-NESS', 'VICTORY MOTORCYCLES-TOURING', 'VICTORY MOTORCYCLES-V92', 'VICTORY MOTORCYCLES-VEGAS', 'VICTORY MOTORCYCLES-VX', 'VICTORY MOTORCYCLES-ZNESS', 'VOLKSWAGEN-EUROVAN', 'VOLVO-9700', 'VOLVO-AERO', 'VOLVO-FE6', 'VOLVO-FE7', 'VOLVO-HIGH COE', 'VOLVO-N10', 'VOLVO-N12', 'VOLVO-VA', 'VOLVO-VHD', 'VOLVO-VN', 'VOLVO-VT', 'WESTERN RV-ALPINE', 'WHITE-INTEGRAL', 'WHITE-LOW COE', 'WHITE-ROAD BOSS', 'WHITE-ROAD COMMANDER', 'WHITE-ROAD XPEDITOR', 'WHITE/GMC-BRIGADIER', 'WINNEBAGO-CLASS A', 'WINNEBAGO-LE SHARO/PHASAR', 'WINNEBAGO-RIALTA', 'WINNEBAGO-WALK-IN VAN', 'FORD-BUS CHASSIS', 'WORKHORSE CUSTOM CHASSIS-R26 - UFO', 'YAMAHA-BW200', 'YAMAH A-BW350', 'YAMAHA-BW80', 'YAMAHA-CA50', 'YAMAHA-CE11', 'YAMAHA-CE12', 'YAMAHA-CE14', 'YAMAHA-CE50', 'YAMAHA-CG19', 'YAMAHA-CG50', 'YAMAHA-CP250', 'YAMAHA-CV50', 'YAMAHA-CV80', 'YAMAHA-CW50', 'YAMAHA-CX50', 'YAMAHA-CY50', 'YAMAHA-DT100', 'YAMAHA-DT125', 'YAMAHA-DT175', 'YAMAHA-DT200', 'YAMAHA-DT50', 'YAMAHA-DT80', 'YAMAHA-FJ1100', 'YAMAHA-FJ1200', 'YAMAHA-FJ600', 'YAMAHA-FJR1300', 'YAMAHA-FZ1', 'YAMAHA-FZ6', 'YAMAHA-FZ600', 'YAMAHA-FZ700', 'YAMAHA-FZ750', 'YAMAHA-FZ8', 'YAMAHA-FZR1000', 'YAMAHA-FZR400', 'YAMAHA-FZR600', 'YAMAHA-FZR750', 'YAMAHA-FZS10', 'YAMAHA-FZX700', 'YAMAHA-FZX750', 'YAMAHA-GTS1000', 'YAMAHA-IT200', 'YAMAHA-IT250', 'YAMAHA-IT490', 'YAMAHA-LB50', 'YAMAHA-LC50', 'YAMAHA-MJ50', 'YAMAHA-MT-01', 'YAMAHA-PRO HAULER', 'YAMAHA-PW50', 'YAMAHA-PW501', 'YAMAHA-PW80', 'YAMAHA-PW801', 'YAMAHA-QT50', 'YAMAHA-RT100', 'YAMAHA-RT180', 'YAMAHA-RX50', 'YAMAHA-RZ350', 'YAMAHA-RZ500', 'YAMAHA-SH50', 'YAMAHA-SR185', 'YAMAHA-SR250', 'YAMAHA-SR500', 'YAMAHA-SRX250', 'YAMAHA-SRX6 00', 'YAMAHA-TDM850', 'YAMAHA-TT-R110E', 'YAMAHA-TT-R230', 'YAMAHA-TT22 5', 'YAMAHA-TT250', 'YAMAHA-TT350', 'YAMAHA-TTR125', 'YAMAHA-TTR225', 'YAMAHA-TTR230', 'YAMAHA-TTR50', 'YAMAHA-TTR90', 'YAMAHA-TW200', 'YAMAHA-TY350', 'YAMAHA-TZ250', 'YAMAHA-TZR250', 'YAMAHA-VMX12', 'YAMAHA-VMX17', 'YAMAHA-VP11', 'YAMAHA-WR200', 'YAMAHA-WR250', 'YAMAHA-WR400', 'YAMAHA-WR426', 'YAMAHA-WR450', 'YAMAHA-WR500', 'YAMAHA-XC125', 'YAMAHA-XC180', 'YAMAHA-XC200', 'YAMAHA-XC50', 'YAMAHA-XF50', 'YAMAHA-XJ1100', 'YAMAHA-XJ550', 'YAMAHA-XJ600', 'YAMAHA-XJ650', 'YAMAHA-XJ700', 'YAMAHA-XJ750', 'YAMAHA-XJ900', 'YAMAHA-XP500', 'YAMAHA-XS1100', 'YAMAHA-XS400', 'YAMAHA-XS650', 'YAMAHA-XS850', 'YAMAHA-XT1200Z', 'YAMAHA-XT1200ZC', 'YAMAHA-XT125', 'YAMAHA-XT200', 'YAMAHA-XT225', 'YAMAHA-XT250', 'YAMAHA-XT350', 'YAMAHA-XT500', 'YAMAHA-XT550', 'YAMAHA-XT600', 'YAMAHA-XV1000', 'YAMAHA-XV1100', 'YAMAHA-XV16', 'YAMAHA-XV1600', 'YAMAHA-XV1700', 'YAMAHA-XV1900', 'YAMAHA-XV250', 'YAMAHA-XV500', 'YAMAHA-XV535', 'YAMAHA-XV700', 'YAMAHA-XV750', 'YAMAHA-XV7501', 'YAMAHA-XV920', 'YAMAHA-XVS 1100', 'YAMAHA-XVS1300', 'YAMAHA-XVS65', 'YAMAHA-XVS650', 'YAMAHA-XVS950', 'YAMAHA-XVZ12', 'YAMAHA-XVZ13', 'YAMAHA-XZ550', 'YAMAHA-YF60', 'YAMAHA-YFA1', 'YAMAHA-YFB250', 'YAMAHA-YFM100', 'YAMAHA-YFM125', 'YAMAHA-YFM200', 'YAMAHA-YFM225', 'YAMAHA-YFM25', 'YAMAHA-YFM250', 'YAMAHA-YFM300', 'YAMAHA-YFM350', 'YAMAHA-YFM4', 'YAMAHA-YFM40', 'YAMAHA-YFM400', 'YAMAHA-YFM45', 'YAMAHA-YFM450', 'YAMAHA-YFM50', 'YAMAHA-YFM550', 'YAMAHA-YFM660', 'YAMAHA-YFM700', 'YAMAHA-YFM80', 'YAMAHA-YFM90', 'YAMAHA-YFP350', 'YAMAHA-YFS200', 'YAMAHA-YFU1', 'YAMAHA-YFZ350', 'YAMAHA-YFZ450', 'YAMAHA-YJ125', 'YAMAHA-YJ50', 'YAMAHA-YP400', 'YAMAHA-YSR50', 'YAMAHA-YT125', 'YAMAHA-YT60', 'YAMAHA-YTM200', 'YAMAHA-YTM225', 'YAMAHA-YTZ250', 'YAMAHA-YW125', 'YAMAHA-YW50', 'YAMAHA-YX600', 'YAMAHA-YXR450', 'YAMAHA-YXR660', 'YAMAHA-YXR700', 'YAMAHA-YZ100', 'YAMAHA-YZ125', 'YAMAHA-YZ1251', 'YAMAHA-YZ250', 'YAMAHA-YZ2501', 'YAMAHA-YZ400', 'YAMAHA-YZ426', 'YAMAHA-YZ450', 'YAMAHA-YZ490', 'YAMAHA-YZ80', 'YAMAHA-YZ801',  'YAMAHA-YZ85', 'YAMAHA-YZF1000', 'YAMAHA-YZF600', 'YAMAHA-YZF750', 'YAM AHA-YZFR1', 'YAMAHA-YZFR6', 'YUGO-GV', 'YUGO-GVC', 'YUGO-GVL', 'YUGO-GVS', 'YUGO-GVX', 'ZONGSHEN-ZS125', 'ZONGSHEN-ZS125ST', 'ZONGSHEN-ZS150', 'ZONGSHEN-ZS200GY-A', 'ZONGSHEN-ZS250', 'ZONGSHEN-ZS250-5', 'ALFA ROMEO-GT', 'AMERICAN IRON HORSE-CLASSIC', 'AMERICAN IRON HORSE-LEGEND', 'AMERICAN IRON HORSE-OUTLAW', 'AMERICAN IRON HORSE-RANGER', 'AMERICAN IRON HORSE-ROADSTER', 'AMERICAN MOTORS-EAGLE', 'AMERICAN MOTORS-SPIRIT', 'ATK-125', 'ATK-200', 'ATK-250', 'ATK-260', 'ATK-600', 'ATK-90', 'AUTOCAR-ACL', 'AUTOCAR-ACM', 'BENTLEY-CORNICHE', 'CAN-AM-DS', 'CHANCE COACH TRANSIT BUS-TRANSIT BUS', 'CHEVROLET-7000', 'CHEVROLET-B7T042', 'CHEVROLET-HI-CUBE VAN', 'COUNTRY COACH MOTORHOME-TRIBUTE', 'CRANE CARRIER-GLIDER KIT', 'CRANE CARRIER-SCHOOL BUS', 'CROWN COACH-CHASSIS', 'DATSUN-300ZX', 'DATSUN-310', 'DATSUN-PULSAR', 'DATSUN-SENTRA', 'DATSUN-STANZA', 'DIAMOND REO-C116', 'DINA TRANSIT BUS-TRANSIT BUS', 'DUCATI-620', 'DUCATI-650', 'DUCATI-750', 'EAGLE-EAGLE', 'ELECTRIC VEHICLE TECHNOLOGIE S-SPORT', 'FERRARI-328', 'FERRARI-348', 'FERRARI-California', 'FERRARI-FF', 'FIAT-500', 'FLXIBLE TRANSIT BUS-TRANSIT BUS', 'FORD-F550', 'FREIGHTLINER-CONVENTIONAL', 'FREIGHTLINER-LEGACY', 'FREIGHTLINER-SPRINTER', 'FWD CORPORATION-FD', 'GEO-TRACKER', 'GILLIG-SCHOOL BUS', 'GILLIG-SHUTTLE BUS', 'GILLIG-TRANSIT BUS', 'GLOBAL ELECTRIC MOTORS-825', 'GMC-4000', 'GMC-5000', 'GMC-6000', 'GMC-7000', 'GMC-C1500', 'GMC-C2500', 'GMC-C4500', 'GMC-C5000', 'GMC-C5500', 'GMC-C6000', 'GMC-C6500', 'GMC-C7500', 'GMC-C8500', 'GMC-PS6500', 'GMC-R15 CONVENTIONAL', 'GMC-R25 CONVENTIONAL', 'GMC-R35 CONVENTIONAL', 'GMC-S6000', 'HARLEY-DAVIDSON-XR100', 'HENDRICKSON-BUS', 'HENDRICKSON-FIRETRUCK', 'HENDRICKSON-TRUCK', 'HINO-FE', 'HINO-FG', 'HONDA-VF700', 'HUMMER-H1', 'HUSABERG-350', 'HUSABERG-600', 'HUSQVARNA-125', 'HUSQVARNA-250', 'HUSQVARNA-260', 'HUSQVARNA-350', 'HUSQVARNA-360', 'HUSQVARNA-510', 'IC CORPORATION-1000', 'INDIANA PHOENIX-GLIDER', 'INTERNATIONAL-3000', 'INTERNATIONAL-5500', 'INTERNATION AL-700', 'INTERNATIONAL-900', 'ISUZU-CONVENTIONAL', 'ISUZU-LT', 'KENWOR TH-COE', 'KOVATCH-FIRETRUCK', 'KTM-200', 'KTM-250', 'KTM-350', 'KTM-360', 'KTM-380', 'KTM-400', 'KTM-450', 'KTM-50', 'KTM-500', 'KTM-505', 'KTM-525', 'KTM-530', 'KTM-560', 'KTM-640', 'LES AUTOBUS MCI-BUS', 'MACK-200', 'MACK-300', 'MACK-400', 'MACK-500', 'MACK-600', 'MARMON HARRINGTON-CONVENTIONAL', 'MARMON HARRINGTON-GLIDER', 'MASERATI-430', 'MASERATI-COUPE', 'MOTO GUZZI-1000', 'MOTO GUZZI-DAYTONA', 'MOTO GUZZI-SPORT', 'MOTOR COACH INDUSTRIES-TRANSIT BUS', 'NEW FLYER-TRANSIT BUS', 'NOVA BUS CORPORATION-BUS', 'ONTARIO BUS-ORION II', 'ONTARIO BUS-ORION V', 'ONTARIO BUS-ORION VI', 'OSHKOSH MOTOR TRUCK CO.-CHASSIS', 'OSHKOSH MOTOR TRUCK CO.-CONVENTIONAL', 'PETERBILT-200', 'PETERBILT-325', 'PIAGGIO-LT', 'PIAGGIO-TYPHOON', 'PLYMOUTH-COLT', 'PLYMOUTH-CONQUEST', 'PLYMOUTH-LASER', 'PLYMOUTH-PROWLER', 'POLARIS-PHOENIX', 'POLARIS-RANGER', 'PREVOST-BUS', 'ROADMASTER RAIL-MOTORHOME CHASSIS', 'SCANIA-CONVENTIONAL', 'SPARTAN MOTORS-FIRETRUCK', 'SPARTAN MOTORS-MOTORHOME', 'SPARTAN MOTORS-S CHOOL BUS', 'SPARTAN MOTORS-SHUTTLE BUS', 'SPARTAN MOTORS-TRANSIT BUS', 'STERLING TRUCK-AT', 'STERLING TRUCK-BULLET', 'STERLING TRUCK-CONDOR', 'STERLING TRUCK-L', 'STERLING TRUCK-SC', 'STERLING TRUCK-SPORT CHASSIS', 'STEWART & STEVENSON-TRANSIT BUS', 'SUTPHEN CORP.-FIRETRUCK', 'SUZUKI-LT', 'TEREX / TEREX ADVANCE-ADVANCE MIXER', 'THOMAS-SCHOOL BUS', 'THOMAS-TRANSIT BUS', 'TRIUMPH MOTORCYCLE-AMERICA', 'TRIUMPH MOTORCYCLE-SCRAMBLER', 'TRIUMPH MOTORCYCLE-SPEED', 'TRIUMPH MOTORCYCLE-T100', 'TRIUMPH MOTORCYCLE-THUNDERBIRD', 'UTILIMASTER-STEP VAN', 'VAN HOOL-TRANSIT BUS', 'VESPA-GRANTURISMO', 'VESPA-LX', 'VICTORY MOTORCYCLES-JUDGE', 'VICTORY MOTORCYCLES-VISION', 'VOLVO-F600', 'VOLVO-F700', 'VOLVO-CONVENTIONAL', 'VOLVO-FE', 'VOLVO-XPEDITOR', 'WESTERN STAR/AUTO CAR-HIGH COE', 'WHITE-AERO', 'WHITE-CONVENTIONAL', 'WHITE-HIGH COE', 'WHITE-XPEDITOR', 'WHITE/GMC-ACL', 'WHITE/GMC-AERO', 'WHITE/GMC-CONVENTIONAL', 'WHITE/GMC-HIGH COE', 'WHITE/GMC-INTEGRAL', 'WHITE/GMC-LOW COE', 'WHITE/GMC-X PEDITOR', 'WORKHORSE CUSTOM CHASSIS-BUS CHASSIS', 'WORKHORSE CUSTOM CHA SSIS-FORWARD CONTROL CHASSIS', 'WORKHORSE CUSTOM CHASSIS-STEP VAN', 'YAMAHA-TT600', 'ZELIGSON-CONVENTIONAL', 'YAMAHA-FZ09', 'YAMAHA-YXM700', 'YIBEN-MD150T', 'YIBEN-MD250T', 'YIBEN-MD50QT', 'ZERO MOTORCYCLES INC-DIRT', 'ZERO MOTORCYCLES INC-DS', 'ZERO MOTORCYCLES INC-FX', 'ZERO MOTORCYCLES INC-MXD', 'ZERO MOTORCYCLES INC-S', 'ZERO MOTORCYCLES INC-SR', 'ZERO MOTORCYCLES INC-STREET', 'ZERO MOTORCYCLES INC-X', 'ZERO MOTORCYCLES INC-XD', 'ZERO MOTORCYCLES INC-XU', 'VOLKSWAGEN-TRANSPORTER', 'VAN HOOL-TOURIST COACH TX', 'VAN HOOL-UNKNOWN', 'VICTORY MOTORCYCLES-GUNNER', 'SYM-CITYCOM', 'SYM-FIDDLE II', 'SYM-HD', 'SYM-RV', 'SYM-WOLF', 'SMITH ELECTRIC-D100 SC', 'SMITH ELECTRIC-D120 SC', 'SMITH ELECTRIC-D75 SC', 'ROLLS-ROYCE-WRAITH', 'PORSCHE-MACAN', 'PETERBILT-567', 'MCLAREN AUTOMOTIVE-650s', 'M. V. AGUSTA-BRUTALE', 'M. V. AGUSTA-MV AGUSTA SM', 'M. V. AGUSTA-MV AGUSTA TE', 'M. V. AGUSTA-MV AGUSTA/B3', 'M. V. AGUSTA-MV AGUSTA/B5', 'M. V. AGUSTA-MV AGUSTA/F3', 'M. V. AGUSTA-MV AGUSTA/F5 ', 'M. V. AGUSTA-MV AGUSTA/F6', 'KTM-1290', 'KYMCO USA INC-BET & WIN', 'KYMCO USA INC-FLAT BED', 'KYMCO USA INC-KYMCO ATV', 'KYMCO USA INC-MONGOOSE', 'KYMCO USA INC-Mongoose/MXU', 'KYMCO USA INC-MXER', 'KYMCO USA INC-MXU', 'KYMCO USA INC-Red Sticker ATV', 'KYMCO USA INC-Sporty ATV', 'KYMCO USA INC-Sporty Utility ATV', 'KYMCO USA INC-Super 9', 'KYMCO USA INC-Utility ATV', 'KYMCO USA INC-UXV', 'KYMCO USA INC-ZX50', 'LAMBORGHINI-HURACAN', 'KAWASAKI-KRF800', 'KAWASAKI-KRT800', 'INDIAN MOTORCYCLE CO.-CHIEFTAIN', 'HUSQVARNA-SMR', 'HUSQVARNA-TR650', 'HYOSUNG-ST7', 'HARLEY DAVIDSON-FLH80', 'HARLEY DAVIDSON-FLSTC', 'HARLEY DAVIDSON-FXSB', 'HARLEY DAVIDSON-FXST', 'HARLEY DAVIDSON-FXWG', 'HARLEY DAVIDSON-XG500', 'HARLEY-DAVIDSON-FLHTKSE', 'HARLEY-DAVIDSON-FLHTNSE', 'HARLEY-DAVIDSON-FLHXS', 'HARLEY-DAVIDSON-XG500', 'HARLEY-DAVIDSON-XG750', 'GMC-TRANSIT BUS', 'GENUINE SCOOTER CO.-RATTLER', 'GLOBAL ELECTRIC MOTORS-E4 S', 'GLOBAL ELECTRIC MOTORS-E6 S', 'GLOBAL ELECTRIC MOTORS-EL XD', 'ETO N-BEAMER', 'ETON-BEAMER II', 'ETON-BEAMER III', 'ETON-BEAMER MATRIX', 'ETON-BEAMER MATRIX II', 'ETON-BEAMER R2', 'ETON-BEAMER R4', 'ETON-LIGHTNING', 'ETON-MATRIX 50', 'ETON-MATRIX R4-150', 'ETON-RASCAL', 'ETON-ROVER', 'ETON-ROVER GT', 'ETON-SIERRA', 'ETON-SIERRA UTILITY', 'ETON-THUNDER', 'ETON-TXL-50', 'ETON-TXL-90', 'ETON-VECTOR 250', 'ETON-VIPER 150R', 'ETON-VIPER 40E', 'ETON-VIPER 50', 'ETON-VIPER 50M', 'ETON-VIPER 70', 'ETON-VIPER 70-4S', 'ETON-VIPER 70M', 'ETON-VIPER 90', 'ETON-VIPER 90-4S', 'ETON-VIPER 90R', 'ETON-VIPER JR', 'ETON-YUKON', 'ETON-YUKON II', 'FERRARI-458 SPECIALE', 'FERRARI-LAFERRARI', 'CPI MOTOR COMPANY-CITY HOP', 'CPI MOTOR COMPANY-STYLE', 'CPI MOTOR COMPANY-VEER', 'CAGIVA-F4', 'CAGIVA-TE E', 'CAN-AM-COMMANDER MAX', 'CAN-AM-MAVERICK MAX', 'BMW-R NINE T', 'AUTOCAR LLC.-Xpert', 'BENTLEY-FLYING SPUR', 'ALFA ROMEO-4C', 'APRILIA-SR MOTARD', 'POLARIS-BRUTUS', 'BMW-F650', 'BMW-F700', 'BMW-F800', 'CHEVROLET-CUTAWAY VAN', 'GMC-SAVANA', 'CADILLAC-COMMERCIAL CHASSIS', 'FORD-TRANSIT', 'GMC-V15 CONVENTIONAL', 'GMC-V25 CONVENTIONAL', ' GMC-V35 CONVENTIONAL', 'HONDA-CBR300', 'HONDA-CBR650', 'HONDA-MRT260E', 'CHEVROLET-ME6500', 'CHEVROLET-ME6000', 'HONDA-CTX1300', 'SUZUKI-GW250', 'SUZUKI-RMX450Z', 'SUZUKI-UH200') AND pk_body_style_desc IN ('Sedan', 'Hatchback', 'Coupe', 'Sport Utility Vehicle', 'Convertible', 'Wagon', 'Sport', 'Pickup', 'Limousine', 'Van Passenger') AND odom BETWEEN 0 AND 170000 AND insert BETWEEN TO_DATE('06/01/2014', 'MM/DD/YYYY') AND TO_DATE('08/01/2014', 'MM/DD/YYYY') AND times_mailed = 0 AND client_dnm_rec = 0 AND capital_dnm = 0 AND outdated = 0 AND killable = 0 AND invalid_vin = 0 GROUP BY state, vehicle_date;