{"current_page":1,"data":[{"id":12224065,"change_date":"2026-06-23 21:39:00","inspection_id":"88181980","dot_number":"299959","report_state":"CT","report_number":"3082002075","insp_date":"2026-06-18 00:00:00","insp_start_time":"1050","insp_end_time":"1145","registration_date":"2026-06-23 00:00:00","region":"ES","ci_status_code":"C","location":"148","location_desc":"CT","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"44551","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3573076","transaction_code":"C","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:40.000000Z","updated_at":"2026-06-27T09:39:13.000000Z","inspection_violations":[{"id":21275818,"change_date":"2026-06-23 21:39:00","inspection_id":"88181980","insp_violation_id":"275076170","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"214239472","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:08.000000Z","updated_at":"2026-06-27T09:59:33.000000Z","normalized_code":"3939ALIL"},{"id":21275819,"change_date":"2026-06-23 21:39:00","inspection_id":"88181980","insp_violation_id":"275076171","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"214239472","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:08.000000Z","updated_at":"2026-06-27T09:59:33.000000Z","normalized_code":"3939ALCL"},{"id":21275820,"change_date":"2026-06-23 21:39:00","inspection_id":"88181980","insp_violation_id":"275076172","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214239472","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:08.000000Z","updated_at":"2026-06-27T09:59:33.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21229371,"change_date":"2026-06-23 21:39:00","inspection_id":"88181980","insp_unit_id":"214239472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5889","insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUMML7SL505881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:31.000000Z","updated_at":"2026-06-27T09:14:26.000000Z"}]},{"id":12201849,"change_date":"2026-06-16 21:40:00","inspection_id":"88158646","dot_number":"299959","report_state":"CT","report_number":"3084000370","insp_date":"2026-06-16 00:00:00","insp_start_time":"1434","insp_end_time":"1444","registration_date":null,"region":"ES","ci_status_code":"C","location":"025","location_desc":"CT","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3556534","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:41.000000Z","updated_at":"2026-06-27T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21192880,"change_date":"2026-06-16 21:40:00","inspection_id":"88158646","insp_unit_id":"214132205","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"DS2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUMMLXSS001396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:19.000000Z","updated_at":"2026-06-27T09:02:03.000000Z"}]},{"id":11997096,"change_date":"2026-05-22 21:38:00","inspection_id":"87935374","dot_number":"299959","report_state":"NJ","report_number":"SPPFI03975","insp_date":"2026-05-22 00:00:00","insp_start_time":"1006","insp_end_time":"1033","registration_date":null,"region":"ES","ci_status_code":"C","location":"1412","location_desc":"NJ","county_code_state":"NJ","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3385528","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:17.000000Z","updated_at":"2026-06-02T09:32:33.000000Z","inspection_violations":[{"id":20872037,"change_date":"2026-05-22 21:38:00","inspection_id":"87935374","insp_violation_id":"274451062","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:00.000000Z","updated_at":"2026-06-02T09:44:51.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20855649,"change_date":"2026-05-22 21:38:00","inspection_id":"87935374","insp_unit_id":"213711323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"73952MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X5KM341499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:27.000000Z","updated_at":"2026-06-02T09:05:52.000000Z"}]},{"id":11947274,"change_date":"2026-05-18 21:39:00","inspection_id":"87882731","dot_number":"299959","report_state":"CT","report_number":"3082001993","insp_date":"2026-05-14 00:00:00","insp_start_time":"1428","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"034S","location_desc":"DANBURY SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"460432","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"772943","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-05-18 21:39:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-18 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:01.000000Z","updated_at":"2026-05-29T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20774745,"change_date":"2026-05-18 21:39:00","inspection_id":"87882731","insp_unit_id":"213613435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"13","insp_unit_license":"BK20859","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1D9PS205980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:15.000000Z","updated_at":"2026-05-29T09:02:12.000000Z"}]},{"id":11738383,"change_date":"2026-04-24 21:40:00","inspection_id":"87666903","dot_number":"299959","report_state":"US","report_number":"1972000082","insp_date":"2026-04-21 00:00:00","insp_start_time":"1056","insp_end_time":"1113","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GREENWICH TOWNSHIP NJ","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3206456","transaction_code":"A","transaction_date":"2026-04-24 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-04-24 21:40:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-24 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:18.000000Z","updated_at":"2026-05-05T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20424902,"change_date":"2026-04-24 21:40:00","inspection_id":"87666903","insp_unit_id":"213195807","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"73952MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X5KM341499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:10.000000Z","updated_at":"2026-05-05T09:02:56.000000Z"}]},{"id":11481289,"change_date":"2026-04-06 21:37:00","inspection_id":"87400404","dot_number":"299959","report_state":"CT","report_number":"0613001761","insp_date":"2026-03-26 00:00:00","insp_start_time":"0748","insp_end_time":"0805","registration_date":"2026-04-06 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"I-84 WB EXIT 25","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"768720","transaction_code":"C","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-03-26 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-26 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:53:53.000000Z","updated_at":"2026-04-17T09:31:10.000000Z","inspection_violations":[{"id":19562651,"change_date":"2026-04-06 21:37:00","inspection_id":"87400404","insp_violation_id":"272882895","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"212555866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-04-18T10:36:27.000000Z","normalized_code":"3939ALHLI"},{"id":19562652,"change_date":"2026-04-06 21:37:00","inspection_id":"87400404","insp_violation_id":"272882896","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"212555866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-04-18T10:36:27.000000Z","normalized_code":"3939ALCL"},{"id":19562653,"change_date":"2026-04-06 21:37:00","inspection_id":"87400404","insp_violation_id":"272882897","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"212555866","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-04-18T10:36:27.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19833243,"change_date":"2026-04-06 21:37:00","inspection_id":"87400404","insp_unit_id":"212555866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"DF2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2MDBAA0NS002394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:49.000000Z","updated_at":"2026-04-18T09:12:27.000000Z"}]},{"id":10841375,"change_date":"2026-01-28 21:37:00","inspection_id":"86869846","dot_number":"299959","report_state":"CT","report_number":"3029003600","insp_date":"2026-01-23 00:00:00","insp_start_time":"1119","insp_end_time":"1148","registration_date":"2026-01-28 00:00:00","region":"ET","ci_status_code":"C","location":"106","location_desc":"OLD SAYBROOK","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"29100","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"764187","transaction_code":"C","transaction_date":"2026-01-23 00:00:00","upload_date":"2026-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-01-23 21:38:00","snet_input_date":"2026-01-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-01-23 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-26T10:37:19.000000Z","updated_at":"2026-02-08T10:30:57.000000Z","inspection_violations":[{"id":18196544,"change_date":"2026-01-28 21:37:00","inspection_id":"86869846","insp_violation_id":"271459311","seq_no":"1","part_no":"393","part_no_section":"71H10-CDDSDM","insp_viol_unit":"2","insp_unit_id":"211316261","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V137705-3","created_at":"2026-01-31T10:49:12.000000Z","updated_at":"2026-02-08T10:37:50.000000Z","normalized_code":"39371H10CDDSDM"}],"inspection_per_units":[{"id":18271802,"change_date":"2026-01-28 21:37:00","inspection_id":"86869846","insp_unit_id":"211316260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"6437","insp_unit_license":"DN2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTEUMML3SS296437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:10:57.000000Z","updated_at":"2026-02-08T10:04:08.000000Z"},{"id":18271803,"change_date":"2026-01-28 21:37:00","inspection_id":"86869846","insp_unit_id":"211316261","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"NISSA","insp_unit_company":"---","insp_unit_license":"-----","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1N4AL2EP4DC131763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:10:57.000000Z","updated_at":"2026-02-08T10:04:08.000000Z"}]},{"id":10829294,"change_date":"2026-01-29 21:38:00","inspection_id":"86857237","dot_number":"299959","report_state":"NY","report_number":"D808900062","insp_date":"2026-01-15 00:00:00","insp_start_time":"1341","insp_end_time":"1445","registration_date":"2026-01-29 00:00:00","region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2797106","transaction_code":"C","transaction_date":"2026-01-21 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2026-01-22 21:38:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-22 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:36:41.000000Z","updated_at":"2026-02-10T10:30:20.000000Z","inspection_violations":[{"id":18215303,"change_date":"2026-01-29 21:38:00","inspection_id":"86857237","insp_violation_id":"271489513","seq_no":"1","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"1","insp_unit_id":"211341888","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:24.000000Z","updated_at":"2026-02-10T10:38:12.000000Z","normalized_code":"393100CC"},{"id":18215304,"change_date":"2026-01-29 21:38:00","inspection_id":"86857237","insp_violation_id":"271489514","seq_no":"2","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"1","insp_unit_id":"211341888","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:24.000000Z","updated_at":"2026-02-10T10:38:12.000000Z","normalized_code":"393100CC"},{"id":18215305,"change_date":"2026-01-29 21:38:00","inspection_id":"86857237","insp_violation_id":"271489515","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"211341888","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:24.000000Z","updated_at":"2026-02-10T10:38:12.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":18289638,"change_date":"2026-01-29 21:38:00","inspection_id":"86857237","insp_unit_id":"211341888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"13","insp_unit_license":"BK20859","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1D9PS205980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:38.000000Z","updated_at":"2026-02-09T10:01:19.000000Z"}]},{"id":10282510,"change_date":"2025-12-09 21:38:00","inspection_id":"86407269","dot_number":"299959","report_state":"CT","report_number":"3019006819","insp_date":"2025-11-25 00:00:00","insp_start_time":"0717","insp_end_time":"0736","registration_date":"2025-12-09 00:00:00","region":"ET","ci_status_code":"C","location":"014","location_desc":"BRANFORD","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-25 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"758830","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-11-25 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-25 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-28T10:31:44.000000Z","updated_at":"2025-12-13T10:30:07.000000Z","inspection_violations":[{"id":17389752,"change_date":"2025-12-09 21:38:00","inspection_id":"86407269","insp_violation_id":"270543764","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V137161-5","created_at":"2025-12-12T10:32:24.000000Z","updated_at":"2025-12-13T10:30:11.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":17356002,"change_date":"2025-12-09 21:38:00","inspection_id":"86407269","insp_unit_id":"210487230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUMML7SL505881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:21.000000Z","updated_at":"2025-12-13T10:00:05.000000Z"}]},{"id":10185940,"change_date":"2025-11-13 21:39:00","inspection_id":"86305948","dot_number":"299959","report_state":"NY","report_number":"M005700226","insp_date":"2025-11-06 00:00:00","insp_start_time":"1223","insp_end_time":"1238","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2532542","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-11-13 21:39:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:48.000000Z","updated_at":"2025-11-17T10:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16966440,"change_date":"2025-11-13 21:39:00","inspection_id":"86305948","insp_unit_id":"209994671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"AE27232","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CYEGXJF142321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:19.000000Z","updated_at":"2025-11-17T10:00:13.000000Z"}]},{"id":10091220,"change_date":"2025-11-04 21:40:00","inspection_id":"86206290","dot_number":"299959","report_state":"MA","report_number":"CW00004097","insp_date":"2025-10-30 00:00:00","insp_start_time":"1531","insp_end_time":"1550","registration_date":"2025-11-04 00:00:00","region":"ET","ci_status_code":"C","location":"151S","location_desc":"S-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"532743","transaction_code":"C","transaction_date":"2025-10-31 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2025-10-31 21:40:00","snet_input_date":"2025-10-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-31 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:51.000000Z","updated_at":"2025-11-08T10:30:42.000000Z","inspection_violations":[{"id":16767787,"change_date":"2025-11-04 21:40:00","inspection_id":"86206290","insp_violation_id":"269719322","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:29.000000Z","updated_at":"2025-11-08T10:31:04.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16827171,"change_date":"2025-11-04 21:40:00","inspection_id":"86206290","insp_unit_id":"209826293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE27245","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HA3GSCG1JN003034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:32.000000Z","updated_at":"2025-11-08T10:00:55.000000Z"}]},{"id":10050497,"change_date":"2025-10-30 21:41:00","inspection_id":"86163196","dot_number":"299959","report_state":"CT","report_number":"0103000174","insp_date":"2025-10-28 00:00:00","insp_start_time":"1400","insp_end_time":"1424","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"756265","transaction_code":"C","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-10-28 21:39:00","snet_input_date":"2025-10-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-28 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:01:48.000000Z","updated_at":"2025-11-03T11:00:05.000000Z","inspection_violations":[{"id":16680790,"change_date":"2025-10-30 21:41:00","inspection_id":"86163196","insp_violation_id":"269606061","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:38.000000Z","updated_at":"2025-11-03T11:15:11.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16742564,"change_date":"2025-10-30 21:41:00","inspection_id":"86163196","insp_unit_id":"209729783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5889","insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUMML7SL505881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:08.000000Z"},{"id":16742565,"change_date":"2025-10-30 21:41:00","inspection_id":"86163196","insp_unit_id":"209729784","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1L1FM88WX5Y621631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:08.000000Z"}]},{"id":9957574,"change_date":"2025-11-14 21:39:00","inspection_id":"86065493","dot_number":"299959","report_state":"NY","report_number":"D808501302","insp_date":"2025-10-15 00:00:00","insp_start_time":"1150","insp_end_time":"1230","registration_date":"2025-11-13 00:00:00","region":"ED","ci_status_code":"C","location":"80923M","location_desc":"HARRIMAN NY","county_code_state":"NY","county_code":"071","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2420567","transaction_code":"C","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-10-16 21:39:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-16 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:33.000000Z","updated_at":"2025-11-18T10:30:05.000000Z","inspection_violations":[{"id":16933862,"change_date":"2025-11-14 21:39:00","inspection_id":"86065493","insp_violation_id":"269943947","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210020578","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:31:39.000000Z","updated_at":"2025-11-18T10:30:09.000000Z","normalized_code":"39021TB1MC"},{"id":16933863,"change_date":"2025-11-14 21:39:00","inspection_id":"86065493","insp_violation_id":"269943948","seq_no":"2","part_no":"393","part_no_section":"209D-STBSP","insp_viol_unit":"1","insp_unit_id":"210020578","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-17T10:31:39.000000Z","updated_at":"2025-11-18T10:30:09.000000Z","normalized_code":"393209DSTBSP"},{"id":16933864,"change_date":"2025-11-14 21:39:00","inspection_id":"86065493","insp_violation_id":"269943949","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210020578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:31:39.000000Z","updated_at":"2025-11-18T10:30:09.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16979929,"change_date":"2025-11-14 21:39:00","inspection_id":"86065493","insp_unit_id":"210020578","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"AE27233","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CYEG9JF141239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:12.000000Z","updated_at":"2025-11-18T10:00:06.000000Z"}]},{"id":9859481,"change_date":"2025-10-06 21:39:00","inspection_id":"85961817","dot_number":"299959","report_state":"CT","report_number":"3132005868","insp_date":"2025-10-03 00:00:00","insp_start_time":"1831","insp_end_time":"1853","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"754185","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-10-06 21:39:00","snet_input_date":"2025-10-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-10-06 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:24.000000Z","updated_at":"2025-10-10T10:00:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16351612,"change_date":"2025-10-06 21:39:00","inspection_id":"85961817","insp_unit_id":"209305839","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"Y","insp_unit_decal_number":"35803501","created_at":"2025-10-09T09:45:33.000000Z","updated_at":"2025-10-10T09:45:09.000000Z"}]},{"id":9762052,"change_date":"2025-09-30 21:38:00","inspection_id":"85859500","dot_number":"299959","report_state":"CT","report_number":"0704000270","insp_date":"2025-09-24 00:00:00","insp_start_time":"1141","insp_end_time":"1210","registration_date":"2025-09-30 00:00:00","region":"ET","ci_status_code":"C","location":"T034","location_desc":"DANBURY WEIGH STATION","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CHUCK AND EDDIES","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"753070","transaction_code":"C","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-09-24 21:41:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-09-24 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:04.000000Z","updated_at":"2025-10-04T10:00:05.000000Z","inspection_violations":[{"id":16142259,"change_date":"2025-09-30 21:38:00","inspection_id":"85859500","insp_violation_id":"268994968","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209211141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-03T10:17:39.000000Z","updated_at":"2025-10-04T10:15:10.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16263758,"change_date":"2025-09-30 21:38:00","inspection_id":"85859500","insp_unit_id":"209211141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE27233","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CYEG9JF141239","insp_unit_decal":"Y","insp_unit_decal_number":"35534092","created_at":"2025-10-03T09:47:08.000000Z","updated_at":"2025-10-04T09:45:09.000000Z"}]},{"id":9711620,"change_date":"2025-09-23 21:41:00","inspection_id":"85806963","dot_number":"299959","report_state":"CT","report_number":"3019006670","insp_date":"2025-09-18 00:00:00","insp_start_time":"1336","insp_end_time":"1345","registration_date":"2025-09-23 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"752561","transaction_code":"C","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-09-18 21:41:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-09-18 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:57.000000Z","updated_at":"2025-09-26T10:00:07.000000Z","inspection_violations":[{"id":16015200,"change_date":"2025-09-23 21:41:00","inspection_id":"85806963","insp_violation_id":"268852430","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:27.000000Z","updated_at":"2025-09-27T10:15:06.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16146061,"change_date":"2025-09-23 21:41:00","inspection_id":"85806963","insp_unit_id":"209084202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DM2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X0HM159279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:45:58.000000Z","updated_at":"2025-09-27T09:45:03.000000Z"}]},{"id":9713344,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","dot_number":"299959","report_state":"NY","report_number":"SPK4020234","insp_date":"2025-09-10 00:00:00","insp_start_time":"1240","insp_end_time":"1330","registration_date":"2025-09-18 00:00:00","region":"ED","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2284771","transaction_code":"C","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-09-17 21:39:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:16.000000Z","updated_at":"2025-09-23T10:02:16.000000Z","inspection_violations":[{"id":15946333,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","insp_violation_id":"268776014","seq_no":"1","part_no":"395","part_no_section":"22H2-ELDNISDT","insp_viol_unit":"1","insp_unit_id":"209018572","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:29.000000Z","updated_at":"2025-09-22T10:17:29.000000Z","normalized_code":"39522H2ELDNISDT"},{"id":15946334,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","insp_violation_id":"268776015","seq_no":"2","part_no":"395","part_no_section":"34A1-ELDDFN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:29.000000Z","updated_at":"2025-09-22T10:17:29.000000Z","normalized_code":"39534A1ELDDFN"},{"id":15946335,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","insp_violation_id":"268776016","seq_no":"3","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:29.000000Z","updated_at":"2025-09-22T10:17:29.000000Z","normalized_code":"39524"},{"id":15946336,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","insp_violation_id":"268776017","seq_no":"4","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:29.000000Z","updated_at":"2025-09-22T10:17:29.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16083988,"change_date":"2025-09-18 21:42:00","inspection_id":"85794568","insp_unit_id":"209018572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"18866PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBABXMS070175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:52.000000Z","updated_at":"2025-09-22T09:45:36.000000Z"}]},{"id":9539293,"change_date":"2025-08-29 21:39:00","inspection_id":"85626189","dot_number":"299959","report_state":"CT","report_number":"3132005786","insp_date":"2025-08-28 00:00:00","insp_start_time":"1259","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"750492","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-08-29 21:39:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-08-29 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:21.000000Z","updated_at":"2025-09-06T10:42:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15744470,"change_date":"2025-08-29 21:39:00","inspection_id":"85626189","insp_unit_id":"208646556","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DM2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X0HM159279","insp_unit_decal":"Y","insp_unit_decal_number":"35534904","created_at":"2025-09-09T09:46:44.000000Z","updated_at":"2025-09-09T09:46:44.000000Z"}]},{"id":9544853,"change_date":"2025-09-11 21:41:00","inspection_id":"85632116","dot_number":"299959","report_state":"NY","report_number":"M600500099","insp_date":"2025-08-28 00:00:00","insp_start_time":"1300","insp_end_time":"1332","registration_date":"2025-09-11 00:00:00","region":"ED","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2198379","transaction_code":"C","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:30.000000Z","updated_at":"2025-09-16T10:46:27.000000Z","inspection_violations":[{"id":15801270,"change_date":"2025-09-11 21:41:00","inspection_id":"85632116","insp_violation_id":"268604297","seq_no":"1","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"1","insp_unit_id":"208868577","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:43.000000Z","updated_at":"2025-09-14T11:56:43.000000Z","normalized_code":"393100CC"}],"inspection_per_units":[{"id":15944571,"change_date":"2025-09-11 21:41:00","inspection_id":"85632116","insp_unit_id":"208868577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:31.000000Z","updated_at":"2025-09-15T09:52:50.000000Z"}]},{"id":9291413,"change_date":"2025-07-31 21:40:00","inspection_id":"85365481","dot_number":"299959","report_state":"CT","report_number":"3132005757","insp_date":"2025-07-31 00:00:00","insp_start_time":"0836","insp_end_time":"0848","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"747586","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-07-31 21:40:00","snet_input_date":"2025-07-31 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-07-31 21:40:00","insp_carrier_name":"OLD TURNPIKE","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:22.000000Z","updated_at":"2025-08-04T10:01:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15298666,"change_date":"2025-07-31 21:40:00","inspection_id":"85365481","insp_unit_id":"208165336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"DF2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2MDBAA0NS002394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-03T09:46:16.000000Z","updated_at":"2025-08-04T09:45:07.000000Z"}]},{"id":9264466,"change_date":"2025-07-28 21:39:00","inspection_id":"85337005","dot_number":"299959","report_state":"MA","report_number":"CP00005466","insp_date":"2025-07-28 00:00:00","insp_start_time":"1550","insp_end_time":"1602","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"524138","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2025-07-28 21:39:00","snet_input_date":"2025-07-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-28 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:26.000000Z","updated_at":"2025-08-01T10:41:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15247482,"change_date":"2025-07-28 21:39:00","inspection_id":"85337005","insp_unit_id":"208110918","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:30.000000Z","updated_at":"2025-08-01T09:45:30.000000Z"}]},{"id":9087766,"change_date":"2025-07-08 21:38:00","inspection_id":"85151099","dot_number":"299959","report_state":"US","report_number":"0641000098","insp_date":"2025-07-08 00:00:00","insp_start_time":"1109","insp_end_time":"1157","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BLOOMSBURY NJ","county_code_state":"NJ","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1964492","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-07-08 21:38:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:48.000000Z","updated_at":"2025-07-12T10:44:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14914332,"change_date":"2025-07-08 21:38:00","inspection_id":"85151099","insp_unit_id":"207748532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1549","insp_unit_license":"65997PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT0J4S54946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-11T09:46:34.000000Z","updated_at":"2025-07-12T09:45:24.000000Z"}]},{"id":8863813,"change_date":"2025-09-11 21:41:00","inspection_id":"84914385","dot_number":"299959","report_state":"PA","report_number":"M609516077","insp_date":"2025-06-09 00:00:00","insp_start_time":"1102","insp_end_time":"1200","registration_date":"2025-09-10 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I-78 E 354 FEET WEST OF MOR","county_code_state":"PA","county_code":"095","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2522611","transaction_code":"C","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-06-10 21:41:00","snet_input_date":"2025-06-09 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-06-10 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:46.000000Z","updated_at":"2025-09-16T10:46:22.000000Z","inspection_violations":[{"id":15798926,"change_date":"2025-09-11 21:41:00","inspection_id":"84914385","insp_violation_id":"268614562","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"208877552","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1295956-4","created_at":"2025-09-14T11:56:39.000000Z","updated_at":"2025-09-14T11:56:39.000000Z","normalized_code":"39021TCMC"},{"id":15798927,"change_date":"2025-09-11 21:41:00","inspection_id":"84914385","insp_violation_id":"268614563","seq_no":"2","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:39.000000Z","updated_at":"2025-09-14T11:56:39.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":15943439,"change_date":"2025-09-11 21:41:00","inspection_id":"84914385","insp_unit_id":"208877552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1834","insp_unit_license":"18866PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBABXMS070175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:30.000000Z","updated_at":"2025-09-15T09:52:45.000000Z"}]},{"id":8830851,"change_date":"2025-09-10 21:39:00","inspection_id":"84879351","dot_number":"299959","report_state":"CT","report_number":"3017001902","insp_date":"2025-06-06 00:00:00","insp_start_time":"1314","insp_end_time":"1340","registration_date":"2025-09-10 00:00:00","region":"ET","ci_status_code":"C","location":"054","location_desc":"GLASTONBURY","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"742353","transaction_code":"C","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-06-06 21:39:00","snet_input_date":"2025-06-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-06-06 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:10.000000Z","updated_at":"2025-09-13T10:47:23.000000Z","inspection_violations":[{"id":15769112,"change_date":"2025-09-10 21:39:00","inspection_id":"84879351","insp_violation_id":"268566063","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V134201-6","created_at":"2025-09-13T10:50:15.000000Z","updated_at":"2025-09-14T11:54:44.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":15921033,"change_date":"2025-09-10 21:39:00","inspection_id":"84879351","insp_unit_id":"208837850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5707","insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X3HM165707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:12.000000Z","updated_at":"2025-09-13T10:00:12.000000Z"}]},{"id":8491137,"change_date":"2025-04-29 21:48:00","inspection_id":"84520820","dot_number":"299959","report_state":"NJ","report_number":"SPNVI01551","insp_date":"2025-04-28 00:00:00","insp_start_time":"1100","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH SCALE","county_code_state":"NJ","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281994","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:46.000000Z","updated_at":"2025-05-02T13:50:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13800127,"change_date":"2025-04-29 21:48:00","inspection_id":"84520820","insp_unit_id":"206533961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"60611A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"5PVNV8JV4H4S57148","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:14:26.000000Z","updated_at":"2025-05-03T10:05:41.000000Z"}]},{"id":8465363,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","dot_number":"299959","report_state":"CT","report_number":"3082001390","insp_date":"2025-04-25 00:00:00","insp_start_time":"0928","insp_end_time":"1030","registration_date":"2025-05-02 00:00:00","region":"ET","ci_status_code":"C","location":"101","location_desc":"NORTH HAVEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"31323","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"29000","viol_total":"7","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738404","transaction_code":"C","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-04-25 21:35:00","snet_input_date":"2025-04-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-25 21:35:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:13:45.000000Z","updated_at":"2025-05-06T10:03:47.000000Z","inspection_violations":[{"id":13503772,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962963","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206604596","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"39395A4EEUS"},{"id":13503773,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962964","seq_no":"2","part_no":"393","part_no_section":"71H10-CDDSDNS","insp_viol_unit":"1","insp_unit_id":"206604596","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V133458-5","created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"39371H10CDDSDNS"},{"id":13503774,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962965","seq_no":"3","part_no":"393","part_no_section":"128B-CLWV","insp_viol_unit":"1","insp_unit_id":"206604596","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V133458-5","created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"393128BCLWV"},{"id":13503775,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962966","seq_no":"4","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"206604597","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"3939ALTSI"},{"id":13503776,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962967","seq_no":"5","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"206604597","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"3939ALSLIWR"},{"id":13503777,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962968","seq_no":"6","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"2","insp_unit_id":"206604597","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"3939ALHWS"},{"id":13503778,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_violation_id":"265962969","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206604597","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V133458-5","created_at":"2025-05-04T10:47:46.000000Z","updated_at":"2025-05-06T10:19:22.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13864773,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_unit_id":"206604596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1703","insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6XXHM165705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T09:58:26.000000Z","updated_at":"2025-05-07T09:49:01.000000Z"},{"id":13864774,"change_date":"2025-05-02 21:40:00","inspection_id":"84493769","insp_unit_id":"206604597","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"HONDA","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HGCM56485A018807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T09:58:26.000000Z","updated_at":"2025-05-07T09:49:01.000000Z"}]},{"id":8193040,"change_date":"2025-03-24 21:40:00","inspection_id":"84206986","dot_number":"299959","report_state":"NJ","report_number":"SPTFI00256","insp_date":"2025-03-21 00:00:00","insp_start_time":"1050","insp_end_time":"1109","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH WEIGHT STATION EB","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1274991","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-03-24 21:40:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-03-24 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:27.000000Z","updated_at":"2025-03-28T10:13:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13245858,"change_date":"2025-03-24 21:40:00","inspection_id":"84206986","insp_unit_id":"205955288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"18866PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBABXMS070175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T09:55:29.000000Z","updated_at":"2025-03-28T10:02:18.000000Z"}]},{"id":8169140,"change_date":"2025-03-20 21:42:00","inspection_id":"84181756","dot_number":"299959","report_state":"PA","report_number":"E903507817","insp_date":"2025-03-19 00:00:00","insp_start_time":"0550","insp_end_time":"0704","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"I-78 AT EXIT 23","county_code_state":"PA","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CHUCK & EDDIES","shipping_paper_number":"0034885883","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2503076","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-03-20 21:42:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:52:50.000000Z","updated_at":"2025-03-24T10:26:21.000000Z","inspection_violations":[{"id":12798309,"change_date":"2025-03-20 21:42:00","inspection_id":"84181756","insp_violation_id":"265163168","seq_no":"1","part_no":"393","part_no_section":"9B-LHLOWR","insp_viol_unit":"1","insp_unit_id":"205909962","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:09:26.000000Z","updated_at":"2025-03-23T11:42:28.000000Z","normalized_code":"3939BLHLOWR"},{"id":12798310,"change_date":"2025-03-20 21:42:00","inspection_id":"84181756","insp_violation_id":"265163169","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"205909962","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:09:26.000000Z","updated_at":"2025-03-23T11:42:28.000000Z","normalized_code":"3922SLLSIV"},{"id":12798311,"change_date":"2025-03-20 21:42:00","inspection_id":"84181756","insp_violation_id":"265163170","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205909962","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0920394-6","created_at":"2025-03-22T11:09:26.000000Z","updated_at":"2025-03-23T11:42:28.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":13203191,"change_date":"2025-03-20 21:42:00","inspection_id":"84181756","insp_unit_id":"205909962","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1834","insp_unit_license":"18866PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBABXMS070175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:17:04.000000Z","updated_at":"2025-03-24T10:05:54.000000Z"}]},{"id":8015485,"change_date":"2025-03-04 21:38:00","inspection_id":"84019969","dot_number":"299959","report_state":"CT","report_number":"3010004063","insp_date":"2025-03-03 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"152","location_desc":"WATERFORD N\/B SCALE","county_code_state":"CT","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"733787","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-03-04 21:38:00","snet_input_date":"2025-03-03 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-04 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:32.000000Z","updated_at":"2025-03-17T21:04:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12940488,"change_date":"2025-03-04 21:38:00","inspection_id":"84019969","insp_unit_id":"205604982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1705","insp_unit_license":"DE2592","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACVFD4LHKU8684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:58.000000Z","updated_at":"2025-03-17T23:57:58.000000Z"}]},{"id":7990744,"change_date":"2025-02-28 21:41:00","inspection_id":"83994036","dot_number":"299959","report_state":"MA","report_number":"DD00002136","insp_date":"2025-02-27 00:00:00","insp_start_time":"1610","insp_end_time":"1626","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF\/SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"510849","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:05.000000Z","updated_at":"2025-03-17T21:04:05.000000Z","inspection_violations":[{"id":12486752,"change_date":"2025-02-28 21:41:00","inspection_id":"83994036","insp_violation_id":"264760743","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"223700AD","created_at":"2025-03-17T22:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"3922SLLS4"},{"id":12486753,"change_date":"2025-02-28 21:41:00","inspection_id":"83994036","insp_violation_id":"264760744","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12900315,"change_date":"2025-02-28 21:41:00","inspection_id":"83994036","insp_unit_id":"205558075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"14","insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:31.000000Z","updated_at":"2025-03-17T23:57:31.000000Z"}]},{"id":7960410,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","dot_number":"299959","report_state":"CT","report_number":"3070006771","insp_date":"2025-02-26 00:00:00","insp_start_time":"1305","insp_end_time":"1334","registration_date":"2025-10-01 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30435","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"733389","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-02-26 21:40:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-26 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-10-21T10:00:05.000000Z","inspection_violations":[{"id":16459352,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_violation_id":"269354705","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"209517117","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:34.000000Z","updated_at":"2025-10-21T10:15:06.000000Z","normalized_code":"3939ALTSI"},{"id":16459353,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_violation_id":"269354706","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"209517117","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:34.000000Z","updated_at":"2025-10-21T10:15:06.000000Z","normalized_code":"3939ALTSI"},{"id":16459354,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_violation_id":"269354707","seq_no":"3","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"209517117","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V132587-2","created_at":"2025-10-20T10:17:34.000000Z","updated_at":"2025-10-21T10:15:06.000000Z","normalized_code":"3939ALSLIWR"},{"id":16459355,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_violation_id":"269354708","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209517117","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:34.000000Z","updated_at":"2025-10-21T10:15:06.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16546292,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_unit_id":"209517116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DB2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X6HM170139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:46:58.000000Z","updated_at":"2025-10-21T09:45:05.000000Z"},{"id":16546293,"change_date":"2025-10-17 21:38:00","inspection_id":"83962119","insp_unit_id":"209517117","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"SUB","insp_unit_company":null,"insp_unit_license":"DB2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4S4BP61C187300502","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:46:58.000000Z","updated_at":"2025-10-21T09:45:05.000000Z"}]},{"id":7949734,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","dot_number":"299959","report_state":"NY","report_number":"M608000063","insp_date":"2025-02-18 00:00:00","insp_start_time":"1000","insp_end_time":"1109","registration_date":null,"region":"ES","ci_status_code":"C","location":"80789M","location_desc":"BREWSTER NY","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1397009","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2025-02-25 21:39:00","snet_input_date":"2025-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-25 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:16.000000Z","updated_at":"2025-03-17T21:03:16.000000Z","inspection_violations":[{"id":12421000,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","insp_violation_id":"264675260","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"39141AMCPC"},{"id":12421001,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","insp_violation_id":"264675261","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"205477731","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"3939ALSLI"},{"id":12421002,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","insp_violation_id":"264675262","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205477731","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"39375A3TAOL"},{"id":12421003,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","insp_violation_id":"264675263","seq_no":"4","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"205477731","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:43.000000Z","updated_at":"2025-03-17T22:06:43.000000Z","normalized_code":"39021TCMC"}],"inspection_per_units":[{"id":12833103,"change_date":"2025-02-25 21:39:00","inspection_id":"83950981","insp_unit_id":"205477731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"BA85352","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B6LS804876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:45.000000Z","updated_at":"2025-03-17T23:56:45.000000Z"}]},{"id":7443416,"change_date":"2024-12-18 21:40:00","inspection_id":"83419307","dot_number":"299959","report_state":"CT","report_number":"3029002739","insp_date":"2024-12-18 00:00:00","insp_start_time":"0925","insp_end_time":"0937","registration_date":null,"region":"ET","ci_status_code":"C","location":"083","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"727066","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:31.000000Z","updated_at":"2025-03-17T20:51:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12007972,"change_date":"2024-12-18 21:40:00","inspection_id":"83419307","insp_unit_id":"204442398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5951","insp_unit_license":"DN2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ6X5KM241255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"}]},{"id":7288172,"change_date":"2024-12-03 21:39:00","inspection_id":"83255970","dot_number":"299959","report_state":"CT","report_number":"3029002685","insp_date":"2024-11-27 00:00:00","insp_start_time":"1113","insp_end_time":"1156","registration_date":"2024-12-03 00:00:00","region":"ET","ci_status_code":"C","location":"148","location_desc":"WALLINGFORD","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31650","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"725082","transaction_code":"C","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:09.000000Z","updated_at":"2025-03-17T20:48:09.000000Z","inspection_violations":[{"id":11395807,"change_date":"2024-12-03 21:39:00","inspection_id":"83255970","insp_violation_id":"263185463","seq_no":"1","part_no":"393","part_no_section":"71H10-CDDSDM","insp_viol_unit":"2","insp_unit_id":"204143474","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V131169-5","created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"39371H10CDDSDM"},{"id":11395808,"change_date":"2024-12-03 21:39:00","inspection_id":"83255970","insp_violation_id":"263185464","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:19.000000Z","updated_at":"2025-03-17T22:01:19.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":11756169,"change_date":"2024-12-03 21:39:00","inspection_id":"83255970","insp_unit_id":"204143473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5951","insp_unit_license":"DN2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ6X5KM241255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:51.000000Z","updated_at":"2025-03-17T23:44:51.000000Z"},{"id":11756170,"change_date":"2024-12-03 21:39:00","inspection_id":"83255970","insp_unit_id":"204143474","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"DN2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2FAFP71W27X127433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:51.000000Z","updated_at":"2025-03-17T23:44:51.000000Z"}]},{"id":7288217,"change_date":"2025-10-30 21:41:00","inspection_id":"83256018","dot_number":"299959","report_state":"CT","report_number":"3070006499","insp_date":"2024-11-27 00:00:00","insp_start_time":"1422","insp_end_time":"1435","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"725096","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:09.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679990,"change_date":"2025-10-30 21:41:00","inspection_id":"83256018","insp_violation_id":"269606253","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16742219,"change_date":"2025-10-30 21:41:00","inspection_id":"83256018","insp_unit_id":"209729875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DB2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X6HM170139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":6811904,"change_date":"2025-09-04 21:40:00","inspection_id":"82750957","dot_number":"299959","report_state":"CT","report_number":"0997000827","insp_date":"2024-09-25 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":"2025-09-04 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30278","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"718969","transaction_code":"C","transaction_date":"2024-09-25 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-09-25 21:40:00","snet_input_date":"2024-09-25 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-25 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:13.000000Z","updated_at":"2025-09-10T10:45:15.000000Z","inspection_violations":[{"id":15662713,"change_date":"2025-09-04 21:40:00","inspection_id":"82750957","insp_violation_id":"268446977","seq_no":"1","part_no":"392","part_no_section":"2LV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Z457497-4","created_at":"2025-09-09T10:42:38.000000Z","updated_at":"2025-09-10T10:46:20.000000Z","normalized_code":"3922LV"}],"inspection_per_units":[{"id":15827423,"change_date":"2025-09-04 21:40:00","inspection_id":"82750957","insp_unit_id":"208737484","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5707","insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X3HM165707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:03.000000Z"},{"id":15827424,"change_date":"2025-09-04 21:40:00","inspection_id":"82750957","insp_unit_id":"208737485","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"VW","insp_unit_company":null,"insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"WVWEV71K08W148187","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:03.000000Z"}]},{"id":6567447,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","dot_number":"299959","report_state":"CT","report_number":"3019005652","insp_date":"2024-08-26 00:00:00","insp_start_time":"1248","insp_end_time":"1323","registration_date":"2024-10-04 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29770","viol_total":"7","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"716467","transaction_code":"C","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-08-27 21:41:00","snet_input_date":"2024-08-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-27 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:10.000000Z","updated_at":"2025-03-17T20:33:10.000000Z","inspection_violations":[{"id":10206433,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181946","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3922"},{"id":10206434,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181947","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3929"},{"id":10206435,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181948","seq_no":"3","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3928"},{"id":10206436,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181949","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203264594","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3939A"},{"id":10206437,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181950","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203264594","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39617C"},{"id":10206438,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181951","seq_no":"6","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"203264594","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39355C1"},{"id":10206439,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_violation_id":"262181952","seq_no":"7","part_no":"393","part_no_section":"71(h)(10)","insp_viol_unit":"2","insp_unit_id":"203264595","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V129615-5","created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39371H10"}],"inspection_per_units":[{"id":10587888,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_unit_id":"203264594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5707","insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X3HM165707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"},{"id":10587889,"change_date":"2024-10-04 21:39:00","inspection_id":"82490405","insp_unit_id":"203264595","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"NISSA","insp_unit_company":null,"insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3N1BC11E58L440216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:40.000000Z","updated_at":"2025-03-17T23:32:40.000000Z"}]},{"id":6475244,"change_date":"2024-08-15 21:42:00","inspection_id":"82392149","dot_number":"299959","report_state":"NJ","report_number":"SPRBI02021","insp_date":"2024-08-14 00:00:00","insp_start_time":"0830","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"000212","location_desc":"MEADOWLANDS 19W RAMP","county_code_state":"NJ","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CHUCK AND EDDIE'S AUTO PARTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229436","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-08-15 21:42:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-08-15 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:09.000000Z","updated_at":"2025-03-17T20:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10437139,"change_date":"2024-08-15 21:42:00","inspection_id":"82392149","insp_unit_id":"202406602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BK20859","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"54DCDW1D9PS205980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:09.000000Z","updated_at":"2025-03-17T23:31:09.000000Z"}]},{"id":6383738,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","dot_number":"299959","report_state":"CT","report_number":"3078002929","insp_date":"2024-08-05 00:00:00","insp_start_time":"1039","insp_end_time":"1229","registration_date":"2024-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"714616","transaction_code":"C","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-08-05 21:41:00","snet_input_date":"2024-08-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-05 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":9908169,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_violation_id":"261123689","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908170,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_violation_id":"261123690","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"39141A1"},{"id":9908171,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_violation_id":"261123691","seq_no":"3","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"V129297-2","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"39111B5"},{"id":9908172,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_violation_id":"261123692","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202330374","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V129265-5","created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3922"},{"id":9908173,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_violation_id":"261123693","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202330374","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10287591,"change_date":"2024-08-12 21:42:00","inspection_id":"82294439","insp_unit_id":"202330374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"L8000","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDUF5GY8BEC12736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:33.000000Z","updated_at":"2025-03-17T23:29:33.000000Z"}]},{"id":6058912,"change_date":"2024-06-24 21:42:00","inspection_id":"81946081","dot_number":"299959","report_state":"NY","report_number":"SPK0220845","insp_date":"2024-06-12 00:00:00","insp_start_time":"1444","insp_end_time":"1501","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2932081","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2024-06-24 21:42:00","snet_input_date":"2024-06-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:40.000000Z","updated_at":"2025-03-17T20:22:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9758473,"change_date":"2024-06-24 21:42:00","inspection_id":"81946081","insp_unit_id":"201552337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BK20859","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1D9PS205980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:04.000000Z","updated_at":"2025-03-17T23:24:04.000000Z"}]},{"id":5832523,"change_date":"2024-06-12 21:41:00","inspection_id":"81700642","dot_number":"299959","report_state":"CT","report_number":"3070006002","insp_date":"2024-05-24 00:00:00","insp_start_time":"1418","insp_end_time":"1435","registration_date":"2024-06-12 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"708598","transaction_code":"C","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-05-24 21:38:00","snet_input_date":"2024-05-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-24 21:38:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:17.000000Z","updated_at":"2025-03-17T20:18:17.000000Z","inspection_violations":[{"id":9037926,"change_date":"2024-06-12 21:41:00","inspection_id":"81700642","insp_violation_id":"260033983","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"201348213","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":9393395,"change_date":"2024-06-12 21:41:00","inspection_id":"81700642","insp_unit_id":"201348213","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DM2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X0HM159279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"}]},{"id":5817345,"change_date":"2024-05-22 21:40:00","inspection_id":"81684207","dot_number":"299959","report_state":"NJ","report_number":"SPRKI01103","insp_date":"2024-05-21 00:00:00","insp_start_time":"1103","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH EB","county_code_state":"NJ","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213957","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9368954,"change_date":"2024-05-22 21:40:00","inspection_id":"81684207","insp_unit_id":"201032737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"1517","insp_unit_license":"20104PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JV8J4S57868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"}]},{"id":5728235,"change_date":"2024-05-13 21:41:00","inspection_id":"81587496","dot_number":"299959","report_state":"MA","report_number":"CE00007026","insp_date":"2024-05-06 00:00:00","insp_start_time":"0902","insp_end_time":"0914","registration_date":null,"region":"ET","ci_status_code":"C","location":"048H","location_desc":"H-BRIMFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"491520","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:17.000000Z","updated_at":"2025-03-17T20:16:17.000000Z","inspection_violations":[{"id":8865329,"change_date":"2024-05-13 21:41:00","inspection_id":"81587496","insp_violation_id":"259457484","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9226391,"change_date":"2024-05-13 21:41:00","inspection_id":"81587496","insp_unit_id":"200851219","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE27245","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HA3GSCG1JN003034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"}]},{"id":5630796,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","dot_number":"299959","report_state":"MA","report_number":"CL00003749","insp_date":"2024-04-30 00:00:00","insp_start_time":"1103","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER OWNED","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"7","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"490922","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:18.000000Z","updated_at":"2025-03-17T20:14:18.000000Z","inspection_violations":[{"id":8706017,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219043","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"611111AC","created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39282A1"},{"id":8706018,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219044","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"611111AC","created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39216A"},{"id":8706019,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219045","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"611111AC","created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39141A"},{"id":8706020,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219046","seq_no":"4","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"611111AC","created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3927A"},{"id":8706021,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219047","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"200645465","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39021TB"},{"id":8706022,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219048","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200645465","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39395A"},{"id":8706023,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_violation_id":"259219049","seq_no":"7","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200645465","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":9070064,"change_date":"2024-04-30 21:41:00","inspection_id":"81481616","insp_unit_id":"200645465","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE27232","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CYEGXJF142321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:24.000000Z","updated_at":"2025-03-17T23:17:24.000000Z"}]},{"id":5630787,"change_date":"2024-04-30 21:41:00","inspection_id":"81481605","dot_number":"299959","report_state":"MA","report_number":"CW00002859","insp_date":"2024-04-29 00:00:00","insp_start_time":"1655","insp_end_time":"1710","registration_date":null,"region":"ET","ci_status_code":"C","location":"151H","location_desc":"H-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"490862","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:18.000000Z","updated_at":"2025-03-17T20:14:18.000000Z","inspection_violations":[{"id":8705990,"change_date":"2024-04-30 21:41:00","inspection_id":"81481605","insp_violation_id":"259218958","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9070054,"change_date":"2024-04-30 21:41:00","inspection_id":"81481605","insp_unit_id":"200645424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE27245","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HA3GSCG1JN003034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:24.000000Z","updated_at":"2025-03-17T23:17:24.000000Z"}]},{"id":5572325,"change_date":"2024-04-23 21:40:00","inspection_id":"81417805","dot_number":"299959","report_state":"NY","report_number":"SPF3010032","insp_date":"2024-04-17 00:00:00","insp_start_time":"1305","insp_end_time":"1333","registration_date":null,"region":"ED","ci_status_code":"C","location":"80881M","location_desc":"SLATE HILL NY","county_code_state":"NY","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"420338","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-04-23 21:40:00","snet_input_date":"2024-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-23 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:09.000000Z","updated_at":"2025-03-17T20:13:09.000000Z","inspection_violations":[{"id":8612002,"change_date":"2024-04-23 21:40:00","inspection_id":"81417805","insp_violation_id":"259072969","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":8975873,"change_date":"2024-04-23 21:40:00","inspection_id":"81417805","insp_unit_id":"200522285","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH N","insp_unit_company":null,"insp_unit_license":"87804NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X1LM392726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:32.000000Z","updated_at":"2025-03-17T23:16:32.000000Z"}]},{"id":5516481,"change_date":"2025-10-30 21:41:00","inspection_id":"81356855","dot_number":"299959","report_state":"CT","report_number":"3070005880","insp_date":"2024-04-16 00:00:00","insp_start_time":"1404","insp_end_time":"1425","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"705036","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-04-16 21:40:00","snet_input_date":"2024-04-16 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-16 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:59.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679982,"change_date":"2025-10-30 21:41:00","inspection_id":"81356855","insp_violation_id":"269606252","seq_no":"1","part_no":"392","part_no_section":"2LV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127290-4","created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"3922LV"}],"inspection_per_units":[{"id":16742213,"change_date":"2025-10-30 21:41:00","inspection_id":"81356855","insp_unit_id":"209729874","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"87804NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X1LM392726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":5412768,"change_date":"2024-04-11 21:40:00","inspection_id":"81243465","dot_number":"299959","report_state":"CT","report_number":"3014004128","insp_date":"2024-04-02 00:00:00","insp_start_time":"1500","insp_end_time":"1511","registration_date":"2024-04-11 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"703894","transaction_code":"C","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-04-02 21:41:00","snet_input_date":"2024-04-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-02 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:53.000000Z","updated_at":"2025-03-17T20:09:53.000000Z","inspection_violations":[{"id":8355712,"change_date":"2024-04-11 21:40:00","inspection_id":"81243465","insp_violation_id":"258868360","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200344063","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8718006,"change_date":"2024-04-11 21:40:00","inspection_id":"81243465","insp_unit_id":"200344063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1701","insp_unit_license":"DR2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X0HM159279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"}]},{"id":5020265,"change_date":"2024-02-09 21:41:00","inspection_id":"80815643","dot_number":"299959","report_state":"PA","report_number":"C111052078","insp_date":"2024-02-08 00:00:00","insp_start_time":"1159","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I84 EAST REST AREA @ GREENTOWN","county_code_state":"PA","county_code":"103","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CHUCK & EDDIES USED AUTO PARTS TARDUCCI'S JUNK YARD INC AUTO PARTS DEPOT","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-02-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2419444","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-02-09 21:41:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-02-09 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:20.000000Z","updated_at":"2025-03-17T20:02:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8080325,"change_date":"2024-02-09 21:41:00","inspection_id":"80815643","insp_unit_id":"199358798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"87804NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X1LM392726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:14.000000Z","updated_at":"2025-03-17T23:08:14.000000Z"}]},{"id":4971534,"change_date":"2025-10-01 21:39:00","inspection_id":"80762210","dot_number":"299959","report_state":"CT","report_number":"3070005662","insp_date":"2024-02-05 00:00:00","insp_start_time":"0900","insp_end_time":"0914","registration_date":"2025-10-01 00:00:00","region":"ET","ci_status_code":"C","location":"025","location_desc":"CHESHIRE","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"698790","transaction_code":"C","transaction_date":"2024-02-05 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-02-05 21:39:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-02-05 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:14.000000Z","updated_at":"2025-10-05T10:00:06.000000Z","inspection_violations":[{"id":16163572,"change_date":"2025-10-01 21:39:00","inspection_id":"80762210","insp_violation_id":"269018740","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:33.000000Z","updated_at":"2025-10-05T10:15:08.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":16281558,"change_date":"2025-10-01 21:39:00","inspection_id":"80762210","insp_unit_id":"209230210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"DF2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2MDBAA0NS002394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:46:55.000000Z","updated_at":"2025-10-05T09:45:06.000000Z"}]},{"id":4962759,"change_date":"2024-02-02 21:41:00","inspection_id":"80752574","dot_number":"299959","report_state":"NY","report_number":"SPF0260261","insp_date":"2024-01-30 00:00:00","insp_start_time":"1235","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"80881A","location_desc":"WAWAYANDA (EB)","county_code_state":"NY","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2903131","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2024-02-02 21:41:00","snet_input_date":"2024-02-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-02 21:41:00","insp_carrier_name":"CHUCK & EDDIES USED AUTO PARTS TARDUCCI'S JUNK YARD INC AUTO PARTS DEPOT","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:11.000000Z","updated_at":"2025-03-17T20:01:11.000000Z","inspection_violations":[{"id":7644421,"change_date":"2024-02-02 21:41:00","inspection_id":"80752574","insp_violation_id":"257632252","seq_no":"1","part_no":"390","part_no_section":"21(e)","insp_viol_unit":"1","insp_unit_id":"199238210","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021E"}],"inspection_per_units":[{"id":7986862,"change_date":"2024-02-02 21:41:00","inspection_id":"80752574","insp_unit_id":"199238210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"87804NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6X1LM392726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:24.000000Z","updated_at":"2025-03-17T23:07:24.000000Z"}]},{"id":4769219,"change_date":"2025-10-30 21:41:00","inspection_id":"80540741","dot_number":"299959","report_state":"CT","report_number":"3022000219","insp_date":"2024-01-05 00:00:00","insp_start_time":"1341","insp_end_time":"1354","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"DANBURY","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-05 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"696174","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2024-01-05 21:45:00","snet_input_date":"2024-01-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-05 21:45:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:16.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679978,"change_date":"2025-10-30 21:41:00","inspection_id":"80540741","insp_violation_id":"269605962","seq_no":"1","part_no":"395","part_no_section":"22G","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":16742210,"change_date":"2025-10-30 21:41:00","inspection_id":"80540741","insp_unit_id":"209729740","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"13","insp_unit_license":"BK20859","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1D9PS205980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":4617925,"change_date":"2023-12-13 21:42:00","inspection_id":"80375533","dot_number":"299959","report_state":"NJ","report_number":"SPMEI01156","insp_date":"2023-12-12 00:00:00","insp_start_time":"1115","insp_end_time":"1126","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH TOWNSHIP","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1183554","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-12-13 21:42:00","snet_input_date":"2023-12-12 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:14.000000Z","updated_at":"2025-03-17T19:54:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7427634,"change_date":"2023-12-13 21:42:00","inspection_id":"80375533","insp_unit_id":"198480541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"74299NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6XXLM392725","insp_unit_decal":"Y","insp_unit_decal_number":"33368893","created_at":"2025-03-17T23:02:26.000000Z","updated_at":"2025-03-17T23:02:26.000000Z"}]},{"id":4502097,"change_date":"2023-11-30 21:38:00","inspection_id":"80248111","dot_number":"299959","report_state":"CT","report_number":"0057000014","insp_date":"2023-11-28 00:00:00","insp_start_time":"1155","insp_end_time":"1214","registration_date":"2023-11-30 00:00:00","region":"ET","ci_status_code":"C","location":"T154","location_desc":"TROOP F REST AREA","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"692888","transaction_code":"C","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-11-28 21:40:00","snet_input_date":"2023-11-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-28 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:10.000000Z","updated_at":"2025-03-17T19:52:10.000000Z","inspection_violations":[{"id":6968610,"change_date":"2023-11-30 21:38:00","inspection_id":"80248111","insp_violation_id":"256633417","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198277022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"3939A"},{"id":6968611,"change_date":"2023-11-30 21:38:00","inspection_id":"80248111","insp_violation_id":"256633418","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198277022","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39395A"},{"id":6968612,"change_date":"2023-11-30 21:38:00","inspection_id":"80248111","insp_violation_id":"256633419","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"198277022","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:38.000000Z","updated_at":"2025-03-17T21:39:38.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":7240945,"change_date":"2023-11-30 21:38:00","inspection_id":"80248111","insp_unit_id":"198277022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"DE2592","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACVFD4LHKU8684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4368534,"change_date":"2023-11-07 21:40:00","inspection_id":"80100727","dot_number":"299959","report_state":"CT","report_number":"0128000006","insp_date":"2023-11-06 00:00:00","insp_start_time":"1600","insp_end_time":"1642","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CHUCK $ EDDIE'S AUTO PARTS","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690865","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7025983,"change_date":"2023-11-07 21:40:00","inspection_id":"80100727","insp_unit_id":"197936387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"786-2002","insp_unit_license":"74299NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6XXLM392725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":4308792,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","dot_number":"299959","report_state":"MA","report_number":"CL00003550","insp_date":"2023-10-30 00:00:00","insp_start_time":"1023","insp_end_time":"1059","registration_date":null,"region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CHUCK&EDDIES USED AUTO PARTS","shipping_paper_number":"350766","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13200","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"477436","transaction_code":"A","transaction_date":"2023-10-30 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2023-10-30 21:42:00","snet_input_date":"2023-10-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-30 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:21.000000Z","updated_at":"2025-03-17T19:48:21.000000Z","inspection_violations":[{"id":6665727,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","insp_violation_id":"256106352","seq_no":"1","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"254339AC","created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3927A"},{"id":6665728,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","insp_violation_id":"256106353","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"254339AC","created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"},{"id":6665729,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","insp_violation_id":"256106354","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197803130","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"254341AC","created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"39617C"},{"id":6665730,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","insp_violation_id":"256106355","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197803130","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"254341AC","created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":6929768,"change_date":"2023-10-30 21:42:00","inspection_id":"80034879","insp_unit_id":"197803130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"5","insp_unit_license":"AE04212","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GB3CZCG4CF216330","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:09.000000Z","updated_at":"2025-03-17T22:58:09.000000Z"}]},{"id":3254576,"change_date":"2025-09-10 21:39:00","inspection_id":"78857717","dot_number":"299959","report_state":"CT","report_number":"3029001491","insp_date":"2023-06-09 00:00:00","insp_start_time":"1118","insp_end_time":"1149","registration_date":"2025-09-10 00:00:00","region":"ET","ci_status_code":"C","location":"152","location_desc":"WATERFORD SCALE","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"676796","transaction_code":"C","transaction_date":"2023-07-19 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-06-12 21:39:00","snet_input_date":"2023-06-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-06-12 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:22.000000Z","updated_at":"2025-09-13T10:47:23.000000Z","inspection_violations":[{"id":15769060,"change_date":"2025-09-10 21:39:00","inspection_id":"78857717","insp_violation_id":"268566199","seq_no":"1","part_no":"392","part_no_section":"2UCR","insp_viol_unit":"1","insp_unit_id":"208837904","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:15.000000Z","updated_at":"2025-09-14T11:54:44.000000Z","normalized_code":"3922UCR"},{"id":15769061,"change_date":"2025-09-10 21:39:00","inspection_id":"78857717","insp_violation_id":"268566200","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"208837904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:15.000000Z","updated_at":"2025-09-14T11:54:44.000000Z","normalized_code":"3939H"},{"id":15769062,"change_date":"2025-09-10 21:39:00","inspection_id":"78857717","insp_violation_id":"268566201","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208837904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:15.000000Z","updated_at":"2025-09-14T11:54:44.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15921015,"change_date":"2025-09-10 21:39:00","inspection_id":"78857717","insp_unit_id":"208837904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5955","insp_unit_license":"DL2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ6X2KM241259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:12.000000Z","updated_at":"2025-09-13T10:00:12.000000Z"}]},{"id":3090151,"change_date":"2025-10-30 21:41:00","inspection_id":"78672294","dot_number":"299959","report_state":"CT","report_number":"3082000467","insp_date":"2023-05-18 00:00:00","insp_start_time":"1946","insp_end_time":"2020","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0018490712","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"675026","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679977,"change_date":"2025-10-30 21:41:00","inspection_id":"78672294","insp_violation_id":"269606216","seq_no":"1","part_no":"392","part_no_section":"2UCR","insp_viol_unit":"1","insp_unit_id":"209729852","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y996088-0","created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"3922UCR"}],"inspection_per_units":[{"id":16742209,"change_date":"2025-10-30 21:41:00","inspection_id":"78672294","insp_unit_id":"209729852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"74299NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHHM6XXLM392725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":2891700,"change_date":"2025-10-30 21:41:00","inspection_id":"78448117","dot_number":"299959","report_state":"CT","report_number":"3029001419","insp_date":"2023-04-26 00:00:00","insp_start_time":"1559","insp_end_time":"1607","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"138","location_desc":"STRATFORD","county_code_state":"CT","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34600","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672878","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-04-26 21:40:00","snet_input_date":"2023-04-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-26 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:05.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679975,"change_date":"2025-10-30 21:41:00","inspection_id":"78448117","insp_violation_id":"269606050","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":16742206,"change_date":"2025-10-30 21:41:00","inspection_id":"78448117","insp_unit_id":"209729770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"DS2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ6X7KM241256","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"},{"id":16742207,"change_date":"2025-10-30 21:41:00","inspection_id":"78448117","insp_unit_id":"209729771","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CHEVR","insp_unit_company":null,"insp_unit_license":"----","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GCGG25C881100880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":2868109,"change_date":"2025-10-30 21:41:00","inspection_id":"78421276","dot_number":"299959","report_state":"CT","report_number":"3070004536","insp_date":"2023-04-22 00:00:00","insp_start_time":"0736","insp_end_time":"0800","registration_date":"2025-10-30 00:00:00","region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672547","transaction_code":"C","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2023-04-24 21:40:00","snet_input_date":"2023-04-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-04-24 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:40.000000Z","updated_at":"2025-11-03T11:00:03.000000Z","inspection_violations":[{"id":16679974,"change_date":"2025-10-30 21:41:00","inspection_id":"78421276","insp_violation_id":"269606029","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209729767","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:37.000000Z","updated_at":"2025-11-03T11:15:06.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16742205,"change_date":"2025-10-30 21:41:00","inspection_id":"78421276","insp_unit_id":"209729767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1704","insp_unit_license":"DH2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUMML9LL149063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:16.000000Z","updated_at":"2025-11-03T10:45:06.000000Z"}]},{"id":1991639,"change_date":"2022-12-21 21:39:00","inspection_id":"77422545","dot_number":"299959","report_state":"CT","report_number":"0158000057","insp_date":"2022-12-21 00:00:00","insp_start_time":"1136","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"661779","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3204383,"change_date":"2022-12-21 21:39:00","inspection_id":"77422545","insp_unit_id":"192528088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"DF2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2MDBAA0NS002394","insp_unit_decal":"Y","insp_unit_decal_number":"32053971","created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":2001224,"change_date":"2023-01-09 21:41:00","inspection_id":"77433480","dot_number":"299959","report_state":"CT","report_number":"3070004110","insp_date":"2022-12-21 00:00:00","insp_start_time":"1528","insp_end_time":"1610","registration_date":"2023-01-09 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"0","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"661895","transaction_code":"C","transaction_date":"2022-12-21 00:00:00","upload_date":"2023-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2022-12-22 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-22 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:38.000000Z","updated_at":"2025-03-17T19:03:38.000000Z","inspection_violations":[{"id":3106868,"change_date":"2023-01-09 21:41:00","inspection_id":"77433480","insp_violation_id":"250440041","seq_no":"1","part_no":"393","part_no_section":"17(b)","insp_viol_unit":"1","insp_unit_id":"192749080","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39317B"},{"id":3106869,"change_date":"2023-01-09 21:41:00","inspection_id":"77433480","insp_violation_id":"250440042","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192749080","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39021TB"},{"id":3106870,"change_date":"2023-01-09 21:41:00","inspection_id":"77433480","insp_violation_id":"250440043","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192749080","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:45.000000Z","updated_at":"2025-03-17T21:21:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3219589,"change_date":"2023-01-09 21:41:00","inspection_id":"77433480","insp_unit_id":"192749080","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DM2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHM6X0HM1S9279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:02.000000Z","updated_at":"2025-03-17T22:29:02.000000Z"}]},{"id":1957758,"change_date":"2022-12-28 21:39:00","inspection_id":"77383920","dot_number":"299959","report_state":"CT","report_number":"3078001449","insp_date":"2022-12-15 00:00:00","insp_start_time":"0942","insp_end_time":"1008","registration_date":"2022-12-27 00:00:00","region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"661229","transaction_code":"C","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2022-12-16 21:39:00","snet_input_date":"2022-12-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-12-16 21:39:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:36.000000Z","updated_at":"2025-03-17T19:02:36.000000Z","inspection_violations":[{"id":3040841,"change_date":"2022-12-28 21:39:00","inspection_id":"77383920","insp_violation_id":"250282271","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y992557-4","created_at":"2025-03-17T21:21:29.000000Z","updated_at":"2025-03-17T21:21:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3150218,"change_date":"2022-12-28 21:39:00","inspection_id":"77383920","insp_unit_id":"192597925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"DH2549","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAEUMML9LL149063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:35.000000Z","updated_at":"2025-03-17T22:28:35.000000Z"}]},{"id":1760022,"change_date":"2022-11-17 21:40:00","inspection_id":"77157205","dot_number":"299959","report_state":"NY","report_number":"SPD0214618","insp_date":"2022-11-08 00:00:00","insp_start_time":"1355","insp_end_time":"1412","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789A","location_desc":"SOUTHEAST (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2769858","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:15.000000Z","updated_at":"2025-03-17T18:59:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2831396,"change_date":"2022-11-17 21:40:00","inspection_id":"77157205","insp_unit_id":"192001902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:22.000000Z","updated_at":"2025-03-17T22:26:22.000000Z"}]},{"id":1031484,"change_date":"2022-08-16 21:38:00","inspection_id":"76314170","dot_number":"299959","report_state":"CT","report_number":"3070003675","insp_date":"2022-08-09 00:00:00","insp_start_time":"1039","insp_end_time":"1050","registration_date":"2022-08-16 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CENTR MOTORS","shipping_paper_number":"505","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"650950","transaction_code":"C","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2022-08-15 21:37:00","snet_input_date":"2022-08-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-15 21:37:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:49.000000Z","updated_at":"2025-03-17T18:45:49.000000Z","inspection_violations":[{"id":1625547,"change_date":"2022-08-16 21:38:00","inspection_id":"76314170","insp_violation_id":"247723700","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1660065,"change_date":"2022-08-16 21:38:00","inspection_id":"76314170","insp_unit_id":"190318268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"DM2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1M2MDBAA9MS001128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"}]},{"id":589580,"change_date":"2022-06-16 21:42:00","inspection_id":"75795221","dot_number":"299959","report_state":"CT","report_number":"3070003458","insp_date":"2022-06-13 00:00:00","insp_start_time":"1455","insp_end_time":"1525","registration_date":"2022-06-16 00:00:00","region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"--","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"646328","transaction_code":"C","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[{"id":924780,"change_date":"2022-06-16 21:42:00","inspection_id":"75795221","insp_violation_id":"246502310","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39282A1"},{"id":924781,"change_date":"2022-06-16 21:42:00","inspection_id":"75795221","insp_violation_id":"246502311","seq_no":"2","part_no":"393","part_no_section":"17(a)","insp_viol_unit":"2","insp_unit_id":"189281965","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39317A"}],"inspection_per_units":[{"id":947310,"change_date":"2022-06-16 21:42:00","inspection_id":"75795221","insp_unit_id":"189281964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DI2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"2NKHHJ6X9KM241260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"},{"id":947311,"change_date":"2022-06-16 21:42:00","inspection_id":"75795221","insp_unit_id":"189281965","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHER","insp_unit_company":null,"insp_unit_license":"DI2635","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"VIN","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]},{"id":414199,"change_date":"2022-05-18 21:43:00","inspection_id":"75586959","dot_number":"299959","report_state":"NY","report_number":"MC24002855","insp_date":"2022-05-17 00:00:00","insp_start_time":"1503","insp_end_time":"1532","registration_date":null,"region":"ET","ci_status_code":"C","location":"80789M","location_desc":"SOUTHEAST REST AREA (NB)","county_code_state":"NY","county_code":"079","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"MITCHELL'S AUTO PARTS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2707047","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:49.000000Z","updated_at":"2025-03-17T18:34:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":668402,"change_date":"2022-05-18 21:43:00","inspection_id":"75586959","insp_unit_id":"188746142","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"Y","insp_unit_decal_number":"31442711","created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":221709,"change_date":"2022-04-21 21:40:00","inspection_id":"75357409","dot_number":"299959","report_state":"NY","report_number":"SPK0109466","insp_date":"2022-04-14 00:00:00","insp_start_time":"0939","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"80057A","location_desc":"BEDFORD (SB)","county_code_state":"NY","county_code":"119","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2697462","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00299959","upload_search_indicator":"M","census_search_date":"2022-04-21 21:40:00","snet_input_date":"2022-04-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"MITCHELL'S AUTO PARTS INC","insp_carrier_street":"384 OLD TURNPIKE ROAD","insp_carrier_city":"SOUTHINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06479","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":359253,"change_date":"2022-04-21 21:40:00","inspection_id":"75357409","insp_unit_id":"188264877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"AE49965","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"54DCDW1B3KS805563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:20.000000Z","updated_at":"2025-03-17T22:10:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/299959\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/299959\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/299959\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/299959\/inspections","per_page":100,"prev_page_url":null,"to":68,"total":68}