{"current_page":1,"data":[{"id":12360183,"change_date":"2026-07-04 21:34:00","inspection_id":"88321700","dot_number":"28581","report_state":"OH","report_number":"1808001366","insp_date":"2026-07-03 00:00:00","insp_start_time":"0644","insp_end_time":"0708","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORTH CANTON OH","county_code_state":"OH","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE SUPERIOR BEVERAGE GROUP LTD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-04 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"3684261","transaction_code":"A","transaction_date":"2026-07-04 00:00:00","upload_date":"2026-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2026-07-04 21:34:00","snet_input_date":"2026-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-04 21:34:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-07T09:40:59.000000Z","updated_at":"2026-07-15T09:30:25.000000Z","inspection_violations":[{"id":21512885,"change_date":"2026-07-04 21:34:00","inspection_id":"88321700","insp_violation_id":"275305999","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-07T10:01:01.000000Z","updated_at":"2026-07-15T09:41:09.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":21464085,"change_date":"2026-07-04 21:34:00","inspection_id":"88321700","insp_unit_id":"214450237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRICK COM","insp_unit_company":"28220","insp_unit_license":"TRN1350","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S11E9283LE543065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-07T09:18:50.000000Z","updated_at":"2026-07-15T09:01:35.000000Z"},{"id":21464084,"change_date":"2026-07-04 21:34:00","inspection_id":"88321700","insp_unit_id":"214450236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"328379","insp_unit_license":"PLR7619","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE7PHUF3372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-07T09:18:50.000000Z","updated_at":"2026-07-15T09:01:35.000000Z"}]},{"id":11649860,"change_date":"2026-04-15 21:38:00","inspection_id":"87579393","dot_number":"28581","report_state":"OH","report_number":"1808001152","insp_date":"2026-04-13 00:00:00","insp_start_time":"1250","insp_end_time":"1314","registration_date":null,"region":"ED","ci_status_code":"C","location":"IR77","location_desc":"CANTON OH","county_code_state":"OH","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"3158154","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:13.000000Z","updated_at":"2026-04-26T09:30:13.000000Z","inspection_violations":[{"id":20227570,"change_date":"2026-04-15 21:38:00","inspection_id":"87579393","insp_violation_id":"273607984","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":"WARNING","created_at":"2026-04-26T09:40:08.000000Z","updated_at":"2026-04-26T09:40:08.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":20264496,"change_date":"2026-04-15 21:38:00","inspection_id":"87579393","insp_unit_id":"213022088","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"328379","insp_unit_license":"PLR7619","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE7PHUF3372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:28.000000Z","updated_at":"2026-04-26T09:02:28.000000Z"},{"id":20264497,"change_date":"2026-04-15 21:38:00","inspection_id":"87579393","insp_unit_id":"213022089","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"910","insp_unit_license":"TTJ5044","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5V8VA48218M809248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:28.000000Z","updated_at":"2026-04-26T09:02:28.000000Z"}]},{"id":9637646,"change_date":"2025-09-10 21:39:00","inspection_id":"85729001","dot_number":"28581","report_state":"OH","report_number":"3265000593","insp_date":"2025-09-08 00:00:00","insp_start_time":"1128","insp_end_time":"1145","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FREDERICKTOWN OH","county_code_state":"OH","county_code":"175","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2242988","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2025-09-10 21:39:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-10 21:39:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:24.000000Z","updated_at":"2025-09-13T10:47:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15922471,"change_date":"2025-09-10 21:39:00","inspection_id":"85729001","insp_unit_id":"208839392","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2515750","insp_unit_license":"PNP6018","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJHLDV3SLWE3632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:13.000000Z","updated_at":"2025-09-13T10:00:13.000000Z"},{"id":15922472,"change_date":"2025-09-10 21:39:00","inspection_id":"85729001","insp_unit_id":"208839393","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"1436489PLA","insp_unit_license":"HHT6503","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532DXEL807969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:13.000000Z","updated_at":"2025-09-13T10:00:13.000000Z"}]},{"id":9348941,"change_date":"2025-08-07 21:39:00","inspection_id":"85425854","dot_number":"28581","report_state":"OH","report_number":"3233000885","insp_date":"2025-08-05 00:00:00","insp_start_time":"0810","insp_end_time":"0905","registration_date":null,"region":"ED","ci_status_code":"C","location":"271 RA","location_desc":"RICHFIELD OH","county_code_state":"OH","county_code":"153","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"2655","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","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":"2094013","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:30.000000Z","updated_at":"2025-08-12T10:42:30.000000Z","inspection_violations":[{"id":15182140,"change_date":"2025-08-07 21:39:00","inspection_id":"85425854","insp_violation_id":"267883583","seq_no":"1","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"208275217","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:31.000000Z","updated_at":"2025-08-11T10:43:57.000000Z","normalized_code":"39311A1LSML"},{"id":15182141,"change_date":"2025-08-07 21:39:00","inspection_id":"85425854","insp_violation_id":"267883584","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"208275217","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:31.000000Z","updated_at":"2025-08-11T10:43:57.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":15400933,"change_date":"2025-08-07 21:39:00","inspection_id":"85425854","insp_unit_id":"208275216","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2515750","insp_unit_license":"PNP6018","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJHLDV3SLWE3632","insp_unit_decal":"Y","insp_unit_decal_number":"35410356","created_at":"2025-08-10T09:46:16.000000Z","updated_at":"2025-08-11T09:45:20.000000Z"},{"id":15400934,"change_date":"2025-08-07 21:39:00","inspection_id":"85425854","insp_unit_id":"208275217","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"910","insp_unit_license":"TTJ5044","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5V8VA48218M809248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:16.000000Z","updated_at":"2025-08-11T09:45:20.000000Z"}]},{"id":9173196,"change_date":"2025-07-17 21:41:00","inspection_id":"85240880","dot_number":"28581","report_state":"OH","report_number":"3277001704","insp_date":"2025-07-16 00:00:00","insp_start_time":"0725","insp_end_time":"0741","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"COLUMBUS OH","county_code_state":"OH","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE GROUP","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2004063","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:08.000000Z","updated_at":"2025-07-21T10:43:08.000000Z","inspection_violations":[{"id":14811696,"change_date":"2025-07-17 21:41:00","inspection_id":"85240880","insp_violation_id":"267462368","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":15072337,"change_date":"2025-07-17 21:41:00","inspection_id":"85240880","insp_unit_id":"207919199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PJH1313","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY1HDJB7075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:26.000000Z","updated_at":"2025-07-21T09:45:36.000000Z"},{"id":15072338,"change_date":"2025-07-17 21:41:00","inspection_id":"85240880","insp_unit_id":"207919200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"1939170","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5CWRA37168H092202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:26.000000Z","updated_at":"2025-07-21T09:45:36.000000Z"}]},{"id":8003144,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","dot_number":"28581","report_state":"OH","report_number":"3255000177","insp_date":"2025-02-27 00:00:00","insp_start_time":"1311","insp_end_time":"1355","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LORAIN OH","county_code_state":"OH","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-02 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1420359","transaction_code":"A","transaction_date":"2025-03-02 00:00:00","upload_date":"2025-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2025-03-02 21:34:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-02 21:34:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:28.000000Z","updated_at":"2025-03-17T21:04:28.000000Z","inspection_violations":[{"id":12504968,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","insp_violation_id":"264784048","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205581759","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"39617CPI"},{"id":12504969,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","insp_violation_id":"264784049","seq_no":"2","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"205581758","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"39355C1"},{"id":12504970,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","insp_violation_id":"264784050","seq_no":"3","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"205581759","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:08.000000Z","updated_at":"2025-03-17T22:07:08.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":12920383,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","insp_unit_id":"205581758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"203553","insp_unit_license":"PLN8964","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE1PDUD2216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:44.000000Z","updated_at":"2025-03-17T23:57:44.000000Z"},{"id":12920384,"change_date":"2025-03-02 21:34:00","inspection_id":"84007027","insp_unit_id":"205581759","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":null,"insp_unit_license":"TTB1162","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28168B092025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:44.000000Z","updated_at":"2025-03-17T23:57:44.000000Z"}]},{"id":6975690,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","dot_number":"28581","report_state":"OH","report_number":"3267000031","insp_date":"2024-10-14 00:00:00","insp_start_time":"1050","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FAIRLAWN OH","county_code_state":"OH","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE","shipping_paper_number":"56820","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"952623","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2024-10-17 21:41:00","snet_input_date":"2024-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-17 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:27.000000Z","updated_at":"2025-03-17T20:41:27.000000Z","inspection_violations":[{"id":10878856,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","insp_violation_id":"262392016","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"203445317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:42.000000Z","updated_at":"2025-03-17T21:58:42.000000Z","normalized_code":"3939ALRLI"},{"id":10878857,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","insp_violation_id":"262392017","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"203445317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:42.000000Z","updated_at":"2025-03-17T21:58:42.000000Z","normalized_code":"3939ALIL"},{"id":10878858,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","insp_violation_id":"262392018","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"203445317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:42.000000Z","updated_at":"2025-03-17T21:58:42.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":11251100,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","insp_unit_id":"203445316","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"315358","insp_unit_license":"PLP7848","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJC5DV1PHUF3333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"},{"id":11251101,"change_date":"2024-10-17 21:41:00","inspection_id":"82924898","insp_unit_id":"203445317","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRICK COM","insp_unit_company":"53761","insp_unit_license":"TRL3739","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9532DE526621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"}]},{"id":6949436,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","dot_number":"28581","report_state":"OH","report_number":"1331000029","insp_date":"2024-10-11 00:00:00","insp_start_time":"1113","insp_end_time":"1157","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BOLIVAR OH","county_code_state":"OH","county_code":"157","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-14 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"943193","transaction_code":"A","transaction_date":"2024-10-14 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":"2024-10-14 21:36:00","snet_input_date":"2024-10-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-14 21:36:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:01.000000Z","updated_at":"2025-03-17T20:41:01.000000Z","inspection_violations":[{"id":10833605,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_violation_id":"262327166","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203390853","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39347E"},{"id":10833606,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_violation_id":"262327167","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"203390853","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39353B"},{"id":10833607,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_violation_id":"262327168","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203390853","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39347E"},{"id":10833608,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_violation_id":"262327169","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"203390853","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11208806,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_unit_id":"203390852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PLR7621","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE0PHUF3374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:02.000000Z","updated_at":"2025-03-17T23:39:02.000000Z"},{"id":11208807,"change_date":"2024-10-14 21:36:00","inspection_id":"82897108","insp_unit_id":"203390853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"TTJ5044","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5V8VA48218M809248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:02.000000Z","updated_at":"2025-03-17T23:39:02.000000Z"}]},{"id":6599100,"change_date":"2024-08-29 21:43:00","inspection_id":"82524405","dot_number":"28581","report_state":"OH","report_number":"3247020660","insp_date":"2024-08-19 00:00:00","insp_start_time":"0844","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"00571","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"005","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","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":"1749343","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-20 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:43.000000Z","updated_at":"2025-03-17T20:33:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10639250,"change_date":"2024-08-29 21:43:00","inspection_id":"82524405","insp_unit_id":"202659936","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"PMH4252","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X4NJ488471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"},{"id":10639251,"change_date":"2024-08-29 21:43:00","inspection_id":"82524405","insp_unit_id":"202659937","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1436479PLA","insp_unit_license":"TTH6493","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D7EL807959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:10.000000Z","updated_at":"2025-03-17T23:33:10.000000Z"}]},{"id":6208056,"change_date":"2024-07-12 21:39:00","inspection_id":"82106264","dot_number":"28581","report_state":"OH","report_number":"3231023491","insp_date":"2024-07-12 00:00:00","insp_start_time":"1251","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"157416","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-07-12 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"76000","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":"1739896","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:46.000000Z","updated_at":"2025-03-17T20:25:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10001234,"change_date":"2024-07-12 21:39:00","inspection_id":"82106264","insp_unit_id":"201863380","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328378","insp_unit_license":"PLS7248","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE5PHUF3371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:39.000000Z","updated_at":"2025-03-17T23:26:39.000000Z"},{"id":10001235,"change_date":"2024-07-12 21:39:00","inspection_id":"82106264","insp_unit_id":"201863381","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"TRQ1827","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28168B092011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:39.000000Z","updated_at":"2025-03-17T23:26:39.000000Z"}]},{"id":6072999,"change_date":"2024-06-25 21:42:00","inspection_id":"81961178","dot_number":"28581","report_state":"OH","report_number":"1057002905","insp_date":"2024-06-24 00:00:00","insp_start_time":"1322","insp_end_time":"1339","registration_date":null,"region":"ET","ci_status_code":"C","location":"035","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"1735841","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-25 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:00.000000Z","updated_at":"2025-03-17T20:23:00.000000Z","inspection_violations":[{"id":9422044,"change_date":"2024-06-25 21:42:00","inspection_id":"81961178","insp_violation_id":"260299032","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9781298,"change_date":"2024-06-25 21:42:00","inspection_id":"81961178","insp_unit_id":"201582673","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135044","insp_unit_license":"PLL7909","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCXFE4PDNW7656","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"},{"id":9781299,"change_date":"2024-06-25 21:42:00","inspection_id":"81961178","insp_unit_id":"201582674","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"TTD2462","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV401D4LL224121","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"}]},{"id":6061403,"change_date":"2024-06-24 21:42:00","inspection_id":"81948811","dot_number":"28581","report_state":"OH","report_number":"1057002897","insp_date":"2024-06-21 00:00:00","insp_start_time":"1413","insp_end_time":"1427","registration_date":null,"region":"ET","ci_status_code":"C","location":"035","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"1735492","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-24 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:56.000000Z","updated_at":"2025-03-17T20:22:56.000000Z","inspection_violations":[{"id":9402737,"change_date":"2024-06-24 21:42:00","inspection_id":"81948811","insp_violation_id":"260269371","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:31.000000Z","updated_at":"2025-03-17T21:51:31.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9762674,"change_date":"2024-06-24 21:42:00","inspection_id":"81948811","insp_unit_id":"201557575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328365","insp_unit_license":"PLQ7198","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE5PDUF3358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"},{"id":9762675,"change_date":"2024-06-24 21:42:00","inspection_id":"81948811","insp_unit_id":"201557576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"931`","insp_unit_license":"TQZ6905","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9388JE537407","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"}]},{"id":5598918,"change_date":"2024-04-25 21:43:00","inspection_id":"81446796","dot_number":"28581","report_state":"OH","report_number":"1777005157","insp_date":"2024-04-25 00:00:00","insp_start_time":"0616","insp_end_time":"0642","registration_date":null,"region":"ET","ci_status_code":"C","location":"15777","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE","shipping_paper_number":"2103945","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","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":"1721756","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-25 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:33.000000Z","updated_at":"2025-03-17T20:13:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9018596,"change_date":"2024-04-25 21:43:00","inspection_id":"81446796","insp_unit_id":"200579630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328378","insp_unit_license":"PLS7248","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE5PHUF3371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"},{"id":9018597,"change_date":"2024-04-25 21:43:00","inspection_id":"81446796","insp_unit_id":"200579631","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"920","insp_unit_license":"TRE2364","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS25399P811607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"}]},{"id":5491614,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","dot_number":"28581","report_state":"OH","report_number":"3225019758","insp_date":"2024-04-11 00:00:00","insp_start_time":"1038","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":"099224","location_desc":"ROAD SIDE","county_code_state":"OH","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"4151","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-11 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"117000","viol_total":"7","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":"1718242","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[{"id":8481226,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884177","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39311"},{"id":8481227,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884178","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39330"},{"id":8481228,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884179","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39375A3"},{"id":8481229,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884180","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3963A1"},{"id":8481230,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884181","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39355E"},{"id":8481231,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884182","seq_no":"6","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39345"},{"id":8481232,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_violation_id":"258884183","seq_no":"7","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"200357283","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":8846075,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_unit_id":"200357282","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"315361","insp_unit_license":"PLQ7207","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJC5DV7PHUF3336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"},{"id":8846076,"change_date":"2024-04-11 21:41:00","inspection_id":"81330015","insp_unit_id":"200357283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"48180","insp_unit_license":"TRX8754","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9483NE547380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5399881,"change_date":"2024-04-01 21:40:00","inspection_id":"81229302","dot_number":"28581","report_state":"OH","report_number":"3272001068","insp_date":"2024-03-29 00:00:00","insp_start_time":"0606","insp_end_time":"0625","registration_date":null,"region":"ET","ci_status_code":"C","location":"09320","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"VARIOUS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1715452","transaction_code":"C","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:31.000000Z","updated_at":"2025-03-17T20:09:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8696964,"change_date":"2024-04-01 21:40:00","inspection_id":"81229302","insp_unit_id":"200182550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"444443","insp_unit_license":"PMR6637","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE5NDNP8099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8696965,"change_date":"2024-04-01 21:40:00","inspection_id":"81229302","insp_unit_id":"200182551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TRF1528","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS253X9P811602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":4943511,"change_date":"2024-01-31 21:42:00","inspection_id":"80731413","dot_number":"28581","report_state":"OH","report_number":"1057002482","insp_date":"2024-01-29 00:00:00","insp_start_time":"1212","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"035","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1701508","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-30 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-31 21:42:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:48.000000Z","updated_at":"2025-03-17T20:00:48.000000Z","inspection_violations":[{"id":7613177,"change_date":"2024-01-31 21:42:00","inspection_id":"80731413","insp_violation_id":"257585182","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199196683","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"},{"id":7613178,"change_date":"2024-01-31 21:42:00","inspection_id":"80731413","insp_violation_id":"257585183","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199196683","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"},{"id":7613179,"change_date":"2024-01-31 21:42:00","inspection_id":"80731413","insp_violation_id":"257585184","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199196683","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:45.000000Z","updated_at":"2025-03-17T21:42:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7955710,"change_date":"2024-01-31 21:42:00","inspection_id":"80731413","insp_unit_id":"199196683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"135043","insp_unit_license":"PLL7910","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCXFE2PDNW7655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:07.000000Z","updated_at":"2025-03-17T23:07:07.000000Z"}]},{"id":4775079,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","dot_number":"28581","report_state":"OH","report_number":"0700004008","insp_date":"2024-01-04 00:00:00","insp_start_time":"0648","insp_end_time":"0712","registration_date":null,"region":"ET","ci_status_code":"C","location":"09390","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1696871","transaction_code":"A","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-05 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:18.000000Z","updated_at":"2025-03-17T19:57:18.000000Z","inspection_violations":[{"id":7368352,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","insp_violation_id":"257213985","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"38371H"},{"id":7368353,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","insp_violation_id":"257213986","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"39141A1"},{"id":7368354,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","insp_violation_id":"257213987","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198839629","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7681868,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","insp_unit_id":"198839628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44402","insp_unit_license":"PMR6636","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE3NDNP8098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"},{"id":7681869,"change_date":"2024-01-05 21:46:00","inspection_id":"80547262","insp_unit_id":"198839629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"28206","insp_unit_license":"TQM5042","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S11E9284FE531334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"}]},{"id":3295720,"change_date":"2023-06-15 21:42:00","inspection_id":"78904523","dot_number":"28581","report_state":"OH","report_number":"3253016384","insp_date":"2023-06-15 00:00:00","insp_start_time":"1415","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":"09302","location_desc":"ROADSIDE.....","county_code_state":"OH","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"1662630","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[{"id":5082234,"change_date":"2023-06-15 21:42:00","inspection_id":"78904523","insp_violation_id":"253532469","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"195522626","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:38.000000Z","updated_at":"2025-03-17T21:30:38.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5298713,"change_date":"2023-06-15 21:42:00","inspection_id":"78904523","insp_unit_id":"195522625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"203550","insp_unit_license":"PLN8965","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE6PDUD2213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"},{"id":5298714,"change_date":"2023-06-15 21:42:00","inspection_id":"78904523","insp_unit_id":"195522626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"28227","insp_unit_license":"TTB1180","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3H3V281CXHT286254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:47.000000Z","updated_at":"2025-03-17T22:44:47.000000Z"}]},{"id":3054472,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","dot_number":"28581","report_state":"OH","report_number":"3225018415","insp_date":"2023-05-15 00:00:00","insp_start_time":"1215","insp_end_time":"1300","registration_date":"2023-05-25 00:00:00","region":"ET","ci_status_code":"C","location":"09911","location_desc":"ROAD SIDE","county_code_state":"OH","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1656640","transaction_code":"C","transaction_date":"2023-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:25.000000Z","updated_at":"2025-03-17T19:23:25.000000Z","inspection_violations":[{"id":4694398,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","insp_violation_id":"259520267","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200907568","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"3963A1"},{"id":4694399,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","insp_violation_id":"259520268","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200907568","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39347E"},{"id":4694400,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","insp_violation_id":"259520269","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200907568","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:52.000000Z","updated_at":"2025-03-17T21:28:52.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":4914148,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","insp_unit_id":"200907567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328385","insp_unit_license":"PLS7200","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE8PHUF3378","insp_unit_decal":"Y","insp_unit_decal_number":"32620834","created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"},{"id":4914149,"change_date":"2024-05-15 21:43:00","inspection_id":"78632321","insp_unit_id":"200907568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"928","insp_unit_license":"TQQ9889","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9384GE533086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":2776152,"change_date":"2023-04-11 21:40:00","inspection_id":"78317478","dot_number":"28581","report_state":"OH","report_number":"3251014151","insp_date":"2023-04-11 00:00:00","insp_start_time":"1310","insp_end_time":"1344","registration_date":null,"region":"ET","ci_status_code":"C","location":"9911","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"1649633","transaction_code":"A","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:43.000000Z","updated_at":"2025-03-17T19:17:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4468675,"change_date":"2023-04-11 21:40:00","inspection_id":"78317478","insp_unit_id":"194323369","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328385","insp_unit_license":"PLS7200","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUBCYFE8PHUF3378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:10.000000Z","updated_at":"2025-03-17T22:38:10.000000Z"},{"id":4468676,"change_date":"2023-04-11 21:40:00","inspection_id":"78317478","insp_unit_id":"194323370","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"28200","insp_unit_license":"TRU8416","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28178B092017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:10.000000Z","updated_at":"2025-03-17T22:38:10.000000Z"}]},{"id":2193986,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","dot_number":"28581","report_state":"OH","report_number":"3253015953","insp_date":"2023-01-20 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"153271","location_desc":"ROADSIDE...","county_code_state":"OH","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"5651","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1636244","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-20 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:59.000000Z","updated_at":"2025-03-17T19:06:59.000000Z","inspection_violations":[{"id":3388776,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_violation_id":"250693561","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192986663","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"},{"id":3388777,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_violation_id":"250693562","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192986663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39311"},{"id":3388778,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_violation_id":"250693563","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192986663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"39311"},{"id":3388779,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_violation_id":"250693564","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192986663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3531292,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_unit_id":"192986663","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"315358","insp_unit_license":"PLP7848","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUJC5DV1PHUF3333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:20.000000Z","updated_at":"2025-03-17T22:31:20.000000Z"},{"id":3531293,"change_date":"2023-01-20 21:41:00","inspection_id":"77654255","insp_unit_id":"192986664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"53761","insp_unit_license":"TRL3739","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9532DE526621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:20.000000Z","updated_at":"2025-03-17T22:31:20.000000Z"}]},{"id":1940203,"change_date":"2023-03-01 21:42:00","inspection_id":"77363860","dot_number":"28581","report_state":"OH","report_number":"3285015661","insp_date":"2022-12-13 00:00:00","insp_start_time":"0856","insp_end_time":"0919","registration_date":"2023-03-01 00:00:00","region":"ET","ci_status_code":"C","location":"081","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MILLER BREW","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1630303","transaction_code":"C","transaction_date":"2022-12-13 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:31.000000Z","updated_at":"2025-03-17T19:02:31.000000Z","inspection_violations":[{"id":3014736,"change_date":"2023-03-01 21:42:00","inspection_id":"77363860","insp_violation_id":"251420434","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39216A"},{"id":3014737,"change_date":"2023-03-01 21:42:00","inspection_id":"77363860","insp_violation_id":"251420435","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193653937","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3121998,"change_date":"2023-03-01 21:42:00","inspection_id":"77363860","insp_unit_id":"193653937","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"022428","insp_unit_license":"PWV4007","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMML5LH423218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"}]},{"id":1916411,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","dot_number":"28581","report_state":"OH","report_number":"1808003656","insp_date":"2022-12-08 00:00:00","insp_start_time":"0605","insp_end_time":"0645","registration_date":null,"region":"ET","ci_status_code":"C","location":"15177","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"THE SUPERIOR BEVERAGE GROUP LTD","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1629809","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-09 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:54.000000Z","updated_at":"2025-03-17T19:01:54.000000Z","inspection_violations":[{"id":2979815,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_violation_id":"250027480","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":"WARNING","created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3922"},{"id":2979816,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_violation_id":"250027481","seq_no":"2","part_no":"383","part_no_section":"71(h)","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:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"38371H"},{"id":2979817,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_violation_id":"250027482","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","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:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"39111B4"},{"id":2979818,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_violation_id":"250027483","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192358556","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:08.000000Z","updated_at":"2025-03-17T21:21:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3083599,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_unit_id":"192358556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"328376","insp_unit_license":"PLQ7189","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFEXPDUF3369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"},{"id":3083600,"change_date":"2022-12-09 21:40:00","inspection_id":"77336547","insp_unit_id":"192358557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"28220","insp_unit_license":"TRN1350","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S11E9283LE543065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:06.000000Z","updated_at":"2025-03-17T22:28:06.000000Z"}]},{"id":1834748,"change_date":"2022-11-29 21:41:00","inspection_id":"77243030","dot_number":"28581","report_state":"OH","report_number":"3225017633","insp_date":"2022-11-23 00:00:00","insp_start_time":"0600","insp_end_time":"0625","registration_date":null,"region":"ET","ci_status_code":"C","location":"09911","location_desc":"ROAD SIDE","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"7095672","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"1627437","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:23.000000Z","updated_at":"2025-03-17T19:00:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2951955,"change_date":"2022-11-29 21:41:00","inspection_id":"77243030","insp_unit_id":"192173595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628220","insp_unit_license":"PJA3595","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY4GDGZ0610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:12.000000Z","updated_at":"2025-03-17T22:27:12.000000Z"},{"id":2951956,"change_date":"2022-11-29 21:41:00","inspection_id":"77243030","insp_unit_id":"192173596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"NONE","insp_unit_license":"TQQ6689","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28108B092019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:12.000000Z","updated_at":"2025-03-17T22:27:12.000000Z"}]},{"id":1798305,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","dot_number":"28581","report_state":"OH","report_number":"3248016257","insp_date":"2022-11-22 00:00:00","insp_start_time":"1309","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"15580","location_desc":"GIRARD(HUBBARD)SCALES","county_code_state":"OH","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","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":"1627322","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:42.000000Z","updated_at":"2025-03-17T18:59:42.000000Z","inspection_violations":[{"id":2811229,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","insp_violation_id":"249743924","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"192089692","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"39345D"},{"id":2811230,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","insp_violation_id":"249743925","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"192089693","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"39355D2"},{"id":2811231,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","insp_violation_id":"249743926","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192089693","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2892612,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","insp_unit_id":"192089692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628227","insp_unit_license":"PJA3598","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY7GDGZ0617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2892613,"change_date":"2022-11-22 21:41:00","inspection_id":"77201369","insp_unit_id":"192089693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2633002","insp_unit_license":"TNX5390","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS128XFP263302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1625745,"change_date":"2022-10-28 21:40:00","inspection_id":"77003427","dot_number":"28581","report_state":"OH","report_number":"3258009493","insp_date":"2022-10-28 00:00:00","insp_start_time":"1225","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"04171","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"041","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE GROUP","shipping_paper_number":"140002625","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"95000","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":"1623661","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:39.000000Z","updated_at":"2025-03-17T18:56:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2615581,"change_date":"2022-10-28 21:40:00","inspection_id":"77003427","insp_unit_id":"191698831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"PMH4252","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X4NJ488471","insp_unit_decal":"Y","insp_unit_decal_number":"31947925","created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"},{"id":2615582,"change_date":"2022-10-28 21:40:00","inspection_id":"77003427","insp_unit_id":"191698832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1436474PLA","insp_unit_license":"3312040","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D8EL807954","insp_unit_decal":"Y","insp_unit_decal_number":"31947926","created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"}]},{"id":1423753,"change_date":"2022-10-03 21:40:00","inspection_id":"76770392","dot_number":"28581","report_state":"OH","report_number":"3285015434","insp_date":"2022-10-03 00:00:00","insp_start_time":"0702","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"0817","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"1619307","transaction_code":"A","transaction_date":"2022-10-03 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-03 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-10-03 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:02.000000Z","updated_at":"2025-03-17T18:53:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2292381,"change_date":"2022-10-03 21:40:00","inspection_id":"76770392","insp_unit_id":"191230188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628220","insp_unit_license":"PJA3595","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY4GDGZ0610","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:22:41.000000Z","updated_at":"2025-03-17T22:22:41.000000Z"},{"id":2292382,"change_date":"2022-10-03 21:40:00","inspection_id":"76770392","insp_unit_id":"191230189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"TRU8416","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28178B092017","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:22:41.000000Z","updated_at":"2025-03-17T22:22:41.000000Z"}]},{"id":1315795,"change_date":"2022-09-19 21:40:00","inspection_id":"76645150","dot_number":"28581","report_state":"OH","report_number":"3233014001","insp_date":"2022-09-19 00:00:00","insp_start_time":"0715","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"15321","location_desc":"ROADSIDE (SR21)","county_code_state":"OH","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"1606","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","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":"1616915","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-19 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-19 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:52.000000Z","updated_at":"2025-03-17T18:50:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2118471,"change_date":"2022-09-19 21:40:00","inspection_id":"76645150","insp_unit_id":"190974460","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"444442","insp_unit_license":"PMR6636","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYFE3NDNP8098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:31.000000Z","updated_at":"2025-03-17T22:21:31.000000Z"},{"id":2118472,"change_date":"2022-09-19 21:40:00","inspection_id":"76645150","insp_unit_id":"190974461","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"920","insp_unit_license":"TRE2364","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS25399P811607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:31.000000Z","updated_at":"2025-03-17T22:21:31.000000Z"}]},{"id":1249413,"change_date":"2022-09-09 21:38:00","inspection_id":"76567649","dot_number":"28581","report_state":"OH","report_number":"3225017346","insp_date":"2022-09-08 00:00:00","insp_start_time":"0617","insp_end_time":"0645","registration_date":null,"region":"ET","ci_status_code":"C","location":"09911","location_desc":"ROAD SIDE","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"6938661","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"75000","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":"1614902","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2010769,"change_date":"2022-09-09 21:38:00","inspection_id":"76567649","insp_unit_id":"190812041","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628224","insp_unit_license":"PKQ6986","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY1GDGZ0614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:49.000000Z","updated_at":"2025-03-17T22:20:49.000000Z"},{"id":2010770,"change_date":"2022-09-09 21:38:00","inspection_id":"76567649","insp_unit_id":"190812042","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"28201","insp_unit_license":"TTB1198","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A28138B092001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:49.000000Z","updated_at":"2025-03-17T22:20:49.000000Z"}]},{"id":1196856,"change_date":"2022-09-01 21:41:00","inspection_id":"76506996","dot_number":"28581","report_state":"OH","report_number":"3285015360","insp_date":"2022-09-01 00:00:00","insp_start_time":"0904","insp_end_time":"0922","registration_date":null,"region":"ET","ci_status_code":"C","location":"08122","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"COORS","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1613811","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-01 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-01 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:40.000000Z","updated_at":"2025-03-17T18:48:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1924522,"change_date":"2022-09-01 21:41:00","inspection_id":"76506996","insp_unit_id":"190687764","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PKP7735","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY5GDGT6913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"},{"id":1924523,"change_date":"2022-09-01 21:41:00","inspection_id":"76506996","insp_unit_id":"190687765","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"918","insp_unit_license":"TPY7771","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS25379P811606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"}]},{"id":983550,"change_date":"2022-08-08 21:39:00","inspection_id":"76258492","dot_number":"28581","report_state":"OH","report_number":"3281021665","insp_date":"2022-08-08 00:00:00","insp_start_time":"0913","insp_end_time":"0959","registration_date":null,"region":"ET","ci_status_code":"C","location":"155","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SUPERIOR BEVERAGE.","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1610292","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-08 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-08-08 21:39:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:04.000000Z","updated_at":"2025-03-17T18:45:04.000000Z","inspection_violations":[{"id":1549437,"change_date":"2022-08-08 21:39:00","inspection_id":"76258492","insp_violation_id":"247567814","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39216A"},{"id":1549438,"change_date":"2022-08-08 21:39:00","inspection_id":"76258492","insp_violation_id":"247567815","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190182349","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1583000,"change_date":"2022-08-08 21:39:00","inspection_id":"76258492","insp_unit_id":"190182349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"511582","insp_unit_license":"PVY1795","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HSDJAPR1FH735404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:58.000000Z","updated_at":"2025-03-17T22:17:58.000000Z"},{"id":1583001,"change_date":"2022-08-08 21:39:00","inspection_id":"76258492","insp_unit_id":"190182350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"48175","insp_unit_license":"TQU9960","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1S12E9483HE535475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:58.000000Z","updated_at":"2025-03-17T22:17:58.000000Z"}]},{"id":516282,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","dot_number":"28581","report_state":"OH","report_number":"3255015106","insp_date":"2022-05-30 00:00:00","insp_start_time":"0644","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"093057","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-31 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1600073","transaction_code":"C","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-31 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[{"id":818801,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875785","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203863550","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3922"},{"id":818802,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875786","seq_no":"2","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"203863550","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"393207A"},{"id":818803,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875787","seq_no":"3","part_no":"396","part_no_section":"3A1-TC","insp_viol_unit":"1","insp_unit_id":"203863550","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3963A1TC"},{"id":818804,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875788","seq_no":"4","part_no":"392","part_no_section":"9A2","insp_viol_unit":"1","insp_unit_id":"203863550","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3929A2"},{"id":818805,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875789","seq_no":"5","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"203863550","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"39345B2UV"},{"id":818806,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875790","seq_no":"6","part_no":"392","part_no_section":"2MI","insp_viol_unit":"2","insp_unit_id":"203863551","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3922MI"},{"id":818807,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875791","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203863551","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"39347E"},{"id":818808,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875792","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"203863551","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"39353B"},{"id":818809,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_violation_id":"262875793","seq_no":"9","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"203863551","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":830969,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_unit_id":"203863550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102598","insp_unit_license":"2256463","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV6FSGC9655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:20.000000Z","updated_at":"2025-03-17T22:13:20.000000Z"},{"id":830970,"change_date":"2024-11-13 21:40:00","inspection_id":"75708727","insp_unit_id":"203863551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"U35306","insp_unit_license":"TRV9481","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS25357G119101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:20.000000Z","updated_at":"2025-03-17T22:13:20.000000Z"}]},{"id":386312,"change_date":"2022-05-13 21:40:00","inspection_id":"75553639","dot_number":"28581","report_state":"OH","report_number":"3225016832","insp_date":"2022-05-11 00:00:00","insp_start_time":"0600","insp_end_time":"0625","registration_date":null,"region":"ET","ci_status_code":"C","location":"099680","location_desc":"ROAD SIDE","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"6676221","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1596415","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-13 21:40:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:24.000000Z","updated_at":"2025-03-17T18:34:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":624489,"change_date":"2022-05-13 21:40:00","inspection_id":"75553639","insp_unit_id":"188675329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628225","insp_unit_license":"PJB2275","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY3GDGZ0615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:01.000000Z","updated_at":"2025-03-17T22:12:01.000000Z"},{"id":624490,"change_date":"2022-05-13 21:40:00","inspection_id":"75553639","insp_unit_id":"188675330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"918","insp_unit_license":"TPY7771","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS25379P811606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:01.000000Z","updated_at":"2025-03-17T22:12:01.000000Z"}]},{"id":20155,"change_date":"2022-03-22 21:31:00","inspection_id":"75107253","dot_number":"28581","report_state":"OH","report_number":"3248016132","insp_date":"2022-03-22 00:00:00","insp_start_time":"0635","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"09911","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-22 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1587059","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00028581","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-03-22 21:31:00","insp_carrier_name":"THE SUPERIOR BEVERAGE GROUP LTD","insp_carrier_street":"31031 DIAMOND PARKWAY","insp_carrier_city":"GLENWILLOW","insp_carrier_state":"OH","insp_carrier_zip_code":"44139","insp_colonia":null,"docket_number":"665794","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:03.000000Z","updated_at":"2025-03-17T18:28:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":32486,"change_date":"2022-03-22 21:31:00","inspection_id":"75107253","insp_unit_id":"187755659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"628225","insp_unit_license":"PJB2275","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKBCYCY3GDGZ0615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"},{"id":32487,"change_date":"2022-03-22 21:31:00","inspection_id":"75107253","insp_unit_id":"187755660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2633002","insp_unit_license":"TNX5390","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS128XFP263302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/28581\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/28581\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/28581\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/28581\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}