{"current_page":1,"data":[{"id":12415101,"change_date":"2026-07-10 21:41:00","inspection_id":"88373316","dot_number":"2988150","report_state":"MI","report_number":"ROLLJ03139","insp_date":"2026-07-10 00:00:00","insp_start_time":"0847","insp_end_time":"0904","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"U","pen_cen_match":"I","final_status_date":"2026-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3725346","transaction_code":"A","transaction_date":"2026-07-10 00:00:00","upload_date":"2026-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-07-10 21:41:00","snet_input_date":"2026-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-10 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-14T09:40:36.000000Z","updated_at":"2026-07-21T09:30:56.000000Z","inspection_violations":[{"id":21609716,"change_date":"2026-07-10 21:41:00","inspection_id":"88373316","insp_violation_id":"275418978","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"214545126","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-14T10:00:05.000000Z","updated_at":"2026-07-21T09:44:23.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":21567360,"change_date":"2026-07-10 21:41:00","inspection_id":"88373316","insp_unit_id":"214545126","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"448","insp_unit_license":"BE69140","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE7TDF08325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:24.000000Z","updated_at":"2026-07-21T09:03:12.000000Z"}]},{"id":12298459,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","dot_number":"2988150","report_state":"MI","report_number":"BALLB05361","insp_date":"2026-06-26 00:00:00","insp_start_time":"1255","insp_end_time":"1357","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"YES","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":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3632820","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:13.000000Z","updated_at":"2026-07-08T09:30:41.000000Z","inspection_violations":[{"id":21405145,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_violation_id":"275162261","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"214319485","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:20.000000Z","normalized_code":"3965BL"},{"id":21405142,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_violation_id":"275162258","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","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":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:20.000000Z","normalized_code":"3922SLLEWA2"},{"id":21405143,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_violation_id":"275162259","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214319485","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4712832","created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:20.000000Z","normalized_code":"3922SLLSR"},{"id":21405144,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_violation_id":"275162260","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"214319485","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:20.000000Z","normalized_code":"39021TB2DOT"},{"id":21405146,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_violation_id":"275162262","seq_no":"5","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"214319485","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:34.000000Z","updated_at":"2026-07-08T09:41:20.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":21361569,"change_date":"2026-06-27 21:41:00","inspection_id":"88255375","insp_unit_id":"214319485","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"423","insp_unit_license":"BE22584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:30.000000Z","updated_at":"2026-07-08T09:01:54.000000Z"}]},{"id":12151094,"change_date":"2026-06-10 21:45:00","inspection_id":"88100274","dot_number":"2988150","report_state":"MI","report_number":"POWEL04353","insp_date":"2026-06-10 00:00:00","insp_start_time":"0710","insp_end_time":"0721","registration_date":null,"region":"ES","ci_status_code":"C","location":"122","location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","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":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:45: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":"3512943","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:32.000000Z","updated_at":"2026-06-21T09:31:32.000000Z","inspection_violations":[{"id":21147856,"change_date":"2026-06-10 21:45:00","inspection_id":"88100274","insp_violation_id":"274821204","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","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":"2026-06-13T10:02:46.000000Z","updated_at":"2026-06-21T09:45:57.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":21108137,"change_date":"2026-06-10 21:45:00","inspection_id":"88100274","insp_unit_id":"214019921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"28GKF2","insp_unit_license":"BE22451","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE1SDF10280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:00.000000Z","updated_at":"2026-06-21T09:02:45.000000Z"}]},{"id":12100664,"change_date":"2026-06-04 21:46:00","inspection_id":"88045110","dot_number":"2988150","report_state":"MI","report_number":"DAWDD04569","insp_date":"2026-06-04 00:00:00","insp_start_time":"1311","insp_end_time":"1358","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE WATER COMPANY LLC","shipping_paper_number":"06042026","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-06-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"3469585","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:58.000000Z","updated_at":"2026-06-16T09:32:04.000000Z","inspection_violations":[{"id":21058193,"change_date":"2026-06-04 21:46:00","inspection_id":"88045110","insp_violation_id":"274700546","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4695195","created_at":"2026-06-07T10:01:08.000000Z","updated_at":"2026-06-16T09:46:52.000000Z","normalized_code":"3922SLLEWA2"},{"id":21058194,"change_date":"2026-06-04 21:46:00","inspection_id":"88045110","insp_violation_id":"274700547","seq_no":"2","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":"2026-06-07T10:01:08.000000Z","updated_at":"2026-06-16T09:46:52.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21025160,"change_date":"2026-06-04 21:46:00","inspection_id":"88045110","insp_unit_id":"213918531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"410","insp_unit_license":"BC15676","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDPF7AY7JDF05775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:11.000000Z","updated_at":"2026-06-16T09:04:10.000000Z"}]},{"id":11993727,"change_date":"2026-05-22 21:38:00","inspection_id":"87931804","dot_number":"2988150","report_state":"MI","report_number":"DOWEM03320","insp_date":"2026-05-21 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"143","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":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38: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":"3383398","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:12.000000Z","updated_at":"2026-06-02T09:32:10.000000Z","inspection_violations":[{"id":20866183,"change_date":"2026-05-22 21:38:00","inspection_id":"87931804","insp_violation_id":"274443450","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":"2026-05-25T10:02:40.000000Z","updated_at":"2026-06-02T09:44:00.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20850298,"change_date":"2026-05-22 21:38:00","inspection_id":"87931804","insp_unit_id":"213705115","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"442","insp_unit_license":"BE02198","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE3SDF01273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:17.000000Z","updated_at":"2026-06-02T09:05:10.000000Z"}]},{"id":11908746,"change_date":"2026-05-14 21:42:00","inspection_id":"87847910","dot_number":"2988150","report_state":"MI","report_number":"EVANT03319","insp_date":"2026-05-14 00:00:00","insp_start_time":"1115","insp_end_time":"1145","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3323803","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:54.000000Z","updated_at":"2026-05-25T09:31:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20702927,"change_date":"2026-05-14 21:42:00","inspection_id":"87847910","insp_unit_id":"213551883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BE02198","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE3SDF01273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:50.000000Z","updated_at":"2026-05-25T09:03:54.000000Z"}]},{"id":11631699,"change_date":"2026-04-13 21:38:00","inspection_id":"87560391","dot_number":"2988150","report_state":"MI","report_number":"ROLLJ03018","insp_date":"2026-04-07 00:00:00","insp_start_time":"1316","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB LONDON DR @ WEST SILVER LAK","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"22500","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":"1265888","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-24T09:30:59.000000Z","updated_at":"2026-04-24T09:30:59.000000Z","inspection_violations":[{"id":20188362,"change_date":"2026-04-13 21:38:00","inspection_id":"87560391","insp_violation_id":"273563404","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-24T09:42:58.000000Z","updated_at":"2026-04-24T09:42:58.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20231726,"change_date":"2026-04-13 21:38:00","inspection_id":"87560391","insp_unit_id":"212986345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"441","insp_unit_license":"BE02197","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DEXSDF01271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:32.000000Z","updated_at":"2026-04-24T09:03:32.000000Z"}]},{"id":10611053,"change_date":"2026-01-13 21:39:00","inspection_id":"86750913","dot_number":"2988150","report_state":"MI","report_number":"KOCHJ02279","insp_date":"2026-01-09 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BAY PORT RD @ RUBY RD","county_code_state":"MI","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-09 21:39: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":"1256021","transaction_code":"C","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2026-01-09 21:39:00","snet_input_date":"2026-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-09 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:47.000000Z","updated_at":"2026-01-24T10:30:12.000000Z","inspection_violations":[{"id":17882083,"change_date":"2026-01-13 21:39:00","inspection_id":"86750913","insp_violation_id":"271167384","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-01-16T10:41:46.000000Z","updated_at":"2026-01-24T10:30:25.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":17830033,"change_date":"2026-01-13 21:39:00","inspection_id":"86750913","insp_unit_id":"211052232","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160041","insp_unit_license":"BD23337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT3HHHW0016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:38.000000Z"}]},{"id":10507541,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","dot_number":"2988150","report_state":"MI","report_number":"BACZM02944","insp_date":"2025-12-22 00:00:00","insp_start_time":"0947","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ MOUNT MORRIS RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1254484","transaction_code":"C","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:36.000000Z","updated_at":"2026-01-16T10:30:15.000000Z","inspection_violations":[{"id":17749899,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015455","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":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLS2"},{"id":17749900,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015456","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210914591","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"39347E"},{"id":17749901,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015457","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"210914591","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3963A1BOS"},{"id":17749902,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015458","seq_no":"4","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"210914591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3939AHLLH"},{"id":17749903,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015459","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210914591","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLSR"},{"id":17749904,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_violation_id":"271015460","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210914591","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4616669","created_at":"2026-01-08T10:38:00.000000Z","updated_at":"2026-01-16T10:30:33.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17705463,"change_date":"2026-01-05 21:37:00","inspection_id":"86642624","insp_unit_id":"210914591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"424","insp_unit_license":"BE22583","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X1NM160288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:20.000000Z"}]},{"id":10230717,"change_date":"2025-12-04 21:38:00","inspection_id":"86352900","dot_number":"2988150","report_state":"MI","report_number":"BACZM02907","insp_date":"2025-11-17 00:00:00","insp_start_time":"0845","insp_end_time":"0905","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":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250890","transaction_code":"C","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-11-18 21:39:00","snet_input_date":"2025-11-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-18 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:54.000000Z","updated_at":"2025-12-08T10:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17290954,"change_date":"2025-12-04 21:38:00","inspection_id":"86352900","insp_unit_id":"210413118","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB05386","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7XXFM440775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:43.000000Z"}]},{"id":10067558,"change_date":"2025-10-29 21:40:00","inspection_id":"86181227","dot_number":"2988150","report_state":"MI","report_number":"DAWDD04216","insp_date":"2025-10-28 00:00:00","insp_start_time":"0820","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT FARMINGTON","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE WATER COMPANY LLC","shipping_paper_number":"10282025","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-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248378","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-02T11:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16733840,"change_date":"2025-10-29 21:40:00","inspection_id":"86181227","insp_unit_id":"209720471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"160041","insp_unit_license":"BD23337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT3HHHW0016","insp_unit_decal":"Y","insp_unit_decal_number":"35768072","created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:30.000000Z"}]},{"id":10030666,"change_date":"2025-10-24 21:40:00","inspection_id":"86142411","dot_number":"2988150","report_state":"MI","report_number":"PEASS03009","insp_date":"2025-10-23 00:00:00","insp_start_time":"0925","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ SAFE ENFORCEMENT SIT","county_code_state":"MI","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247544","transaction_code":"A","transaction_date":"2025-10-23 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-10-24 21:40:00","snet_input_date":"2025-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-27T10:01:53.000000Z","updated_at":"2025-10-28T10:01:12.000000Z","inspection_violations":[{"id":16591404,"change_date":"2025-10-24 21:40:00","inspection_id":"86142411","insp_violation_id":"269504348","seq_no":"1","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"3958K2HOSP"},{"id":16591405,"change_date":"2025-10-24 21:40:00","inspection_id":"86142411","insp_violation_id":"269504349","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"209644832","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"3922SLLEWA1"},{"id":16591406,"change_date":"2025-10-24 21:40:00","inspection_id":"86142411","insp_violation_id":"269504350","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209644832","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4550260","created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:32.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16664426,"change_date":"2025-10-24 21:40:00","inspection_id":"86142411","insp_unit_id":"209644832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"442","insp_unit_license":"BE01298","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE3SDF01273","insp_unit_decal":"Y","insp_unit_decal_number":"35768344","created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:30.000000Z"}]},{"id":9770365,"change_date":"2025-09-24 21:42:00","inspection_id":"85868256","dot_number":"2988150","report_state":"MI","report_number":"DAWDD04161","insp_date":"2025-09-23 00:00:00","insp_start_time":"0805","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT OUTER DRIVE","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE WATER COMPANY LLC","shipping_paper_number":"09232025","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-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1242345","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:16.000000Z","updated_at":"2025-09-28T10:00:41.000000Z","inspection_violations":[{"id":16058994,"change_date":"2025-09-24 21:42:00","inspection_id":"85868256","insp_violation_id":"268900315","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-09-27T10:17:06.000000Z","updated_at":"2025-09-28T10:16:07.000000Z","normalized_code":"3922SLLSR"},{"id":16058995,"change_date":"2025-09-24 21:42:00","inspection_id":"85868256","insp_violation_id":"268900316","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","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-09-27T10:17:06.000000Z","updated_at":"2025-09-28T10:16:07.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":16186360,"change_date":"2025-09-24 21:42:00","inspection_id":"85868256","insp_unit_id":"209127034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"438","insp_unit_license":"RC45630","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDPF7AN0SDF00375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:10.000000Z"}]},{"id":9439486,"change_date":"2025-08-18 21:39:00","inspection_id":"85521145","dot_number":"2988150","report_state":"MI","report_number":"HARRK01562","insp_date":"2025-08-14 00:00:00","insp_start_time":"1420","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236723","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:57.000000Z","updated_at":"2025-08-23T10:45:57.000000Z","inspection_violations":[{"id":15365608,"change_date":"2025-08-18 21:39:00","inspection_id":"85521145","insp_violation_id":"268091363","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"208450673","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4553249","created_at":"2025-08-21T10:42:31.000000Z","updated_at":"2025-08-22T10:43:54.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":15563333,"change_date":"2025-08-18 21:39:00","inspection_id":"85521145","insp_unit_id":"208450673","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"440","insp_unit_license":"RB84719","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE1SDF01272","insp_unit_decal":"Y","insp_unit_decal_number":"00000000","created_at":"2025-08-21T09:45:43.000000Z","updated_at":"2025-08-22T09:46:01.000000Z"}]},{"id":9364381,"change_date":"2025-08-08 21:39:00","inspection_id":"85442104","dot_number":"2988150","report_state":"MI","report_number":"RICHP00572","insp_date":"2025-08-05 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B US-131","county_code_state":"MI","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1234558","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":15211803,"change_date":"2025-08-08 21:39:00","inspection_id":"85442104","insp_violation_id":"267918280","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":"WARNING","created_at":"2025-08-11T10:45:29.000000Z","updated_at":"2025-08-12T10:45:27.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":15428210,"change_date":"2025-08-08 21:39:00","inspection_id":"85442104","insp_unit_id":"208305663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"412","insp_unit_license":"BC02166","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT0GEC79021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:56.000000Z"}]},{"id":9364217,"change_date":"2025-08-08 21:39:00","inspection_id":"85441933","dot_number":"2988150","report_state":"MI","report_number":"SEYFE00141","insp_date":"2025-08-04 00:00:00","insp_start_time":"1800","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-275 @ 6 MILE RD.","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 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":"1234268","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":15211470,"change_date":"2025-08-08 21:39:00","inspection_id":"85441933","insp_violation_id":"267917927","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208305370","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:28.000000Z","updated_at":"2025-08-12T10:45:26.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":15427938,"change_date":"2025-08-08 21:39:00","inspection_id":"85441933","insp_unit_id":"208305370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"NA","insp_unit_license":"BE28046","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:55.000000Z"}]},{"id":9323125,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","dot_number":"2988150","report_state":"MI","report_number":"EVANT02944","insp_date":"2025-07-30 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTWICK PINES REST ARE","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233468","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":"02988150","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":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","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:45.000000Z","inspection_violations":[{"id":15128146,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_violation_id":"267824300","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208225671","insp_violation_category_id":"29","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:53.000000Z","normalized_code":"39617CPI"},{"id":15128147,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_violation_id":"267824301","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"208225671","insp_violation_category_id":"20","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:53.000000Z","normalized_code":"3939ALCL"},{"id":15128148,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_violation_id":"267824302","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"208225671","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:53.000000Z","normalized_code":"3922SLLSIV"},{"id":15128149,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_violation_id":"267824303","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"208225671","insp_violation_category_id":"23","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:53.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15128150,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_violation_id":"267824304","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"208225671","insp_violation_category_id":"23","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:53.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":15354015,"change_date":"2025-08-04 21:39:00","inspection_id":"85398749","insp_unit_id":"208225671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"462","insp_unit_license":"BB05399","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X3FM440777","insp_unit_decal":"Y","insp_unit_decal_number":"35456354","created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:55.000000Z"}]},{"id":9077860,"change_date":"2025-07-07 21:40:00","inspection_id":"85140766","dot_number":"2988150","report_state":"MI","report_number":"POWED05312","insp_date":"2025-07-02 00:00:00","insp_start_time":"1930","insp_end_time":"1950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1228684","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:35.000000Z","updated_at":"2025-07-11T10:44:35.000000Z","inspection_violations":[{"id":14615591,"change_date":"2025-07-07 21:40:00","inspection_id":"85140766","insp_violation_id":"267238066","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-07-10T10:42:40.000000Z","updated_at":"2025-07-11T10:45:59.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":14896843,"change_date":"2025-07-07 21:40:00","inspection_id":"85140766","insp_unit_id":"207730527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"406","insp_unit_license":"BB67158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY0JDF03075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:54.000000Z"}]},{"id":8963290,"change_date":"2025-06-23 21:41:00","inspection_id":"85020130","dot_number":"2988150","report_state":"MI","report_number":"ROBEJ00720","insp_date":"2025-06-20 00:00:00","insp_start_time":"1425","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 S\/B AT JEFFERSON","county_code_state":"MI","county_code":"107","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":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226274","transaction_code":"A","transaction_date":"2025-06-20 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14396479,"change_date":"2025-06-23 21:41:00","inspection_id":"85020130","insp_violation_id":"266989589","seq_no":"1","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4518846","created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:59.000000Z","normalized_code":"39141AMCPVI"}],"inspection_per_units":[{"id":14693561,"change_date":"2025-06-23 21:41:00","inspection_id":"85020130","insp_unit_id":"207510797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"426","insp_unit_license":"BE22498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:12.000000Z"}]},{"id":8921674,"change_date":"2025-06-17 21:41:00","inspection_id":"84975832","dot_number":"2988150","report_state":"MI","report_number":"MCKEN00061","insp_date":"2025-06-16 00:00:00","insp_start_time":"0840","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M66 NEAR COOLIDGE AVE","county_code_state":"MI","county_code":"117","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225757","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:58.000000Z","updated_at":"2025-06-22T10:00:43.000000Z","inspection_violations":[{"id":14311845,"change_date":"2025-06-17 21:41:00","inspection_id":"84975832","insp_violation_id":"266894025","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","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-06-20T10:16:42.000000Z","updated_at":"2025-06-21T10:17:49.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":14619841,"change_date":"2025-06-17 21:41:00","inspection_id":"84975832","insp_unit_id":"207430181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLUE","insp_unit_license":"BE22498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:06.000000Z","updated_at":"2025-06-22T09:45:58.000000Z"}]},{"id":8743612,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","dot_number":"2988150","report_state":"MI","report_number":"HARRK01498","insp_date":"2025-05-23 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 NEAR BELLEVILLE RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE","shipping_paper_number":"MULTIPLE","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-05-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"3","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222962","transaction_code":"A","transaction_date":"2025-05-23 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-05-27 21:39:00","snet_input_date":"2025-05-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-27 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:31.000000Z","updated_at":"2025-05-31T10:00:39.000000Z","inspection_violations":[{"id":13956242,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","insp_violation_id":"266487142","seq_no":"1","part_no":"383","part_no_section":"91A-LCDL","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-05-30T10:15:48.000000Z","updated_at":"2025-05-31T10:17:31.000000Z","normalized_code":"38391ALCDL"},{"id":13956243,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","insp_violation_id":"266487143","seq_no":"2","part_no":"383","part_no_section":"95A-LCDL","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-05-30T10:15:48.000000Z","updated_at":"2025-05-31T10:17:31.000000Z","normalized_code":"38395ALCDL"},{"id":13956244,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","insp_violation_id":"266487144","seq_no":"3","part_no":"391","part_no_section":"41B10-MC","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-30T10:15:48.000000Z","updated_at":"2025-05-31T10:17:31.000000Z","normalized_code":"39141B10MC"},{"id":13956245,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","insp_violation_id":"266487145","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207077929","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:48.000000Z","updated_at":"2025-05-31T10:17:31.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14297082,"change_date":"2025-05-27 21:39:00","inspection_id":"84787091","insp_unit_id":"207077929","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RC45630","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDPF7AN0SDF00375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:34.000000Z","updated_at":"2025-05-31T09:47:18.000000Z"}]},{"id":8632128,"change_date":"2025-05-14 21:42:00","inspection_id":"84669276","dot_number":"2988150","report_state":"MI","report_number":"DAWDD03950","insp_date":"2025-05-13 00:00:00","insp_start_time":"0807","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BELLEVILLE RD AT TYLER","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE","shipping_paper_number":"05132025","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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1221174","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:20.000000Z","updated_at":"2025-05-18T10:06:08.000000Z","inspection_violations":[{"id":13727182,"change_date":"2025-05-14 21:42:00","inspection_id":"84669276","insp_violation_id":"266221049","seq_no":"1","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"206857478","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-18T10:27:10.000000Z","updated_at":"2025-05-18T10:33:42.000000Z","normalized_code":"3963A1TAOCV"}],"inspection_per_units":[{"id":14095475,"change_date":"2025-05-14 21:42:00","inspection_id":"84669276","insp_unit_id":"206857478","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BC15680","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDPF7AY7JDF05792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:43.000000Z"}]},{"id":8382574,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","dot_number":"2988150","report_state":"MI","report_number":"JURKV02971","insp_date":"2025-04-14 00:00:00","insp_start_time":"0900","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1217634","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:26:37.000000Z","updated_at":"2025-04-19T10:17:02.000000Z","inspection_violations":[{"id":13214833,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","insp_violation_id":"265634995","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206325460","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4501387","created_at":"2025-04-18T10:59:34.000000Z","updated_at":"2025-04-18T11:07:36.000000Z","normalized_code":"3922SLLSR"},{"id":13214834,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","insp_violation_id":"265634996","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206325460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:59:34.000000Z","updated_at":"2025-04-18T11:07:36.000000Z","normalized_code":"39347E"},{"id":13214835,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","insp_violation_id":"265634997","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206325460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:59:34.000000Z","updated_at":"2025-04-18T11:07:37.000000Z","normalized_code":"39347E"},{"id":13214836,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","insp_violation_id":"265634998","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"206325460","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4501387","created_at":"2025-04-18T10:59:34.000000Z","updated_at":"2025-04-18T11:07:37.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13606021,"change_date":"2025-04-15 21:41:00","inspection_id":"84406523","insp_unit_id":"206325460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"424","insp_unit_license":"BC91946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X1NM160288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:14:29.000000Z","updated_at":"2025-04-19T10:00:37.000000Z"}]},{"id":7960591,"change_date":"2025-02-26 21:40:00","inspection_id":"83962317","dot_number":"2988150","report_state":"MO","report_number":"3698001573","insp_date":"2025-02-25 00:00:00","insp_start_time":"0902","insp_end_time":"0925","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1399203","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-02-26 21:40:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12850640,"change_date":"2025-02-26 21:40:00","inspection_id":"83962317","insp_unit_id":"205498671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"439","insp_unit_license":"RC45629","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDPF7AN2SDF00376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"}]},{"id":7865420,"change_date":"2025-02-13 21:40:00","inspection_id":"83862581","dot_number":"2988150","report_state":"MI","report_number":"POWED05140","insp_date":"2025-02-12 00:00:00","insp_start_time":"1435","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB 275 ANN ARBOR RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1209952","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12290973,"change_date":"2025-02-13 21:40:00","inspection_id":"83862581","insp_violation_id":"264507861","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","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:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":12694849,"change_date":"2025-02-13 21:40:00","inspection_id":"83862581","insp_unit_id":"205315648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"BD49132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN9RDF00540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"}]},{"id":7749333,"change_date":"2025-01-30 21:41:00","inspection_id":"83740506","dot_number":"2988150","report_state":"MI","report_number":"HOLLM04198","insp_date":"2025-01-30 00:00:00","insp_start_time":"0955","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"I-94 W\/B GRASS LAKE SCALE","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"25999","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":"1208324","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":"02988150","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":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","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":12108553,"change_date":"2025-01-30 21:41:00","inspection_id":"83740506","insp_violation_id":"264259893","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4481819","created_at":"2025-03-17T22:05:04.000000Z","updated_at":"2025-03-17T22:05:04.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":12505704,"change_date":"2025-01-30 21:41:00","inspection_id":"83740506","insp_unit_id":"205085208","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB67157","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY4JDF03077","insp_unit_decal":"Y","insp_unit_decal_number":"34932035","created_at":"2025-03-17T23:53:03.000000Z","updated_at":"2025-03-17T23:53:03.000000Z"}]},{"id":7672113,"change_date":"2025-01-21 21:39:00","inspection_id":"83659589","dot_number":"2988150","report_state":"MI","report_number":"OSHEE02425","insp_date":"2025-01-17 00:00:00","insp_start_time":"0910","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WALMART PARKING LOT","county_code_state":"MI","county_code":"165","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"28500","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":"1207179","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11986628,"change_date":"2025-01-21 21:39:00","inspection_id":"83659589","insp_violation_id":"264099824","seq_no":"1","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:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39145AMCEM"}],"inspection_per_units":[{"id":12379885,"change_date":"2025-01-21 21:39:00","inspection_id":"83659589","insp_unit_id":"204934785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"432","insp_unit_license":"BD30898","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN2PDF05334","insp_unit_decal":"Y","insp_unit_decal_number":"34933933","created_at":"2025-03-17T23:51:36.000000Z","updated_at":"2025-03-17T23:51:36.000000Z"}]},{"id":7584158,"change_date":"2025-01-14 21:55:00","inspection_id":"83567131","dot_number":"2988150","report_state":"MI","report_number":"BACZM02567","insp_date":"2025-01-07 00:00:00","insp_start_time":"1044","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1206162","transaction_code":"C","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2025-01-09 21:40:00","snet_input_date":"2025-01-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[{"id":11855118,"change_date":"2025-01-14 21:55:00","inspection_id":"83567131","insp_violation_id":"263994697","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"204827588","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4459569","created_at":"2025-03-17T22:03:45.000000Z","updated_at":"2025-03-17T22:03:45.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":12237090,"change_date":"2025-01-14 21:55:00","inspection_id":"83567131","insp_unit_id":"204827588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BE02198","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DE3SDF01273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"}]},{"id":6808668,"change_date":"2024-09-24 21:42:00","inspection_id":"82747550","dot_number":"2988150","report_state":"MI","report_number":"GUSUJ00327","insp_date":"2024-09-23 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"SB 23 @ MM 1","county_code_state":"MI","county_code":"115","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195852","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[{"id":10601452,"change_date":"2024-09-24 21:42:00","inspection_id":"82747550","insp_violation_id":"262009019","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203108749","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"3939A"},{"id":10601453,"change_date":"2024-09-24 21:42:00","inspection_id":"82747550","insp_violation_id":"262009020","seq_no":"2","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"203108749","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"39381"},{"id":10601454,"change_date":"2024-09-24 21:42:00","inspection_id":"82747550","insp_violation_id":"262009021","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203108749","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10979602,"change_date":"2024-09-24 21:42:00","inspection_id":"82747550","insp_unit_id":"203108749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"425","insp_unit_license":"BC91948","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X3NM160289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:42.000000Z","updated_at":"2025-03-17T23:36:42.000000Z"}]},{"id":6631786,"change_date":"2024-09-17 21:45:00","inspection_id":"82559177","dot_number":"2988150","report_state":"MI","report_number":"BRADD01252","insp_date":"2024-08-28 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZEELAND REST STOP.","county_code_state":"MI","county_code":"139","insp_level_id":"2","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":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1193060","transaction_code":"C","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10315014,"change_date":"2024-09-17 21:45:00","inspection_id":"82559177","insp_violation_id":"261859528","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202975765","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3939A"},{"id":10315015,"change_date":"2024-09-17 21:45:00","inspection_id":"82559177","insp_violation_id":"261859529","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202975765","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3939A"},{"id":10315016,"change_date":"2024-09-17 21:45:00","inspection_id":"82559177","insp_violation_id":"261859530","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202975765","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10692023,"change_date":"2024-09-17 21:45:00","inspection_id":"82559177","insp_unit_id":"202975765","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"401","insp_unit_license":"BB05396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X5FM440778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6424010,"change_date":"2024-09-17 21:45:00","inspection_id":"82337565","dot_number":"2988150","report_state":"MI","report_number":"MATTJ01564","insp_date":"2024-08-07 00:00:00","insp_start_time":"0715","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","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-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1189522","transaction_code":"C","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-08-08 21:42:00","snet_input_date":"2024-08-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:16.000000Z","updated_at":"2025-03-17T20:30:16.000000Z","inspection_violations":[{"id":9974738,"change_date":"2024-09-17 21:45:00","inspection_id":"82337565","insp_violation_id":"261868912","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202982890","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10353279,"change_date":"2024-09-17 21:45:00","inspection_id":"82337565","insp_unit_id":"202982890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD49133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN0RDF00541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"}]},{"id":6357658,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","dot_number":"2988150","report_state":"MI","report_number":"MANIJ01700","insp_date":"2024-07-29 00:00:00","insp_start_time":"1201","insp_end_time":"1253","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"YES","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-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188125","transaction_code":"C","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870593,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","insp_violation_id":"261868547","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:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3922"},{"id":9870594,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","insp_violation_id":"261868548","seq_no":"2","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:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3922"},{"id":9870595,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","insp_violation_id":"261868549","seq_no":"3","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":"X4413036","created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"39141A"},{"id":9870596,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","insp_violation_id":"261868550","seq_no":"4","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":"X4413036","created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":10245443,"change_date":"2024-09-17 21:45:00","inspection_id":"82266528","insp_unit_id":"202982474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB96547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4HEE40925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":6299522,"change_date":"2024-09-17 21:45:00","inspection_id":"82204355","dot_number":"2988150","report_state":"MI","report_number":"RAMSB01973","insp_date":"2024-07-23 00:00:00","insp_start_time":"1420","insp_end_time":"1434","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ANN ARBOR WB AT I-275","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1187201","transaction_code":"C","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:27.000000Z","updated_at":"2025-03-17T20:27:27.000000Z","inspection_violations":[{"id":9783253,"change_date":"2024-09-17 21:45:00","inspection_id":"82204355","insp_violation_id":"261871449","seq_no":"1","part_no":"392","part_no_section":"16(a)","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:53:20.000000Z","updated_at":"2025-03-17T21:53:20.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10150447,"change_date":"2024-09-17 21:45:00","inspection_id":"82204355","insp_unit_id":"202985213","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"434","insp_unit_license":"BD49133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN0RDF00541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"}]},{"id":6220064,"change_date":"2024-09-16 21:43:00","inspection_id":"82119205","dot_number":"2988150","report_state":"MI","report_number":"AKERT00282","insp_date":"2024-07-08 00:00:00","insp_start_time":"1342","insp_end_time":"1356","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M46 & FEDERAL AVE","county_code_state":"MI","county_code":"117","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-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186036","transaction_code":"C","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10021322,"change_date":"2024-09-16 21:43:00","inspection_id":"82119205","insp_unit_id":"202945566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"426","insp_unit_license":"BC91949","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":6143382,"change_date":"2024-07-03 21:40:00","inspection_id":"82036858","dot_number":"2988150","report_state":"MI","report_number":"MATTJ01548","insp_date":"2024-07-03 00:00:00","insp_start_time":"0720","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","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":"2024-07-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1184293","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[{"id":9536566,"change_date":"2024-07-03 21:40:00","inspection_id":"82036858","insp_violation_id":"260463822","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201728773","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"39378"},{"id":9536567,"change_date":"2024-07-03 21:40:00","inspection_id":"82036858","insp_violation_id":"260463823","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201728773","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9895694,"change_date":"2024-07-03 21:40:00","inspection_id":"82036858","insp_unit_id":"201728773","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD49133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN0RDF0054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:34.000000Z","updated_at":"2025-03-17T23:25:34.000000Z"}]},{"id":6033662,"change_date":"2024-06-20 21:43:00","inspection_id":"81918775","dot_number":"2988150","report_state":"MO","report_number":"3698000962","insp_date":"2024-06-20 00:00:00","insp_start_time":"0837","insp_end_time":"0854","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"1","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"586674","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":"02988150","upload_search_indicator":null,"census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:16.000000Z","updated_at":"2025-03-17T20:22:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9718186,"change_date":"2024-06-20 21:43:00","inspection_id":"81918775","insp_unit_id":"201499974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"431","insp_unit_license":"RB84721","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN4PDF05335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:42.000000Z","updated_at":"2025-03-17T23:23:42.000000Z"}]},{"id":5410609,"change_date":"2024-04-01 21:40:00","inspection_id":"81241126","dot_number":"2988150","report_state":"MI","report_number":"BACZM02226","insp_date":"2024-03-28 00:00:00","insp_start_time":"0940","insp_end_time":"0956","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":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1171243","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[{"id":8350583,"change_date":"2024-04-01 21:40:00","inspection_id":"81241126","insp_violation_id":"258683278","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:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8714379,"change_date":"2024-04-01 21:40:00","inspection_id":"81241126","insp_unit_id":"200179754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD30890","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN2PDF05334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5189611,"change_date":"2024-03-01 21:40:00","inspection_id":"81000000","dot_number":"2988150","report_state":"MI","report_number":"BACZM02199","insp_date":"2024-02-29 00:00:00","insp_start_time":"1004","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ COLDWATER RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1167399","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7997914,"change_date":"2024-03-01 21:40:00","inspection_id":"81000000","insp_violation_id":"258153935","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:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"},{"id":7997915,"change_date":"2024-03-01 21:40:00","inspection_id":"81000000","insp_violation_id":"258153936","seq_no":"2","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":"X4321151","created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":8356115,"change_date":"2024-03-01 21:40:00","inspection_id":"81000000","insp_unit_id":"199711127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD30898","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN2PDF05334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":5154273,"change_date":"2024-02-28 21:42:00","inspection_id":"80961916","dot_number":"2988150","report_state":"MI","report_number":"BACZM02192","insp_date":"2024-02-27 00:00:00","insp_start_time":"0912","insp_end_time":"0927","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1166809","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7950325,"change_date":"2024-02-28 21:42:00","inspection_id":"80961916","insp_violation_id":"258086560","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:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8299148,"change_date":"2024-02-28 21:42:00","inspection_id":"80961916","insp_unit_id":"199641550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC91946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X1NM160288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"}]},{"id":5154309,"change_date":"2024-02-28 21:42:00","inspection_id":"80961955","dot_number":"2988150","report_state":"MI","report_number":"BENNK00627","insp_date":"2024-02-27 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CO RD 633 @ M37","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1166957","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7950387,"change_date":"2024-02-28 21:42:00","inspection_id":"80961955","insp_violation_id":"258086638","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:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8299207,"change_date":"2024-02-28 21:42:00","inspection_id":"80961955","insp_unit_id":"199641618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC02166","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT0GEC79021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"}]},{"id":5089679,"change_date":"2024-02-20 21:42:00","inspection_id":"80891422","dot_number":"2988150","report_state":"MI","report_number":"KERSD00304","insp_date":"2024-02-20 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-275 SB @ ECORSE","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","shipping_paper_number":"MULTI","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-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1165635","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":7845671,"change_date":"2024-02-20 21:42:00","inspection_id":"80891422","insp_violation_id":"257925695","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":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39282A1"},{"id":7845672,"change_date":"2024-02-20 21:42:00","inspection_id":"80891422","insp_violation_id":"257925696","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:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8193977,"change_date":"2024-02-20 21:42:00","inspection_id":"80891422","insp_unit_id":"199502639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"406","insp_unit_license":"BB67158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY0JDF03075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":5009716,"change_date":"2024-02-08 21:43:00","inspection_id":"80804027","dot_number":"2988150","report_state":"MI","report_number":"BACZM02181","insp_date":"2024-02-07 00:00:00","insp_start_time":"1112","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ BIRCH RUN 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":"2024-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1163745","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:01.000000Z","updated_at":"2025-03-17T20:02:01.000000Z","inspection_violations":[{"id":7716994,"change_date":"2024-02-08 21:43:00","inspection_id":"80804027","insp_violation_id":"257739477","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:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8063294,"change_date":"2024-02-08 21:43:00","inspection_id":"80804027","insp_unit_id":"199336637","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"432","insp_unit_license":"BD30898","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN2PDF05334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:04.000000Z","updated_at":"2025-03-17T23:08:04.000000Z"}]},{"id":4987792,"change_date":"2024-02-06 21:42:00","inspection_id":"80779933","dot_number":"2988150","report_state":"MI","report_number":"BLAKD04064","insp_date":"2024-02-05 00:00:00","insp_start_time":"1700","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US 23 NB @ REST AREA","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-02-06 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":"1163299","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:37.000000Z","updated_at":"2025-03-17T20:01:37.000000Z","inspection_violations":[{"id":7681813,"change_date":"2024-02-06 21:42:00","inspection_id":"80779933","insp_violation_id":"257687072","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199290113","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3939A"},{"id":7681814,"change_date":"2024-02-06 21:42:00","inspection_id":"80779933","insp_violation_id":"257687073","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199290113","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8027604,"change_date":"2024-02-06 21:42:00","inspection_id":"80779933","insp_unit_id":"199290113","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"430","insp_unit_license":"BD26644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAL99H104234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"}]},{"id":4977562,"change_date":"2024-02-05 21:40:00","inspection_id":"80768855","dot_number":"2988150","report_state":"MI","report_number":"FRIZS02918","insp_date":"2024-02-02 00:00:00","insp_start_time":"1045","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"210TH AVE @ 9 MILE RD","county_code_state":"MI","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"ROUTE 12102","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-02-05 21:40: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":"1163034","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7667305,"change_date":"2024-02-05 21:40:00","inspection_id":"80768855","insp_violation_id":"257666965","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:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8011227,"change_date":"2024-02-05 21:40:00","inspection_id":"80768855","insp_unit_id":"199269955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"401","insp_unit_license":"BB05396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X5FM440778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"}]},{"id":4910117,"change_date":"2024-01-26 21:39:00","inspection_id":"80694887","dot_number":"2988150","report_state":"MI","report_number":"BLAKD04053","insp_date":"2024-01-25 00:00:00","insp_start_time":"0845","insp_end_time":"0901","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-75 SB @ SUMMIT","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-01-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1161827","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2024-01-26 21:39:00","snet_input_date":"2024-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-26 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:02.000000Z","updated_at":"2025-03-17T20:00:02.000000Z","inspection_violations":[{"id":7565049,"change_date":"2024-01-26 21:39:00","inspection_id":"80694887","insp_violation_id":"257515013","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:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3922"},{"id":7565050,"change_date":"2024-01-26 21:39:00","inspection_id":"80694887","insp_violation_id":"257515014","seq_no":"2","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:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7901283,"change_date":"2024-01-26 21:39:00","inspection_id":"80694887","insp_unit_id":"199127301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"39","insp_unit_license":"BC92815","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GY6KDA04764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"}]},{"id":4702924,"change_date":"2023-12-26 21:40:00","inspection_id":"80468728","dot_number":"2988150","report_state":"MI","report_number":"DAWDD03207","insp_date":"2023-12-21 00:00:00","insp_start_time":"0912","insp_end_time":"1007","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT INKSTER","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ABSOPURE WATER COMPANY LLC","shipping_paper_number":"12212023","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-12-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1158455","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-12-26 21:40:00","snet_input_date":"2023-12-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-26 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:08.000000Z","updated_at":"2025-03-17T19:56:08.000000Z","inspection_violations":[{"id":7264019,"change_date":"2023-12-26 21:40:00","inspection_id":"80468728","insp_violation_id":"257049146","seq_no":"1","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":"X4292302","created_at":"2025-03-17T21:41:06.000000Z","updated_at":"2025-03-17T21:41:06.000000Z","normalized_code":"3922"},{"id":7264020,"change_date":"2023-12-26 21:40:00","inspection_id":"80468728","insp_violation_id":"257049147","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":"X4292302","created_at":"2025-03-17T21:41:06.000000Z","updated_at":"2025-03-17T21:41:06.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":7564583,"change_date":"2023-12-26 21:40:00","inspection_id":"80468728","insp_unit_id":"198665252","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BB17344","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY3HDB02307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:36.000000Z","updated_at":"2025-03-17T23:03:36.000000Z"}]},{"id":4473214,"change_date":"2023-11-21 21:40:00","inspection_id":"80216512","dot_number":"2988150","report_state":"MI","report_number":"BACZM02132","insp_date":"2023-11-20 00:00:00","insp_start_time":"0921","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1154311","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[{"id":6924029,"change_date":"2023-11-21 21:40:00","inspection_id":"80216512","insp_violation_id":"256513324","seq_no":"1","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":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"38323A2"},{"id":6924030,"change_date":"2023-11-21 21:40:00","inspection_id":"80216512","insp_violation_id":"256513325","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:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7194063,"change_date":"2023-11-21 21:40:00","inspection_id":"80216512","insp_unit_id":"198166379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB05398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7XXFM440775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:24.000000Z","updated_at":"2025-03-17T23:00:24.000000Z"}]},{"id":4342391,"change_date":"2023-11-02 21:42:00","inspection_id":"80072016","dot_number":"2988150","report_state":"MI","report_number":"DELMT00847","insp_date":"2023-11-01 00:00:00","insp_start_time":"1720","insp_end_time":"1740","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 21:42: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":"1151977","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[{"id":6716920,"change_date":"2023-11-02 21:42:00","inspection_id":"80072016","insp_violation_id":"256189554","seq_no":"1","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"197880847","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:18.000000Z","updated_at":"2025-03-17T21:38:18.000000Z","normalized_code":"39324A"}],"inspection_per_units":[{"id":6983821,"change_date":"2023-11-02 21:42:00","inspection_id":"80072016","insp_unit_id":"197880847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD26644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAL99H104234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:37.000000Z","updated_at":"2025-03-17T22:58:37.000000Z"}]},{"id":4272871,"change_date":"2023-10-24 21:40:00","inspection_id":"79995234","dot_number":"2988150","report_state":"MI","report_number":"AKERT00022","insp_date":"2023-10-23 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M66 @ E WASHINGTON RD","county_code_state":"MI","county_code":"107","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-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1150587","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6871943,"change_date":"2023-10-24 21:40:00","inspection_id":"79995234","insp_unit_id":"197721848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLUE","insp_unit_license":"BC91949","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:37.000000Z","updated_at":"2025-03-17T22:57:37.000000Z"}]},{"id":4227572,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","dot_number":"2988150","report_state":"MI","report_number":"POWEL03351","insp_date":"2023-10-18 00:00:00","insp_start_time":"0700","insp_end_time":"0748","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","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-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"9","oos_total":"4","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149842","transaction_code":"C","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-10-18 21:41:00","snet_input_date":"2023-10-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-18 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:37.000000Z","updated_at":"2025-03-17T19:46:37.000000Z","inspection_violations":[{"id":6544906,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964003","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":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39141A"},{"id":6544907,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964004","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":"X4282824","created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"38323A2"},{"id":6544908,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964005","seq_no":"3","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:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3922"},{"id":6544909,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964006","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544910,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964007","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544911,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964008","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544912,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964009","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544913,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964010","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4282824","created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544914,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_violation_id":"255964011","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668581","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6798810,"change_date":"2023-10-20 21:40:00","inspection_id":"79945025","insp_unit_id":"197668581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD49133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN0RDF0054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:59.000000Z","updated_at":"2025-03-17T22:56:59.000000Z"}]},{"id":4034222,"change_date":"2023-09-22 21:39:00","inspection_id":"79730822","dot_number":"2988150","report_state":"MI","report_number":"WASCC00415","insp_date":"2023-09-21 00:00:00","insp_start_time":"1233","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SHOULDER","county_code_state":"MI","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","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":"2023-09-22 21:39: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":"1147144","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-09-22 21:39:00","snet_input_date":"2023-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-22 21:39:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:26.000000Z","updated_at":"2025-03-17T19:42:26.000000Z","inspection_violations":[{"id":6244590,"change_date":"2023-09-22 21:39:00","inspection_id":"79730822","insp_violation_id":"255427479","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":null,"created_at":"2025-03-17T21:36:09.000000Z","updated_at":"2025-03-17T21:36:09.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":6486054,"change_date":"2023-09-22 21:39:00","inspection_id":"79730822","insp_unit_id":"197189098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC26105","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDTXDHFH1904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:27.000000Z","updated_at":"2025-03-17T22:54:27.000000Z"}]},{"id":3858843,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","dot_number":"2988150","report_state":"MI","report_number":"BACZM02058","insp_date":"2023-08-29 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","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":"Y","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":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143269","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":"02988150","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":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","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":5960247,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","insp_violation_id":"254954079","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":"X4258200","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"},{"id":5960248,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","insp_violation_id":"254954080","seq_no":"2","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":5960249,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","insp_violation_id":"254954081","seq_no":"3","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":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"38323A2"},{"id":5960250,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","insp_violation_id":"254954082","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196789175","insp_violation_category_id":"30","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"}],"inspection_per_units":[{"id":6203859,"change_date":"2023-08-29 21:42:00","inspection_id":"79535841","insp_unit_id":"196789175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC91946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X1NM160288","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":3833775,"change_date":"2023-08-30 21:44:00","inspection_id":"79507809","dot_number":"2988150","report_state":"MI","report_number":"DEJOS00681","insp_date":"2023-08-24 00:00:00","insp_start_time":"1730","insp_end_time":"1805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142681","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:32.000000Z","updated_at":"2025-03-17T19:38:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6164006,"change_date":"2023-08-30 21:44:00","inspection_id":"79507809","insp_unit_id":"196813106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD26644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMAAL99H104234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"}]},{"id":3823859,"change_date":"2023-08-30 21:44:00","inspection_id":"79496561","dot_number":"2988150","report_state":"MI","report_number":"EVANT02300","insp_date":"2023-08-23 00:00:00","insp_start_time":"1230","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"4 MILE REST ARE","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142410","transaction_code":"C","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-08-24 21:41:00","snet_input_date":"2023-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:29.000000Z","updated_at":"2025-03-17T19:38:29.000000Z","inspection_violations":[{"id":5903123,"change_date":"2023-08-30 21:44:00","inspection_id":"79496561","insp_violation_id":"254984223","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196813591","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39395A"},{"id":5903124,"change_date":"2023-08-30 21:44:00","inspection_id":"79496561","insp_violation_id":"254984224","seq_no":"2","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"1","insp_unit_id":"196813591","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"387303B4"},{"id":5903125,"change_date":"2023-08-30 21:44:00","inspection_id":"79496561","insp_violation_id":"254984225","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196813591","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6147960,"change_date":"2023-08-30 21:44:00","inspection_id":"79496561","insp_unit_id":"196813591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"424","insp_unit_license":"BC91946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X1NM160288","insp_unit_decal":"Y","insp_unit_decal_number":"33030638","created_at":"2025-03-17T22:51:38.000000Z","updated_at":"2025-03-17T22:51:38.000000Z"}]},{"id":3746265,"change_date":"2023-08-30 21:45:00","inspection_id":"79409943","dot_number":"2988150","report_state":"MI","report_number":"MALIK01921","insp_date":"2023-08-15 00:00:00","insp_start_time":"1440","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/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":"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":"2023-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1140336","transaction_code":"C","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:53.000000Z","updated_at":"2025-03-17T19:36:53.000000Z","inspection_violations":[{"id":5776507,"change_date":"2023-08-30 21:45:00","inspection_id":"79409943","insp_violation_id":"254986959","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":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":6023654,"change_date":"2023-08-30 21:45:00","inspection_id":"79409943","insp_unit_id":"196815604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"354","insp_unit_license":"BD49103","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY7HDB02309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:37.000000Z","updated_at":"2025-03-17T22:50:37.000000Z"}]},{"id":3609559,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","dot_number":"2988150","report_state":"MI","report_number":"FROSR00765","insp_date":"2023-07-27 00:00:00","insp_start_time":"0830","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ DODGE RD R\/A","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1137229","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566549,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","insp_violation_id":"254318605","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196228646","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"},{"id":5566550,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","insp_violation_id":"254318606","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196228646","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39347E"},{"id":5566551,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","insp_violation_id":"254318607","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196228646","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39353B"},{"id":5566552,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","insp_violation_id":"254318608","seq_no":"4","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":5803519,"change_date":"2023-07-27 21:40:00","inspection_id":"79257082","insp_unit_id":"196228646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC64713","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7XXCM308482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3501297,"change_date":"2023-07-13 21:42:00","inspection_id":"79135714","dot_number":"2988150","report_state":"MO","report_number":"00SH007466","insp_date":"2023-07-12 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"C70","location_desc":"3700 N BROADWAY","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-07-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2083629","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-07-13 21:42:00","snet_input_date":"2023-07-13 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"PO BOX 701248","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:25.000000Z","updated_at":"2025-03-17T19:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5630057,"change_date":"2023-07-13 21:42:00","inspection_id":"79135714","insp_unit_id":"195985453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"341","insp_unit_license":"RB84723","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT2DHFG6339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:27.000000Z","updated_at":"2025-03-17T22:47:27.000000Z"}]},{"id":3434237,"change_date":"2023-07-05 21:42:00","inspection_id":"79059989","dot_number":"2988150","report_state":"MI","report_number":"SCHMC04604","insp_date":"2023-07-03 00:00:00","insp_start_time":"0710","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ISB 275 REST AREA","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1133442","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-07-05 21:42:00","snet_input_date":"2023-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:58.000000Z","updated_at":"2025-03-17T19:30:58.000000Z","inspection_violations":[{"id":5293014,"change_date":"2023-07-05 21:42:00","inspection_id":"79059989","insp_violation_id":"253867652","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195828527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"3939A"},{"id":5293015,"change_date":"2023-07-05 21:42:00","inspection_id":"79059989","insp_violation_id":"253867653","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195828527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5521817,"change_date":"2023-07-05 21:42:00","inspection_id":"79059989","insp_unit_id":"195828527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"346","insp_unit_license":"RB84716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT6DHFH1902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"}]},{"id":3142549,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","dot_number":"2988150","report_state":"MO","report_number":"CT03005326","insp_date":"2023-05-24 00:00:00","insp_start_time":"0801","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"I-55 SB AT CARRON ROAD","county_code_state":"MO","county_code":"186","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"ROUTE 10","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":"I","final_status_date":"2023-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"12","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2075863","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-05-25 21:42:00","snet_input_date":"2023-05-25 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"PO BOX 701248","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:19.000000Z","updated_at":"2025-03-17T19:25:19.000000Z","inspection_violations":[{"id":4837894,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082415","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3922"},{"id":4837895,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082416","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3939A"},{"id":4837896,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082417","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3965B"},{"id":4837897,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082418","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39345D"},{"id":4837898,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082419","seq_no":"5","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39375B"},{"id":4837899,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082420","seq_no":"6","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39375B"},{"id":4837900,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082421","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3963A1"},{"id":4837901,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082422","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39347E"},{"id":4837902,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082423","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39353B"},{"id":4837903,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082424","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39347E"},{"id":4837904,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082425","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39347E"},{"id":4837905,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_violation_id":"253082426","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195146033","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5054395,"change_date":"2023-05-25 21:42:00","inspection_id":"78731335","insp_unit_id":"195146033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"341","insp_unit_license":"RB84723","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT2DHFG6339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"}]},{"id":2585933,"change_date":"2023-03-15 21:42:00","inspection_id":"78100734","dot_number":"2988150","report_state":"MI","report_number":"MCGEJ02728","insp_date":"2023-03-14 00:00:00","insp_start_time":"1445","insp_end_time":"1457","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"CO RD 612 @ CO RD 489","county_code_state":"MI","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"MULTIPLE","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":"Y","pen_cen_match":null,"final_status_date":"2023-03-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1117685","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-03-15 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[{"id":3976882,"change_date":"2023-03-15 21:42:00","inspection_id":"78100734","insp_violation_id":"251681136","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":"WARNING","created_at":"2025-03-17T21:25:38.000000Z","updated_at":"2025-03-17T21:25:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4162201,"change_date":"2023-03-15 21:42:00","inspection_id":"78100734","insp_unit_id":"193890778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"432","insp_unit_license":"BD30898","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7AN2PDF05334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":2317000,"change_date":"2023-02-07 21:41:00","inspection_id":"77793992","dot_number":"2988150","report_state":"MO","report_number":"SLC7000901","insp_date":"2023-02-06 00:00:00","insp_start_time":"0948","insp_end_time":"1014","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"I55 SB AT MERAMEC BOTTOM","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"19003","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":"I","final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2057091","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":"M","census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"PO BOX 701248","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3569036,"change_date":"2023-02-07 21:41:00","inspection_id":"77793992","insp_violation_id":"250996841","seq_no":"1","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"193275136","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":3729245,"change_date":"2023-02-07 21:41:00","inspection_id":"77793992","insp_unit_id":"193275136","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"338","insp_unit_license":"RB84720","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT7DHFG6336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":2066119,"change_date":"2023-01-04 21:40:00","inspection_id":"77507425","dot_number":"2988150","report_state":"MI","report_number":"PRIED02078","insp_date":"2023-01-03 00:00:00","insp_start_time":"1055","insp_end_time":"1102","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 @ 6 MILE","county_code_state":"MI","county_code":"107","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":"2023-01-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1107470","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2023-01-04 21:40:00","snet_input_date":"2023-01-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-04 21:40:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:44.000000Z","updated_at":"2025-03-17T19:04:44.000000Z","inspection_violations":[{"id":3197881,"change_date":"2023-01-04 21:40:00","inspection_id":"77507425","insp_violation_id":"250382006","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192695980","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:07.000000Z","updated_at":"2025-03-17T21:22:07.000000Z","normalized_code":"3939A"},{"id":3197882,"change_date":"2023-01-04 21:40:00","inspection_id":"77507425","insp_violation_id":"250382007","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192695980","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:07.000000Z","updated_at":"2025-03-17T21:22:07.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":3323962,"change_date":"2023-01-04 21:40:00","inspection_id":"77507425","insp_unit_id":"192695980","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB05399","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM7X3FM440777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:47.000000Z","updated_at":"2025-03-17T22:29:47.000000Z"}]},{"id":2012286,"change_date":"2022-12-26 21:31:00","inspection_id":"77446046","dot_number":"2988150","report_state":"MI","report_number":"NEGUB02224","insp_date":"2022-12-21 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALES","county_code_state":"MI","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"MULTIPLE","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-12-26 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1106683","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-12-26 21:31:00","snet_input_date":"2022-12-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-26 21:31:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3123164,"change_date":"2022-12-26 21:31:00","inspection_id":"77446046","insp_violation_id":"250259872","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:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3237530,"change_date":"2022-12-26 21:31:00","inspection_id":"77446046","insp_unit_id":"192574335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB17343","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AY5HDB02308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1159555,"change_date":"2022-08-29 21:42:00","inspection_id":"76463875","dot_number":"2988150","report_state":"MO","report_number":"SLC2002161","insp_date":"2022-08-26 00:00:00","insp_start_time":"1112","insp_end_time":"1144","registration_date":null,"region":"CT","ci_status_code":"C","location":"C100","location_desc":"14850 MANCHESTER RD","county_code_state":"MO","county_code":"189","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"197365","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":"Y","pen_cen_match":"I","final_status_date":"2022-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2029325","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":"M","census_search_date":"2022-08-29 21:42:00","snet_input_date":"2022-08-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"PO BOX 701248","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1837568,"change_date":"2022-08-29 21:42:00","inspection_id":"76463875","insp_violation_id":"248066138","seq_no":"1","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39216B"},{"id":1837569,"change_date":"2022-08-29 21:42:00","inspection_id":"76463875","insp_violation_id":"248066139","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190598185","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39617C"},{"id":1837570,"change_date":"2022-08-29 21:42:00","inspection_id":"76463875","insp_violation_id":"248066140","seq_no":"3","part_no":"393","part_no_section":"70(d)","insp_viol_unit":"1","insp_unit_id":"190598185","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39370D"}],"inspection_per_units":[{"id":1864366,"change_date":"2022-08-29 21:42:00","inspection_id":"76463875","insp_unit_id":"190598185","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"156193H","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1HTMMAAL49H101533","insp_unit_decal":"Y","insp_unit_decal_number":"31759840","created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":1016598,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","dot_number":"2988150","report_state":"MI","report_number":"KELLC01543","insp_date":"2022-08-10 00:00:00","insp_start_time":"1250","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75BUS @ TRACTOR SUPPLY","county_code_state":"MI","county_code":"039","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1088647","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:28.000000Z","updated_at":"2025-03-17T18:45:28.000000Z","inspection_violations":[{"id":1600587,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","insp_violation_id":"247656120","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190260079","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39617C"},{"id":1600588,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","insp_violation_id":"247656121","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190260079","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39347E"},{"id":1600589,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","insp_violation_id":"247656122","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190260079","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"39353B"},{"id":1600590,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","insp_violation_id":"247656123","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190260079","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4091331","created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1635652,"change_date":"2022-08-11 21:38:00","inspection_id":"76296838","insp_unit_id":"190260079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"334","insp_unit_license":"BC23991","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDTXDHFG6332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"}]},{"id":818140,"change_date":"2022-07-14 21:41:00","inspection_id":"76064778","dot_number":"2988150","report_state":"MI","report_number":"OOSTA00914","insp_date":"2022-07-13 00:00:00","insp_start_time":"1500","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1083995","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-07-14 21:41:00","snet_input_date":"2022-07-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[{"id":1288973,"change_date":"2022-07-14 21:41:00","inspection_id":"76064778","insp_violation_id":"247092107","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:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"3922"},{"id":1288974,"change_date":"2022-07-14 21:41:00","inspection_id":"76064778","insp_violation_id":"247092108","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189777580","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1316208,"change_date":"2022-07-14 21:41:00","inspection_id":"76064778","insp_unit_id":"189777580","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"41","insp_unit_license":"BB96547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4HEE40925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"}]},{"id":748628,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","dot_number":"2988150","report_state":"MI","report_number":"BACZM01533","insp_date":"2022-06-30 00:00:00","insp_start_time":"0820","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":"1","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1082635","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-07-05 21:42:00","snet_input_date":"2022-06-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1178299,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_violation_id":"246884963","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":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39141A"},{"id":1178300,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_violation_id":"246884964","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":"X4071897","created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"38323A2"},{"id":1178301,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_violation_id":"246884965","seq_no":"3","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:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3922"},{"id":1178302,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_violation_id":"246884966","seq_no":"4","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:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3922"},{"id":1178303,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_violation_id":"246884967","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189600597","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1203717,"change_date":"2022-07-05 21:42:00","inspection_id":"75983815","insp_unit_id":"189600597","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"423","insp_unit_license":"BC91947","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6XXNM160287","insp_unit_decal":"Y","insp_unit_decal_number":"31295038","created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":540425,"change_date":"2022-06-03 21:41:00","inspection_id":"75737426","dot_number":"2988150","report_state":"OH","report_number":"3238016464","insp_date":"2022-06-03 00:00:00","insp_start_time":"1048","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","pen_cen_match":"I","final_status_date":"2022-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1600846","transaction_code":"A","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-06-03 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-06-03 21:41:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"PO BOX 701248","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:23.000000Z","updated_at":"2025-03-17T18:37:23.000000Z","inspection_violations":[{"id":853440,"change_date":"2022-06-03 21:41:00","inspection_id":"75737426","insp_violation_id":"246241636","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189058582","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":869708,"change_date":"2022-06-03 21:41:00","inspection_id":"75737426","insp_unit_id":"189058582","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"513893","insp_unit_license":"RB84716","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT6DHFH1902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":175937,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","dot_number":"2988150","report_state":"MI","report_number":"WORDN03514","insp_date":"2022-04-13 00:00:00","insp_start_time":"1121","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEW BUFFALO TWP","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1071817","transaction_code":"C","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02988150","upload_search_indicator":null,"census_search_date":"2022-04-14 21:42:00","snet_input_date":"2022-04-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"ABSOPURE WATER COMPANY LLC","insp_carrier_street":"41590 JOY RD","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:32.000000Z","updated_at":"2025-03-17T18:30:32.000000Z","inspection_violations":[{"id":265259,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","insp_violation_id":"246344393","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4042798","created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39216A"},{"id":265260,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","insp_violation_id":"246344394","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189154915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3939A"},{"id":265261,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","insp_violation_id":"246344395","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"189154915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"39319"},{"id":265262,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","insp_violation_id":"246344396","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189154915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:08:17.000000Z","updated_at":"2025-03-17T21:08:17.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":284959,"change_date":"2022-06-09 21:43:00","inspection_id":"75303236","insp_unit_id":"189154915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"513895","insp_unit_license":"BC26105","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDTXDHFH1904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:54.000000Z","updated_at":"2025-03-17T22:09:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2988150\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2988150\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2988150\/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\/2988150\/inspections","per_page":100,"prev_page_url":null,"to":69,"total":69}