{"current_page":1,"data":[{"id":12717970,"change_date":"2026-08-13 21:43:00","inspection_id":"88693398","dot_number":"1715438","report_state":"MI","report_number":"LEONP00781","insp_date":"2026-08-13 00:00:00","insp_start_time":"1605","insp_end_time":"1619","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"159","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"U","pen_cen_match":"I","final_status_date":"2026-08-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"39100","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3979402","transaction_code":"A","transaction_date":"2026-08-13 00:00:00","upload_date":"2026-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2026-08-13 21:43:00","snet_input_date":"2026-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-13 21:43:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-16T09:41:07.000000Z","updated_at":"2026-08-24T09:31:25.000000Z","inspection_violations":[{"id":22141483,"change_date":"2026-08-13 21:43:00","inspection_id":"88693398","insp_violation_id":"276113677","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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":"2026-08-16T10:00:51.000000Z","updated_at":"2026-08-24T09:41:54.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":22071221,"change_date":"2026-08-13 21:43:00","inspection_id":"88693398","insp_unit_id":"215142778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BC47292","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GB4KYCG1HF204063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-16T09:20:19.000000Z","updated_at":"2026-08-24T09:03:24.000000Z"},{"id":22071222,"change_date":"2026-08-13 21:43:00","inspection_id":"88693398","insp_unit_id":"215142779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TR","insp_unit_company":null,"insp_unit_license":"F318876","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4P53H4521P1398532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-16T09:20:19.000000Z","updated_at":"2026-08-24T09:03:24.000000Z"}]},{"id":11591890,"change_date":"2026-04-07 21:39:00","inspection_id":"87512660","dot_number":"1715438","report_state":"MI","report_number":"MALIK03613","insp_date":"2026-04-07 00:00:00","insp_start_time":"0755","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 18 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"2026-04-07 21:39: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":"1265265","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2026-04-07 21:39:00","snet_input_date":"2026-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-07 21:39:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:41:34.000000Z","updated_at":"2026-04-17T09:55:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19868517,"change_date":"2026-04-07 21:39:00","inspection_id":"87512660","insp_unit_id":"212587526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"223","insp_unit_license":"BC3116","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"54DC4W1B5HS807789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:18:28.000000Z","updated_at":"2026-04-18T09:31:12.000000Z"}]},{"id":9402976,"change_date":"2025-08-13 21:39:00","inspection_id":"85482556","dot_number":"1715438","report_state":"MI","report_number":"MALIK03193","insp_date":"2025-08-13 00:00:00","insp_start_time":"0700","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235894","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-16T10:01:24.000000Z","updated_at":"2025-08-17T10:00:45.000000Z","inspection_violations":[{"id":15291226,"change_date":"2025-08-13 21:39:00","inspection_id":"85482556","insp_violation_id":"268006833","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-16T10:45:09.000000Z","updated_at":"2025-08-17T10:44:28.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":15497269,"change_date":"2025-08-13 21:39:00","inspection_id":"85482556","insp_unit_id":"208379572","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"124","insp_unit_license":"BD02269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYCY1EDFV2333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:39.000000Z","updated_at":"2025-08-17T09:45:54.000000Z"}]},{"id":9323036,"change_date":"2025-08-04 21:39:00","inspection_id":"85398657","dot_number":"1715438","report_state":"MI","report_number":"MYERD01527","insp_date":"2025-07-30 00:00:00","insp_start_time":"1030","insp_end_time":"1052","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 W @ 110 MM","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233445","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:44.000000Z","inspection_violations":[{"id":15127969,"change_date":"2025-08-04 21:39:00","inspection_id":"85398657","insp_violation_id":"267824105","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":"2025-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:52.000000Z","normalized_code":"39141APC"},{"id":15127970,"change_date":"2025-08-04 21:39:00","inspection_id":"85398657","insp_violation_id":"267824106","seq_no":"2","part_no":"392","part_no_section":"2-SLL","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-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:52.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":15353865,"change_date":"2025-08-04 21:39:00","inspection_id":"85398657","insp_unit_id":"208225508","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC35431","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEDV0FSGB7470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:54.000000Z"},{"id":15353866,"change_date":"2025-08-04 21:39:00","inspection_id":"85398657","insp_unit_id":"208225509","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PENSK","insp_unit_company":null,"insp_unit_license":"F019828","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TB123327CM863851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:54.000000Z"}]},{"id":8513126,"change_date":"2025-04-30 21:52:00","inspection_id":"84544202","dot_number":"1715438","report_state":"MI","report_number":"MALIK02973","insp_date":"2025-04-30 00:00:00","insp_start_time":"0710","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"11200","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":"1219792","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:21.000000Z","inspection_violations":[{"id":13475849,"change_date":"2025-04-30 21:52:00","inspection_id":"84544202","insp_violation_id":"265930076","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:48.000000Z","normalized_code":"3922SLLS2"},{"id":13475850,"change_date":"2025-04-30 21:52:00","inspection_id":"84544202","insp_violation_id":"265930077","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:48.000000Z","normalized_code":"3922SLLSIV"},{"id":13475851,"change_date":"2025-04-30 21:52:00","inspection_id":"84544202","insp_violation_id":"265930078","seq_no":"3","part_no":"391","part_no_section":"41A","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":"2025-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:48.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":13839163,"change_date":"2025-04-30 21:52:00","inspection_id":"84544202","insp_unit_id":"206576264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"232","insp_unit_license":"BC87718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDWF36S54EC74138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":7982636,"change_date":"2025-02-27 21:41:00","inspection_id":"83985497","dot_number":"1715438","report_state":"MI","report_number":"MALIK02843","insp_date":"2025-02-26 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211508","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:02.000000Z","updated_at":"2025-03-17T21:04:02.000000Z","inspection_violations":[{"id":12472402,"change_date":"2025-02-27 21:41:00","inspection_id":"83985497","insp_violation_id":"264742080","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":12886726,"change_date":"2025-02-27 21:41:00","inspection_id":"83985497","insp_unit_id":"205542147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"139","insp_unit_license":"BD78193","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMSAAR67H453097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"}]},{"id":7749272,"change_date":"2025-01-30 21:41:00","inspection_id":"83740443","dot_number":"1715438","report_state":"MI","report_number":"MALIK02807","insp_date":"2025-01-30 00:00:00","insp_start_time":"0855","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"2025-01-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1208290","transaction_code":"A","transaction_date":"2025-01-30 00:00:00","upload_date":"2025-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2025-01-30 21:41:00","snet_input_date":"2025-01-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-30 21:41:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:08.000000Z","updated_at":"2025-03-17T20:59:08.000000Z","inspection_violations":[{"id":12108420,"change_date":"2025-01-30 21:41:00","inspection_id":"83740443","insp_violation_id":"264259703","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","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:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":12505603,"change_date":"2025-01-30 21:41:00","inspection_id":"83740443","insp_unit_id":"205085096","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"223","insp_unit_license":"BC1116","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"54DC4W1B5HS807789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"}]},{"id":7174358,"change_date":"2024-11-12 21:42:00","inspection_id":"83135743","dot_number":"1715438","report_state":"MI","report_number":"MALIK02674","insp_date":"2024-11-06 00:00:00","insp_start_time":"1505","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","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-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1200585","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11208457,"change_date":"2024-11-12 21:42:00","inspection_id":"83135743","insp_violation_id":"262848331","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11571969,"change_date":"2024-11-12 21:42:00","inspection_id":"83135743","insp_unit_id":"203841537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"131","insp_unit_license":"BD46051","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEBG6GSHM9210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11571970,"change_date":"2024-11-12 21:42:00","inspection_id":"83135743","insp_unit_id":"203841538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITTS","insp_unit_company":"NONE","insp_unit_license":"E221824","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JYDF533XFE151444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":7014178,"change_date":"2024-10-22 21:41:00","inspection_id":"82965890","dot_number":"1715438","report_state":"MI","report_number":"MALIK02637","insp_date":"2024-10-21 00:00:00","insp_start_time":"1140","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B VAN DYKE AVE @ 17 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","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-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198861","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[{"id":10944449,"change_date":"2024-10-22 21:41:00","inspection_id":"82965890","insp_violation_id":"262484658","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-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11313240,"change_date":"2024-10-22 21:41:00","inspection_id":"82965890","insp_unit_id":"203524673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"117","insp_unit_license":"BC31196","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWGAAR15J007777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:08.000000Z","updated_at":"2025-03-17T23:40:08.000000Z"}]},{"id":6990210,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","dot_number":"1715438","report_state":"MI","report_number":"BARTT04631","insp_date":"2024-10-16 00:00:00","insp_start_time":"0945","insp_end_time":"1012","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@BURT","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","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-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198470","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":10904658,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","insp_violation_id":"262428155","seq_no":"1","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-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"38323A2LCDLN"},{"id":10904659,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","insp_violation_id":"262428156","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"203475525","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"39311A1CSLRR"},{"id":10904660,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","insp_violation_id":"262428157","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203475525","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"3922RG"},{"id":10904661,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","insp_violation_id":"262428158","seq_no":"4","part_no":"392","part_no_section":"2-MCSR","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-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"3922MCSR"}],"inspection_per_units":[{"id":11274687,"change_date":"2024-10-18 21:42:00","inspection_id":"82940441","insp_unit_id":"203475525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"NONE","insp_unit_license":"BD49943","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALAV95PU45691","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6749115,"change_date":"2024-09-17 21:45:00","inspection_id":"82683717","dot_number":"1715438","report_state":"MI","report_number":"GRAHA00732","insp_date":"2024-09-16 00:00:00","insp_start_time":"1739","insp_end_time":"1805","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I94 W\/B @ WELCOME CENTER","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-17 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"16900","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195288","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-09-17 21:45:00","snet_input_date":"2024-09-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-17 21:45:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:56.000000Z","updated_at":"2025-03-17T20:36:56.000000Z","inspection_violations":[{"id":10508904,"change_date":"2024-09-17 21:45:00","inspection_id":"82683717","insp_violation_id":"261862993","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4430309","created_at":"2025-03-17T21:56:53.000000Z","updated_at":"2025-03-17T21:56:53.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":10882969,"change_date":"2024-09-17 21:45:00","inspection_id":"82683717","insp_unit_id":"202978375","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"228","insp_unit_license":"BC90143","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC1KUEG4JF226567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"},{"id":10882970,"change_date":"2024-09-17 21:45:00","inspection_id":"82683717","insp_unit_id":"202978376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"436","insp_unit_license":"E698971","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7HB21142XN1902250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"}]},{"id":6548769,"change_date":"2024-09-17 21:45:00","inspection_id":"82470562","dot_number":"1715438","report_state":"MI","report_number":"KLEIN03578","insp_date":"2024-08-23 00:00:00","insp_start_time":"0935","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"OSHTEMO REST AREA","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA 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":"N","pen_cen_match":null,"final_status_date":"2024-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1191551","transaction_code":"C","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-08-23 21:41:00","snet_input_date":"2024-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-23 21:41:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:47.000000Z","updated_at":"2025-03-17T20:32:47.000000Z","inspection_violations":[{"id":10174556,"change_date":"2024-09-17 21:45:00","inspection_id":"82470562","insp_violation_id":"261866173","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202980819","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"39021TB"},{"id":10174557,"change_date":"2024-09-17 21:45:00","inspection_id":"82470562","insp_violation_id":"261866174","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","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":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":10557160,"change_date":"2024-09-17 21:45:00","inspection_id":"82470562","insp_unit_id":"202980819","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD78193","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMSAAR67H453097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:21.000000Z","updated_at":"2025-03-17T23:32:21.000000Z"}]},{"id":6516268,"change_date":"2024-09-17 21:45:00","inspection_id":"82435990","dot_number":"1715438","report_state":"MI","report_number":"MALIK02537","insp_date":"2024-08-19 00:00:00","insp_start_time":"0805","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1190733","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10120732,"change_date":"2024-09-17 21:45:00","inspection_id":"82435990","insp_violation_id":"261868296","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:00.000000Z","updated_at":"2025-03-17T21:55:00.000000Z","normalized_code":"3922"},{"id":10120733,"change_date":"2024-09-17 21:45:00","inspection_id":"82435990","insp_violation_id":"261868297","seq_no":"2","part_no":"392","part_no_section":"2","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-17T21:55:00.000000Z","updated_at":"2025-03-17T21:55:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10504575,"change_date":"2024-09-17 21:45:00","inspection_id":"82435990","insp_unit_id":"202982253","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"NONE","insp_unit_license":"BC31116","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"54DC4W1B5HS807789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:48.000000Z","updated_at":"2025-03-17T23:31:48.000000Z"}]},{"id":5885825,"change_date":"2024-05-31 21:39:00","inspection_id":"81758140","dot_number":"1715438","report_state":"MI","report_number":"WARRJ02568","insp_date":"2024-05-30 00:00:00","insp_start_time":"1820","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1180382","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9125244,"change_date":"2024-05-31 21:39:00","inspection_id":"81758140","insp_violation_id":"259835651","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9479795,"change_date":"2024-05-31 21:39:00","inspection_id":"81758140","insp_unit_id":"201175438","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC09075","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK39DAG7660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"},{"id":9479796,"change_date":"2024-05-31 21:39:00","inspection_id":"81758140","insp_unit_id":"201175439","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLAR","insp_unit_company":"425","insp_unit_license":"F019830","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C9BCM289BB092060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":4774561,"change_date":"2024-01-05 21:46:00","inspection_id":"80546685","dot_number":"1715438","report_state":"MI","report_number":"MALIK02115","insp_date":"2024-01-04 00:00:00","insp_start_time":"0715","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 23 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","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-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"37950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159476","transaction_code":"A","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2024-01-05 21:46:00","snet_input_date":"2024-01-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[{"id":7367473,"change_date":"2024-01-05 21:46:00","inspection_id":"80546685","insp_violation_id":"257212513","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7680989,"change_date":"2024-01-05 21:46:00","inspection_id":"80546685","insp_unit_id":"198838323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"225","insp_unit_license":"BC49783","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAW56P77EB26286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"},{"id":7680990,"change_date":"2024-01-05 21:46:00","inspection_id":"80546685","insp_unit_id":"198838324","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ","insp_unit_company":"NONE","insp_unit_license":"E858285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4P53H4521P1398532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"}]},{"id":4022651,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","dot_number":"1715438","report_state":"MI","report_number":"PATTM04423","insp_date":"2023-09-20 00:00:00","insp_start_time":"0835","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"290","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":"Y","pen_cen_match":null,"final_status_date":"2023-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1146854","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:22.000000Z","updated_at":"2025-03-17T19:42:22.000000Z","inspection_violations":[{"id":6225725,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398097","seq_no":"1","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"393104F3"},{"id":6225726,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398098","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3922"},{"id":6225727,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398099","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3939A"},{"id":6225728,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398100","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39347E"},{"id":6225729,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398101","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39353B"},{"id":6225730,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398102","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39347E"},{"id":6225731,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_violation_id":"255398103","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197164732","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6467980,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_unit_id":"197164731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"BD46053","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FWYHWDB6YAF71909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:17.000000Z","updated_at":"2025-03-17T22:54:17.000000Z"},{"id":6467981,"change_date":"2023-09-21 21:40:00","inspection_id":"79717864","insp_unit_id":"197164732","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DYNW","insp_unit_company":null,"insp_unit_license":"C487865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4U181DHX1W1X36066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:17.000000Z","updated_at":"2025-03-17T22:54:17.000000Z"}]},{"id":3858918,"change_date":"2023-08-29 21:42:00","inspection_id":"79535926","dot_number":"1715438","report_state":"MI","report_number":"MALIK01944","insp_date":"2023-08-29 00:00:00","insp_start_time":"0835","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B M-53 @ 32 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143234","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5960382,"change_date":"2023-08-29 21:42:00","inspection_id":"79535926","insp_violation_id":"254954242","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"},{"id":5960383,"change_date":"2023-08-29 21:42:00","inspection_id":"79535926","insp_violation_id":"254954243","seq_no":"2","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":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":6203972,"change_date":"2023-08-29 21:42:00","inspection_id":"79535926","insp_unit_id":"196789311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"118","insp_unit_license":"BC35431","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEDV0FSGB7470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3404752,"change_date":"2023-06-29 21:43:00","inspection_id":"79027171","dot_number":"1715438","report_state":"MI","report_number":"WARRJ02190","insp_date":"2023-06-28 00:00:00","insp_start_time":"1710","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1132734","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2023-06-29 21:43:00","snet_input_date":"2023-06-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-29 21:43:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:33.000000Z","updated_at":"2025-03-17T19:30:33.000000Z","inspection_violations":[{"id":5248691,"change_date":"2023-06-29 21:43:00","inspection_id":"79027171","insp_violation_id":"253796292","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:22.000000Z","updated_at":"2025-03-17T21:31:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5474108,"change_date":"2023-06-29 21:43:00","inspection_id":"79027171","insp_unit_id":"195763413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"113","insp_unit_license":"BC95695","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSCUAPR5BJ265433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"},{"id":5474109,"change_date":"2023-06-29 21:43:00","inspection_id":"79027171","insp_unit_id":"195763414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DYNW","insp_unit_company":"407","insp_unit_license":"C487865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4U181DHX1W1X36066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:10.000000Z","updated_at":"2025-03-17T22:46:10.000000Z"}]},{"id":3023512,"change_date":"2023-05-11 21:42:00","inspection_id":"78597309","dot_number":"1715438","report_state":"MI","report_number":"LINEM00415","insp_date":"2023-05-09 00:00:00","insp_start_time":"0845","insp_end_time":"0923","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"2023-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125564","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4643472,"change_date":"2023-05-11 21:42:00","inspection_id":"78597309","insp_violation_id":"252774696","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3958A1"},{"id":4643473,"change_date":"2023-05-11 21:42:00","inspection_id":"78597309","insp_violation_id":"252774697","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"},{"id":4643474,"change_date":"2023-05-11 21:42:00","inspection_id":"78597309","insp_violation_id":"252774698","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194881620","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4864227,"change_date":"2023-05-11 21:42:00","inspection_id":"78597309","insp_unit_id":"194881620","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"127","insp_unit_license":"BD17796","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXCY9GHHM8836","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":1486980,"change_date":"2022-10-11 21:41:00","inspection_id":"76843682","dot_number":"1715438","report_state":"MI","report_number":"BACZM01667","insp_date":"2022-10-10 00:00:00","insp_start_time":"0925","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","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-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097948","transaction_code":"A","transaction_date":"2022-10-10 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:07.000000Z","updated_at":"2025-03-17T18:54:07.000000Z","inspection_violations":[{"id":2339725,"change_date":"2022-10-11 21:41:00","inspection_id":"76843682","insp_violation_id":"248951459","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2392782,"change_date":"2022-10-11 21:41:00","inspection_id":"76843682","insp_unit_id":"191374731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"117","insp_unit_license":"BC31196","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTWGAAR15J007777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:23.000000Z","updated_at":"2025-03-17T22:23:23.000000Z"}]},{"id":1466842,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","dot_number":"1715438","report_state":"MI","report_number":"BRADD00785","insp_date":"2022-10-06 00:00:00","insp_start_time":"2010","insp_end_time":"2115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","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-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097652","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310156,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899987","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39378"},{"id":2310157,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899988","seq_no":"2","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4126682","created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"393100B"},{"id":2310158,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899989","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3939A"},{"id":2310159,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899990","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3939A"},{"id":2310160,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899991","seq_no":"5","part_no":"393","part_no_section":"112","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"393112"},{"id":2310161,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_violation_id":"248899992","seq_no":"6","part_no":"390","part_no_section":"19(a)(1)","insp_viol_unit":"1","insp_unit_id":"191329596","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"39019A1"}],"inspection_per_units":[{"id":2361509,"change_date":"2022-10-07 21:39:00","inspection_id":"76820286","insp_unit_id":"191329596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"124","insp_unit_license":"BD02269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYCY1EDFV2333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":460170,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","dot_number":"1715438","report_state":"MI","report_number":"MALIK01061","insp_date":"2022-05-20 00:00:00","insp_start_time":"0655","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 27 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":"2022-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"42950","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":"1076478","transaction_code":"C","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01715438","upload_search_indicator":null,"census_search_date":"2022-05-23 21:42:00","snet_input_date":"2022-05-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-23 21:42:00","insp_carrier_name":"SMITH'S WATERPROOFING LLC","insp_carrier_street":"3821 VAN DYKE","insp_carrier_city":"ALMONT","insp_carrier_state":"MI","insp_carrier_zip_code":"48003","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:55.000000Z","updated_at":"2025-03-17T18:35:55.000000Z","inspection_violations":[{"id":728705,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_violation_id":"246338391","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189149472","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"39395A"},{"id":728706,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_violation_id":"246338392","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189149472","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"39395F"},{"id":728707,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_violation_id":"246338393","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189149472","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"3939A"},{"id":728708,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_violation_id":"246338394","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189149473","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":741324,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_unit_id":"189149472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"225","insp_unit_license":"BC49783","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAW56P77EB26286","insp_unit_decal":"Y","insp_unit_decal_number":"31293195","created_at":"2025-03-17T22:12:46.000000Z","updated_at":"2025-03-17T22:12:46.000000Z"},{"id":741325,"change_date":"2022-06-09 21:42:00","inspection_id":"75641805","insp_unit_id":"189149473","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ TR","insp_unit_company":"002","insp_unit_license":"N\/A","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4P5LY3228E3007456","insp_unit_decal":"Y","insp_unit_decal_number":"31293196","created_at":"2025-03-17T22:12:46.000000Z","updated_at":"2025-03-17T22:12:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1715438\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1715438\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1715438\/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\/1715438\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}