{"current_page":1,"data":[{"id":11491778,"change_date":"2026-03-26 21:40:00","inspection_id":"87411524","dot_number":"3497382","report_state":"CA","report_number":"UCOM001322","insp_date":"2026-03-25 00:00:00","insp_start_time":"1421","insp_end_time":"1451","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","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":"2026-03-26 21:40: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":"16224666","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:21.000000Z","updated_at":"2026-04-06T09:34:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19685899,"change_date":"2026-03-26 21:40:00","inspection_id":"87411524","insp_unit_id":"212365041","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X","insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:06.000000Z","updated_at":"2026-04-06T09:14:02.000000Z"}]},{"id":11108923,"change_date":"2026-02-11 21:39:00","inspection_id":"87021328","dot_number":"3497382","report_state":"CA","report_number":"UCOM001218","insp_date":"2026-02-09 00:00:00","insp_start_time":"1145","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","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":"2026-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16166841","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2026-02-11 21:39:00","snet_input_date":"2026-02-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-11 21:39:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:41.000000Z","updated_at":"2026-02-22T10:31:10.000000Z","inspection_violations":[{"id":18604160,"change_date":"2026-02-11 21:39:00","inspection_id":"87021328","insp_violation_id":"271743737","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"211573719","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA767532","created_at":"2026-02-14T10:52:32.000000Z","updated_at":"2026-02-22T10:40:16.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":18945858,"change_date":"2026-02-11 21:39:00","inspection_id":"87021328","insp_unit_id":"211573719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X","insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:37.000000Z","updated_at":"2026-02-22T10:03:45.000000Z"}]},{"id":10783420,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","dot_number":"3497382","report_state":"CA","report_number":"UDLV004800","insp_date":"2026-01-14 00:00:00","insp_start_time":"1003","insp_end_time":"1021","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"CONTRA COSTA BLVD OFF RAMP","county_code_state":"CA","county_code":"013","insp_level_id":"3","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16131990","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2026-01-18T10:45:31.000000Z","updated_at":"2026-01-26T10:31:18.000000Z","inspection_violations":[{"id":18018607,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_violation_id":"271241580","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:04:50.000000Z","updated_at":"2026-01-26T10:32:11.000000Z","normalized_code":"3922SLLTCD"},{"id":18018608,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_violation_id":"271241581","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"211120318","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RH08451","created_at":"2026-01-18T11:04:50.000000Z","updated_at":"2026-01-26T10:32:11.000000Z","normalized_code":"39021TB2DOT"},{"id":18018609,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_violation_id":"271241582","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"211120318","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:04:51.000000Z","updated_at":"2026-01-26T10:32:11.000000Z","normalized_code":"3922SLL"},{"id":18018610,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_violation_id":"271241583","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211120318","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RH08451","created_at":"2026-01-18T11:04:51.000000Z","updated_at":"2026-01-26T10:32:11.000000Z","normalized_code":"3922SLLSR"},{"id":18018611,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_violation_id":"271241584","seq_no":"5","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"211120318","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RH08451","created_at":"2026-01-18T11:04:51.000000Z","updated_at":"2026-01-26T10:32:11.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":18103687,"change_date":"2026-01-15 21:41:00","inspection_id":"86809209","insp_unit_id":"211120318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:44.000000Z","updated_at":"2026-01-26T10:01:32.000000Z"}]},{"id":9574199,"change_date":"2025-09-02 21:40:00","inspection_id":"85663017","dot_number":"3497382","report_state":"CA","report_number":"UDBL004680","insp_date":"2025-08-13 00:00:00","insp_start_time":"1401","insp_end_time":"1427","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15961391","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2025-09-02 21:40:00","snet_input_date":"2025-08-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2025-09-06T10:43:10.000000Z","updated_at":"2025-09-06T10:43:10.000000Z","inspection_violations":[{"id":18474356,"change_date":null,"inspection_id":"85663017","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39330B"}],"inspection_per_units":[{"id":15804021,"change_date":"2025-09-02 21:40:00","inspection_id":"85663017","insp_unit_id":"208712044","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XWHTBX","insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:23.000000Z","updated_at":"2025-09-09T09:47:23.000000Z"}]},{"id":8196778,"change_date":"2025-03-25 12:44:00","inspection_id":"84210879","dot_number":"3497382","report_state":"CA","report_number":"NF37001172","insp_date":"2025-03-18 00:00:00","insp_start_time":"0735","insp_end_time":"0803","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15751637","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2025-03-25 12:44:00","snet_input_date":"2025-03-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2025-03-28T10:14:35.000000Z","updated_at":"2025-03-29T10:18:23.000000Z","inspection_violations":[{"id":12853186,"change_date":"2025-03-25 12:44:00","inspection_id":"84210879","insp_violation_id":"265224516","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205963030","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:28:09.000000Z","updated_at":"2025-03-28T10:43:01.000000Z","normalized_code":"39021TB2DOT"},{"id":12853187,"change_date":"2025-03-25 12:44:00","inspection_id":"84210879","insp_violation_id":"265224517","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205963030","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:28:09.000000Z","updated_at":"2025-03-28T10:43:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13252084,"change_date":"2025-03-25 12:44:00","inspection_id":"84210879","insp_unit_id":"205963030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHI","insp_unit_license":"3720303","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"Y","insp_unit_decal_number":"34775188","created_at":"2025-03-28T10:00:11.000000Z","updated_at":"2025-03-29T09:51:41.000000Z"}]},{"id":7807897,"change_date":"2025-02-06 21:41:00","inspection_id":"83802224","dot_number":"3497382","report_state":"CA","report_number":"UESQ004655","insp_date":"2025-02-06 00:00:00","insp_start_time":"0701","insp_end_time":"0714","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"NB 99 S  OF MORADA","county_code_state":"CA","county_code":"077","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15695557","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2025-02-06 21:41:00","snet_input_date":"2025-02-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-06 21:41:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2025-03-17T21:00:20.000000Z","updated_at":"2025-03-17T21:00:20.000000Z","inspection_violations":[{"id":12202548,"change_date":"2025-02-06 21:41:00","inspection_id":"83802224","insp_violation_id":"264387755","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205201344","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RD70965","created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"3922SLLSR"},{"id":12202549,"change_date":"2025-02-06 21:41:00","inspection_id":"83802224","insp_violation_id":"264387756","seq_no":"2","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"205201344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39311A1LLPL"},{"id":12202550,"change_date":"2025-02-06 21:41:00","inspection_id":"83802224","insp_violation_id":"264387757","seq_no":"3","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"205201344","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:33.000000Z","updated_at":"2025-03-17T22:05:33.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":12600723,"change_date":"2025-02-06 21:41:00","inspection_id":"83802224","insp_unit_id":"205201344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:13.000000Z","updated_at":"2025-03-17T23:54:13.000000Z"}]},{"id":7721686,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","dot_number":"3497382","report_state":"CA","report_number":"UE1B001519","insp_date":"2025-01-27 00:00:00","insp_start_time":"0930","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"310","location_desc":"N\/B MARIN SCALE (TERRA LINDA)","county_code_state":"CA","county_code":"041","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15680019","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2025-03-17T20:58:39.000000Z","updated_at":"2025-03-17T20:58:39.000000Z","inspection_violations":[{"id":12065042,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_violation_id":"264202649","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"205031477","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW 754058","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"39311A1LHLM"},{"id":12065043,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_violation_id":"264202650","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205031477","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLSR"},{"id":12065044,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_violation_id":"264202651","seq_no":"3","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"205031477","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"39395A4EENA"},{"id":12065045,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_violation_id":"264202652","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205031477","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLEQP"},{"id":12065046,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_violation_id":"264202653","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205031477","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12460795,"change_date":"2025-01-27 21:40:00","inspection_id":"83711413","insp_unit_id":"205031477","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2XWHI","insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:30.000000Z","updated_at":"2025-03-17T23:52:30.000000Z"}]},{"id":7721909,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","dot_number":"3497382","report_state":"CA","report_number":"UF44005760","insp_date":"2025-01-24 00:00:00","insp_start_time":"1518","insp_end_time":"1538","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB @ ANDRADE RD","county_code_state":"CA","county_code":"001","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15678719","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03497382","upload_search_indicator":null,"census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"D SANDOVALTRUCKING LLC","insp_carrier_street":"1240 N PALM ST","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"572480","created_at":"2025-03-17T20:58:39.000000Z","updated_at":"2025-03-17T20:58:39.000000Z","inspection_violations":[{"id":12065290,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202950","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ75817","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLTCD"},{"id":12065291,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202951","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"RJ75817","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"38323A2LCDLN"},{"id":12065292,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202952","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205031831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ75818","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLSR"},{"id":12065293,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202953","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205031831","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ75818","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLEQP"},{"id":12065294,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202954","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205031831","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ75818","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLSR"},{"id":12065295,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_violation_id":"264202955","seq_no":"6","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"205031831","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ75818","created_at":"2025-03-17T22:04:51.000000Z","updated_at":"2025-03-17T22:04:51.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":12461127,"change_date":"2025-01-27 21:40:00","inspection_id":"83711643","insp_unit_id":"205031831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"37203D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALE5W165J7302713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:30.000000Z","updated_at":"2025-03-17T23:52:30.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3497382\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3497382\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3497382\/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\/3497382\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}