{"current_page":1,"data":[{"id":6797087,"change_date":"2024-09-23 21:41:00","inspection_id":"82735359","dot_number":"3536615","report_state":"OH","report_number":"1441000327","insp_date":"2024-09-23 00:00:00","insp_start_time":"1505","insp_end_time":"1519","registration_date":null,"region":"ET","ci_status_code":"C","location":"097070","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"UNFI-IN","shipping_paper_number":"024819","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-09-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1758275","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":"M","census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:47.000000Z","updated_at":"2025-03-17T20:37:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10960976,"change_date":"2024-09-23 21:41:00","inspection_id":"82735359","insp_unit_id":"203084856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:33.000000Z","updated_at":"2025-03-17T23:36:33.000000Z"},{"id":10960977,"change_date":"2024-09-23 21:41:00","inspection_id":"82735359","insp_unit_id":"203084857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B235","insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:33.000000Z","updated_at":"2025-03-17T23:36:33.000000Z"}]},{"id":4747257,"change_date":"2024-01-02 21:44:00","inspection_id":"80516872","dot_number":"3536615","report_state":"WY","report_number":"PMLB000095","insp_date":"2023-12-28 00:00:00","insp_start_time":"1335","insp_end_time":"1430","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML80","location_desc":"EVANSTON POE","county_code_state":"WY","county_code":"041","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LACTALIS","shipping_paper_number":"3390184","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-01-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"441037","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2024-01-02 21:44:00","snet_input_date":"2023-12-28 00:00:00","source_office":"4WYS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":7326016,"change_date":"2024-01-02 21:44:00","inspection_id":"80516872","insp_violation_id":"257144711","seq_no":"1","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39532B"}],"inspection_per_units":[{"id":7636661,"change_date":"2024-01-02 21:44:00","inspection_id":"80516872","insp_unit_id":"198771504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:16.000000Z","updated_at":"2025-03-17T23:04:16.000000Z"},{"id":7636662,"change_date":"2024-01-02 21:44:00","inspection_id":"80516872","insp_unit_id":"198771505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:16.000000Z","updated_at":"2025-03-17T23:04:16.000000Z"}]},{"id":4277644,"change_date":"2023-10-24 21:41:00","inspection_id":"80000429","dot_number":"3536615","report_state":"CA","report_number":"UEHJ004153","insp_date":"2023-10-21 00:00:00","insp_start_time":"0225","insp_end_time":"0323","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":"KNUTZEN FARMS","shipping_paper_number":"230206","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15109389","transaction_code":"A","transaction_date":"2023-10-22 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-10-24 21:41:00","snet_input_date":"2023-10-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-24 21:41:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"577124","created_at":"2025-03-17T19:47:29.000000Z","updated_at":"2025-03-17T19:47:29.000000Z","inspection_violations":[{"id":6616916,"change_date":"2023-10-24 21:41:00","inspection_id":"80000429","insp_violation_id":"256026047","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":6879719,"change_date":"2023-10-24 21:41:00","inspection_id":"80000429","insp_unit_id":"197731701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"},{"id":6879720,"change_date":"2023-10-24 21:41:00","inspection_id":"80000429","insp_unit_id":"197731702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B235","insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":4262823,"change_date":"2023-10-23 21:42:00","inspection_id":"79984119","dot_number":"3536615","report_state":"OR","report_number":"AAYB008154","insp_date":"2023-10-20 00:00:00","insp_start_time":"0955","insp_end_time":"1019","registration_date":null,"region":"PT","ci_status_code":"C","location":"1007","location_desc":"BOOTH RANCH SB - N OF MYRTLE C","county_code_state":"OR","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KNUTZEN FARMS","shipping_paper_number":"230206","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-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","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":"1236227","transaction_code":"A","transaction_date":"2023-10-20 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-23 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619-5286","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"019747","created_at":"2025-03-17T19:47:24.000000Z","updated_at":"2025-03-17T19:47:24.000000Z","inspection_violations":[{"id":6593871,"change_date":"2023-10-23 21:42:00","inspection_id":"79984119","insp_violation_id":"255990674","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197700067","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6855659,"change_date":"2023-10-23 21:42:00","inspection_id":"79984119","insp_unit_id":"197700066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"},{"id":6855660,"change_date":"2023-10-23 21:42:00","inspection_id":"79984119","insp_unit_id":"197700067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"}]},{"id":3866355,"change_date":"2023-08-30 21:44:00","inspection_id":"79544176","dot_number":"3536615","report_state":"GA","report_number":"1289003973","insp_date":"2023-08-24 00:00:00","insp_start_time":"0630","insp_end_time":"0715","registration_date":null,"region":"ET","ci_status_code":"C","location":"B","location_desc":"MULTI-LANE URBAN HIGHWAY","county_code_state":"GA","county_code":"297","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1996911","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-30 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-08-30 21:44:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619-5286","insp_colonia":null,"docket_number":"1179288","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:21.000000Z","updated_at":"2025-03-17T19:39:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6215675,"change_date":"2023-08-30 21:44:00","inspection_id":"79544176","insp_unit_id":"196807586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"},{"id":6215676,"change_date":"2023-08-30 21:44:00","inspection_id":"79544176","insp_unit_id":"196807587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B35","insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"}]},{"id":3654203,"change_date":"2023-08-02 21:41:00","inspection_id":"79307027","dot_number":"3536615","report_state":"MO","report_number":"AT04003849","insp_date":"2023-07-31 00:00:00","insp_start_time":"1427","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":"A70","location_desc":"I-70 AT 35MM","county_code_state":"MO","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"COLORADO SOUTHERN FARMS","shipping_paper_number":"381825","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-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2086247","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619-5286","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5875701,"change_date":"2023-08-02 21:41:00","inspection_id":"79307027","insp_unit_id":"196326585","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5875702,"change_date":"2023-08-02 21:41:00","inspection_id":"79307027","insp_unit_id":"196326586","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3435682,"change_date":"2023-07-05 21:42:00","inspection_id":"79061700","dot_number":"3536615","report_state":"CO","report_number":"PF05411196","insp_date":"2023-06-30 00:00:00","insp_start_time":"2035","insp_end_time":"2053","registration_date":null,"region":"MT","ci_status_code":"C","location":"H50","location_desc":"LAMAR POE WB","county_code_state":"CO","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MOLO SOLUTIONS, LLC","shipping_paper_number":"6000897362","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248633","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-07-05 21:42:00","snet_input_date":"2023-07-05 00:00:00","source_office":"4COS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619-5286","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:58.000000Z","updated_at":"2025-03-17T19:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5524349,"change_date":"2023-07-05 21:42:00","inspection_id":"79061700","insp_unit_id":"195832766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"},{"id":5524350,"change_date":"2023-07-05 21:42:00","inspection_id":"79061700","insp_unit_id":"195832767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"}]},{"id":3215789,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","dot_number":"3536615","report_state":"CA","report_number":"NBYQ004488","insp_date":"2023-06-03 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO PLATFORM SCALE","county_code_state":"CA","county_code":"111","insp_level_id":"1","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":"2023-06-05 21:43: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":"14930155","transaction_code":"A","transaction_date":"2023-06-03 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-06-05 21:43:00","snet_input_date":"2023-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-05 21:43:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"577124","created_at":"2025-03-17T19:26:31.000000Z","updated_at":"2025-03-17T19:26:31.000000Z","inspection_violations":[{"id":4955959,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","insp_violation_id":"253304552","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195331848","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3922"},{"id":4955960,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","insp_violation_id":"253304553","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195331848","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3963A1"},{"id":4955961,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","insp_violation_id":"253304554","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195331848","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:03.000000Z","updated_at":"2025-03-17T21:30:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5171994,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","insp_unit_id":"195331847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"Y","insp_unit_decal_number":"32544724","created_at":"2025-03-17T22:43:45.000000Z","updated_at":"2025-03-17T22:43:45.000000Z"},{"id":5171995,"change_date":"2023-06-05 21:43:00","inspection_id":"78814193","insp_unit_id":"195331848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B235","insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:45.000000Z","updated_at":"2025-03-17T22:43:45.000000Z"}]},{"id":2912972,"change_date":"2023-04-27 21:43:00","inspection_id":"78472445","dot_number":"3536615","report_state":"UT","report_number":"23TR000596","insp_date":"2023-04-26 00:00:00","insp_start_time":"1553","insp_end_time":"1641","registration_date":null,"region":"MT","ci_status_code":"C","location":"PERRY","location_desc":"PERRY PORT OF ENTRY","county_code_state":"UT","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ANHUESER BUSCH","shipping_paper_number":"6228727","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"880411","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-26 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:27.000000Z","updated_at":"2025-03-17T19:20:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4686611,"change_date":"2023-04-27 21:43:00","inspection_id":"78472445","insp_unit_id":"194633331","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:57.000000Z","updated_at":"2025-03-17T22:39:57.000000Z"},{"id":4686612,"change_date":"2023-04-27 21:43:00","inspection_id":"78472445","insp_unit_id":"194633332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU7935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:57.000000Z","updated_at":"2025-03-17T22:39:57.000000Z"}]},{"id":2670530,"change_date":"2023-03-27 21:40:00","inspection_id":"78196315","dot_number":"3536615","report_state":"CA","report_number":"UEBX001643","insp_date":"2023-03-24 00:00:00","insp_start_time":"2328","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TAYLOR FARMS","shipping_paper_number":"3461367","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14834273","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4104900,"change_date":"2023-03-27 21:40:00","inspection_id":"78196315","insp_violation_id":"251891231","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194085665","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD06921","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4300031,"change_date":"2023-03-27 21:40:00","inspection_id":"78196315","insp_unit_id":"194085665","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/RED","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"},{"id":4300032,"change_date":"2023-03-27 21:40:00","inspection_id":"78196315","insp_unit_id":"194085666","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHITE","insp_unit_license":"4KR35556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"}]},{"id":2482972,"change_date":"2023-03-01 21:42:00","inspection_id":"77983575","dot_number":"3536615","report_state":"AZ","report_number":"0Y25000947","insp_date":"2023-02-28 00:00:00","insp_start_time":"1410","insp_end_time":"1445","registration_date":null,"region":"MT","ci_status_code":"C","location":"TPOE","location_desc":"TOPOCK PORT OF ENTRY","county_code_state":"AZ","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"GRIMMWAY FARMS","shipping_paper_number":"46216801","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":"Y","pen_cen_match":"I","final_status_date":"2023-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118250","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1800352","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-03-01 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619-5286","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:29.000000Z","updated_at":"2025-03-17T19:12:29.000000Z","inspection_violations":[{"id":3820834,"change_date":"2023-03-01 21:42:00","inspection_id":"77983575","insp_violation_id":"251421935","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"39524C2III"},{"id":3820835,"change_date":"2023-03-01 21:42:00","inspection_id":"77983575","insp_violation_id":"251421936","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":3995631,"change_date":"2023-03-01 21:42:00","inspection_id":"77983575","insp_unit_id":"193654873","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"},{"id":3995632,"change_date":"2023-03-01 21:42:00","inspection_id":"77983575","insp_unit_id":"193654874","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"}]},{"id":2251345,"change_date":"2023-01-30 21:43:00","inspection_id":"77719611","dot_number":"3536615","report_state":"AR","report_number":"761C000583","insp_date":"2023-01-29 00:00:00","insp_start_time":"1657","insp_end_time":"1713","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"FRESHPOINT","shipping_paper_number":"1157174066","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-30 21:43: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":"1442565","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-30 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:08.000000Z","updated_at":"2025-03-17T19:08:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3623269,"change_date":"2023-01-30 21:43:00","inspection_id":"77719611","insp_unit_id":"193119488","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"},{"id":3623270,"change_date":"2023-01-30 21:43:00","inspection_id":"77719611","insp_unit_id":"193119489","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"}]},{"id":1726057,"change_date":"2022-11-14 21:41:00","inspection_id":"77118402","dot_number":"3536615","report_state":"LA","report_number":"LANM003448","insp_date":"2022-11-10 00:00:00","insp_start_time":"0642","insp_end_time":"0700","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"015","insp_level_id":"3","service_center":"SH","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148640","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":"M","census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[{"id":2703738,"change_date":"2022-11-14 21:41:00","inspection_id":"77118402","insp_violation_id":"249565642","seq_no":"1","part_no":"392","part_no_section":"22(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:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39222A"},{"id":2703739,"change_date":"2022-11-14 21:41:00","inspection_id":"77118402","insp_violation_id":"249565643","seq_no":"2","part_no":"392","part_no_section":"22(b)","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:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"39222B"}],"inspection_per_units":[{"id":2776500,"change_date":"2022-11-14 21:41:00","inspection_id":"77118402","insp_unit_id":"191924485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"},{"id":2776501,"change_date":"2022-11-14 21:41:00","inspection_id":"77118402","insp_unit_id":"191924486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"}]},{"id":1706847,"change_date":"2022-11-09 21:40:00","inspection_id":"77096326","dot_number":"3536615","report_state":"SC","report_number":"B341001411","insp_date":"2022-11-07 00:00:00","insp_start_time":"2040","insp_end_time":"2110","registration_date":null,"region":"ET","ci_status_code":"C","location":"107","location_desc":"I-85 NB ROADSIDE","county_code_state":"SC","county_code":"021","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CLASSIC FRUIT CO","shipping_paper_number":"225507","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1057842","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-07 00:00:00","source_office":"2SCS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2674836,"change_date":"2022-11-09 21:40:00","inspection_id":"77096326","insp_violation_id":"249516949","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"},{"id":2674837,"change_date":"2022-11-09 21:40:00","inspection_id":"77096326","insp_violation_id":"249516950","seq_no":"2","part_no":"391","part_no_section":"11(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39111B2"}],"inspection_per_units":[{"id":2745739,"change_date":"2022-11-09 21:40:00","inspection_id":"77096326","insp_unit_id":"191881290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP62525","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ0PN615264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2745740,"change_date":"2022-11-09 21:40:00","inspection_id":"77096326","insp_unit_id":"191881291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"B235","insp_unit_license":"4KR3556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534AU891601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1590571,"change_date":"2022-10-25 21:40:00","inspection_id":"76962928","dot_number":"3536615","report_state":"MS","report_number":"3017010807","insp_date":"2022-10-24 00:00:00","insp_start_time":"0912","insp_end_time":"0933","registration_date":null,"region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"CLASSIC FRUIT COMPANY","shipping_paper_number":"225221","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"995022","transaction_code":"A","transaction_date":"2022-10-24 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2022-10-25 21:40:00","snet_input_date":"2022-10-25 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-10-25 21:40:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:56.000000Z","updated_at":"2025-03-17T18:55:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2559054,"change_date":"2022-10-25 21:40:00","inspection_id":"76962928","insp_unit_id":"191617636","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:32.000000Z","updated_at":"2025-03-17T22:24:32.000000Z"},{"id":2559055,"change_date":"2022-10-25 21:40:00","inspection_id":"76962928","insp_unit_id":"191617637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4050","insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:32.000000Z","updated_at":"2025-03-17T22:24:32.000000Z"}]},{"id":555244,"change_date":"2022-06-06 21:41:00","inspection_id":"75754761","dot_number":"3536615","report_state":"CA","report_number":"UBN4001307","insp_date":"2022-06-03 00:00:00","insp_start_time":"1220","insp_end_time":"1240","registration_date":null,"region":"PT","ci_status_code":"C","location":"740","location_desc":"SR-46 @ GOLDEN HILL RD","county_code_state":"CA","county_code":"079","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DRISCOLL'S","shipping_paper_number":"10469107","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14456801","transaction_code":"A","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03536615","upload_search_indicator":null,"census_search_date":"2022-06-06 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"Z SANDHU INC","insp_carrier_street":"3727 HIGHCLERE WAY","insp_carrier_city":"CLOVIS","insp_carrier_state":"CA","insp_carrier_zip_code":"93619","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"577124","created_at":"2025-03-17T18:37:28.000000Z","updated_at":"2025-03-17T18:37:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":893459,"change_date":"2022-06-06 21:41:00","inspection_id":"75754761","insp_unit_id":"189093431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04","insp_unit_license":"YP04786","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDR5HSHM5850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:42.000000Z","updated_at":"2025-03-17T22:13:42.000000Z"},{"id":893460,"change_date":"2022-06-06 21:41:00","inspection_id":"75754761","insp_unit_id":"189093432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4RM1660","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537HU793513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:42.000000Z","updated_at":"2025-03-17T22:13:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3536615\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3536615\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3536615\/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\/3536615\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}