{"current_page":1,"data":[{"id":12280519,"change_date":"2026-06-25 21:51:00","inspection_id":"88240299","dot_number":"2625443","report_state":"CA","report_number":"NCCL007833","insp_date":"2026-06-22 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":"347","location_desc":"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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:51: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":"3621364","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOSE","insp_carrier_state":"CA","insp_carrier_zip_code":"95112","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2026-06-28T09:39:49.000000Z","updated_at":"2026-07-06T09:32:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21323991,"change_date":"2026-06-25 21:51:00","inspection_id":"88240299","insp_unit_id":"214285229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"A45WHT2X","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"Y","insp_unit_decal_number":"36190183","created_at":"2026-06-28T09:15:28.000000Z","updated_at":"2026-07-06T09:04:42.000000Z"}]},{"id":11942871,"change_date":"2026-05-16 21:38:00","inspection_id":"87878073","dot_number":"2625443","report_state":"CA","report_number":"NARW004452","insp_date":"2026-05-15 00:00:00","insp_start_time":"0737","insp_end_time":"0753","registration_date":null,"region":"PS","ci_status_code":"C","location":"347","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"99600","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":"3347112","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2026-05-16 21:38:00","snet_input_date":"2026-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-16 21:38:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOSE","insp_carrier_state":"CA","insp_carrier_zip_code":"95112","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2026-05-19T09:41:18.000000Z","updated_at":"2026-05-27T09:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20767493,"change_date":"2026-05-16 21:38:00","inspection_id":"87878073","insp_unit_id":"213605474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT\/3X","insp_unit_license":"18398X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-19T09:20:15.000000Z","updated_at":"2026-05-27T09:03:45.000000Z"},{"id":20767494,"change_date":"2026-05-16 21:38:00","inspection_id":"87878073","insp_unit_id":"213605475","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"KLI","insp_unit_company":"BLK\/2X","insp_unit_license":"4WR1813","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5SHFH252X7B000406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-19T09:20:15.000000Z","updated_at":"2026-05-27T09:03:45.000000Z"}]},{"id":11937428,"change_date":"2026-05-16 21:37:00","inspection_id":"87872355","dot_number":"2625443","report_state":"CA","report_number":"UCU1001298","insp_date":"2026-05-13 00:00:00","insp_start_time":"0805","insp_end_time":"0845","registration_date":null,"region":"ES","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-16 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"3339372","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2026-05-16 21:37:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-16 21:37:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOSE","insp_carrier_state":"CA","insp_carrier_zip_code":"95112","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-19T09:41:10.000000Z","updated_at":"2026-05-27T09:30:18.000000Z","inspection_violations":[{"id":20763678,"change_date":"2026-05-16 21:37:00","inspection_id":"87872355","insp_violation_id":"274309149","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"213595947","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-19T10:01:38.000000Z","updated_at":"2026-05-27T09:40:12.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":20758644,"change_date":"2026-05-16 21:37:00","inspection_id":"87872355","insp_unit_id":"213595947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X WHT","insp_unit_license":"18361X3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-19T09:20:01.000000Z","updated_at":"2026-05-27T09:02:07.000000Z"}]},{"id":10653744,"change_date":"2026-01-14 21:41:00","inspection_id":"86795690","dot_number":"2625443","report_state":"CA","report_number":"NEC6001455","insp_date":"2026-01-13 00:00:00","insp_start_time":"1409","insp_end_time":"1427","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-14 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":"16128369","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2026-01-14 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-14 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOSE","insp_carrier_state":"CA","insp_carrier_zip_code":"95112","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2026-01-17T10:36:37.000000Z","updated_at":"2026-01-25T10:31:13.000000Z","inspection_violations":[{"id":17927193,"change_date":"2026-01-14 21:41:00","inspection_id":"86795690","insp_violation_id":"271214135","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211094914","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-17T10:43:57.000000Z","updated_at":"2026-01-25T10:31:58.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17874139,"change_date":"2026-01-14 21:41:00","inspection_id":"86795690","insp_unit_id":"211094914","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"A45\/WHT","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-17T10:09:12.000000Z","updated_at":"2026-01-25T10:01:25.000000Z"}]},{"id":10424366,"change_date":"2025-12-12 21:41:00","inspection_id":"86555716","dot_number":"2625443","report_state":"CA","report_number":"NC9Y006830","insp_date":"2025-12-09 00:00:00","insp_start_time":"0951","insp_end_time":"1022","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":"2025-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"16092992","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOSE","insp_carrier_state":"CA","insp_carrier_zip_code":"95112","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-15T10:32:14.000000Z","updated_at":"2025-12-23T10:31:12.000000Z","inspection_violations":[{"id":17479049,"change_date":"2025-12-12 21:41:00","inspection_id":"86555716","insp_violation_id":"270662022","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210585884","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ00198","created_at":"2025-12-15T10:33:59.000000Z","updated_at":"2025-12-23T10:32:08.000000Z","normalized_code":"3922SLLSR"},{"id":17479050,"change_date":"2025-12-12 21:41:00","inspection_id":"86555716","insp_violation_id":"270662023","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"210585884","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:59.000000Z","updated_at":"2025-12-23T10:32:08.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":17436061,"change_date":"2025-12-12 21:41:00","inspection_id":"86555716","insp_unit_id":"210585884","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT\/A21","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","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":17436062,"change_date":"2025-12-12 21:41:00","inspection_id":"86555716","insp_unit_id":"210585885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROT","insp_unit_company":"F\/B","insp_unit_license":"4TV8209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5BNDP282XYC001862","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":9487677,"change_date":"2025-08-25 21:40:00","inspection_id":"85571634","dot_number":"2625443","report_state":"CA","report_number":"UD8N004407","insp_date":"2025-08-21 00:00:00","insp_start_time":"1645","insp_end_time":"1730","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF UNION AVE., SAN JOSE","county_code_state":"CA","county_code":"085","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":"2025-08-22 21:39: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":"15948595","transaction_code":"C","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-08-22 21:39:00","snet_input_date":"2025-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-22 21:39:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:29.000000Z","updated_at":"2025-08-29T10:42:41.000000Z","inspection_violations":[{"id":15488369,"change_date":"2025-08-25 21:40:00","inspection_id":"85571634","insp_violation_id":"268241099","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-08-28T10:44:03.000000Z","updated_at":"2025-09-05T10:48:36.000000Z","normalized_code":"3922SLLTCD"},{"id":15488370,"change_date":"2025-08-25 21:40:00","inspection_id":"85571634","insp_violation_id":"268241100","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208575983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:44:03.000000Z","updated_at":"2025-09-05T10:48:36.000000Z","normalized_code":"3922SLLSR"},{"id":15488371,"change_date":"2025-08-25 21:40:00","inspection_id":"85571634","insp_violation_id":"268241101","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208575983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA785354","created_at":"2025-08-28T10:44:03.000000Z","updated_at":"2025-09-05T10:48:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15669497,"change_date":"2025-08-25 21:40:00","inspection_id":"85571634","insp_unit_id":"208575983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"56322S3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FD0W5GT4NED54668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:33.000000Z","updated_at":"2025-08-29T09:45:47.000000Z"}]},{"id":8997314,"change_date":"2025-06-26 21:41:00","inspection_id":"85056018","dot_number":"2625443","report_state":"CA","report_number":"NCPN006793","insp_date":"2025-06-16 00:00:00","insp_start_time":"1515","insp_end_time":"1536","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"15871906","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"1731 SMITH AVE","insp_carrier_city":"SAN JOES","insp_carrier_state":"CA","insp_carrier_zip_code":"94088","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-06-30T10:01:05.000000Z","updated_at":"2025-06-30T10:01:05.000000Z","inspection_violations":[{"id":14466673,"change_date":"2025-06-26 21:41:00","inspection_id":"85056018","insp_violation_id":"267070475","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207578428","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:52.000000Z","updated_at":"2025-06-30T10:18:15.000000Z","normalized_code":"39345DB"},{"id":14466674,"change_date":"2025-06-26 21:41:00","inspection_id":"85056018","insp_violation_id":"267070476","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"207578429","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA666283","created_at":"2025-06-29T10:16:52.000000Z","updated_at":"2025-06-30T10:18:15.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":14755449,"change_date":"2025-06-26 21:41:00","inspection_id":"85056018","insp_unit_id":"207578428","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:21.000000Z","updated_at":"2025-07-01T09:48:00.000000Z"},{"id":14755450,"change_date":"2025-06-26 21:41:00","inspection_id":"85056018","insp_unit_id":"207578429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROT","insp_unit_company":null,"insp_unit_license":"4TV8209","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5BNDP282XYC001862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:21.000000Z","updated_at":"2025-07-01T09:48:00.000000Z"}]},{"id":8217229,"change_date":"2025-03-26 21:41:00","inspection_id":"84232338","dot_number":"2625443","report_state":"CA","report_number":"UCU1000560","insp_date":"2025-03-24 00:00:00","insp_start_time":"0905","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"2025-03-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"15755229","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-03-26 21:41:00","snet_input_date":"2025-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-26 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-29T10:22:05.000000Z","updated_at":"2025-03-30T10:37:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13290956,"change_date":"2025-03-26 21:41:00","inspection_id":"84232338","insp_unit_id":"206006570","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X WHT ED","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:16:23.000000Z","updated_at":"2025-03-30T10:14:50.000000Z"}]},{"id":8075571,"change_date":"2025-03-10 21:39:00","inspection_id":"84083274","dot_number":"2625443","report_state":"CA","report_number":"UDPO000450","insp_date":"2025-03-09 00:00:00","insp_start_time":"1049","insp_end_time":"1101","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-10 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":"15734381","transaction_code":"A","transaction_date":"2025-03-09 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-03-10 21:39:00","snet_input_date":"2025-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-10 21:39:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13038699,"change_date":"2025-03-10 21:39:00","inspection_id":"84083274","insp_unit_id":"205719631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/A45","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:05.000000Z","updated_at":"2025-03-17T23:59:05.000000Z"}]},{"id":7899405,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","dot_number":"2625443","report_state":"CA","report_number":"NE7S004317","insp_date":"2025-02-14 00:00:00","insp_start_time":"0807","insp_end_time":"0825","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":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"69600","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15705281","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[{"id":12344555,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","insp_violation_id":"264575724","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205380991","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3939ALRLI"},{"id":12344556,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","insp_violation_id":"264575725","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"205380991","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3939ALSLIWR"},{"id":12344557,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","insp_violation_id":"264575726","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"205380991","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA672734","created_at":"2025-03-17T22:06:18.000000Z","updated_at":"2025-03-17T22:06:18.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":12751071,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","insp_unit_id":"205380990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHITE\/3AX","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"},{"id":12751072,"change_date":"2025-02-18 21:40:00","inspection_id":"83898258","insp_unit_id":"205380991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAFMN","insp_unit_company":"BLACK\/2AX","insp_unit_license":"4HJ8635","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5SHFH252X7B000406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:53.000000Z","updated_at":"2025-03-17T23:55:53.000000Z"}]},{"id":7207859,"change_date":"2024-11-15 21:43:00","inspection_id":"83171128","dot_number":"2625443","report_state":"CA","report_number":"UCOM000338","insp_date":"2024-11-14 00:00:00","insp_start_time":"0659","insp_end_time":"0739","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"15594948","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-11-15 21:43:00","snet_input_date":"2024-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-15 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:26.000000Z","updated_at":"2025-03-17T20:46:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11626166,"change_date":"2024-11-15 21:43:00","inspection_id":"83171128","insp_unit_id":"203910259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:30.000000Z","updated_at":"2025-03-17T23:43:30.000000Z"}]},{"id":7197566,"change_date":"2024-11-14 21:41:00","inspection_id":"83160196","dot_number":"2625443","report_state":"CA","report_number":"NFDT000209","insp_date":"2024-11-12 00:00:00","insp_start_time":"0940","insp_end_time":"1000","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15593074","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:03.000000Z","updated_at":"2025-03-17T20:46:03.000000Z","inspection_violations":[{"id":11248010,"change_date":"2024-11-14 21:41:00","inspection_id":"83160196","insp_violation_id":"262904071","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"203888468","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":11609622,"change_date":"2024-11-14 21:41:00","inspection_id":"83160196","insp_unit_id":"203888468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X WHITE ED","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":7098221,"change_date":"2024-10-31 21:43:00","inspection_id":"83054960","dot_number":"2625443","report_state":"CA","report_number":"UDLV003757","insp_date":"2024-10-31 00:00:00","insp_start_time":"0756","insp_end_time":"0807","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"MONUMENT BL OFF RAMP","county_code_state":"CA","county_code":"013","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":"Y","traffic_enf":"Y","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":"97000","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":"15579685","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T20:43:55.000000Z","updated_at":"2025-03-17T20:43:55.000000Z","inspection_violations":[{"id":11082941,"change_date":"2024-10-31 21:43:00","inspection_id":"83054960","insp_violation_id":"262674615","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-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3922SLLTCD"},{"id":11082942,"change_date":"2024-10-31 21:43:00","inspection_id":"83054960","insp_violation_id":"262674616","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"2","insp_unit_id":"203690324","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11448046,"change_date":"2024-10-31 21:43:00","inspection_id":"83054960","insp_unit_id":"203690323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","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":11448047,"change_date":"2024-10-31 21:43:00","inspection_id":"83054960","insp_unit_id":"203690324","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"A27","insp_unit_license":"4PN2259","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"46UFU3020G1174695","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":6616546,"change_date":"2024-08-30 21:41:00","inspection_id":"82542817","dot_number":"2625443","report_state":"CA","report_number":"NC7K009058","insp_date":"2024-08-27 00:00:00","insp_start_time":"1140","insp_end_time":"1210","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":"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-08-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"11600","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":"15505002","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-08-30 21:41:00","snet_input_date":"2024-08-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-30 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:06.000000Z","updated_at":"2025-03-17T20:34:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10667542,"change_date":"2024-08-30 21:41:00","inspection_id":"82542817","insp_unit_id":"202695833","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT 2X UT","insp_unit_license":"31473V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WR8CL8KG517276","insp_unit_decal":"Y","insp_unit_decal_number":"34151810","created_at":"2025-03-17T23:33:28.000000Z","updated_at":"2025-03-17T23:33:28.000000Z"}]},{"id":6048937,"change_date":"2024-06-21 21:39:00","inspection_id":"81935219","dot_number":"2625443","report_state":"CA","report_number":"NDLU006172","insp_date":"2024-06-19 00:00:00","insp_start_time":"0742","insp_end_time":"0807","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY INSPECTION FACILITY","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":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-21 21:39: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":"15414382","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-06-21 21:39:00","snet_input_date":"2024-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-21 21:39:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T20:22:36.000000Z","updated_at":"2025-03-17T20:22:36.000000Z","inspection_violations":[{"id":9384254,"change_date":"2024-06-21 21:39:00","inspection_id":"81935219","insp_violation_id":"260243068","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"201533217","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:25.000000Z","updated_at":"2025-03-17T21:51:25.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":9742552,"change_date":"2024-06-21 21:39:00","inspection_id":"81935219","insp_unit_id":"201533217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT A45","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:56.000000Z","updated_at":"2025-03-17T23:23:56.000000Z"}]},{"id":6050176,"change_date":"2024-06-21 21:40:00","inspection_id":"81936501","dot_number":"2625443","report_state":"CA","report_number":"UFCF000370","insp_date":"2024-06-19 00:00:00","insp_start_time":"0906","insp_end_time":"0931","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":"2024-06-21 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":"15414935","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-06-21 21:40:00","snet_input_date":"2024-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-21 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:37.000000Z","updated_at":"2025-03-17T20:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9744437,"change_date":"2024-06-21 21:40:00","inspection_id":"81936501","insp_unit_id":"201535353","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT\/A45","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"Y","insp_unit_decal_number":"33860257","created_at":"2025-03-17T23:23:56.000000Z","updated_at":"2025-03-17T23:23:56.000000Z"}]},{"id":6029342,"change_date":"2024-06-19 21:38:00","inspection_id":"81914095","dot_number":"2625443","report_state":"CA","report_number":"NC7K008762","insp_date":"2024-06-18 00:00:00","insp_start_time":"1241","insp_end_time":"1311","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":"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-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"11600","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":"15411567","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-06-19 21:38:00","snet_input_date":"2024-06-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-19 21:38:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[{"id":9354384,"change_date":"2024-06-19 21:38:00","inspection_id":"81914095","insp_violation_id":"260195969","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201490934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:15.000000Z","updated_at":"2025-03-17T21:51:15.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9711220,"change_date":"2024-06-19 21:38:00","inspection_id":"81914095","insp_unit_id":"201490934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"WHT 2X UT","insp_unit_license":"31473V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WR8CL8KG517276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:38.000000Z","updated_at":"2025-03-17T23:23:38.000000Z"}]},{"id":5831174,"change_date":"2024-05-23 21:41:00","inspection_id":"81699224","dot_number":"2625443","report_state":"CA","report_number":"NBGO006668","insp_date":"2024-05-22 00:00:00","insp_start_time":"0739","insp_end_time":"0757","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15375640","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T20:18:17.000000Z","updated_at":"2025-03-17T20:18:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9391392,"change_date":"2024-05-23 21:41:00","inspection_id":"81699224","insp_unit_id":"201061888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"Y","insp_unit_decal_number":"33867398","created_at":"2025-03-17T23:20:30.000000Z","updated_at":"2025-03-17T23:20:30.000000Z"}]},{"id":5796931,"change_date":"2024-05-20 21:43:00","inspection_id":"81661691","dot_number":"2625443","report_state":"CA","report_number":"UE7U002540","insp_date":"2024-05-17 00:00:00","insp_start_time":"1025","insp_end_time":"1110","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"FLYNN RD EB WOF CITATION WY","county_code_state":"CA","county_code":"069","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-05-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15371205","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-05-20 21:43:00","snet_input_date":"2024-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-20 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T20:17:32.000000Z","updated_at":"2025-03-17T20:17:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9336887,"change_date":"2024-05-20 21:43:00","inspection_id":"81661691","insp_unit_id":"200991528","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"650\/WHT","insp_unit_license":"51147Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3FRNF6FC9FV728119","insp_unit_decal":"Y","insp_unit_decal_number":"33867223","created_at":"2025-03-17T23:19:56.000000Z","updated_at":"2025-03-17T23:19:56.000000Z"}]},{"id":5771728,"change_date":"2024-05-16 21:42:00","inspection_id":"81634610","dot_number":"2625443","report_state":"CA","report_number":"UCOM000131","insp_date":"2024-05-13 00:00:00","insp_start_time":"0710","insp_end_time":"0740","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-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"15365889","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-05-16 21:42:00","snet_input_date":"2024-05-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-16 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:06.000000Z","updated_at":"2025-03-17T20:17:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9296412,"change_date":"2024-05-16 21:42:00","inspection_id":"81634610","insp_unit_id":"200940092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:33.000000Z","updated_at":"2025-03-17T23:19:33.000000Z"}]},{"id":5450468,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","dot_number":"2625443","report_state":"CA","report_number":"UFUE000357","insp_date":"2024-04-05 00:00:00","insp_start_time":"0545","insp_end_time":"0611","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"CHEVRON AIRWAY BLVD N\/OF 580","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11600","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15307810","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[{"id":8412876,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780884","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW263050","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8412877,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780885","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"},{"id":8412878,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780886","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW263050","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39360D"},{"id":8412879,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780887","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39360D"},{"id":8412880,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780888","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW263050","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39395A"},{"id":8412881,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780889","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW263050","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"39395F"},{"id":8412882,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_violation_id":"258780890","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200268346","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW263050","created_at":"2025-03-17T21:46:43.000000Z","updated_at":"2025-03-17T21:46:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8779220,"change_date":"2024-04-05 21:40:00","inspection_id":"81284630","insp_unit_id":"200268346","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"2X WHI","insp_unit_license":"31473V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C7WR8CL8KG517276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":5383153,"change_date":"2024-03-27 21:42:00","inspection_id":"81211166","dot_number":"2625443","report_state":"CA","report_number":"N5Y3005614","insp_date":"2024-03-26 00:00:00","insp_start_time":"1229","insp_end_time":"1248","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":"ABERLE CONCRETE","shipping_paper_number":"NONE","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15296286","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:25.000000Z","updated_at":"2025-03-17T20:09:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8669738,"change_date":"2024-03-27 21:42:00","inspection_id":"81211166","insp_unit_id":"200122381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHI","insp_unit_license":"62600U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDTF4GY3JEC68779","insp_unit_decal":"Y","insp_unit_decal_number":"33575310","created_at":"2025-03-17T23:13:37.000000Z","updated_at":"2025-03-17T23:13:37.000000Z"}]},{"id":4730500,"change_date":"2023-12-28 21:46:00","inspection_id":"80498582","dot_number":"2625443","report_state":"CA","report_number":"NE02003810","insp_date":"2023-12-26 00:00:00","insp_start_time":"1642","insp_end_time":"1702","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":"2023-12-28 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15183345","transaction_code":"A","transaction_date":"2023-12-26 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-12-28 21:46:00","snet_input_date":"2023-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-28 21:46:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:56:33.000000Z","updated_at":"2025-03-17T19:56:33.000000Z","inspection_violations":[{"id":7304709,"change_date":"2023-12-28 21:46:00","inspection_id":"80498582","insp_violation_id":"257112089","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198733730","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"3922"},{"id":7304710,"change_date":"2023-12-28 21:46:00","inspection_id":"80498582","insp_violation_id":"257112090","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198733730","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7609376,"change_date":"2023-12-28 21:46:00","inspection_id":"80498582","insp_unit_id":"198733730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/W3X","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:01.000000Z","updated_at":"2025-03-17T23:04:01.000000Z"}]},{"id":4500370,"change_date":"2023-11-27 21:43:00","inspection_id":"80246280","dot_number":"2625443","report_state":"CA","report_number":"NCCL005269","insp_date":"2023-11-15 00:00:00","insp_start_time":"1110","insp_end_time":"1130","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":"2023-11-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15143874","transaction_code":"A","transaction_date":"2023-11-15 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-11-27 21:43:00","snet_input_date":"2023-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7238120,"change_date":"2023-11-27 21:43:00","inspection_id":"80246280","insp_unit_id":"198227068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT 2X","insp_unit_license":"BL02N28","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDTF4GY3JEC68779","insp_unit_decal":"Y","insp_unit_decal_number":"33212952","created_at":"2025-03-17T23:00:48.000000Z","updated_at":"2025-03-17T23:00:48.000000Z"}]},{"id":4346329,"change_date":"2023-11-02 21:43:00","inspection_id":"80076271","dot_number":"2625443","report_state":"CA","report_number":"UCV3001984","insp_date":"2023-11-01 00:00:00","insp_start_time":"2121","insp_end_time":"2142","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 21:43: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":"15120728","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-11-02 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-02 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:06.000000Z","updated_at":"2025-03-17T19:49:06.000000Z","inspection_violations":[{"id":6723675,"change_date":"2023-11-02 21:43:00","inspection_id":"80076271","insp_violation_id":"256200325","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"197889243","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW954724","created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39021TA"},{"id":6723676,"change_date":"2023-11-02 21:43:00","inspection_id":"80076271","insp_violation_id":"256200326","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197889243","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW954724","created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":6990009,"change_date":"2023-11-02 21:43:00","inspection_id":"80076271","insp_unit_id":"197889243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2 AXLE","insp_unit_license":"BL02N28","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDTF4GY3JEC68779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"}]},{"id":4306779,"change_date":"2023-10-27 21:43:00","inspection_id":"80032690","dot_number":"2625443","report_state":"CA","report_number":"NDN6007832","insp_date":"2023-10-24 00:00:00","insp_start_time":"1340","insp_end_time":"1413","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15112839","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:48:21.000000Z","updated_at":"2025-03-17T19:48:21.000000Z","inspection_violations":[{"id":6662695,"change_date":"2023-10-27 21:43:00","inspection_id":"80032690","insp_violation_id":"256102432","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197799364","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3939A"},{"id":6662696,"change_date":"2023-10-27 21:43:00","inspection_id":"80032690","insp_violation_id":"256102433","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"197799364","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:06.000000Z","updated_at":"2025-03-17T21:38:06.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":6926537,"change_date":"2023-10-27 21:43:00","inspection_id":"80032690","insp_unit_id":"197799364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X ED WHITE","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:08.000000Z","updated_at":"2025-03-17T22:58:08.000000Z"}]},{"id":4266194,"change_date":"2023-10-23 21:42:00","inspection_id":"79987769","dot_number":"2625443","report_state":"CA","report_number":"NDN6007808","insp_date":"2023-10-19 00:00:00","insp_start_time":"0634","insp_end_time":"0708","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15106192","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:47:26.000000Z","updated_at":"2025-03-17T19:47:26.000000Z","inspection_violations":[{"id":6599926,"change_date":"2023-10-23 21:42:00","inspection_id":"79987769","insp_violation_id":"255999641","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197707241","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3939A"},{"id":6599927,"change_date":"2023-10-23 21:42:00","inspection_id":"79987769","insp_violation_id":"255999642","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197707241","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3922"},{"id":6599928,"change_date":"2023-10-23 21:42:00","inspection_id":"79987769","insp_violation_id":"255999643","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197707241","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6861185,"change_date":"2023-10-23 21:42:00","inspection_id":"79987769","insp_unit_id":"197707241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X ED WHITE","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:32.000000Z","updated_at":"2025-03-17T22:57:32.000000Z"}]},{"id":4209670,"change_date":"2023-10-16 21:43:00","inspection_id":"79925329","dot_number":"2625443","report_state":"CA","report_number":"UCD7000169","insp_date":"2023-10-14 00:00:00","insp_start_time":"1040","insp_end_time":"1052","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":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15096483","transaction_code":"A","transaction_date":"2023-10-14 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[{"id":6518644,"change_date":"2023-10-16 21:43:00","inspection_id":"79925329","insp_violation_id":"255868712","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197583851","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:24.000000Z","updated_at":"2025-03-17T21:37:24.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6769956,"change_date":"2023-10-16 21:43:00","inspection_id":"79925329","insp_unit_id":"197583851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2 AX  WHT","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:44.000000Z","updated_at":"2025-03-17T22:56:44.000000Z"}]},{"id":4178265,"change_date":"2023-10-11 21:41:00","inspection_id":"79890554","dot_number":"2625443","report_state":"CA","report_number":"UE03002906","insp_date":"2023-10-09 00:00:00","insp_start_time":"1400","insp_end_time":"1432","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15092813","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-10-11 21:41:00","snet_input_date":"2023-10-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-11 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:31.000000Z","updated_at":"2025-03-17T19:45:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6719085,"change_date":"2023-10-11 21:41:00","inspection_id":"79890554","insp_unit_id":"197511942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3AX","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:19.000000Z","updated_at":"2025-03-17T22:56:19.000000Z"}]},{"id":3837631,"change_date":"2023-08-25 21:42:00","inspection_id":"79512075","dot_number":"2625443","report_state":"CA","report_number":"UE03002829","insp_date":"2023-08-21 00:00:00","insp_start_time":"1145","insp_end_time":"1216","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15037185","transaction_code":"A","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-08-25 21:42:00","snet_input_date":"2023-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-25 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:34.000000Z","updated_at":"2025-03-17T19:38:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6170214,"change_date":"2023-08-25 21:42:00","inspection_id":"79512075","insp_unit_id":"196743645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:51.000000Z","updated_at":"2025-03-17T22:51:51.000000Z"}]},{"id":3473147,"change_date":"2023-07-10 21:43:00","inspection_id":"79104095","dot_number":"2625443","report_state":"CA","report_number":"UD4T000619","insp_date":"2023-07-07 00:00:00","insp_start_time":"1214","insp_end_time":"1246","registration_date":null,"region":"PT","ci_status_code":"C","location":"9211","location_desc":"SAN JOQAUIN COUNTY","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"14974027","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-07-10 21:43:00","snet_input_date":"2023-07-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-10 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"34395P1","created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[{"id":5355521,"change_date":"2023-07-10 21:43:00","inspection_id":"79104095","insp_violation_id":"253972182","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195920546","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3922"},{"id":5355522,"change_date":"2023-07-10 21:43:00","inspection_id":"79104095","insp_violation_id":"253972183","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195920546","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5584995,"change_date":"2023-07-10 21:43:00","inspection_id":"79104095","insp_unit_id":"195920546","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A21","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:05.000000Z","updated_at":"2025-03-17T22:47:05.000000Z"}]},{"id":3347007,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","dot_number":"2625443","report_state":"CA","report_number":"NC7K007421","insp_date":"2023-06-20 00:00:00","insp_start_time":"0605","insp_end_time":"0640","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14955414","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[{"id":5162256,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","insp_violation_id":"253658060","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195635468","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3922"},{"id":5162257,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","insp_violation_id":"253658061","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195635468","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA391665","created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3922"},{"id":5162258,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","insp_violation_id":"253658062","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195635468","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3963A1"},{"id":5162259,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","insp_violation_id":"253658063","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195635468","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:59.000000Z","updated_at":"2025-03-17T21:30:59.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":5380821,"change_date":"2023-06-22 21:42:00","inspection_id":"78962240","insp_unit_id":"195635468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT3XED","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:27.000000Z","updated_at":"2025-03-17T22:45:27.000000Z"}]},{"id":3186038,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","dot_number":"2625443","report_state":"CA","report_number":"NDN6007230","insp_date":"2023-05-16 00:00:00","insp_start_time":"0900","insp_end_time":"0940","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"14925913","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-05-31 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-31 21:43:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:26:05.000000Z","updated_at":"2025-03-17T19:26:05.000000Z","inspection_violations":[{"id":4909500,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","insp_violation_id":"253198912","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195244437","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3922"},{"id":4909501,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","insp_violation_id":"253198913","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195244437","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3922"},{"id":4909502,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","insp_violation_id":"253198914","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195244437","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3922"},{"id":4909503,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","insp_violation_id":"253198915","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195244437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5124847,"change_date":"2023-05-31 21:43:00","inspection_id":"78780610","insp_unit_id":"195244437","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3X ED WHITE","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:22.000000Z","updated_at":"2025-03-17T22:43:22.000000Z"}]},{"id":2968405,"change_date":"2023-05-04 21:42:00","inspection_id":"78534834","dot_number":"2625443","report_state":"CA","report_number":"NC7K007245","insp_date":"2023-05-02 00:00:00","insp_start_time":"0615","insp_end_time":"0635","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":"2023-05-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14887546","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-05-04 21:42:00","snet_input_date":"2023-05-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-04 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:51.000000Z","updated_at":"2025-03-17T19:21:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4776458,"change_date":"2023-05-04 21:42:00","inspection_id":"78534834","insp_unit_id":"194759073","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT3XED","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:39.000000Z","updated_at":"2025-03-17T22:40:39.000000Z"}]},{"id":2845012,"change_date":"2023-04-19 21:42:00","inspection_id":"78395286","dot_number":"2625443","report_state":"CA","report_number":"N9PI005934","insp_date":"2023-04-13 00:00:00","insp_start_time":"0952","insp_end_time":"1022","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35999","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":"14865012","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-04-19 21:42:00","snet_input_date":"2023-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:19:15.000000Z","updated_at":"2025-03-17T19:19:15.000000Z","inspection_violations":[{"id":4366441,"change_date":"2023-04-19 21:42:00","inspection_id":"78395286","insp_violation_id":"252327702","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194482847","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:24.000000Z","updated_at":"2025-03-17T21:27:24.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":4578668,"change_date":"2023-04-19 21:42:00","inspection_id":"78395286","insp_unit_id":"194482846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT DMP TRK","insp_unit_license":"51147Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3FRNF6FC9FV728119","insp_unit_decal":"Y","insp_unit_decal_number":"32547605","created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"},{"id":4578669,"change_date":"2023-04-19 21:42:00","inspection_id":"78395286","insp_unit_id":"194482847","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KRGO","insp_unit_company":"FB TRL","insp_unit_license":"4NU9030","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5SHFD20247B000405","insp_unit_decal":"Y","insp_unit_decal_number":"32547606","created_at":"2025-03-17T22:39:06.000000Z","updated_at":"2025-03-17T22:39:06.000000Z"}]},{"id":2669931,"change_date":"2023-03-27 21:40:00","inspection_id":"78195673","dot_number":"2625443","report_state":"CA","report_number":"NE8I002048","insp_date":"2023-03-22 00:00:00","insp_start_time":"1442","insp_end_time":"1524","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":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"14833198","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4104418,"change_date":"2023-03-27 21:40:00","inspection_id":"78195673","insp_violation_id":"251890670","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194084650","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4299143,"change_date":"2023-03-27 21:40:00","inspection_id":"78195673","insp_unit_id":"194084650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A21\/WHT","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"Y","insp_unit_decal_number":"32148297","created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2629272,"change_date":"2023-03-21 21:42:00","inspection_id":"78149780","dot_number":"2625443","report_state":"CA","report_number":"UD8N002493","insp_date":"2023-03-20 00:00:00","insp_start_time":"1350","insp_end_time":"1420","registration_date":null,"region":"PT","ci_status_code":"C","location":"340","location_desc":"N\/OF SR-237, SAN JOSE","county_code_state":"CA","county_code":"085","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":"2023-03-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14825473","transaction_code":"A","transaction_date":"2023-03-20 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2023-03-21 21:42:00","snet_input_date":"2023-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-21 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:15:11.000000Z","updated_at":"2025-03-17T19:15:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4232692,"change_date":"2023-03-21 21:42:00","inspection_id":"78149780","insp_unit_id":"193991611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:21.000000Z","updated_at":"2025-03-17T22:36:21.000000Z"}]},{"id":2021451,"change_date":"2022-12-27 21:40:00","inspection_id":"77456420","dot_number":"2625443","report_state":"CA","report_number":"NE02002427","insp_date":"2022-12-19 00:00:00","insp_start_time":"1442","insp_end_time":"1456","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":"2022-12-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14721508","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-12-27 21:40:00","snet_input_date":"2022-12-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-27 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T19:03:58.000000Z","updated_at":"2025-03-17T19:03:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3252404,"change_date":"2022-12-27 21:40:00","inspection_id":"77456420","insp_unit_id":"192594767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT2X","insp_unit_license":"56881U2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF7DE9KDF03312","insp_unit_decal":"Y","insp_unit_decal_number":"31926619","created_at":"2025-03-17T22:29:17.000000Z","updated_at":"2025-03-17T22:29:17.000000Z"}]},{"id":1628487,"change_date":"2022-10-28 21:40:00","inspection_id":"77006477","dot_number":"2625443","report_state":"CA","report_number":"N9ZT004079","insp_date":"2022-10-27 00:00:00","insp_start_time":"1200","insp_end_time":"1230","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":"2022-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"14654534","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T18:56:40.000000Z","updated_at":"2025-03-17T18:56:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2619913,"change_date":"2022-10-28 21:40:00","inspection_id":"77006477","insp_unit_id":"191704591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"51147Y1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3FRNF6FC9FV728119","insp_unit_decal":"Y","insp_unit_decal_number":"31822671","created_at":"2025-03-17T22:24:57.000000Z","updated_at":"2025-03-17T22:24:57.000000Z"}]},{"id":1393362,"change_date":"2022-09-28 21:41:00","inspection_id":"76734817","dot_number":"2625443","report_state":"CA","report_number":"NC7K006401","insp_date":"2022-09-27 00:00:00","insp_start_time":"0812","insp_end_time":"0832","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":"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-09-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14613947","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-09-28 21:41:00","snet_input_date":"2022-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-28 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:21.000000Z","updated_at":"2025-03-17T18:52:21.000000Z","inspection_violations":[{"id":2202050,"change_date":"2022-09-28 21:41:00","inspection_id":"76734817","insp_violation_id":"248714039","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191159614","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:07.000000Z","updated_at":"2025-03-17T21:17:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2243896,"change_date":"2022-09-28 21:41:00","inspection_id":"76734817","insp_unit_id":"191159614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT3XED","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:21.000000Z","updated_at":"2025-03-17T22:22:21.000000Z"}]},{"id":824667,"change_date":"2022-07-14 21:42:00","inspection_id":"76072414","dot_number":"2625443","report_state":"CA","report_number":"UE03001888","insp_date":"2022-07-12 00:00:00","insp_start_time":"1600","insp_end_time":"1631","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14507352","transaction_code":"A","transaction_date":"2022-07-12 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-07-14 21:42:00","snet_input_date":"2022-07-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-14 21:42:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:16.000000Z","updated_at":"2025-03-17T18:42:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1326849,"change_date":"2022-07-14 21:42:00","inspection_id":"76072414","insp_unit_id":"189793526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:21.000000Z","updated_at":"2025-03-17T22:16:21.000000Z"}]},{"id":783729,"change_date":"2022-07-08 21:41:00","inspection_id":"76024465","dot_number":"2625443","report_state":"CA","report_number":"UEAO002663","insp_date":"2022-06-14 00:00:00","insp_start_time":"0803","insp_end_time":"0815","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"2022-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64999","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":"14497347","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:34.000000Z","updated_at":"2025-03-17T18:41:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1260939,"change_date":"2022-07-08 21:41:00","inspection_id":"76024465","insp_unit_id":"189686373","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"3XWHT","insp_unit_license":"34395P1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"2NP3LJ9X4FM255748","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"}]},{"id":401257,"change_date":"2022-05-16 21:44:00","inspection_id":"75571703","dot_number":"2625443","report_state":"CA","report_number":"NE02001641","insp_date":"2022-05-09 00:00:00","insp_start_time":"1515","insp_end_time":"1551","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":"2022-05-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14428313","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02625443","upload_search_indicator":null,"census_search_date":"2022-05-16 21:44:00","snet_input_date":"2022-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-16 21:44:00","insp_carrier_name":"ABERLE CONCRETE EXCAVATING & GRADING INC","insp_carrier_street":"42100 BOSCELL RD","insp_carrier_city":"FREMONT","insp_carrier_state":"CA","insp_carrier_zip_code":"94538","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"417442","created_at":"2025-03-17T18:34:44.000000Z","updated_at":"2025-03-17T18:34:44.000000Z","inspection_violations":[{"id":628001,"change_date":"2022-05-16 21:44:00","inspection_id":"75571703","insp_violation_id":"245821378","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188711215","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"},{"id":628002,"change_date":"2022-05-16 21:44:00","inspection_id":"75571703","insp_violation_id":"245821379","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"188711215","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39375A3"},{"id":628003,"change_date":"2022-05-16 21:44:00","inspection_id":"75571703","insp_violation_id":"245821380","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188711215","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":648341,"change_date":"2022-05-16 21:44:00","inspection_id":"75571703","insp_unit_id":"188711215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"A23\/WHT3X","insp_unit_license":"81369W1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPSLP0X0GD330741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2625443\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2625443\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2625443\/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\/2625443\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}