{"current_page":1,"data":[{"id":12497326,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","dot_number":"2776659","report_state":"CA","report_number":"UD2M003391","insp_date":"2026-07-20 00:00:00","insp_start_time":"0820","insp_end_time":"0904","registration_date":null,"region":"PD","ci_status_code":"C","location":"461","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE SEEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3795263","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-07-20 21:39:00","snet_input_date":"2026-07-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-20 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-07-23T09:41:14.000000Z","updated_at":"2026-07-23T09:41:14.000000Z","inspection_violations":[{"id":21755777,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613065","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"39345B2BAIR"},{"id":21755778,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613066","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"39345B2BAIR"},{"id":21755779,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613067","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"00ND002ZM","created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"39345B2BHTD"},{"id":21755780,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613068","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"39345B2BAIR"},{"id":21755781,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613069","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"39345B2BAIR"},{"id":21755782,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_violation_id":"275613070","seq_no":"6","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"214714014","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:01:30.000000Z","updated_at":"2026-07-23T10:01:30.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":21704816,"change_date":"2026-07-20 21:39:00","inspection_id":"88460962","insp_unit_id":"214714014","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:17:35.000000Z","updated_at":"2026-07-23T09:17:35.000000Z"}]},{"id":12425404,"change_date":"2026-07-11 21:34:00","inspection_id":"88384130","dot_number":"2776659","report_state":"CA","report_number":"ND7N011070","insp_date":"2026-07-06 00:00:00","insp_start_time":"1505","insp_end_time":"1525","registration_date":null,"region":"PD","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","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":"U","pen_cen_match":"I","final_status_date":"2026-07-11 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"3732273","transaction_code":"A","transaction_date":"2026-07-11 00:00:00","upload_date":"2026-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-07-11 21:34:00","snet_input_date":"2026-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-11 21:34:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-07-14T09:41:02.000000Z","updated_at":"2026-07-22T09:30:28.000000Z","inspection_violations":[{"id":21630874,"change_date":"2026-07-11 21:34:00","inspection_id":"88384130","insp_violation_id":"275447809","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"214567560","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA810481","created_at":"2026-07-14T10:01:20.000000Z","updated_at":"2026-07-22T09:42:11.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":21584696,"change_date":"2026-07-11 21:34:00","inspection_id":"88384130","insp_unit_id":"214567560","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"T7 FB","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:58.000000Z","updated_at":"2026-07-22T09:01:42.000000Z"},{"id":21584697,"change_date":"2026-07-11 21:34:00","inspection_id":"88384130","insp_unit_id":"214567561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"243801 WHT","insp_unit_license":"ZP19785","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR2RL019167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:58.000000Z","updated_at":"2026-07-22T09:01:42.000000Z"}]},{"id":11935938,"change_date":"2026-05-16 21:37:00","inspection_id":"87870822","dot_number":"2776659","report_state":"CA","report_number":"UCZW000672","insp_date":"2026-05-13 00:00:00","insp_start_time":"1520","insp_end_time":"1540","registration_date":null,"region":"PS","ci_status_code":"C","location":"223","location_desc":"CA","county_code_state":"CA","county_code":"057","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-16 21:37: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":"3345086","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-05-16 21:37:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-16 21:37:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-19T09:41:07.000000Z","updated_at":"2026-05-27T09:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20756313,"change_date":"2026-05-16 21:37:00","inspection_id":"87870822","insp_unit_id":"213593425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"95909X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMMLXRS682508","insp_unit_decal":"Y","insp_unit_decal_number":"36178619","created_at":"2026-05-19T09:19:57.000000Z","updated_at":"2026-05-27T09:01:48.000000Z"}]},{"id":11837160,"change_date":"2026-05-08 21:38:00","inspection_id":"87772565","dot_number":"2776659","report_state":"CA","report_number":"UE7Q000842","insp_date":"2026-05-05 00:00:00","insp_start_time":"1346","insp_end_time":"1415","registration_date":null,"region":"PS","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3270735","transaction_code":"C","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-05-06 21:40:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-05-09T09:40:13.000000Z","updated_at":"2026-05-19T09:30:09.000000Z","inspection_violations":[{"id":20587726,"change_date":"2026-05-08 21:38:00","inspection_id":"87772565","insp_violation_id":"274121780","seq_no":"1","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:00:48.000000Z","updated_at":"2026-05-19T09:41:24.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":20586199,"change_date":"2026-05-08 21:38:00","inspection_id":"87772565","insp_unit_id":"213440691","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZP19785","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR2RL019167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:19.000000Z","updated_at":"2026-05-19T09:02:06.000000Z"},{"id":20586200,"change_date":"2026-05-08 21:38:00","inspection_id":"87772565","insp_unit_id":"213440692","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"4NN6049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DTP16W21GP021875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:19.000000Z","updated_at":"2026-05-19T09:02:06.000000Z"}]},{"id":11270753,"change_date":"2026-03-02 21:39:00","inspection_id":"87184993","dot_number":"2776659","report_state":"CA","report_number":"NEL1005405","insp_date":"2026-02-26 00:00:00","insp_start_time":"0943","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16188464","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-03-02 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-02 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:39:09.000000Z","updated_at":"2026-03-13T09:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19273917,"change_date":"2026-03-02 21:39:00","inspection_id":"87184993","insp_unit_id":"211929274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"243801\/WHT","insp_unit_license":"ZP19785","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR2RL019167","insp_unit_decal":"Y","insp_unit_decal_number":"35868570","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:51.000000Z"},{"id":19273918,"change_date":"2026-03-02 21:39:00","inspection_id":"87184993","insp_unit_id":"211929275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"T-10\/FB","insp_unit_license":"4UA1136","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C0DT399007","insp_unit_decal":"Y","insp_unit_decal_number":"35868571","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:51.000000Z"}]},{"id":11270484,"change_date":"2026-03-02 21:39:00","inspection_id":"87184722","dot_number":"2776659","report_state":"CA","report_number":"NE5Z004953","insp_date":"2026-02-26 00:00:00","insp_start_time":"1600","insp_end_time":"1625","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"B&B","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":"2026-03-02 21:39: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":"16189756","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-03-02 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-02 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-03-05T10:39:09.000000Z","updated_at":"2026-03-13T09:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19273482,"change_date":"2026-03-02 21:39:00","inspection_id":"87184722","insp_unit_id":"211928814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/23F383","insp_unit_license":"57261B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"Y","insp_unit_decal_number":"35894295","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:48.000000Z"}]},{"id":11210489,"change_date":"2026-02-23 21:39:00","inspection_id":"87121713","dot_number":"2776659","report_state":"CA","report_number":"NEUU000591","insp_date":"2026-02-20 00:00:00","insp_start_time":"1340","insp_end_time":"1403","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2026-02-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"16180716","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-02-23 21:39:00","snet_input_date":"2026-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-02-26T10:37:04.000000Z","updated_at":"2026-03-06T10:31:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19143152,"change_date":"2026-02-23 21:39:00","inspection_id":"87121713","insp_unit_id":"211778589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"24F399","insp_unit_license":"53297H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML7RS286472","insp_unit_decal":"Y","insp_unit_decal_number":"35890238","created_at":"2026-02-26T10:12:19.000000Z","updated_at":"2026-03-06T10:04:15.000000Z"}]},{"id":11220062,"change_date":"2026-02-24 21:40:00","inspection_id":"87131756","dot_number":"2776659","report_state":"CA","report_number":"NEC6001653","insp_date":"2026-02-20 00:00:00","insp_start_time":"1045","insp_end_time":"1106","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"2026-02-24 21:40: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":"16181633","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2026-02-27T10:38:10.000000Z","updated_at":"2026-03-07T10:31:13.000000Z","inspection_violations":[{"id":18817508,"change_date":"2026-02-24 21:40:00","inspection_id":"87131756","insp_violation_id":"271996740","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211804338","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-27T10:54:05.000000Z","updated_at":"2026-03-07T10:40:56.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":19165340,"change_date":"2026-02-24 21:40:00","inspection_id":"87131756","insp_unit_id":"211804338","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"22F368\/WHT","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"Y","insp_unit_decal_number":"35934604","created_at":"2026-02-27T10:13:26.000000Z","updated_at":"2026-03-07T10:04:09.000000Z"}]},{"id":10414295,"change_date":"2025-12-11 21:45:00","inspection_id":"86545151","dot_number":"2776659","report_state":"CA","report_number":"UCED004179","insp_date":"2025-12-11 00:00:00","insp_start_time":"0705","insp_end_time":"0723","registration_date":null,"region":"PT","ci_status_code":"C","location":"220","location_desc":"AUBURN AREA","county_code_state":"CA","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAL SIERRA-PIPE LLC","shipping_paper_number":"40287-001","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-12-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16090614","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-12-11 21:45:00","snet_input_date":"2025-12-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-11 21:45:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-12-14T10:31:56.000000Z","updated_at":"2025-12-15T10:31:44.000000Z","inspection_violations":[{"id":17457037,"change_date":"2025-12-11 21:45:00","inspection_id":"86545151","insp_violation_id":"270635933","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-14T10:32:52.000000Z","updated_at":"2025-12-15T10:33:14.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17417368,"change_date":"2025-12-11 21:45:00","inspection_id":"86545151","insp_unit_id":"210564924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9H09854","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR4RL019168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:07.000000Z","updated_at":"2025-12-15T10:02:20.000000Z"},{"id":17417369,"change_date":"2025-12-11 21:45:00","inspection_id":"86545151","insp_unit_id":"210564925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANS","insp_unit_company":"T-3","insp_unit_license":"4DA9018","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4520041072359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:07.000000Z","updated_at":"2025-12-15T10:02:20.000000Z"}]},{"id":10441633,"change_date":"2025-12-15 21:40:00","inspection_id":"86573778","dot_number":"2776659","report_state":"CA","report_number":"NC3S011040","insp_date":"2025-12-08 00:00:00","insp_start_time":"1510","insp_end_time":"1535","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-12-15 21:40: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":"16094492","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-12-18T10:30:48.000000Z","updated_at":"2025-12-26T10:31:18.000000Z","inspection_violations":[{"id":17512432,"change_date":"2025-12-15 21:40:00","inspection_id":"86573778","insp_violation_id":"270700906","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"210621656","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-18T10:31:09.000000Z","updated_at":"2025-12-26T10:32:14.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":17468371,"change_date":"2025-12-15 21:40:00","inspection_id":"86573778","insp_unit_id":"210621656","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"23F383","insp_unit_license":"57261B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"Y","insp_unit_decal_number":"35618408","created_at":"2025-12-18T10:00:39.000000Z","updated_at":"2025-12-26T10:01:29.000000Z"}]},{"id":10367232,"change_date":"2025-12-05 21:43:00","inspection_id":"86495881","dot_number":"2776659","report_state":"CA","report_number":"UDJB004798","insp_date":"2025-12-05 00:00:00","insp_start_time":"1135","insp_end_time":"1200","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"N\/B SANTA NELLA PLATFORM SCALE","county_code_state":"CA","county_code":"047","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":"2025-12-05 21:43: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":"16084165","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-12-05 21:43:00","snet_input_date":"2025-12-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:09.000000Z","updated_at":"2025-12-09T10:31:40.000000Z","inspection_violations":[{"id":17359932,"change_date":"2025-12-05 21:43:00","inspection_id":"86495881","insp_violation_id":"270505149","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"210452516","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:33:08.000000Z","updated_at":"2025-12-09T10:32:47.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":17328191,"change_date":"2025-12-05 21:43:00","inspection_id":"86495881","insp_unit_id":"210452516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"57261B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:13.000000Z","updated_at":"2025-12-09T10:01:57.000000Z"}]},{"id":10218908,"change_date":"2025-11-18 21:38:00","inspection_id":"86340608","dot_number":"2776659","report_state":"NV","report_number":"7263029510","insp_date":"2025-11-14 00:00:00","insp_start_time":"1020","insp_end_time":"1036","registration_date":"2025-11-18 00:00:00","region":"PS","ci_status_code":"C","location":"2","location_desc":"NV","county_code_state":"NV","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CALSIERRA PIPE","shipping_paper_number":"110000040005-00","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2555931","transaction_code":"C","transaction_date":"2025-11-18 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-11-17 21:39:00","snet_input_date":"2025-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:34.000000Z","updated_at":"2025-11-23T10:30:14.000000Z","inspection_violations":[{"id":16997164,"change_date":"2025-11-18 21:38:00","inspection_id":"86340608","insp_violation_id":"270028069","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-21T10:32:41.000000Z","updated_at":"2025-11-23T10:30:21.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17036615,"change_date":"2025-11-18 21:38:00","inspection_id":"86340608","insp_unit_id":"210089154","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"24F399","insp_unit_license":"53297H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML7RS286472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:49.000000Z","updated_at":"2025-11-23T10:00:17.000000Z"}]},{"id":10168071,"change_date":"2025-11-17 21:40:00","inspection_id":"86287165","dot_number":"2776659","report_state":"CA","report_number":"UD54000813","insp_date":"2025-11-06 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16052100","transaction_code":"C","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-11-10 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-10 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-11-13T10:30:47.000000Z","updated_at":"2025-11-21T10:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17024696,"change_date":"2025-11-17 21:40:00","inspection_id":"86287165","insp_unit_id":"210081795","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"243828\/ WHT","insp_unit_license":"9H09854","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR4RL019168","insp_unit_decal":"Y","insp_unit_decal_number":"35620573","created_at":"2025-11-20T10:00:37.000000Z","updated_at":"2025-11-21T10:01:08.000000Z"},{"id":17024697,"change_date":"2025-11-17 21:40:00","inspection_id":"86287165","insp_unit_id":"210081796","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"T\/ FB","insp_unit_license":"4NN6049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DTP16W21GP021875","insp_unit_decal":"Y","insp_unit_decal_number":"35620574","created_at":"2025-11-20T10:00:37.000000Z","updated_at":"2025-11-21T10:01:08.000000Z"}]},{"id":10011180,"change_date":"2025-10-22 21:40:00","inspection_id":"86121901","dot_number":"2776659","report_state":"CA","report_number":"N8MC010534","insp_date":"2025-10-21 00:00:00","insp_start_time":"1147","insp_end_time":"1209","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"2025-10-22 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":"16028676","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-10-22 21:40:00","snet_input_date":"2025-10-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-22 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:45.000000Z","updated_at":"2025-10-26T10:01:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16628998,"change_date":"2025-10-22 21:40:00","inspection_id":"86121901","insp_unit_id":"209607088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE","insp_unit_license":"DM88Z12","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML7RS286472","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:53.000000Z","updated_at":"2025-10-26T09:46:46.000000Z"}]},{"id":9513001,"change_date":"2025-08-26 21:41:00","inspection_id":"85588179","dot_number":"2776659","report_state":"CA","report_number":"UE5E000387","insp_date":"2025-08-25 00:00:00","insp_start_time":"0811","insp_end_time":"0824","registration_date":null,"region":"PT","ci_status_code":"C","location":"740","location_desc":"SR46 AT GOLDEN HILL","county_code_state":"CA","county_code":"079","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15952155","transaction_code":"C","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-08-29T10:43:08.000000Z","updated_at":"2025-09-05T10:46:52.000000Z","inspection_violations":[{"id":15519882,"change_date":"2025-08-26 21:41:00","inspection_id":"85588179","insp_violation_id":"268270195","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208599581","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:57.000000Z","updated_at":"2025-09-05T10:49:57.000000Z","normalized_code":"39395F"},{"id":15519883,"change_date":"2025-08-26 21:41:00","inspection_id":"85588179","insp_violation_id":"268270196","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"208599581","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:57.000000Z","updated_at":"2025-09-05T10:49:57.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":15697980,"change_date":"2025-08-26 21:41:00","inspection_id":"85588179","insp_unit_id":"208599581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:43.000000Z","updated_at":"2025-09-05T09:46:17.000000Z"}]},{"id":8620404,"change_date":"2025-05-13 21:41:00","inspection_id":"84657193","dot_number":"2776659","report_state":"CA","report_number":"N8MC009843","insp_date":"2025-05-07 00:00:00","insp_start_time":"1028","insp_end_time":"1052","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15816484","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-05-17T10:04:16.000000Z","updated_at":"2025-05-17T10:09:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14075544,"change_date":"2025-05-13 21:41:00","inspection_id":"84657193","insp_unit_id":"206836549","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"22F368\/WHT","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:50.000000Z","updated_at":"2025-05-17T09:51:26.000000Z"}]},{"id":8454343,"change_date":"2025-04-23 21:41:00","inspection_id":"84482207","dot_number":"2776659","report_state":"CA","report_number":"NC43009392","insp_date":"2025-04-22 00:00:00","insp_start_time":"1623","insp_end_time":"1639","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15792361","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-04-26T10:28:48.000000Z","updated_at":"2025-04-27T10:33:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13732072,"change_date":"2025-04-23 21:41:00","inspection_id":"84482207","insp_unit_id":"206462610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2X\/WHT","insp_unit_license":"EP06395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML2LH093425","insp_unit_decal":"Y","insp_unit_decal_number":"35069557","created_at":"2025-04-26T10:18:56.000000Z","updated_at":"2025-04-27T10:09:31.000000Z"}]},{"id":8204796,"change_date":"2025-03-26 21:41:00","inspection_id":"84219336","dot_number":"2776659","report_state":"CA","report_number":"NF37001191","insp_date":"2025-03-20 00:00:00","insp_start_time":"0954","insp_end_time":"1027","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 21:41: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":"15753833","transaction_code":"C","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-03-25 21:41:00","snet_input_date":"2025-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-25 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-28T10:15:15.000000Z","updated_at":"2025-03-30T10:36:22.000000Z","inspection_violations":[{"id":12884811,"change_date":"2025-03-26 21:41:00","inspection_id":"84219336","insp_violation_id":"265269005","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"206003404","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:59:25.000000Z","updated_at":"2025-03-29T10:41:26.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":13283336,"change_date":"2025-03-26 21:41:00","inspection_id":"84219336","insp_unit_id":"206003404","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"23F383","insp_unit_license":"57261B4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"Y","insp_unit_decal_number":"34775203","created_at":"2025-03-29T10:11:10.000000Z","updated_at":"2025-03-30T10:07:34.000000Z"}]},{"id":7706261,"change_date":"2025-01-24 21:40:00","inspection_id":"83695264","dot_number":"2776659","report_state":"CA","report_number":"N9PI008764","insp_date":"2025-01-23 00:00:00","insp_start_time":"1449","insp_end_time":"1522","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-01-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15676808","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T20:58:17.000000Z","updated_at":"2025-03-17T20:58:17.000000Z","inspection_violations":[{"id":12039903,"change_date":"2025-01-24 21:40:00","inspection_id":"83695264","insp_violation_id":"264170210","seq_no":"1","part_no":"395","part_no_section":"8K2-HOSRC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3958K2HOSRC"},{"id":12039904,"change_date":"2025-01-24 21:40:00","inspection_id":"83695264","insp_violation_id":"264170211","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205001233","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":12435340,"change_date":"2025-01-24 21:40:00","inspection_id":"83695264","insp_unit_id":"205001233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 20F352","insp_unit_license":"EP06395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML2LH093425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:15.000000Z","updated_at":"2025-03-17T23:52:15.000000Z"}]},{"id":7433031,"change_date":"2024-12-16 21:41:00","inspection_id":"83408422","dot_number":"2776659","report_state":"CA","report_number":"UDJB004095","insp_date":"2024-12-13 00:00:00","insp_start_time":"1330","insp_end_time":"1410","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"N\/B SANTA NELLA PLATFORM SCALE","county_code_state":"CA","county_code":"047","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":"2024-12-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15630469","transaction_code":"A","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-12-16 21:41:00","snet_input_date":"2024-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-16 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:10.000000Z","updated_at":"2025-03-17T20:51:10.000000Z","inspection_violations":[{"id":11615440,"change_date":"2024-12-16 21:41:00","inspection_id":"83408422","insp_violation_id":"263504206","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"204418624","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RK87013","created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"39345B2BHTD"},{"id":11615441,"change_date":"2024-12-16 21:41:00","inspection_id":"83408422","insp_violation_id":"263504207","seq_no":"2","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"204418624","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"39345B2B"}],"inspection_per_units":[{"id":11991630,"change_date":"2024-12-16 21:41:00","inspection_id":"83408422","insp_unit_id":"204418624","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"ZP19785","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR2RL019167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:24.000000Z","updated_at":"2025-03-17T23:47:24.000000Z"},{"id":11991631,"change_date":"2024-12-16 21:41:00","inspection_id":"83408422","insp_unit_id":"204418625","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4UA1136","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C0DT399007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:24.000000Z","updated_at":"2025-03-17T23:47:24.000000Z"}]},{"id":7309568,"change_date":"2024-11-30 21:33:00","inspection_id":"83278578","dot_number":"2776659","report_state":"CA","report_number":"NC9Y006088","insp_date":"2024-11-22 00:00:00","insp_start_time":"0921","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ 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":"2024-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15612303","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:34.000000Z","updated_at":"2025-03-17T20:48:34.000000Z","inspection_violations":[{"id":11427128,"change_date":"2024-11-30 21:33:00","inspection_id":"83278578","insp_violation_id":"263154774","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"204115735","insp_violation_category_id":"30","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":"3922SLLEQP"}],"inspection_per_units":[{"id":11791130,"change_date":"2024-11-30 21:33:00","inspection_id":"83278578","insp_unit_id":"204115734","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/243828","insp_unit_license":"9H09854","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR4RL019168","insp_unit_decal":"Y","insp_unit_decal_number":"34467468","created_at":"2025-03-17T23:45:13.000000Z","updated_at":"2025-03-17T23:45:13.000000Z"},{"id":11791131,"change_date":"2024-11-30 21:33:00","inspection_id":"83278578","insp_unit_id":"204115735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"T-7 F\/B","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","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":7065102,"change_date":"2024-10-28 21:40:00","inspection_id":"83019845","dot_number":"2776659","report_state":"CA","report_number":"UEGR001698","insp_date":"2024-10-25 00:00:00","insp_start_time":"1004","insp_end_time":"1018","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS IF","county_code_state":"CA","county_code":"057","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15572651","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-10-28 21:40:00","snet_input_date":"2024-10-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-28 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:25.000000Z","updated_at":"2025-03-17T20:43:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11394548,"change_date":"2024-10-28 21:40:00","inspection_id":"83019845","insp_unit_id":"203624500","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"243828","insp_unit_license":"9H09854","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR4RL019168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:57.000000Z","updated_at":"2025-03-17T23:40:57.000000Z"},{"id":11394549,"change_date":"2024-10-28 21:40:00","inspection_id":"83019845","insp_unit_id":"203624501","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"9","insp_unit_license":"4UA1136","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C0DT399007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:57.000000Z","updated_at":"2025-03-17T23:40:57.000000Z"}]},{"id":6840956,"change_date":"2024-09-27 21:41:00","inspection_id":"82781779","dot_number":"2776659","report_state":"CA","report_number":"NDV8003577","insp_date":"2024-09-26 00:00:00","insp_start_time":"1418","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"223","location_desc":"DONNER PASS CVEF","county_code_state":"CA","county_code":"057","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":"2024-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15537090","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-09-27 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-27 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:57.000000Z","updated_at":"2025-03-17T20:38:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11032101,"change_date":"2024-09-27 21:41:00","inspection_id":"82781779","insp_unit_id":"203172340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"20F352","insp_unit_license":"EP06395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML2LH093425","insp_unit_decal":"Y","insp_unit_decal_number":"34143681","created_at":"2025-03-17T23:37:15.000000Z","updated_at":"2025-03-17T23:37:15.000000Z"}]},{"id":5998100,"change_date":"2024-06-14 21:41:00","inspection_id":"81880356","dot_number":"2776659","report_state":"CA","report_number":"NDLU006135","insp_date":"2024-06-12 00:00:00","insp_start_time":"1139","insp_end_time":"1209","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CALSIERRA PIPE","shipping_paper_number":"PO 4035","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-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15404087","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[{"id":9305760,"change_date":"2024-06-14 21:41:00","inspection_id":"81880356","insp_violation_id":"260100699","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201407837","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"3965B"},{"id":9305761,"change_date":"2024-06-14 21:41:00","inspection_id":"81880356","insp_violation_id":"260100700","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201407837","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9660848,"change_date":"2024-06-14 21:41:00","inspection_id":"81880356","insp_unit_id":"201407837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 22F368","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"}]},{"id":5798269,"change_date":"2024-05-20 21:43:00","inspection_id":"81663076","dot_number":"2776659","report_state":"CA","report_number":"UBG2003487","insp_date":"2024-05-17 00:00:00","insp_start_time":"1233","insp_end_time":"1259","registration_date":null,"region":"PT","ci_status_code":"C","location":"9435","location_desc":"KINGSBURG","county_code_state":"CA","county_code":"019","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":"2024-05-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15370055","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-05-20 21:43:00","snet_input_date":"2024-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-20 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T20:17:33.000000Z","updated_at":"2025-03-17T20:17:33.000000Z","inspection_violations":[{"id":8978813,"change_date":"2024-05-20 21:43:00","inspection_id":"81663076","insp_violation_id":"259619536","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9338966,"change_date":"2024-05-20 21:43:00","inspection_id":"81663076","insp_unit_id":"200993763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT\/3X","insp_unit_license":"9G91351","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR3RL019159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"},{"id":9338967,"change_date":"2024-05-20 21:43:00","inspection_id":"81663076","insp_unit_id":"200993764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FLT","insp_unit_license":"4UA1136","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C0DT399007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"}]},{"id":5658657,"change_date":"2024-05-02 21:43:00","inspection_id":"81511929","dot_number":"2776659","report_state":"CA","report_number":"N9ZT005816","insp_date":"2024-05-01 00:00:00","insp_start_time":"0645","insp_end_time":"0715","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":"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":"2024-05-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15346251","transaction_code":"A","transaction_date":"2024-05-01 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-05-02 21:43:00","snet_input_date":"2024-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-02 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:45.000000Z","updated_at":"2025-03-17T20:14:45.000000Z","inspection_violations":[{"id":8753805,"change_date":"2024-05-02 21:43:00","inspection_id":"81511929","insp_violation_id":"259291411","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"200705362","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA519542","created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":9114400,"change_date":"2024-05-02 21:43:00","inspection_id":"81511929","insp_unit_id":"200705361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G31390","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDZAPR1MN386644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:48.000000Z","updated_at":"2025-03-17T23:17:48.000000Z"},{"id":9114401,"change_date":"2024-05-02 21:43:00","inspection_id":"81511929","insp_unit_id":"200705362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUDD","insp_unit_company":null,"insp_unit_license":"4ER1396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"176125L","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:48.000000Z","updated_at":"2025-03-17T23:17:48.000000Z"}]},{"id":5526209,"change_date":"2024-04-16 21:42:00","inspection_id":"81367691","dot_number":"2776659","report_state":"CA","report_number":"NAGM008466","insp_date":"2024-04-12 00:00:00","insp_start_time":"1238","insp_end_time":"1308","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"2024-04-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"15320561","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-04-16 21:42:00","snet_input_date":"2024-04-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-16 21:42:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:20.000000Z","updated_at":"2025-03-17T20:12:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8901822,"change_date":"2024-04-16 21:42:00","inspection_id":"81367691","insp_unit_id":"200429833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7\/WHT","insp_unit_license":"9E91249","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDDP9X8EJ417466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:50.000000Z","updated_at":"2025-03-17T23:15:50.000000Z"},{"id":8901823,"change_date":"2024-04-16 21:42:00","inspection_id":"81367691","insp_unit_id":"200429834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":null,"insp_unit_license":"4UC8287","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:50.000000Z","updated_at":"2025-03-17T23:15:50.000000Z"}]},{"id":5363497,"change_date":"2024-03-25 21:41:00","inspection_id":"81189833","dot_number":"2776659","report_state":"CA","report_number":"NC20006595","insp_date":"2024-03-22 00:00:00","insp_start_time":"1215","insp_end_time":"1240","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15294099","transaction_code":"A","transaction_date":"2024-03-22 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-03-25 21:41:00","snet_input_date":"2024-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":8277367,"change_date":"2024-03-25 21:41:00","inspection_id":"81189833","insp_violation_id":"258571760","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200077591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3939A"},{"id":8277368,"change_date":"2024-03-25 21:41:00","inspection_id":"81189833","insp_violation_id":"258571761","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200077591","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":8637899,"change_date":"2024-03-25 21:41:00","inspection_id":"81189833","insp_unit_id":"200077590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9\/WHT","insp_unit_license":"9G83001","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDDP9X3JJ191895","insp_unit_decal":"Y","insp_unit_decal_number":"33534696","created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"},{"id":8637900,"change_date":"2024-03-25 21:41:00","inspection_id":"81189833","insp_unit_id":"200077591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":"2X\/FB","insp_unit_license":"4UC8287","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"}]},{"id":5290305,"change_date":"2024-03-14 21:42:00","inspection_id":"81110013","dot_number":"2776659","report_state":"CA","report_number":"N9PI007401","insp_date":"2024-03-13 00:00:00","insp_start_time":"1549","insp_end_time":"1613","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15281168","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[{"id":8158775,"change_date":"2024-03-14 21:42:00","inspection_id":"81110013","insp_violation_id":"258395547","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199923559","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:24.000000Z","updated_at":"2025-03-17T21:45:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8519451,"change_date":"2024-03-14 21:42:00","inspection_id":"81110013","insp_unit_id":"199923558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHT 243778","insp_unit_license":"9G991351","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR3RL019159","insp_unit_decal":"Y","insp_unit_decal_number":"33536902","created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"},{"id":8519452,"change_date":"2024-03-14 21:42:00","inspection_id":"81110013","insp_unit_id":"199923559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"FB TRL","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":4210656,"change_date":"2023-10-16 21:43:00","inspection_id":"79926367","dot_number":"2776659","report_state":"CA","report_number":"NBGO005803","insp_date":"2023-10-13 00:00:00","insp_start_time":"1025","insp_end_time":"1041","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43: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":"15098185","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6771470,"change_date":"2023-10-16 21:43:00","inspection_id":"79926367","insp_unit_id":"197585513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"22F368\/WHT","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"Y","insp_unit_decal_number":"33268111","created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":4167788,"change_date":"2023-10-10 21:42:00","inspection_id":"79879050","dot_number":"2776659","report_state":"CA","report_number":"UECE005223","insp_date":"2023-10-10 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"252","location_desc":"SR-99 NB NOF SHELDON","county_code_state":"CA","county_code":"067","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-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15091292","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6702152,"change_date":"2023-10-10 21:42:00","inspection_id":"79879050","insp_unit_id":"197489110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G83001","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDDP9X3JJ191895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"},{"id":6702153,"change_date":"2023-10-10 21:42:00","inspection_id":"79879050","insp_unit_id":"197489111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLMO","insp_unit_company":null,"insp_unit_license":"1WC3688","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PTF71TJ1V9004206","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:12.000000Z","updated_at":"2025-03-17T22:56:12.000000Z"}]},{"id":4096579,"change_date":"2023-09-29 21:40:00","inspection_id":"79800189","dot_number":"2776659","report_state":"CA","report_number":"UBA8000737","insp_date":"2023-09-29 00:00:00","insp_start_time":"0949","insp_end_time":"0956","registration_date":null,"region":"PT","ci_status_code":"C","location":"295","location_desc":"AMADORO AREA","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-29 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":"15080806","transaction_code":"A","transaction_date":"2023-09-29 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-09-29 21:40:00","snet_input_date":"2023-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-29 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:40.000000Z","updated_at":"2025-03-17T19:43:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6586207,"change_date":"2023-09-29 21:40:00","inspection_id":"79800189","insp_unit_id":"197330545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"EP06395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTEUMML2LH093425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:16.000000Z","updated_at":"2025-03-17T22:55:16.000000Z"}]},{"id":4075262,"change_date":"2023-09-27 21:42:00","inspection_id":"79776520","dot_number":"2776659","report_state":"CA","report_number":"ND7N007074","insp_date":"2023-09-25 00:00:00","insp_start_time":"1557","insp_end_time":"1617","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2023-09-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15074714","transaction_code":"A","transaction_date":"2023-09-25 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-09-27 21:42:00","snet_input_date":"2023-09-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-27 21:42:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:14.000000Z","updated_at":"2025-03-17T19:43:14.000000Z","inspection_violations":[{"id":6308661,"change_date":"2023-09-27 21:42:00","inspection_id":"79776520","insp_violation_id":"255531035","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197281004","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6552339,"change_date":"2023-09-27 21:42:00","inspection_id":"79776520","insp_unit_id":"197281003","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"243778 WT","insp_unit_license":"BZ33E27","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HCDZAPR3RL019159","insp_unit_decal":"Y","insp_unit_decal_number":"32869797","created_at":"2025-03-17T22:55:00.000000Z","updated_at":"2025-03-17T22:55:00.000000Z"},{"id":6552340,"change_date":"2023-09-27 21:42:00","inspection_id":"79776520","insp_unit_id":"197281004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"T7 FB","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:00.000000Z","updated_at":"2025-03-17T22:55:00.000000Z"}]},{"id":3997018,"change_date":"2023-09-18 21:39:00","inspection_id":"79689426","dot_number":"2776659","report_state":"CA","report_number":"NCPN004510","insp_date":"2023-09-14 00:00:00","insp_start_time":"1823","insp_end_time":"1847","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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":"2023-09-18 21:39: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":"15066185","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-09-18 21:39:00","snet_input_date":"2023-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:40.000000Z","updated_at":"2025-03-17T19:41:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6427182,"change_date":"2023-09-18 21:39:00","inspection_id":"79689426","insp_unit_id":"197109254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"23F883\/WHT","insp_unit_license":"28057T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"Y","insp_unit_decal_number":"32918781","created_at":"2025-03-17T22:53:58.000000Z","updated_at":"2025-03-17T22:53:58.000000Z"}]},{"id":3668243,"change_date":"2023-08-03 21:41:00","inspection_id":"79322958","dot_number":"2776659","report_state":"CA","report_number":"UDJB003077","insp_date":"2023-08-03 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"N\/B SANTA NELLA PLATFORM SCALE","county_code_state":"CA","county_code":"047","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":"2023-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15007718","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-08-03 21:41:00","snet_input_date":"2023-08-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-03 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:35:17.000000Z","updated_at":"2025-03-17T19:35:17.000000Z","inspection_violations":[{"id":5655268,"change_date":"2023-08-03 21:41:00","inspection_id":"79322958","insp_violation_id":"254461651","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:12.000000Z","updated_at":"2025-03-17T21:33:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5897723,"change_date":"2023-08-03 21:41:00","inspection_id":"79322958","insp_unit_id":"196358855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"23F383","insp_unit_license":"28057T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXPL773220","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:35.000000Z","updated_at":"2025-03-17T22:49:35.000000Z"}]},{"id":3494360,"change_date":"2023-07-12 21:41:00","inspection_id":"79127919","dot_number":"2776659","report_state":"CA","report_number":"NCTX005505","insp_date":"2023-07-12 00:00:00","insp_start_time":"1025","insp_end_time":"1059","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14978984","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-07-12 21:41:00","snet_input_date":"2023-07-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-12 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:32:06.000000Z","updated_at":"2025-03-17T19:32:06.000000Z","inspection_violations":[{"id":5389093,"change_date":"2023-07-12 21:41:00","inspection_id":"79127919","insp_violation_id":"254027841","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195968269","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KV81538","created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5618895,"change_date":"2023-07-12 21:41:00","inspection_id":"79127919","insp_unit_id":"195968269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8\/WHT\/WHT","insp_unit_license":"YP18409","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3WKDDP9X1GF124354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"},{"id":5618896,"change_date":"2023-07-12 21:41:00","inspection_id":"79127919","insp_unit_id":"195968270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TNSC","insp_unit_company":"8\/WHT","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:20.000000Z","updated_at":"2025-03-17T22:47:20.000000Z"}]},{"id":3185735,"change_date":"2023-05-31 21:43:00","inspection_id":"78780285","dot_number":"2776659","report_state":"CA","report_number":"NBGO005003","insp_date":"2023-05-26 00:00:00","insp_start_time":"1105","insp_end_time":"1120","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-31 21:43: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":"14923172","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-05-31 21:43:00","snet_input_date":"2023-05-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-31 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:26:05.000000Z","updated_at":"2025-03-17T19:26:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5124406,"change_date":"2023-05-31 21:43:00","inspection_id":"78780285","insp_unit_id":"195243936","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"22F368\/WHT","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"Y","insp_unit_decal_number":"32549911","created_at":"2025-03-17T22:43:22.000000Z","updated_at":"2025-03-17T22:43:22.000000Z"}]},{"id":3172487,"change_date":"2023-05-30 21:43:00","inspection_id":"78765144","dot_number":"2776659","report_state":"CA","report_number":"ND7N006514","insp_date":"2023-05-25 00:00:00","insp_start_time":"1629","insp_end_time":"1653","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14922653","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5103195,"change_date":"2023-05-30 21:43:00","inspection_id":"78765144","insp_unit_id":"195213860","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X WHT","insp_unit_license":"XP71934","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPBDP9X5KD613165","insp_unit_decal":"Y","insp_unit_decal_number":"32494273","created_at":"2025-03-17T22:43:13.000000Z","updated_at":"2025-03-17T22:43:13.000000Z"},{"id":5103196,"change_date":"2023-05-30 21:43:00","inspection_id":"78765144","insp_unit_id":"195213861","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":"2X FB","insp_unit_license":"4UC8287","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5419","insp_unit_decal":"Y","insp_unit_decal_number":"32494274","created_at":"2025-03-17T22:43:13.000000Z","updated_at":"2025-03-17T22:43:13.000000Z"}]},{"id":2120192,"change_date":"2023-01-11 21:43:00","inspection_id":"77569389","dot_number":"2776659","report_state":"CA","report_number":"NCNK005560","insp_date":"2023-01-09 00:00:00","insp_start_time":"1514","insp_end_time":"1545","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAL-SIERRA PIPE LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"14736362","transaction_code":"A","transaction_date":"2023-01-09 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"39868BAKER","created_at":"2025-03-17T19:05:50.000000Z","updated_at":"2025-03-17T19:05:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3412488,"change_date":"2023-01-11 21:43:00","inspection_id":"77569389","insp_unit_id":"192821468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT\/8","insp_unit_license":"YP18409","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3WKDDP9X1GF124354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"},{"id":3412489,"change_date":"2023-01-11 21:43:00","inspection_id":"77569389","insp_unit_id":"192821469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"FLAT\/T8","insp_unit_license":"4NN6049","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DTP16W21GP021875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:27.000000Z","updated_at":"2025-03-17T22:30:27.000000Z"}]},{"id":2120914,"change_date":"2023-01-11 21:43:00","inspection_id":"77570179","dot_number":"2776659","report_state":"CA","report_number":"NDLY005627","insp_date":"2023-01-06 00:00:00","insp_start_time":"1444","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14732326","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2023-01-11 21:43:00","snet_input_date":"2023-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-11 21:43:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T19:05:50.000000Z","updated_at":"2025-03-17T19:05:50.000000Z","inspection_violations":[{"id":3283272,"change_date":"2023-01-11 21:43:00","inspection_id":"77570179","insp_violation_id":"250520320","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192822761","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:22:33.000000Z","updated_at":"2025-03-17T21:22:33.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3413631,"change_date":"2023-01-11 21:43:00","inspection_id":"77570179","insp_unit_id":"192822761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9\/WHT","insp_unit_license":"YP18410","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDDP9X3JJ191895","insp_unit_decal":"Y","insp_unit_decal_number":"32168562","created_at":"2025-03-17T22:30:28.000000Z","updated_at":"2025-03-17T22:30:28.000000Z"},{"id":3413632,"change_date":"2023-01-11 21:43:00","inspection_id":"77570179","insp_unit_id":"192822762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"9\/FB","insp_unit_license":"4UA1136","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C0DT399007","insp_unit_decal":"Y","insp_unit_decal_number":"32168563","created_at":"2025-03-17T22:30:28.000000Z","updated_at":"2025-03-17T22:30:28.000000Z"}]},{"id":1585341,"change_date":"2022-10-24 21:41:00","inspection_id":"76956942","dot_number":"2776659","report_state":"CA","report_number":"NAGM005624","insp_date":"2022-10-17 00:00:00","insp_start_time":"1101","insp_end_time":"1120","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14647082","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2022-10-24 21:41:00","snet_input_date":"2022-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-24 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T18:55:55.000000Z","updated_at":"2025-03-17T18:55:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2551538,"change_date":"2022-10-24 21:41:00","inspection_id":"76956942","insp_unit_id":"191606893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"22F368\/WHT","insp_unit_license":"05724J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAEUMMLXNL455062","insp_unit_decal":"Y","insp_unit_decal_number":"31878814","created_at":"2025-03-17T22:24:30.000000Z","updated_at":"2025-03-17T22:24:30.000000Z"}]},{"id":1308575,"change_date":"2022-09-16 21:41:00","inspection_id":"76636603","dot_number":"2776659","report_state":"CA","report_number":"NBH0005378","insp_date":"2022-09-12 00:00:00","insp_start_time":"1049","insp_end_time":"1217","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-09-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14597953","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2022-09-16 21:41:00","snet_input_date":"2022-09-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-16 21:41:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T18:50:50.000000Z","updated_at":"2025-03-17T18:50:50.000000Z","inspection_violations":[{"id":2072738,"change_date":"2022-09-16 21:41:00","inspection_id":"76636603","insp_violation_id":"248485660","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190957535","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:29.000000Z","updated_at":"2025-03-17T21:16:29.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2106543,"change_date":"2022-09-16 21:41:00","inspection_id":"76636603","insp_unit_id":"190957534","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8\/WHT","insp_unit_license":"YP18409","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3WKDDP9X1GF124354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"},{"id":2106544,"change_date":"2022-09-16 21:41:00","inspection_id":"76636603","insp_unit_id":"190957535","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"BLK","insp_unit_license":"1WC3688","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PTF71TJ1V9004206","insp_unit_decal":"Y","insp_unit_decal_number":"31490376","created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":1021251,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","dot_number":"2776659","report_state":"CA","report_number":"N91G003327","insp_date":"2022-08-08 00:00:00","insp_start_time":"1050","insp_end_time":"1138","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD CVEF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CAL-SIERRA PIPE","shipping_paper_number":"20319-001","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-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14545102","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:46.000000Z","updated_at":"2025-03-17T18:45:46.000000Z","inspection_violations":[{"id":1610557,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","insp_violation_id":"247672214","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190271218","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39375A3"},{"id":1610558,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","insp_violation_id":"247672215","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190271218","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39375A3"},{"id":1610559,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","insp_violation_id":"247672216","seq_no":"3","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"190271219","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39387A"}],"inspection_per_units":[{"id":1643389,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","insp_unit_id":"190271218","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9\/WHI","insp_unit_license":"YP18410","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKDDP9X3JJ191895","insp_unit_decal":"Y","insp_unit_decal_number":"31451327","created_at":"2025-03-17T22:18:21.000000Z","updated_at":"2025-03-17T22:18:21.000000Z"},{"id":1643390,"change_date":"2022-08-11 21:38:00","inspection_id":"76302268","insp_unit_id":"190271219","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"BLUE\/FLTBD","insp_unit_license":"1VU9941","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE48204F1026159","insp_unit_decal":"Y","insp_unit_decal_number":"31451328","created_at":"2025-03-17T22:18:21.000000Z","updated_at":"2025-03-17T22:18:21.000000Z"}]},{"id":869481,"change_date":"2022-07-21 21:40:00","inspection_id":"76124757","dot_number":"2776659","report_state":"CA","report_number":"NDMK003645","insp_date":"2022-07-20 00:00:00","insp_start_time":"1113","insp_end_time":"1140","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":"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":"2022-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14516220","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2022-07-21 21:40:00","snet_input_date":"2022-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-21 21:40:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[{"id":1369336,"change_date":"2022-07-21 21:40:00","inspection_id":"76124757","insp_violation_id":"247245193","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189908248","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"},{"id":1369337,"change_date":"2022-07-21 21:40:00","inspection_id":"76124757","insp_violation_id":"247245194","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189908248","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1399760,"change_date":"2022-07-21 21:40:00","inspection_id":"76124757","insp_unit_id":"189908247","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP18409","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3WKDDP9X1GF124354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"},{"id":1399761,"change_date":"2022-07-21 21:40:00","inspection_id":"76124757","insp_unit_id":"189908248","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TCRFT","insp_unit_company":null,"insp_unit_license":"1VU9941","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTE48204F1026159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"}]},{"id":424991,"change_date":"2022-05-18 21:44:00","inspection_id":"75599940","dot_number":"2776659","report_state":"CA","report_number":"ND7N004861","insp_date":"2022-05-17 00:00:00","insp_start_time":"1559","insp_end_time":"1628","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","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-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14433970","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02776659","upload_search_indicator":null,"census_search_date":"2022-05-18 21:44:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-18 21:44:00","insp_carrier_name":"CAL-SIERRA PIPE LLC","insp_carrier_street":"3033 S HIGHWAY 99","insp_carrier_city":"STOCKTON","insp_carrier_state":"CA","insp_carrier_zip_code":"95215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"398680","created_at":"2025-03-17T18:35:07.000000Z","updated_at":"2025-03-17T18:35:07.000000Z","inspection_violations":[{"id":668852,"change_date":"2022-05-18 21:44:00","inspection_id":"75599940","insp_violation_id":"245901334","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188773430","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNED","created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39347E"},{"id":668853,"change_date":"2022-05-18 21:44:00","inspection_id":"75599940","insp_violation_id":"245901335","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188773430","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:10.000000Z","updated_at":"2025-03-17T21:10:10.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":685870,"change_date":"2022-05-18 21:44:00","inspection_id":"75599940","insp_unit_id":"188773430","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8 WHT","insp_unit_license":"YP18409","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3WKDDP9X1GF124354","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"},{"id":685871,"change_date":"2022-05-18 21:44:00","inspection_id":"75599940","insp_unit_id":"188773431","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"T7 FB","insp_unit_license":"4NM9545","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TTF4820062016002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:25.000000Z","updated_at":"2025-03-17T22:12:25.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2776659\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2776659\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2776659\/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\/2776659\/inspections","per_page":100,"prev_page_url":null,"to":45,"total":45}