{"current_page":1,"data":[{"id":11328230,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","dot_number":"2048792","report_state":"CA","report_number":"UD2M003249","insp_date":"2026-03-09 00:00:00","insp_start_time":"0940","insp_end_time":"1036","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"MODESTO AREA","county_code_state":"CA","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","shipping_paper_number":"NONE SEEN","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-09 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16200991","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-03-09 21:37:00","snet_input_date":"2026-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-09 21:37:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-03-12T09:40:31.000000Z","updated_at":"2026-03-20T09:31:28.000000Z","inspection_violations":[{"id":19067543,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295718","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212051266","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00ND002TJ","created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"3922SLLSR"},{"id":19067544,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295719","seq_no":"1","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"393100CC"},{"id":19067545,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295720","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"3922SLLEQP"},{"id":19067546,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295721","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"393110B3C"},{"id":19067547,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295722","seq_no":"4","part_no":"393","part_no_section":"106C1-C","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"393106C1C"},{"id":19067548,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295723","seq_no":"5","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"39311A1LSML"},{"id":19067549,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295724","seq_no":"6","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00ND002TJ","created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"39311A1LSML"},{"id":19067550,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_violation_id":"272295725","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"212051267","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-12T10:02:00.000000Z","updated_at":"2026-03-20T09:44:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":19382736,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_unit_id":"212051267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"4KY4097","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1KNFT21223L161215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:11.000000Z","updated_at":"2026-03-20T09:04:23.000000Z"},{"id":19382735,"change_date":"2026-03-09 21:37:00","inspection_id":"87245202","insp_unit_id":"212051266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"83278W3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5HT3PED95730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-12T09:21:11.000000Z","updated_at":"2026-03-20T09:04:23.000000Z"}]},{"id":10885661,"change_date":"2026-01-29 21:39:00","inspection_id":"86916331","dot_number":"2048792","report_state":"CA","report_number":"NCNY007916","insp_date":"2026-01-27 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16150245","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:54.000000Z","inspection_violations":[{"id":18225785,"change_date":"2026-01-29 21:39:00","inspection_id":"86916331","insp_violation_id":"271498221","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211349829","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"3922SLLEQP"},{"id":18225786,"change_date":"2026-01-29 21:39:00","inspection_id":"86916331","insp_violation_id":"271498222","seq_no":"2","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"211349829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"39311A1LFTSM"},{"id":18225787,"change_date":"2026-01-29 21:39:00","inspection_id":"86916331","insp_violation_id":"271498223","seq_no":"3","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"211349829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":18298896,"change_date":"2026-01-29 21:39:00","inspection_id":"86916331","insp_unit_id":"211349829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"43\/WHT","insp_unit_license":"44609M1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X3EM237546","insp_unit_decal":"Y","insp_unit_decal_number":"35891531","created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:08.000000Z"}]},{"id":10885662,"change_date":"2026-01-29 21:39:00","inspection_id":"86916332","dot_number":"2048792","report_state":"CA","report_number":"NCNY007917","insp_date":"2026-01-27 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31240","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16150246","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:54.000000Z","inspection_violations":[{"id":18225788,"change_date":"2026-01-29 21:39:00","inspection_id":"86916332","insp_violation_id":"271498224","seq_no":"1","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"1","insp_unit_id":"211349830","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"39348ABIHE"},{"id":18225790,"change_date":"2026-01-29 21:39:00","inspection_id":"86916332","insp_violation_id":"271498226","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"211349830","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"3963A1BOS"},{"id":18225789,"change_date":"2026-01-29 21:39:00","inspection_id":"86916332","insp_violation_id":"271498225","seq_no":"2","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"1","insp_unit_id":"211349830","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:21.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":18298897,"change_date":"2026-01-29 21:39:00","inspection_id":"86916332","insp_unit_id":"211349830","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"TOWR","insp_unit_company":"T-24\/FB","insp_unit_license":"1WH2318","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KNFT2129YL162501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:08.000000Z"}]},{"id":10885663,"change_date":"2026-01-29 21:39:00","inspection_id":"86916333","dot_number":"2048792","report_state":"CA","report_number":"NCNY007918","insp_date":"2026-01-27 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"16150247","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18298898,"change_date":"2026-01-29 21:39:00","inspection_id":"86916333","insp_unit_id":"211349831","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"TRAIL","insp_unit_company":"22\/FB","insp_unit_license":"4SS4764","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1G9FS31215A065324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:08.000000Z"}]},{"id":10885664,"change_date":"2026-01-29 21:39:00","inspection_id":"86916334","dot_number":"2048792","report_state":"CA","report_number":"NCNY007919","insp_date":"2026-01-27 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"16150248","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18298899,"change_date":"2026-01-29 21:39:00","inspection_id":"86916334","insp_unit_id":"211349832","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"TOWR","insp_unit_company":"T-23 FB","insp_unit_license":"4KY4097","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1KNFT21223L161215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:08.000000Z"}]},{"id":10885924,"change_date":"2026-01-29 21:39:00","inspection_id":"86916597","dot_number":"2048792","report_state":"CA","report_number":"NCNY007914","insp_date":"2026-01-27 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16150243","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18299279,"change_date":"2026-01-29 21:39:00","inspection_id":"86916597","insp_unit_id":"211350234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"56\/WHT","insp_unit_license":"59056PZ","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPCL40XUJD496137","insp_unit_decal":"Y","insp_unit_decal_number":"35891530","created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:10.000000Z"}]},{"id":10885925,"change_date":"2026-01-29 21:39:00","inspection_id":"86916598","dot_number":"2048792","report_state":"CA","report_number":"NCNY007915","insp_date":"2026-01-27 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"TURLOCK AREA","county_code_state":"CA","county_code":"099","insp_level_id":"5","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":"2026-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"16150244","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2026-01-29 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-29 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2026-02-01T10:35:59.000000Z","updated_at":"2026-02-10T10:30:56.000000Z","inspection_violations":[{"id":18226034,"change_date":"2026-01-29 21:39:00","inspection_id":"86916598","insp_violation_id":"271498477","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211350235","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-01T10:47:43.000000Z","updated_at":"2026-02-10T10:39:22.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":18299280,"change_date":"2026-01-29 21:39:00","inspection_id":"86916598","insp_unit_id":"211350235","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"36\/WHT","insp_unit_license":"30769B1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LN0X3BM119061","insp_unit_decal":"Y","insp_unit_decal_number":"35891529","created_at":"2026-02-01T10:10:48.000000Z","updated_at":"2026-02-09T10:02:10.000000Z"}]},{"id":9426876,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","dot_number":"2048792","report_state":"CA","report_number":"UD2M002984","insp_date":"2025-08-14 00:00:00","insp_start_time":"1125","insp_end_time":"1231","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"MODESTO AREA","county_code_state":"CA","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","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":"N","pen_cen_match":null,"final_status_date":"2025-08-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15939367","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"DON PEDRO PUMP LLC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-08-20T10:44:42.000000Z","updated_at":"2025-08-20T10:44:42.000000Z","inspection_violations":[{"id":15339960,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063372","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00ND002GZ","created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"3922SLLSOA"},{"id":15339961,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063373","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"39345B2BHTD"},{"id":15339962,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063374","seq_no":"3","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"39348ABIBD"},{"id":15339963,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063375","seq_no":"4","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"39348ABIBD"},{"id":15339964,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063376","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"3963A1BOS"},{"id":15339965,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_violation_id":"268063377","seq_no":"6","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"208426151","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:45:07.000000Z","updated_at":"2025-08-19T10:45:06.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":15540109,"change_date":"2025-08-15 21:39:00","inspection_id":"85507730","insp_unit_id":"208426151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"60651F1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LN0X8CM159069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:34.000000Z","updated_at":"2025-08-19T09:46:07.000000Z"}]},{"id":8706535,"change_date":"2025-05-21 21:42:00","inspection_id":"84747659","dot_number":"2048792","report_state":"CA","report_number":"UCP8000615","insp_date":"2025-05-20 00:00:00","insp_start_time":"1455","insp_end_time":"1529","registration_date":null,"region":"PT","ci_status_code":"C","location":"465","location_desc":"WHITMORE EB WOF BERKELEY","county_code_state":"CA","county_code":"099","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15829543","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT RD","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:40.000000Z","updated_at":"2025-05-25T10:07:36.000000Z","inspection_violations":[{"id":13877981,"change_date":"2025-05-21 21:42:00","inspection_id":"84747659","insp_violation_id":"266391985","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"207000882","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:53.000000Z","updated_at":"2025-05-25T10:28:04.000000Z","normalized_code":"3922SLLSOA"},{"id":13877980,"change_date":"2025-05-21 21:42:00","inspection_id":"84747659","insp_violation_id":"266391984","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"207000882","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RU10345","created_at":"2025-05-24T10:28:53.000000Z","updated_at":"2025-05-25T10:28:04.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14227662,"change_date":"2025-05-21 21:42:00","inspection_id":"84747659","insp_unit_id":"207000882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"52","insp_unit_license":"44180C1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NKHHN7X3CM302769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:50:03.000000Z","updated_at":"2025-05-25T09:53:36.000000Z"}]},{"id":7495340,"change_date":"2024-12-24 21:35:00","inspection_id":"83473914","dot_number":"2048792","report_state":"CA","report_number":"UD2M002639","insp_date":"2024-12-24 00:00:00","insp_start_time":"0805","insp_end_time":"0836","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","location_desc":"MERCED AREA","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE","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":"N","pen_cen_match":null,"final_status_date":"2024-12-24 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15641447","transaction_code":"A","transaction_date":"2024-12-24 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2024-12-24 21:35:00","snet_input_date":"2024-12-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-24 21:35:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T20:52:21.000000Z","updated_at":"2025-03-17T20:52:21.000000Z","inspection_violations":[{"id":11715910,"change_date":"2024-12-24 21:35:00","inspection_id":"83473914","insp_violation_id":"263647597","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204546428","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00ND00006","created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLSR"},{"id":11715911,"change_date":"2024-12-24 21:35:00","inspection_id":"83473914","insp_violation_id":"263647598","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204546428","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12091799,"change_date":"2024-12-24 21:35:00","inspection_id":"83473914","insp_unit_id":"204546428","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"60651F1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LN0X8CM159069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:31.000000Z","updated_at":"2025-03-17T23:48:31.000000Z"}]},{"id":6417129,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","dot_number":"2048792","report_state":"CA","report_number":"UDP0005306","insp_date":"2024-08-07 00:00:00","insp_start_time":"0640","insp_end_time":"0654","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"STOCKTON AREA","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"41740","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15474164","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2024-08-07 21:42:00","snet_input_date":"2024-08-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-07 21:42:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T20:29:55.000000Z","updated_at":"2025-03-17T20:29:55.000000Z","inspection_violations":[{"id":9964082,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","insp_violation_id":"261077170","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"202289298","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"393100B"},{"id":9964083,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","insp_violation_id":"261077171","seq_no":"2","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"202289298","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"393110B"},{"id":9964084,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","insp_violation_id":"261077172","seq_no":"3","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"202289298","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"393104B"}],"inspection_per_units":[{"id":10342158,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","insp_unit_id":"202289297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"49","insp_unit_license":"73566X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRNFL8GG113637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"},{"id":10342159,"change_date":"2024-08-07 21:42:00","inspection_id":"82330185","insp_unit_id":"202289298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CMI","insp_unit_company":null,"insp_unit_license":"4CA2283","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"49TFG2521M1001285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:10.000000Z","updated_at":"2025-03-17T23:30:10.000000Z"}]},{"id":5999101,"change_date":"2024-06-14 21:41:00","inspection_id":"81881414","dot_number":"2048792","report_state":"CA","report_number":"NC43008283","insp_date":"2024-06-13 00:00:00","insp_start_time":"1553","insp_end_time":"1648","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-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"57240","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":"15404916","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2024-06-14 21:41:00","snet_input_date":"2024-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-14 21:41:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T20:21:31.000000Z","updated_at":"2025-03-17T20:21:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9662238,"change_date":"2024-06-14 21:41:00","inspection_id":"81881414","insp_unit_id":"201409416","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2X\/WHT","insp_unit_license":"79964B3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKTSWK0LH340648","insp_unit_decal":"Y","insp_unit_decal_number":"33819314","created_at":"2025-03-17T23:23:08.000000Z","updated_at":"2025-03-17T23:23:08.000000Z"},{"id":9662239,"change_date":"2024-06-14 21:41:00","inspection_id":"81881414","insp_unit_id":"201409417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"2X\/RED","insp_unit_license":"1WH2318","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4KNFT2129YL162501","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":5601354,"change_date":"2024-04-25 21:43:00","inspection_id":"81449431","dot_number":"2048792","report_state":"CA","report_number":"NC43008042","insp_date":"2024-04-24 00:00:00","insp_start_time":"1636","insp_end_time":"1649","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-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15335091","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9022587,"change_date":"2024-04-25 21:43:00","inspection_id":"81449431","insp_unit_id":"200585247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X\/WHT","insp_unit_license":"97685P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5HT6NEE67145","insp_unit_decal":"Y","insp_unit_decal_number":"33819086","created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":4095775,"change_date":"2023-09-29 21:40:00","inspection_id":"79799323","dot_number":"2048792","report_state":"CA","report_number":"NCNY006046","insp_date":"2023-09-28 00:00:00","insp_start_time":"1114","insp_end_time":"1139","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":"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":"N","pen_cen_match":null,"final_status_date":"2023-09-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15080393","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2023-09-29 21:40:00","snet_input_date":"2023-09-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-29 21:40:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T19:43:40.000000Z","updated_at":"2025-03-17T19:43:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6584919,"change_date":"2023-09-29 21:40:00","inspection_id":"79799323","insp_unit_id":"197329105","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"57\/WHT","insp_unit_license":"48710W2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5HT3KEF50074","insp_unit_decal":"Y","insp_unit_decal_number":"32868719","created_at":"2025-03-17T22:55:14.000000Z","updated_at":"2025-03-17T22:55:14.000000Z"}]},{"id":3947906,"change_date":"2023-09-11 21:41:00","inspection_id":"79635045","dot_number":"2048792","report_state":"CA","report_number":"N9ZT005008","insp_date":"2023-09-07 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"15055637","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2023-09-11 21:41:00","snet_input_date":"2023-09-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-11 21:41:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T19:40:48.000000Z","updated_at":"2025-03-17T19:40:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6348361,"change_date":"2023-09-11 21:41:00","inspection_id":"79635045","insp_unit_id":"196999204","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"18024R3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVDCXDT5FHGE2944","insp_unit_decal":"Y","insp_unit_decal_number":"32852483","created_at":"2025-03-17T22:53:19.000000Z","updated_at":"2025-03-17T22:53:19.000000Z"}]},{"id":3625010,"change_date":"2023-07-28 21:42:00","inspection_id":"79274379","dot_number":"2048792","report_state":"CA","report_number":"NDLY006588","insp_date":"2023-07-27 00:00:00","insp_start_time":"1508","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":"DON PEDRO PUMP","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-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14999386","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5828314,"change_date":"2023-07-28 21:42:00","inspection_id":"79274379","insp_unit_id":"196262772","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"64\/WHT","insp_unit_license":"97685P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0X5HT6NEE67145","insp_unit_decal":"Y","insp_unit_decal_number":"32869902","created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3060288,"change_date":"2023-05-16 21:43:00","inspection_id":"78638650","dot_number":"2048792","report_state":"CA","report_number":"UD4T000462","insp_date":"2023-05-16 00:00:00","insp_start_time":"1106","insp_end_time":"1129","registration_date":null,"region":"PT","ci_status_code":"C","location":"9211","location_desc":"SAN JOQAUIN COUNTY","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14904370","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2023-05-16 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-16 21:43:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"503246","created_at":"2025-03-17T19:23:43.000000Z","updated_at":"2025-03-17T19:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4923574,"change_date":"2023-05-16 21:43:00","inspection_id":"78638650","insp_unit_id":"194966752","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"40","insp_unit_license":"60651F1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LN0X8CM159069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:48.000000Z","updated_at":"2025-03-17T22:41:48.000000Z"}]},{"id":622020,"change_date":"2022-06-15 21:41:00","inspection_id":"75834310","dot_number":"2048792","report_state":"CA","report_number":"NCNY004202","insp_date":"2022-06-14 00:00:00","insp_start_time":"1507","insp_end_time":"1525","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":"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":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"14470792","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02048792","upload_search_indicator":null,"census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"DON PEDRO COMPANY INC","insp_carrier_street":"1930 S WALNUT","insp_carrier_city":"TURLCOK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1000327,"change_date":"2022-06-15 21:41:00","inspection_id":"75834310","insp_unit_id":"189281117","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X\/WHT","insp_unit_license":"54891Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WRNBL3FG543581","insp_unit_decal":"Y","insp_unit_decal_number":"31132777","created_at":"2025-03-17T22:14:21.000000Z","updated_at":"2025-03-17T22:14:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2048792\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2048792\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2048792\/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\/2048792\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}