{"current_page":1,"data":[{"id":7569171,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","dot_number":"3451334","report_state":"CA","report_number":"UEED002856","insp_date":"2025-01-06 00:00:00","insp_start_time":"1645","insp_end_time":"1745","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"JWO S. FRONT","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15650995","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2025-01-07 21:41:00","snet_input_date":"2025-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-07 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:17.000000Z","updated_at":"2025-03-17T20:55:17.000000Z","inspection_violations":[{"id":11833100,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_violation_id":"263806152","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204696889","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLSR"},{"id":11833101,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_violation_id":"263806153","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","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-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLDL"},{"id":11833102,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_violation_id":"263806154","seq_no":"3","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":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"38323A2LCDLN"},{"id":11833103,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_violation_id":"263806155","seq_no":"4","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"204696889","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA13085","created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLDL"},{"id":11833104,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_violation_id":"263806156","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204696889","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA13085","created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12212671,"change_date":"2025-01-07 21:41:00","inspection_id":"83551401","insp_unit_id":"204696889","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:49.000000Z","updated_at":"2025-03-17T23:49:49.000000Z"}]},{"id":7311872,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","dot_number":"3451334","report_state":"CA","report_number":"UEED002791","insp_date":"2024-11-29 00:00:00","insp_start_time":"1800","insp_end_time":"1945","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"JWO VASCO","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15612919","transaction_code":"A","transaction_date":"2024-11-29 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:35.000000Z","updated_at":"2025-03-17T20:48:35.000000Z","inspection_violations":[{"id":11430359,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_violation_id":"263158236","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204119804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA12684","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLSR"},{"id":11430360,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_violation_id":"263158237","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"1","insp_unit_id":"204119804","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA12684","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLDL"},{"id":11430361,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_violation_id":"263158238","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"1","insp_unit_id":"204119804","insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"38323A2LCDLN"},{"id":11430362,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_violation_id":"263158239","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204119804","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SA12684","created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3922SLLSR"},{"id":11430363,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_violation_id":"263158240","seq_no":"5","part_no":"393","part_no_section":"9B-LLPL","insp_viol_unit":"1","insp_unit_id":"204119804","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"3939BLLPL"}],"inspection_per_units":[{"id":11794982,"change_date":"2024-11-30 21:33:00","inspection_id":"83280948","insp_unit_id":"204119804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4AXL DMP","insp_unit_license":"9G39524","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M1AW07Y3FM043912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"}]},{"id":6302309,"change_date":"2024-07-24 21:42:00","inspection_id":"82207289","dot_number":"3451334","report_state":"CA","report_number":"UE03003322","insp_date":"2024-07-19 00:00:00","insp_start_time":"1430","insp_end_time":"1450","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"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":"2024-07-24 21:42: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":"15454939","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:48.000000Z","updated_at":"2025-03-17T20:27:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10154779,"change_date":"2024-07-24 21:42:00","inspection_id":"82207289","insp_unit_id":"202055195","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"55867X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"}]},{"id":6254497,"change_date":"2024-07-18 21:41:00","inspection_id":"82156156","dot_number":"3451334","report_state":"CA","report_number":"UEGX000549","insp_date":"2024-07-16 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CRK PLTFM SCALES","county_code_state":"CA","county_code":"013","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"15445379","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2024-07-18 21:41:00","snet_input_date":"2024-07-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-18 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T20:26:39.000000Z","updated_at":"2025-03-17T20:26:39.000000Z","inspection_violations":[{"id":9715876,"change_date":"2024-07-18 21:41:00","inspection_id":"82156156","insp_violation_id":"260722764","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201958595","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891035","created_at":"2025-03-17T21:53:00.000000Z","updated_at":"2025-03-17T21:53:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10077453,"change_date":"2024-07-18 21:41:00","inspection_id":"82156156","insp_unit_id":"201958595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"55867X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:26.000000Z","updated_at":"2025-03-17T23:27:26.000000Z"}]},{"id":6199959,"change_date":"2024-07-11 21:41:00","inspection_id":"82097583","dot_number":"3451334","report_state":"CA","report_number":"N9ZT006011","insp_date":"2024-07-09 00:00:00","insp_start_time":"0845","insp_end_time":"0900","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","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":"2024-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52300","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":"15437808","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-07-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:26.000000Z","updated_at":"2025-03-17T20:25:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9988141,"change_date":"2024-07-11 21:41:00","inspection_id":"82097583","insp_unit_id":"201846663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:31.000000Z","updated_at":"2025-03-17T23:26:31.000000Z"}]},{"id":5649215,"change_date":"2024-05-01 21:43:00","inspection_id":"81501565","dot_number":"3451334","report_state":"CA","report_number":"UDLV003254","insp_date":"2024-05-01 00:00:00","insp_start_time":"1015","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52300","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":"15343759","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2024-05-01 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-01 21:43:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T20:14:42.000000Z","updated_at":"2025-03-17T20:14:42.000000Z","inspection_violations":[{"id":8737677,"change_date":"2024-05-01 21:43:00","inspection_id":"81501565","insp_violation_id":"259265371","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200683778","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MJ08643","created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3922"},{"id":8737678,"change_date":"2024-05-01 21:43:00","inspection_id":"81501565","insp_violation_id":"259265372","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200683778","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:15.000000Z","updated_at":"2025-03-17T21:48:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9099178,"change_date":"2024-05-01 21:43:00","inspection_id":"81501565","insp_unit_id":"200683778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:39.000000Z","updated_at":"2025-03-17T23:17:39.000000Z"}]},{"id":4367897,"change_date":"2023-11-06 21:43:00","inspection_id":"80100032","dot_number":"3451334","report_state":"CA","report_number":"UCOB005203","insp_date":"2023-11-03 00:00:00","insp_start_time":"1012","insp_end_time":"1044","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"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":"2023-11-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15124912","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-11-06 21:43:00","snet_input_date":"2023-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-06 21:43:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[{"id":6758095,"change_date":"2023-11-06 21:43:00","inspection_id":"80100032","insp_violation_id":"256251680","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197935215","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LD 58095","created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7024975,"change_date":"2023-11-06 21:43:00","inspection_id":"80100032","insp_unit_id":"197935215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:57.000000Z","updated_at":"2025-03-17T22:58:57.000000Z"}]},{"id":4305870,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","dot_number":"3451334","report_state":"CA","report_number":"NC7K007928","insp_date":"2023-10-24 00:00:00","insp_start_time":"1355","insp_end_time":"1447","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":"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-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15112937","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:21.000000Z","updated_at":"2025-03-17T19:48:21.000000Z","inspection_violations":[{"id":6661744,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101249","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"},{"id":6661745,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101250","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3922"},{"id":6661746,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101251","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3963A1"},{"id":6661747,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101252","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3963A1"},{"id":6661748,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101253","seq_no":"5","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3969D2"},{"id":6661749,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101254","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"39347E"},{"id":6661750,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_violation_id":"256101255","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197797694","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6925103,"change_date":"2023-10-27 21:43:00","inspection_id":"80031741","insp_unit_id":"197797694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 4X ED","insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:08.000000Z","updated_at":"2025-03-17T22:58:08.000000Z"}]},{"id":4139248,"change_date":"2023-10-05 21:40:00","inspection_id":"79847490","dot_number":"3451334","report_state":"CA","report_number":"UDBL002449","insp_date":"2023-10-03 00:00:00","insp_start_time":"1053","insp_end_time":"1130","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":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"15086416","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-10-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[{"id":6406882,"change_date":"2023-10-05 21:40:00","inspection_id":"79847490","insp_violation_id":"255690323","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197426935","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LD58501","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"},{"id":6406883,"change_date":"2023-10-05 21:40:00","inspection_id":"79847490","insp_violation_id":"255690324","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197426935","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LD58501","created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6655717,"change_date":"2023-10-05 21:40:00","inspection_id":"79847490","insp_unit_id":"197426935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"4XEDWHT","insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":4138728,"change_date":"2023-10-05 21:40:00","inspection_id":"79846922","dot_number":"3451334","report_state":"CA","report_number":"UCOB005080","insp_date":"2023-09-30 00:00:00","insp_start_time":"0851","insp_end_time":"0921","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:40: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":"15086341","transaction_code":"A","transaction_date":"2023-09-30 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-09-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:30.000000Z","updated_at":"2025-03-17T19:44:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6654927,"change_date":"2023-10-05 21:40:00","inspection_id":"79846922","insp_unit_id":"197426036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"}]},{"id":3527031,"change_date":"2023-09-21 21:41:00","inspection_id":"79164293","dot_number":"3451334","report_state":"CA","report_number":"UCOB004769","insp_date":"2023-07-13 00:00:00","insp_start_time":"1354","insp_end_time":"1419","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 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":"14984122","transaction_code":"C","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:47.000000Z","updated_at":"2025-03-17T19:32:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5671284,"change_date":"2023-09-21 21:41:00","inspection_id":"79164293","insp_unit_id":"197176626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:45.000000Z","updated_at":"2025-03-17T22:47:45.000000Z"}]},{"id":3515030,"change_date":"2023-07-14 21:41:00","inspection_id":"79151003","dot_number":"3451334","report_state":"CA","report_number":"N9ZT004644","insp_date":"2023-07-07 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","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-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","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":"14981601","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[{"id":5421416,"change_date":"2023-07-14 21:41:00","inspection_id":"79151003","insp_violation_id":"254080661","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196015604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA391530","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3939A"},{"id":5421417,"change_date":"2023-07-14 21:41:00","inspection_id":"79151003","insp_violation_id":"254080662","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196015604","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5652150,"change_date":"2023-07-14 21:41:00","inspection_id":"79151003","insp_unit_id":"196015604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":2878472,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","dot_number":"3451334","report_state":"CA","report_number":"NC7K007185","insp_date":"2023-04-18 00:00:00","insp_start_time":"1214","insp_end_time":"1253","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":"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-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14871140","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-04-24 21:42:00","snet_input_date":"2023-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-24 21:42:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:44.000000Z","updated_at":"2025-03-17T19:19:44.000000Z","inspection_violations":[{"id":4419345,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","insp_violation_id":"254277679","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196194158","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"3922"},{"id":4419346,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","insp_violation_id":"254277680","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196194158","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"3922"},{"id":4419347,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","insp_violation_id":"254277681","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196194158","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"3963A1"},{"id":4419348,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","insp_violation_id":"254277682","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196194158","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:36.000000Z","updated_at":"2025-03-17T21:27:36.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4631677,"change_date":"2023-07-25 21:42:00","inspection_id":"78433066","insp_unit_id":"196194158","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 4X ED","insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"}]},{"id":2310448,"change_date":"2023-02-06 21:42:00","inspection_id":"77786516","dot_number":"3451334","report_state":"CA","report_number":"UCOB004262","insp_date":"2023-02-04 00:00:00","insp_start_time":"1142","insp_end_time":"1209","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"LIVERMORE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:42: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":"14772537","transaction_code":"A","transaction_date":"2023-02-04 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-02-06 21:42:00","snet_input_date":"2023-02-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-06 21:42:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:15.000000Z","updated_at":"2025-03-17T19:09:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3719009,"change_date":"2023-02-06 21:42:00","inspection_id":"77786516","insp_unit_id":"193261152","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XBPD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:38.000000Z","updated_at":"2025-03-17T22:32:38.000000Z"}]},{"id":2247401,"change_date":"2023-01-27 21:41:00","inspection_id":"77715273","dot_number":"3451334","report_state":"CA","report_number":"N9ZT004233","insp_date":"2023-01-25 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","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-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"14759204","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-01-27 21:41:00","snet_input_date":"2023-01-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:07.000000Z","updated_at":"2025-03-17T19:08:07.000000Z","inspection_violations":[{"id":3472484,"change_date":"2023-01-27 21:41:00","inspection_id":"77715273","insp_violation_id":"250831457","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193112317","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3922"},{"id":3472485,"change_date":"2023-01-27 21:41:00","inspection_id":"77715273","insp_violation_id":"250831458","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193112317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3617463,"change_date":"2023-01-27 21:41:00","inspection_id":"77715273","insp_unit_id":"193112317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"9G39524","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M1AW07Y3FM043912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":2261800,"change_date":"2023-01-30 21:44:00","inspection_id":"77731410","dot_number":"3451334","report_state":"CA","report_number":"UEED001683","insp_date":"2023-01-21 00:00:00","insp_start_time":"0800","insp_end_time":"0817","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"NB SCALES NIMITZ","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"14760553","transaction_code":"A","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[{"id":3491155,"change_date":"2023-01-30 21:44:00","inspection_id":"77731410","insp_violation_id":"250860271","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193143091","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3922"},{"id":3491156,"change_date":"2023-01-30 21:44:00","inspection_id":"77731410","insp_violation_id":"250860272","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193143091","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3640731,"change_date":"2023-01-30 21:44:00","inspection_id":"77731410","insp_unit_id":"193143091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81397M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XBPD49XXED236528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:06.000000Z","updated_at":"2025-03-17T22:32:06.000000Z"}]},{"id":2147074,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","dot_number":"3451334","report_state":"CA","report_number":"UF44003435","insp_date":"2023-01-12 00:00:00","insp_start_time":"1629","insp_end_time":"1642","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB N SHERIDAN 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":"2023-01-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14739897","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2023-01-13 21:41:00","snet_input_date":"2023-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-13 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[{"id":3321120,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_violation_id":"250582903","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36580","created_at":"2025-03-17T21:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3922"},{"id":3321121,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_violation_id":"250582904","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192880974","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36581","created_at":"2025-03-17T21:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3922"},{"id":3321122,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_violation_id":"250582905","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192880974","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3922"},{"id":3321123,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_violation_id":"250582906","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192880974","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36581","created_at":"2025-03-17T21:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"39311"},{"id":3321124,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_violation_id":"250582907","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192880974","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP36581","created_at":"2025-03-17T21:22:44.000000Z","updated_at":"2025-03-17T21:22:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3455130,"change_date":"2023-01-13 21:41:00","inspection_id":"77600208","insp_unit_id":"192880974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"9G39524","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1M1AW07Y3FM043912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:47.000000Z","updated_at":"2025-03-17T22:30:47.000000Z"}]},{"id":1942705,"change_date":"2022-12-13 21:40:00","inspection_id":"77366662","dot_number":"3451334","report_state":"CA","report_number":"UF44003299","insp_date":"2022-12-12 00:00:00","insp_start_time":"1641","insp_end_time":"1705","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"CALAVERAS RD JEO I-680","county_code_state":"CA","county_code":"001","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":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14706137","transaction_code":"A","transaction_date":"2022-12-12 00:00:00","upload_date":"2022-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-12-13 21:40:00","snet_input_date":"2022-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T19:02:31.000000Z","updated_at":"2025-03-17T19:02:31.000000Z","inspection_violations":[{"id":3018809,"change_date":"2022-12-13 21:40:00","inspection_id":"77366662","insp_violation_id":"250090893","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192417824","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CK018608","created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39345"},{"id":3018810,"change_date":"2022-12-13 21:40:00","inspection_id":"77366662","insp_violation_id":"250090894","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192417824","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR36219","created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3018811,"change_date":"2022-12-13 21:40:00","inspection_id":"77366662","insp_violation_id":"250090895","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192417824","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CK018608","created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3126150,"change_date":"2022-12-13 21:40:00","inspection_id":"77366662","insp_unit_id":"192417824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:25.000000Z","updated_at":"2025-03-17T22:28:25.000000Z"}]},{"id":1451908,"change_date":"2022-10-05 21:41:00","inspection_id":"76802895","dot_number":"3451334","report_state":"CA","report_number":"NC7K006418","insp_date":"2022-09-29 00:00:00","insp_start_time":"0750","insp_end_time":"0810","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":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14624009","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-10-05 21:41:00","snet_input_date":"2022-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-05 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:26.000000Z","updated_at":"2025-03-17T18:53:26.000000Z","inspection_violations":[{"id":2287899,"change_date":"2022-10-05 21:41:00","inspection_id":"76802895","insp_violation_id":"248861466","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191294880","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"},{"id":2287900,"change_date":"2022-10-05 21:41:00","inspection_id":"76802895","insp_violation_id":"248861467","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191294880","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2337829,"change_date":"2022-10-05 21:41:00","inspection_id":"76802895","insp_unit_id":"191294880","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 3X ED","insp_unit_license":"10021D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHDB9X5BD125377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:00.000000Z","updated_at":"2025-03-17T22:23:00.000000Z"}]},{"id":1359071,"change_date":"2022-09-23 21:38:00","inspection_id":"76695298","dot_number":"3451334","report_state":"CA","report_number":"UEX8002394","insp_date":"2022-09-22 00:00:00","insp_start_time":"1510","insp_end_time":"1523","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14607875","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-09-23 21:38:00","snet_input_date":"2022-09-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-23 21:38:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:41.000000Z","updated_at":"2025-03-17T18:51:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2188377,"change_date":"2022-09-23 21:38:00","inspection_id":"76695298","insp_unit_id":"191078172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:58.000000Z","updated_at":"2025-03-17T22:21:58.000000Z"}]},{"id":1200747,"change_date":"2022-09-01 21:42:00","inspection_id":"76511471","dot_number":"3451334","report_state":"CA","report_number":"UEAO002877","insp_date":"2022-08-31 00:00:00","insp_start_time":"0834","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALES","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":"2022-09-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14578804","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-09-01 21:42:00","snet_input_date":"2022-08-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-01 21:42:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:56.000000Z","updated_at":"2025-03-17T18:48:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1931141,"change_date":"2022-09-01 21:42:00","inspection_id":"76511471","insp_unit_id":"190697843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X","insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:17.000000Z","updated_at":"2025-03-17T22:20:17.000000Z"}]},{"id":824837,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","dot_number":"3451334","report_state":"CA","report_number":"UF44002860","insp_date":"2022-07-13 00:00:00","insp_start_time":"1714","insp_end_time":"1750","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB S ANDRADE","county_code_state":"CA","county_code":"001","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":"2022-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37000","viol_total":"5","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14506706","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"567851","created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[{"id":1300411,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_violation_id":"247112295","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"LP33167","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"38351A"},{"id":1300412,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_violation_id":"247112296","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP33167","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"},{"id":1300413,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_violation_id":"247112297","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189793818","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP33168","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"},{"id":1300414,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_violation_id":"247112298","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189793818","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LP33168","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"},{"id":1300415,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_violation_id":"247112299","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189793818","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"LP33168","created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1327099,"change_date":"2022-07-14 21:42:00","inspection_id":"76072609","insp_unit_id":"189793818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"13655Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMKSTRXFH715463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":306561,"change_date":"2022-05-02 21:41:00","inspection_id":"75458854","dot_number":"3451334","report_state":"CA","report_number":"UEX8002002","insp_date":"2022-04-29 00:00:00","insp_start_time":"1405","insp_end_time":"1425","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","insp_level_id":"1","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":"2022-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14408886","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-05-02 21:41:00","snet_input_date":"2022-04-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-02 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:56.000000Z","updated_at":"2025-03-17T18:32:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":496019,"change_date":"2022-05-02 21:41:00","inspection_id":"75458854","insp_unit_id":"188468807","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"10021D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHDB9X5BD125377","insp_unit_decal":"Y","insp_unit_decal_number":"31100836","created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"}]},{"id":293635,"change_date":"2022-04-29 21:41:00","inspection_id":"75443503","dot_number":"3451334","report_state":"CA","report_number":"NDN6005461","insp_date":"2022-04-26 00:00:00","insp_start_time":"0608","insp_end_time":"0643","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":"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":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14408075","transaction_code":"A","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-04-29 21:41:00","snet_input_date":"2022-04-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:36.000000Z","updated_at":"2025-03-17T18:32:36.000000Z","inspection_violations":[{"id":458689,"change_date":"2022-04-29 21:41:00","inspection_id":"75443503","insp_violation_id":"245495679","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188438294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3922"},{"id":458690,"change_date":"2022-04-29 21:41:00","inspection_id":"75443503","insp_violation_id":"245495680","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188438294","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA309831","created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3963A1"},{"id":458691,"change_date":"2022-04-29 21:41:00","inspection_id":"75443503","insp_violation_id":"245495681","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188438294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":475269,"change_date":"2022-04-29 21:41:00","inspection_id":"75443503","insp_unit_id":"188438294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X ED WHITE","insp_unit_license":"10021D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHDB9X5BD125377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:07.000000Z","updated_at":"2025-03-17T22:11:07.000000Z"}]},{"id":105278,"change_date":"2022-04-04 21:41:00","inspection_id":"75216737","dot_number":"3451334","report_state":"CA","report_number":"NC7K005685","insp_date":"2022-04-01 00:00:00","insp_start_time":"1213","insp_end_time":"1235","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":"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14370182","transaction_code":"A","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03451334","upload_search_indicator":null,"census_search_date":"2022-04-04 21:41:00","snet_input_date":"2022-04-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-04 21:41:00","insp_carrier_name":"ALEJANDRO AGUILAR","insp_carrier_street":"2212 BARGER WAY","insp_carrier_city":"RIVERBANK","insp_carrier_state":"CA","insp_carrier_zip_code":"95367","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:27.000000Z","updated_at":"2025-03-17T18:29:27.000000Z","inspection_violations":[{"id":155805,"change_date":"2022-04-04 21:41:00","inspection_id":"75216737","insp_violation_id":"244956017","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187979348","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:47.000000Z","updated_at":"2025-03-17T21:07:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":170603,"change_date":"2022-04-04 21:41:00","inspection_id":"75216737","insp_unit_id":"187979348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT 3X ED","insp_unit_license":"10021D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHDB9X5BD125377","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:15.000000Z","updated_at":"2025-03-17T22:09:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3451334\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3451334\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3451334\/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\/3451334\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}