{"current_page":1,"data":[{"id":12066657,"change_date":"2026-06-01 21:41:00","inspection_id":"88008646","dot_number":"476933","report_state":"MI","report_number":"GUTHG02937","insp_date":"2026-06-01 00:00:00","insp_start_time":"1020","insp_end_time":"1151","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CHESAING MIDDLE SCHOOL","shipping_paper_number":"11421-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"3442259","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:04.000000Z","updated_at":"2026-06-12T09:31:02.000000Z","inspection_violations":[{"id":20995768,"change_date":"2026-06-01 21:41:00","inspection_id":"88008646","insp_violation_id":"274618729","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"213851071","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:41.000000Z","updated_at":"2026-06-12T09:41:54.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":20970481,"change_date":"2026-06-01 21:41:00","inspection_id":"88008646","insp_unit_id":"213851071","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1348","insp_unit_license":"RC27246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:35.000000Z","updated_at":"2026-06-12T09:02:29.000000Z"}]},{"id":12067962,"change_date":"2026-06-01 21:41:00","inspection_id":"88010006","dot_number":"476933","report_state":"MI","report_number":"GUTHG02936","insp_date":"2026-06-01 00:00:00","insp_start_time":"0905","insp_end_time":"1006","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CHESANING MIDDLE SCHOOL","shipping_paper_number":"11421-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"3441374","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:06.000000Z","updated_at":"2026-06-12T09:31:11.000000Z","inspection_violations":[{"id":20997691,"change_date":"2026-06-01 21:41:00","inspection_id":"88010006","insp_violation_id":"274621262","seq_no":"1","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"213853553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:48.000000Z","updated_at":"2026-06-12T09:42:15.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":20972574,"change_date":"2026-06-01 21:41:00","inspection_id":"88010006","insp_unit_id":"213853553","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1344","insp_unit_license":"RC27245","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA95P1000344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:40.000000Z","updated_at":"2026-06-12T09:02:43.000000Z"}]},{"id":12001357,"change_date":"2026-05-23 21:34:00","inspection_id":"87939833","dot_number":"476933","report_state":"OH","report_number":"3205000454","insp_date":"2026-05-21 00:00:00","insp_start_time":"1055","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":"CP","location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNIVERSITY LIGGETT SCHOOL","shipping_paper_number":"FC MG","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-23 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3388691","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-05-23 21:34:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-23 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-26T09:42:17.000000Z","updated_at":"2026-06-03T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20862744,"change_date":"2026-05-23 21:34:00","inspection_id":"87939833","insp_unit_id":"213719685","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":"9735","insp_unit_license":"RC23520","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNAXLW069735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-26T09:20:15.000000Z","updated_at":"2026-06-03T09:01:47.000000Z"}]},{"id":12001135,"change_date":"2026-05-23 21:34:00","inspection_id":"87939596","dot_number":"476933","report_state":"OH","report_number":"9465000057","insp_date":"2026-05-21 00:00:00","insp_start_time":"1110","insp_end_time":"1154","registration_date":null,"region":"ED","ci_status_code":"C","location":"CP","location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BROWNSTOWN MIDDLE SCHOOL","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":"U","pen_cen_match":"I","final_status_date":"2026-05-23 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3388127","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-05-23 21:34:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-23 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-26T09:42:17.000000Z","updated_at":"2026-06-03T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20862396,"change_date":"2026-05-23 21:34:00","inspection_id":"87939596","insp_unit_id":"213719298","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":"1351","insp_unit_license":"RC27242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000351","insp_unit_decal":"Y","insp_unit_decal_number":"None","created_at":"2026-05-26T09:20:14.000000Z","updated_at":"2026-06-03T09:01:42.000000Z"}]},{"id":12000920,"change_date":"2026-05-23 21:34:00","inspection_id":"87939373","dot_number":"476933","report_state":"OH","report_number":"9460000084","insp_date":"2026-05-21 00:00:00","insp_start_time":"1050","insp_end_time":"1155","registration_date":null,"region":"ED","ci_status_code":"C","location":"CP","location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BROWNSTOWN MIDDLE SCHOOL","shipping_paper_number":"5797","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-23 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"3388131","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-05-23 21:34:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-23 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-26T09:42:17.000000Z","updated_at":"2026-06-03T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20862067,"change_date":"2026-05-23 21:34:00","inspection_id":"87939373","insp_unit_id":"213718943","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":"3263","insp_unit_license":"RC27244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA55N1000263","insp_unit_decal":"Y","insp_unit_decal_number":"36291465","created_at":"2026-05-26T09:20:14.000000Z","updated_at":"2026-06-03T09:01:42.000000Z"}]},{"id":11883441,"change_date":"2026-05-12 21:39:00","inspection_id":"87821182","dot_number":"476933","report_state":"MI","report_number":"MDTKH03118","insp_date":"2026-05-12 00:00:00","insp_start_time":"0800","insp_end_time":"0829","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"3304457","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:26.000000Z","updated_at":"2026-05-23T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20661782,"change_date":"2026-05-12 21:39:00","inspection_id":"87821182","insp_unit_id":"213499568","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":null,"insp_unit_license":"RC52054","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB91S1000655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:25.000000Z","updated_at":"2026-05-23T09:03:15.000000Z"}]},{"id":11883426,"change_date":"2026-05-12 21:39:00","inspection_id":"87821167","dot_number":"476933","report_state":"MI","report_number":"MDTKH03117","insp_date":"2026-05-12 00:00:00","insp_start_time":"0830","insp_end_time":"0859","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"3304475","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:26.000000Z","updated_at":"2026-05-23T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20661760,"change_date":"2026-05-12 21:39:00","inspection_id":"87821167","insp_unit_id":"213499536","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":null,"insp_unit_license":"RC27254","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB99S1000645","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:25.000000Z","updated_at":"2026-05-23T09:03:15.000000Z"}]},{"id":11744262,"change_date":"2026-04-24 21:41:00","inspection_id":"87673672","dot_number":"476933","report_state":"MI","report_number":"MDTKH03099","insp_date":"2026-04-23 00:00:00","insp_start_time":"0900","insp_end_time":"0951","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY,TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1267039","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:32.000000Z","updated_at":"2026-05-05T09:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20434096,"change_date":"2026-04-24 21:41:00","inspection_id":"87673672","insp_unit_id":"213208788","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"3362","insp_unit_license":"RC41047","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA5XR1000362","insp_unit_decal":"Y","insp_unit_decal_number":"36394612","created_at":"2026-04-27T09:21:34.000000Z","updated_at":"2026-05-05T09:04:33.000000Z"}]},{"id":11744263,"change_date":"2026-04-24 21:41:00","inspection_id":"87673673","dot_number":"476933","report_state":"MI","report_number":"MDTKH03100","insp_date":"2026-04-23 00:00:00","insp_start_time":"0946","insp_end_time":"1019","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1267154","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-24 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:32.000000Z","updated_at":"2026-05-05T09:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20434097,"change_date":"2026-04-24 21:41:00","inspection_id":"87673673","insp_unit_id":"213208789","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"3361","insp_unit_license":"RC27271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA58R1000361","insp_unit_decal":"Y","insp_unit_decal_number":"36394613","created_at":"2026-04-27T09:21:34.000000Z","updated_at":"2026-05-05T09:04:33.000000Z"}]},{"id":11454835,"change_date":"2026-03-23 21:51:00","inspection_id":"87372553","dot_number":"476933","report_state":"MI","report_number":"MDTRL02872","insp_date":"2026-03-23 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1263551","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618698,"change_date":"2026-03-23 21:51:00","inspection_id":"87372553","insp_unit_id":"212288800","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9761","insp_unit_license":"RC27256","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B2J3049761","insp_unit_decal":"Y","insp_unit_decal_number":"36056669","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11454836,"change_date":"2026-03-23 21:51:00","inspection_id":"87372554","dot_number":"476933","report_state":"MI","report_number":"MDTRL02873","insp_date":"2026-03-23 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1263601","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618699,"change_date":"2026-03-23 21:51:00","inspection_id":"87372554","insp_unit_id":"212288801","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1317","insp_unit_license":"RC27210","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B9K3081317","insp_unit_decal":"Y","insp_unit_decal_number":"36056670","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11454852,"change_date":"2026-03-23 21:51:00","inspection_id":"87372573","dot_number":"476933","report_state":"MI","report_number":"MDTRL02876","insp_date":"2026-03-23 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"1263623","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618725,"change_date":"2026-03-23 21:51:00","inspection_id":"87372573","insp_unit_id":"212288833","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1599","insp_unit_license":"RC27269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB96S1000599","insp_unit_decal":"Y","insp_unit_decal_number":"36056673","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11454853,"change_date":"2026-03-23 21:51:00","inspection_id":"87372574","dot_number":"476933","report_state":"MI","report_number":"MDTRL02877","insp_date":"2026-03-23 00:00:00","insp_start_time":"1300","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1263691","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618726,"change_date":"2026-03-23 21:51:00","inspection_id":"87372574","insp_unit_id":"212288834","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9408","insp_unit_license":"RC27259","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B5H3049408","insp_unit_decal":"Y","insp_unit_decal_number":"36056674","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11454851,"change_date":"2026-03-23 21:51:00","inspection_id":"87372572","dot_number":"476933","report_state":"MI","report_number":"MDTRL02875","insp_date":"2026-03-23 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1263577","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618724,"change_date":"2026-03-23 21:51:00","inspection_id":"87372572","insp_unit_id":"212288832","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8689","insp_unit_license":"RC27258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA0JW068689","insp_unit_decal":"Y","insp_unit_decal_number":"36056672","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11454850,"change_date":"2026-03-23 21:51:00","inspection_id":"87372571","dot_number":"476933","report_state":"MI","report_number":"MDTRL02874","insp_date":"2026-03-23 00:00:00","insp_start_time":"1020","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1263654","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-26T09:41:42.000000Z","updated_at":"2026-04-03T09:33:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19618723,"change_date":"2026-03-23 21:51:00","inspection_id":"87372571","insp_unit_id":"212288831","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9403","insp_unit_license":"RC27266","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B6H3049403","insp_unit_decal":"Y","insp_unit_decal_number":"36056671","created_at":"2026-03-26T09:18:51.000000Z","updated_at":"2026-04-03T09:07:00.000000Z"}]},{"id":11227784,"change_date":"2026-03-06 21:42:00","inspection_id":"87139863","dot_number":"476933","report_state":"MI","report_number":"MDTRL02849","insp_date":"2026-02-24 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1260394","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343712,"change_date":"2026-03-06 21:42:00","inspection_id":"87139863","insp_unit_id":"212013548","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3208","insp_unit_license":"RC27265","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLM57L1000208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11227800,"change_date":"2026-03-06 21:42:00","inspection_id":"87139879","dot_number":"476933","report_state":"MI","report_number":"MDTRL99803","insp_date":"2026-01-08 00:00:00","insp_start_time":"1400","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1260385","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343735,"change_date":"2026-03-06 21:42:00","inspection_id":"87139879","insp_unit_id":"212013582","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1318","insp_unit_license":"RC27251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM86M1000318","insp_unit_decal":"Y","insp_unit_decal_number":"36056595","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11227801,"change_date":"2026-03-06 21:42:00","inspection_id":"87139880","dot_number":"476933","report_state":"MI","report_number":"MDTRL99804","insp_date":"2026-01-08 00:00:00","insp_start_time":"1310","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1260546","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343736,"change_date":"2026-03-06 21:42:00","inspection_id":"87139880","insp_unit_id":"212013583","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"9734","insp_unit_license":"RC27261","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNA8LW069734","insp_unit_decal":"Y","insp_unit_decal_number":"36056594","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11227802,"change_date":"2026-03-06 21:42:00","inspection_id":"87139881","dot_number":"476933","report_state":"MI","report_number":"MDTRL99805","insp_date":"2026-01-08 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1260361","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343737,"change_date":"2026-03-06 21:42:00","inspection_id":"87139881","insp_unit_id":"212013596","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1319","insp_unit_license":"RC27250","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM88M1000319","insp_unit_decal":"Y","insp_unit_decal_number":"36056593","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11227803,"change_date":"2026-03-06 21:42:00","inspection_id":"87139882","dot_number":"476933","report_state":"MI","report_number":"MDTRL99806","insp_date":"2026-01-08 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1260396","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343738,"change_date":"2026-03-06 21:42:00","inspection_id":"87139882","insp_unit_id":"212013597","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"9735","insp_unit_license":"RC23520","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNAXLW069735","insp_unit_decal":"Y","insp_unit_decal_number":"36056592","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":10019588,"change_date":"2025-10-23 21:39:00","inspection_id":"86130770","dot_number":"476933","report_state":"MI","report_number":"MDTBB02431","insp_date":"2025-10-22 00:00:00","insp_start_time":"1130","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"2528 PRESTON DR, STE A","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27960","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":"1247277","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"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 LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-26T10:01:55.000000Z","updated_at":"2025-10-27T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16644568,"change_date":"2025-10-23 21:39:00","inspection_id":"86130770","insp_unit_id":"209623378","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"3265","insp_unit_license":"RC27244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA55N1000263","insp_unit_decal":"Y","insp_unit_decal_number":"35766795","created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:23.000000Z"}]},{"id":10008460,"change_date":"2025-11-12 21:41:00","inspection_id":"86119003","dot_number":"476933","report_state":"MI","report_number":"MDTBB02430","insp_date":"2025-10-22 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"2528 PRESTON DR, STE A,","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1246966","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":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-22 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-25T10:01:41.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16948729,"change_date":"2025-11-12 21:41:00","inspection_id":"86119003","insp_unit_id":"209980532","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1348","insp_unit_license":"RC27246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000348","insp_unit_decal":"Y","insp_unit_decal_number":"35766794","created_at":"2025-11-15T10:00:33.000000Z","updated_at":"2025-11-16T10:00:54.000000Z"}]},{"id":10019279,"change_date":"2025-11-12 21:41:00","inspection_id":"86130439","dot_number":"476933","report_state":"MI","report_number":"MDTBB02427","insp_date":"2025-10-20 00:00:00","insp_start_time":"0940","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1247194","transaction_code":"C","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16949015,"change_date":"2025-11-12 21:41:00","inspection_id":"86130439","insp_unit_id":"209980530","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"3267","insp_unit_license":"RC27247","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA52N1000267","insp_unit_decal":"Y","insp_unit_decal_number":"35766791","created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:56.000000Z"}]},{"id":10019682,"change_date":"2025-10-23 21:39:00","inspection_id":"86130869","dot_number":"476933","report_state":"MI","report_number":"MDTBB02425","insp_date":"2025-10-20 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1247423","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-26T10:01:55.000000Z","updated_at":"2025-10-27T10:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16644732,"change_date":"2025-10-23 21:39:00","inspection_id":"86130869","insp_unit_id":"209623554","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"1351","insp_unit_license":"RC27242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000351","insp_unit_decal":"Y","insp_unit_decal_number":"35766790","created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:24.000000Z"}]},{"id":10019683,"change_date":"2025-10-23 21:39:00","inspection_id":"86130870","dot_number":"476933","report_state":"MI","report_number":"MDTBB02426","insp_date":"2025-10-20 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1247400","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-26T10:01:55.000000Z","updated_at":"2025-10-27T10:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16644733,"change_date":"2025-10-23 21:39:00","inspection_id":"86130870","insp_unit_id":"209623555","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"1344","insp_unit_license":"RC27245","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA95P1000344","insp_unit_decal":"Y","insp_unit_decal_number":"35766788","created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:24.000000Z"}]},{"id":10008458,"change_date":"2025-11-12 21:41:00","inspection_id":"86119001","dot_number":"476933","report_state":"MI","report_number":"MDTBB02424","insp_date":"2025-10-20 00:00:00","insp_start_time":"0840","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW","county_code_state":"MI","county_code":"163","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1246903","transaction_code":"C","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-22 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-10-25T10:01:41.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16948727,"change_date":"2025-11-12 21:41:00","inspection_id":"86119001","insp_unit_id":"209980529","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMS","insp_unit_company":"1349","insp_unit_license":"RC27243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA94P1000349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:33.000000Z","updated_at":"2025-11-16T10:00:54.000000Z"}]},{"id":9216938,"change_date":"2025-07-22 21:42:00","inspection_id":"85286879","dot_number":"476933","report_state":"MI","report_number":"MDTRL02729","insp_date":"2025-07-21 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1231597","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15158114,"change_date":"2025-07-22 21:42:00","inspection_id":"85286879","insp_unit_id":"208014006","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1399","insp_unit_license":"RC44043","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W916SW110399","insp_unit_decal":"Y","insp_unit_decal_number":"35453997","created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"}]},{"id":9216939,"change_date":"2025-07-22 21:42:00","inspection_id":"85286880","dot_number":"476933","report_state":"MI","report_number":"MDTRL02730","insp_date":"2025-07-21 00:00:00","insp_start_time":"1440","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1231493","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15158115,"change_date":"2025-07-22 21:42:00","inspection_id":"85286880","insp_unit_id":"208014007","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1400","insp_unit_license":"RC44044","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W919SW110400","insp_unit_decal":"Y","insp_unit_decal_number":"35453998","created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"}]},{"id":9124203,"change_date":"2025-07-11 21:39:00","inspection_id":"85189597","dot_number":"476933","report_state":"MI","report_number":"MDTRL02714","insp_date":"2025-07-10 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1229901","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:05.000000Z","updated_at":"2025-07-16T10:44:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14980669,"change_date":"2025-07-11 21:39:00","inspection_id":"85189597","insp_unit_id":"207822861","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4137","insp_unit_license":"RC32155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B0P3084137","insp_unit_decal":"Y","insp_unit_decal_number":"35454133","created_at":"2025-07-14T09:46:08.000000Z","updated_at":"2025-07-15T09:45:52.000000Z"}]},{"id":9124204,"change_date":"2025-07-11 21:39:00","inspection_id":"85189598","dot_number":"476933","report_state":"MI","report_number":"MDTRL02715","insp_date":"2025-07-10 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1229763","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:05.000000Z","updated_at":"2025-07-16T10:44:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14980670,"change_date":"2025-07-11 21:39:00","inspection_id":"85189598","insp_unit_id":"207822862","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4136","insp_unit_license":"RC28637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B9P3084136","insp_unit_decal":"Y","insp_unit_decal_number":"35454134","created_at":"2025-07-14T09:46:08.000000Z","updated_at":"2025-07-15T09:45:52.000000Z"}]},{"id":8779850,"change_date":"2025-05-30 21:40:00","inspection_id":"84825400","dot_number":"476933","report_state":"MI","report_number":"MDTBB02248","insp_date":"2025-05-29 00:00:00","insp_start_time":"0830","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1223496","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-06-04T10:01:08.000000Z","updated_at":"2025-06-04T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14364611,"change_date":"2025-05-30 21:40:00","inspection_id":"84825400","insp_unit_id":"207151961","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4064","insp_unit_license":"RC27249","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86BXP3084064","insp_unit_decal":"Y","insp_unit_decal_number":"35169547","created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"}]},{"id":8779851,"change_date":"2025-05-30 21:40:00","inspection_id":"84825401","dot_number":"476933","report_state":"MI","report_number":"MDTBB02249","insp_date":"2025-05-29 00:00:00","insp_start_time":"0930","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1223586","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-06-04T10:01:08.000000Z","updated_at":"2025-06-04T10:01:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14364612,"change_date":"2025-05-30 21:40:00","inspection_id":"84825401","insp_unit_id":"207151962","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9405","insp_unit_license":"RC27268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81BXH3049405","insp_unit_decal":"Y","insp_unit_decal_number":"35169548","created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:49.000000Z"}]},{"id":8758486,"change_date":"2025-05-28 21:43:00","inspection_id":"84802713","dot_number":"476933","report_state":"MI","report_number":"MDTRL02664","insp_date":"2025-05-27 00:00:00","insp_start_time":"1430","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1223104","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:38.000000Z","updated_at":"2025-06-01T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14325671,"change_date":"2025-05-28 21:43:00","inspection_id":"84802713","insp_unit_id":"207109140","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4062","insp_unit_license":"RC27248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B6P3084062","insp_unit_decal":"Y","insp_unit_decal_number":"35169454","created_at":"2025-05-31T09:46:52.000000Z","updated_at":"2025-06-01T09:47:42.000000Z"}]},{"id":8732126,"change_date":"2025-05-25 21:34:00","inspection_id":"84774851","dot_number":"476933","report_state":"OH","report_number":"3249000503","insp_date":"2025-05-23 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARMAN AISWORTH MIDDLE SCHOOL","shipping_paper_number":"511-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1777542","transaction_code":"A","transaction_date":"2025-05-25 00:00:00","upload_date":"2025-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2025-05-25 21:34:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-25 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-28T10:00:25.000000Z","updated_at":"2025-05-29T10:00:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14275978,"change_date":"2025-05-25 21:34:00","inspection_id":"84774851","insp_unit_id":"207055460","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":"1653","insp_unit_license":"DVQ1247","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"NLTEJXB98S1000653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-28T09:45:26.000000Z","updated_at":"2025-05-29T09:45:17.000000Z"}]},{"id":8732500,"change_date":"2025-05-25 21:34:00","inspection_id":"84775266","dot_number":"476933","report_state":"OH","report_number":"9455000034","insp_date":"2025-05-23 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"ED","ci_status_code":"C","location":"CP","location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SEAHOLM HIG SCHOOL  PATRICK HOOVER","shipping_paper_number":"2079-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1778186","transaction_code":"A","transaction_date":"2025-05-25 00:00:00","upload_date":"2025-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2025-05-25 21:34:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-25 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-28T10:00:25.000000Z","updated_at":"2025-05-29T10:00:12.000000Z","inspection_violations":[{"id":13934180,"change_date":"2025-05-25 21:34:00","inspection_id":"84775266","insp_violation_id":"266463149","seq_no":"1","part_no":"390","part_no_section":"21TC-MC","insp_viol_unit":"1","insp_unit_id":"207056148","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-28T10:15:34.000000Z","updated_at":"2025-05-29T10:15:15.000000Z","normalized_code":"39021TCMC"}],"inspection_per_units":[{"id":14276590,"change_date":"2025-05-25 21:34:00","inspection_id":"84775266","insp_unit_id":"207056148","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":"1351","insp_unit_license":"RC27242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000351","insp_unit_decal":"Y","insp_unit_decal_number":"35134874","created_at":"2025-05-28T09:45:26.000000Z","updated_at":"2025-05-29T09:45:19.000000Z"}]},{"id":8733503,"change_date":"2025-05-25 21:34:00","inspection_id":"84776376","dot_number":"476933","report_state":"OH","report_number":"3220000550","insp_date":"2025-05-23 00:00:00","insp_start_time":"1051","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARMAN AINSWORTH MIDDLE SCHOOL","shipping_paper_number":"SEE PHOTO","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1778565","transaction_code":"A","transaction_date":"2025-05-25 00:00:00","upload_date":"2025-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2025-05-25 21:34:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-25 21:34:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-28T10:00:27.000000Z","updated_at":"2025-05-29T10:00:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14278255,"change_date":"2025-05-25 21:34:00","inspection_id":"84776376","insp_unit_id":"207058008","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":"1318","insp_unit_license":"RC27251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM86M1000318","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-28T09:45:27.000000Z","updated_at":"2025-05-29T09:45:25.000000Z"}]},{"id":8632137,"change_date":"2025-05-14 21:42:00","inspection_id":"84669285","dot_number":"476933","report_state":"MI","report_number":"MDTBB02225","insp_date":"2025-05-13 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1221176","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-05-17T10:05:20.000000Z","updated_at":"2025-05-18T10:06:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14095488,"change_date":"2025-05-14 21:42:00","inspection_id":"84669285","insp_unit_id":"206857497","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1655","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB91S1000655","insp_unit_decal":"Y","insp_unit_decal_number":"35169525","created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:44.000000Z"}]},{"id":8632138,"change_date":"2025-05-14 21:42:00","inspection_id":"84669286","dot_number":"476933","report_state":"MI","report_number":"MDTBB02226","insp_date":"2025-05-13 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1221114","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-05-17T10:05:20.000000Z","updated_at":"2025-05-18T10:06:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14095489,"change_date":"2025-05-14 21:42:00","inspection_id":"84669286","insp_unit_id":"206857498","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1654","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB9XS1000654","insp_unit_decal":"Y","insp_unit_decal_number":"35169526","created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:44.000000Z"}]},{"id":9770836,"change_date":"2025-09-24 21:42:00","inspection_id":"85868751","dot_number":"476933","report_state":"MI","report_number":"MDTBB02227","insp_date":"2025-05-13 00:00:00","insp_start_time":"1300","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1242477","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-09-26T10:01:17.000000Z","updated_at":"2025-09-28T10:00:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16187169,"change_date":"2025-09-24 21:42:00","inspection_id":"85868751","insp_unit_id":"209127917","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1653","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB98S1000653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:12.000000Z"}]},{"id":8597779,"change_date":"2025-05-11 21:32:00","inspection_id":"84633219","dot_number":"476933","report_state":"OH","report_number":"9455000025","insp_date":"2025-05-09 00:00:00","insp_start_time":"1115","insp_end_time":"1201","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ANNE LAWRENCE  PIONEER MIDDLE SCHOOL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-11 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1711349","transaction_code":"A","transaction_date":"2025-05-11 00:00:00","upload_date":"2025-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2025-05-11 21:32:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-11 21:32:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-14T10:00:56.000000Z","updated_at":"2025-05-15T10:00:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14034461,"change_date":"2025-05-11 21:32:00","inspection_id":"84633219","insp_unit_id":"206792353","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":null,"insp_unit_license":"DVM5483","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"NLTEJXB94S1000651","insp_unit_decal":"Y","insp_unit_decal_number":"35133362","created_at":"2025-05-14T09:45:59.000000Z","updated_at":"2025-05-15T09:45:25.000000Z"}]},{"id":8599004,"change_date":"2025-05-11 21:33:00","inspection_id":"84634536","dot_number":"476933","report_state":"OH","report_number":"9492000024","insp_date":"2025-05-09 00:00:00","insp_start_time":"1115","insp_end_time":"1220","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PIONEER MIDDLE SCHOOL","shipping_paper_number":"482-0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1712812","transaction_code":"A","transaction_date":"2025-05-11 00:00:00","upload_date":"2025-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":"2025-05-11 21:33:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-11 21:33:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-14T10:00:59.000000Z","updated_at":"2025-05-15T10:00:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14036484,"change_date":"2025-05-11 21:33:00","inspection_id":"84634536","insp_unit_id":"206794556","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"TEMSA SKOD","insp_unit_company":null,"insp_unit_license":"RC27269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB96S1000599","insp_unit_decal":"Y","insp_unit_decal_number":"35133395","created_at":"2025-05-14T09:46:00.000000Z","updated_at":"2025-05-15T09:45:42.000000Z"}]},{"id":8549784,"change_date":"2025-05-05 21:40:00","inspection_id":"84582861","dot_number":"476933","report_state":"MI","report_number":"MDTRL02642","insp_date":"2025-05-02 00:00:00","insp_start_time":"1500","insp_end_time":"1540","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1220109","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:43.000000Z","updated_at":"2025-05-09T10:23:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13904446,"change_date":"2025-05-05 21:40:00","inspection_id":"84582861","insp_unit_id":"206647253","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1651","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB94S1000651","insp_unit_decal":"Y","insp_unit_decal_number":"35169397","created_at":"2025-05-08T09:57:09.000000Z","updated_at":"2025-05-09T10:04:06.000000Z"}]},{"id":8549785,"change_date":"2025-05-05 21:40:00","inspection_id":"84582862","dot_number":"476933","report_state":"MI","report_number":"MDTRL02643","insp_date":"2025-05-02 00:00:00","insp_start_time":"1545","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1220120","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:43.000000Z","updated_at":"2025-05-09T10:23:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13904447,"change_date":"2025-05-05 21:40:00","inspection_id":"84582862","insp_unit_id":"206647254","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1654","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB99S1000645","insp_unit_decal":"Y","insp_unit_decal_number":"35169398","created_at":"2025-05-08T09:57:09.000000Z","updated_at":"2025-05-09T10:04:06.000000Z"}]},{"id":8343803,"change_date":"2025-04-10 21:41:00","inspection_id":"84365607","dot_number":"476933","report_state":"MI","report_number":"DAWDD03927","insp_date":"2025-04-08 00:00:00","insp_start_time":"0930","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"4400 8 MILE RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DOD","shipping_paper_number":"04082025","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1216907","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":"00476933","upload_search_indicator":null,"census_search_date":null,"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 LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","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":[],"inspection_per_units":[{"id":13535752,"change_date":"2025-04-10 21:41:00","inspection_id":"84365607","insp_unit_id":"206249736","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNK","insp_unit_company":"1349","insp_unit_license":"RC27243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA94P1000349","insp_unit_decal":"Y","insp_unit_decal_number":"35167595","created_at":"2025-04-13T10:17:59.000000Z","updated_at":"2025-04-14T10:03:11.000000Z"}]},{"id":8311661,"change_date":"2025-04-07 21:40:00","inspection_id":"84331864","dot_number":"476933","report_state":"MI","report_number":"MDTRL02608","insp_date":"2025-04-04 00:00:00","insp_start_time":"1320","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1216266","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:23.000000Z","updated_at":"2025-04-11T10:11:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13478839,"change_date":"2025-04-07 21:40:00","inspection_id":"84331864","insp_unit_id":"206187682","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9150","insp_unit_license":"0257PBA","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"YE2XC81B3H3049150","insp_unit_decal":"Y","insp_unit_decal_number":"35169373","created_at":"2025-04-10T09:55:51.000000Z","updated_at":"2025-04-11T09:58:57.000000Z"}]},{"id":8277290,"change_date":"2025-04-02 21:41:00","inspection_id":"84295721","dot_number":"476933","report_state":"MI","report_number":"MDTRL02604","insp_date":"2025-04-02 00:00:00","insp_start_time":"0840","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1215862","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398600,"change_date":"2025-04-02 21:41:00","inspection_id":"84295721","insp_unit_id":"206122273","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3363","insp_unit_license":"RC41045","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA51R1000363","insp_unit_decal":"Y","insp_unit_decal_number":"35169369","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:58.000000Z"}]},{"id":8277291,"change_date":"2025-04-02 21:41:00","inspection_id":"84295722","dot_number":"476933","report_state":"MI","report_number":"MDTRL02605","insp_date":"2025-04-02 00:00:00","insp_start_time":"0915","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1215883","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398601,"change_date":"2025-04-02 21:41:00","inspection_id":"84295722","insp_unit_id":"206122274","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3361","insp_unit_license":"RC27271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA58R1000361","insp_unit_decal":"Y","insp_unit_decal_number":"35169370","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:58.000000Z"}]},{"id":8277299,"change_date":"2025-04-02 21:41:00","inspection_id":"84295731","dot_number":"476933","report_state":"MI","report_number":"MDTRL02606","insp_date":"2025-04-02 00:00:00","insp_start_time":"1010","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1215923","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398613,"change_date":"2025-04-02 21:41:00","inspection_id":"84295731","insp_unit_id":"206122287","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3362","insp_unit_license":"RC41047","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA5XR1000362","insp_unit_decal":"Y","insp_unit_decal_number":"35169371","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:59.000000Z"}]},{"id":8277300,"change_date":"2025-04-02 21:41:00","inspection_id":"84295732","dot_number":"476933","report_state":"MI","report_number":"MDTRL02607","insp_date":"2025-04-02 00:00:00","insp_start_time":"1230","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1215934","transaction_code":"A","transaction_date":"2025-04-02 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398614,"change_date":"2025-04-02 21:41:00","inspection_id":"84295732","insp_unit_id":"206122288","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8819","insp_unit_license":"RC41046","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910RW108819","insp_unit_decal":"Y","insp_unit_decal_number":"35169372","created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:59.000000Z"}]},{"id":8179370,"change_date":"2025-03-21 21:40:00","inspection_id":"84192522","dot_number":"476933","report_state":"MI","report_number":"MDTRL02591","insp_date":"2025-03-20 00:00:00","insp_start_time":"1420","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1214294","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:28:02.000000Z","updated_at":"2025-03-25T10:11:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13221526,"change_date":"2025-03-21 21:40:00","inspection_id":"84192522","insp_unit_id":"205929588","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1599","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXB96S1000599","insp_unit_decal":"Y","insp_unit_decal_number":"34934405","created_at":"2025-03-24T10:17:43.000000Z","updated_at":"2025-03-25T09:59:59.000000Z"}]},{"id":8179369,"change_date":"2025-03-21 21:40:00","inspection_id":"84192521","dot_number":"476933","report_state":"MI","report_number":"MDTRL02590","insp_date":"2025-03-20 00:00:00","insp_start_time":"1300","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1214356","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:28:02.000000Z","updated_at":"2025-03-25T10:11:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13221525,"change_date":"2025-03-21 21:40:00","inspection_id":"84192521","insp_unit_id":"205929587","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8690","insp_unit_license":"RC27255","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA7JW068690","insp_unit_decal":"Y","insp_unit_decal_number":"34934404","created_at":"2025-03-24T10:17:43.000000Z","updated_at":"2025-03-25T09:59:59.000000Z"}]},{"id":8084266,"change_date":"2025-03-11 21:41:00","inspection_id":"84092446","dot_number":"476933","report_state":"MI","report_number":"MDTBB02156","insp_date":"2025-03-10 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1212721","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052348,"change_date":"2025-03-11 21:41:00","inspection_id":"84092446","insp_unit_id":"205736683","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9761","insp_unit_license":"RC27256","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B2J3049761","insp_unit_decal":"Y","insp_unit_decal_number":"34934475","created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8084267,"change_date":"2025-03-11 21:41:00","inspection_id":"84092447","dot_number":"476933","report_state":"MI","report_number":"MDTBB02157","insp_date":"2025-03-10 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1212771","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052349,"change_date":"2025-03-11 21:41:00","inspection_id":"84092447","insp_unit_id":"205736684","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9408","insp_unit_license":"RC27259","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B5H3049408","insp_unit_decal":"Y","insp_unit_decal_number":"34934476","created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8084268,"change_date":"2025-03-11 21:41:00","inspection_id":"84092448","dot_number":"476933","report_state":"MI","report_number":"MDTBB02158","insp_date":"2025-03-10 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1212814","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052350,"change_date":"2025-03-11 21:41:00","inspection_id":"84092448","insp_unit_id":"205736685","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8689","insp_unit_license":"RC27258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA0JW068689","insp_unit_decal":"Y","insp_unit_decal_number":"34934477","created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8084284,"change_date":"2025-03-11 21:41:00","inspection_id":"84092464","dot_number":"476933","report_state":"MI","report_number":"MDTBB02159","insp_date":"2025-03-10 00:00:00","insp_start_time":"1045","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"155","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1212668","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052379,"change_date":"2025-03-11 21:41:00","inspection_id":"84092464","insp_unit_id":"205736714","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1317","insp_unit_license":"RC27210","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B9K3081317","insp_unit_decal":"Y","insp_unit_decal_number":"34934478","created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8084285,"change_date":"2025-03-11 21:41:00","inspection_id":"84092465","dot_number":"476933","report_state":"MI","report_number":"MDTBB02160","insp_date":"2025-03-10 00:00:00","insp_start_time":"1145","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 NORTH SAGINAW ROAD","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1212742","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":"207","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052380,"change_date":"2025-03-11 21:41:00","inspection_id":"84092465","insp_unit_id":"205736715","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9403","insp_unit_license":"RC27266","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B6H3049403","insp_unit_decal":"Y","insp_unit_decal_number":"34934479","created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":7921158,"change_date":"2025-02-20 21:40:00","inspection_id":"83921065","dot_number":"476933","report_state":"MI","report_number":"MDTRL02586","insp_date":"2025-02-19 00:00:00","insp_start_time":"0830","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1210473","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:47.000000Z","updated_at":"2025-03-17T21:02:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12786643,"change_date":"2025-02-20 21:40:00","inspection_id":"83921065","insp_unit_id":"205423514","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3208","insp_unit_license":"RC27265","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLM57L1000208","insp_unit_decal":"Y","insp_unit_decal_number":"34934400","created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"}]},{"id":7921159,"change_date":"2025-02-20 21:40:00","inspection_id":"83921066","dot_number":"476933","report_state":"MI","report_number":"MDTRL02587","insp_date":"2025-02-19 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1210616","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:47.000000Z","updated_at":"2025-03-17T21:02:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12786644,"change_date":"2025-02-20 21:40:00","inspection_id":"83921066","insp_unit_id":"205423515","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3212","insp_unit_license":"RC27264","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLM59L1000212","insp_unit_decal":"Y","insp_unit_decal_number":"34934401","created_at":"2025-03-17T23:56:16.000000Z","updated_at":"2025-03-17T23:56:16.000000Z"}]},{"id":7832842,"change_date":"2025-02-10 21:40:00","inspection_id":"83828507","dot_number":"476933","report_state":"MI","report_number":"BALLB05037","insp_date":"2025-02-07 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"4400 EAST EIGHT MILE","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DOD","shipping_paper_number":"W119567","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-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1209345","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:47.000000Z","updated_at":"2025-03-17T21:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12641456,"change_date":"2025-02-10 21:40:00","inspection_id":"83828507","insp_unit_id":"205252028","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"14000","insp_unit_license":"RC44044","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W919SW110400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]},{"id":7774171,"change_date":"2025-02-03 21:39:00","inspection_id":"83766822","dot_number":"476933","report_state":"MI","report_number":"STREJ01796","insp_date":"2025-02-01 00:00:00","insp_start_time":"0415","insp_end_time":"0440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 N SAGINAW RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1208502","transaction_code":"A","transaction_date":"2025-02-01 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-03-17T20:59:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12546553,"change_date":"2025-02-03 21:39:00","inspection_id":"83766822","insp_unit_id":"205132962","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3263","insp_unit_license":"RC27244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA55N1000263","insp_unit_decal":"Y","insp_unit_decal_number":"34933113","created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7774172,"change_date":"2025-02-03 21:39:00","inspection_id":"83766823","dot_number":"476933","report_state":"MI","report_number":"STREJ01797","insp_date":"2025-02-01 00:00:00","insp_start_time":"0440","insp_end_time":"0500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12154 N SAGINAW RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1208550","transaction_code":"A","transaction_date":"2025-02-01 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-03-17T20:59:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12546554,"change_date":"2025-02-03 21:39:00","inspection_id":"83766823","insp_unit_id":"205132963","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3361","insp_unit_license":"RC27271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA58R1000361","insp_unit_decal":"Y","insp_unit_decal_number":"34933114","created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":7584050,"change_date":"2025-01-14 21:55:00","inspection_id":"83567022","dot_number":"476933","report_state":"MI","report_number":"MDTRL02514","insp_date":"2025-01-08 00:00:00","insp_start_time":"0830","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1206079","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12236906,"change_date":"2025-01-14 21:55:00","inspection_id":"83567022","insp_unit_id":"204828049","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1319","insp_unit_license":"RC27250","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM88M1000319","insp_unit_decal":"Y","insp_unit_decal_number":"34934322","created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7584051,"change_date":"2025-01-14 21:55:00","inspection_id":"83567023","dot_number":"476933","report_state":"MI","report_number":"MDTRL02515","insp_date":"2025-01-08 00:00:00","insp_start_time":"0940","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1206010","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12236907,"change_date":"2025-01-14 21:55:00","inspection_id":"83567023","insp_unit_id":"204828050","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1318","insp_unit_license":"RC27251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM86M1000318","insp_unit_decal":"Y","insp_unit_decal_number":"34934323","created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7584067,"change_date":"2025-01-14 21:55:00","inspection_id":"83567039","dot_number":"476933","report_state":"MI","report_number":"MDTRL02516","insp_date":"2025-01-08 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1205989","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12236931,"change_date":"2025-01-14 21:55:00","inspection_id":"83567039","insp_unit_id":"204828051","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"9735","insp_unit_license":"RC23520","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNAXLW069735","insp_unit_decal":"Y","insp_unit_decal_number":"34934324","created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7584068,"change_date":"2025-01-14 21:55:00","inspection_id":"83567040","dot_number":"476933","report_state":"MI","report_number":"MDTRL02517","insp_date":"2025-01-08 00:00:00","insp_start_time":"1140","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1205947","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12236932,"change_date":"2025-01-14 21:55:00","inspection_id":"83567040","insp_unit_id":"204828098","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"9734","insp_unit_license":"RC27261","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNA8LW069734","insp_unit_decal":"Y","insp_unit_decal_number":"34934325","created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7115468,"change_date":"2024-11-04 21:40:00","inspection_id":"83073441","dot_number":"476933","report_state":"MI","report_number":"BALLB04976","insp_date":"2024-11-01 00:00:00","insp_start_time":"0800","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"DOD","location_desc":"12450 BEECH DALY ROAD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DOD","shipping_paper_number":"W117033","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-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1200508","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11476255,"change_date":"2024-11-04 21:40:00","inspection_id":"83073441","insp_unit_id":"203724350","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"UNK","insp_unit_company":"1206","insp_unit_license":"RC27254","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM81J1000206","insp_unit_decal":"Y","insp_unit_decal_number":"34635974","created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":7115470,"change_date":"2024-11-04 21:40:00","inspection_id":"83073445","dot_number":"476933","report_state":"MI","report_number":"DAWDD03767","insp_date":"2024-11-01 00:00:00","insp_start_time":"0800","insp_end_time":"0851","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"12450 BEECH DALY","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MICHIGAN NATIONAL GUARD","shipping_paper_number":"11012024","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-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1200551","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11476258,"change_date":"2024-11-04 21:40:00","inspection_id":"83073445","insp_unit_id":"203724357","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNK","insp_unit_company":"1203","insp_unit_license":"RC27269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXM86J1000203","insp_unit_decal":"Y","insp_unit_decal_number":"34635921","created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":6913044,"change_date":"2024-10-08 21:42:00","inspection_id":"82858371","dot_number":"476933","report_state":"MI","report_number":"MDTRL02432","insp_date":"2024-10-07 00:00:00","insp_start_time":"0915","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1197361","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149276,"change_date":"2024-10-08 21:42:00","inspection_id":"82858371","insp_unit_id":"203318823","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1344","insp_unit_license":"RC27245","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA95P1000344","insp_unit_decal":"Y","insp_unit_decal_number":"34637525","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6913045,"change_date":"2024-10-08 21:42:00","inspection_id":"82858372","dot_number":"476933","report_state":"MI","report_number":"MDTRL02433","insp_date":"2024-10-07 00:00:00","insp_start_time":"0955","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1197519","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149277,"change_date":"2024-10-08 21:42:00","inspection_id":"82858372","insp_unit_id":"203318824","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1351","insp_unit_license":"RC27242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000351","insp_unit_decal":"Y","insp_unit_decal_number":"34637526","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6913046,"change_date":"2024-10-08 21:42:00","inspection_id":"82858373","dot_number":"476933","report_state":"MI","report_number":"MDTRL02434","insp_date":"2024-10-07 00:00:00","insp_start_time":"1035","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","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":"1197429","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149278,"change_date":"2024-10-08 21:42:00","inspection_id":"82858373","insp_unit_id":"203318825","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1348","insp_unit_license":"RC27246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000348","insp_unit_decal":"Y","insp_unit_decal_number":"34637527","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6913047,"change_date":"2024-10-08 21:42:00","inspection_id":"82858374","dot_number":"476933","report_state":"MI","report_number":"MDTRL02435","insp_date":"2024-10-07 00:00:00","insp_start_time":"1230","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1197444","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149279,"change_date":"2024-10-08 21:42:00","inspection_id":"82858374","insp_unit_id":"203318826","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3267","insp_unit_license":"RC27247","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA52N1000267","insp_unit_decal":"Y","insp_unit_decal_number":"34637528","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6913055,"change_date":"2024-10-08 21:42:00","inspection_id":"82858382","dot_number":"476933","report_state":"MI","report_number":"MDTRL02436","insp_date":"2024-10-07 00:00:00","insp_start_time":"1310","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1197474","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149292,"change_date":"2024-10-08 21:42:00","inspection_id":"82858382","insp_unit_id":"203318839","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3263","insp_unit_license":"RC27244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA55N1000263","insp_unit_decal":"Y","insp_unit_decal_number":"34637505","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6913079,"change_date":"2024-10-08 21:42:00","inspection_id":"82858410","dot_number":"476933","report_state":"MI","report_number":"MDTRL02431","insp_date":"2024-10-07 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1197468","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11149322,"change_date":"2024-10-08 21:42:00","inspection_id":"82858410","insp_unit_id":"203318880","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"1349","insp_unit_license":"RC27243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA94P1000349","insp_unit_decal":"Y","insp_unit_decal_number":"34637521","created_at":"2025-03-17T23:38:27.000000Z","updated_at":"2025-03-17T23:38:27.000000Z"}]},{"id":6809022,"change_date":"2024-09-24 21:42:00","inspection_id":"82747935","dot_number":"476933","report_state":"MI","report_number":"MDTRL02413","insp_date":"2024-09-19 00:00:00","insp_start_time":"1140","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1195517","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10980204,"change_date":"2024-09-24 21:42:00","inspection_id":"82747935","insp_unit_id":"203109430","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4136","insp_unit_license":"RC28637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B9P3084136","insp_unit_decal":"Y","insp_unit_decal_number":"34302682","created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"}]},{"id":6736997,"change_date":"2024-09-16 21:43:00","inspection_id":"82670926","dot_number":"476933","report_state":"MI","report_number":"GUTHG02631","insp_date":"2024-09-15 00:00:00","insp_start_time":"1345","insp_end_time":"1427","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WAWATAM PARK PARKING","county_code_state":"MI","county_code":"031","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GATE 1 TRAVEL NORTH AMERICA","shipping_paper_number":"USMIWE-01 2024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1195131","transaction_code":"A","transaction_date":"2024-09-15 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:33.000000Z","updated_at":"2025-03-17T20:36:33.000000Z","inspection_violations":[{"id":10489110,"change_date":"2024-09-16 21:43:00","inspection_id":"82670926","insp_violation_id":"261825962","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202945641","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10863398,"change_date":"2024-09-16 21:43:00","inspection_id":"82670926","insp_unit_id":"202945641","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"8819","insp_unit_license":"RC41046","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910RW108819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:31.000000Z","updated_at":"2025-03-17T23:35:31.000000Z"}]},{"id":6680429,"change_date":"2024-09-17 21:45:00","inspection_id":"82610916","dot_number":"476933","report_state":"MI","report_number":"MDTRL02381","insp_date":"2024-09-05 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1194142","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10771139,"change_date":"2024-09-17 21:45:00","inspection_id":"82610916","insp_unit_id":"202983264","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1399","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W916SW110399","insp_unit_decal":"Y","insp_unit_decal_number":"34302657","created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6680430,"change_date":"2024-09-17 21:45:00","inspection_id":"82610917","dot_number":"476933","report_state":"MI","report_number":"MDTRL02382","insp_date":"2024-09-05 00:00:00","insp_start_time":"1240","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1193994","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10771140,"change_date":"2024-09-17 21:45:00","inspection_id":"82610917","insp_unit_id":"202983265","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1400","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W919SW110400","insp_unit_decal":"Y","insp_unit_decal_number":"34302658","created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6680431,"change_date":"2024-09-17 21:45:00","inspection_id":"82610918","dot_number":"476933","report_state":"MI","report_number":"MDTRL02383","insp_date":"2024-09-05 00:00:00","insp_start_time":"1400","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1193984","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10771141,"change_date":"2024-09-17 21:45:00","inspection_id":"82610918","insp_unit_id":"202983266","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4132","insp_unit_license":"RC32155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B0P3084137","insp_unit_decal":"Y","insp_unit_decal_number":"34302659","created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":5885632,"change_date":"2024-05-31 21:39:00","inspection_id":"81757928","dot_number":"476933","report_state":"MI","report_number":"GUTHG02563","insp_date":"2024-05-30 00:00:00","insp_start_time":"0950","insp_end_time":"1101","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ST IGNACE POST PARKINGLOT","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BRYANT ELEMENTARY SCHOOL","shipping_paper_number":"116827","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-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1180509","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":9124883,"change_date":"2024-05-31 21:39:00","inspection_id":"81757928","insp_violation_id":"259835207","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:07.000000Z","updated_at":"2025-03-17T21:50:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9479486,"change_date":"2024-05-31 21:39:00","inspection_id":"81757928","insp_unit_id":"201175081","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"9735","insp_unit_license":"RC23520","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMNAXLW069735","insp_unit_decal":"Y","insp_unit_decal_number":"33975369","created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5778925,"change_date":"2024-05-17 21:40:00","inspection_id":"81642362","dot_number":"476933","report_state":"MI","report_number":"MDTRL02255","insp_date":"2024-05-17 00:00:00","insp_start_time":"0840","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1179156","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:09.000000Z","updated_at":"2025-03-17T20:17:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9307826,"change_date":"2024-05-17 21:40:00","inspection_id":"81642362","insp_unit_id":"200954471","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4064","insp_unit_license":"RC27249","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86BXP3084064","insp_unit_decal":"Y","insp_unit_decal_number":"33975887","created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":5778926,"change_date":"2024-05-17 21:40:00","inspection_id":"81642363","dot_number":"476933","report_state":"MI","report_number":"MDTRL02256","insp_date":"2024-05-17 00:00:00","insp_start_time":"0935","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1179154","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:09.000000Z","updated_at":"2025-03-17T20:17:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9307827,"change_date":"2024-05-17 21:40:00","inspection_id":"81642363","insp_unit_id":"200954472","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4062","insp_unit_license":"RC27248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B6P3084062","insp_unit_decal":"Y","insp_unit_decal_number":"33975888","created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":5768154,"change_date":"2024-05-16 21:41:00","inspection_id":"81630743","dot_number":"476933","report_state":"MI","report_number":"MDTRL02250","insp_date":"2024-05-15 00:00:00","insp_start_time":"1150","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1178918","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:05.000000Z","updated_at":"2025-03-17T20:17:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9290663,"change_date":"2024-05-16 21:41:00","inspection_id":"81630743","insp_unit_id":"200932625","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9405","insp_unit_license":"RC27268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81BXH3049405","insp_unit_decal":"Y","insp_unit_decal_number":"33975882","created_at":"2025-03-17T23:19:30.000000Z","updated_at":"2025-03-17T23:19:30.000000Z"}]},{"id":5719405,"change_date":"2024-05-10 21:39:00","inspection_id":"81577907","dot_number":"476933","report_state":"OH","report_number":"9449300362","insp_date":"2024-05-10 00:00:00","insp_start_time":"1030","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CP","location_desc":"CEDAR POINT AMUSEMENT PARK","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"EASTPOINTE MIDDLE SCHOOL","shipping_paper_number":"292253","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51500","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":"1725445","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:57.000000Z","updated_at":"2025-03-17T20:15:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9211961,"change_date":"2024-05-10 21:39:00","inspection_id":"81577907","insp_unit_id":"200831761","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNK","insp_unit_company":"1351","insp_unit_license":"RC27242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTEJXA92P1000351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":5710943,"change_date":"2024-05-09 21:42:00","inspection_id":"81568776","dot_number":"476933","report_state":"OH","report_number":"3216302066","insp_date":"2024-05-09 00:00:00","insp_start_time":"1130","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CP","location_desc":"CEDAR POINT AMUSEMENT PARK","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"BRECKENRIDGE SCHOOLS","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":"I","final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1725119","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9198478,"change_date":"2024-05-09 21:42:00","inspection_id":"81568776","insp_unit_id":"200814801","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4064","insp_unit_license":"RC27249","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86BXP3084064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5711032,"change_date":"2024-05-09 21:42:00","inspection_id":"81568893","dot_number":"476933","report_state":"OH","report_number":"1796005158","insp_date":"2024-05-09 00:00:00","insp_start_time":"1106","insp_end_time":"1132","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CED","location_desc":"CEDAR POINT","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BLUE LAKES CHARTERS","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":"I","final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1725238","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9198612,"change_date":"2024-05-09 21:42:00","inspection_id":"81568893","insp_unit_id":"200815048","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1317","insp_unit_license":"RC27260","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B9K3081317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5711044,"change_date":"2024-05-09 21:42:00","inspection_id":"81568905","dot_number":"476933","report_state":"OH","report_number":"9465100267","insp_date":"2024-05-09 00:00:00","insp_start_time":"1106","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CP","location_desc":"CEDAR POINT AMUSEMENT PARK","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1725230","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9198626,"change_date":"2024-05-09 21:42:00","inspection_id":"81568905","insp_unit_id":"200815076","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8690","insp_unit_license":"RC27255","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA7JW068690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5711063,"change_date":"2024-05-09 21:42:00","inspection_id":"81568926","dot_number":"476933","report_state":"OH","report_number":"9474300088","insp_date":"2024-05-09 00:00:00","insp_start_time":"0931","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CP","location_desc":"CEDAR POINT AMUSEMENT PARK","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CLIO SCHOOL","shipping_paper_number":"592024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1725272","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:54.000000Z","updated_at":"2025-03-17T20:15:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9198649,"change_date":"2024-05-09 21:42:00","inspection_id":"81568926","insp_unit_id":"200815119","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8689","insp_unit_license":"RC27258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA0JW068689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:36.000000Z","updated_at":"2025-03-17T23:18:36.000000Z"}]},{"id":5719398,"change_date":"2024-05-10 21:39:00","inspection_id":"81577898","dot_number":"476933","report_state":"OH","report_number":"3246017227","insp_date":"2024-05-09 00:00:00","insp_start_time":"1112","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":"043CED","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"EAST MIDDLE SCHOOL","shipping_paper_number":"290987","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1725477","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-10 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:57.000000Z","updated_at":"2025-03-17T20:15:57.000000Z","inspection_violations":[{"id":8849541,"change_date":"2024-05-10 21:39:00","inspection_id":"81577898","insp_violation_id":"259432488","seq_no":"1","part_no":"395","part_no_section":"5(a)(2)","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":"2025-03-17T21:48:49.000000Z","updated_at":"2025-03-17T21:48:49.000000Z","normalized_code":"3955A2"}],"inspection_per_units":[{"id":9211953,"change_date":"2024-05-10 21:39:00","inspection_id":"81577898","insp_unit_id":"200831751","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4136","insp_unit_license":"RC28637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B9P3084136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:44.000000Z","updated_at":"2025-03-17T23:18:44.000000Z"}]},{"id":5607849,"change_date":"2024-04-26 21:39:00","inspection_id":"81456500","dot_number":"476933","report_state":"MI","report_number":"MDTRL02231","insp_date":"2024-04-26 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1175698","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9033084,"change_date":"2024-04-26 21:39:00","inspection_id":"81456500","insp_unit_id":"200598567","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8819","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910RW108819","insp_unit_decal":"Y","insp_unit_decal_number":"33975863","created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5607850,"change_date":"2024-04-26 21:39:00","inspection_id":"81456501","dot_number":"476933","report_state":"MI","report_number":"MDTRL02232","insp_date":"2024-04-26 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50535","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":"1175851","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9033085,"change_date":"2024-04-26 21:39:00","inspection_id":"81456501","insp_unit_id":"200598568","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCE","insp_unit_company":"2505","insp_unit_license":"CB63BP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"WEBS404H8P3292505","insp_unit_decal":"Y","insp_unit_decal_number":"33975864","created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5523647,"change_date":"2024-05-17 21:40:00","inspection_id":"81364871","dot_number":"476933","report_state":"MI","report_number":"MDTRL02213","insp_date":"2024-04-15 00:00:00","insp_start_time":"0900","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1173733","transaction_code":"C","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8897589,"change_date":"2024-05-17 21:40:00","inspection_id":"81364871","insp_unit_id":"200954640","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3361","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA58R1000361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":5523648,"change_date":"2024-05-17 21:40:00","inspection_id":"81364872","dot_number":"476933","report_state":"MI","report_number":"MDTRL02214","insp_date":"2024-04-15 00:00:00","insp_start_time":"1000","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1173758","transaction_code":"C","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8897590,"change_date":"2024-05-17 21:40:00","inspection_id":"81364872","insp_unit_id":"200954663","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3362","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA5XR1000362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":5523767,"change_date":"2024-04-16 21:41:00","inspection_id":"81365008","dot_number":"476933","report_state":"MI","report_number":"MDTRL02215","insp_date":"2024-04-15 00:00:00","insp_start_time":"1200","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1174004","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8897777,"change_date":"2024-04-16 21:41:00","inspection_id":"81365008","insp_unit_id":"200422248","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3363","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLA51R1000363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":5410599,"change_date":"2024-04-01 21:40:00","inspection_id":"81241115","dot_number":"476933","report_state":"MI","report_number":"MDTRL02195","insp_date":"2024-03-28 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1171389","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8714364,"change_date":"2024-04-01 21:40:00","inspection_id":"81241115","insp_unit_id":"200179738","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1317","insp_unit_license":"RC27210","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B9K3081317","insp_unit_decal":"Y","insp_unit_decal_number":"33686503","created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5410600,"change_date":"2024-04-01 21:40:00","inspection_id":"81241116","dot_number":"476933","report_state":"MI","report_number":"MDTRL02196","insp_date":"2024-03-28 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1171469","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8714365,"change_date":"2024-04-01 21:40:00","inspection_id":"81241116","insp_unit_id":"200179739","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"8689","insp_unit_license":"RC27258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA0JW068689","insp_unit_decal":"Y","insp_unit_decal_number":"33686504","created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5410601,"change_date":"2024-04-01 21:40:00","inspection_id":"81241117","dot_number":"476933","report_state":"MI","report_number":"MDTRL02197","insp_date":"2024-03-28 00:00:00","insp_start_time":"1040","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1171438","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8714366,"change_date":"2024-04-01 21:40:00","inspection_id":"81241117","insp_unit_id":"200179740","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9408","insp_unit_license":"RC27259","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B5H3049408","insp_unit_decal":"Y","insp_unit_decal_number":"33686505","created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5339092,"change_date":"2024-03-21 21:41:00","inspection_id":"81163379","dot_number":"476933","report_state":"MI","report_number":"MDTRL02186","insp_date":"2024-03-21 00:00:00","insp_start_time":"1030","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1170234","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:20.000000Z","updated_at":"2025-03-17T20:08:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8598409,"change_date":"2024-03-21 21:41:00","inspection_id":"81163379","insp_unit_id":"200026427","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9403","insp_unit_license":"RC27266","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B6H3049403","insp_unit_decal":"Y","insp_unit_decal_number":"33686494","created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5154381,"change_date":"2024-02-28 21:42:00","inspection_id":"80962033","dot_number":"476933","report_state":"MI","report_number":"MDTRL02156","insp_date":"2024-02-27 00:00:00","insp_start_time":"1130","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY TRAVERSE CITY","county_code_state":"MI","county_code":"055","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1166853","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8299331,"change_date":"2024-02-28 21:42:00","inspection_id":"80962033","insp_unit_id":"199641761","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"9761","insp_unit_license":"RC27256","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC81B2J3049761","insp_unit_decal":"Y","insp_unit_decal_number":"33686474","created_at":"2025-03-17T23:10:12.000000Z","updated_at":"2025-03-17T23:10:12.000000Z"}]},{"id":5137072,"change_date":"2024-02-26 21:42:00","inspection_id":"80943168","dot_number":"476933","report_state":"MI","report_number":"MDTRL02154","insp_date":"2024-02-23 00:00:00","insp_start_time":"1010","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY CLIO MI","county_code_state":"MI","county_code":"049","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27980","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":"1166480","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8270926,"change_date":"2024-02-26 21:42:00","inspection_id":"80943168","insp_unit_id":"199602810","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"3092","insp_unit_license":"RC27271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTAPLY55H1000192","insp_unit_decal":"Y","insp_unit_decal_number":"33686472","created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":5072841,"change_date":"2024-02-16 21:42:00","inspection_id":"80873057","dot_number":"476933","report_state":"MN","report_number":"00XV002682","insp_date":"2024-02-16 00:00:00","insp_start_time":"1252","insp_end_time":"1323","registration_date":null,"region":"CT","ci_status_code":"C","location":"BLNE","location_desc":"BLAINE","county_code_state":"MN","county_code":"003","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"VICTORY ICE TIER 1 HOCKEY TEAM","shipping_paper_number":"288024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1435533","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00476933","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-16 00:00:00","source_office":"3MNS001","mcmis_add_date":"2024-02-16 21:42:00","insp_carrier_name":"BLUE LAKES CHARTERS AND TOURS INC","insp_carrier_street":"12154 N SAGINAW RD","insp_carrier_city":"CLIO","insp_carrier_state":"MI","insp_carrier_zip_code":"48420","insp_colonia":null,"docket_number":"228157","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:06.000000Z","updated_at":"2025-03-17T20:03:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8166347,"change_date":"2024-02-16 21:42:00","inspection_id":"80873057","insp_unit_id":"199468340","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"4137","insp_unit_license":"RC32155","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2XC86B0P3084137","insp_unit_decal":"Y","insp_unit_decal_number":"33729749","created_at":"2025-03-17T23:09:02.000000Z","updated_at":"2025-03-17T23:09:02.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections?page=2","path":"https:\/\/www.searchcarriers.com\/company\/476933\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":190}