{"current_page":1,"data":[{"id":12098247,"change_date":"2026-06-04 21:46:00","inspection_id":"88042526","dot_number":"1547096","report_state":"CA","report_number":"NC4I006291","insp_date":"2026-06-01 00:00:00","insp_start_time":"0720","insp_end_time":"0741","registration_date":null,"region":"PS","ci_status_code":"C","location":"883","location_desc":"CA","county_code_state":"CA","county_code":"071","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":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"3458608","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:54.000000Z","updated_at":"2026-06-16T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21021556,"change_date":"2026-06-04 21:46:00","inspection_id":"88042526","insp_unit_id":"213914521","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TRT8\/BLUE","insp_unit_license":"9G89661","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X1JJ217717","insp_unit_decal":"Y","insp_unit_decal_number":"36256007","created_at":"2026-06-07T09:18:03.000000Z","updated_at":"2026-06-16T09:03:41.000000Z"}]},{"id":11963317,"change_date":"2026-05-19 21:40:00","inspection_id":"87899609","dot_number":"1547096","report_state":"CA","report_number":"NBED007971","insp_date":"2026-05-19 00:00:00","insp_start_time":"1010","insp_end_time":"1235","registration_date":null,"region":"PS","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3363003","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2026-05-22T09:41:13.000000Z","updated_at":"2026-05-30T09:30:54.000000Z","inspection_violations":[{"id":20809160,"change_date":"2026-05-19 21:40:00","inspection_id":"87899609","insp_violation_id":"274367816","seq_no":"1","part_no":"396","part_no_section":"3A1-DLDSUJBCB","insp_viol_unit":"1","insp_unit_id":"213645592","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-22T10:01:34.000000Z","updated_at":"2026-05-30T09:41:22.000000Z","normalized_code":"3963A1DLDSUJBCB"}],"inspection_per_units":[{"id":20800739,"change_date":"2026-05-19 21:40:00","inspection_id":"87899609","insp_unit_id":"213645592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TRU19 YELL","insp_unit_license":"59012W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYCY1GHHL4613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:48.000000Z","updated_at":"2026-05-30T09:03:11.000000Z"}]},{"id":10591510,"change_date":"2026-01-07 21:39:00","inspection_id":"86730343","dot_number":"1547096","report_state":"CA","report_number":"NCGL005666","insp_date":"2026-01-06 00:00:00","insp_start_time":"1300","insp_end_time":"1344","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"PERALTA SCALES W\/B","county_code_state":"CA","county_code":"059","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16118591","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2026-01-07 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-07 21:39:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2026-01-10T10:34:42.000000Z","updated_at":"2026-01-18T10:32:08.000000Z","inspection_violations":[{"id":17802947,"change_date":"2026-01-07 21:39:00","inspection_id":"86730343","insp_violation_id":"271069833","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210961701","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3922SLLSR"},{"id":17802948,"change_date":"2026-01-07 21:39:00","inspection_id":"86730343","insp_violation_id":"271069834","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"210961701","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":17754267,"change_date":"2026-01-07 21:39:00","inspection_id":"86730343","insp_unit_id":"210961701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YLLW-3X","insp_unit_license":"59012W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYCY1GHHL4613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:12.000000Z","updated_at":"2026-01-18T10:01:41.000000Z"}]},{"id":9953982,"change_date":"2025-10-15 21:40:00","inspection_id":"86061697","dot_number":"1547096","report_state":"CA","report_number":"UHB3001920","insp_date":"2025-10-15 00:00:00","insp_start_time":"0700","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"SR-91 W\/B PERALTA SCALES","county_code_state":"CA","county_code":"059","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":"2025-10-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16019141","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2025-10-15 21:40:00","snet_input_date":"2025-10-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-15 21:40:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-18T10:02:01.000000Z","updated_at":"2025-10-19T10:01:23.000000Z","inspection_violations":[{"id":16435444,"change_date":"2025-10-15 21:40:00","inspection_id":"86061697","insp_violation_id":"269327384","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209493517","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00QC007HB","created_at":"2025-10-18T10:18:15.000000Z","updated_at":"2025-10-19T10:17:18.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":16524489,"change_date":"2025-10-15 21:40:00","inspection_id":"86061697","insp_unit_id":"209493517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"65375U1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMSAARXBL394378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:19.000000Z","updated_at":"2025-10-19T09:46:40.000000Z"}]},{"id":9417791,"change_date":"2025-08-14 21:41:00","inspection_id":"85498102","dot_number":"1547096","report_state":"CA","report_number":"UG0M003992","insp_date":"2025-08-12 00:00:00","insp_start_time":"1625","insp_end_time":"1650","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"CAJON PLATFORM SCALES","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15938348","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2025-08-14 21:41:00","snet_input_date":"2025-08-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-14 21:41:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2025-08-17T10:01:25.000000Z","updated_at":"2025-08-20T10:44:25.000000Z","inspection_violations":[{"id":15320380,"change_date":"2025-08-14 21:41:00","inspection_id":"85498102","insp_violation_id":"268041024","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208408395","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:32.000000Z","updated_at":"2025-08-18T10:44:39.000000Z","normalized_code":"3922SLLEQP"},{"id":15320381,"change_date":"2025-08-14 21:41:00","inspection_id":"85498102","insp_violation_id":"268041025","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"208408395","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-17T10:45:32.000000Z","updated_at":"2025-08-18T10:44:39.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":15523723,"change_date":"2025-08-14 21:41:00","inspection_id":"85498102","insp_unit_id":"208408395","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"TRU12\/RED","insp_unit_license":"65375U1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMSAARXBL394378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:31.000000Z","updated_at":"2025-08-18T09:46:22.000000Z"}]},{"id":8717852,"change_date":"2025-05-22 21:43:00","inspection_id":"84759659","dot_number":"1547096","report_state":"CA","report_number":"UCSF001379","insp_date":"2025-05-20 00:00:00","insp_start_time":"0700","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"883","location_desc":"CAJON PLATFORM SCALES","county_code_state":"CA","county_code":"071","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":"2025-05-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15832074","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2025-05-22 21:43:00","snet_input_date":"2025-05-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-22 21:43:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-25T10:06:16.000000Z","updated_at":"2025-05-26T10:07:23.000000Z","inspection_violations":[{"id":13905856,"change_date":"2025-05-22 21:43:00","inspection_id":"84759659","insp_violation_id":"266431843","seq_no":"1","part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"1","insp_unit_id":"207027922","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-25T10:29:08.000000Z","updated_at":"2025-05-26T10:29:19.000000Z","normalized_code":"39375A3ATIS"},{"id":13905857,"change_date":"2025-05-22 21:43:00","inspection_id":"84759659","insp_violation_id":"266431844","seq_no":"2","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"207027922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-25T10:29:13.000000Z","updated_at":"2025-05-26T10:29:19.000000Z","normalized_code":"3963A1OAL"}],"inspection_per_units":[{"id":14249951,"change_date":"2025-05-22 21:43:00","inspection_id":"84759659","insp_unit_id":"207027922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17\/WHT","insp_unit_license":"75738N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHCYCYXFDGF4694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-25T09:51:10.000000Z","updated_at":"2025-05-26T09:52:44.000000Z"}]},{"id":7577245,"change_date":"2025-01-08 21:40:00","inspection_id":"83559873","dot_number":"1547096","report_state":"CA","report_number":"UEZF000248","insp_date":"2025-01-06 00:00:00","insp_start_time":"0722","insp_end_time":"0737","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"I-15 NB S OF SR-138","county_code_state":"CA","county_code":"071","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-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15652773","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2025-01-08 21:40:00","snet_input_date":"2025-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-08 21:40:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:19.000000Z","updated_at":"2025-03-17T20:55:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12225684,"change_date":"2025-01-08 21:40:00","inspection_id":"83559873","insp_unit_id":"204716646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"13\/ WHT","insp_unit_license":"28708V1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMSAZR7BJ398231","insp_unit_decal":"Y","insp_unit_decal_number":"34828920","created_at":"2025-03-17T23:49:58.000000Z","updated_at":"2025-03-17T23:49:58.000000Z"}]},{"id":4512502,"change_date":"2023-11-28 21:42:00","inspection_id":"80259556","dot_number":"1547096","report_state":"CA","report_number":"UBYI000535","insp_date":"2023-11-27 00:00:00","insp_start_time":"1636","insp_end_time":"1700","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO IF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BEST DRILLING AND PUMPING","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15146608","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-11-28 21:42:00","snet_input_date":"2023-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-28 21:42:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:13.000000Z","updated_at":"2025-03-17T19:52:13.000000Z","inspection_violations":[{"id":6982615,"change_date":"2023-11-28 21:42:00","inspection_id":"80259556","insp_violation_id":"256604838","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"},{"id":6982616,"change_date":"2023-11-28 21:42:00","inspection_id":"80259556","insp_violation_id":"256604839","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198252334","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3939A"},{"id":6982617,"change_date":"2023-11-28 21:42:00","inspection_id":"80259556","insp_violation_id":"256604840","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7257654,"change_date":"2023-11-28 21:42:00","inspection_id":"80259556","insp_unit_id":"198252334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TRU14","insp_unit_license":"12573G2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHCYBS2BDBA5967","insp_unit_decal":"Y","insp_unit_decal_number":"33266043","created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"}]},{"id":4367147,"change_date":"2023-11-06 21:42:00","inspection_id":"80099239","dot_number":"1547096","report_state":"CA","report_number":"NCVL005770","insp_date":"2023-11-02 00:00:00","insp_start_time":"1404","insp_end_time":"1427","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEST DRILLING AND PUMP INC","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-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"15123716","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[{"id":6757425,"change_date":"2023-11-06 21:42:00","inspection_id":"80099239","insp_violation_id":"256250910","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"197934022","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":7023897,"change_date":"2023-11-06 21:42:00","inspection_id":"80099239","insp_unit_id":"197934022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"PR9","insp_unit_license":"9F27182","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPCL70XXGD327351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:57.000000Z","updated_at":"2025-03-17T22:58:57.000000Z"}]},{"id":4118060,"change_date":"2023-10-03 21:41:00","inspection_id":"79824078","dot_number":"1547096","report_state":"CA","report_number":"NDOG004276","insp_date":"2023-10-02 00:00:00","insp_start_time":"1005","insp_end_time":"1033","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"PIT SCALES","county_code_state":"CA","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15083032","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2025-03-17T19:44:06.000000Z","updated_at":"2025-03-17T19:44:06.000000Z","inspection_violations":[{"id":6372523,"change_date":"2023-10-03 21:41:00","inspection_id":"79824078","insp_violation_id":"255637501","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3922"},{"id":6372524,"change_date":"2023-10-03 21:41:00","inspection_id":"79824078","insp_violation_id":"255637502","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197380701","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":6621222,"change_date":"2023-10-03 21:41:00","inspection_id":"79824078","insp_unit_id":"197380701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"75738N3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHCYCYXFDGF4694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:33.000000Z","updated_at":"2025-03-17T22:55:33.000000Z"}]},{"id":3251988,"change_date":"2023-06-09 21:41:00","inspection_id":"78854932","dot_number":"1547096","report_state":"CA","report_number":"NDOG003902","insp_date":"2023-06-06 00:00:00","insp_start_time":"1030","insp_end_time":"1050","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"PIT SCALES","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"14936173","transaction_code":"A","transaction_date":"2023-06-06 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-06-09 21:41:00","snet_input_date":"2023-06-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-09 21:41:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:21.000000Z","updated_at":"2025-03-17T19:27:21.000000Z","inspection_violations":[{"id":5015427,"change_date":"2023-06-09 21:41:00","inspection_id":"78854932","insp_violation_id":"253418542","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"195423878","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:19.000000Z","updated_at":"2025-03-17T21:30:19.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":5230354,"change_date":"2023-06-09 21:41:00","inspection_id":"78854932","insp_unit_id":"195423878","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00753P2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHCYFC7KDKG8516","insp_unit_decal":"Y","insp_unit_decal_number":"32545261","created_at":"2025-03-17T22:44:14.000000Z","updated_at":"2025-03-17T22:44:14.000000Z"}]},{"id":3127014,"change_date":"2023-07-10 21:43:00","inspection_id":"78713760","dot_number":"1547096","report_state":"CA","report_number":"UDB7007249","insp_date":"2023-05-23 00:00:00","insp_start_time":"0641","insp_end_time":"0652","registration_date":null,"region":"PT","ci_status_code":"C","location":"9525","location_desc":"GLENDORA","county_code_state":"CA","county_code":"037","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-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"14915303","transaction_code":"C","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:57.000000Z","updated_at":"2025-03-17T19:24:57.000000Z","inspection_violations":[{"id":4814265,"change_date":"2023-07-10 21:43:00","inspection_id":"78713760","insp_violation_id":"253972269","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6LV0045H","created_at":"2025-03-17T21:29:23.000000Z","updated_at":"2025-03-17T21:29:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5029680,"change_date":"2023-07-10 21:43:00","inspection_id":"78713760","insp_unit_id":"195920629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28254V1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPCL70X1GD327352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:38.000000Z","updated_at":"2025-03-17T22:42:38.000000Z"}]},{"id":2146421,"change_date":"2023-01-13 21:41:00","inspection_id":"77599468","dot_number":"1547096","report_state":"CA","report_number":"NCGL002245","insp_date":"2023-01-10 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"PERALTA SCALES W\/B","county_code_state":"CA","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14741187","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2023-01-13 21:41:00","snet_input_date":"2023-01-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-13 21:41:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3454195,"change_date":"2023-01-13 21:41:00","inspection_id":"77599468","insp_unit_id":"192879879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHTE-3X","insp_unit_license":"51820E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHCYFE0JDJK4388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"}]},{"id":1896481,"change_date":"2022-12-07 21:41:00","inspection_id":"77313370","dot_number":"1547096","report_state":"CA","report_number":"NCGL002139","insp_date":"2022-12-07 00:00:00","insp_start_time":"0630","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"PERALTA SCALES W\/B","county_code_state":"CA","county_code":"059","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"14700115","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2022-12-07 21:41:00","snet_input_date":"2022-12-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-07 21:41:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2951535,"change_date":"2022-12-07 21:41:00","inspection_id":"77313370","insp_violation_id":"249982063","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192316063","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JS57499","created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3052188,"change_date":"2022-12-07 21:41:00","inspection_id":"77313370","insp_unit_id":"192316063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHTE-3X","insp_unit_license":"51820E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHCYFE0JDJK4388","insp_unit_decal":"Y","insp_unit_decal_number":"31859433","created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":947968,"change_date":"2022-08-02 21:40:00","inspection_id":"76216837","dot_number":"1547096","report_state":"CA","report_number":"NC4I002859","insp_date":"2022-07-29 00:00:00","insp_start_time":"0727","insp_end_time":"0810","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"CAJON SCALES","county_code_state":"CA","county_code":"071","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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14531020","transaction_code":"A","transaction_date":"2022-07-29 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-07-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"389660","created_at":"2025-03-17T18:44:23.000000Z","updated_at":"2025-03-17T18:44:23.000000Z","inspection_violations":[{"id":1496391,"change_date":"2022-08-02 21:40:00","inspection_id":"76216837","insp_violation_id":"247473043","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190098486","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JW83924","created_at":"2025-03-17T21:14:05.000000Z","updated_at":"2025-03-17T21:14:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1526738,"change_date":"2022-08-02 21:40:00","inspection_id":"76216837","insp_unit_id":"190098486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"TRU13\/WHT","insp_unit_license":"28708V1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMSAZR7BJ398231","insp_unit_decal":"Y","insp_unit_decal_number":"31559238","created_at":"2025-03-17T22:17:37.000000Z","updated_at":"2025-03-17T22:17:37.000000Z"}]},{"id":372877,"change_date":"2022-05-11 21:40:00","inspection_id":"75537394","dot_number":"1547096","report_state":"CA","report_number":"NCOM002737","insp_date":"2022-05-10 00:00:00","insp_start_time":"0938","insp_end_time":"0954","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO IF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"14422646","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01547096","upload_search_indicator":null,"census_search_date":"2022-05-11 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"BEST DRILLING AND PUMP INC","insp_carrier_street":"1640 W PELLISIER RD","insp_carrier_city":"COLTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92324","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:01.000000Z","updated_at":"2025-03-17T18:34:01.000000Z","inspection_violations":[{"id":584995,"change_date":"2022-05-11 21:40:00","inspection_id":"75537394","insp_violation_id":"245739868","seq_no":"1","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"1","insp_unit_id":"188640114","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1","created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"39325E"},{"id":584996,"change_date":"2022-05-11 21:40:00","inspection_id":"75537394","insp_violation_id":"245739869","seq_no":"2","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"188640114","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"3967"}],"inspection_per_units":[{"id":603249,"change_date":"2022-05-11 21:40:00","inspection_id":"75537394","insp_unit_id":"188640114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"28254V1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPCL70X1GD327352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1547096\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1547096\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1547096\/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\/1547096\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}