{"current_page":1,"data":[{"id":7797596,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","dot_number":"2741425","report_state":"CA","report_number":"UBGO004648","insp_date":"2025-02-05 00:00:00","insp_start_time":"1000","insp_end_time":"1028","registration_date":null,"region":"PT","ci_status_code":"C","location":"426","location_desc":"BUTTONWILLOW","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-05 21:40: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":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15694207","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2025-02-05 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-05 21:40:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:59:58.000000Z","updated_at":"2025-03-17T20:59:58.000000Z","inspection_violations":[{"id":12185321,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","insp_violation_id":"264363114","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"205179756","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"39311A1LHLM"},{"id":12185322,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","insp_violation_id":"264363115","seq_no":"2","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"205179757","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059588","created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"39311A1LIL"},{"id":12185323,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","insp_violation_id":"264363116","seq_no":"3","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"2","insp_unit_id":"205179757","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CU059588","created_at":"2025-03-17T22:05:28.000000Z","updated_at":"2025-03-17T22:05:28.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":12583810,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","insp_unit_id":"205179756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB16","insp_unit_license":"9G99404","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X0RD678286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:00.000000Z","updated_at":"2025-03-17T23:54:00.000000Z"},{"id":12583811,"change_date":"2025-02-05 21:40:00","inspection_id":"83791336","insp_unit_id":"205179757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"4HY7820","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2MN011AJ671007106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:00.000000Z","updated_at":"2025-03-17T23:54:00.000000Z"}]},{"id":7619483,"change_date":"2025-01-14 21:55:00","inspection_id":"83604249","dot_number":"2741425","report_state":"CA","report_number":"NBFL006003","insp_date":"2025-01-09 00:00:00","insp_start_time":"0639","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCED BEVERAGE COMPANY","shipping_paper_number":"1\/9\/2025","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-14 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"15659994","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:56:11.000000Z","updated_at":"2025-03-17T20:56:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12294480,"change_date":"2025-01-14 21:55:00","inspection_id":"83604249","insp_unit_id":"204834684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB18","insp_unit_license":"9G99584","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49X2RD678287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:40.000000Z","updated_at":"2025-03-17T23:50:40.000000Z"},{"id":12294481,"change_date":"2025-01-14 21:55:00","inspection_id":"83604249","insp_unit_id":"204834685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1","insp_unit_license":"4JY7690","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9227NS052909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:40.000000Z","updated_at":"2025-03-17T23:50:40.000000Z"}]},{"id":6821384,"change_date":"2024-09-25 21:42:00","inspection_id":"82761049","dot_number":"2741425","report_state":"CA","report_number":"ND6D006173","insp_date":"2024-09-20 00:00:00","insp_start_time":"0518","insp_end_time":"0539","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCE BEVERAGE CO INC","shipping_paper_number":"1916347","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15533424","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-25 21:42:00","snet_input_date":"2024-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:38:33.000000Z","updated_at":"2025-03-17T20:38:33.000000Z","inspection_violations":[{"id":10623766,"change_date":"2024-09-25 21:42:00","inspection_id":"82761049","insp_violation_id":"262038937","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"203134074","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":11000222,"change_date":"2024-09-25 21:42:00","inspection_id":"82761049","insp_unit_id":"203134074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB600","insp_unit_license":"80609K2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HJ7X0JM226563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"}]},{"id":6855836,"change_date":"2024-09-30 21:41:00","inspection_id":"82797481","dot_number":"2741425","report_state":"CA","report_number":"NCNO002177","insp_date":"2024-09-18 00:00:00","insp_start_time":"0808","insp_end_time":"0850","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539922","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[{"id":10678186,"change_date":"2024-09-30 21:41:00","inspection_id":"82797481","insp_violation_id":"262111377","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"203201247","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"39345"},{"id":10678187,"change_date":"2024-09-30 21:41:00","inspection_id":"82797481","insp_violation_id":"262111378","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203201247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11056072,"change_date":"2024-09-30 21:41:00","inspection_id":"82797481","insp_unit_id":"203201247","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AB525","insp_unit_license":"9F56966","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HSMTAAN0FH745096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056073,"change_date":"2024-09-30 21:41:00","inspection_id":"82797481","insp_unit_id":"203201248","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"495","insp_unit_license":"4HX8887","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HHRTX2167M000405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855837,"change_date":"2024-09-30 21:41:00","inspection_id":"82797482","dot_number":"2741425","report_state":"CA","report_number":"NCNO002178","insp_date":"2024-09-18 00:00:00","insp_start_time":"0855","insp_end_time":"0940","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539923","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056074,"change_date":"2024-09-30 21:41:00","inspection_id":"82797482","insp_unit_id":"203201249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB570","insp_unit_license":"9G13625","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2XP2AJ7X1LM718421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056075,"change_date":"2024-09-30 21:41:00","inspection_id":"82797482","insp_unit_id":"203201250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"500","insp_unit_license":"4HX8888","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HHRTX2147M000404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855838,"change_date":"2024-09-30 21:41:00","inspection_id":"82797483","dot_number":"2741425","report_state":"CA","report_number":"NCNO002179","insp_date":"2024-09-18 00:00:00","insp_start_time":"0942","insp_end_time":"1033","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539924","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056076,"change_date":"2024-09-30 21:41:00","inspection_id":"82797483","insp_unit_id":"203201251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB565","insp_unit_license":"9G13627","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2XP2AJ7XXLM718420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056077,"change_date":"2024-09-30 21:41:00","inspection_id":"82797483","insp_unit_id":"203201252","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"510","insp_unit_license":"4EK3808","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HHRTX21X4M000144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855852,"change_date":"2024-09-30 21:41:00","inspection_id":"82797498","dot_number":"2741425","report_state":"CA","report_number":"NCNO002180","insp_date":"2024-09-18 00:00:00","insp_start_time":"1036","insp_end_time":"1115","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100350","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":"15539925","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056094,"change_date":"2024-09-30 21:41:00","inspection_id":"82797498","insp_unit_id":"203201274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB550","insp_unit_license":"9F53643","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2XP2AJ8X8LM669832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056095,"change_date":"2024-09-30 21:41:00","inspection_id":"82797498","insp_unit_id":"203201275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"TA15","insp_unit_license":"4KG1511","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2472NU646208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855853,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","dot_number":"2741425","report_state":"CA","report_number":"NCNO002181","insp_date":"2024-09-18 00:00:00","insp_start_time":"1120","insp_end_time":"1204","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"101200","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539926","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[{"id":10678200,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","insp_violation_id":"262111400","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203201276","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3965B"},{"id":10678201,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","insp_violation_id":"262111401","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203201276","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"3939A"},{"id":10678202,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","insp_violation_id":"262111402","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203201277","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:41.000000Z","updated_at":"2025-03-17T21:57:41.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11056096,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","insp_unit_id":"203201276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AB8","insp_unit_license":"9G50479","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDYAPR1KL416863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056097,"change_date":"2024-09-30 21:41:00","inspection_id":"82797499","insp_unit_id":"203201277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"TA7","insp_unit_license":"1WZ5370","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1H4V04522GJ017604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855854,"change_date":"2024-09-30 21:41:00","inspection_id":"82797500","dot_number":"2741425","report_state":"CA","report_number":"NCNO002182","insp_date":"2024-09-18 00:00:00","insp_start_time":"1242","insp_end_time":"1329","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539927","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056098,"change_date":"2024-09-30 21:41:00","inspection_id":"82797500","insp_unit_id":"203201278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB555","insp_unit_license":"9G10664","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2XP2AJ7X1LM718418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056099,"change_date":"2024-09-30 21:41:00","inspection_id":"82797500","insp_unit_id":"203201279","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"385","insp_unit_license":"4BD2144","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HHRTX215YM000252","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855855,"change_date":"2024-09-30 21:41:00","inspection_id":"82797501","dot_number":"2741425","report_state":"CA","report_number":"NCNO002183","insp_date":"2024-09-18 00:00:00","insp_start_time":"1333","insp_end_time":"1410","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15539928","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056100,"change_date":"2024-09-30 21:41:00","inspection_id":"82797501","insp_unit_id":"203201280","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB610","insp_unit_license":"60789C2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HJ6XXLM689380","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855872,"change_date":"2024-09-30 21:41:00","inspection_id":"82797518","dot_number":"2741425","report_state":"CA","report_number":"NCNO002184","insp_date":"2024-09-18 00:00:00","insp_start_time":"1413","insp_end_time":"1458","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"100050","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":"15539929","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056122,"change_date":"2024-09-30 21:41:00","inspection_id":"82797518","insp_unit_id":"203201303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB10","insp_unit_license":"9G79041","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2XP8AJ8X7PM889155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056123,"change_date":"2024-09-30 21:41:00","inspection_id":"82797518","insp_unit_id":"203201304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TA10","insp_unit_license":"4AN5799","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT011AJ1Y9005385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855873,"change_date":"2024-09-30 21:41:00","inspection_id":"82797519","dot_number":"2741425","report_state":"CA","report_number":"NCNO002185","insp_date":"2024-09-18 00:00:00","insp_start_time":"1502","insp_end_time":"1546","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"98200","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":"15539930","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056124,"change_date":"2024-09-30 21:41:00","inspection_id":"82797519","insp_unit_id":"203201305","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AB14","insp_unit_license":"9G85493","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDYAPR5RL440514","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"},{"id":11056125,"change_date":"2024-09-30 21:41:00","inspection_id":"82797519","insp_unit_id":"203201306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLM","insp_unit_company":"TA09","insp_unit_license":"4JA7595","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2MN011AJ471007105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6855874,"change_date":"2024-09-30 21:41:00","inspection_id":"82797520","dot_number":"2741425","report_state":"CA","report_number":"NCNO002186","insp_date":"2024-09-18 00:00:00","insp_start_time":"1550","insp_end_time":"1626","registration_date":null,"region":"PD","ci_status_code":"C","location":"420","location_desc":"BAKERSFIELD","county_code_state":"CA","county_code":"029","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","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":"15539931","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11056126,"change_date":"2024-09-30 21:41:00","inspection_id":"82797520","insp_unit_id":"203201307","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"GDAN","insp_unit_company":"TA835","insp_unit_license":"4KE7620","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9223NS052910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:30.000000Z","updated_at":"2025-03-17T23:37:30.000000Z"}]},{"id":6772308,"change_date":"2024-09-19 21:42:00","inspection_id":"82708566","dot_number":"2741425","report_state":"CA","report_number":"NBFL005781","insp_date":"2024-09-13 00:00:00","insp_start_time":"1124","insp_end_time":"1144","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCED BEVERAGE","shipping_paper_number":"9\/13\/2024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15527192","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10920829,"change_date":"2024-09-19 21:42:00","inspection_id":"82708566","insp_unit_id":"203035712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB 600","insp_unit_license":"80609K2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HJ7X0JM226563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"}]},{"id":1068099,"change_date":"2022-08-17 21:41:00","inspection_id":"76357048","dot_number":"2741425","report_state":"CA","report_number":"ND6D003597","insp_date":"2022-08-15 00:00:00","insp_start_time":"0602","insp_end_time":"0621","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ADVANCE BEVERAGE","shipping_paper_number":"00","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14551455","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02741425","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"ADVANCE BEVERAGE CO INC","insp_carrier_street":"5200 DISTRICT BLVD","insp_carrier_city":"BAKERSFIELD","insp_carrier_state":"CA","insp_carrier_zip_code":"93313","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"49410","created_at":"2025-03-17T18:46:31.000000Z","updated_at":"2025-03-17T18:46:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1718741,"change_date":"2022-08-17 21:41:00","inspection_id":"76357048","insp_unit_id":"190383702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AB605","insp_unit_license":"39488G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP2HJ6X0KM611981","insp_unit_decal":"Y","insp_unit_decal_number":"31498499","created_at":"2025-03-17T22:18:50.000000Z","updated_at":"2025-03-17T22:18:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2741425\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2741425\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2741425\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2741425\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}