{"current_page":1,"data":[{"id":11880776,"change_date":"2026-05-12 21:38:00","inspection_id":"87818327","dot_number":"2672795","report_state":"CA","report_number":"NBH6007885","insp_date":"2026-05-06 00:00:00","insp_start_time":"0721","insp_end_time":"0745","registration_date":null,"region":"PS","ci_status_code":"C","location":"366","location_desc":"CA","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3303206","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2026-05-12 21:38:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:38:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2026-05-14T12:39:22.000000Z","updated_at":"2026-05-23T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20657533,"change_date":"2026-05-12 21:38:00","inspection_id":"87818327","insp_unit_id":"213493927","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56207Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK2KH483647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:15.000000Z","updated_at":"2026-05-23T09:02:44.000000Z"}]},{"id":11208202,"change_date":"2026-02-23 21:39:00","inspection_id":"87119386","dot_number":"2672795","report_state":"CA","report_number":"NBH6007621","insp_date":"2026-02-13 00:00:00","insp_start_time":"0846","insp_end_time":"0907","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":"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":"2026-02-23 21:39: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":"16177601","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2026-02-23 21:39:00","snet_input_date":"2026-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-23 21:39:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2026-02-26T10:37:02.000000Z","updated_at":"2026-03-06T10:31:03.000000Z","inspection_violations":[{"id":18797011,"change_date":"2026-02-23 21:39:00","inspection_id":"87119386","insp_violation_id":"271971517","seq_no":"1","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"211774954","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-26T10:51:08.000000Z","updated_at":"2026-03-06T10:42:04.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":19139692,"change_date":"2026-02-23 21:39:00","inspection_id":"87119386","insp_unit_id":"211774954","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56207Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK2KH483647","insp_unit_decal":"Y","insp_unit_decal_number":"35879320","created_at":"2026-02-26T10:12:17.000000Z","updated_at":"2026-03-06T10:03:54.000000Z"}]},{"id":11098053,"change_date":"2026-02-10 21:39:00","inspection_id":"87009993","dot_number":"2672795","report_state":"CA","report_number":"NCNG009842","insp_date":"2026-02-05 00:00:00","insp_start_time":"0933","insp_end_time":"0956","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-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":"16164283","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2026-02-10 21:39:00","snet_input_date":"2026-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-10 21:39:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2026-02-13T10:37:57.000000Z","updated_at":"2026-02-21T10:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18925831,"change_date":"2026-02-10 21:39:00","inspection_id":"87009993","insp_unit_id":"211549597","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"10419D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACWDT0DHBU8571","insp_unit_decal":"Y","insp_unit_decal_number":"35880345","created_at":"2026-02-13T10:15:42.000000Z","updated_at":"2026-02-21T10:04:02.000000Z"}]},{"id":10591416,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","dot_number":"2672795","report_state":"CA","report_number":"NCCL007332","insp_date":"2026-01-06 00:00:00","insp_start_time":"1115","insp_end_time":"1155","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":"2026-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16120220","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2026-01-07 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-07 21:39:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2026-01-10T10:34:42.000000Z","updated_at":"2026-01-18T10:32:08.000000Z","inspection_violations":[{"id":17802871,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069756","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ01390","created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3939ALTSI"},{"id":17802872,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069757","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3939ALSLI"},{"id":17802873,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069758","seq_no":"3","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"39311A1LLPL"},{"id":17802874,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069759","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3939ALSML"},{"id":17802875,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069760","seq_no":"5","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ01390","created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3939ALCL"},{"id":17802876,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069761","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3939ALRLI"},{"id":17802877,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_violation_id":"271069762","seq_no":"7","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"210961541","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:06.000000Z","updated_at":"2026-01-18T10:32:46.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":17754112,"change_date":"2026-01-07 21:39:00","inspection_id":"86730248","insp_unit_id":"210961541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"417WHT2X","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:12.000000Z","updated_at":"2026-01-18T10:01:40.000000Z"}]},{"id":9774034,"change_date":"2025-09-24 21:42:00","inspection_id":"85872034","dot_number":"2672795","report_state":"CA","report_number":"UD8N004466","insp_date":"2025-09-24 00:00:00","insp_start_time":"0800","insp_end_time":"0830","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":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15993832","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-09-26T10:01:20.000000Z","updated_at":"2025-09-28T10:00:55.000000Z","inspection_violations":[{"id":16066054,"change_date":"2025-09-24 21:42:00","inspection_id":"85872034","insp_violation_id":"268909393","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209133906","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA785364","created_at":"2025-09-27T10:17:15.000000Z","updated_at":"2025-09-28T10:16:31.000000Z","normalized_code":"3922SLLSR"},{"id":16066055,"change_date":"2025-09-24 21:42:00","inspection_id":"85872034","insp_violation_id":"268909394","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209133906","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:15.000000Z","updated_at":"2025-09-28T10:16:31.000000Z","normalized_code":"3922SLLSOA"},{"id":16066056,"change_date":"2025-09-24 21:42:00","inspection_id":"85872034","insp_violation_id":"268909395","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209133906","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:15.000000Z","updated_at":"2025-09-28T10:16:31.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":16192317,"change_date":"2025-09-24 21:42:00","inspection_id":"85872034","insp_unit_id":"209133906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"56207Z2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTKHPVK2KH483647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:27.000000Z"}]},{"id":9794931,"change_date":"2025-09-26 21:40:00","inspection_id":"85894013","dot_number":"2672795","report_state":"CA","report_number":"NARW003772","insp_date":"2025-09-23 00:00:00","insp_start_time":"1255","insp_end_time":"1308","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15995644","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-09-30T10:01:12.000000Z","updated_at":"2025-09-30T10:01:12.000000Z","inspection_violations":[{"id":16108782,"change_date":"2025-09-26 21:40:00","inspection_id":"85894013","insp_violation_id":"268957356","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"209177865","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"3922SLLSOA"},{"id":16108783,"change_date":"2025-09-26 21:40:00","inspection_id":"85894013","insp_violation_id":"268957357","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209177865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"3939ALHLI"},{"id":16108784,"change_date":"2025-09-26 21:40:00","inspection_id":"85894013","insp_violation_id":"268957358","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209177865","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:56.000000Z","updated_at":"2025-09-30T10:16:56.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":16232819,"change_date":"2025-09-26 21:40:00","inspection_id":"85894013","insp_unit_id":"209177865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"417\/WHT2X","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:53.000000Z","updated_at":"2025-09-30T09:46:01.000000Z"}]},{"id":8139210,"change_date":"2025-03-17 21:41:00","inspection_id":"84150478","dot_number":"2672795","report_state":"CA","report_number":"NEEU002971","insp_date":"2025-03-14 00:00:00","insp_start_time":"1100","insp_end_time":"1108","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-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15742229","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2025-03-17 21:41:00","snet_input_date":"2025-03-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-17 21:41:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-21T10:25:03.000000Z","updated_at":"2025-03-21T10:25:03.000000Z","inspection_violations":[{"id":12733952,"change_date":"2025-03-17 21:41:00","inspection_id":"84150478","insp_violation_id":"265090660","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205846242","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:50:04.000000Z","updated_at":"2025-03-21T10:59:47.000000Z","normalized_code":"3922SLLSR"},{"id":12733953,"change_date":"2025-03-17 21:41:00","inspection_id":"84150478","insp_violation_id":"265090661","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"205846242","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:50:04.000000Z","updated_at":"2025-03-21T10:59:47.000000Z","normalized_code":"39021TB2DOT"},{"id":12733954,"change_date":"2025-03-17 21:41:00","inspection_id":"84150478","insp_violation_id":"265090662","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205846242","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:50:04.000000Z","updated_at":"2025-03-21T10:59:47.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13143983,"change_date":"2025-03-17 21:41:00","inspection_id":"84150478","insp_unit_id":"205846242","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHT","insp_unit_license":"86814H2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDUF5GT7JEB69574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:59:16.000000Z","updated_at":"2025-03-21T10:11:21.000000Z"}]},{"id":8048121,"change_date":"2025-03-06 21:40:00","inspection_id":"84054283","dot_number":"2672795","report_state":"CA","report_number":"NE7S004408","insp_date":"2025-03-05 00:00:00","insp_start_time":"1350","insp_end_time":"1419","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15730311","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2025-03-06 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-06 21:40:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T21:05:24.000000Z","updated_at":"2025-03-17T21:05:24.000000Z","inspection_violations":[{"id":12578285,"change_date":"2025-03-06 21:40:00","inspection_id":"84054283","insp_violation_id":"264879157","seq_no":"1","part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:07:28.000000Z","updated_at":"2025-03-17T22:07:28.000000Z","normalized_code":"39111B5LNCDLNVL"},{"id":12578286,"change_date":"2025-03-06 21:40:00","inspection_id":"84054283","insp_violation_id":"264879158","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205668273","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:28.000000Z","updated_at":"2025-03-17T22:07:28.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12993487,"change_date":"2025-03-06 21:40:00","inspection_id":"84054283","insp_unit_id":"205668273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:32.000000Z","updated_at":"2025-03-17T23:58:32.000000Z"}]},{"id":7631915,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","dot_number":"2672795","report_state":"CA","report_number":"NE7S004188","insp_date":"2025-01-13 00:00:00","insp_start_time":"1310","insp_end_time":"1340","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-01-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15663897","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T20:56:33.000000Z","updated_at":"2025-03-17T20:56:33.000000Z","inspection_violations":[{"id":11927001,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","insp_violation_id":"264024189","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3922SLLDL"},{"id":11927002,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","insp_violation_id":"264024190","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204858586","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"39360D"},{"id":11927003,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","insp_violation_id":"264024191","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204858586","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3922SLLSR"},{"id":11927004,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","insp_violation_id":"264024192","seq_no":"4","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"204858586","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA672588","created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":12314614,"change_date":"2025-01-15 21:42:00","inspection_id":"83617243","insp_unit_id":"204858586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":6235180,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","dot_number":"2672795","report_state":"CA","report_number":"UE5M003762","insp_date":"2024-07-10 00:00:00","insp_start_time":"1030","insp_end_time":"1110","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15440034","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2024-07-16 21:44:00","snet_input_date":"2024-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-07-16 21:44:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T20:26:14.000000Z","updated_at":"2025-03-17T20:26:14.000000Z","inspection_violations":[{"id":9685696,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679592","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ35506","created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"39111B5"},{"id":9685697,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679593","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201918764","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35507","created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"3922"},{"id":9685698,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679594","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201918764","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ35507","created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"39360D"},{"id":9685699,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679595","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201918764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"3939A"},{"id":9685700,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679596","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201918764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"3939A"},{"id":9685701,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_violation_id":"260679597","seq_no":"6","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"201918764","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:53.000000Z","updated_at":"2025-03-17T21:52:53.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10046121,"change_date":"2024-07-16 21:44:00","inspection_id":"82135392","insp_unit_id":"201918764","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:06.000000Z","updated_at":"2025-03-17T23:27:06.000000Z"}]},{"id":6041910,"change_date":"2024-06-20 21:44:00","inspection_id":"81927678","dot_number":"2672795","report_state":"CA","report_number":"UE1B001097","insp_date":"2024-06-20 00:00:00","insp_start_time":"0705","insp_end_time":"0723","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"W\/OF SFOBB TP","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15413896","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2024-06-20 21:44:00","snet_input_date":"2024-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-20 21:44:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T20:22:34.000000Z","updated_at":"2025-03-17T20:22:34.000000Z","inspection_violations":[{"id":9371655,"change_date":"2024-06-20 21:44:00","inspection_id":"81927678","insp_violation_id":"260221785","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LB 75212","created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3922"},{"id":9371656,"change_date":"2024-06-20 21:44:00","inspection_id":"81927678","insp_violation_id":"260221786","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201516322","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW 078289","created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9731158,"change_date":"2024-06-20 21:44:00","inspection_id":"81927678","insp_unit_id":"201516322","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2XWHIFB","insp_unit_license":"10419D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACWDT0DHBU8571","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:50.000000Z","updated_at":"2025-03-17T23:23:50.000000Z"}]},{"id":4749525,"change_date":"2024-01-02 21:44:00","inspection_id":"80519277","dot_number":"2672795","report_state":"CA","report_number":"NE7S002688","insp_date":"2023-12-28 00:00:00","insp_start_time":"0855","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15184902","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2024-01-02 21:44:00","snet_input_date":"2023-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-02 21:44:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T19:56:53.000000Z","updated_at":"2025-03-17T19:56:53.000000Z","inspection_violations":[{"id":7330536,"change_date":"2024-01-02 21:44:00","inspection_id":"80519277","insp_violation_id":"257150821","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"198776170","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW 953255","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39345"},{"id":7330537,"change_date":"2024-01-02 21:44:00","inspection_id":"80519277","insp_violation_id":"257150822","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"198776170","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":7640457,"change_date":"2024-01-02 21:44:00","inspection_id":"80519277","insp_unit_id":"198776170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"WHITE\/2AX","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","insp_unit_decal":"Y","insp_unit_decal_number":"33213109","created_at":"2025-03-17T23:04:19.000000Z","updated_at":"2025-03-17T23:04:19.000000Z"}]},{"id":4265960,"change_date":"2023-10-23 21:42:00","inspection_id":"79987529","dot_number":"2672795","report_state":"CA","report_number":"NCCL005193","insp_date":"2023-10-17 00:00:00","insp_start_time":"1035","insp_end_time":"1105","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-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15106900","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T19:47:25.000000Z","updated_at":"2025-03-17T19:47:25.000000Z","inspection_violations":[{"id":6599646,"change_date":"2023-10-23 21:42:00","inspection_id":"79987529","insp_violation_id":"255999344","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197706865","insp_violation_category_id":"30","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":"39021TB"},{"id":6599647,"change_date":"2023-10-23 21:42:00","inspection_id":"79987529","insp_violation_id":"255999345","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197706865","insp_violation_category_id":"30","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":"3963A1"}],"inspection_per_units":[{"id":6860829,"change_date":"2023-10-23 21:42:00","inspection_id":"79987529","insp_unit_id":"197706865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"417WHT2X","insp_unit_license":"47590D3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HAMMMML5GL740542","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":1977686,"change_date":"2022-12-19 21:41:00","inspection_id":"77406663","dot_number":"2672795","report_state":"CA","report_number":"NE7S001607","insp_date":"2022-12-13 00:00:00","insp_start_time":"1028","insp_end_time":"1109","registration_date":null,"region":"PT","ci_status_code":"C","location":"370","location_desc":"OAKLAND AREA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-19 21:41: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":"14713436","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02672795","upload_search_indicator":null,"census_search_date":"2022-12-19 21:41:00","snet_input_date":"2022-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-19 21:41:00","insp_carrier_name":"BAY CITY MECHANICAL INC","insp_carrier_street":"543 SOUTH 31ST ST","insp_carrier_city":"RICHMOND","insp_carrier_state":"CA","insp_carrier_zip_code":"94804","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"158913","created_at":"2025-03-17T19:02:59.000000Z","updated_at":"2025-03-17T19:02:59.000000Z","inspection_violations":[{"id":3071548,"change_date":"2022-12-19 21:41:00","inspection_id":"77406663","insp_violation_id":"250175389","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192495837","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3939A"},{"id":3071549,"change_date":"2022-12-19 21:41:00","inspection_id":"77406663","insp_violation_id":"250175390","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192495837","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3182279,"change_date":"2022-12-19 21:41:00","inspection_id":"77406663","insp_unit_id":"192495837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHITE\/2AX","insp_unit_license":"10419D2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVACWDT0DHBU8571","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:48.000000Z","updated_at":"2025-03-17T22:28:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2672795\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2672795\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2672795\/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\/2672795\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}