{"current_page":1,"data":[{"id":11501042,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","dot_number":"1076336","report_state":"MI","report_number":"GENTC03280","insp_date":"2026-03-25 00:00:00","insp_start_time":"2101","insp_end_time":"2130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ MM 238","county_code_state":"MI","county_code":"143","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"24912","cargo_tank":null,"hazmat_placard_req":"Y","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-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"137350","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":"1264371","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:27.000000Z","inspection_violations":[{"id":19420240,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_violation_id":"272692086","seq_no":"1","part_no":"395","part_no_section":"3A2-HOSPRNP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"3953A2HOSPRNP"},{"id":19420241,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_violation_id":"272692087","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"212384353","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"39311A1CSLRR"},{"id":19420242,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_violation_id":"272692088","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"212384353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"39345B2BAIR"},{"id":19420243,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_violation_id":"272692089","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"212384354","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":19702770,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_unit_id":"212384353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"68","insp_unit_license":"RC48431","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYDP9X5PJ262945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:50.000000Z"},{"id":19702771,"change_date":"2026-03-27 21:40:00","inspection_id":"87421138","insp_unit_id":"212384354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"F176463","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4S9KT5389MC429016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:50.000000Z"}]},{"id":11466010,"change_date":"2026-03-24 21:40:00","inspection_id":"87384336","dot_number":"1076336","report_state":"MI","report_number":"CELMS01682","insp_date":"2026-03-24 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ DAVISBURG REST AREA","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FOSTER BLUE WATER OIL","shipping_paper_number":"9098","cargo_tank":"306","hazmat_placard_req":"Y","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","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":"1263819","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19639015,"change_date":"2026-03-24 21:40:00","inspection_id":"87384336","insp_unit_id":"212311542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:58.000000Z"},{"id":19639016,"change_date":"2026-03-24 21:40:00","inspection_id":"87384336","insp_unit_id":"212311543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"F114563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D7R7L57432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:58.000000Z"}]},{"id":11310082,"change_date":"2026-03-06 21:42:00","inspection_id":"87226207","dot_number":"1076336","report_state":"MI","report_number":"FRIZS03486","insp_date":"2026-03-05 00:00:00","insp_start_time":"1005","insp_end_time":"1028","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E. PICKARD RD @ S E COUNT LINE","county_code_state":"MI","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX TERMINALS, LLC.","shipping_paper_number":"332079533","cargo_tank":"406","hazmat_placard_req":"Y","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-03-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"166600","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":"1261560","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-03-06 21:42:00","snet_input_date":"2026-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:39.000000Z","updated_at":"2026-03-17T09:31:06.000000Z","inspection_violations":[{"id":19029343,"change_date":"2026-03-06 21:42:00","inspection_id":"87226207","insp_violation_id":"272252761","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"212015158","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:20.000000Z","normalized_code":"39311A1CSLRR"},{"id":19029344,"change_date":"2026-03-06 21:42:00","inspection_id":"87226207","insp_violation_id":"272252762","seq_no":"2","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"212015158","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:20.000000Z","normalized_code":"39311A1LBL"}],"inspection_per_units":[{"id":19350683,"change_date":"2026-03-06 21:42:00","inspection_id":"87226207","insp_unit_id":"212015158","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"603","insp_unit_license":"BD98659","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWGGGG60J140371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:26.000000Z","updated_at":"2026-03-17T09:03:32.000000Z"},{"id":19350684,"change_date":"2026-03-06 21:42:00","inspection_id":"87226207","insp_unit_id":"212015159","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"656","insp_unit_license":"F191793","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTSA486XT7131059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:26.000000Z","updated_at":"2026-03-17T09:03:32.000000Z"}]},{"id":11173584,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","dot_number":"1076336","report_state":"MI","report_number":"PEASS03058","insp_date":"2026-02-19 00:00:00","insp_start_time":"1135","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"333105133","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259906","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-02-19 21:40:00","snet_input_date":"2026-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:38:04.000000Z","updated_at":"2026-03-02T10:31:04.000000Z","inspection_violations":[{"id":18731150,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_violation_id":"271897694","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"211713799","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4578278","created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:36.000000Z","normalized_code":"39345DB"},{"id":18731151,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_violation_id":"271897695","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"211713799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:36.000000Z","normalized_code":"3939ALRLI"},{"id":18731152,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_violation_id":"271897696","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211713800","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:36.000000Z","normalized_code":"39347E"},{"id":18731153,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_violation_id":"271897697","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"211713800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:36.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":19068288,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_unit_id":"211713799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"439","insp_unit_license":"BD98660","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9JJ211603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:04:00.000000Z"},{"id":19068289,"change_date":"2026-02-19 21:40:00","inspection_id":"87089468","insp_unit_id":"211713800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"456","insp_unit_license":"D572219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB476XW7L61960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:04:00.000000Z"}]},{"id":10835512,"change_date":"2026-01-22 21:39:00","inspection_id":"86863776","dot_number":"1076336","report_state":"MI","report_number":"PEIFM07913","insp_date":"2026-01-21 00:00:00","insp_start_time":"0300","insp_end_time":"0320","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PLAINS","shipping_paper_number":"110639","cargo_tank":"331","hazmat_placard_req":"Y","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"181000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1256901","transaction_code":"A","transaction_date":"2026-01-21 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-01-22 21:39:00","snet_input_date":"2026-01-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-22 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:37:00.000000Z","updated_at":"2026-02-02T10:30:43.000000Z","inspection_violations":[{"id":18117383,"change_date":"2026-01-22 21:39:00","inspection_id":"86863776","insp_violation_id":"271361012","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","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-01-25T10:42:39.000000Z","updated_at":"2026-02-02T10:36:57.000000Z","normalized_code":"3922SLLEWA3"},{"id":18117384,"change_date":"2026-01-22 21:39:00","inspection_id":"86863776","insp_violation_id":"271361013","seq_no":"2","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"211236113","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-25T10:42:39.000000Z","updated_at":"2026-02-02T10:36:57.000000Z","normalized_code":"393207FSDAS"}],"inspection_per_units":[{"id":18203861,"change_date":"2026-01-22 21:39:00","inspection_id":"86863776","insp_unit_id":"211236112","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"RC48434","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X2RD673421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:19.000000Z","updated_at":"2026-02-02T10:03:11.000000Z"},{"id":18203862,"change_date":"2026-01-22 21:39:00","inspection_id":"86863776","insp_unit_id":"211236113","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"18","insp_unit_license":"F176464","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9PT0Y83RH355837","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:19.000000Z","updated_at":"2026-02-02T10:03:11.000000Z"}]},{"id":10635868,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","dot_number":"1076336","report_state":"MI","report_number":"FRIZS03461","insp_date":"2026-01-12 00:00:00","insp_start_time":"1230","insp_end_time":"1332","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-127 @ WELCOME CENTER","county_code_state":"MI","county_code":"035","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"NONE","cargo_tank":"306","hazmat_placard_req":"Y","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-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","viol_total":"12","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"1256194","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:37.000000Z","inspection_violations":[{"id":17890606,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168050","seq_no":"1","part_no":"392","part_no_section":"16-D","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:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"39216D"},{"id":17890607,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168051","seq_no":"2","part_no":"177","part_no_section":"817E2-HMHC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"177817E2HMHC"},{"id":17890608,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168052","seq_no":"3","part_no":"172","part_no_section":"602A-HMER","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"172602AHMER"},{"id":17890609,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168053","seq_no":"4","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"1","insp_unit_id":"211052802","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890610,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168054","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"211052802","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4629156","created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"3963A1BOS"},{"id":17890611,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168055","seq_no":"6","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890612,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168056","seq_no":"7","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890613,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168057","seq_no":"8","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39345B2BAIR"},{"id":17890614,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168058","seq_no":"9","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890615,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168059","seq_no":"10","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890616,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168060","seq_no":"11","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39348ABLMCBAD"},{"id":17890617,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_violation_id":"271168061","seq_no":"12","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"211052803","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:10.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":17838770,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_unit_id":"211052802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"},{"id":17838771,"change_date":"2026-01-13 21:39:00","inspection_id":"86777011","insp_unit_id":"211052803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"482","insp_unit_license":"F114563","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D7R7L57432","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"}]},{"id":10611299,"change_date":"2026-01-13 21:39:00","inspection_id":"86751175","dot_number":"1076336","report_state":"MI","report_number":"BLAKD04839","insp_date":"2026-01-09 00:00:00","insp_start_time":"0720","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"21124","cargo_tank":"331","hazmat_placard_req":"Y","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":"152500","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":"1255993","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":"01076336","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":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:47.000000Z","updated_at":"2026-01-24T10:30:13.000000Z","inspection_violations":[{"id":17882567,"change_date":"2026-01-13 21:39:00","inspection_id":"86751175","insp_violation_id":"271167607","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"211052407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:47.000000Z","updated_at":"2026-01-24T10:30:27.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":17830456,"change_date":"2026-01-13 21:39:00","inspection_id":"86751175","insp_unit_id":"211052407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"65","insp_unit_license":"RB95334","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD49X9KJ370898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:40.000000Z"},{"id":17830457,"change_date":"2026-01-13 21:39:00","inspection_id":"86751175","insp_unit_id":"211052408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTCI","insp_unit_company":"4","insp_unit_license":"F176452","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9PT0X36PH355138","insp_unit_decal":"Y","insp_unit_decal_number":"36057588","created_at":"2026-01-16T10:08:33.000000Z","updated_at":"2026-01-24T10:01:40.000000Z"}]},{"id":10378496,"change_date":"2025-12-08 21:39:00","inspection_id":"86507734","dot_number":"1076336","report_state":"MI","report_number":"LITTJ05650","insp_date":"2025-12-05 00:00:00","insp_start_time":"1120","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 @ HURON RIVER DR","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KIROS","shipping_paper_number":"336028115","cargo_tank":"331","hazmat_placard_req":"Y","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-12-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1253057","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-12-08 21:39:00","snet_input_date":"2025-12-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-08 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:35.000000Z","updated_at":"2025-12-12T10:30:56.000000Z","inspection_violations":[{"id":17381314,"change_date":"2025-12-08 21:39:00","inspection_id":"86507734","insp_violation_id":"270534369","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"210479838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-11T10:30:50.000000Z","updated_at":"2025-12-12T10:31:36.000000Z","normalized_code":"3939ALSLI"},{"id":17381315,"change_date":"2025-12-08 21:39:00","inspection_id":"86507734","insp_violation_id":"270534370","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"210479838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-11T10:30:50.000000Z","updated_at":"2025-12-12T10:31:36.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":17349214,"change_date":"2025-12-08 21:39:00","inspection_id":"86507734","insp_unit_id":"210479838","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"71","insp_unit_license":"RC48436","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1DP9X5SJ130147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:33.000000Z","updated_at":"2025-12-12T10:00:57.000000Z"},{"id":17349215,"change_date":"2025-12-08 21:39:00","inspection_id":"86507734","insp_unit_id":"210479839","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRO-P","insp_unit_company":"NONE","insp_unit_license":"F176458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3M3GL009002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:33.000000Z","updated_at":"2025-12-12T10:00:57.000000Z"}]},{"id":10200741,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","dot_number":"1076336","report_state":"MI","report_number":"MCGEJ03776","insp_date":"2025-11-12 00:00:00","insp_start_time":"1415","insp_end_time":"1453","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SB @ 4 MILE RD","county_code_state":"MI","county_code":"039","insp_level_id":"2","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1250465","transaction_code":"C","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:28.000000Z","updated_at":"2025-12-08T10:30:32.000000Z","inspection_violations":[{"id":17320072,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","insp_violation_id":"270462776","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4615862","created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:57.000000Z","normalized_code":"39141APC"},{"id":17320073,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","insp_violation_id":"270462777","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210414962","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:57.000000Z","normalized_code":"39395F"},{"id":17320074,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","insp_violation_id":"270462778","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"210414963","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:57.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":17290173,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","insp_unit_id":"210414962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"424","insp_unit_license":"RC26596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X6BJ286517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"},{"id":17290174,"change_date":"2025-12-04 21:38:00","inspection_id":"86321588","insp_unit_id":"210414963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"494","insp_unit_license":"E420468","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1S12E95336E509023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"}]},{"id":10123691,"change_date":"2025-11-05 21:40:00","inspection_id":"86240370","dot_number":"1076336","report_state":"OH","report_number":"3217000276","insp_date":"2025-11-04 00:00:00","insp_start_time":"0710","insp_end_time":"0739","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"TOLEDO OH","county_code_state":"OH","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"108246","cargo_tank":"331","hazmat_placard_req":"Y","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-11-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","viol_total":"1","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":"2503574","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-11-05 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-05 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-08T10:31:47.000000Z","updated_at":"2025-11-09T10:30:27.000000Z","inspection_violations":[{"id":16787982,"change_date":"2025-11-05 21:40:00","inspection_id":"86240370","insp_violation_id":"269739134","seq_no":"1","part_no":"172","part_no_section":"328D-HMM","insp_viol_unit":"2","insp_unit_id":"209848870","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-08T10:32:31.000000Z","updated_at":"2025-11-09T10:30:48.000000Z","normalized_code":"172328DHMM"}],"inspection_per_units":[{"id":16847773,"change_date":"2025-11-05 21:40:00","inspection_id":"86240370","insp_unit_id":"209848869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"611","insp_unit_license":"RC48432","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1D40X0TJ220190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:06.000000Z","updated_at":"2025-11-09T10:00:36.000000Z"},{"id":16847774,"change_date":"2025-11-05 21:40:00","inspection_id":"86240370","insp_unit_id":"209848870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRO-TRAIL,","insp_unit_company":"457","insp_unit_license":"F114562","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K3XL009001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:06.000000Z","updated_at":"2025-11-09T10:00:36.000000Z"}]},{"id":10138440,"change_date":"2025-11-06 21:40:00","inspection_id":"86255978","dot_number":"1076336","report_state":"MI","report_number":"MORGZ03396","insp_date":"2025-11-04 00:00:00","insp_start_time":"0821","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PLAINS","shipping_paper_number":"108247","cargo_tank":"331","hazmat_placard_req":"Y","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-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"195530","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":"1249397","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:43.000000Z","updated_at":"2025-11-10T10:31:00.000000Z","inspection_violations":[{"id":16822088,"change_date":"2025-11-06 21:40:00","inspection_id":"86255978","insp_violation_id":"269784031","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"209884841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:56.000000Z","updated_at":"2025-11-10T10:32:00.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":16876735,"change_date":"2025-11-06 21:40:00","inspection_id":"86255978","insp_unit_id":"209884841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"69","insp_unit_license":"RC48440","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYDP9X7PJ262946","insp_unit_decal":"Y","insp_unit_decal_number":"35767085","created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:32.000000Z"},{"id":16876736,"change_date":"2025-11-06 21:40:00","inspection_id":"86255978","insp_unit_id":"209884842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SIGNA","insp_unit_company":"16","insp_unit_license":"F176462","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4S9KT5387LC429014","insp_unit_decal":"Y","insp_unit_decal_number":"35767086","created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:32.000000Z"}]},{"id":10019422,"change_date":"2025-11-12 21:41:00","inspection_id":"86130591","dot_number":"1076336","report_state":"MI","report_number":"CELMS01507","insp_date":"2025-10-22 00:00:00","insp_start_time":"1555","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"107966","cargo_tank":null,"hazmat_placard_req":"Y","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-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1247069","transaction_code":"C","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-16T10:30:48.000000Z","inspection_violations":[{"id":16901129,"change_date":"2025-11-12 21:41:00","inspection_id":"86130591","insp_violation_id":"269896002","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":"X4613169","created_at":"2025-11-15T10:31:00.000000Z","updated_at":"2025-11-16T10:31:23.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":16949257,"change_date":"2025-11-12 21:41:00","inspection_id":"86130591","insp_unit_id":"209979880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"611","insp_unit_license":"RC48432","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1D40X0TJ220190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:56.000000Z"},{"id":16949258,"change_date":"2025-11-12 21:41:00","inspection_id":"86130591","insp_unit_id":"209979881","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROT","insp_unit_company":"457","insp_unit_license":"F114562","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K3XL009001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:56.000000Z"}]},{"id":9911415,"change_date":"2025-10-22 21:39:00","inspection_id":"86016323","dot_number":"1076336","report_state":"MI","report_number":"PEIFM07639","insp_date":"2025-10-09 00:00:00","insp_start_time":"2335","insp_end_time":"0000","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"496406","cargo_tank":"331","hazmat_placard_req":"Y","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1245527","transaction_code":"C","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:09.000000Z","updated_at":"2025-10-26T10:00:23.000000Z","inspection_violations":[{"id":16535539,"change_date":"2025-10-22 21:39:00","inspection_id":"86016323","insp_violation_id":"269451561","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","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-10-25T10:17:06.000000Z","updated_at":"2025-10-26T10:15:35.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":16614613,"change_date":"2025-10-22 21:39:00","inspection_id":"86016323","insp_unit_id":"209600667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"68","insp_unit_license":"RC48431","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKYDP9X5PJ262945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:25.000000Z"},{"id":16614614,"change_date":"2025-10-22 21:39:00","inspection_id":"86016323","insp_unit_id":"209600668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"F176463","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4S9KT5389MC429016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:25.000000Z"}]},{"id":9888612,"change_date":"2025-10-08 21:40:00","inspection_id":"85992492","dot_number":"1076336","report_state":"MI","report_number":"HOULD04866","insp_date":"2025-10-07 00:00:00","insp_start_time":"1138","insp_end_time":"1212","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-69EB@GRAHAM RD","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE WATER OIL TRANSPORT LLC","shipping_paper_number":"10\/7\/2025","cargo_tank":"331","hazmat_placard_req":"Y","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-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"1245232","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:49.000000Z","updated_at":"2025-10-12T10:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16406992,"change_date":"2025-10-08 21:40:00","inspection_id":"85992492","insp_unit_id":"209365682","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"434","insp_unit_license":"RC12132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2GJ104367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"},{"id":16406993,"change_date":"2025-10-08 21:40:00","inspection_id":"85992492","insp_unit_id":"209365683","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"12","insp_unit_license":"F176457","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3B4FL009006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:25.000000Z"}]},{"id":9770294,"change_date":"2025-09-24 21:42:00","inspection_id":"85868182","dot_number":"1076336","report_state":"MI","report_number":"HADZM04922","insp_date":"2025-09-19 00:00:00","insp_start_time":"0835","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COMMERCE @ GIBRALTAR","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1242945","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","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":16058864,"change_date":"2025-09-24 21:42:00","inspection_id":"85868182","insp_violation_id":"268900182","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":"2025-09-27T10:17:06.000000Z","updated_at":"2025-09-28T10:16:07.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":16186238,"change_date":"2025-09-24 21:42:00","inspection_id":"85868182","insp_unit_id":"209126904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"443","insp_unit_license":"RC12125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X1LJ397222","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":16186239,"change_date":"2025-09-24 21:42:00","inspection_id":"85868182","insp_unit_id":"209126905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DALLA","insp_unit_company":"458","insp_unit_license":"E307920","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"10158","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":9707399,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","dot_number":"1076336","report_state":"MI","report_number":"NEGUB02863","insp_date":"2025-09-16 00:00:00","insp_start_time":"0945","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 SB @ MM 17","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":"331","hazmat_placard_req":"Y","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"1241576","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:48.000000Z","updated_at":"2025-09-23T10:01:48.000000Z","inspection_violations":[{"id":15930988,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","insp_violation_id":"268756938","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209003385","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:28.000000Z","updated_at":"2025-09-22T10:16:33.000000Z","normalized_code":"3939ALHLI"},{"id":15930989,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","insp_violation_id":"268756939","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209003386","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:28.000000Z","updated_at":"2025-09-22T10:16:33.000000Z","normalized_code":"3939ALIL"},{"id":15930990,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","insp_violation_id":"268756940","seq_no":"1","part_no":"177","part_no_section":"817A-HMSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:28.000000Z","updated_at":"2025-09-22T10:16:33.000000Z","normalized_code":"177817AHMSP"}],"inspection_per_units":[{"id":16070888,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","insp_unit_id":"209003385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"71","insp_unit_license":"RC48436","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1DP9X5SJ130147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:50.000000Z","updated_at":"2025-09-21T09:45:33.000000Z"},{"id":16070889,"change_date":"2025-09-17 21:40:00","inspection_id":"85802463","insp_unit_id":"209003386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRO-P","insp_unit_company":"13","insp_unit_license":"F176458","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3M3GL009002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:50.000000Z","updated_at":"2025-09-21T09:45:33.000000Z"}]},{"id":9547098,"change_date":"2025-08-29 21:40:00","inspection_id":"85634560","dot_number":"1076336","report_state":"MI","report_number":"REBIM00322","insp_date":"2025-08-27 00:00:00","insp_start_time":"0903","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DODGE RD REST AREA, NORTHBOUND","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FOSTER BLUE WATER OIL","shipping_paper_number":"333094912","cargo_tank":null,"hazmat_placard_req":"Y","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-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1238543","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-08-29 21:40:00","snet_input_date":"2025-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-29 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:32.000000Z","updated_at":"2025-09-06T10:42:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15757803,"change_date":"2025-08-29 21:40:00","inspection_id":"85634560","insp_unit_id":"208661409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"64","insp_unit_license":"RC48439","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBDP9XXLD664839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"},{"id":15757804,"change_date":"2025-08-29 21:40:00","inspection_id":"85634560","insp_unit_id":"208661410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"496","insp_unit_license":"E808739","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"UNT000904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:53.000000Z","updated_at":"2025-09-09T09:46:53.000000Z"}]},{"id":9077939,"change_date":"2025-07-07 21:40:00","inspection_id":"85140854","dot_number":"1076336","report_state":"MI","report_number":"JURKV03078","insp_date":"2025-07-03 00:00:00","insp_start_time":"0750","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LINWOOD REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"333091629","cargo_tank":null,"hazmat_placard_req":"Y","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-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1228898","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","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":14615773,"change_date":"2025-07-07 21:40:00","inspection_id":"85140854","insp_violation_id":"267238282","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"207730693","insp_violation_category_id":"47","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:46:00.000000Z","normalized_code":"3922SLLEWA3"},{"id":14615774,"change_date":"2025-07-07 21:40:00","inspection_id":"85140854","insp_violation_id":"267238283","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"207730694","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4548494","created_at":"2025-07-10T10:42:40.000000Z","updated_at":"2025-07-11T10:46:00.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14896988,"change_date":"2025-07-07 21:40:00","inspection_id":"85140854","insp_unit_id":"207730693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"433","insp_unit_license":"BD96063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X3FJ466268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:55.000000Z"},{"id":14896989,"change_date":"2025-07-07 21:40:00","inspection_id":"85140854","insp_unit_id":"207730694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"456","insp_unit_license":"D572219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB476XW7L61960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:55.000000Z"}]},{"id":9014548,"change_date":"2025-06-27 21:39:00","inspection_id":"85073890","dot_number":"1076336","report_state":"MI","report_number":"MANIJ01901","insp_date":"2025-06-26 00:00:00","insp_start_time":"0926","insp_end_time":"0954","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"357101138","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1227559","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:24.000000Z","updated_at":"2025-07-03T10:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14784535,"change_date":"2025-06-27 21:39:00","inspection_id":"85073890","insp_unit_id":"207609173","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"433","insp_unit_license":"BD96063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X3FJ466268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:38.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"},{"id":14784536,"change_date":"2025-06-27 21:39:00","inspection_id":"85073890","insp_unit_id":"207609174","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"D572219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB476XW7L61960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:38.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"}]},{"id":8990537,"change_date":"2025-06-26 21:41:00","inspection_id":"85049007","dot_number":"1076336","report_state":"MI","report_number":"SCIBA02465","insp_date":"2025-06-25 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LANSING RD","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"306","hazmat_placard_req":"Y","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"175000","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":"1227412","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:58.000000Z","updated_at":"2025-06-30T10:00:58.000000Z","inspection_violations":[{"id":14457648,"change_date":"2025-06-26 21:41:00","inspection_id":"85049007","insp_violation_id":"267059624","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","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-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:37.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":14744982,"change_date":"2025-06-26 21:41:00","inspection_id":"85049007","insp_unit_id":"207566826","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE03997","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X0SJ170103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:15.000000Z","updated_at":"2025-07-01T09:47:23.000000Z"},{"id":14744983,"change_date":"2025-06-26 21:41:00","inspection_id":"85049007","insp_unit_id":"207566827","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"E659183","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A8D2N7L56329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:15.000000Z","updated_at":"2025-07-01T09:47:23.000000Z"}]},{"id":8963435,"change_date":"2025-06-23 21:41:00","inspection_id":"85020282","dot_number":"1076336","report_state":"MI","report_number":"ARCHH01246","insp_date":"2025-06-19 00:00:00","insp_start_time":"1415","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75@ 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX TERMINALS","shipping_paper_number":"333090854","cargo_tank":"406","hazmat_placard_req":"Y","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"153000","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":"1226719","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","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":[],"inspection_per_units":[{"id":14693807,"change_date":"2025-06-23 21:41:00","inspection_id":"85020282","insp_unit_id":"207511064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"606","insp_unit_license":"BE11579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40XXRJ349257","insp_unit_decal":"Y","insp_unit_decal_number":"35169003","created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"},{"id":14693808,"change_date":"2025-06-23 21:41:00","inspection_id":"85020282","insp_unit_id":"207511065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"474","insp_unit_license":"D985586","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486187L74534","insp_unit_decal":"Y","insp_unit_decal_number":"35169004","created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"}]},{"id":8896981,"change_date":"2025-06-13 21:40:00","inspection_id":"84949578","dot_number":"1076336","report_state":"MI","report_number":"MALIK03060","insp_date":"2025-06-13 00:00:00","insp_start_time":"0735","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ OLD SCALES","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":"0111234","cargo_tank":null,"hazmat_placard_req":"Y","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-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","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":"1225139","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-17T10:00:39.000000Z","inspection_violations":[{"id":14261326,"change_date":"2025-06-13 21:40:00","inspection_id":"84949578","insp_violation_id":"266836814","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","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-06-17T10:17:44.000000Z","updated_at":"2025-06-17T10:20:52.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":14575293,"change_date":"2025-06-13 21:40:00","inspection_id":"84949578","insp_unit_id":"207381505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":"NONE","insp_unit_license":"BA88952","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40XXHJ162521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:41.000000Z","updated_at":"2025-06-17T09:45:52.000000Z"},{"id":14575294,"change_date":"2025-06-13 21:40:00","inspection_id":"84949578","insp_unit_id":"207381506","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"263","insp_unit_license":"E871174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486537L66994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:41.000000Z","updated_at":"2025-06-17T09:45:52.000000Z"}]},{"id":8873482,"change_date":"2025-06-11 21:42:00","inspection_id":"84924538","dot_number":"1076336","report_state":"MI","report_number":"BALLB05122","insp_date":"2025-06-09 00:00:00","insp_start_time":"0811","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I696 SD @ DEQUINDRE","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BUCKEYE","shipping_paper_number":"747106","cargo_tank":"406","hazmat_placard_req":"Y","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-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"1224827","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:41.000000Z","inspection_violations":[{"id":14217837,"change_date":"2025-06-11 21:42:00","inspection_id":"84924538","insp_violation_id":"266785876","seq_no":"1","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"2","insp_unit_id":"207334860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:36.000000Z","updated_at":"2025-06-17T10:17:45.000000Z","normalized_code":"39311A1LCHL"}],"inspection_per_units":[{"id":14533301,"change_date":"2025-06-11 21:42:00","inspection_id":"84924538","insp_unit_id":"207334859","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"431","insp_unit_license":"RC12128","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X2EJ416230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"},{"id":14533302,"change_date":"2025-06-11 21:42:00","inspection_id":"84924538","insp_unit_id":"207334860","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"654","insp_unit_license":"F212066","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB4426E7H80004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"}]},{"id":8438568,"change_date":"2025-04-22 21:41:00","inspection_id":"84465565","dot_number":"1076336","report_state":"US","report_number":"1690000231","insp_date":"2025-04-22 00:00:00","insp_start_time":"0924","insp_end_time":"0951","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PLAINS LPG SERVICE","shipping_paper_number":"106325","cargo_tank":"331","hazmat_placard_req":"Y","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-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"2","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":"1629550","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:14.000000Z","updated_at":"2025-04-26T10:27:14.000000Z","inspection_violations":[{"id":13327994,"change_date":"2025-04-22 21:41:00","inspection_id":"84465565","insp_violation_id":"265760927","seq_no":"1","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"206431601","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:51:28.000000Z","updated_at":"2025-04-25T11:01:29.000000Z","normalized_code":"39348ABIAD"},{"id":13327995,"change_date":"2025-04-22 21:41:00","inspection_id":"84465565","insp_violation_id":"265760928","seq_no":"2","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"206431601","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:51:28.000000Z","updated_at":"2025-04-25T11:01:29.000000Z","normalized_code":"39348ABIAD"}],"inspection_per_units":[{"id":13705095,"change_date":"2025-04-22 21:41:00","inspection_id":"84465565","insp_unit_id":"206431600","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"441","insp_unit_license":"BE11773","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8KJ281627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:10:21.000000Z","updated_at":"2025-04-26T10:00:26.000000Z"},{"id":13705096,"change_date":"2025-04-22 21:41:00","inspection_id":"84465565","insp_unit_id":"206431601","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRO-TRAIL,","insp_unit_company":"457","insp_unit_license":"F114562","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K3XL009001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:10:21.000000Z","updated_at":"2025-04-26T10:00:26.000000Z"}]},{"id":8409285,"change_date":"2025-04-18 21:39:00","inspection_id":"84434598","dot_number":"1076336","report_state":"OH","report_number":"3200000136","insp_date":"2025-04-16 00:00:00","insp_start_time":"1235","insp_end_time":"1310","registration_date":null,"region":"ED","ci_status_code":"C","location":"01","location_desc":"CAMBRIDGE OH","county_code_state":"OH","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX","shipping_paper_number":"10054532","cargo_tank":"331","hazmat_placard_req":"Y","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-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1610048","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-04-18 21:39:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-18 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:25:22.000000Z","updated_at":"2025-04-23T10:01:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13652136,"change_date":"2025-04-18 21:39:00","inspection_id":"84434598","insp_unit_id":"206375865","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC48438","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1D49X7LJ389237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:06:23.000000Z","updated_at":"2025-04-22T09:49:01.000000Z"},{"id":13652137,"change_date":"2025-04-18 21:39:00","inspection_id":"84434598","insp_unit_id":"206375866","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"F176461","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1Z9M1AA22FA448114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:06:23.000000Z","updated_at":"2025-04-22T09:49:01.000000Z"}]},{"id":8388848,"change_date":"2025-04-16 21:40:00","inspection_id":"84413074","dot_number":"1076336","report_state":"OH","report_number":"3294000494","insp_date":"2025-04-14 00:00:00","insp_start_time":"1229","insp_end_time":"1259","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MARION OH","county_code_state":"OH","county_code":"101","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX","shipping_paper_number":"10054492","cargo_tank":"331","hazmat_placard_req":"Y","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-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1601100","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:50.000000Z","updated_at":"2025-04-20T10:23:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13616156,"change_date":"2025-04-16 21:40:00","inspection_id":"84413074","insp_unit_id":"206336695","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"66","insp_unit_license":"RC48438","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XK1D49X7LJ389237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:03:39.000000Z","updated_at":"2025-04-20T09:52:15.000000Z"},{"id":13616157,"change_date":"2025-04-16 21:40:00","inspection_id":"84413074","insp_unit_id":"206336696","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUNTRYSID","insp_unit_company":null,"insp_unit_license":"F176461","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1Z9M1AA22FA448114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:03:39.000000Z","updated_at":"2025-04-20T09:52:15.000000Z"}]},{"id":8343829,"change_date":"2025-04-10 21:41:00","inspection_id":"84365635","dot_number":"1076336","report_state":"MI","report_number":"ELDEH00761","insp_date":"2025-04-08 00:00:00","insp_start_time":"0905","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I75 @ BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPLX","shipping_paper_number":"355155406","cargo_tank":null,"hazmat_placard_req":"Y","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"175000","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":"1216809","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:24.000000Z","updated_at":"2025-04-14T10:28:24.000000Z","inspection_violations":[{"id":13136509,"change_date":"2025-04-10 21:41:00","inspection_id":"84365635","insp_violation_id":"265547728","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"206249785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-12T10:57:50.000000Z","updated_at":"2025-04-13T10:49:47.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":13535797,"change_date":"2025-04-10 21:41:00","inspection_id":"84365635","insp_unit_id":"206249785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"605","insp_unit_license":"BD27098","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8RJ349256","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:17:59.000000Z","updated_at":"2025-04-14T10:03:12.000000Z"},{"id":13535798,"change_date":"2025-04-10 21:41:00","inspection_id":"84365635","insp_unit_id":"206249786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"493","insp_unit_license":"E345129","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMA2466XY5002317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:17:59.000000Z","updated_at":"2025-04-14T10:03:12.000000Z"}]},{"id":7895151,"change_date":"2025-02-18 21:39:00","inspection_id":"83893844","dot_number":"1076336","report_state":"MI","report_number":"JURKV02899","insp_date":"2025-02-17 00:00:00","insp_start_time":"0725","insp_end_time":"0752","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"333085804","cargo_tank":null,"hazmat_placard_req":"Y","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1210184","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[{"id":12335467,"change_date":"2025-02-18 21:39:00","inspection_id":"83893844","insp_violation_id":"264565034","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-03-17T22:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12743905,"change_date":"2025-02-18 21:39:00","inspection_id":"83893844","insp_unit_id":"205372981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"445","insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:47.000000Z","updated_at":"2025-03-17T23:55:47.000000Z"},{"id":12743906,"change_date":"2025-02-18 21:39:00","inspection_id":"83893844","insp_unit_id":"205372982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"E823917","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB496617L65462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:47.000000Z","updated_at":"2025-03-17T23:55:47.000000Z"}]},{"id":7816266,"change_date":"2025-02-07 21:40:00","inspection_id":"83811000","dot_number":"1076336","report_state":"MI","report_number":"FROSR00848","insp_date":"2025-02-06 00:00:00","insp_start_time":"1010","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ REST AREA (LINWOOD)","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MARYSVILLE HYDROCARBONS","shipping_paper_number":"492422","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","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":"1209197","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:22.000000Z","updated_at":"2025-03-17T21:00:22.000000Z","inspection_violations":[{"id":12213927,"change_date":"2025-02-07 21:40:00","inspection_id":"83811000","insp_violation_id":"264402659","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4458111","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":12614098,"change_date":"2025-02-07 21:40:00","inspection_id":"83811000","insp_unit_id":"205217501","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB81338","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8KJ281627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"},{"id":12614099,"change_date":"2025-02-07 21:40:00","inspection_id":"83811000","insp_unit_id":"205217502","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROT","insp_unit_company":null,"insp_unit_license":"F114562","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K3XL009001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"}]},{"id":7616868,"change_date":"2025-01-14 21:55:00","inspection_id":"83601551","dot_number":"1076336","report_state":"MI","report_number":"NEGUB02697","insp_date":"2025-01-13 00:00:00","insp_start_time":"1100","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 S\/B @ 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":"PLAINS LPG SERVICES","shipping_paper_number":"103368","cargo_tank":"331","hazmat_placard_req":"Y","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-01-14 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1206665","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:10.000000Z","updated_at":"2025-03-17T20:56:10.000000Z","inspection_violations":[{"id":11906418,"change_date":"2025-01-14 21:55:00","inspection_id":"83601551","insp_violation_id":"263994331","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4481589","created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":12290213,"change_date":"2025-01-14 21:55:00","inspection_id":"83601551","insp_unit_id":"204827276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"431","insp_unit_license":"RC12128","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X2EJ416230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:40.000000Z","updated_at":"2025-03-17T23:50:40.000000Z"},{"id":12290214,"change_date":"2025-01-14 21:55:00","inspection_id":"83601551","insp_unit_id":"204827277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DALLA","insp_unit_company":"458","insp_unit_license":"E307920","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"10158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:40.000000Z","updated_at":"2025-03-17T23:50:40.000000Z"}]},{"id":7329130,"change_date":"2024-12-03 21:40:00","inspection_id":"83299199","dot_number":"1076336","report_state":"MI","report_number":"WARRJ02728","insp_date":"2024-12-02 00:00:00","insp_start_time":"1049","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","shipping_paper_number":"732051","cargo_tank":"406","hazmat_placard_req":"Y","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-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1202933","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11459625,"change_date":"2024-12-03 21:40:00","inspection_id":"83299199","insp_violation_id":"263197374","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"204154048","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLLEWA2"},{"id":11459626,"change_date":"2024-12-03 21:40:00","inspection_id":"83299199","insp_violation_id":"263197375","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"2","insp_unit_id":"204154049","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4446947","created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":11823210,"change_date":"2024-12-03 21:40:00","inspection_id":"83299199","insp_unit_id":"204154048","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD96063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X3FJ466268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"},{"id":11823211,"change_date":"2024-12-03 21:40:00","inspection_id":"83299199","insp_unit_id":"204154049","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"D572219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB476XW7L61960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7194809,"change_date":"2024-11-14 21:41:00","inspection_id":"83157334","dot_number":"1076336","report_state":"MI","report_number":"FELDW00357","insp_date":"2024-11-13 00:00:00","insp_start_time":"1050","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPC WHOLESALE","shipping_paper_number":"336021990","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"1201602","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:02.000000Z","updated_at":"2025-03-17T20:46:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11605257,"change_date":"2024-11-14 21:41:00","inspection_id":"83157334","insp_unit_id":"203882544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"448","insp_unit_license":"BD20246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X2PF244062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"},{"id":11605258,"change_date":"2024-11-14 21:41:00","inspection_id":"83157334","insp_unit_id":"203882545","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROPA","insp_unit_company":"450","insp_unit_license":"F114561","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3G0LL009001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":7194810,"change_date":"2024-11-14 21:41:00","inspection_id":"83157335","dot_number":"1076336","report_state":"MI","report_number":"FELDW00358","insp_date":"2024-11-13 00:00:00","insp_start_time":"1120","insp_end_time":"1200","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":"WOODHAVEN CAVERNS","shipping_paper_number":"336021991","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"162300","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":"1201593","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:02.000000Z","updated_at":"2025-03-17T20:46:02.000000Z","inspection_violations":[{"id":11242999,"change_date":"2024-11-14 21:41:00","inspection_id":"83157335","insp_violation_id":"262895974","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":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":11605259,"change_date":"2024-11-14 21:41:00","inspection_id":"83157335","insp_unit_id":"203882546","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"443","insp_unit_license":"RC12125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X1LJ397222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"},{"id":11605260,"change_date":"2024-11-14 21:41:00","inspection_id":"83157335","insp_unit_id":"203882547","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"462","insp_unit_license":"F078128","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K9YL009005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":7038776,"change_date":"2024-10-24 21:41:00","inspection_id":"82992004","dot_number":"1076336","report_state":"MI","report_number":"WARRJ02709","insp_date":"2024-10-23 00:00:00","insp_start_time":"1120","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1199309","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[{"id":10984388,"change_date":"2024-10-24 21:41:00","inspection_id":"82992004","insp_violation_id":"262541263","seq_no":"1","part_no":"393","part_no_section":"11B-CSURR","insp_viol_unit":"2","insp_unit_id":"203573714","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"39311BCSURR"}],"inspection_per_units":[{"id":11352021,"change_date":"2024-10-24 21:41:00","inspection_id":"82992004","insp_unit_id":"203573713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC26596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X6BJ286517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"},{"id":11352022,"change_date":"2024-10-24 21:41:00","inspection_id":"82992004","insp_unit_id":"203573714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":null,"insp_unit_license":"E420468","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1S12E95336E509023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6853227,"change_date":"2024-09-30 21:41:00","inspection_id":"82794771","dot_number":"1076336","report_state":"MI","report_number":"EVANT02662","insp_date":"2024-09-26 00:00:00","insp_start_time":"1350","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W HOUGHTON LAKE DR @ OAKDALE D","county_code_state":"MI","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1196443","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11051800,"change_date":"2024-09-30 21:41:00","inspection_id":"82794771","insp_unit_id":"203195103","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"424","insp_unit_license":"RC26596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X6BJ286517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"},{"id":11051801,"change_date":"2024-09-30 21:41:00","inspection_id":"82794771","insp_unit_id":"203195104","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"494","insp_unit_license":"E420468","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1S12E95336E509023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6827937,"change_date":"2024-09-26 21:40:00","inspection_id":"82767979","dot_number":"1076336","report_state":"MI","report_number":"JURKV02789","insp_date":"2024-09-25 00:00:00","insp_start_time":"1255","insp_end_time":"1352","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LINWOOD REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"355139359","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-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1196164","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:35.000000Z","updated_at":"2025-03-17T20:38:35.000000Z","inspection_violations":[{"id":10633637,"change_date":"2024-09-26 21:40:00","inspection_id":"82767979","insp_violation_id":"262052291","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203147110","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"3922"},{"id":10633638,"change_date":"2024-09-26 21:40:00","inspection_id":"82767979","insp_violation_id":"262052292","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203147111","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4441494","created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11010908,"change_date":"2024-09-26 21:40:00","inspection_id":"82767979","insp_unit_id":"203147110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"439","insp_unit_license":"BD98660","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9JJ211603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:03.000000Z","updated_at":"2025-03-17T23:37:03.000000Z"},{"id":11010909,"change_date":"2024-09-26 21:40:00","inspection_id":"82767979","insp_unit_id":"203147111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"145","insp_unit_license":"D588596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB4763W7L61881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:03.000000Z","updated_at":"2025-03-17T23:37:03.000000Z"}]},{"id":6586358,"change_date":"2024-09-17 21:45:00","inspection_id":"82510516","dot_number":"1076336","report_state":"MI","report_number":"ELDEH00613","insp_date":"2024-08-20 00:00:00","insp_start_time":"0820","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ LINWOOD RA","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"333077875","cargo_tank":null,"hazmat_placard_req":"Y","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1192652","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10240053,"change_date":"2024-09-17 21:45:00","inspection_id":"82510516","insp_violation_id":"261862187","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":"X4421003","created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"},{"id":10240054,"change_date":"2024-09-17 21:45:00","inspection_id":"82510516","insp_violation_id":"261862188","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:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10618372,"change_date":"2024-09-17 21:45:00","inspection_id":"82510516","insp_unit_id":"202977856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"445","insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"},{"id":10618373,"change_date":"2024-09-17 21:45:00","inspection_id":"82510516","insp_unit_id":"202977857","insp_unit_type_id":"12","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"482","insp_unit_license":"D754885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D7R7L57432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":6423855,"change_date":"2024-09-17 21:45:00","inspection_id":"82337400","dot_number":"1076336","report_state":"MI","report_number":"COPEK02771","insp_date":"2024-08-08 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ CROOKS","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WOODHAVEN CAVERNS","shipping_paper_number":"336020833","cargo_tank":"330","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1189445","transaction_code":"C","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-08-08 21:42:00","snet_input_date":"2024-08-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","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":9974396,"change_date":"2024-09-17 21:45:00","inspection_id":"82337400","insp_violation_id":"261860304","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:54:14.000000Z","updated_at":"2025-03-17T21:54:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10353017,"change_date":"2024-09-17 21:45:00","inspection_id":"82337400","insp_unit_id":"202976436","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"448","insp_unit_license":"BD20246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X2PF244062","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":10353018,"change_date":"2024-09-17 21:45:00","inspection_id":"82337400","insp_unit_id":"202976437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROPA","insp_unit_company":"450","insp_unit_license":"D754882","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3G0LL009001","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":6586572,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","dot_number":"1076336","report_state":"MI","report_number":"WARRJ02584","insp_date":"2024-06-18 00:00:00","insp_start_time":"1912","insp_end_time":"1955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"0000717077","cargo_tank":"406","hazmat_placard_req":"Y","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-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192387","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-08-28 21:43:00","snet_input_date":"2024-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:43:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10240488,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","insp_violation_id":"261467764","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":"X4375530","created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"},{"id":10240489,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","insp_violation_id":"261467765","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:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"},{"id":10240490,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","insp_violation_id":"261467766","seq_no":"3","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:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10618731,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","insp_unit_id":"202633129","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"447","insp_unit_license":"BD09346","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X0PF244061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"},{"id":10618732,"change_date":"2024-08-28 21:43:00","inspection_id":"82510757","insp_unit_id":"202633130","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"145","insp_unit_license":"D588596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB4763W7L61881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":5995670,"change_date":"2024-06-14 21:40:00","inspection_id":"81877733","dot_number":"1076336","report_state":"MI","report_number":"COPEK02651","insp_date":"2024-06-14 00:00:00","insp_start_time":"1340","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ OLD SCALES","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPC WHOLESALE","shipping_paper_number":"336020438","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1182686","transaction_code":"A","transaction_date":"2024-06-14 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:30.000000Z","updated_at":"2025-03-17T20:21:30.000000Z","inspection_violations":[{"id":9300821,"change_date":"2024-06-14 21:40:00","inspection_id":"81877733","insp_violation_id":"260093543","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201402580","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9656914,"change_date":"2024-06-14 21:40:00","inspection_id":"81877733","insp_unit_id":"201402579","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"448","insp_unit_license":"BD20246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X2PF244062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:05.000000Z","updated_at":"2025-03-17T23:23:05.000000Z"},{"id":9656915,"change_date":"2024-06-14 21:40:00","inspection_id":"81877733","insp_unit_id":"201402580","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PROTE","insp_unit_company":"462","insp_unit_license":"D950816","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K9YL009005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:05.000000Z","updated_at":"2025-03-17T23:23:05.000000Z"}]},{"id":5277462,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","dot_number":"1076336","report_state":"MI","report_number":"PEASS02723","insp_date":"2024-03-12 00:00:00","insp_start_time":"0920","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ LINWOOD REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FOSTER BLUE OIL","shipping_paper_number":"355122160","cargo_tank":"306","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1168765","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-03-13 21:42:00","snet_input_date":"2024-03-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-13 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:07.000000Z","updated_at":"2025-03-17T20:07:07.000000Z","inspection_violations":[{"id":8137688,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","insp_violation_id":"258361466","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199893875","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:18.000000Z","updated_at":"2025-03-17T21:45:18.000000Z","normalized_code":"3922"},{"id":8137689,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","insp_violation_id":"258361467","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199893876","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4318173","created_at":"2025-03-17T21:45:18.000000Z","updated_at":"2025-03-17T21:45:18.000000Z","normalized_code":"3922"},{"id":8137690,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","insp_violation_id":"258361468","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199893876","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:18.000000Z","updated_at":"2025-03-17T21:45:18.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8498373,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","insp_unit_id":"199893875","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"606","insp_unit_license":"BD27099","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40XXRJ349257","insp_unit_decal":"Y","insp_unit_decal_number":"00000000","created_at":"2025-03-17T23:12:00.000000Z","updated_at":"2025-03-17T23:12:00.000000Z"},{"id":8498374,"change_date":"2024-03-13 21:42:00","inspection_id":"81096038","insp_unit_id":"199893876","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"144","insp_unit_license":"E003051","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA3A8D9N7L56330","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:00.000000Z","updated_at":"2025-03-17T23:12:00.000000Z"}]},{"id":4921130,"change_date":"2024-01-29 21:39:00","inspection_id":"80706906","dot_number":"1076336","report_state":"MI","report_number":"WARRJ02424","insp_date":"2024-01-26 00:00:00","insp_start_time":"1535","insp_end_time":"1555","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","shipping_paper_number":"95354","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1161951","transaction_code":"A","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2024-01-29 21:39:00","snet_input_date":"2024-01-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-29 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:25.000000Z","updated_at":"2025-03-17T20:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7919265,"change_date":"2024-01-29 21:39:00","inspection_id":"80706906","insp_unit_id":"199150234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"448","insp_unit_license":"BD20246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X2PF244062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:47.000000Z","updated_at":"2025-03-17T23:06:47.000000Z"},{"id":7919266,"change_date":"2024-01-29 21:39:00","inspection_id":"80706906","insp_unit_id":"199150235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RNG","insp_unit_company":null,"insp_unit_license":"D950816","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3K9YL009005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:47.000000Z","updated_at":"2025-03-17T23:06:47.000000Z"}]},{"id":4528165,"change_date":"2023-11-30 21:38:00","inspection_id":"80276911","dot_number":"1076336","report_state":"MI","report_number":"MOREM04926","insp_date":"2023-11-30 00:00:00","insp_start_time":"1100","insp_end_time":"1132","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B FOWLERVILLE SCALES","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MPC WHOLESALE","shipping_paper_number":"336017305","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-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"177000","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":"1155399","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7006254,"change_date":"2023-11-30 21:38:00","inspection_id":"80276911","insp_violation_id":"256641566","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":"X4310883","created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7282627,"change_date":"2023-11-30 21:38:00","inspection_id":"80276911","insp_unit_id":"198285143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"443","insp_unit_license":"RC12125","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X1LJ397222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"},{"id":7282628,"change_date":"2023-11-30 21:38:00","inspection_id":"80276911","insp_unit_id":"198285144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"452","insp_unit_license":"D950819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3JXTL009009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4463773,"change_date":"2023-11-20 21:40:00","inspection_id":"80206112","dot_number":"1076336","report_state":"MI","report_number":"SAHIW01217","insp_date":"2023-11-17 00:00:00","insp_start_time":"2115","insp_end_time":"2135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB-I-75 @ BALDWIN RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"2023-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1154013","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-11-20 21:40:00","snet_input_date":"2023-11-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-20 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:23.000000Z","updated_at":"2025-03-17T19:51:23.000000Z","inspection_violations":[{"id":6908821,"change_date":"2023-11-20 21:40:00","inspection_id":"80206112","insp_violation_id":"256490259","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:39:20.000000Z","updated_at":"2025-03-17T21:39:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7178737,"change_date":"2023-11-20 21:40:00","inspection_id":"80206112","insp_unit_id":"198146294","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"481","insp_unit_license":"E871175","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D8P7L56870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"},{"id":7178738,"change_date":"2023-11-20 21:40:00","inspection_id":"80206112","insp_unit_id":"198146295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"442","insp_unit_license":"BC16492","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40XXLJ397221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:16.000000Z","updated_at":"2025-03-17T23:00:16.000000Z"}]},{"id":4362510,"change_date":"2023-11-06 21:42:00","inspection_id":"80094164","dot_number":"1076336","report_state":"MI","report_number":"BURGM05690","insp_date":"2023-11-03 00:00:00","insp_start_time":"1110","insp_end_time":"1148","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":"MPC WOLESALE","shipping_paper_number":"336016629","cargo_tank":"331","hazmat_placard_req":"Y","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-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1152278","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-11-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:29.000000Z","updated_at":"2025-03-17T19:49:29.000000Z","inspection_violations":[{"id":6748300,"change_date":"2023-11-06 21:42:00","inspection_id":"80094164","insp_violation_id":"256237490","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":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3922"},{"id":6748301,"change_date":"2023-11-06 21:42:00","inspection_id":"80094164","insp_violation_id":"256237491","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:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7016196,"change_date":"2023-11-06 21:42:00","inspection_id":"80094164","insp_unit_id":"197923554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"605","insp_unit_license":"BD27098","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X8RJ349256","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:54.000000Z","updated_at":"2025-03-17T22:58:54.000000Z"},{"id":7016197,"change_date":"2023-11-06 21:42:00","inspection_id":"80094164","insp_unit_id":"197923555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"452","insp_unit_license":"D950819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3JXTL009009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:54.000000Z","updated_at":"2025-03-17T22:58:54.000000Z"}]},{"id":4013316,"change_date":"2023-09-20 21:39:00","inspection_id":"79707515","dot_number":"1076336","report_state":"MI","report_number":"WARRJ02292","insp_date":"2023-09-19 00:00:00","insp_start_time":"1545","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ MAPLE RD","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PLAINS LPG","shipping_paper_number":"89771","cargo_tank":"331","hazmat_placard_req":"Y","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-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1146780","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:03.000000Z","updated_at":"2025-03-17T19:42:03.000000Z","inspection_violations":[{"id":6209400,"change_date":"2023-09-20 21:39:00","inspection_id":"79707515","insp_violation_id":"255373373","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":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6453108,"change_date":"2023-09-20 21:39:00","inspection_id":"79707515","insp_unit_id":"197144372","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BB81337","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X6KJ281626","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"},{"id":6453109,"change_date":"2023-09-20 21:39:00","inspection_id":"79707515","insp_unit_id":"197144373","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"D950815","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3J9VL009010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3674735,"change_date":"2023-08-29 21:42:00","inspection_id":"79330390","dot_number":"1076336","report_state":"MI","report_number":"BOLLJ00628","insp_date":"2023-08-02 00:00:00","insp_start_time":"1150","insp_end_time":"1216","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PONTIAC SCALE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1138544","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5908146,"change_date":"2023-08-29 21:42:00","inspection_id":"79330390","insp_unit_id":"196789587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"BC95732","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X4NF123448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"},{"id":5908147,"change_date":"2023-08-29 21:42:00","inspection_id":"79330390","insp_unit_id":"196789588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"163","insp_unit_license":"E871174","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB486537L66994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3323313,"change_date":"2023-06-20 21:41:00","inspection_id":"78935693","dot_number":"1076336","report_state":"MI","report_number":"COPEK02165","insp_date":"2023-06-16 00:00:00","insp_start_time":"1040","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ 21 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KIROS ENERGY MAKETING ULC","shipping_paper_number":"336015241","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1131294","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-06-20 21:41:00","snet_input_date":"2023-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:53.000000Z","updated_at":"2025-03-17T19:28:53.000000Z","inspection_violations":[{"id":5125747,"change_date":"2023-06-20 21:41:00","inspection_id":"78935693","insp_violation_id":"253599661","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195582537","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5342326,"change_date":"2023-06-20 21:41:00","inspection_id":"78935693","insp_unit_id":"195582536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"431","insp_unit_license":"RC12128","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X2EJ416230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"},{"id":5342327,"change_date":"2023-06-20 21:41:00","inspection_id":"78935693","insp_unit_id":"195582537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COUI","insp_unit_company":"488","insp_unit_license":"E455877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1Z9M1AA2XFA448118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":3304336,"change_date":"2023-06-16 21:40:00","inspection_id":"78914379","dot_number":"1076336","report_state":"MI","report_number":"DAWDD02803","insp_date":"2023-06-15 00:00:00","insp_start_time":"1318","insp_end_time":"1354","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FORT ST AT SCHAEFER","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MPLX","shipping_paper_number":"334349083","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","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":"1130769","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-06-16 21:40:00","snet_input_date":"2023-06-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5095619,"change_date":"2023-06-16 21:40:00","inspection_id":"78914379","insp_violation_id":"253553235","seq_no":"1","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"195541152","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":5312388,"change_date":"2023-06-16 21:40:00","inspection_id":"78914379","insp_unit_id":"195541152","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"430","insp_unit_license":"RC12130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDP4EX6EJ416229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5312389,"change_date":"2023-06-16 21:40:00","inspection_id":"78914379","insp_unit_id":"195541153","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"496","insp_unit_license":"E808739","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"UNT000904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":2532141,"change_date":"2023-03-08 21:40:00","inspection_id":"78039268","dot_number":"1076336","report_state":"MI","report_number":"BURGM05159","insp_date":"2023-03-08 00:00:00","insp_start_time":"0735","insp_end_time":"0802","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"JASON RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FOSTER BLUE WATER OIL","shipping_paper_number":"6396","cargo_tank":"306","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1116581","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-03-08 21:40:00","snet_input_date":"2023-03-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-08 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:21.000000Z","updated_at":"2025-03-17T19:13:21.000000Z","inspection_violations":[{"id":3891926,"change_date":"2023-03-08 21:40:00","inspection_id":"78039268","insp_violation_id":"251540878","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:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3891927,"change_date":"2023-03-08 21:40:00","inspection_id":"78039268","insp_violation_id":"251540879","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193767193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4075600,"change_date":"2023-03-08 21:40:00","inspection_id":"78039268","insp_unit_id":"193767192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"445","insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:13.000000Z","updated_at":"2025-03-17T22:35:13.000000Z"},{"id":4075601,"change_date":"2023-03-08 21:40:00","inspection_id":"78039268","insp_unit_id":"193767193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"482","insp_unit_license":"D754885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D7R7L57432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:13.000000Z","updated_at":"2025-03-17T22:35:13.000000Z"}]},{"id":2491982,"change_date":"2023-03-02 21:41:00","inspection_id":"77993746","dot_number":"1076336","report_state":"MI","report_number":"POWED04024","insp_date":"2023-02-28 00:00:00","insp_start_time":"1540","insp_end_time":"1610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ HAGGERTY","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARYSVILLE HYDROCARBNS","shipping_paper_number":"474099","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"184350","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":"1115668","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2023-03-02 21:41:00","snet_input_date":"2023-02-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:32.000000Z","updated_at":"2025-03-17T19:12:32.000000Z","inspection_violations":[{"id":3833055,"change_date":"2023-03-02 21:41:00","inspection_id":"77993746","insp_violation_id":"251442734","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:25:00.000000Z","updated_at":"2025-03-17T21:25:00.000000Z","normalized_code":"3922"},{"id":3833056,"change_date":"2023-03-02 21:41:00","inspection_id":"77993746","insp_violation_id":"251442735","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193675144","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:00.000000Z","updated_at":"2025-03-17T21:25:00.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4009985,"change_date":"2023-03-02 21:41:00","inspection_id":"77993746","insp_unit_id":"193675144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"430","insp_unit_license":"RC12130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDP4EX6EJ416229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:42.000000Z","updated_at":"2025-03-17T22:34:42.000000Z"},{"id":4009986,"change_date":"2023-03-02 21:41:00","inspection_id":"77993746","insp_unit_id":"193675145","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"455","insp_unit_license":"D950815","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3J9VL009010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:42.000000Z","updated_at":"2025-03-17T22:34:42.000000Z"}]},{"id":1902967,"change_date":"2022-12-08 21:41:00","inspection_id":"77320814","dot_number":"1076336","report_state":"MI","report_number":"WARRJ01971","insp_date":"2022-12-07 00:00:00","insp_start_time":"1635","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":"330","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1104658","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[{"id":2959841,"change_date":"2022-12-08 21:41:00","inspection_id":"77320814","insp_violation_id":"249995712","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192330189","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:04.000000Z","updated_at":"2025-03-17T21:21:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3062402,"change_date":"2022-12-08 21:41:00","inspection_id":"77320814","insp_unit_id":"192330189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"419","insp_unit_license":"RC12133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDU9X57J177956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"},{"id":3062403,"change_date":"2022-12-08 21:41:00","inspection_id":"77320814","insp_unit_id":"192330190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PRO P","insp_unit_company":"452","insp_unit_license":"D950819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3JXTL009009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1414200,"change_date":"2022-09-30 21:39:00","inspection_id":"76759286","dot_number":"1076336","report_state":"MI","report_number":"DAWDD02181","insp_date":"2022-09-29 00:00:00","insp_start_time":"1032","insp_end_time":"1102","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 AT OLD SCALE","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FOSTER OIL","shipping_paper_number":"09292022","cargo_tank":"306","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","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":"1096892","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-09-30 21:39:00","snet_input_date":"2022-09-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-30 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:43.000000Z","updated_at":"2025-03-17T18:52:43.000000Z","inspection_violations":[{"id":2227881,"change_date":"2022-09-30 21:39:00","inspection_id":"76759286","insp_violation_id":"248760888","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191206691","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:13.000000Z","updated_at":"2025-03-17T21:17:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2276600,"change_date":"2022-09-30 21:39:00","inspection_id":"76759286","insp_unit_id":"191206690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"426","insp_unit_license":"RC12127","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X4CJ325196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:35.000000Z","updated_at":"2025-03-17T22:22:35.000000Z"},{"id":2276601,"change_date":"2022-09-30 21:39:00","inspection_id":"76759286","insp_unit_id":"191206691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"461","insp_unit_license":"D422157","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"927227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:35.000000Z","updated_at":"2025-03-17T22:22:35.000000Z"}]},{"id":1064079,"change_date":"2022-08-17 21:40:00","inspection_id":"76352507","dot_number":"1076336","report_state":"MI","report_number":"BOHNE01418","insp_date":"2022-08-05 00:00:00","insp_start_time":"1509","insp_end_time":"1536","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I69 @ M53","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MARYSVILLE HYDROCARBONS LLC","shipping_paper_number":"469989","cargo_tank":"331","hazmat_placard_req":"Y","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-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121061","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":"1089820","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:30.000000Z","updated_at":"2025-03-17T18:46:30.000000Z","inspection_violations":[{"id":1679009,"change_date":"2022-08-17 21:40:00","inspection_id":"76352507","insp_violation_id":"247793419","seq_no":"1","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"190374655","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:49.000000Z","updated_at":"2025-03-17T21:14:49.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":1712278,"change_date":"2022-08-17 21:40:00","inspection_id":"76352507","insp_unit_id":"190374655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"434","insp_unit_license":"RC12132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2GJ104367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"},{"id":1712279,"change_date":"2022-08-17 21:40:00","inspection_id":"76352507","insp_unit_id":"190374656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUBB","insp_unit_company":"454","insp_unit_license":"E187319","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"59061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:48.000000Z","updated_at":"2025-03-17T22:18:48.000000Z"}]},{"id":956780,"change_date":"2022-08-03 21:42:00","inspection_id":"76227194","dot_number":"1076336","report_state":"MI","report_number":"BARTT03399","insp_date":"2022-08-02 00:00:00","insp_start_time":"1550","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/BI69@LAKE NEPESSING","county_code_state":"MI","county_code":"087","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":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"1087150","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-08-03 21:42:00","snet_input_date":"2022-08-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:26.000000Z","updated_at":"2025-03-17T18:44:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1539568,"change_date":"2022-08-03 21:42:00","inspection_id":"76227194","insp_unit_id":"190116832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"0","insp_unit_license":"NOPLATE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKMHD7X3YS847260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:41.000000Z","updated_at":"2025-03-17T22:17:41.000000Z"}]},{"id":573738,"change_date":"2022-06-09 21:42:00","inspection_id":"75776499","dot_number":"1076336","report_state":"MI","report_number":"HOULD02968","insp_date":"2022-06-06 00:00:00","insp_start_time":"1605","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-69EB@CAPAC RD","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"1078939","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-06-09 21:42:00","snet_input_date":"2022-06-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-09 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:47.000000Z","updated_at":"2025-03-17T18:37:47.000000Z","inspection_violations":[{"id":897508,"change_date":"2022-06-09 21:42:00","inspection_id":"75776499","insp_violation_id":"246327943","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":922675,"change_date":"2022-06-09 21:42:00","inspection_id":"75776499","insp_unit_id":"189141128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"419","insp_unit_license":"RC12133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDU9X57J177956","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"},{"id":922676,"change_date":"2022-06-09 21:42:00","inspection_id":"75776499","insp_unit_id":"189141129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"452","insp_unit_license":"D950819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3JXTL009009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"}]},{"id":309437,"change_date":"2022-06-09 21:42:00","inspection_id":"75462392","dot_number":"1076336","report_state":"MI","report_number":"JURKV01701","insp_date":"2022-05-02 00:00:00","insp_start_time":"0845","insp_end_time":"0938","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0000649581","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","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":"1074269","transaction_code":"C","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:57.000000Z","updated_at":"2025-03-17T18:32:57.000000Z","inspection_violations":[{"id":480610,"change_date":"2022-06-09 21:42:00","inspection_id":"75462392","insp_violation_id":"246336225","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":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":500618,"change_date":"2022-06-09 21:42:00","inspection_id":"75462392","insp_unit_id":"189147398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"445","insp_unit_license":"BC95733","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3WKDD40X6NF123449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"},{"id":500619,"change_date":"2022-06-09 21:42:00","inspection_id":"75462392","insp_unit_id":"189147399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"482","insp_unit_license":"D754885","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HLA4A8D7R7L57432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"}]},{"id":62106,"change_date":"2022-03-29 21:42:00","inspection_id":"75164320","dot_number":"1076336","report_state":"MI","report_number":"HARRK00702","insp_date":"2022-03-28 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ BELLEVILLE RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PLAINS LPG","shipping_paper_number":"77382","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"1069381","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01076336","upload_search_indicator":null,"census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"BLUE WATER OIL TRANSPORT LLC","insp_carrier_street":"36065 WATER STREET","insp_carrier_city":"RICHMOND","insp_carrier_state":"MI","insp_carrier_zip_code":"48062","insp_colonia":null,"docket_number":"317018","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":100873,"change_date":"2022-03-29 21:42:00","inspection_id":"75164320","insp_unit_id":"187872902","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"434","insp_unit_license":"RB88624","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X2GJ104367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100874,"change_date":"2022-03-29 21:42:00","inspection_id":"75164320","insp_unit_id":"187872903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"452","insp_unit_license":"D950819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2P9B3P3JXTL009009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/1076336\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/1076336\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/1076336\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/1076336\/inspections","per_page":100,"prev_page_url":null,"to":58,"total":58}