{"current_page":1,"data":[{"id":11825966,"change_date":"2026-05-05 21:39:00","inspection_id":"87760745","dot_number":"18477","report_state":"NH","report_number":"1305000301","insp_date":"2026-05-04 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NH","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TOURTELLOT & CO 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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3263316","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:27.000000Z","updated_at":"2026-05-15T12:18:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20567944,"change_date":"2026-05-05 21:39:00","inspection_id":"87760745","insp_unit_id":"213384919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1SI786","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE9RHUM5450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:17.000000Z","updated_at":"2026-05-15T11:57:41.000000Z"}]},{"id":11607375,"change_date":"2026-04-09 21:55:00","inspection_id":"87534702","dot_number":"18477","report_state":"MA","report_number":"EG00001027","insp_date":"2026-04-09 00:00:00","insp_start_time":"1110","insp_end_time":"1122","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-09 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"543874","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2026-04-09 21:55:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-04-09 21:55:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-12T09:45:29.000000Z","updated_at":"2026-04-20T09:31:21.000000Z","inspection_violations":[{"id":19634581,"change_date":"2026-04-09 21:55:00","inspection_id":"87534702","insp_violation_id":"272965645","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-04-11T10:04:16.000000Z","updated_at":"2026-04-19T10:53:31.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":19896004,"change_date":"2026-04-09 21:55:00","inspection_id":"87534702","insp_unit_id":"212628174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"757587","insp_unit_license":"1SI522","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC7SDVH9603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:25:31.000000Z","updated_at":"2026-04-19T09:09:17.000000Z"}]},{"id":11475371,"change_date":"2026-03-25 21:40:00","inspection_id":"87394275","dot_number":"18477","report_state":"MA","report_number":"DS00002705","insp_date":"2026-03-24 00:00:00","insp_start_time":"1332","insp_end_time":"1356","registration_date":null,"region":"ET","ci_status_code":"C","location":"011H","location_desc":"H-ANDOVER","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"542679","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:46.000000Z","updated_at":"2026-04-05T09:31:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19656309,"change_date":"2026-03-25 21:40:00","inspection_id":"87394275","insp_unit_id":"212330200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468545","insp_unit_license":"1SI708","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE3RHUM5461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:22:56.000000Z","updated_at":"2026-04-05T09:17:17.000000Z"}]},{"id":11475344,"change_date":"2026-04-06 21:37:00","inspection_id":"87394245","dot_number":"18477","report_state":"MA","report_number":"BV00008254","insp_date":"2026-03-24 00:00:00","insp_start_time":"1327","insp_end_time":"1412","registration_date":null,"region":"ET","ci_status_code":"C","location":"331H","location_desc":"H-TEWKSBURY","county_code_state":"MA","county_code":"017","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":"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":"2026-03-25 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"52000","viol_total":"3","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":"542632","transaction_code":"C","transaction_date":"2026-04-06 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:46.000000Z","updated_at":"2026-04-17T09:31:07.000000Z","inspection_violations":[{"id":19562591,"change_date":"2026-04-06 21:37:00","inspection_id":"87394245","insp_violation_id":"272893964","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"212564306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:09.000000Z","updated_at":"2026-04-18T10:36:27.000000Z","normalized_code":"3965BL"},{"id":19562589,"change_date":"2026-04-06 21:37:00","inspection_id":"87394245","insp_violation_id":"272893962","seq_no":"1","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"1","insp_unit_id":"212564306","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-08T10:13:09.000000Z","updated_at":"2026-04-18T10:36:26.000000Z","normalized_code":"3963A1HCM"},{"id":19562590,"change_date":"2026-04-06 21:37:00","inspection_id":"87394245","insp_violation_id":"272893963","seq_no":"2","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"212564306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:09.000000Z","updated_at":"2026-04-18T10:36:27.000000Z","normalized_code":"39330B"}],"inspection_per_units":[{"id":19833216,"change_date":"2026-04-06 21:37:00","inspection_id":"87394245","insp_unit_id":"212564306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1S1787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","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":11422082,"change_date":"2026-03-20 21:39:00","inspection_id":"87337863","dot_number":"18477","report_state":"RI","report_number":"0239000741","insp_date":"2026-03-14 00:00:00","insp_start_time":"1028","insp_end_time":"1057","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","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":"U","pen_cen_match":"I","final_status_date":"2026-03-20 21:39: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":"3027886","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:29.000000Z","updated_at":"2026-03-31T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19566727,"change_date":"2026-03-20 21:39:00","inspection_id":"87337863","insp_unit_id":"212229797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"468583","insp_unit_license":"1JW197","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVACXFC2RHUM5462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:55.000000Z","updated_at":"2026-03-31T09:08:04.000000Z"}]},{"id":11343334,"change_date":"2026-03-11 21:38:00","inspection_id":"87261114","dot_number":"18477","report_state":"MA","report_number":"DT00000785","insp_date":"2026-03-11 00:00:00","insp_start_time":"0539","insp_end_time":"0555","registration_date":null,"region":"ET","ci_status_code":"C","location":"178H","location_desc":"H-LUDLOW","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"733095","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":"2026-03-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"541646","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2026-03-11 21:38:00","snet_input_date":"2026-03-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-11 21:38:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-14T09:38:16.000000Z","updated_at":"2026-03-22T09:31:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19411953,"change_date":"2026-03-11 21:38:00","inspection_id":"87261114","insp_unit_id":"212082182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1SI786","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE9RHUM5450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:54.000000Z","updated_at":"2026-03-22T09:10:45.000000Z"}]},{"id":11374939,"change_date":"2026-03-14 21:33:00","inspection_id":"87288751","dot_number":"18477","report_state":"RI","report_number":"0239000731","insp_date":"2026-03-08 00:00:00","insp_start_time":"1016","insp_end_time":"1043","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","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":"U","pen_cen_match":"I","final_status_date":"2026-03-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3003892","transaction_code":"A","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2026-03-14 21:33:00","snet_input_date":"2026-03-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-14 21:33:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-17T09:38:31.000000Z","updated_at":"2026-03-25T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19476988,"change_date":"2026-03-14 21:33:00","inspection_id":"87288751","insp_unit_id":"212132941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"468544","insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-17T09:14:09.000000Z","updated_at":"2026-03-25T09:03:29.000000Z"}]},{"id":10174566,"change_date":"2025-11-12 21:40:00","inspection_id":"86294050","dot_number":"18477","report_state":"NY","report_number":"D103101331","insp_date":"2025-11-10 00:00:00","insp_start_time":"1054","insp_end_time":"1119","registration_date":"2025-11-11 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","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":"U","pen_cen_match":"I","final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2530773","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:34.000000Z","updated_at":"2025-11-16T10:30:28.000000Z","inspection_violations":[{"id":16895792,"change_date":"2025-11-12 21:40:00","inspection_id":"86294050","insp_violation_id":"269881097","seq_no":"1","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"209966475","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"393201BFR"}],"inspection_per_units":[{"id":16943538,"change_date":"2025-11-12 21:40:00","inspection_id":"86294050","insp_unit_id":"209966475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:30.000000Z","updated_at":"2025-11-16T10:00:31.000000Z"}]},{"id":9648902,"change_date":"2025-09-11 21:40:00","inspection_id":"85742508","dot_number":"18477","report_state":"NY","report_number":"SPK3040726","insp_date":"2025-09-04 00:00:00","insp_start_time":"1207","insp_end_time":"1234","registration_date":null,"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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-11 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":"2250242","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-09-11 21:40:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-11 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:45.000000Z","updated_at":"2025-09-16T10:46:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15942903,"change_date":"2025-09-11 21:40:00","inspection_id":"85742508","insp_unit_id":"208864387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI522","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC7SDVH9603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:30.000000Z","updated_at":"2025-09-15T09:52:43.000000Z"}]},{"id":9084609,"change_date":"2025-07-08 21:38:00","inspection_id":"85147692","dot_number":"18477","report_state":"RI","report_number":"0084000750","insp_date":"2025-07-02 00:00:00","insp_start_time":"1045","insp_end_time":"1121","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","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":"Y","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":"52000","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":"1961746","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-07-08 21:38:00","snet_input_date":"2025-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-08 21:38:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:45.000000Z","updated_at":"2025-07-12T10:44:30.000000Z","inspection_violations":[{"id":14632056,"change_date":"2025-07-08 21:38:00","inspection_id":"85147692","insp_violation_id":"267254511","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","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-07-11T10:47:01.000000Z","updated_at":"2025-07-13T10:47:59.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":14909215,"change_date":"2025-07-08 21:38:00","inspection_id":"85147692","insp_unit_id":"207742662","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI786","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE9RHUM5450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-11T09:46:31.000000Z","updated_at":"2025-07-12T09:45:08.000000Z"}]},{"id":8908410,"change_date":"2025-06-26 21:40:00","inspection_id":"84961833","dot_number":"18477","report_state":"MA","report_number":"DZ00000537","insp_date":"2025-06-16 00:00:00","insp_start_time":"0331","insp_end_time":"0348","registration_date":"2025-06-26 00:00:00","region":"ET","ci_status_code":"C","location":"186H","location_desc":"H-MANSFIELD","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MID ATLANTIC REGIONAL COOP","shipping_paper_number":"217326","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-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"520649","transaction_code":"C","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:21.000000Z","updated_at":"2025-06-30T10:00:47.000000Z","inspection_violations":[{"id":14444991,"change_date":"2025-06-26 21:40:00","inspection_id":"84961833","insp_violation_id":"267054972","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"207561983","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:22.000000Z","updated_at":"2025-06-30T10:16:44.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":14732634,"change_date":"2025-06-26 21:40:00","inspection_id":"84961833","insp_unit_id":"207561983","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"757586","insp_unit_license":"1SI521","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC5SDVH9602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:07.000000Z","updated_at":"2025-07-01T09:46:40.000000Z"}]},{"id":8656355,"change_date":"2025-05-16 21:42:00","inspection_id":"84694723","dot_number":"18477","report_state":"US","report_number":"1434000047","insp_date":"2025-05-14 00:00:00","insp_start_time":"0923","insp_end_time":"1001","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RICHMOND RI","county_code_state":"RI","county_code":"001","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-05-16 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":"1739286","transaction_code":"A","transaction_date":"2025-05-16 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-05-16 21:42:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-16 21:42:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:04.000000Z","updated_at":"2025-05-20T10:05:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14138977,"change_date":"2025-05-16 21:42:00","inspection_id":"84694723","insp_unit_id":"206903381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1S1521","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC5SDVH9602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:23.000000Z","updated_at":"2025-05-20T09:50:27.000000Z"}]},{"id":8672349,"change_date":"2025-05-19 21:39:00","inspection_id":"84711668","dot_number":"18477","report_state":"RI","report_number":"0168000019","insp_date":"2025-05-13 00:00:00","insp_start_time":"1306","insp_end_time":"1400","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RICHMOND RI","county_code_state":"RI","county_code":"009","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-05-19 21:39: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":"1748103","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-05-19 21:39:00","snet_input_date":"2025-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:14.000000Z","updated_at":"2025-05-23T10:03:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14165864,"change_date":"2025-05-19 21:39:00","inspection_id":"84711668","insp_unit_id":"206934082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI522","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC7SDVH9603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:56.000000Z","updated_at":"2025-05-23T09:48:41.000000Z"}]},{"id":8498109,"change_date":"2025-04-30 21:51:00","inspection_id":"84528129","dot_number":"18477","report_state":"RI","report_number":"0050000017","insp_date":"2025-04-19 00:00:00","insp_start_time":"0932","insp_end_time":"1025","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"UNKNOWN","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":"U","pen_cen_match":"I","final_status_date":"2025-04-30 21:51: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":"1652191","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-04-30 21:51:00","snet_input_date":"2025-04-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:51:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:41.000000Z","updated_at":"2025-05-04T10:33:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13812012,"change_date":"2025-04-30 21:51:00","inspection_id":"84528129","insp_unit_id":"206547259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1JW198","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVACXFC4RHUM5463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:11:05.000000Z","updated_at":"2025-05-04T09:51:08.000000Z"}]},{"id":8295757,"change_date":"2025-04-04 21:40:00","inspection_id":"84315032","dot_number":"18477","report_state":"MA","report_number":"DR00001477","insp_date":"2025-04-04 00:00:00","insp_start_time":"0815","insp_end_time":"0902","registration_date":null,"region":"ET","ci_status_code":"C","location":"036H","location_desc":"H-BLANDFORD","county_code_state":"MA","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"75786","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-04-04 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":"514107","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:04.000000Z","updated_at":"2025-04-08T10:09:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13450295,"change_date":"2025-04-04 21:40:00","inspection_id":"84315032","insp_unit_id":"206156968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1SI522","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALACXFC7SDVH9603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:09:18.000000Z","updated_at":"2025-04-08T09:56:32.000000Z"}]},{"id":8102113,"change_date":"2025-03-13 21:42:00","inspection_id":"84111117","dot_number":"18477","report_state":"CT","report_number":"3119998896","insp_date":"2025-03-13 00:00:00","insp_start_time":"0330","insp_end_time":"0348","registration_date":null,"region":"ET","ci_status_code":"C","location":"152SS","location_desc":"WATERFORD SCALE S\/B","county_code_state":"CT","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"00704383","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-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"734707","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-03-13 21:42:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-13 21:42:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:49.000000Z","updated_at":"2025-03-17T21:06:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13081456,"change_date":"2025-03-13 21:42:00","inspection_id":"84111117","insp_unit_id":"205770634","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468544","insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:37.000000Z","updated_at":"2025-03-17T23:59:37.000000Z"}]},{"id":8125256,"change_date":"2025-03-15 21:33:00","inspection_id":"84135498","dot_number":"18477","report_state":"RI","report_number":"0145000710","insp_date":"2025-03-09 00:00:00","insp_start_time":"1043","insp_end_time":"1111","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PROVIDENCE RI","county_code_state":"RI","county_code":"007","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-03-15 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1474015","transaction_code":"A","transaction_date":"2025-03-15 00:00:00","upload_date":"2025-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-03-15 21:33:00","snet_input_date":"2025-03-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-15 21:33:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:07:04.000000Z","updated_at":"2025-03-21T10:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13119014,"change_date":"2025-03-15 21:33:00","inspection_id":"84135498","insp_unit_id":"205818710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"468544","insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"Y","insp_unit_decal_number":"35015117","created_at":"2025-03-18T00:00:01.000000Z","updated_at":"2025-03-21T09:49:13.000000Z"}]},{"id":7877596,"change_date":"2025-02-16 21:34:00","inspection_id":"83875310","dot_number":"18477","report_state":"RI","report_number":"1660000008","insp_date":"2025-02-08 00:00:00","insp_start_time":"1343","insp_end_time":"1421","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"RICHMOND RI","county_code_state":"RI","county_code":"009","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-16 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1363411","transaction_code":"A","transaction_date":"2025-02-16 00:00:00","upload_date":"2025-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-02-16 21:34:00","snet_input_date":"2025-02-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-16 21:34:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:36.000000Z","updated_at":"2025-03-17T21:01:36.000000Z","inspection_violations":[{"id":12311018,"change_date":"2025-02-16 21:34:00","inspection_id":"83875310","insp_violation_id":"264534902","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205339514","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":12714762,"change_date":"2025-02-16 21:34:00","inspection_id":"83875310","insp_unit_id":"205339514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:25.000000Z","updated_at":"2025-03-17T23:55:25.000000Z"}]},{"id":7722206,"change_date":"2025-01-30 21:40:00","inspection_id":"83711950","dot_number":"18477","report_state":"CT","report_number":"3091005808","insp_date":"2025-01-28 00:00:00","insp_start_time":"1050","insp_end_time":"1129","registration_date":"2025-01-30 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TOURTELLOT & CO INC","shipping_paper_number":"00700189","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-01-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"730956","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-01-28 21:38:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-28 21:38:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:39.000000Z","updated_at":"2025-03-17T20:58:39.000000Z","inspection_violations":[{"id":12065679,"change_date":"2025-01-30 21:40:00","inspection_id":"83711950","insp_violation_id":"264244996","seq_no":"1","part_no":"392","part_no_section":"2-SLL","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:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12461545,"change_date":"2025-01-30 21:40:00","inspection_id":"83711950","insp_unit_id":"205071477","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"468584","insp_unit_license":"1JW198","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVACXFC4RHUM5463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:30.000000Z","updated_at":"2025-03-17T23:52:30.000000Z"}]},{"id":7549675,"change_date":"2025-01-05 21:32:00","inspection_id":"83530854","dot_number":"18477","report_state":"RI","report_number":"0084000509","insp_date":"2024-12-29 00:00:00","insp_start_time":"1158","insp_end_time":"1232","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MCQUADES MARKET","shipping_paper_number":"00698844","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-05 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1216063","transaction_code":"A","transaction_date":"2025-01-05 00:00:00","upload_date":"2025-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2025-01-05 21:32:00","snet_input_date":"2024-12-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-05 21:32:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:54.000000Z","updated_at":"2025-03-17T20:54:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12181016,"change_date":"2025-01-05 21:32:00","inspection_id":"83530854","insp_unit_id":"204654331","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1SI787","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:29.000000Z","updated_at":"2025-03-17T23:49:29.000000Z"}]},{"id":7436002,"change_date":"2025-01-14 21:54:00","inspection_id":"83411530","dot_number":"18477","report_state":"RI","report_number":"0058000454","insp_date":"2024-12-10 00:00:00","insp_start_time":"1420","insp_end_time":"1512","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"JOHNSTON RI","county_code_state":"RI","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"00697420","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":"U","pen_cen_match":"I","final_status_date":"2024-12-17 21:38: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1165819","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-12-17 21:38:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-17 21:38:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:11.000000Z","updated_at":"2025-03-17T20:51:11.000000Z","inspection_violations":[{"id":11620112,"change_date":"2025-01-14 21:54:00","inspection_id":"83411530","insp_violation_id":"263975071","seq_no":"1","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"1","insp_unit_id":"204815387","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:37.000000Z","updated_at":"2025-03-17T22:02:37.000000Z","normalized_code":"393201AFRCLS"},{"id":11620113,"change_date":"2025-01-14 21:54:00","inspection_id":"83411530","insp_violation_id":"263975072","seq_no":"2","part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"204815387","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:37.000000Z","updated_at":"2025-03-17T22:02:37.000000Z","normalized_code":"393201BFR"},{"id":11620114,"change_date":"2025-01-14 21:54:00","inspection_id":"83411530","insp_violation_id":"263975073","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204815387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:37.000000Z","updated_at":"2025-03-17T22:02:37.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":11996407,"change_date":"2025-01-14 21:54:00","inspection_id":"83411530","insp_unit_id":"204815387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"239768","insp_unit_license":"2915798","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN1LL847653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:27.000000Z","updated_at":"2025-03-17T23:47:27.000000Z"}]},{"id":7246707,"change_date":"2024-11-21 21:40:00","inspection_id":"83212122","dot_number":"18477","report_state":"US","report_number":"1889000054","insp_date":"2024-11-20 00:00:00","insp_start_time":"1117","insp_end_time":"1138","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DANBURY CT","county_code_state":"CT","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"00073507","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-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1077512","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-11-21 21:40:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-21 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:15.000000Z","updated_at":"2025-03-17T20:47:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11688810,"change_date":"2024-11-21 21:40:00","inspection_id":"83212122","insp_unit_id":"203985593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3790649","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVHCYFE1RHUM5460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"}]},{"id":7131862,"change_date":"2024-11-06 21:40:00","inspection_id":"83090697","dot_number":"18477","report_state":"MA","report_number":"DL00000481","insp_date":"2024-11-06 00:00:00","insp_start_time":"0827","insp_end_time":"0857","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"502947","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2024-11-06 21:40:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:41.000000Z","updated_at":"2025-03-17T20:44:41.000000Z","inspection_violations":[{"id":11141541,"change_date":"2024-11-06 21:40:00","inspection_id":"83090697","insp_violation_id":"262754699","seq_no":"1","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":"991128AC","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":11502920,"change_date":"2024-11-06 21:40:00","inspection_id":"83090697","insp_unit_id":"203757414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"248286","insp_unit_license":"2924653","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN0LL859017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"}]},{"id":7031132,"change_date":"2024-10-24 21:40:00","inspection_id":"82983822","dot_number":"18477","report_state":"CT","report_number":"0773000091","insp_date":"2024-10-24 00:00:00","insp_start_time":"0856","insp_end_time":"0926","registration_date":null,"region":"ET","ci_status_code":"C","location":"T083","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":"STEW LEONARDS","shipping_paper_number":"00072959","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-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26308","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":"721361","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-10-24 21:40:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-24 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:39.000000Z","updated_at":"2025-03-17T20:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11339575,"change_date":"2024-10-24 21:40:00","inspection_id":"82983822","insp_unit_id":"203558078","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"467204","insp_unit_license":"1SI665","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FVHCYFE7RHUM3602","insp_unit_decal":"Y","insp_unit_decal_number":"34681581","created_at":"2025-03-17T23:40:24.000000Z","updated_at":"2025-03-17T23:40:24.000000Z"}]},{"id":6741695,"change_date":"2024-09-17 21:43:00","inspection_id":"82675805","dot_number":"18477","report_state":"CT","report_number":"3072000127","insp_date":"2024-09-17 00:00:00","insp_start_time":"0743","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":"137","location_desc":"STONINGTON","county_code_state":"CT","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DUNNS CORNERS MARKET","shipping_paper_number":"00690202","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-09-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"718160","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-09-17 21:43:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-17 21:43:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:53.000000Z","updated_at":"2025-03-17T20:36:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10870978,"change_date":"2024-09-17 21:43:00","inspection_id":"82675805","insp_unit_id":"202956197","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"248961","insp_unit_license":"3573400","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR9RN664481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"},{"id":10870979,"change_date":"2024-09-17 21:43:00","inspection_id":"82675805","insp_unit_id":"202956198","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"665534","insp_unit_license":"1PD535","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1GRAA7220HB705802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"}]},{"id":5814945,"change_date":"2024-05-22 21:40:00","inspection_id":"81681622","dot_number":"18477","report_state":"RI","report_number":"0239000182","insp_date":"2024-05-16 00:00:00","insp_start_time":"1424","insp_end_time":"1503","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0095N","location_desc":"RICHMOND EXETER NB","county_code_state":"RI","county_code":"009","insp_level_id":"2","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":"Y","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-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"505210","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:54.000000Z","updated_at":"2025-03-17T20:17:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9365230,"change_date":"2024-05-22 21:40:00","inspection_id":"81681622","insp_unit_id":"201028187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"248960","insp_unit_license":"1371394288","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMML5RL667101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:15.000000Z","updated_at":"2025-03-17T23:20:15.000000Z"}]},{"id":5802425,"change_date":"2024-05-21 21:46:00","inspection_id":"81667741","dot_number":"18477","report_state":"US","report_number":"1888000049","insp_date":"2024-05-15 00:00:00","insp_start_time":"1239","insp_end_time":"1313","registration_date":null,"region":"ED","ci_status_code":"C","location":"I0095N","location_desc":"RICHMOND EXETER NB","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"TOURTELLOT & CO., INC","shipping_paper_number":"JDELPIVO\/PD0960","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-05-21 21:46: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":"501729","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2024-05-21 21:46:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:50.000000Z","updated_at":"2025-03-17T20:17:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9345365,"change_date":"2024-05-21 21:46:00","inspection_id":"81667741","insp_unit_id":"201001261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"S12\/248269","insp_unit_license":"2924104","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN1LL859009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"}]},{"id":5084081,"change_date":"2024-02-20 21:41:00","inspection_id":"80885261","dot_number":"18477","report_state":"MA","report_number":"DA00001786","insp_date":"2024-02-19 00:00:00","insp_start_time":"1021","insp_end_time":"1039","registration_date":null,"region":"ET","ci_status_code":"C","location":"208H","location_desc":"H-MILTON","county_code_state":"MA","county_code":"021","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"485541","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:26.000000Z","updated_at":"2025-03-17T20:03:26.000000Z","inspection_violations":[{"id":7837993,"change_date":"2024-02-20 21:41:00","inspection_id":"80885261","insp_violation_id":"257914474","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"199491722","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:52.000000Z","updated_at":"2025-03-17T21:43:52.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":8185161,"change_date":"2024-02-20 21:41:00","inspection_id":"80885261","insp_unit_id":"199491722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"33003","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE3JDJJ9296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:12.000000Z","updated_at":"2025-03-17T23:09:12.000000Z"}]},{"id":4971488,"change_date":"2024-02-05 21:39:00","inspection_id":"80762160","dot_number":"18477","report_state":"CT","report_number":"3022000280","insp_date":"2024-02-05 00:00:00","insp_start_time":"0746","insp_end_time":"0802","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"00669277","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-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"698792","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","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":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","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-03-17T20:01:14.000000Z","inspection_violations":[{"id":7659103,"change_date":"2024-02-05 21:39:00","inspection_id":"80762160","insp_violation_id":"257654607","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126129-5","created_at":"2025-03-17T21:42:57.000000Z","updated_at":"2025-03-17T21:42:57.000000Z","normalized_code":"3922"},{"id":7659104,"change_date":"2024-02-05 21:39:00","inspection_id":"80762160","insp_violation_id":"257654608","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V126129-5","created_at":"2025-03-17T21:42:57.000000Z","updated_at":"2025-03-17T21:42:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8001305,"change_date":"2024-02-05 21:39:00","inspection_id":"80762160","insp_unit_id":"199257254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"239768","insp_unit_license":"2915798","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN1LL847653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:32.000000Z","updated_at":"2025-03-17T23:07:32.000000Z"}]},{"id":4402426,"change_date":"2023-11-13 21:40:00","inspection_id":"80138504","dot_number":"18477","report_state":"MA","report_number":"DC00001152","insp_date":"2023-11-10 00:00:00","insp_start_time":"1134","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TOURTELLOT & CO 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":"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-11-13 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":"478394","transaction_code":"A","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-11-13 21:40:00","snet_input_date":"2023-11-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-13 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:15.000000Z","updated_at":"2025-03-17T19:50:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7080188,"change_date":"2023-11-13 21:40:00","inspection_id":"80138504","insp_unit_id":"198009327","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2924653","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN0LL859017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:27.000000Z","updated_at":"2025-03-17T22:59:27.000000Z"}]},{"id":4179565,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","dot_number":"18477","report_state":"MA","report_number":"CQ00003236","insp_date":"2023-10-12 00:00:00","insp_start_time":"1034","insp_end_time":"1112","registration_date":null,"region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","county_code":"005","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":"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":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"476186","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:31.000000Z","updated_at":"2025-03-17T19:45:31.000000Z","inspection_violations":[{"id":6471079,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_violation_id":"255789618","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197514486","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39347E"},{"id":6471080,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_violation_id":"255789619","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197514486","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39353B"},{"id":6471081,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_violation_id":"255789620","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197514486","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39347E"},{"id":6471082,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_violation_id":"255789621","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197514486","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3963A1"},{"id":6471083,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_violation_id":"255789622","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"197514486","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":6721174,"change_date":"2023-10-12 21:41:00","inspection_id":"79891973","insp_unit_id":"197514486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2653537","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMMN9JH579899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:22.000000Z","updated_at":"2025-03-17T22:56:22.000000Z"}]},{"id":3246336,"change_date":"2023-08-30 21:44:00","inspection_id":"78848467","dot_number":"18477","report_state":"RI","report_number":"0084001191","insp_date":"2023-06-08 00:00:00","insp_start_time":"1135","insp_end_time":"1203","registration_date":"2023-06-21 00:00:00","region":"ET","ci_status_code":"C","location":"55","location_desc":"RT 195E","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"ADUSA TRANSPORTATION","shipping_paper_number":"572716","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-30 21:44: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":"82621","transaction_code":"C","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-08-30 21:44:00","snet_input_date":"2023-06-09 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[{"id":5005522,"change_date":"2023-08-30 21:44:00","inspection_id":"78848467","insp_violation_id":"254968364","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196801654","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:18.000000Z","updated_at":"2025-03-17T21:30:18.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":5220958,"change_date":"2023-08-30 21:44:00","inspection_id":"78848467","insp_unit_id":"196801654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2316477","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMMN7GH106740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"}]},{"id":3103609,"change_date":"2023-08-24 21:41:00","inspection_id":"78687316","dot_number":"18477","report_state":"RI","report_number":"00LR003114","insp_date":"2023-05-21 00:00:00","insp_start_time":"0839","insp_end_time":"0902","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"AIRPORT CONNECTOR, WARWICK","county_code_state":"RI","county_code":"003","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":"Y","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-08-24 21:41: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":"82377","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-08-24 21:41:00","snet_input_date":"2023-05-21 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:33.000000Z","updated_at":"2025-03-17T19:24:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4991678,"change_date":"2023-08-24 21:41:00","inspection_id":"78687316","insp_unit_id":"196703026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"248269","insp_unit_license":"2924104","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN1LL859009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:21.000000Z","updated_at":"2025-03-17T22:42:21.000000Z"}]},{"id":3077682,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","dot_number":"18477","report_state":"RI","report_number":"00ZM000108","insp_date":"2023-05-18 00:00:00","insp_start_time":"1015","insp_end_time":"1104","registration_date":"2023-06-01 00:00:00","region":"ET","ci_status_code":"C","location":"121","location_desc":"RT 146S @ WEIGH STATION","county_code_state":"RI","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"TOURTELLOT AND CO INC","shipping_paper_number":"00644523","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":"I","final_status_date":"2023-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"82347","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-08-22 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-18 21:42:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:49.000000Z","updated_at":"2025-03-17T19:23:49.000000Z","inspection_violations":[{"id":4730367,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","insp_violation_id":"254792607","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196654131","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39347E"},{"id":4730368,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","insp_violation_id":"254792608","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196654131","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39353B"},{"id":4730369,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","insp_violation_id":"254792609","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196654131","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3963A1"},{"id":4730370,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","insp_violation_id":"254792610","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196654131","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4950465,"change_date":"2023-08-22 21:42:00","inspection_id":"78658170","insp_unit_id":"196654131","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INOR","insp_unit_company":"184540","insp_unit_license":"2599570","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMMN9JH214168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:03.000000Z","updated_at":"2025-03-17T22:42:03.000000Z"}]},{"id":3049886,"change_date":"2023-08-11 21:38:00","inspection_id":"78627019","dot_number":"18477","report_state":"RI","report_number":"502C000409","insp_date":"2023-05-16 00:00:00","insp_start_time":"1132","insp_end_time":"1158","registration_date":"2023-06-06 00:00:00","region":"ET","ci_status_code":"C","location":"505","location_desc":"RTE 95 WEIGH STATION (NB)","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"82061","transaction_code":"C","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-08-11 21:38:00","snet_input_date":"2023-05-16 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-05-16 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:23.000000Z","updated_at":"2025-03-17T19:23:23.000000Z","inspection_violations":[{"id":4687702,"change_date":"2023-08-11 21:38:00","inspection_id":"78627019","insp_violation_id":"254598568","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196482377","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4906501,"change_date":"2023-08-11 21:38:00","inspection_id":"78627019","insp_unit_id":"196482377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"600","insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:41.000000Z","updated_at":"2025-03-17T22:41:41.000000Z"}]},{"id":2882376,"change_date":"2023-07-24 21:41:00","inspection_id":"78437547","dot_number":"18477","report_state":"RI","report_number":"0084001008","insp_date":"2023-04-21 00:00:00","insp_start_time":"1222","insp_end_time":"1242","registration_date":"2023-05-04 00:00:00","region":"ET","ci_status_code":"C","location":"109","location_desc":"ROUTE 37 WEST","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CONFREDA GRENNHOUSES-FARMS LLC","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-24 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":"81750","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-04-25 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-04-25 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVENUE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:02.000000Z","updated_at":"2025-03-17T19:20:02.000000Z","inspection_violations":[{"id":4423980,"change_date":"2023-07-24 21:41:00","inspection_id":"78437547","insp_violation_id":"254225077","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:39.000000Z","updated_at":"2025-03-17T21:27:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4637337,"change_date":"2023-07-24 21:41:00","inspection_id":"78437547","insp_unit_id":"196146059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T34540","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC8KDKE2349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:35.000000Z","updated_at":"2025-03-17T22:39:35.000000Z"}]},{"id":2712159,"change_date":"2023-06-13 21:41:00","inspection_id":"78244894","dot_number":"18477","report_state":"RI","report_number":"00JT002883","insp_date":"2023-03-26 00:00:00","insp_start_time":"0722","insp_end_time":"0752","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PONTIAC AVE","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"639906","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-01 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"81302","transaction_code":"C","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-04-01 21:30:00","snet_input_date":"2023-03-26 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-04-01 21:30:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:37.000000Z","updated_at":"2025-03-17T19:16:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4364928,"change_date":"2023-06-13 21:41:00","inspection_id":"78244894","insp_unit_id":"195461654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"631306","insp_unit_license":"33004","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE5JDJJ9297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:21.000000Z","updated_at":"2025-03-17T22:37:21.000000Z"}]},{"id":2581842,"change_date":"2023-03-21 21:41:00","inspection_id":"78096008","dot_number":"18477","report_state":"MA","report_number":"CQ00002785","insp_date":"2023-03-15 00:00:00","insp_start_time":"0750","insp_end_time":"0845","registration_date":"2023-03-21 00:00:00","region":"ET","ci_status_code":"C","location":"145H","location_desc":"H-HINGHAM","county_code_state":"MA","county_code":"023","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":"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":"2023-03-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"462192","transaction_code":"C","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-03-15 21:41:00","snet_input_date":"2023-03-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-15 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:26.000000Z","updated_at":"2025-03-17T19:14:26.000000Z","inspection_violations":[{"id":3972081,"change_date":"2023-03-21 21:41:00","inspection_id":"78096008","insp_violation_id":"251770173","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193970265","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:37.000000Z","updated_at":"2025-03-17T21:25:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4155549,"change_date":"2023-03-21 21:41:00","inspection_id":"78096008","insp_unit_id":"193970265","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":null,"insp_unit_license":"2735740","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAMMMMN2KL589492","insp_unit_decal":"Y","insp_unit_decal_number":"32402411","created_at":"2025-03-17T22:35:48.000000Z","updated_at":"2025-03-17T22:35:48.000000Z"}]},{"id":2528692,"change_date":"2023-03-13 21:41:00","inspection_id":"78035323","dot_number":"18477","report_state":"CT","report_number":"3067002682","insp_date":"2023-03-08 00:00:00","insp_start_time":"1015","insp_end_time":"1032","registration_date":"2023-03-13 00:00:00","region":"ET","ci_status_code":"C","location":"081","location_desc":"MIDDLEBURY","county_code_state":"CT","county_code":"009","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":"2023-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"668797","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2023-03-08 21:40:00","snet_input_date":"2023-03-08 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-03-08 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:20.000000Z","updated_at":"2025-03-17T19:13:20.000000Z","inspection_violations":[{"id":3887168,"change_date":"2023-03-13 21:41:00","inspection_id":"78035323","insp_violation_id":"251608471","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193823911","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4070144,"change_date":"2023-03-13 21:41:00","inspection_id":"78035323","insp_unit_id":"193823911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"245378","insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:11.000000Z","updated_at":"2025-03-17T22:35:11.000000Z"}]},{"id":2406349,"change_date":"2023-05-16 21:41:00","inspection_id":"77896206","dot_number":"18477","report_state":"RI","report_number":"00LR002822","insp_date":"2023-02-15 00:00:00","insp_start_time":"1109","insp_end_time":"1134","registration_date":"2023-03-07 00:00:00","region":"ET","ci_status_code":"C","location":"65","location_desc":"RT 95N @ EXIT 13 (AIRPORT CON)","county_code_state":"RI","county_code":"003","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":"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-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"80571","transaction_code":"C","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-15 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:03.000000Z","updated_at":"2025-03-17T19:11:03.000000Z","inspection_violations":[{"id":3704456,"change_date":"2023-05-16 21:41:00","inspection_id":"77896206","insp_violation_id":"252848275","seq_no":"1","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":null,"created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3872134,"change_date":"2023-05-16 21:41:00","inspection_id":"77896206","insp_unit_id":"194942817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"245378","insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2177069,"change_date":"2023-04-14 21:41:00","inspection_id":"77634714","dot_number":"18477","report_state":"RI","report_number":"00DP002289","insp_date":"2023-01-17 00:00:00","insp_start_time":"1403","insp_end_time":"1434","registration_date":"2023-02-02 00:00:00","region":"ET","ci_status_code":"C","location":"31","location_desc":"RT 95S @ EXIT 17 (ELMWOOD AVE)","county_code_state":"RI","county_code":"007","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"80284","transaction_code":"C","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-01-19 21:43:00","snet_input_date":"2023-01-17 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-01-19 21:43:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:39.000000Z","updated_at":"2025-03-17T19:06:39.000000Z","inspection_violations":[{"id":3364341,"change_date":"2023-04-14 21:41:00","inspection_id":"77634714","insp_violation_id":"252227266","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:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3922"},{"id":3364342,"change_date":"2023-04-14 21:41:00","inspection_id":"77634714","insp_violation_id":"252227267","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"194388665","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":3503651,"change_date":"2023-04-14 21:41:00","inspection_id":"77634714","insp_unit_id":"194388665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"248286","insp_unit_license":"2924653","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN0LL859017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:07.000000Z","updated_at":"2025-03-17T22:31:07.000000Z"}]},{"id":2124403,"change_date":"2023-01-12 21:41:00","inspection_id":"77574050","dot_number":"18477","report_state":"MA","report_number":"CM00003362","insp_date":"2023-01-12 00:00:00","insp_start_time":"1005","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":"067H","location_desc":"H-CHELSEA","county_code_state":"MA","county_code":"025","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":"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-01-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"458623","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2023-01-12 21:41:00","snet_input_date":"2023-01-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-12 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:51.000000Z","updated_at":"2025-03-17T19:05:51.000000Z","inspection_violations":[{"id":3286299,"change_date":"2023-01-12 21:41:00","inspection_id":"77574050","insp_violation_id":"250524246","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:34.000000Z","updated_at":"2025-03-17T21:22:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3419082,"change_date":"2023-01-12 21:41:00","inspection_id":"77574050","insp_unit_id":"192829067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"34011","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE1JDJJ9295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:30.000000Z","updated_at":"2025-03-17T22:30:30.000000Z"}]},{"id":1724596,"change_date":"2023-03-13 21:41:00","inspection_id":"77116646","dot_number":"18477","report_state":"RI","report_number":"00LR002623","insp_date":"2022-11-11 00:00:00","insp_start_time":"0829","insp_end_time":"0903","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PONTIAC AVE, CRANSTON","county_code_state":"RI","county_code":"007","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18477","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":"79487","transaction_code":"C","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-11 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2774161,"change_date":"2023-03-13 21:41:00","inspection_id":"77116646","insp_unit_id":"193826133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"681303","insp_unit_license":"32798","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFEXJDJJ9294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1683416,"change_date":"2023-03-13 21:41:00","inspection_id":"77069450","dot_number":"18477","report_state":"RI","report_number":"0084000555","insp_date":"2022-11-05 00:00:00","insp_start_time":"0945","insp_end_time":"1011","registration_date":null,"region":"ET","ci_status_code":"C","location":"109","location_desc":"RT 295S @ EXIT 18 (RT 146)","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"DAVE'S MARKET PLACE","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":"I","final_status_date":"2022-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"79432","transaction_code":"C","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-11-07 21:40:00","snet_input_date":"2022-11-07 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-11-07 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:44.000000Z","updated_at":"2025-03-17T18:57:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2708049,"change_date":"2023-03-13 21:41:00","inspection_id":"77069450","insp_unit_id":"193826109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"33004","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE5JDJJ9297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:33.000000Z","updated_at":"2025-03-17T22:25:33.000000Z"}]},{"id":1280312,"change_date":"2022-09-14 21:39:00","inspection_id":"76603253","dot_number":"18477","report_state":"NY","report_number":"SPK0174134","insp_date":"2022-09-01 00:00:00","insp_start_time":"1020","insp_end_time":"1035","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-09-14 21:39: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":"2748373","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-09-14 21:39:00","snet_input_date":"2022-09-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-14 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:25.000000Z","updated_at":"2025-03-17T18:50:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2060488,"change_date":"2022-09-14 21:39:00","inspection_id":"76603253","insp_unit_id":"190885371","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:09.000000Z","updated_at":"2025-03-17T22:21:09.000000Z"}]},{"id":1140907,"change_date":"2022-08-26 21:39:00","inspection_id":"76441964","dot_number":"18477","report_state":"CT","report_number":"3067002273","insp_date":"2022-08-26 00:00:00","insp_start_time":"0805","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH","county_code_state":"CT","county_code":"001","insp_level_id":"1","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-26 21:39: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":"652727","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2022-08-26 21:39:00","snet_input_date":"2022-08-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-26 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:52.000000Z","updated_at":"2025-03-17T18:47:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1834712,"change_date":"2022-08-26 21:39:00","inspection_id":"76441964","insp_unit_id":"190555792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"245378","insp_unit_license":"3067895","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"Y","insp_unit_decal_number":"31730594","created_at":"2025-03-17T22:19:38.000000Z","updated_at":"2025-03-17T22:19:38.000000Z"}]},{"id":1454564,"change_date":"2022-12-15 21:38:00","inspection_id":"76805894","dot_number":"18477","report_state":"RI","report_number":"00CB003090","insp_date":"2022-08-24 00:00:00","insp_start_time":"0541","insp_end_time":"0614","registration_date":null,"region":"CT","ci_status_code":"C","location":"87","location_desc":"RT 295N @ EXIT 7","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"78154","transaction_code":"C","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-10-06 21:39:00","snet_input_date":"2022-10-03 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2341549,"change_date":"2022-12-15 21:38:00","inspection_id":"76805894","insp_unit_id":"192438897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"33004","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE5JDJJ9297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":613749,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","dot_number":"18477","report_state":"RI","report_number":"00DP001642","insp_date":"2022-06-14 00:00:00","insp_start_time":"1008","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"38","location_desc":"RT 95S @ EXIT 21 (ATWELLS AVE)","county_code_state":"RI","county_code":"007","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":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"26000","viol_total":"7","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":"77381","transaction_code":"C","transaction_date":"2022-10-18 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-06-15 21:40:00","snet_input_date":"2022-06-14 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-06-15 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:28.000000Z","updated_at":"2025-03-17T18:38:28.000000Z","inspection_violations":[{"id":964753,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090428","seq_no":"1","part_no":"393","part_no_section":"80","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39380"},{"id":964754,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090429","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"3965B"},{"id":964755,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090430","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39348A"},{"id":964756,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090431","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"393201A"},{"id":964757,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090432","seq_no":"5","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"393201A"},{"id":964758,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090433","seq_no":"6","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"393201A"},{"id":964759,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_violation_id":"249090434","seq_no":"7","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"191493411","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":987004,"change_date":"2022-10-18 21:39:00","inspection_id":"75824359","insp_unit_id":"191493411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"684118","insp_unit_license":"2571772","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMML6JH534451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"}]},{"id":556268,"change_date":"2022-06-13 21:41:00","inspection_id":"75755942","dot_number":"18477","report_state":"CT","report_number":"3026000349","insp_date":"2022-06-07 00:00:00","insp_start_time":"1152","insp_end_time":"1253","registration_date":"2022-06-10 00:00:00","region":"ET","ci_status_code":"C","location":"152SN","location_desc":"WATERFORD SCALE N\/B","county_code_state":"CT","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"9856958","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-06-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"645883","transaction_code":"C","transaction_date":"2022-06-07 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2022-06-07 21:38:00","snet_input_date":"2022-06-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-07 21:38:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:29.000000Z","updated_at":"2025-03-17T18:37:29.000000Z","inspection_violations":[{"id":874412,"change_date":"2022-06-13 21:41:00","inspection_id":"75755942","insp_violation_id":"246398038","seq_no":"1","part_no":"395","part_no_section":"22(h)(1)","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-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39522H1"},{"id":874413,"change_date":"2022-06-13 21:41:00","inspection_id":"75755942","insp_violation_id":"246398039","seq_no":"2","part_no":"395","part_no_section":"22(h)(3)","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-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39522H3"},{"id":874414,"change_date":"2022-06-13 21:41:00","inspection_id":"75755942","insp_violation_id":"246398040","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189194134","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":895013,"change_date":"2022-06-13 21:41:00","inspection_id":"75755942","insp_unit_id":"189194134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"245378","insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:43.000000Z","updated_at":"2025-03-17T22:13:43.000000Z"}]},{"id":441214,"change_date":"2022-11-17 21:40:00","inspection_id":"75618963","dot_number":"18477","report_state":"RI","report_number":"00DM000124","insp_date":"2022-05-19 00:00:00","insp_start_time":"1442","insp_end_time":"1528","registration_date":"2022-11-17 00:00:00","region":"ET","ci_status_code":"C","location":"58","location_desc":"RT 95N @ WEIGH STATION","county_code_state":"RI","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"77131","transaction_code":"C","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-05-20 21:40:00","snet_input_date":"2022-05-20 00:00:00","source_office":"1RIS001","mcmis_add_date":"2022-05-20 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[{"id":696836,"change_date":"2022-11-17 21:40:00","inspection_id":"75618963","insp_violation_id":"249654545","seq_no":"1","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"1","insp_unit_id":"192003351","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:15.000000Z","updated_at":"2025-03-17T21:10:15.000000Z","normalized_code":"393201B"}],"inspection_per_units":[{"id":711078,"change_date":"2022-11-17 21:40:00","inspection_id":"75618963","insp_unit_id":"192003351","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3067895","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN7LL899580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"}]},{"id":413089,"change_date":"2022-05-18 21:43:00","inspection_id":"75585686","dot_number":"18477","report_state":"US","report_number":"1695000123","insp_date":"2022-05-17 00:00:00","insp_start_time":"1038","insp_end_time":"1102","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-95 NORTH WEIGH STATION","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"00054709","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":"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":"35381","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1MDD001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":666928,"change_date":"2022-05-18 21:43:00","inspection_id":"75585686","insp_unit_id":"188744032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2924058","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAEUMMN8LL899684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":390898,"change_date":"2022-06-17 21:39:00","inspection_id":"75558937","dot_number":"18477","report_state":"ME","report_number":"3969003506","insp_date":"2022-05-16 00:00:00","insp_start_time":"1049","insp_end_time":"1119","registration_date":"2022-06-08 00:00:00","region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"346181","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":"M","census_search_date":"2022-05-16 21:42:00","snet_input_date":"2022-05-16 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-16 21:42:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:25.000000Z","updated_at":"2025-03-17T18:34:25.000000Z","inspection_violations":[{"id":610857,"change_date":"2022-06-17 21:39:00","inspection_id":"75558937","insp_violation_id":"246540225","seq_no":"1","part_no":"395","part_no_section":"24(d)","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-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":631482,"change_date":"2022-06-17 21:39:00","inspection_id":"75558937","insp_unit_id":"189312656","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"681304","insp_unit_license":"34011","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"3ALHCYFE1JDJJ9295","insp_unit_decal":"Y","insp_unit_decal_number":"32389867","created_at":"2025-03-17T22:12:04.000000Z","updated_at":"2025-03-17T22:12:04.000000Z"}]},{"id":183796,"change_date":"2022-04-15 21:37:00","inspection_id":"75312199","dot_number":"18477","report_state":"ME","report_number":"1121008112","insp_date":"2022-04-15 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"00607993","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"344481","transaction_code":"A","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2022-04-15 21:37:00","snet_input_date":"2022-04-15 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":280005,"change_date":"2022-04-15 21:37:00","inspection_id":"75312199","insp_violation_id":"245181609","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"38323A2"},{"id":280006,"change_date":"2022-04-15 21:37:00","inspection_id":"75312199","insp_violation_id":"245181610","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188173129","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5056377","created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"3922"},{"id":280007,"change_date":"2022-04-15 21:37:00","inspection_id":"75312199","insp_violation_id":"245181611","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":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":297642,"change_date":"2022-04-15 21:37:00","inspection_id":"75312199","insp_unit_id":"188173129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T34540","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC8KDKE2349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:59.000000Z","updated_at":"2025-03-17T22:09:59.000000Z"}]},{"id":48487,"change_date":"2022-03-28 21:40:00","inspection_id":"75147348","dot_number":"18477","report_state":"CT","report_number":"3078000838","insp_date":"2022-03-26 00:00:00","insp_start_time":"1026","insp_end_time":"1051","registration_date":null,"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":"SAME","shipping_paper_number":"NONE PROVIDE","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-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"641041","transaction_code":"A","transaction_date":"2022-03-26 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00018477","upload_search_indicator":null,"census_search_date":"2022-03-28 21:40:00","snet_input_date":"2022-03-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-03-28 21:40:00","insp_carrier_name":"TOURTELLOT & CO INC","insp_carrier_street":"99 COLORADO AVE","insp_carrier_city":"WARWICK","insp_carrier_state":"RI","insp_carrier_zip_code":"02888","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:26.000000Z","updated_at":"2025-03-17T18:28:26.000000Z","inspection_violations":[{"id":68942,"change_date":"2022-03-28 21:40:00","inspection_id":"75147348","insp_violation_id":"244795693","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"39216A"},{"id":68943,"change_date":"2022-03-28 21:40:00","inspection_id":"75147348","insp_violation_id":"244795694","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187836669","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"Y9880585","created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":78282,"change_date":"2022-03-28 21:40:00","inspection_id":"75147348","insp_unit_id":"187836669","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTC","insp_unit_company":"815091","insp_unit_license":"2923866","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HAMMMMN4KL589459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:44.000000Z","updated_at":"2025-03-17T22:08:44.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/18477\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/18477\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/18477\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/18477\/inspections","per_page":100,"prev_page_url":null,"to":54,"total":54}