{"current_page":1,"data":[{"id":12170693,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","dot_number":"24531","report_state":"CT","report_number":"3081A00723","insp_date":"2026-06-12 00:00:00","insp_start_time":"0515","insp_end_time":"0657","registration_date":"2026-06-29 00:00:00","region":"ES","ci_status_code":"C","location":"145S","location_desc":"CT","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELLOGLOW","shipping_paper_number":"SO5245304","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125800","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":"3528346","transaction_code":"C","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:30.000000Z","updated_at":"2026-07-10T09:30:29.000000Z","inspection_violations":[{"id":21181445,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_violation_id":"275193523","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214348864","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-16T10:05:52.000000Z","updated_at":"2026-07-10T09:42:12.000000Z","normalized_code":"39375A3TAOL"},{"id":21181446,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_violation_id":"275193524","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214348864","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:52.000000Z","updated_at":"2026-07-10T09:42:12.000000Z","normalized_code":"39345B2BAIR"},{"id":21181447,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_violation_id":"275193525","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214348864","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:52.000000Z","updated_at":"2026-07-10T09:42:12.000000Z","normalized_code":"39345B2BAIR"},{"id":21181448,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_violation_id":"275193526","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"214348864","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:52.000000Z","updated_at":"2026-07-10T09:42:12.000000Z","normalized_code":"39345DB"},{"id":21181449,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_violation_id":"275193527","seq_no":"5","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"2","insp_unit_id":"214348863","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:52.000000Z","updated_at":"2026-07-10T09:42:12.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":21140545,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_unit_id":"214348864","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915","insp_unit_license":"5953A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV8KLKE3031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:31.000000Z","updated_at":"2026-07-10T09:01:34.000000Z"},{"id":21140546,"change_date":"2026-06-29 21:42:00","inspection_id":"88125221","insp_unit_id":"214348863","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"SFSZ 1669","insp_unit_license":"5339729","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"EH800620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:31.000000Z","updated_at":"2026-07-10T09:01:34.000000Z"}]},{"id":12135765,"change_date":"2026-06-09 21:42:00","inspection_id":"88082143","dot_number":"24531","report_state":"CT","report_number":"3063007669","insp_date":"2026-06-09 00:00:00","insp_start_time":"0750","insp_end_time":"0830","registration_date":null,"region":"ES","ci_status_code":"C","location":"145S","location_desc":"CT","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELLOGLOW CORPORATION","shipping_paper_number":"S05248528","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"3499863","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-06-09 21:42:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:40:00.000000Z","updated_at":"2026-06-20T09:32:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21083974,"change_date":"2026-06-09 21:42:00","inspection_id":"88082143","insp_unit_id":"213987456","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-55","insp_unit_license":"1AF45A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE9SHVZ8433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:49.000000Z","updated_at":"2026-06-20T09:04:29.000000Z"}]},{"id":11728756,"change_date":"2026-04-23 21:39:00","inspection_id":"87656676","dot_number":"24531","report_state":"RI","report_number":"0198000109","insp_date":"2026-04-18 00:00:00","insp_start_time":"0804","insp_end_time":"0849","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":"YELLOGLOW","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":"U","pen_cen_match":"I","final_status_date":"2026-04-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"3201094","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:56.000000Z","updated_at":"2026-05-04T09:30:44.000000Z","inspection_violations":[{"id":20390634,"change_date":"2026-04-23 21:39:00","inspection_id":"87656676","insp_violation_id":"273797881","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213175972","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:01:30.000000Z","updated_at":"2026-05-04T09:42:32.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":20408443,"change_date":"2026-04-23 21:39:00","inspection_id":"87656676","insp_unit_id":"213175972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3468B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0LHLT9119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:19:09.000000Z","updated_at":"2026-05-04T09:03:26.000000Z"}]},{"id":11568497,"change_date":"2026-04-04 21:34:00","inspection_id":"87492210","dot_number":"24531","report_state":"RI","report_number":"M022000131","insp_date":"2026-03-30 00:00:00","insp_start_time":"0712","insp_end_time":"0739","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH KINGSTOWN 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":"2026-04-04 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"3114089","transaction_code":"A","transaction_date":"2026-04-04 00:00:00","upload_date":"2026-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-04-04 21:34:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-04 21:34:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-07T09:46:01.000000Z","updated_at":"2026-04-15T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19826108,"change_date":"2026-04-04 21:34:00","inspection_id":"87492210","insp_unit_id":"212540602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1AF45A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE9SHVZ8433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-07T09:33:37.000000Z","updated_at":"2026-04-15T09:07:16.000000Z"}]},{"id":12148512,"change_date":"2026-06-10 21:44:00","inspection_id":"88097422","dot_number":"24531","report_state":"NH","report_number":"0963000155","insp_date":"2026-03-19 00:00:00","insp_start_time":"1115","insp_end_time":"1133","registration_date":null,"region":"ED","ci_status_code":"C","location":"198","location_desc":"NH","county_code_state":"NH","county_code":"015","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":"N","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":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"3509668","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:28.000000Z","updated_at":"2026-06-21T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21104799,"change_date":"2026-06-10 21:44:00","inspection_id":"88097422","insp_unit_id":"214016079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"H-49","insp_unit_license":"1AD65F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYCY0FDGL6337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:54.000000Z","updated_at":"2026-06-21T09:02:19.000000Z"}]},{"id":11230613,"change_date":"2026-02-26 21:40:00","inspection_id":"87142784","dot_number":"24531","report_state":"CT","report_number":"3129006533","insp_date":"2026-02-26 00:00:00","insp_start_time":"0735","insp_end_time":"0753","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"766284","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:47.000000Z","updated_at":"2026-03-09T09:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19197507,"change_date":"2026-02-26 21:40:00","inspection_id":"87142784","insp_unit_id":"211840443","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AF45A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE9SHVZ8433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:36.000000Z","updated_at":"2026-03-09T09:05:10.000000Z"}]},{"id":12149550,"change_date":"2026-06-10 21:44:00","inspection_id":"88098592","dot_number":"24531","report_state":"NH","report_number":"1274003860","insp_date":"2026-01-27 00:00:00","insp_start_time":"0802","insp_end_time":"0830","registration_date":null,"region":"ES","ci_status_code":"C","location":"200","location_desc":"NH","county_code_state":"NH","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":"N","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":"2026-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"3510481","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2026-06-10 21:44:00","snet_input_date":"2026-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:44:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:30.000000Z","updated_at":"2026-06-21T09:31:19.000000Z","inspection_violations":[{"id":21145992,"change_date":"2026-06-10 21:44:00","inspection_id":"88098592","insp_violation_id":"274818779","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":"2026-06-13T10:02:42.000000Z","updated_at":"2026-06-21T09:45:40.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":21106031,"change_date":"2026-06-10 21:44:00","inspection_id":"88098592","insp_unit_id":"214017516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"H-51","insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:17:57.000000Z","updated_at":"2026-06-21T09:02:28.000000Z"}]},{"id":10624512,"change_date":"2026-01-12 21:39:00","inspection_id":"86765138","dot_number":"24531","report_state":"MA","report_number":"CP00005923","insp_date":"2026-01-11 00:00:00","insp_start_time":"1006","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"538028","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2026-01-12 21:39:00","snet_input_date":"2026-01-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-12 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-15T10:37:02.000000Z","updated_at":"2026-01-23T10:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17816766,"change_date":"2026-01-12 21:39:00","inspection_id":"86765138","insp_unit_id":"211026384","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"98933","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKYDP9X5GJ120773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:09:21.000000Z","updated_at":"2026-01-24T10:00:53.000000Z"},{"id":17816765,"change_date":"2026-01-12 21:39:00","inspection_id":"86765138","insp_unit_id":"211026383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"5953A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV8KLKE3031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-15T10:09:21.000000Z","updated_at":"2026-01-24T10:00:53.000000Z"}]},{"id":10608459,"change_date":"2026-01-09 21:38:00","inspection_id":"86748218","dot_number":"24531","report_state":"MA","report_number":"BV00008161","insp_date":"2026-01-09 00:00:00","insp_start_time":"0509","insp_end_time":"0526","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":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"537909","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:43.000000Z","updated_at":"2026-01-20T10:30:32.000000Z","inspection_violations":[{"id":17836140,"change_date":"2026-01-09 21:38:00","inspection_id":"86748218","insp_violation_id":"271106801","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-12T10:39:26.000000Z","updated_at":"2026-01-20T10:31:02.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":17785695,"change_date":"2026-01-09 21:38:00","inspection_id":"86748218","insp_unit_id":"210995441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:44.000000Z","updated_at":"2026-01-20T10:00:35.000000Z"}]},{"id":10494098,"change_date":"2026-01-16 21:39:00","inspection_id":"86628677","dot_number":"24531","report_state":"MA","report_number":"CQ00004752","insp_date":"2025-12-20 00:00:00","insp_start_time":"0729","insp_end_time":"0759","registration_date":"2026-01-16 00:00:00","region":"ET","ci_status_code":"C","location":"049H","location_desc":"H-BROCKTON","county_code_state":"MA","county_code":"023","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":"2025-12-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"536711","transaction_code":"C","transaction_date":"2025-12-22 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:40.000000Z","updated_at":"2026-01-27T10:30:05.000000Z","inspection_violations":[{"id":18020722,"change_date":"2026-01-16 21:39:00","inspection_id":"86628677","insp_violation_id":"271254701","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"211132641","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"906837AD","created_at":"2026-01-19T10:43:12.000000Z","updated_at":"2026-01-27T10:30:11.000000Z","normalized_code":"3922SLLTL"},{"id":18020723,"change_date":"2026-01-16 21:39:00","inspection_id":"86628677","insp_violation_id":"271254702","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"2","insp_unit_id":"211132642","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:12.000000Z","updated_at":"2026-01-27T10:30:11.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":18105627,"change_date":"2026-01-16 21:39:00","inspection_id":"86628677","insp_unit_id":"211132641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AE94T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJHTDV2SSWE7241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:19.000000Z","updated_at":"2026-01-27T10:00:07.000000Z"},{"id":18105628,"change_date":"2026-01-16 21:39:00","inspection_id":"86628677","insp_unit_id":"211132642","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-66","insp_unit_license":"39B2","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2481H2144802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:19.000000Z","updated_at":"2026-01-27T10:00:07.000000Z"}]},{"id":10175853,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","dot_number":"24531","report_state":"MA","report_number":"DQ00002877","insp_date":"2025-11-12 00:00:00","insp_start_time":"0543","insp_end_time":"0623","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"SO5152939","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-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"533715","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":"00024531","upload_search_indicator":"M","census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:36.000000Z","updated_at":"2025-11-16T10:30:35.000000Z","inspection_violations":[{"id":16897979,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","insp_violation_id":"269883801","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"209968890","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:54.000000Z","updated_at":"2025-11-16T10:31:05.000000Z","normalized_code":"3922SLL"},{"id":16897980,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","insp_violation_id":"269883802","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"2","insp_unit_id":"209968891","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:54.000000Z","updated_at":"2025-11-16T10:31:05.000000Z","normalized_code":"3922SLL"},{"id":16897981,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","insp_violation_id":"269883803","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:54.000000Z","updated_at":"2025-11-16T10:31:05.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":16945662,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","insp_unit_id":"209968890","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AG51M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV2LDLT9106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:31.000000Z","updated_at":"2025-11-16T10:00:39.000000Z"},{"id":16945663,"change_date":"2025-11-12 21:40:00","inspection_id":"86295435","insp_unit_id":"209968891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"SM93395","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GRAA06227B705459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:31.000000Z","updated_at":"2025-11-16T10:00:39.000000Z"}]},{"id":10140264,"change_date":"2025-11-25 21:38:00","inspection_id":"86257870","dot_number":"24531","report_state":"CT","report_number":"3066000755","insp_date":"2025-11-07 00:00:00","insp_start_time":"0811","insp_end_time":"0902","registration_date":"2025-11-25 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"S05150393","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-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"757288","transaction_code":"C","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:29.000000Z","updated_at":"2025-11-29T10:30:20.000000Z","inspection_violations":[{"id":17191813,"change_date":"2025-11-25 21:38:00","inspection_id":"86257870","insp_violation_id":"270275793","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210247049","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:33.000000Z","updated_at":"2025-11-29T10:30:21.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17167492,"change_date":"2025-11-25 21:38:00","inspection_id":"86257870","insp_unit_id":"210247049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-53","insp_unit_license":"1AH75Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFEXRHVA4968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:31.000000Z","updated_at":"2025-11-29T10:00:25.000000Z"}]},{"id":9938928,"change_date":"2025-10-14 21:42:00","inspection_id":"86045910","dot_number":"24531","report_state":"MA","report_number":"DQ00002787","insp_date":"2025-10-14 00:00:00","insp_start_time":"0524","insp_end_time":"0548","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"S05139623","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"531121","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-10-14 21:42:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:48.000000Z","updated_at":"2025-10-18T10:01:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16498013,"change_date":"2025-10-14 21:42:00","inspection_id":"86045910","insp_unit_id":"209463623","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-51","insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:54.000000Z","updated_at":"2025-10-18T09:46:22.000000Z"}]},{"id":9683066,"change_date":"2025-09-15 21:40:00","inspection_id":"85776854","dot_number":"24531","report_state":"MA","report_number":"DQ00002668","insp_date":"2025-09-14 00:00:00","insp_start_time":"1223","insp_end_time":"1307","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"528750","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-09-15 21:40:00","snet_input_date":"2025-09-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-15 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:32.000000Z","updated_at":"2025-09-18T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16026537,"change_date":"2025-09-15 21:40:00","inspection_id":"85776854","insp_unit_id":"208954453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-55","insp_unit_license":"1AF45A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE9SHVZ8433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:30.000000Z","updated_at":"2025-09-18T09:45:30.000000Z"}]},{"id":9580920,"change_date":"2025-09-15 21:40:00","inspection_id":"85669573","dot_number":"24531","report_state":"MA","report_number":"BV00999831","insp_date":"2025-09-03 00:00:00","insp_start_time":"0512","insp_end_time":"0530","registration_date":"2025-09-15 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","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":"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-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"527373","transaction_code":"C","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:26.000000Z","updated_at":"2025-09-18T10:00:20.000000Z","inspection_violations":[{"id":15870683,"change_date":"2025-09-15 21:40:00","inspection_id":"85669573","insp_violation_id":"268694924","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"208954371","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:20:34.000000Z","updated_at":"2025-09-18T10:20:34.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":16019461,"change_date":"2025-09-15 21:40:00","inspection_id":"85669573","insp_unit_id":"208954371","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:24.000000Z","updated_at":"2025-09-18T09:45:24.000000Z"}]},{"id":9564443,"change_date":"2025-09-09 21:40:00","inspection_id":"85652827","dot_number":"24531","report_state":"MA","report_number":"DZ00000857","insp_date":"2025-09-02 00:00:00","insp_start_time":"0407","insp_end_time":"0426","registration_date":"2025-09-09 00:00:00","region":"ET","ci_status_code":"C","location":"295H","location_desc":"H-SHARON","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"SO5120775","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-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"527205","transaction_code":"C","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-09-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:00.000000Z","updated_at":"2025-09-13T10:46:22.000000Z","inspection_violations":[{"id":15748584,"change_date":"2025-09-09 21:40:00","inspection_id":"85652827","insp_violation_id":"268549707","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:37.000000Z","normalized_code":"3922SLLS1"},{"id":15748585,"change_date":"2025-09-09 21:40:00","inspection_id":"85652827","insp_violation_id":"268549708","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208824032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:09.000000Z","updated_at":"2025-09-13T10:48:37.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":15903156,"change_date":"2025-09-09 21:40:00","inspection_id":"85652827","insp_unit_id":"208824032","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"912","insp_unit_license":"93512","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV1HLHV8551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:41.000000Z","updated_at":"2025-09-13T09:59:05.000000Z"},{"id":15903157,"change_date":"2025-09-09 21:40:00","inspection_id":"85652827","insp_unit_id":"208824033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-58","insp_unit_license":"93882","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2535EU946207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:41.000000Z","updated_at":"2025-09-13T09:59:05.000000Z"}]},{"id":9437302,"change_date":"2025-09-02 21:39:00","inspection_id":"85518805","dot_number":"24531","report_state":"MA","report_number":"EI00000046","insp_date":"2025-08-18 00:00:00","insp_start_time":"1235","insp_end_time":"1319","registration_date":"2025-09-02 00:00:00","region":"ET","ci_status_code":"C","location":"327H","location_desc":"H-SWANSEA","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"YELLOW-OGLOW","shipping_paper_number":"505114210","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-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"526039","transaction_code":"C","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:46.000000Z","updated_at":"2025-09-06T10:42:53.000000Z","inspection_violations":[{"id":15614570,"change_date":"2025-09-02 21:39:00","inspection_id":"85518805","insp_violation_id":"268393078","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208693614","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:07.000000Z","updated_at":"2025-09-06T10:47:07.000000Z","normalized_code":"39617CPI"},{"id":15614571,"change_date":"2025-09-02 21:39:00","inspection_id":"85518805","insp_violation_id":"268393079","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"2","insp_unit_id":"208693614","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:07.000000Z","updated_at":"2025-09-06T10:47:07.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":15781866,"change_date":"2025-09-02 21:39:00","inspection_id":"85518805","insp_unit_id":"208693613","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"917","insp_unit_license":"1AG52M","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV4LDLT9107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:09.000000Z","updated_at":"2025-09-09T09:47:09.000000Z"},{"id":15781867,"change_date":"2025-09-02 21:39:00","inspection_id":"85518805","insp_unit_id":"208693614","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-60","insp_unit_license":"92654","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2532CU268707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:09.000000Z","updated_at":"2025-09-09T09:47:09.000000Z"}]},{"id":9264454,"change_date":"2025-07-28 21:39:00","inspection_id":"85336993","dot_number":"24531","report_state":"MA","report_number":"DX00000515","insp_date":"2025-07-26 00:00:00","insp_start_time":"0731","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"164H","location_desc":"H-LAKEVILLE","county_code_state":"MA","county_code":"023","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":"2025-07-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"523994","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-07-28 21:39:00","snet_input_date":"2025-07-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-28 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:26.000000Z","updated_at":"2025-08-01T10:41:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15247467,"change_date":"2025-07-28 21:39:00","inspection_id":"85336993","insp_unit_id":"208110901","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AL41S","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE4SHWC8143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:30.000000Z","updated_at":"2025-08-01T09:45:30.000000Z"}]},{"id":9234709,"change_date":"2025-08-26 21:40:00","inspection_id":"85305784","dot_number":"24531","report_state":"MA","report_number":"EA00000177","insp_date":"2025-07-24 00:00:00","insp_start_time":"0729","insp_end_time":"0744","registration_date":"2025-08-26 00:00:00","region":"ET","ci_status_code":"C","location":"H","location_desc":"WILMINGTON","county_code_state":"MA","county_code":"017","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":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"523863","transaction_code":"C","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:50.000000Z","updated_at":"2025-09-05T10:46:13.000000Z","inspection_violations":[{"id":15505742,"change_date":"2025-08-26 21:40:00","inspection_id":"85305784","insp_violation_id":"268255883","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:35.000000Z","updated_at":"2025-09-05T10:49:35.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":15685962,"change_date":"2025-08-26 21:40:00","inspection_id":"85305784","insp_unit_id":"208587211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AE94T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJHTDV2SSWE7241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:35.000000Z","updated_at":"2025-09-05T09:45:29.000000Z"},{"id":15685963,"change_date":"2025-08-26 21:40:00","inspection_id":"85305784","insp_unit_id":"208587212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"39B2","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2481H2144802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:35.000000Z","updated_at":"2025-09-05T09:45:29.000000Z"}]},{"id":8871128,"change_date":"2025-06-11 21:42:00","inspection_id":"84922034","dot_number":"24531","report_state":"MA","report_number":"BV00007631","insp_date":"2025-06-11 00:00:00","insp_start_time":"0432","insp_end_time":"0449","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":"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":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"520059","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:59.000000Z","updated_at":"2025-06-15T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14529586,"change_date":"2025-06-11 21:42:00","inspection_id":"84922034","insp_unit_id":"207330104","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:09.000000Z","updated_at":"2025-06-15T09:45:42.000000Z"}]},{"id":8813887,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","dot_number":"24531","report_state":"MA","report_number":"CY00003575","insp_date":"2025-06-04 00:00:00","insp_start_time":"0847","insp_end_time":"0926","registration_date":"2025-06-17 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"519620","transaction_code":"C","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:04.000000Z","updated_at":"2025-06-22T10:00:15.000000Z","inspection_violations":[{"id":14300214,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_violation_id":"266891343","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"207427276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"39355D2B"},{"id":14300215,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_violation_id":"266891344","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"207427277","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"3939ALIL"},{"id":14300216,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_violation_id":"266891345","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207427277","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"39347E"},{"id":14300217,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_violation_id":"266891346","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"207427277","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":14610023,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_unit_id":"207427276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"928","insp_unit_license":"1AE94T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJHTDV2SSWE7241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:21.000000Z"},{"id":14610024,"change_date":"2025-06-17 21:41:00","inspection_id":"84861439","insp_unit_id":"207427277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-66","insp_unit_license":"SM39B2","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2481H2144802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:21.000000Z"}]},{"id":8740713,"change_date":"2025-05-27 21:38:00","inspection_id":"84784067","dot_number":"24531","report_state":"MA","report_number":"DA00003438","insp_date":"2025-05-25 00:00:00","insp_start_time":"0525","insp_end_time":"0537","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":"2025-05-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"518794","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-05-27 21:38:00","snet_input_date":"2025-05-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-27 21:38:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:24.000000Z","updated_at":"2025-05-31T10:00:23.000000Z","inspection_violations":[{"id":13950725,"change_date":"2025-05-27 21:38:00","inspection_id":"84784067","insp_violation_id":"266482237","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-05-30T10:15:39.000000Z","updated_at":"2025-05-31T10:17:08.000000Z","normalized_code":"3922SLLS1"},{"id":13950726,"change_date":"2025-05-27 21:38:00","inspection_id":"84784067","insp_violation_id":"266482238","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"207072085","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:39.000000Z","updated_at":"2025-05-31T10:17:08.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14291030,"change_date":"2025-05-27 21:38:00","inspection_id":"84784067","insp_unit_id":"207072084","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"917","insp_unit_license":"3073B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV4LDLT9107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:30.000000Z","updated_at":"2025-05-31T09:46:56.000000Z"},{"id":14291031,"change_date":"2025-05-27 21:38:00","inspection_id":"84784067","insp_unit_id":"207072085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"92654","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS24827U162101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:30.000000Z","updated_at":"2025-05-31T09:46:56.000000Z"}]},{"id":8636412,"change_date":"2025-05-15 21:42:00","inspection_id":"84673700","dot_number":"24531","report_state":"CT","report_number":"3013003341","insp_date":"2025-05-15 00:00:00","insp_start_time":"0736","insp_end_time":"0833","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":"SO5069733","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-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"740267","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-05-15 21:42:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-05-15 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-18T10:03:27.000000Z","updated_at":"2025-05-19T10:03:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14102688,"change_date":"2025-05-15 21:42:00","inspection_id":"84673700","insp_unit_id":"206865492","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915","insp_unit_license":"5953A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV8KLKE3031","insp_unit_decal":"Y","insp_unit_decal_number":"35261195","created_at":"2025-05-18T09:49:42.000000Z","updated_at":"2025-05-19T09:48:22.000000Z"},{"id":14102689,"change_date":"2025-05-15 21:42:00","inspection_id":"84673700","insp_unit_id":"206865493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T52","insp_unit_license":"SM98933","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2536AM092404","insp_unit_decal":"Y","insp_unit_decal_number":"35261196","created_at":"2025-05-18T09:49:42.000000Z","updated_at":"2025-05-19T09:48:22.000000Z"}]},{"id":8604064,"change_date":"2025-05-12 21:40:00","inspection_id":"84639889","dot_number":"24531","report_state":"MA","report_number":"DQ00002190","insp_date":"2025-05-12 00:00:00","insp_start_time":"0342","insp_end_time":"0427","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TROPICAL CASH","shipping_paper_number":"SO5068625","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-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"516963","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:08.000000Z","updated_at":"2025-05-17T10:04:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14045932,"change_date":"2025-05-12 21:40:00","inspection_id":"84639889","insp_unit_id":"206804210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:13.000000Z","updated_at":"2025-05-16T09:50:12.000000Z"}]},{"id":8424483,"change_date":"2025-04-21 21:39:00","inspection_id":"84450701","dot_number":"24531","report_state":"CT","report_number":"3120005279","insp_date":"2025-04-18 00:00:00","insp_start_time":"0855","insp_end_time":"0913","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":"SO5058655","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"737855","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-04-21 21:39:00","snet_input_date":"2025-04-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-04-21 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:02:17.000000Z","updated_at":"2025-04-26T10:21:40.000000Z","inspection_violations":[{"id":13295493,"change_date":"2025-04-21 21:39:00","inspection_id":"84450701","insp_violation_id":"265726878","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-04-24T10:18:10.000000Z","updated_at":"2025-04-25T10:29:58.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":13678871,"change_date":"2025-04-21 21:39:00","inspection_id":"84450701","insp_unit_id":"206404656","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"H42","insp_unit_license":"93812","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAN9BH314940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:47:38.000000Z","updated_at":"2025-04-25T09:48:57.000000Z"}]},{"id":8328739,"change_date":"2025-04-15 21:41:00","inspection_id":"84349722","dot_number":"24531","report_state":"MA","report_number":"DS00001715","insp_date":"2025-04-09 00:00:00","insp_start_time":"0556","insp_end_time":"0614","registration_date":"2025-04-15 00:00:00","region":"ET","ci_status_code":"C","location":"385H","location_desc":"H-WOBURN","county_code_state":"MA","county_code":"017","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":"2025-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"514381","transaction_code":"C","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-04-09 21:40:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:24:14.000000Z","updated_at":"2025-04-19T10:15:57.000000Z","inspection_violations":[{"id":13210757,"change_date":"2025-04-15 21:41:00","inspection_id":"84349722","insp_violation_id":"265630401","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-04-18T10:57:03.000000Z","updated_at":"2025-04-18T11:03:09.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":13601347,"change_date":"2025-04-15 21:41:00","inspection_id":"84349722","insp_unit_id":"206320588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"90980","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV3FSFZ7993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:11:24.000000Z","updated_at":"2025-04-19T09:56:11.000000Z"},{"id":13601348,"change_date":"2025-04-15 21:41:00","inspection_id":"84349722","insp_unit_id":"206320589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"SM98564","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2488AM092806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:11:24.000000Z","updated_at":"2025-04-19T09:56:11.000000Z"}]},{"id":8233356,"change_date":"2025-03-28 21:40:00","inspection_id":"84249258","dot_number":"24531","report_state":"CT","report_number":"1200000518","insp_date":"2025-03-28 00:00:00","insp_start_time":"0830","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"736133","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-03-28 21:40:00","snet_input_date":"2025-03-28 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-03-28 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-31T10:32:15.000000Z","updated_at":"2025-04-01T10:12:26.000000Z","inspection_violations":[{"id":12923638,"change_date":"2025-03-28 21:40:00","inspection_id":"84249258","insp_violation_id":"265305896","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206036809","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:00:39.000000Z","updated_at":"2025-03-31T11:05:57.000000Z","normalized_code":"39345DB"},{"id":12923639,"change_date":"2025-03-28 21:40:00","inspection_id":"84249258","insp_violation_id":"265305897","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206036809","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:00:39.000000Z","updated_at":"2025-03-31T11:05:57.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":13319243,"change_date":"2025-03-28 21:40:00","inspection_id":"84249258","insp_unit_id":"206036809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H56","insp_unit_license":"1AF93R","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE2SHWC8142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:11:21.000000Z","updated_at":"2025-04-01T09:48:41.000000Z"}]},{"id":8177757,"change_date":"2025-05-01 21:41:00","inspection_id":"84190826","dot_number":"24531","report_state":"NH","report_number":"1291004125","insp_date":"2025-03-20 00:00:00","insp_start_time":"0843","insp_end_time":"0913","registration_date":"2025-05-01 00:00:00","region":"ET","ci_status_code":"C","location":"029","location_desc":"MARLBORO","county_code_state":"NH","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"SO5046378","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-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"283507","transaction_code":"C","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:57.000000Z","updated_at":"2025-05-05T10:12:26.000000Z","inspection_violations":[{"id":13492984,"change_date":"2025-05-01 21:41:00","inspection_id":"84190826","insp_violation_id":"265951093","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206593597","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-03T11:22:47.000000Z","updated_at":"2025-05-04T10:54:53.000000Z","normalized_code":"3922SLLSR"},{"id":13492985,"change_date":"2025-05-01 21:41:00","inspection_id":"84190826","insp_violation_id":"265951094","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"206593597","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-03T11:22:47.000000Z","updated_at":"2025-05-04T10:54:53.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":13854169,"change_date":"2025-05-01 21:41:00","inspection_id":"84190826","insp_unit_id":"206593597","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H46","insp_unit_license":"3468B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0LHLT9119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:20:21.000000Z","updated_at":"2025-05-05T09:54:40.000000Z"}]},{"id":8019865,"change_date":"2025-03-04 21:39:00","inspection_id":"84024594","dot_number":"24531","report_state":"NH","report_number":"1085004589","insp_date":"2025-03-03 00:00:00","insp_start_time":"1020","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"103200","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":"282904","transaction_code":"A","transaction_date":"2025-03-03 00:00:00","upload_date":"2025-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-03-04 21:39:00","snet_input_date":"2025-03-03 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-03-04 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:33.000000Z","updated_at":"2025-03-17T21:04:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12947407,"change_date":"2025-03-04 21:39:00","inspection_id":"84024594","insp_unit_id":"205612860","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"919","insp_unit_license":"5572B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV5LDLT9794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:02.000000Z","updated_at":"2025-03-17T23:58:02.000000Z"},{"id":12947408,"change_date":"2025-03-04 21:39:00","inspection_id":"84024594","insp_unit_id":"205612861","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T47","insp_unit_license":"95641","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS248X9U802803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:02.000000Z","updated_at":"2025-03-17T23:58:02.000000Z"}]},{"id":7990722,"change_date":"2025-02-28 21:41:00","inspection_id":"83994013","dot_number":"24531","report_state":"MA","report_number":"DA00003126","insp_date":"2025-02-27 00:00:00","insp_start_time":"0418","insp_end_time":"0430","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":"CARRIER","shipping_paper_number":"INTERNAL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"510838","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:05.000000Z","updated_at":"2025-03-17T21:04:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12900284,"change_date":"2025-02-28 21:41:00","inspection_id":"83994013","insp_unit_id":"205558038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H48","insp_unit_license":"44363","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0MHMU4289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:31.000000Z","updated_at":"2025-03-17T23:57:31.000000Z"}]},{"id":7782689,"change_date":"2025-02-04 21:39:00","inspection_id":"83775781","dot_number":"24531","report_state":"NH","report_number":"1292002417","insp_date":"2025-02-03 00:00:00","insp_start_time":"1124","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OSSIPEE","county_code_state":"NH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"282083","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:53.000000Z","updated_at":"2025-03-17T20:59:53.000000Z","inspection_violations":[{"id":12161729,"change_date":"2025-02-04 21:39:00","inspection_id":"83775781","insp_violation_id":"264330166","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"25-887-000265","created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":12560026,"change_date":"2025-02-04 21:39:00","inspection_id":"83775781","insp_unit_id":"205149944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:44.000000Z","updated_at":"2025-03-17T23:53:44.000000Z"}]},{"id":7747226,"change_date":"2025-01-30 21:41:00","inspection_id":"83738299","dot_number":"24531","report_state":"MA","report_number":"DX00000045","insp_date":"2025-01-30 00:00:00","insp_start_time":"0923","insp_end_time":"0953","registration_date":null,"region":"ET","ci_status_code":"C","location":"164H","location_desc":"H-LAKEVILLE","county_code_state":"MA","county_code":"023","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":"2025-01-30 21:41: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":"508412","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:08.000000Z","updated_at":"2025-03-17T20:59:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12502313,"change_date":"2025-01-30 21:41:00","inspection_id":"83738299","insp_unit_id":"205080875","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-47","insp_unit_license":"5386B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYCY7FDGL4813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:58.000000Z","updated_at":"2025-03-17T23:52:58.000000Z"}]},{"id":7688507,"change_date":"2025-01-23 21:38:00","inspection_id":"83676648","dot_number":"24531","report_state":"CT","report_number":"3119002217","insp_date":"2025-01-23 00:00:00","insp_start_time":"1108","insp_end_time":"1151","registration_date":null,"region":"ET","ci_status_code":"C","location":"080","location_desc":"MERIDEN","county_code_state":"CT","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"DOLE","shipping_paper_number":"S05022240","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-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"730504","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-01-23 21:38:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-23 21:38:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:53.000000Z","updated_at":"2025-03-17T20:57:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12406382,"change_date":"2025-01-23 21:38:00","inspection_id":"83676648","insp_unit_id":"204966079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"927","insp_unit_license":"1AJ92P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJHTDV4SDVZ3448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:55.000000Z","updated_at":"2025-03-17T23:51:55.000000Z"},{"id":12406383,"change_date":"2025-01-23 21:38:00","inspection_id":"83676648","insp_unit_id":"204966080","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"SFSZ 4153","insp_unit_license":"521427","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1S12GC409NB672631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:55.000000Z","updated_at":"2025-03-17T23:51:55.000000Z"}]},{"id":7666192,"change_date":"2025-01-21 21:39:00","inspection_id":"83653316","dot_number":"24531","report_state":"CT","report_number":"3011001376","insp_date":"2025-01-21 00:00:00","insp_start_time":"0823","insp_end_time":"0843","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"SO5020823","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-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"730252","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-21 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12370399,"change_date":"2025-01-21 21:39:00","inspection_id":"83653316","insp_unit_id":"204923388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-53","insp_unit_license":"1AH75Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFEXRHVA4968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7554734,"change_date":"2025-01-06 21:39:00","inspection_id":"83536221","dot_number":"24531","report_state":"MA","report_number":"DQ00001710","insp_date":"2025-01-05 00:00:00","insp_start_time":"1003","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"506462","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12189579,"change_date":"2025-01-06 21:39:00","inspection_id":"83536221","insp_unit_id":"204664058","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"912","insp_unit_license":"93512","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV1HLHV8551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"},{"id":12189580,"change_date":"2025-01-06 21:39:00","inspection_id":"83536221","insp_unit_id":"204664059","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-50","insp_unit_license":"SM98564","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2488AM092806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7422186,"change_date":"2024-12-16 21:39:00","inspection_id":"83397030","dot_number":"24531","report_state":"CT","report_number":"0108000047","insp_date":"2024-12-14 00:00:00","insp_start_time":"1157","insp_end_time":"1232","registration_date":null,"region":"ET","ci_status_code":"C","location":"T084","location_desc":"I-91 NORTH, MIDDLETOWN","county_code_state":"CT","county_code":"007","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"726679","transaction_code":"A","transaction_date":"2024-12-14 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-12-16 21:39:00","snet_input_date":"2024-12-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-12-16 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:06.000000Z","updated_at":"2025-03-17T20:51:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11974240,"change_date":"2024-12-16 21:39:00","inspection_id":"83397030","insp_unit_id":"204395420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-54","insp_unit_license":"1AG69Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE5RDVJ4835","insp_unit_decal":"Y","insp_unit_decal_number":"34681220","created_at":"2025-03-17T23:47:11.000000Z","updated_at":"2025-03-17T23:47:11.000000Z"}]},{"id":7112421,"change_date":"2024-11-22 21:40:00","inspection_id":"83070199","dot_number":"24531","report_state":"MA","report_number":"CH00005564","insp_date":"2024-11-04 00:00:00","insp_start_time":"0900","insp_end_time":"1038","registration_date":"2024-11-22 00:00:00","region":"ET","ci_status_code":"C","location":"067S","location_desc":"S-CHELSEA","county_code_state":"MA","county_code":"025","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":"2024-11-04 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":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"502788","transaction_code":"C","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:17.000000Z","updated_at":"2025-03-17T20:44:17.000000Z","inspection_violations":[{"id":11107611,"change_date":"2024-11-22 21:40:00","inspection_id":"83070199","insp_violation_id":"263042103","seq_no":"1","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"204010643","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39355D1B"},{"id":11107612,"change_date":"2024-11-22 21:40:00","inspection_id":"83070199","insp_violation_id":"263042104","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204010643","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347E"},{"id":11107613,"change_date":"2024-11-22 21:40:00","inspection_id":"83070199","insp_violation_id":"263042105","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204010643","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":11471365,"change_date":"2024-11-22 21:40:00","inspection_id":"83070199","insp_unit_id":"204010643","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"79376","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2FZHCHDJ89AAL4271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:51.000000Z","updated_at":"2025-03-17T23:41:51.000000Z"}]},{"id":6762583,"change_date":"2024-09-20 21:41:00","inspection_id":"82698130","dot_number":"24531","report_state":"CT","report_number":"3132004940","insp_date":"2024-09-19 00:00:00","insp_start_time":"0622","insp_end_time":"0651","registration_date":"2024-09-20 00:00:00","region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":"SO4115142","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-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"718486","transaction_code":"C","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:18.000000Z","updated_at":"2025-03-17T20:37:18.000000Z","inspection_violations":[{"id":10531128,"change_date":"2024-09-20 21:41:00","inspection_id":"82698130","insp_violation_id":"261932952","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"203037316","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10904908,"change_date":"2024-09-20 21:41:00","inspection_id":"82698130","insp_unit_id":"203037315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"93512","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV1HLHV8551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"},{"id":10904909,"change_date":"2024-09-20 21:41:00","inspection_id":"82698130","insp_unit_id":"203037316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"95640","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS24839U802805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:56.000000Z","updated_at":"2025-03-17T23:35:56.000000Z"}]},{"id":6741630,"change_date":"2024-09-20 21:41:00","inspection_id":"82675735","dot_number":"24531","report_state":"CT","report_number":"3067A00049","insp_date":"2024-09-17 00:00:00","insp_start_time":"0656","insp_end_time":"0804","registration_date":"2024-09-20 00:00:00","region":"ET","ci_status_code":"C","location":"145","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORP","shipping_paper_number":"S04114243","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":"53220","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"718150","transaction_code":"C","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","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":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","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":[{"id":10497782,"change_date":"2024-09-20 21:41:00","inspection_id":"82675735","insp_violation_id":"261932903","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3903E"},{"id":10497783,"change_date":"2024-09-20 21:41:00","inspection_id":"82675735","insp_violation_id":"261932904","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203037283","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":10870889,"change_date":"2024-09-20 21:41:00","inspection_id":"82675735","insp_unit_id":"203037283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-53","insp_unit_license":"1AH75Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFEXRHVA4968","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":6719957,"change_date":"2024-09-13 21:41:00","inspection_id":"82652809","dot_number":"24531","report_state":"MA","report_number":"CY00002509","insp_date":"2024-09-13 00:00:00","insp_start_time":"0534","insp_end_time":"0550","registration_date":null,"region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MULTIPLE","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-09-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"499413","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2024-09-13 21:41:00","snet_input_date":"2024-09-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-13 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:09.000000Z","updated_at":"2025-03-17T20:36:09.000000Z","inspection_violations":[{"id":10461013,"change_date":"2024-09-13 21:41:00","inspection_id":"82652809","insp_violation_id":"261784977","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10835689,"change_date":"2024-09-13 21:41:00","inspection_id":"82652809","insp_unit_id":"202909930","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"922","insp_unit_license":"90981","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV8LDLZ7432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"},{"id":10835690,"change_date":"2024-09-13 21:41:00","inspection_id":"82652809","insp_unit_id":"202909931","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-47","insp_unit_license":"SM95641","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS248X9U802803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":6705241,"change_date":"2024-09-12 21:41:00","inspection_id":"82637141","dot_number":"24531","report_state":"CT","report_number":"3129005121","insp_date":"2024-09-12 00:00:00","insp_start_time":"0745","insp_end_time":"0839","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"SO4112312","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"717764","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-09-12 21:41:00","snet_input_date":"2024-09-12 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-09-12 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:04.000000Z","updated_at":"2025-03-17T20:36:04.000000Z","inspection_violations":[{"id":10437390,"change_date":"2024-09-12 21:41:00","inspection_id":"82637141","insp_violation_id":"261751634","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"202880303","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:31.000000Z","updated_at":"2025-03-17T21:56:31.000000Z","normalized_code":"39375A"},{"id":10437391,"change_date":"2024-09-12 21:41:00","inspection_id":"82637141","insp_violation_id":"261751635","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202880303","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:31.000000Z","updated_at":"2025-03-17T21:56:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10811901,"change_date":"2024-09-12 21:41:00","inspection_id":"82637141","insp_unit_id":"202880303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-46","insp_unit_license":"95640","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS24839U802805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:56.000000Z","updated_at":"2025-03-17T23:34:56.000000Z"},{"id":10811902,"change_date":"2024-09-12 21:41:00","inspection_id":"82637141","insp_unit_id":"202880304","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"915","insp_unit_license":"5953A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FUJGBDV8KLKE3031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:56.000000Z","updated_at":"2025-03-17T23:34:56.000000Z"}]},{"id":6642524,"change_date":"2024-09-04 21:41:00","inspection_id":"82570496","dot_number":"24531","report_state":"NH","report_number":"0940000806","insp_date":"2024-09-02 00:00:00","insp_start_time":"0904","insp_end_time":"0916","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 10\/KRIF ROAD KEENE","county_code_state":"NH","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":"2024-09-04 21:41: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":"278207","transaction_code":"A","transaction_date":"2024-09-02 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-09-04 21:41:00","snet_input_date":"2024-09-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-09-04 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:48.000000Z","updated_at":"2025-03-17T20:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10709414,"change_date":"2024-09-04 21:41:00","inspection_id":"82570496","insp_unit_id":"202747575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"H-43","insp_unit_license":"97321","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSSTR1GH232557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:53.000000Z","updated_at":"2025-03-17T23:33:53.000000Z"}]},{"id":6450091,"change_date":"2024-08-13 21:41:00","inspection_id":"82365379","dot_number":"24531","report_state":"CT","report_number":"3063006653","insp_date":"2024-08-13 00:00:00","insp_start_time":"0608","insp_end_time":"0620","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":"S04099086","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-08-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"715281","transaction_code":"A","transaction_date":"2024-08-13 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-08-13 21:41:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-08-13 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:42.000000Z","updated_at":"2025-03-17T20:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10396245,"change_date":"2024-08-13 21:41:00","inspection_id":"82365379","insp_unit_id":"202355773","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-51","insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:45.000000Z","updated_at":"2025-03-17T23:30:45.000000Z"}]},{"id":6318852,"change_date":"2024-07-26 21:39:00","inspection_id":"82224984","dot_number":"24531","report_state":"NH","report_number":"1085004203","insp_date":"2024-07-25 00:00:00","insp_start_time":"0803","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-26 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":"277009","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-07-26 21:39:00","snet_input_date":"2024-07-25 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-07-26 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10181576,"change_date":"2024-07-26 21:39:00","inspection_id":"82224984","insp_unit_id":"202090400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97321","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSSTR1GH232557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:28.000000Z","updated_at":"2025-03-17T23:28:28.000000Z"}]},{"id":6485137,"change_date":"2024-08-16 21:39:00","inspection_id":"82402755","dot_number":"24531","report_state":"MA","report_number":"PD67000048","insp_date":"2024-07-15 00:00:00","insp_start_time":"1006","insp_end_time":"1023","registration_date":null,"region":"ED","ci_status_code":"C","location":"001","location_desc":"BOSTON MA","county_code_state":"MA","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2024-08-16 21:39: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":"752244","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:33.000000Z","updated_at":"2025-03-17T20:31:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10453282,"change_date":"2024-08-16 21:39:00","inspection_id":"82402755","insp_unit_id":"202427691","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"1AC44N","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMMML8HH570586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:18.000000Z","updated_at":"2025-03-17T23:31:18.000000Z"}]},{"id":6100744,"change_date":"2024-06-28 21:39:00","inspection_id":"81990959","dot_number":"24531","report_state":"NH","report_number":"1085004139","insp_date":"2024-06-27 00:00:00","insp_start_time":"0848","insp_end_time":"0906","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"276339","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:43.000000Z","updated_at":"2025-03-17T20:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9826237,"change_date":"2024-06-28 21:39:00","inspection_id":"81990959","insp_unit_id":"201640393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-51","insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:48.000000Z","updated_at":"2025-03-17T23:24:48.000000Z"}]},{"id":6045321,"change_date":"2024-06-27 21:40:00","inspection_id":"81931318","dot_number":"24531","report_state":"RI","report_number":"00DP003915","insp_date":"2024-06-19 00:00:00","insp_start_time":"1008","insp_end_time":"1034","registration_date":null,"region":"ET","ci_status_code":"C","location":"99","location_desc":"RT 295N @ EXIT 22 (RT 114)","county_code_state":"RI","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"SO4073462","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":"2024-06-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"85889","transaction_code":"C","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2024-06-21 21:38:00","snet_input_date":"2024-06-19 00:00:00","source_office":"1RIS001","mcmis_add_date":"2024-06-21 21:38:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:35.000000Z","updated_at":"2025-03-17T20:22:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9736474,"change_date":"2024-06-27 21:40:00","inspection_id":"81931318","insp_unit_id":"201623203","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3468B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0LHLT9119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":5735709,"change_date":"2024-05-14 21:40:00","inspection_id":"81595556","dot_number":"24531","report_state":"CT","report_number":"3132004565","insp_date":"2024-05-14 00:00:00","insp_start_time":"0759","insp_end_time":"0831","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","shipping_paper_number":"S04057527","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"707435","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-05-14 21:40:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-14 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:20.000000Z","updated_at":"2025-03-17T20:16:20.000000Z","inspection_violations":[{"id":8877491,"change_date":"2024-05-14 21:40:00","inspection_id":"81595556","insp_violation_id":"259475810","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200866754","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"V1277745","created_at":"2025-03-17T21:48:56.000000Z","updated_at":"2025-03-17T21:48:56.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":9238292,"change_date":"2024-05-14 21:40:00","inspection_id":"81595556","insp_unit_id":"200866754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AD65F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYCY0FDGL6337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:58.000000Z","updated_at":"2025-03-17T23:18:58.000000Z"}]},{"id":5670438,"change_date":"2024-05-06 21:42:00","inspection_id":"81524733","dot_number":"24531","report_state":"CT","report_number":"0558000930","insp_date":"2024-05-05 00:00:00","insp_start_time":"0920","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"145S","location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"FRESH POINT","shipping_paper_number":"SO4053953","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116900","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":"706622","transaction_code":"A","transaction_date":"2024-05-05 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-05-06 21:42:00","snet_input_date":"2024-05-05 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-05-06 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:06.000000Z","updated_at":"2025-03-17T20:15:06.000000Z","inspection_violations":[{"id":8772321,"change_date":"2024-05-06 21:42:00","inspection_id":"81524733","insp_violation_id":"259319364","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":"Z436606-1","created_at":"2025-03-17T21:48:25.000000Z","updated_at":"2025-03-17T21:48:25.000000Z","normalized_code":"3922"},{"id":8772322,"change_date":"2024-05-06 21:42:00","inspection_id":"81524733","insp_violation_id":"259319365","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":"Z436606-1","created_at":"2025-03-17T21:48:25.000000Z","updated_at":"2025-03-17T21:48:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9133160,"change_date":"2024-05-06 21:42:00","inspection_id":"81524733","insp_unit_id":"200729758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-52","insp_unit_license":"SM98933","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS2536AM092404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:59.000000Z","updated_at":"2025-03-17T23:17:59.000000Z"},{"id":9133161,"change_date":"2024-05-06 21:42:00","inspection_id":"81524733","insp_unit_id":"200729759","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"919","insp_unit_license":"5572B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV5LDLT9794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:59.000000Z","updated_at":"2025-03-17T23:17:59.000000Z"}]},{"id":5618505,"change_date":"2024-04-29 21:43:00","inspection_id":"81468217","dot_number":"24531","report_state":"NH","report_number":"1085003954","insp_date":"2024-04-09 00:00:00","insp_start_time":"0750","insp_end_time":"0812","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"274208","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-09 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9050723,"change_date":"2024-04-29 21:43:00","inspection_id":"81468217","insp_unit_id":"200620256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":5458244,"change_date":"2024-04-08 21:43:00","inspection_id":"81293194","dot_number":"24531","report_state":"NH","report_number":"0945004106","insp_date":"2024-04-05 00:00:00","insp_start_time":"1028","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"061","location_desc":"BEDFORD","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"YELL-O-GLOW CORPORATION","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":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"274137","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-04-08 21:43:00","snet_input_date":"2024-04-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:44.000000Z","updated_at":"2025-03-17T20:10:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8792125,"change_date":"2024-04-08 21:43:00","inspection_id":"81293194","insp_unit_id":"200284900","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-52","insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:47.000000Z","updated_at":"2025-03-17T23:14:47.000000Z"}]},{"id":5407872,"change_date":"2024-04-01 21:40:00","inspection_id":"81238096","dot_number":"24531","report_state":"NH","report_number":"1078007474","insp_date":"2024-04-01 00:00:00","insp_start_time":"0834","insp_end_time":"0852","registration_date":null,"region":"ET","ci_status_code":"C","location":"004","location_desc":"CANTERBURY","county_code_state":"NH","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"274004","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:51.000000Z","updated_at":"2025-03-17T20:09:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8709970,"change_date":"2024-04-01 21:40:00","inspection_id":"81238096","insp_unit_id":"200174046","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:59.000000Z","updated_at":"2025-03-17T23:13:59.000000Z"}]},{"id":5177513,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","dot_number":"24531","report_state":"MA","report_number":"CU00002960","insp_date":"2024-02-29 00:00:00","insp_start_time":"1002","insp_end_time":"1049","registration_date":"2024-03-11 00:00:00","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":"F","shipper_name":"SAME","shipping_paper_number":"SO4025420","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-29 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"486362","transaction_code":"C","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2024-02-29 21:47:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-02-29 21:47:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:00.000000Z","updated_at":"2025-03-17T20:05:00.000000Z","inspection_violations":[{"id":7980727,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","insp_violation_id":"258306957","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:44:36.000000Z","updated_at":"2025-03-17T21:44:36.000000Z","normalized_code":"3922"},{"id":7980728,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","insp_violation_id":"258306958","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199843889","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:36.000000Z","updated_at":"2025-03-17T21:44:36.000000Z","normalized_code":"39375C"},{"id":7980729,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","insp_violation_id":"258306959","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199843889","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:36.000000Z","updated_at":"2025-03-17T21:44:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8336286,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","insp_unit_id":"199843888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"918","insp_unit_license":"90898","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV9LDLT9796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:32.000000Z","updated_at":"2025-03-17T23:10:32.000000Z"},{"id":8336287,"change_date":"2024-03-11 21:43:00","inspection_id":"80986816","insp_unit_id":"199843889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-55","insp_unit_license":"SM3157B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS24846M861101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:32.000000Z","updated_at":"2025-03-17T23:10:32.000000Z"}]},{"id":4984020,"change_date":"2024-02-06 21:41:00","inspection_id":"80775790","dot_number":"24531","report_state":"NH","report_number":"0945003955","insp_date":"2024-02-05 00:00:00","insp_start_time":"0738","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"YELL-O-GLOW CORPORATION","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":"2024-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"272671","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-02-06 21:41:00","snet_input_date":"2024-02-05 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-02-06 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:36.000000Z","updated_at":"2025-03-17T20:01:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8021450,"change_date":"2024-02-06 21:41:00","inspection_id":"80775790","insp_unit_id":"199282218","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH75Z","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFEXRHVA4968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:42.000000Z","updated_at":"2025-03-17T23:07:42.000000Z"}]},{"id":4873556,"change_date":"2024-01-22 21:43:00","inspection_id":"80654972","dot_number":"24531","report_state":"MA","report_number":"BV00006634","insp_date":"2024-01-22 00:00:00","insp_start_time":"0549","insp_end_time":"0605","registration_date":null,"region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","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-01-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"483439","transaction_code":"A","transaction_date":"2024-01-22 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2024-01-22 21:43:00","snet_input_date":"2024-01-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-01-22 21:43:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:15.000000Z","updated_at":"2025-03-17T19:59:15.000000Z","inspection_violations":[{"id":7510183,"change_date":"2024-01-22 21:43:00","inspection_id":"80654972","insp_violation_id":"257429894","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:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3922"},{"id":7510184,"change_date":"2024-01-22 21:43:00","inspection_id":"80654972","insp_violation_id":"257429895","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7841560,"change_date":"2024-01-22 21:43:00","inspection_id":"80654972","insp_unit_id":"199047398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:05.000000Z","updated_at":"2025-03-17T23:06:05.000000Z"}]},{"id":4742181,"change_date":"2024-01-02 21:43:00","inspection_id":"80511299","dot_number":"24531","report_state":"NH","report_number":"0989000005","insp_date":"2024-01-01 00:00:00","insp_start_time":"1047","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HAMPTON FALLS","county_code_state":"NH","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"272038","transaction_code":"A","transaction_date":"2024-01-01 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2024-01-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:51.000000Z","updated_at":"2025-03-17T19:56:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7628185,"change_date":"2024-01-02 21:43:00","inspection_id":"80511299","insp_unit_id":"198760116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-51","insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:11.000000Z","updated_at":"2025-03-17T23:04:11.000000Z"}]},{"id":4329301,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","dot_number":"24531","report_state":"MA","report_number":"CU00002761","insp_date":"2023-11-01 00:00:00","insp_start_time":"0725","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"008H","location_desc":"H-ALLSTON","county_code_state":"MA","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"SO3977375","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-01 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"117000","viol_total":"4","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":"477577","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:44.000000Z","updated_at":"2025-03-17T19:48:44.000000Z","inspection_violations":[{"id":6696899,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_violation_id":"256155061","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":"257872AC","created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3922"},{"id":6696900,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_violation_id":"256155062","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197847921","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"39617C"},{"id":6696901,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_violation_id":"256155063","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197847922","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"3963A1"},{"id":6696902,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_violation_id":"256155064","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"197847922","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:13.000000Z","updated_at":"2025-03-17T21:38:13.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":6962480,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_unit_id":"197847921","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"918","insp_unit_license":"90898","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV9LDLT9796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"},{"id":6962481,"change_date":"2023-11-01 21:43:00","inspection_id":"80057570","insp_unit_id":"197847922","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-45","insp_unit_license":"92306","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS24868U509401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"}]},{"id":4179541,"change_date":"2023-10-24 21:39:00","inspection_id":"79891947","dot_number":"24531","report_state":"MA","report_number":"CX00000495","insp_date":"2023-10-12 00:00:00","insp_start_time":"1055","insp_end_time":"1103","registration_date":"2023-10-24 00:00:00","region":"ET","ci_status_code":"C","location":"171H","location_desc":"LEOMINSTER","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","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":"53220","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":"476165","transaction_code":"C","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","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":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","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":6471010,"change_date":"2023-10-24 21:39:00","inspection_id":"79891947","insp_violation_id":"256003476","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":"225921AC","created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6721147,"change_date":"2023-10-24 21:39:00","inspection_id":"79891947","insp_unit_id":"197711110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1AD75Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYFE7PDUN0097","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":4169409,"change_date":"2023-10-24 21:39:00","inspection_id":"79880810","dot_number":"24531","report_state":"MA","report_number":"DI00000387","insp_date":"2023-10-10 00:00:00","insp_start_time":"1550","insp_end_time":"1610","registration_date":"2023-10-24 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","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-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"476012","transaction_code":"C","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-03-17T19:45:28.000000Z","inspection_violations":[{"id":6453997,"change_date":"2023-10-24 21:39:00","inspection_id":"79880810","insp_violation_id":"256003762","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197711249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:06.000000Z","updated_at":"2025-03-17T21:37:06.000000Z","normalized_code":"3939A"},{"id":6453998,"change_date":"2023-10-24 21:39:00","inspection_id":"79880810","insp_violation_id":"256003763","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"197711249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:06.000000Z","updated_at":"2025-03-17T21:37:06.000000Z","normalized_code":"39319"},{"id":6453999,"change_date":"2023-10-24 21:39:00","inspection_id":"79880810","insp_violation_id":"256003764","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197711249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:06.000000Z","updated_at":"2025-03-17T21:37:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6704619,"change_date":"2023-10-24 21:39:00","inspection_id":"79880810","insp_unit_id":"197711249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"H-41","insp_unit_license":"93813","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSSTR3GH741727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"}]},{"id":3895332,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","dot_number":"24531","report_state":"MA","report_number":"CP00003444","insp_date":"2023-09-04 00:00:00","insp_start_time":"0924","insp_end_time":"1002","registration_date":null,"region":"ET","ci_status_code":"C","location":"365H","location_desc":"H-WESTBORO","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"473280","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-09-05 21:40:00","snet_input_date":"2023-09-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[{"id":6021173,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","insp_violation_id":"255064433","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:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"3922"},{"id":6021174,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","insp_violation_id":"255064434","seq_no":"2","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:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"38323A2"},{"id":6021175,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","insp_violation_id":"255064435","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196880550","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"164084AC","created_at":"2025-03-17T21:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6262917,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","insp_unit_id":"196880550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FTL","insp_unit_company":null,"insp_unit_license":"3072B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV2LDLT9106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"},{"id":6262918,"change_date":"2023-09-05 21:40:00","inspection_id":"79576401","insp_unit_id":"196880551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"98643","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1UYVS248XAU930401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3659873,"change_date":"2023-08-03 21:40:00","inspection_id":"79313241","dot_number":"24531","report_state":"NH","report_number":"1085003356","insp_date":"2023-08-02 00:00:00","insp_start_time":"0917","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SANBORNTON","county_code_state":"NH","county_code":"001","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-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"268128","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2023-08-03 21:40:00","snet_input_date":"2023-08-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:59.000000Z","updated_at":"2025-03-17T19:34:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5884628,"change_date":"2023-08-03 21:40:00","inspection_id":"79313241","insp_unit_id":"196339762","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H52","insp_unit_license":"1AH47P","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0RHUX7185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":2528845,"change_date":"2023-03-08 21:40:00","inspection_id":"78035499","dot_number":"24531","report_state":"MA","report_number":"DC00000356","insp_date":"2023-03-08 00:00:00","insp_start_time":"1100","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"218H","location_desc":"H-NATICK","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":"2023-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"461837","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-03-08 21:40:00","snet_input_date":"2023-03-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-08 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","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":3887475,"change_date":"2023-03-08 21:40:00","inspection_id":"78035499","insp_violation_id":"251532161","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39141A1"},{"id":3887476,"change_date":"2023-03-08 21:40:00","inspection_id":"78035499","insp_violation_id":"251532162","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193759077","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39345"},{"id":3887477,"change_date":"2023-03-08 21:40:00","inspection_id":"78035499","insp_violation_id":"251532163","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193759077","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4070359,"change_date":"2023-03-08 21:40:00","inspection_id":"78035499","insp_unit_id":"193759077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"98996","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMAAL2CL445850","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":2406373,"change_date":"2023-05-17 21:42:00","inspection_id":"77896235","dot_number":"24531","report_state":"RI","report_number":"00LR002835","insp_date":"2023-02-18 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROUTE 37 WEST, 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":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"80608","transaction_code":"C","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-18 00:00:00","source_office":"1RIS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","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":3704497,"change_date":"2023-05-17 21:42:00","inspection_id":"77896235","insp_violation_id":"252878984","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":"23001506511","created_at":"2025-03-17T21:24:29.000000Z","updated_at":"2025-03-17T21:24:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3872161,"change_date":"2023-05-17 21:42:00","inspection_id":"77896235","insp_unit_id":"194973473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-46","insp_unit_license":"3468B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVHCYFE0LHLT9119","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":2354089,"change_date":"2023-02-13 21:42:00","inspection_id":"77836481","dot_number":"24531","report_state":"MA","report_number":"CY00000587","insp_date":"2023-02-13 00:00:00","insp_start_time":"0757","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"066H","location_desc":"H-CHELMSFORD","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":"2023-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"460429","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2023-02-13 21:42:00","snet_input_date":"2023-02-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-02-13 21:42:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:00.000000Z","updated_at":"2025-03-17T19:10:00.000000Z","inspection_violations":[{"id":3626221,"change_date":"2023-02-13 21:42:00","inspection_id":"77836481","insp_violation_id":"251088894","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193357882","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39375G"},{"id":3626222,"change_date":"2023-02-13 21:42:00","inspection_id":"77836481","insp_violation_id":"251088895","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193357882","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39375G"},{"id":3626223,"change_date":"2023-02-13 21:42:00","inspection_id":"77836481","insp_violation_id":"251088896","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193357882","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"812117AB","created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3788629,"change_date":"2023-02-13 21:42:00","inspection_id":"77836481","insp_unit_id":"193357882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"H-47","insp_unit_license":"5386B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALHCYCY7FDGL4813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"}]},{"id":2311962,"change_date":"2023-02-07 21:40:00","inspection_id":"77788238","dot_number":"24531","report_state":"CT","report_number":"3010002337","insp_date":"2023-02-07 00:00:00","insp_start_time":"1518","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"TRIP SLIP","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"665935","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2023-02-07 21:40:00","snet_input_date":"2023-02-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-02-07 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:15.000000Z","updated_at":"2025-03-17T19:09:15.000000Z","inspection_violations":[{"id":3561792,"change_date":"2023-02-07 21:40:00","inspection_id":"77788238","insp_violation_id":"250984788","seq_no":"1","part_no":"390","part_no_section":"19(a)(1)","insp_viol_unit":"1","insp_unit_id":"193263778","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:50.000000Z","updated_at":"2025-03-17T21:23:50.000000Z","normalized_code":"39019A1"},{"id":3561793,"change_date":"2023-02-07 21:40:00","inspection_id":"77788238","insp_violation_id":"250984789","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193263778","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:50.000000Z","updated_at":"2025-03-17T21:23:50.000000Z","normalized_code":"3922"},{"id":3561794,"change_date":"2023-02-07 21:40:00","inspection_id":"77788238","insp_violation_id":"250984790","seq_no":"3","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"193263778","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y993582-0","created_at":"2025-03-17T21:23:50.000000Z","updated_at":"2025-03-17T21:23:50.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":3721178,"change_date":"2023-02-07 21:40:00","inspection_id":"77788238","insp_unit_id":"193263778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"H-41","insp_unit_license":"93813","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSSTR3GH741727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:40.000000Z","updated_at":"2025-03-17T22:32:40.000000Z"}]},{"id":2042042,"change_date":"2022-12-30 21:36:00","inspection_id":"77479899","dot_number":"24531","report_state":"MA","report_number":"DC00000156","insp_date":"2022-12-30 00:00:00","insp_start_time":"0841","insp_end_time":"0857","registration_date":null,"region":"ET","ci_status_code":"C","location":"370H","location_desc":"H-WESTON","county_code_state":"MA","county_code":"017","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":"2022-12-30 21:36: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":"457870","transaction_code":"A","transaction_date":"2022-12-30 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2022-12-30 21:36:00","snet_input_date":"2022-12-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-12-30 21:36:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:20.000000Z","updated_at":"2025-03-17T19:04:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3285085,"change_date":"2022-12-30 21:36:00","inspection_id":"77479899","insp_unit_id":"192641123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97321","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWE30S7XHB66635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:32.000000Z","updated_at":"2025-03-17T22:29:32.000000Z"}]},{"id":1479201,"change_date":"2022-10-11 21:40:00","inspection_id":"76834443","dot_number":"24531","report_state":"NH","report_number":"1078006237","insp_date":"2022-10-10 00:00:00","insp_start_time":"0943","insp_end_time":"1007","registration_date":null,"region":"ET","ci_status_code":"C","location":"039","location_desc":"PLYMOUTH","county_code_state":"NH","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":"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-10-11 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":"261329","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2022-10-11 21:40:00","snet_input_date":"2022-10-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-10-11 21:40:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:50.000000Z","updated_at":"2025-03-17T18:53:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2381518,"change_date":"2022-10-11 21:40:00","inspection_id":"76834443","insp_unit_id":"191358057","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97321","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMSSTR1GH232557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:19.000000Z","updated_at":"2025-03-17T22:23:19.000000Z"}]},{"id":676734,"change_date":"2022-07-11 21:41:00","inspection_id":"75898962","dot_number":"24531","report_state":"MA","report_number":"CM00003126","insp_date":"2022-06-23 00:00:00","insp_start_time":"0935","insp_end_time":"0949","registration_date":"2022-07-11 00:00:00","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":"2022-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"448114","transaction_code":"C","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2022-06-23 21:39:00","snet_input_date":"2022-06-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-06-23 21:39:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:33.000000Z","updated_at":"2025-03-17T18:39:33.000000Z","inspection_violations":[{"id":1064783,"change_date":"2022-07-11 21:41:00","inspection_id":"75898962","insp_violation_id":"246991392","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:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"3922"},{"id":1064784,"change_date":"2022-07-11 21:41:00","inspection_id":"75898962","insp_violation_id":"246991393","seq_no":"2","part_no":"393","part_no_section":"203(b)","insp_viol_unit":"1","insp_unit_id":"189690298","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:01.000000Z","updated_at":"2025-03-17T21:12:01.000000Z","normalized_code":"393203B"}],"inspection_per_units":[{"id":1087674,"change_date":"2022-07-11 21:41:00","inspection_id":"75898962","insp_unit_id":"189690298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"93812","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAN9BH314940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:53.000000Z","updated_at":"2025-03-17T22:14:53.000000Z"}]},{"id":589492,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","dot_number":"24531","report_state":"CT","report_number":"3120003031","insp_date":"2022-06-10 00:00:00","insp_start_time":"1319","insp_end_time":"1406","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"MANCHESTER","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"YELL O GLOW CORPORATION","shipping_paper_number":"TEMU946473","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"10","oos_total":"2","driver_viol_total":"6","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"646212","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":null,"census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"YELL O GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON ST","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[{"id":924622,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398153","seq_no":"7","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"189194201","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y989339-6","created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"393126"},{"id":924623,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398154","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:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"3922"},{"id":924624,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398155","seq_no":"2","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:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39522H1"},{"id":924625,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398156","seq_no":"3","part_no":"395","part_no_section":"22(h)(2)","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:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39522H2"},{"id":924626,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398157","seq_no":"4","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:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39522H3"},{"id":924627,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398158","seq_no":"5","part_no":"395","part_no_section":"22(h)(4)","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:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39522H4"},{"id":924628,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398159","seq_no":"6","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:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39524D"},{"id":924629,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398160","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189194201","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"3939A"},{"id":924630,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398161","seq_no":"9","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"189194201","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39319"},{"id":924631,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_violation_id":"246398162","seq_no":"10","part_no":"393","part_no_section":"25(a)","insp_viol_unit":"2","insp_unit_id":"189194201","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"39325A"}],"inspection_per_units":[{"id":947189,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_unit_id":"189194200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"916","insp_unit_license":"3072B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3AKJGBDV2LDLT9106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"},{"id":947190,"change_date":"2022-06-13 21:41:00","inspection_id":"75795119","insp_unit_id":"189194201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"TAXZ471802","insp_unit_license":"3412713","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1S12GC40XSB698182","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]},{"id":426973,"change_date":"2022-05-19 21:41:00","inspection_id":"75602159","dot_number":"24531","report_state":"MA","report_number":"CB00007094","insp_date":"2022-05-18 00:00:00","insp_start_time":"1215","insp_end_time":"1229","registration_date":null,"region":"ET","ci_status_code":"C","location":"038H","location_desc":"H-BOSTON","county_code_state":"MA","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-19 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":"446364","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00024531","upload_search_indicator":"M","census_search_date":"2022-05-19 21:41:00","snet_input_date":"2022-05-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-19 21:41:00","insp_carrier_name":"YELL-O-GLOW CORPORATION","insp_carrier_street":"21 ARLINGTON STREET","insp_carrier_city":"CHELSEA","insp_carrier_state":"MA","insp_carrier_zip_code":"02150","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:08.000000Z","updated_at":"2025-03-17T18:35:08.000000Z","inspection_violations":[{"id":670939,"change_date":"2022-05-19 21:41:00","inspection_id":"75602159","insp_violation_id":"245903994","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:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":688802,"change_date":"2022-05-19 21:41:00","inspection_id":"75602159","insp_unit_id":"188776838","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"INTER","insp_unit_company":null,"insp_unit_license":"98996","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3HAMMAAL2CL445850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/24531\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/24531\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/24531\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/24531\/inspections","per_page":100,"prev_page_url":null,"to":70,"total":70}