{"current_page":1,"data":[{"id":12061743,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","dot_number":"1864132","report_state":"MI","report_number":"ETPJN02303","insp_date":"2026-05-31 00:00:00","insp_start_time":"1219","insp_end_time":"1244","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"U","pen_cen_match":"I","final_status_date":"2026-05-31 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"8","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3437047","transaction_code":"A","transaction_date":"2026-05-31 00:00:00","upload_date":"2026-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01864132","upload_search_indicator":null,"census_search_date":"2026-05-31 21:34:00","snet_input_date":"2026-05-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-31 21:34:00","insp_carrier_name":"DISCOVER PLUMBING INC","insp_carrier_street":"2436 AUBURN RD","insp_carrier_city":"SHELBY TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48317","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-03T09:39:39.000000Z","updated_at":"2026-06-11T09:30:24.000000Z","inspection_violations":[{"id":20987879,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604537","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"39141APC"},{"id":20987880,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604538","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"3958A1HOSP"},{"id":20987881,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604539","seq_no":"3","part_no":"392","part_no_section":"9AA2-OA","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"3929AA2OA"},{"id":20987883,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604541","seq_no":"5","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"39311A1LHLM"},{"id":20987884,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604542","seq_no":"6","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"39019TG"},{"id":20987885,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604543","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"39395F"},{"id":20987886,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604544","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"39617CPI"},{"id":20987882,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_violation_id":"274604540","seq_no":"4","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"213839830","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-03T09:56:56.000000Z","updated_at":"2026-06-11T09:40:11.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":20962705,"change_date":"2026-05-31 21:34:00","inspection_id":"88003449","insp_unit_id":"213839830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BC52009","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7GZ37TCG5JN003910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-03T09:15:20.000000Z","updated_at":"2026-06-11T09:01:22.000000Z"}]},{"id":7450426,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","dot_number":"1864132","report_state":"MI","report_number":"MALIK02732","insp_date":"2024-12-16 00:00:00","insp_start_time":"1345","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 12 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1204518","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01864132","upload_search_indicator":null,"census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"DISCOVER PLUMBING","insp_carrier_street":"2436 AUBURN RD","insp_carrier_city":"SHELBY TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48317","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:33.000000Z","updated_at":"2025-03-17T20:51:33.000000Z","inspection_violations":[{"id":11642121,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","insp_violation_id":"263546376","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922SLLSR"},{"id":11642122,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","insp_violation_id":"263546377","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"38323A2LCDLN"},{"id":11642123,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","insp_violation_id":"263546378","seq_no":"3","part_no":"391","part_no_section":"45A-MCEM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39145AMCEM"}],"inspection_per_units":[{"id":12019321,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","insp_unit_id":"204456584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"NONE","insp_unit_license":"BD15490","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKJPVK3NH083993","insp_unit_decal":"Y","insp_unit_decal_number":"33395925","created_at":"2025-03-17T23:47:40.000000Z","updated_at":"2025-03-17T23:47:40.000000Z"},{"id":12019322,"change_date":"2024-12-18 21:41:00","inspection_id":"83426690","insp_unit_id":"204456585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"QUAL","insp_unit_company":"NONE","insp_unit_license":"D809718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"550FD2028DS002780","insp_unit_decal":"Y","insp_unit_decal_number":"33395926","created_at":"2025-03-17T23:47:40.000000Z","updated_at":"2025-03-17T23:47:40.000000Z"}]},{"id":1821301,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","dot_number":"1864132","report_state":"MI","report_number":"CELMS00141","insp_date":"2022-11-28 00:00:00","insp_start_time":"0850","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W MAYBEE @ BALDWIN","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103437","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01864132","upload_search_indicator":null,"census_search_date":"2022-11-28 21:41:00","snet_input_date":"2022-11-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"DISCOVER PLUMBING","insp_carrier_street":"2436 AUBURN RD","insp_carrier_city":"SHELBY TWP","insp_carrier_state":"MI","insp_carrier_zip_code":"48317","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:18.000000Z","updated_at":"2025-03-17T19:00:18.000000Z","inspection_violations":[{"id":2844516,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800496","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4147394","created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"39141A"},{"id":2844517,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800497","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4147394","created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"38323A2"},{"id":2844518,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800498","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192143539","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"39617C"},{"id":2844519,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800499","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192143540","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"39617C"},{"id":2844520,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800500","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192143540","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"3939A"},{"id":2844521,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_violation_id":"249800501","seq_no":"6","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"192143540","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":2929953,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_unit_id":"192143539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"NONE","insp_unit_license":"BD15490","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKJPVK3NH083993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"},{"id":2929954,"change_date":"2022-11-28 21:41:00","inspection_id":"77227824","insp_unit_id":"192143540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"QUAL","insp_unit_company":"NONE","insp_unit_license":"D809718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"550FD2028DS002780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1864132\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1864132\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1864132\/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\/1864132\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}