{"current_page":1,"data":[{"id":12579976,"change_date":"2026-07-29 21:41:00","inspection_id":"88548479","dot_number":"1076550","report_state":"CA","report_number":"NDHX007168","insp_date":"2026-07-27 00:00:00","insp_start_time":"0911","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":"424","location_desc":"CA","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMER PIPE SUPPLY","shipping_paper_number":"S1734678.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3862401","transaction_code":"A","transaction_date":"2026-07-29 00:00:00","upload_date":"2026-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-07-29 21:41:00","snet_input_date":"2026-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-29 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0120592","created_at":"2026-08-01T09:41:34.000000Z","updated_at":"2026-08-09T09:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21842085,"change_date":"2026-07-29 21:41:00","inspection_id":"88548479","insp_unit_id":"214876477","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23101","insp_unit_license":"82350M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD23PDUA3515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-01T09:18:34.000000Z","updated_at":"2026-08-09T09:02:42.000000Z"}]},{"id":12242078,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","dot_number":"1076550","report_state":"CA","report_number":"NDOG007487","insp_date":"2026-06-19 00:00:00","insp_start_time":"0824","insp_end_time":"0858","registration_date":null,"region":"PS","ci_status_code":"C","location":"424","location_desc":"CA","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMERS PIPE","shipping_paper_number":"T1129092001","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-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3587051","transaction_code":"A","transaction_date":"2026-06-21 00:00:00","upload_date":"2026-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-06-21 21:33:00","snet_input_date":"2026-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-21 21:33:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-06-24T09:39:50.000000Z","updated_at":"2026-07-02T09:30:39.000000Z","inspection_violations":[{"id":21307945,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_violation_id":"275035357","seq_no":"1","part_no":"395","part_no_section":"8C-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-24T09:57:52.000000Z","updated_at":"2026-07-02T09:41:56.000000Z","normalized_code":"3958CHOSF"},{"id":21307946,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_violation_id":"275035358","seq_no":"2","part_no":"395","part_no_section":"8D3-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-24T09:57:52.000000Z","updated_at":"2026-07-02T09:41:56.000000Z","normalized_code":"3958D3HOSF"},{"id":21307947,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_violation_id":"275035359","seq_no":"3","part_no":"395","part_no_section":"8F11-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-24T09:57:52.000000Z","updated_at":"2026-07-02T09:41:56.000000Z","normalized_code":"3958F11HOSM"},{"id":21307948,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_violation_id":"275035360","seq_no":"4","part_no":"395","part_no_section":"8D11-HOSF","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-24T09:57:52.000000Z","updated_at":"2026-07-02T09:41:56.000000Z","normalized_code":"3958D11HOSF"},{"id":21307949,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_violation_id":"275035361","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214208025","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-24T09:57:52.000000Z","updated_at":"2026-07-02T09:41:56.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":21259754,"change_date":"2026-06-21 21:33:00","inspection_id":"88200054","insp_unit_id":"214208025","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21102","insp_unit_license":"88979Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD26MDMN4717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-24T09:16:59.000000Z","updated_at":"2026-07-02T09:00:46.000000Z"}]},{"id":12058625,"change_date":"2026-05-30 21:35:00","inspection_id":"88000143","dot_number":"1076550","report_state":"CA","report_number":"UEX8005435","insp_date":"2026-05-29 00:00:00","insp_start_time":"0955","insp_end_time":"1023","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-30 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3433991","transaction_code":"A","transaction_date":"2026-05-30 00:00:00","upload_date":"2026-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-05-30 21:35:00","snet_input_date":"2026-05-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-30 21:35:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-02T09:40:12.000000Z","updated_at":"2026-06-10T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20957502,"change_date":"2026-05-30 21:35:00","inspection_id":"88000143","insp_unit_id":"213834168","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"Y","insp_unit_decal_number":"36188119","created_at":"2026-06-02T09:17:18.000000Z","updated_at":"2026-06-10T09:01:43.000000Z"}]},{"id":12024929,"change_date":"2026-05-27 21:39:00","inspection_id":"87964715","dot_number":"1076550","report_state":"CA","report_number":"NCPN007992","insp_date":"2026-05-26 00:00:00","insp_start_time":"1507","insp_end_time":"1525","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3407677","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-05-27 21:39:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:39:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:27.000000Z","updated_at":"2026-06-07T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20901952,"change_date":"2026-05-27 21:39:00","inspection_id":"87964715","insp_unit_id":"213767084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21101","insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"Y","insp_unit_decal_number":"36239504","created_at":"2026-05-30T09:17:28.000000Z","updated_at":"2026-06-07T09:01:47.000000Z"}]},{"id":11867674,"change_date":"2026-05-10 21:34:00","inspection_id":"87804552","dot_number":"1076550","report_state":"CA","report_number":"NABR010140","insp_date":"2026-05-07 00:00:00","insp_start_time":"0638","insp_end_time":"0710","registration_date":null,"region":"PS","ci_status_code":"C","location":"541","location_desc":"CA","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-10 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3294432","transaction_code":"A","transaction_date":"2026-05-10 00:00:00","upload_date":"2026-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-05-10 21:34:00","snet_input_date":"2026-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-10 21:34:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-05-13T09:38:38.000000Z","updated_at":"2026-05-21T09:30:24.000000Z","inspection_violations":[{"id":20642254,"change_date":"2026-05-10 21:34:00","inspection_id":"87804552","insp_violation_id":"274156253","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"213467943","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-12T09:58:59.000000Z","updated_at":"2026-05-21T09:41:51.000000Z","normalized_code":"3922SLLSOA"},{"id":20642255,"change_date":"2026-05-10 21:34:00","inspection_id":"87804552","insp_violation_id":"274156254","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213467943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-12T09:58:59.000000Z","updated_at":"2026-05-21T09:41:51.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":20635911,"change_date":"2026-05-10 21:34:00","inspection_id":"87804552","insp_unit_id":"213467943","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T09:15:21.000000Z","updated_at":"2026-05-21T09:02:32.000000Z"}]},{"id":11723249,"change_date":"2026-04-22 21:39:00","inspection_id":"87650900","dot_number":"1076550","report_state":"CA","report_number":"NEBC003165","insp_date":"2026-04-22 00:00:00","insp_start_time":"0608","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16258344","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-04-27T09:39:57.000000Z","updated_at":"2026-05-03T09:31:21.000000Z","inspection_violations":[{"id":20381586,"change_date":"2026-04-22 21:39:00","inspection_id":"87650900","insp_violation_id":"273787035","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213166161","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:33.000000Z","updated_at":"2026-05-03T09:43:31.000000Z","normalized_code":"3922SLLEQP"},{"id":20381587,"change_date":"2026-04-22 21:39:00","inspection_id":"87650900","insp_violation_id":"273787036","seq_no":"2","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"213166161","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:33.000000Z","updated_at":"2026-05-03T09:43:31.000000Z","normalized_code":"39311A1LCL"},{"id":20381588,"change_date":"2026-04-22 21:39:00","inspection_id":"87650900","insp_violation_id":"273787037","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213166161","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:59:33.000000Z","updated_at":"2026-05-03T09:43:31.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":20399624,"change_date":"2026-04-22 21:39:00","inspection_id":"87650900","insp_unit_id":"213166161","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT#231125","insp_unit_license":"62856T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC4PDUP0828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:17:45.000000Z","updated_at":"2026-05-03T09:04:20.000000Z"}]},{"id":11747002,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","dot_number":"1076550","report_state":"CA","report_number":"NEVK002488","insp_date":"2026-04-21 00:00:00","insp_start_time":"1910","insp_end_time":"1930","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"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":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16262042","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-04-24 21:41:00","snet_input_date":"2026-04-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-04-27T09:42:40.000000Z","updated_at":"2026-05-05T09:32:02.000000Z","inspection_violations":[{"id":20424414,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","insp_violation_id":"273851842","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:29.000000Z","normalized_code":"3958A1HOSP"},{"id":20424415,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","insp_violation_id":"273851843","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213222846","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:29.000000Z","normalized_code":"3922SLLSR"},{"id":20424416,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","insp_violation_id":"273851844","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"213222846","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:29.000000Z","normalized_code":"3969D2FTF"},{"id":20424417,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","insp_violation_id":"273851845","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213222846","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:07:19.000000Z","updated_at":"2026-05-05T09:45:29.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":20438844,"change_date":"2026-04-24 21:41:00","inspection_id":"87676539","insp_unit_id":"213222846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE\/BOX","insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:45.000000Z","updated_at":"2026-05-05T09:05:08.000000Z"}]},{"id":11270114,"change_date":"2026-03-02 21:39:00","inspection_id":"87184347","dot_number":"1076550","report_state":"CA","report_number":"NBFL007186","insp_date":"2026-02-26 00:00:00","insp_start_time":"0910","insp_end_time":"0935","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":"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":"2026-03-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16189118","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-03-02 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-02 21:39:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-03-05T10:39:08.000000Z","updated_at":"2026-03-13T09:32:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19272913,"change_date":"2026-03-02 21:39:00","inspection_id":"87184347","insp_unit_id":"211928223","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21101","insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"Y","insp_unit_decal_number":"35896247","created_at":"2026-03-05T10:14:49.000000Z","updated_at":"2026-03-13T09:07:44.000000Z"}]},{"id":11243728,"change_date":"2026-02-26 21:42:00","inspection_id":"87156550","dot_number":"1076550","report_state":"CA","report_number":"NC4I005994","insp_date":"2026-02-24 00:00:00","insp_start_time":"0735","insp_end_time":"0806","registration_date":null,"region":"PT","ci_status_code":"C","location":"883","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":"CONSUMER PIPE","shipping_paper_number":"M0141511","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16186915","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-02-26 21:42:00","snet_input_date":"2026-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-26 21:42:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:39:09.000000Z","updated_at":"2026-03-09T09:32:31.000000Z","inspection_violations":[{"id":18884482,"change_date":"2026-02-26 21:42:00","inspection_id":"87156550","insp_violation_id":"272076737","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211867727","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:18.000000Z","updated_at":"2026-03-09T09:47:18.000000Z","normalized_code":"3922SLLSR"},{"id":18884483,"change_date":"2026-02-26 21:42:00","inspection_id":"87156550","insp_violation_id":"272076738","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211867727","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-01T10:57:18.000000Z","updated_at":"2026-03-09T09:47:18.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":19221109,"change_date":"2026-02-26 21:42:00","inspection_id":"87156550","insp_unit_id":"211867727","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"231126\/WHT","insp_unit_license":"62857T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC6PDUP0829","insp_unit_decal":"Y","insp_unit_decal_number":"35944911","created_at":"2026-03-01T10:15:51.000000Z","updated_at":"2026-03-09T09:10:38.000000Z"}]},{"id":11154726,"change_date":"2026-02-17 21:40:00","inspection_id":"87069497","dot_number":"1076550","report_state":"CA","report_number":"NBFL007143","insp_date":"2026-02-13 00:00:00","insp_start_time":"0930","insp_end_time":"1000","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":"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":"2026-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16173041","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-02-17 21:40:00","snet_input_date":"2026-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-17 21:40:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2026-02-20T10:37:56.000000Z","updated_at":"2026-02-28T10:31:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19030400,"change_date":"2026-02-17 21:40:00","inspection_id":"87069497","insp_unit_id":"211673194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21100","insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"Y","insp_unit_decal_number":"35896242","created_at":"2026-02-20T10:14:36.000000Z","updated_at":"2026-02-28T10:04:31.000000Z"}]},{"id":11122841,"change_date":"2026-02-12 21:41:00","inspection_id":"87035939","dot_number":"1076550","report_state":"CA","report_number":"UEH7007147","insp_date":"2026-02-12 00:00:00","insp_start_time":"1020","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"240","location_desc":"W CAPITOL AVE","county_code_state":"CA","county_code":"113","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"16170186","transaction_code":"A","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:52.000000Z","updated_at":"2026-02-23T10:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18970560,"change_date":"2026-02-12 21:41:00","inspection_id":"87035939","insp_unit_id":"211601823","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:13.000000Z","updated_at":"2026-02-23T10:04:00.000000Z"}]},{"id":10424397,"change_date":"2025-12-12 21:41:00","inspection_id":"86555747","dot_number":"1076550","report_state":"CA","report_number":"NDHX006847","insp_date":"2025-12-10 00:00:00","insp_start_time":"1001","insp_end_time":"1020","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":"2","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-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16092464","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0120592","created_at":"2025-12-15T10:32:14.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17436112,"change_date":"2025-12-12 21:41:00","inspection_id":"86555747","insp_unit_id":"210585935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21101","insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:48.000000Z","updated_at":"2025-12-23T10:01:21.000000Z"}]},{"id":10222421,"change_date":"2025-11-17 21:40:00","inspection_id":"86344234","dot_number":"1076550","report_state":"CA","report_number":"NDE9008277","insp_date":"2025-11-13 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"LEBEC","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMERS PIPE","shipping_paper_number":"S1706383.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16061187","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-11-20T10:30:41.000000Z","updated_at":"2025-11-21T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17030915,"change_date":"2025-11-17 21:40:00","inspection_id":"86344234","insp_unit_id":"210080613","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"231125","insp_unit_license":"62856T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC4PDUP0828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:42.000000Z","updated_at":"2025-11-21T10:01:36.000000Z"}]},{"id":9935515,"change_date":"2026-01-13 21:39:00","inspection_id":"86041656","dot_number":"1076550","report_state":"NV","report_number":"7078029200","insp_date":"2025-10-01 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"PT","ci_status_code":"C","location":"1008","location_desc":"SLOAN I-15 NB","county_code_state":"NV","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMERS PIPE & SUPPLY","shipping_paper_number":"M0138946","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-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"806162","transaction_code":"C","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-01 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:34.000000Z","updated_at":"2026-01-24T10:30:06.000000Z","inspection_violations":[{"id":17879282,"change_date":"2026-01-13 21:39:00","inspection_id":"86041656","insp_violation_id":"271168711","seq_no":"1","part_no":"395","part_no_section":"8F1-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:41.000000Z","updated_at":"2026-01-24T10:30:11.000000Z","normalized_code":"3958F1HOSM"},{"id":17879283,"change_date":"2026-01-13 21:39:00","inspection_id":"86041656","insp_violation_id":"271168712","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:41.000000Z","updated_at":"2026-01-24T10:30:11.000000Z","normalized_code":"39522H4ELDBRODS"}],"inspection_per_units":[{"id":17828008,"change_date":"2026-01-13 21:39:00","inspection_id":"86041656","insp_unit_id":"211053440","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23101","insp_unit_license":"82350M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD23PDUA3515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:31.000000Z","updated_at":"2026-01-24T10:01:32.000000Z"}]},{"id":9525684,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","dot_number":"1076550","report_state":"CA","report_number":"UE0V004488","insp_date":"2025-08-27 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"855","location_desc":"FONTANA","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-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15955800","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-08-27 21:41:00","snet_input_date":"2025-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-27 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:26.000000Z","updated_at":"2025-09-06T10:41:55.000000Z","inspection_violations":[{"id":15546693,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_violation_id":"268296510","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208620692","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:11.000000Z","normalized_code":"3922SLLSR"},{"id":15546694,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_violation_id":"268296511","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208620692","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:11.000000Z","normalized_code":"39347E"},{"id":15546695,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_violation_id":"268296512","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"208620692","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:11.000000Z","normalized_code":"39353BB"},{"id":15546696,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_violation_id":"268296513","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208620692","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:11.000000Z","normalized_code":"3963A1BOS"},{"id":15546697,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_violation_id":"268296514","seq_no":"5","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"1","insp_unit_id":"208620692","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:50:42.000000Z","updated_at":"2025-09-06T10:45:11.000000Z","normalized_code":"393100CC"}],"inspection_per_units":[{"id":15721020,"change_date":"2025-08-27 21:41:00","inspection_id":"85611606","insp_unit_id":"208620692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI","insp_unit_license":"82351M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24PDUA7508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:43.000000Z","updated_at":"2025-09-09T09:46:19.000000Z"}]},{"id":9513890,"change_date":"2025-08-26 21:41:00","inspection_id":"85599245","dot_number":"1076550","report_state":"CA","report_number":"NBFL006695","insp_date":"2025-08-22 00:00:00","insp_start_time":"0950","insp_end_time":"1010","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":"F","shipper_name":"CONSUMERS PIPE & SUPLLY CO.","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-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15953726","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-08-26 21:41:00","snet_input_date":"2025-08-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-26 21:41:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-08-29T10:43:09.000000Z","updated_at":"2025-09-05T10:46:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15699512,"change_date":"2025-08-26 21:41:00","inspection_id":"85599245","insp_unit_id":"208597532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21100","insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"Y","insp_unit_decal_number":"35346649","created_at":"2025-08-29T09:46:44.000000Z","updated_at":"2025-09-05T09:46:22.000000Z"}]},{"id":9356833,"change_date":"2025-08-07 21:40:00","inspection_id":"85434207","dot_number":"1076550","report_state":"CA","report_number":"NEC6000980","insp_date":"2025-07-25 00:00:00","insp_start_time":"1005","insp_end_time":"1016","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15928974","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-08-07 21:40:00","snet_input_date":"2025-07-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-07 21:40:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-08-12T10:44:01.000000Z","updated_at":"2025-08-12T10:44:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15414507,"change_date":"2025-08-07 21:40:00","inspection_id":"85434207","insp_unit_id":"208290960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/FLTBED","insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"Y","insp_unit_decal_number":"35367952","created_at":"2025-08-10T09:46:24.000000Z","updated_at":"2025-08-11T09:46:15.000000Z"}]},{"id":9252294,"change_date":"2025-07-25 21:40:00","inspection_id":"85324148","dot_number":"1076550","report_state":"CA","report_number":"UDMC003385","insp_date":"2025-07-24 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"852","location_desc":"VICTORVILLE AREA","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15913419","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:24.000000Z","updated_at":"2025-07-30T10:01:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15226792,"change_date":"2025-07-25 21:40:00","inspection_id":"85324148","insp_unit_id":"208088661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23101","insp_unit_license":"82350M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD23PDUA3515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:38.000000Z","updated_at":"2025-07-29T09:46:11.000000Z"}]},{"id":9177475,"change_date":"2025-07-17 21:42:00","inspection_id":"85245426","dot_number":"1076550","report_state":"NV","report_number":"7032028996","insp_date":"2025-07-15 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":null,"region":"PT","ci_status_code":"C","location":"1","location_desc":"IR15@SR146","county_code_state":"NV","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CONSUMERS PIPE","shipping_paper_number":"T1120690.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"798550","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"CONSUMERS PIPE AND SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:18.000000Z","updated_at":"2025-07-21T10:43:18.000000Z","inspection_violations":[{"id":14820804,"change_date":"2025-07-17 21:42:00","inspection_id":"85245426","insp_violation_id":"267474261","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:44.000000Z","updated_at":"2025-07-21T10:45:44.000000Z","normalized_code":"3922SLLTCD"},{"id":14820805,"change_date":"2025-07-17 21:42:00","inspection_id":"85245426","insp_violation_id":"267474262","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:44.000000Z","updated_at":"2025-07-21T10:45:44.000000Z","normalized_code":"39141AMCPC"},{"id":14820806,"change_date":"2025-07-17 21:42:00","inspection_id":"85245426","insp_violation_id":"267474263","seq_no":"3","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"207930823","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-21T10:45:44.000000Z","updated_at":"2025-07-21T10:45:44.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":15081259,"change_date":"2025-07-17 21:42:00","inspection_id":"85245426","insp_unit_id":"207930823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21102","insp_unit_license":"88979Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD26MDMN4717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:31.000000Z","updated_at":"2025-07-21T09:46:05.000000Z"}]},{"id":8526798,"change_date":"2025-05-01 21:41:00","inspection_id":"84558489","dot_number":"1076550","report_state":"CA","report_number":"UD6P001307","insp_date":"2025-04-28 00:00:00","insp_start_time":"0848","insp_end_time":"0903","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"US-101 N\/B AT SAN MARTIN AVE","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CONSUMERS PIPE","shipping_paper_number":"S1687642.005","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-05-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15803123","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-05-01 21:41:00","snet_input_date":"2025-04-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-01 21:41:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:35:15.000000Z","updated_at":"2025-05-05T10:14:47.000000Z","inspection_violations":[{"id":13502387,"change_date":"2025-05-01 21:41:00","inspection_id":"84558489","insp_violation_id":"265961530","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-05-03T11:28:33.000000Z","updated_at":"2025-05-04T11:01:27.000000Z","normalized_code":"3922SLLTCD"},{"id":13502388,"change_date":"2025-05-01 21:41:00","inspection_id":"84558489","insp_violation_id":"265961531","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-03T11:28:33.000000Z","updated_at":"2025-05-04T11:01:27.000000Z","normalized_code":"3958A1HOSP"},{"id":13502389,"change_date":"2025-05-01 21:41:00","inspection_id":"84558489","insp_violation_id":"265961532","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206603096","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-03T11:28:33.000000Z","updated_at":"2025-05-04T11:01:27.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":13863315,"change_date":"2025-05-01 21:41:00","inspection_id":"84558489","insp_unit_id":"206603096","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21100\/BLU","insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:24:31.000000Z","updated_at":"2025-05-05T10:03:03.000000Z"}]},{"id":8110947,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","dot_number":"1076550","report_state":"NV","report_number":"7036028644","insp_date":"2025-03-13 00:00:00","insp_start_time":"1143","insp_end_time":"1217","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"GARSON CHECKSITE","county_code_state":"NV","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"S1681065.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"789113","transaction_code":"C","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":"M","census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"4NVS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335-2908","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:52.000000Z","updated_at":"2025-03-22T10:32:06.000000Z","inspection_violations":[{"id":12744081,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_violation_id":"265108831","seq_no":"1","part_no":"391","part_no_section":"11B1-A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:56:32.000000Z","updated_at":"2025-03-21T11:09:20.000000Z","normalized_code":"39111B1A"},{"id":12744082,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_violation_id":"265108832","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:56:32.000000Z","updated_at":"2025-03-21T11:09:20.000000Z","normalized_code":"39141AMCPC"},{"id":12744083,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_violation_id":"265108833","seq_no":"3","part_no":"392","part_no_section":"2SLSCR","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-21T10:56:32.000000Z","updated_at":"2025-03-21T11:09:20.000000Z","normalized_code":"3922SLSCR"},{"id":12744084,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_violation_id":"265108834","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"205862522","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:56:32.000000Z","updated_at":"2025-03-21T11:09:20.000000Z","normalized_code":"3922SLLIRP"},{"id":12744085,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_violation_id":"265108835","seq_no":"5","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"1","insp_unit_id":"205862522","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:56:32.000000Z","updated_at":"2025-03-21T11:09:20.000000Z","normalized_code":"393104F3C"}],"inspection_per_units":[{"id":13152809,"change_date":"2025-03-18 21:40:00","inspection_id":"84120486","insp_unit_id":"205862522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:04:02.000000Z","updated_at":"2025-03-22T09:54:58.000000Z"}]},{"id":7997934,"change_date":"2025-02-28 21:42:00","inspection_id":"84001501","dot_number":"1076550","report_state":"CA","report_number":"NECL002896","insp_date":"2025-02-28 00:00:00","insp_start_time":"0748","insp_end_time":"0807","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMERS PIPE","shipping_paper_number":"S1681992.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15722078","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-02-28 21:42:00","snet_input_date":"2025-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-28 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T21:04:07.000000Z","updated_at":"2025-03-17T21:04:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12911675,"change_date":"2025-02-28 21:42:00","inspection_id":"84001501","insp_unit_id":"205572081","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2 X WHT","insp_unit_license":"62856T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC4PDUP0828","insp_unit_decal":"Y","insp_unit_decal_number":"34790404","created_at":"2025-03-17T23:57:37.000000Z","updated_at":"2025-03-17T23:57:37.000000Z"}]},{"id":7984416,"change_date":"2025-02-27 21:42:00","inspection_id":"83987353","dot_number":"1076550","report_state":"CA","report_number":"UCSM003698","insp_date":"2025-02-27 00:00:00","insp_start_time":"0955","insp_end_time":"1019","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"KEARNY VILLA RD W\/OF RUFFIN RD","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"15721004","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[{"id":12476641,"change_date":"2025-02-27 21:42:00","inspection_id":"83987353","insp_violation_id":"264748679","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205546258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"39021TB2DOT"},{"id":12476642,"change_date":"2025-02-27 21:42:00","inspection_id":"83987353","insp_violation_id":"264748680","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205546258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN17067","created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLSR"},{"id":12476643,"change_date":"2025-02-27 21:42:00","inspection_id":"83987353","insp_violation_id":"264748681","seq_no":"3","part_no":"390","part_no_section":"3E3-MC","insp_viol_unit":"1","insp_unit_id":"205546258","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3903E3MC"}],"inspection_per_units":[{"id":12889727,"change_date":"2025-02-27 21:42:00","inspection_id":"83987353","insp_unit_id":"205546258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2AX FB","insp_unit_license":"31431X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GT3PDA18322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"}]},{"id":7972127,"change_date":"2025-02-26 21:42:00","inspection_id":"83974473","dot_number":"1076550","report_state":"CA","report_number":"NEBC002172","insp_date":"2025-02-26 00:00:00","insp_start_time":"0724","insp_end_time":"0803","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSUMERS PIPE & SUPPLY CO","shipping_paper_number":"S1681633.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15719107","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12457242,"change_date":"2025-02-26 21:42:00","inspection_id":"83974473","insp_violation_id":"264723230","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"205522064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39345DB"},{"id":12457243,"change_date":"2025-02-26 21:42:00","inspection_id":"83974473","insp_violation_id":"264723231","seq_no":"2","part_no":"392","part_no_section":"2SLLHOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"3922SLLHOS"}],"inspection_per_units":[{"id":12869912,"change_date":"2025-02-26 21:42:00","inspection_id":"83974473","insp_unit_id":"205522064","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT#20501","insp_unit_license":"82350M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD23PDUA3515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7777180,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","dot_number":"1076550","report_state":"CA","report_number":"UCRF004413","insp_date":"2025-02-03 00:00:00","insp_start_time":"1122","insp_end_time":"1149","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SAN DIEGO","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15690331","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-02-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:59:34.000000Z","updated_at":"2025-03-17T20:59:34.000000Z","inspection_violations":[{"id":12152777,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","insp_violation_id":"264317935","seq_no":"1","part_no":"393","part_no_section":"106D-C","insp_viol_unit":"1","insp_unit_id":"205139453","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"393106DC"},{"id":12152778,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","insp_violation_id":"264317936","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205139453","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39395F"},{"id":12152779,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","insp_violation_id":"264317937","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205139453","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN16764","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLSR"},{"id":12152780,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","insp_violation_id":"264317938","seq_no":"4","part_no":"392","part_no_section":"9BA-NOREGINTRA","insp_viol_unit":"1","insp_unit_id":"205139453","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3929BANOREGINTRA"}],"inspection_per_units":[{"id":12551456,"change_date":"2025-02-03 21:40:00","inspection_id":"83769929","insp_unit_id":"205139453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2AX FB","insp_unit_license":"31431X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GT3PDA18322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7777760,"change_date":"2025-02-03 21:40:00","inspection_id":"83770539","dot_number":"1076550","report_state":"CA","report_number":"UFU1000873","insp_date":"2025-01-30 00:00:00","insp_start_time":"1022","insp_end_time":"1042","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-02-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15689147","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-02-03 21:40:00","snet_input_date":"2025-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-03 21:40:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:59:35.000000Z","updated_at":"2025-03-17T20:59:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12552294,"change_date":"2025-02-03 21:40:00","inspection_id":"83770539","insp_unit_id":"205140374","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21102 BLU","insp_unit_license":"88979Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD26MDMN4717","insp_unit_decal":"Y","insp_unit_decal_number":"34814323","created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7678973,"change_date":"2025-01-21 21:40:00","inspection_id":"83666697","dot_number":"1076550","report_state":"CA","report_number":"UFU1000830","insp_date":"2025-01-16 00:00:00","insp_start_time":"1152","insp_end_time":"1321","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15669895","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:57:30.000000Z","updated_at":"2025-03-17T20:57:30.000000Z","inspection_violations":[{"id":11999024,"change_date":"2025-01-21 21:40:00","inspection_id":"83666697","insp_violation_id":"264114548","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"204947594","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39345B2BAIR"},{"id":11999025,"change_date":"2025-01-21 21:40:00","inspection_id":"83666697","insp_violation_id":"264114549","seq_no":"2","part_no":"393","part_no_section":"110C-C","insp_viol_unit":"1","insp_unit_id":"204947594","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA542903","created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"393110CC"}],"inspection_per_units":[{"id":12391055,"change_date":"2025-01-21 21:40:00","inspection_id":"83666697","insp_unit_id":"204947594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21102 2XBLU","insp_unit_license":"88979Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD26MDMN4717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:45.000000Z","updated_at":"2025-03-17T23:51:45.000000Z"}]},{"id":7397788,"change_date":"2024-12-11 21:42:00","inspection_id":"83371351","dot_number":"1076550","report_state":"CA","report_number":"UDTG004008","insp_date":"2024-12-10 00:00:00","insp_start_time":"1310","insp_end_time":"1317","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12900","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":"15624906","transaction_code":"A","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-12-11 21:42:00","snet_input_date":"2024-12-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-11 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:50:21.000000Z","updated_at":"2025-03-17T20:50:21.000000Z","inspection_violations":[{"id":11560213,"change_date":"2024-12-11 21:42:00","inspection_id":"83371351","insp_violation_id":"263406698","seq_no":"1","part_no":"392","part_no_section":"9BA-NOREGINTRA","insp_viol_unit":"1","insp_unit_id":"204334108","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN97666","created_at":"2025-03-17T22:02:19.000000Z","updated_at":"2025-03-17T22:02:19.000000Z","normalized_code":"3929BANOREGINTRA"}],"inspection_per_units":[{"id":11933989,"change_date":"2024-12-11 21:42:00","inspection_id":"83371351","insp_unit_id":"204334108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"31431X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF4GT3PDA18322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:45.000000Z","updated_at":"2025-03-17T23:46:45.000000Z"}]},{"id":6291400,"change_date":"2024-07-23 21:43:00","inspection_id":"82195631","dot_number":"1076550","report_state":"CA","report_number":"UFEP004104","insp_date":"2024-07-22 00:00:00","insp_start_time":"1355","insp_end_time":"1431","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"I-80 AT DRY CREEK","county_code_state":"CA","county_code":"061","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-07-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15453797","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-07-23 21:43:00","snet_input_date":"2024-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-23 21:43:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:24.000000Z","updated_at":"2025-03-17T20:27:24.000000Z","inspection_violations":[{"id":9771773,"change_date":"2024-07-23 21:43:00","inspection_id":"82195631","insp_violation_id":"260804546","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"3922"},{"id":9771774,"change_date":"2024-07-23 21:43:00","inspection_id":"82195631","insp_violation_id":"260804547","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202033748","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"3922"},{"id":9771775,"change_date":"2024-07-23 21:43:00","inspection_id":"82195631","insp_violation_id":"260804548","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202033748","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"281","created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10137365,"change_date":"2024-07-23 21:43:00","inspection_id":"82195631","insp_unit_id":"202033748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:01.000000Z","updated_at":"2025-03-17T23:28:01.000000Z"}]},{"id":6040974,"change_date":"2024-06-20 21:44:00","inspection_id":"81926701","dot_number":"1076550","report_state":"CA","report_number":"NARW002447","insp_date":"2024-06-18 00:00:00","insp_start_time":"1039","insp_end_time":"1053","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15413606","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-06-20 21:44:00","snet_input_date":"2024-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-20 21:44:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:22:34.000000Z","updated_at":"2025-03-17T20:22:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9729739,"change_date":"2024-06-20 21:44:00","inspection_id":"81926701","insp_unit_id":"201514766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/2X","insp_unit_license":"07943V3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W163P7014448","insp_unit_decal":"Y","insp_unit_decal_number":"33878287","created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":5746607,"change_date":"2024-05-14 21:42:00","inspection_id":"81607447","dot_number":"1076550","report_state":"CA","report_number":"NBEV005456","insp_date":"2024-05-08 00:00:00","insp_start_time":"0526","insp_end_time":"0545","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15360754","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-05-14 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-14 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:40.000000Z","updated_at":"2025-03-17T20:16:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9255936,"change_date":"2024-05-14 21:42:00","inspection_id":"81607447","insp_unit_id":"200888909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"112725","insp_unit_license":"62856T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFCRPDUP0828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:09.000000Z","updated_at":"2025-03-17T23:19:09.000000Z"}]},{"id":5465296,"change_date":"2024-04-08 21:45:00","inspection_id":"81300755","dot_number":"1076550","report_state":"CA","report_number":"UFV3003517","insp_date":"2024-04-04 00:00:00","insp_start_time":"0805","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"883","location_desc":"CAJON 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":"2024-04-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15310369","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-04-08 21:45:00","snet_input_date":"2024-04-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:45:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[{"id":8437851,"change_date":"2024-04-08 21:45:00","inspection_id":"81300755","insp_violation_id":"258815754","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"200298953","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"393110B"},{"id":8437852,"change_date":"2024-04-08 21:45:00","inspection_id":"81300755","insp_violation_id":"258815755","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200298953","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:46:49.000000Z","updated_at":"2025-03-17T21:46:49.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8803253,"change_date":"2024-04-08 21:45:00","inspection_id":"81300755","insp_unit_id":"200298952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15367\/WHT","insp_unit_license":"AM23563","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3AKJGEBG3FDGN2341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"},{"id":8803254,"change_date":"2024-04-08 21:45:00","inspection_id":"81300755","insp_unit_id":"200298953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"C048\/ALUM","insp_unit_license":"4SY1925","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3F482C7LT410003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:52.000000Z","updated_at":"2025-03-17T23:14:52.000000Z"}]},{"id":5440505,"change_date":"2024-04-04 21:43:00","inspection_id":"81273818","dot_number":"1076550","report_state":"CA","report_number":"UCUI007195","insp_date":"2024-04-02 00:00:00","insp_start_time":"0750","insp_end_time":"0836","registration_date":null,"region":"PT","ci_status_code":"C","location":"550","location_desc":"SANTA FE SPRINGS AREA","county_code_state":"CA","county_code":"037","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":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15302452","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T20:10:38.000000Z","updated_at":"2025-03-17T20:10:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8763608,"change_date":"2024-04-04 21:43:00","inspection_id":"81273818","insp_unit_id":"200248464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:30.000000Z","updated_at":"2025-03-17T23:14:30.000000Z"}]},{"id":5298582,"change_date":"2024-03-15 21:41:00","inspection_id":"81119117","dot_number":"1076550","report_state":"CA","report_number":"NCSV005628","insp_date":"2024-03-13 00:00:00","insp_start_time":"1624","insp_end_time":"1641","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15282392","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2024-03-15 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-15 21:41:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:32.000000Z","updated_at":"2025-03-17T20:07:32.000000Z","inspection_violations":[{"id":8172330,"change_date":"2024-03-15 21:41:00","inspection_id":"81119117","insp_violation_id":"258416497","seq_no":"1","part_no":"393","part_no_section":"86(a)(5)","insp_viol_unit":"1","insp_unit_id":"199941924","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA542170","created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39386A5"}],"inspection_per_units":[{"id":8532975,"change_date":"2024-03-15 21:41:00","inspection_id":"81119117","insp_unit_id":"199941924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT231126","insp_unit_license":"62857T3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWFC6PDUP0829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:20.000000Z","updated_at":"2025-03-17T23:12:20.000000Z"}]},{"id":4436774,"change_date":"2023-11-15 21:42:00","inspection_id":"80176380","dot_number":"1076550","report_state":"CA","report_number":"UDA9003463","insp_date":"2023-11-15 00:00:00","insp_start_time":"0614","insp_end_time":"0626","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC CVEF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15135428","transaction_code":"A","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2023-11-15 21:42:00","snet_input_date":"2023-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-15 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7135029,"change_date":"2023-11-15 21:42:00","inspection_id":"80176380","insp_unit_id":"198084731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X BLU","insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"}]},{"id":3060470,"change_date":"2023-05-16 21:43:00","inspection_id":"78638853","dot_number":"1076550","report_state":"CA","report_number":"UDQU000798","insp_date":"2023-05-16 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"9685","location_desc":"DIAZ N\/ OF RANCHO CAL","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14904249","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":"01076550","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":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"120592","created_at":"2025-03-17T19:23:43.000000Z","updated_at":"2025-03-17T19:23:43.000000Z","inspection_violations":[{"id":4701498,"change_date":"2023-05-16 21:43:00","inspection_id":"78638853","insp_violation_id":"252871424","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194967039","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HH60835","created_at":"2025-03-17T21:28:56.000000Z","updated_at":"2025-03-17T21:28:56.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4923815,"change_date":"2023-05-16 21:43:00","inspection_id":"78638853","insp_unit_id":"194967039","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","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":3038144,"change_date":"2023-05-12 21:43:00","inspection_id":"78613888","dot_number":"1076550","report_state":"CA","report_number":"UEA9000023","insp_date":"2023-05-12 00:00:00","insp_start_time":"1040","insp_end_time":"1057","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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-05-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14898686","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2023-05-12 21:43:00","snet_input_date":"2023-05-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-12 21:43:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:03.000000Z","updated_at":"2025-03-17T19:23:03.000000Z","inspection_violations":[{"id":4667038,"change_date":"2023-05-12 21:43:00","inspection_id":"78613888","insp_violation_id":"252814186","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:28:45.000000Z","updated_at":"2025-03-17T21:28:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4887696,"change_date":"2023-05-12 21:43:00","inspection_id":"78613888","insp_unit_id":"194915232","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2X WHT","insp_unit_license":"82350M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD23PDUA3515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:31.000000Z","updated_at":"2025-03-17T22:41:31.000000Z"}]},{"id":2487476,"change_date":"2023-03-01 21:42:00","inspection_id":"77988523","dot_number":"1076550","report_state":"CA","report_number":"UFEK002623","insp_date":"2023-03-01 00:00:00","insp_start_time":"0620","insp_end_time":"0635","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14803374","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-03-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:31.000000Z","updated_at":"2025-03-17T19:12:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4002911,"change_date":"2023-03-01 21:42:00","inspection_id":"77988523","insp_unit_id":"193664159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"60225X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDTXGDHM4118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:40.000000Z","updated_at":"2025-03-17T22:34:40.000000Z"}]},{"id":2259962,"change_date":"2023-01-30 21:44:00","inspection_id":"77729416","dot_number":"1076550","report_state":"CA","report_number":"NBGO004528","insp_date":"2023-01-26 00:00:00","insp_start_time":"0756","insp_end_time":"0809","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14761980","transaction_code":"A","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:11.000000Z","updated_at":"2025-03-17T19:08:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3637959,"change_date":"2023-01-30 21:44:00","inspection_id":"77729416","insp_unit_id":"193139954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21102\/BLUE","insp_unit_license":"88979Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD26MDMN4717","insp_unit_decal":"Y","insp_unit_decal_number":"32208785","created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"}]},{"id":2008041,"change_date":"2022-12-22 21:40:00","inspection_id":"77441262","dot_number":"1076550","report_state":"CA","report_number":"NAAN003852","insp_date":"2022-12-20 00:00:00","insp_start_time":"2100","insp_end_time":"2122","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14718327","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2022-12-22 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-22 21:40:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"120592","created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[{"id":3117506,"change_date":"2022-12-22 21:40:00","inspection_id":"77441262","insp_violation_id":"250251629","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192565489","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:46.000000Z","updated_at":"2025-03-17T21:21:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3230545,"change_date":"2022-12-22 21:40:00","inspection_id":"77441262","insp_unit_id":"192565489","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2100 BLU","insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"Y","insp_unit_decal_number":"31869071","created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":2008066,"change_date":"2022-12-22 21:40:00","inspection_id":"77441287","dot_number":"1076550","report_state":"CA","report_number":"NCSV004075","insp_date":"2022-12-20 00:00:00","insp_start_time":"1640","insp_end_time":"1706","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-12-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14717835","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2022-12-22 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-22 21:40:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0120592","created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[{"id":3117524,"change_date":"2022-12-22 21:40:00","inspection_id":"77441287","insp_violation_id":"250251647","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"192565527","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA131188","created_at":"2025-03-17T21:21:46.000000Z","updated_at":"2025-03-17T21:21:46.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":3230583,"change_date":"2022-12-22 21:40:00","inspection_id":"77441287","insp_unit_id":"192565527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLU21100","insp_unit_license":"88981Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD22MDMN4715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":1977326,"change_date":"2022-12-19 21:41:00","inspection_id":"77406283","dot_number":"1076550","report_state":"CA","report_number":"NAAN003841","insp_date":"2022-12-16 00:00:00","insp_start_time":"1632","insp_end_time":"1645","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14713975","transaction_code":"A","transaction_date":"2022-12-16 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2022-12-19 21:41:00","snet_input_date":"2022-12-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-19 21:41:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"120592","created_at":"2025-03-17T19:02:59.000000Z","updated_at":"2025-03-17T19:02:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3181756,"change_date":"2022-12-19 21:41:00","inspection_id":"77406283","insp_unit_id":"192495266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21101 BLU","insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"Y","insp_unit_decal_number":"31869056","created_at":"2025-03-17T22:28:48.000000Z","updated_at":"2025-03-17T22:28:48.000000Z"}]},{"id":1071399,"change_date":"2022-08-17 21:41:00","inspection_id":"76360755","dot_number":"1076550","report_state":"CA","report_number":"UCUI004698","insp_date":"2022-08-17 00:00:00","insp_start_time":"1100","insp_end_time":"1158","registration_date":null,"region":"PT","ci_status_code":"C","location":"550","location_desc":"SANTA FE SPRINGS AREA","county_code_state":"CA","county_code":"037","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":"2022-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14553621","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T18:46:32.000000Z","updated_at":"2025-03-17T18:46:32.000000Z","inspection_violations":[{"id":1689058,"change_date":"2022-08-17 21:41:00","inspection_id":"76360755","insp_violation_id":"247808792","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190389804","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LM70878","created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1723944,"change_date":"2022-08-17 21:41:00","inspection_id":"76360755","insp_unit_id":"190389804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"88980Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWD24MDMN4716","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:52.000000Z","updated_at":"2025-03-17T22:18:52.000000Z"}]},{"id":1069476,"change_date":"2022-08-17 21:41:00","inspection_id":"76358598","dot_number":"1076550","report_state":"CA","report_number":"NEBC000482","insp_date":"2022-08-15 00:00:00","insp_start_time":"0620","insp_end_time":"0651","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","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-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14550066","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01076550","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"CONSUMERS PIPE & SUPPLY CO","insp_carrier_street":"13424 ARROW BLVD","insp_carrier_city":"FONTANA","insp_carrier_state":"CA","insp_carrier_zip_code":"92335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"120592","created_at":"2025-03-17T18:46:32.000000Z","updated_at":"2025-03-17T18:46:32.000000Z","inspection_violations":[{"id":1686957,"change_date":"2022-08-17 21:41:00","inspection_id":"76358598","insp_violation_id":"247806140","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3922"},{"id":1686958,"change_date":"2022-08-17 21:41:00","inspection_id":"76358598","insp_violation_id":"247806141","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"190386281","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"39360C"},{"id":1686959,"change_date":"2022-08-17 21:41:00","inspection_id":"76358598","insp_violation_id":"247806142","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190386281","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1720964,"change_date":"2022-08-17 21:41:00","inspection_id":"76358598","insp_unit_id":"190386281","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHT#16113","insp_unit_license":"60225X1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALACWDTXGDHM4118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:51.000000Z","updated_at":"2025-03-17T22:18:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1076550\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1076550\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1076550\/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\/1076550\/inspections","per_page":100,"prev_page_url":null,"to":44,"total":44}