{"current_page":1,"data":[{"id":9059571,"change_date":"2025-07-03 21:34:00","inspection_id":"85121218","dot_number":"2674836","report_state":"CA","report_number":"UDLV004348","insp_date":"2025-07-02 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CREEK SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"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-07-03 21:34: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":"15884133","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2025-07-03 21:34:00","snet_input_date":"2025-07-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-03 21:34:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-07-07T10:07:37.000000Z","updated_at":"2025-07-07T10:07:37.000000Z","inspection_violations":[{"id":14580274,"change_date":"2025-07-03 21:34:00","inspection_id":"85121218","insp_violation_id":"267198317","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"207695720","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:59.000000Z","updated_at":"2025-07-07T10:15:51.000000Z","normalized_code":"3922SLLMF"},{"id":14580275,"change_date":"2025-07-03 21:34:00","inspection_id":"85121218","insp_violation_id":"267198318","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207695720","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:59.000000Z","updated_at":"2025-07-07T10:15:51.000000Z","normalized_code":"3939ALIL"},{"id":14580276,"change_date":"2025-07-03 21:34:00","inspection_id":"85121218","insp_violation_id":"267198319","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"207695720","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-06T10:16:59.000000Z","updated_at":"2025-07-07T10:15:51.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":14864580,"change_date":"2025-07-03 21:34:00","inspection_id":"85121218","insp_unit_id":"207695720","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"64","insp_unit_license":"88502A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWF6DC0MDF01951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-06T09:46:20.000000Z","updated_at":"2025-07-07T09:45:35.000000Z"}]},{"id":7924304,"change_date":"2025-02-20 21:41:00","inspection_id":"83924305","dot_number":"2674836","report_state":"CA","report_number":"UF4O000357","insp_date":"2025-02-18 00:00:00","insp_start_time":"0845","insp_end_time":"0858","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":"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":"2025-02-20 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":"15710724","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2025-02-20 21:41:00","snet_input_date":"2025-02-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-20 21:41:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:48.000000Z","updated_at":"2025-03-17T21:02:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12791721,"change_date":"2025-02-20 21:41:00","inspection_id":"83924305","insp_unit_id":"205429685","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"88502A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWF6DC0MDF01951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:19.000000Z","updated_at":"2025-03-17T23:56:19.000000Z"}]},{"id":7609044,"change_date":"2025-01-13 21:46:00","inspection_id":"83593386","dot_number":"2674836","report_state":"CA","report_number":"NCCL006458","insp_date":"2025-01-11 00:00:00","insp_start_time":"0500","insp_end_time":"0545","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-13 21:46: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":"15658262","transaction_code":"A","transaction_date":"2025-01-11 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:56:08.000000Z","updated_at":"2025-03-17T20:56:08.000000Z","inspection_violations":[{"id":11896039,"change_date":"2025-01-13 21:46:00","inspection_id":"83593386","insp_violation_id":"263918517","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204787891","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ00549","created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922SLLSR"},{"id":11896040,"change_date":"2025-01-13 21:46:00","inspection_id":"83593386","insp_violation_id":"263918518","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204787891","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12277786,"change_date":"2025-01-13 21:46:00","inspection_id":"83593386","insp_unit_id":"204787891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"64 WHT 2X","insp_unit_license":"88502A3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDWF6DC0MDF01951","insp_unit_decal":"Y","insp_unit_decal_number":"34768834","created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"}]},{"id":7118060,"change_date":"2024-11-04 21:41:00","inspection_id":"83076122","dot_number":"2674836","report_state":"CA","report_number":"NA5N007665","insp_date":"2024-10-31 00:00:00","insp_start_time":"0847","insp_end_time":"0918","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B HWY 580, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-04 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":"15579965","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:19.000000Z","updated_at":"2025-03-17T20:44:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11480732,"change_date":"2024-11-04 21:41:00","inspection_id":"83076122","insp_unit_id":"203731023","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:57.000000Z","updated_at":"2025-03-17T23:41:57.000000Z"}]},{"id":7098270,"change_date":"2024-10-31 21:43:00","inspection_id":"83055009","dot_number":"2674836","report_state":"CA","report_number":"UD5V000165","insp_date":"2024-10-18 00:00:00","insp_start_time":"1655","insp_end_time":"1709","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE SCALE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15579471","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:43:55.000000Z","updated_at":"2025-03-17T20:43:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11448125,"change_date":"2024-10-31 21:43:00","inspection_id":"83055009","insp_unit_id":"203690402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2X WHT","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:33.000000Z","updated_at":"2025-03-17T23:41:33.000000Z"}]},{"id":6885076,"change_date":"2024-10-03 21:43:00","inspection_id":"82828570","dot_number":"2674836","report_state":"CA","report_number":"NC7K009238","insp_date":"2024-10-02 00:00:00","insp_start_time":"1044","insp_end_time":"1110","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15543380","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-10-03 21:43:00","snet_input_date":"2024-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-03 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:47.000000Z","updated_at":"2025-03-17T20:39:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11103980,"change_date":"2024-10-03 21:43:00","inspection_id":"82828570","insp_unit_id":"203261622","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"50\/WHT 2X","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:58.000000Z","updated_at":"2025-03-17T23:37:58.000000Z"}]},{"id":6885606,"change_date":"2024-10-03 21:43:00","inspection_id":"82829114","dot_number":"2674836","report_state":"CA","report_number":"NC7K009230","insp_date":"2024-10-01 00:00:00","insp_start_time":"0851","insp_end_time":"0911","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15543641","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-10-03 21:43:00","snet_input_date":"2024-10-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-03 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:47.000000Z","updated_at":"2025-03-17T20:39:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11104778,"change_date":"2024-10-03 21:43:00","inspection_id":"82829114","insp_unit_id":"203262473","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:58.000000Z","updated_at":"2025-03-17T23:37:58.000000Z"}]},{"id":6886689,"change_date":"2024-10-03 21:43:00","inspection_id":"82830246","dot_number":"2674836","report_state":"CA","report_number":"UCUF003837","insp_date":"2024-10-01 00:00:00","insp_start_time":"1535","insp_end_time":"1600","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B LIVERMORE SCALES","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15543671","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-10-03 21:43:00","snet_input_date":"2024-10-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-03 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:39:48.000000Z","updated_at":"2025-03-17T20:39:48.000000Z","inspection_violations":[{"id":10727855,"change_date":"2024-10-03 21:43:00","inspection_id":"82830246","insp_violation_id":"262181506","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203264343","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA 514290","created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11106502,"change_date":"2024-10-03 21:43:00","inspection_id":"82830246","insp_unit_id":"203264343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHI.2X.TRK","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:01.000000Z","updated_at":"2025-03-17T23:38:01.000000Z"}]},{"id":6820881,"change_date":"2024-09-25 21:42:00","inspection_id":"82760528","dot_number":"2674836","report_state":"CA","report_number":"UDBL003707","insp_date":"2024-09-24 00:00:00","insp_start_time":"1123","insp_end_time":"1149","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15533696","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-09-25 21:42:00","snet_input_date":"2024-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-25 21:42:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:38:33.000000Z","updated_at":"2025-03-17T20:38:33.000000Z","inspection_violations":[{"id":10623179,"change_date":"2024-09-25 21:42:00","inspection_id":"82760528","insp_violation_id":"262038236","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"203133247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ77327","created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":10999448,"change_date":"2024-09-25 21:42:00","inspection_id":"82760528","insp_unit_id":"203133247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2XWHT","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":5899992,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","dot_number":"2674836","report_state":"CA","report_number":"NCCL005866","insp_date":"2024-05-31 00:00:00","insp_start_time":"0900","insp_end_time":"0935","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"15386766","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-06-03 21:43:00","snet_input_date":"2024-05-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-03 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:19:31.000000Z","updated_at":"2025-03-17T20:19:31.000000Z","inspection_violations":[{"id":9149610,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","insp_violation_id":"259874207","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201207045","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3939A"},{"id":9149611,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","insp_violation_id":"259874208","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201207044","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"3922"},{"id":9149612,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","insp_violation_id":"259874209","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201207044","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:14.000000Z","updated_at":"2025-03-17T21:50:14.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":9502948,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","insp_unit_id":"201207044","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BLK 2X","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"},{"id":9502949,"change_date":"2024-06-03 21:43:00","inspection_id":"81773830","insp_unit_id":"201207045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"BLK 2X","insp_unit_license":"4HW5395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TKC028297M108191","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"}]},{"id":5602941,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","dot_number":"2674836","report_state":"CA","report_number":"N9ZT005790","insp_date":"2024-04-24 00:00:00","insp_start_time":"0840","insp_end_time":"0955","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54969","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15334096","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T20:13:51.000000Z","updated_at":"2025-03-17T20:13:51.000000Z","inspection_violations":[{"id":8663074,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_violation_id":"259156267","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"200587911","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3929A1"},{"id":8663075,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_violation_id":"259156268","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200587911","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA 512567","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3939A"},{"id":8663076,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_violation_id":"259156269","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200587910","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8663077,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_violation_id":"259156270","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200587910","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8663078,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_violation_id":"259156271","seq_no":"5","part_no":"393","part_no_section":"71(h)(10)","insp_viol_unit":"1","insp_unit_id":"200587910","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39371H10"}],"inspection_per_units":[{"id":9025020,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_unit_id":"200587910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BLK.2X","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"},{"id":9025021,"change_date":"2024-04-25 21:43:00","inspection_id":"81451107","insp_unit_id":"200587911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2X.FLTB","insp_unit_license":"4HN5395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"16VVX121762A34048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"}]},{"id":3741429,"change_date":"2023-08-14 21:43:00","inspection_id":"79404557","dot_number":"2674836","report_state":"CA","report_number":"UCV3001889","insp_date":"2023-08-10 00:00:00","insp_start_time":"0400","insp_end_time":"0413","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":"2023-08-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"15018029","transaction_code":"A","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-08-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:51.000000Z","updated_at":"2025-03-17T19:36:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6016012,"change_date":"2023-08-14 21:43:00","inspection_id":"79404557","insp_unit_id":"196526988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2 AXLE","insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:34.000000Z","updated_at":"2025-03-17T22:50:34.000000Z"}]},{"id":1863367,"change_date":"2022-12-02 21:41:00","inspection_id":"77275773","dot_number":"2674836","report_state":"CA","report_number":"UCKN001249","insp_date":"2022-12-02 00:00:00","insp_start_time":"0838","insp_end_time":"0846","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"14693494","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02674836","upload_search_indicator":null,"census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-12-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"ANDY'S ROOFING COMPANYINC","insp_carrier_street":"2161 ADAMS AVE","insp_carrier_city":"SAN LEANDRO","insp_carrier_state":"CA","insp_carrier_zip_code":"94577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"89686","created_at":"2025-03-17T19:01:05.000000Z","updated_at":"2025-03-17T19:01:05.000000Z","inspection_violations":[{"id":2903959,"change_date":"2022-12-02 21:41:00","inspection_id":"77275773","insp_violation_id":"249899990","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192240398","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2998832,"change_date":"2022-12-02 21:41:00","inspection_id":"77275773","insp_unit_id":"192240397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"31125D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDXF7DE4GDA05471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"},{"id":2998833,"change_date":"2022-12-02 21:41:00","inspection_id":"77275773","insp_unit_id":"192240398","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CRKG","insp_unit_company":null,"insp_unit_license":"4HW5395","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1TKC028297M108191","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2674836\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2674836\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2674836\/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\/2674836\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}