{"current_page":1,"data":[{"id":12542017,"change_date":"2026-07-24 21:40:00","inspection_id":"88508520","dot_number":"675742","report_state":"MI","report_number":"COPEK03873","insp_date":"2026-07-24 00:00:00","insp_start_time":"1025","insp_end_time":"1040","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3829033","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-07-24 21:40:00","snet_input_date":"2026-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-24 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-27T09:41:35.000000Z","updated_at":"2026-08-04T09:31:02.000000Z","inspection_violations":[{"id":21834361,"change_date":"2026-07-24 21:40:00","inspection_id":"88508520","insp_violation_id":"275716106","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:09.000000Z","updated_at":"2026-08-04T09:43:38.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":21779067,"change_date":"2026-07-24 21:40:00","inspection_id":"88508520","insp_unit_id":"214804187","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"578564","insp_unit_license":"RB85975","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR1TN578564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:19:54.000000Z","updated_at":"2026-08-04T09:02:17.000000Z"},{"id":21779068,"change_date":"2026-07-24 21:40:00","inspection_id":"88508520","insp_unit_id":"214804188","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"NONE","insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:19:54.000000Z","updated_at":"2026-08-04T09:02:17.000000Z"}]},{"id":12531630,"change_date":"2026-07-23 21:41:00","inspection_id":"88497699","dot_number":"675742","report_state":"MI","report_number":"BIEGK00881","insp_date":"2026-07-23 00:00:00","insp_start_time":"1250","insp_end_time":"1313","registration_date":null,"region":"ED","ci_status_code":"C","location":"141","location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GERBER POULTRY","shipping_paper_number":"140329","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-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3821262","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:27.000000Z","updated_at":"2026-08-03T09:31:15.000000Z","inspection_violations":[{"id":21815197,"change_date":"2026-07-23 21:41:00","inspection_id":"88497699","insp_violation_id":"275692112","seq_no":"1","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"214784627","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-26T10:04:31.000000Z","updated_at":"2026-08-03T09:43:06.000000Z","normalized_code":"39375A3TFL"},{"id":21815198,"change_date":"2026-07-23 21:41:00","inspection_id":"88497699","insp_violation_id":"275692113","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:31.000000Z","updated_at":"2026-08-03T09:43:06.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":21761879,"change_date":"2026-07-23 21:41:00","inspection_id":"88497699","insp_unit_id":"214784627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"215719","insp_unit_license":"RC02040","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR8SN215791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:20.000000Z","updated_at":"2026-08-03T09:05:35.000000Z"},{"id":21761880,"change_date":"2026-07-23 21:41:00","inspection_id":"88497699","insp_unit_id":"214784628","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"37821","insp_unit_license":"F257679","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532BXGL965794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:20.000000Z","updated_at":"2026-08-03T09:05:35.000000Z"}]},{"id":12455044,"change_date":"2026-07-15 21:42:00","inspection_id":"88415301","dot_number":"675742","report_state":"MI","report_number":"ARCHH01410","insp_date":"2026-07-15 00:00:00","insp_start_time":"1000","insp_end_time":"1020","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3757376","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-07-15 21:42:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-18T09:40:48.000000Z","updated_at":"2026-07-26T09:30:57.000000Z","inspection_violations":[{"id":21685103,"change_date":"2026-07-15 21:42:00","inspection_id":"88415301","insp_violation_id":"275521084","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-18T10:03:06.000000Z","updated_at":"2026-07-26T09:44:24.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21633926,"change_date":"2026-07-15 21:42:00","inspection_id":"88415301","insp_unit_id":"214626123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD61894","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML2PL039686","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:20:18.000000Z","updated_at":"2026-07-26T09:02:37.000000Z"}]},{"id":12373842,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","dot_number":"675742","report_state":"MI","report_number":"KOCHJ02507","insp_date":"2026-07-07 00:00:00","insp_start_time":"1005","insp_end_time":"1035","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3698218","transaction_code":"A","transaction_date":"2026-07-07 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-07-07 21:40:00","snet_input_date":"2026-07-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:21.000000Z","updated_at":"2026-07-18T09:30:44.000000Z","inspection_violations":[{"id":21535190,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","insp_violation_id":"275337203","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-10T09:59:30.000000Z","updated_at":"2026-07-18T09:42:24.000000Z","normalized_code":"3922SLLTCD"},{"id":21535191,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","insp_violation_id":"275337204","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"214477514","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-10T09:59:30.000000Z","updated_at":"2026-07-18T09:42:24.000000Z","normalized_code":"39021TB2DOT"},{"id":21535192,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","insp_violation_id":"275337205","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"214477514","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-10T09:59:30.000000Z","updated_at":"2026-07-18T09:42:24.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":21486880,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","insp_unit_id":"214477515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"837880","insp_unit_license":"266336A","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B0GL965853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:38.000000Z","updated_at":"2026-07-18T09:02:08.000000Z"},{"id":21486879,"change_date":"2026-07-07 21:40:00","inspection_id":"88336379","insp_unit_id":"214477514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"134388","insp_unit_license":"RC40637","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR3SN230036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:38.000000Z","updated_at":"2026-07-18T09:02:08.000000Z"}]},{"id":12036982,"change_date":"2026-05-28 21:41:00","inspection_id":"87977350","dot_number":"675742","report_state":"MI","report_number":"OSHEE02877","insp_date":"2026-05-28 00:00:00","insp_start_time":"0628","insp_end_time":"0635","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3416658","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:52.000000Z","updated_at":"2026-06-08T09:30:49.000000Z","inspection_violations":[{"id":20946272,"change_date":"2026-05-28 21:41:00","inspection_id":"87977350","insp_violation_id":"274549392","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:06.000000Z","updated_at":"2026-06-08T09:42:30.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":20921709,"change_date":"2026-05-28 21:41:00","inspection_id":"87977350","insp_unit_id":"213790902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"039687","insp_unit_license":"BD95626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4PL039687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:03.000000Z","updated_at":"2026-06-08T09:02:37.000000Z"}]},{"id":11665421,"change_date":"2026-04-16 21:41:00","inspection_id":"87595746","dot_number":"675742","report_state":"MI","report_number":"CELMS01689","insp_date":"2026-04-14 00:00:00","insp_start_time":"1415","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DAVISBURG REST AREA S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"45914","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1266372","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:31.000000Z","updated_at":"2026-04-27T09:31:31.000000Z","inspection_violations":[{"id":20261728,"change_date":"2026-04-16 21:41:00","inspection_id":"87595746","insp_violation_id":"273649157","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"213053863","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:44:56.000000Z","updated_at":"2026-04-27T09:44:56.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":20292355,"change_date":"2026-04-16 21:41:00","inspection_id":"87595746","insp_unit_id":"213053863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"578564","insp_unit_license":"RB85975","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR1TN578564","insp_unit_decal":"Y","insp_unit_decal_number":"36395678","created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"},{"id":20292356,"change_date":"2026-04-16 21:41:00","inspection_id":"87595746","insp_unit_id":"213053864","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"837817","insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"Y","insp_unit_decal_number":"36395679","created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"}]},{"id":11427472,"change_date":"2026-03-20 21:39:00","inspection_id":"87343582","dot_number":"675742","report_state":"MI","report_number":"BENNK01113","insp_date":"2026-03-19 00:00:00","insp_start_time":"1405","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SUPPLY RD @ COYOTE CROSSING","county_code_state":"MI","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1263092","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:35.000000Z","updated_at":"2026-03-31T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19575592,"change_date":"2026-03-20 21:39:00","inspection_id":"87343582","insp_unit_id":"212241922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"039687","insp_unit_license":"BD95626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4PL039687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:02.000000Z","updated_at":"2026-03-31T09:10:21.000000Z"}]},{"id":11309967,"change_date":"2026-03-06 21:42:00","inspection_id":"87226079","dot_number":"675742","report_state":"MI","report_number":"WORDN06066","insp_date":"2026-03-05 00:00:00","insp_start_time":"1150","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-62 @ TWIN LAKES RD","county_code_state":"MI","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261420","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-03-06 21:42:00","snet_input_date":"2026-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:39.000000Z","updated_at":"2026-03-17T09:31:05.000000Z","inspection_violations":[{"id":19029148,"change_date":"2026-03-06 21:42:00","inspection_id":"87226079","insp_violation_id":"272252503","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4664675","created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:19.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":19350490,"change_date":"2026-03-06 21:42:00","inspection_id":"87226079","insp_unit_id":"212014939","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"134132","insp_unit_license":"BD39756","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4SL576228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:26.000000Z","updated_at":"2026-03-17T09:03:30.000000Z"}]},{"id":10635844,"change_date":"2026-01-13 21:39:00","inspection_id":"86776986","dot_number":"675742","report_state":"MI","report_number":"BLAKD04847","insp_date":"2026-01-12 00:00:00","insp_start_time":"1210","insp_end_time":"1225","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","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":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1256227","transaction_code":"A","transaction_date":"2026-01-12 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:37.000000Z","inspection_violations":[{"id":17890555,"change_date":"2026-01-13 21:39:00","inspection_id":"86776986","insp_violation_id":"271167997","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211052761","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"3939ALHLI"},{"id":17890556,"change_date":"2026-01-13 21:39:00","inspection_id":"86776986","insp_violation_id":"271167998","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"211052761","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:09.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":17838730,"change_date":"2026-01-13 21:39:00","inspection_id":"86776986","insp_unit_id":"211052761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"255049","insp_unit_license":"BD07981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR0NL255049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"},{"id":17838731,"change_date":"2026-01-13 21:39:00","inspection_id":"86776986","insp_unit_id":"211052762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"15351","insp_unit_license":"F262049","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B2GL965840","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:11.000000Z"}]},{"id":10599830,"change_date":"2026-01-08 21:40:00","inspection_id":"86739138","dot_number":"675742","report_state":"MI","report_number":"PEIFM07875","insp_date":"2026-01-08 00:00:00","insp_start_time":"0510","insp_end_time":"0530","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","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-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1255593","transaction_code":"A","transaction_date":"2026-01-08 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:45.000000Z","updated_at":"2026-01-19T10:30:47.000000Z","inspection_violations":[{"id":17819260,"change_date":"2026-01-08 21:40:00","inspection_id":"86739138","insp_violation_id":"271087325","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210978828","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"3939ALIL"},{"id":17819261,"change_date":"2026-01-08 21:40:00","inspection_id":"86739138","insp_violation_id":"271087326","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210978828","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":17770497,"change_date":"2026-01-08 21:40:00","inspection_id":"86739138","insp_unit_id":"210978828","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BE19636","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML6SL098779","insp_unit_decal":"Y","insp_unit_decal_number":"36057543","created_at":"2026-01-11T10:06:13.000000Z","updated_at":"2026-01-19T10:00:56.000000Z"}]},{"id":10599856,"change_date":"2026-01-08 21:40:00","inspection_id":"86739166","dot_number":"675742","report_state":"MI","report_number":"REYNP00319","insp_date":"2026-01-06 00:00:00","insp_start_time":"1700","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":"1","location_desc":"EB SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"2130228","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1255356","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:45.000000Z","updated_at":"2026-01-19T10:30:48.000000Z","inspection_violations":[{"id":17819312,"change_date":"2026-01-08 21:40:00","inspection_id":"86739166","insp_violation_id":"271087382","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"210978879","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4632303","created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":17819313,"change_date":"2026-01-08 21:40:00","inspection_id":"86739166","insp_violation_id":"271087383","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"210978879","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:20.000000Z","updated_at":"2026-01-19T10:31:26.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":17770542,"change_date":"2026-01-08 21:40:00","inspection_id":"86739166","insp_unit_id":"210978879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"53118","insp_unit_license":"BD62685","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML9RS533118","insp_unit_decal":"Y","insp_unit_decal_number":"36058713","created_at":"2026-01-11T10:06:13.000000Z","updated_at":"2026-01-19T10:00:56.000000Z"}]},{"id":10200670,"change_date":"2025-12-04 21:38:00","inspection_id":"86321513","dot_number":"675742","report_state":"MI","report_number":"MALIK03371","insp_date":"2025-11-12 00:00:00","insp_start_time":"1350","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 31 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250510","transaction_code":"C","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:27.000000Z","updated_at":"2025-12-08T10:30:32.000000Z","inspection_violations":[{"id":17319945,"change_date":"2025-12-04 21:38:00","inspection_id":"86321513","insp_violation_id":"270463116","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:05.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"3922SLLSIV"},{"id":17319946,"change_date":"2025-12-04 21:38:00","inspection_id":"86321513","insp_violation_id":"270463117","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:05.000000Z","updated_at":"2025-12-08T10:30:56.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":17290053,"change_date":"2025-12-04 21:38:00","inspection_id":"86321513","insp_unit_id":"210415251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"33700","insp_unit_license":"BD17396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXPL189996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:39.000000Z"}]},{"id":9972057,"change_date":"2025-10-17 21:39:00","inspection_id":"86080748","dot_number":"675742","report_state":"MI","report_number":"HUFFR00290","insp_date":"2025-10-16 00:00:00","insp_start_time":"1355","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":"532","location_desc":"NEW BUFFALO SCALE W\/B","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246457","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:55.000000Z","updated_at":"2025-10-21T10:00:51.000000Z","inspection_violations":[{"id":16472557,"change_date":"2025-10-17 21:39:00","inspection_id":"86080748","insp_violation_id":"269368845","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:31.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":16557667,"change_date":"2025-10-17 21:39:00","inspection_id":"86080748","insp_unit_id":"209529099","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD62685","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML9RS533118","insp_unit_decal":"Y","insp_unit_decal_number":"35768704","created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:10.000000Z"}]},{"id":9844777,"change_date":"2025-10-03 21:39:00","inspection_id":"85946335","dot_number":"675742","report_state":"IN","report_number":"8352005601","insp_date":"2025-09-26 00:00:00","insp_start_time":"1415","insp_end_time":"1510","registration_date":null,"region":"ED","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARMELA FOODS INC","shipping_paper_number":"2081507","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-10-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2360946","transaction_code":"A","transaction_date":"2025-10-03 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-10-03 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-03 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:02:12.000000Z","updated_at":"2025-10-08T10:00:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16326427,"change_date":"2025-10-03 21:39:00","inspection_id":"85946335","insp_unit_id":"209277658","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"533118","insp_unit_license":"BD62685","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML9RS533118","insp_unit_decal":"Y","insp_unit_decal_number":"35555330","created_at":"2025-10-05T09:47:08.000000Z","updated_at":"2025-10-08T09:45:19.000000Z"}]},{"id":9669006,"change_date":"2025-09-12 21:49:00","inspection_id":"85761992","dot_number":"675742","report_state":"MI","report_number":"RICKE00826","insp_date":"2025-09-11 00:00:00","insp_start_time":"1625","insp_end_time":"1635","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B US-131 & WOODMAN RD","county_code_state":"MI","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240956","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:15.000000Z","updated_at":"2025-09-16T10:48:15.000000Z","inspection_violations":[{"id":15845569,"change_date":"2025-09-12 21:49:00","inspection_id":"85761992","insp_violation_id":"268659154","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-09-14T11:58:00.000000Z","updated_at":"2025-09-16T10:51:12.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15993404,"change_date":"2025-09-12 21:49:00","inspection_id":"85761992","insp_unit_id":"208919711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD095626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4PL039687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:58.000000Z","updated_at":"2025-09-16T09:56:03.000000Z"}]},{"id":9499527,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","dot_number":"675742","report_state":"MI","report_number":"ESCOT02976","insp_date":"2025-08-23 00:00:00","insp_start_time":"0820","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S-C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1237855","transaction_code":"A","transaction_date":"2025-08-23 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:44.000000Z","updated_at":"2025-08-29T10:42:44.000000Z","inspection_violations":[{"id":15491366,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_violation_id":"268233256","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208569357","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:50.000000Z","normalized_code":"39617CPI"},{"id":15491367,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_violation_id":"268233257","seq_no":"2","part_no":"396","part_no_section":"3A1-BNMH","insp_viol_unit":"2","insp_unit_id":"208569357","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:50.000000Z","normalized_code":"3963A1BNMH"},{"id":15491368,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_violation_id":"268233258","seq_no":"3","part_no":"393","part_no_section":"28-WS-6","insp_viol_unit":"2","insp_unit_id":"208569357","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:50.000000Z","normalized_code":"39328WS6"},{"id":15491369,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_violation_id":"268233259","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208569357","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4581248","created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:50.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15673464,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_unit_id":"208569356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"204042","insp_unit_license":"RC44165","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR0SN204042","insp_unit_decal":"Y","insp_unit_decal_number":"35455197","created_at":"2025-08-28T09:45:35.000000Z","updated_at":"2025-08-29T09:46:02.000000Z"},{"id":15673465,"change_date":"2025-08-25 21:40:00","inspection_id":"85584245","insp_unit_id":"208569357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"837720","insp_unit_license":"F262048","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2539EU046426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:35.000000Z","updated_at":"2025-08-29T09:46:02.000000Z"}]},{"id":9492374,"change_date":"2025-08-24 21:33:00","inspection_id":"85576620","dot_number":"675742","report_state":"IN","report_number":"8290000973","insp_date":"2025-08-22 00:00:00","insp_start_time":"0700","insp_end_time":"0758","registration_date":null,"region":"ED","ci_status_code":"C","location":"5570W","location_desc":"RICHMOND IN","county_code_state":"IN","county_code":"177","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARMELA FOODS, INC","shipping_paper_number":"2060541A","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-08-24 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2170965","transaction_code":"A","transaction_date":"2025-08-24 00:00:00","upload_date":"2025-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-08-24 21:33:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-24 21:33:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-27T10:43:54.000000Z","updated_at":"2025-08-29T10:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15659121,"change_date":"2025-08-24 21:33:00","inspection_id":"85576620","insp_unit_id":"208553624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"282505","insp_unit_license":"PNW4152","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTEUMMLXSS446723","insp_unit_decal":"Y","insp_unit_decal_number":"35554935","created_at":"2025-08-27T09:45:26.000000Z","updated_at":"2025-08-28T09:45:21.000000Z"}]},{"id":9123865,"change_date":"2025-07-11 21:39:00","inspection_id":"85189231","dot_number":"675742","report_state":"MI","report_number":"FROSR00885","insp_date":"2025-07-09 00:00:00","insp_start_time":"1040","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ CLIO  R\/A","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":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":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229576","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:46.000000Z","inspection_violations":[{"id":14709429,"change_date":"2025-07-11 21:39:00","inspection_id":"85189231","insp_violation_id":"267347984","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"2","insp_unit_id":"207822205","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:05.000000Z","normalized_code":"39345DBAAL"},{"id":14709430,"change_date":"2025-07-11 21:39:00","inspection_id":"85189231","insp_violation_id":"267347985","seq_no":"2","part_no":"396","part_no_section":"3A1-BARS","insp_viol_unit":"2","insp_unit_id":"207822205","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:05.000000Z","normalized_code":"3963A1BARS"}],"inspection_per_units":[{"id":14980078,"change_date":"2025-07-11 21:39:00","inspection_id":"85189231","insp_unit_id":"207822204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC02040","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR8SN215791","insp_unit_decal":"Y","insp_unit_decal_number":"35455510","created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:50.000000Z"},{"id":14980079,"change_date":"2025-07-11 21:39:00","inspection_id":"85189231","insp_unit_id":"207822205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:50.000000Z"}]},{"id":8990433,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","dot_number":"675742","report_state":"MI","report_number":"KAATZ00580","insp_date":"2025-06-25 00:00:00","insp_start_time":"0952","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1227391","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:58.000000Z","updated_at":"2025-06-30T10:00:58.000000Z","inspection_violations":[{"id":14457384,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_violation_id":"267059302","seq_no":"1","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"2","insp_unit_id":"207566621","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:36.000000Z","normalized_code":"3969D2FTF"},{"id":14457385,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_violation_id":"267059303","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207566621","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:36.000000Z","normalized_code":"3922SLLSR"},{"id":14457386,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_violation_id":"267059304","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207566620","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:36.000000Z","normalized_code":"39345DB"},{"id":14457387,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_violation_id":"267059305","seq_no":"4","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:36.000000Z","normalized_code":"3958A1HOSP"},{"id":14457388,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_violation_id":"267059306","seq_no":"5","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:39.000000Z","updated_at":"2025-06-30T10:17:36.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":14744799,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_unit_id":"207566620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"510903","insp_unit_license":"BE06427","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZSZR5SN299331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:14.000000Z","updated_at":"2025-07-01T09:47:22.000000Z"},{"id":14744800,"change_date":"2025-06-26 21:41:00","inspection_id":"85048892","insp_unit_id":"207566621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"15306","insp_unit_license":"UNKNOWN","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B2GL965773","insp_unit_decal":"Y","insp_unit_decal_number":"35167473","created_at":"2025-06-29T09:46:14.000000Z","updated_at":"2025-07-01T09:47:22.000000Z"}]},{"id":8962981,"change_date":"2025-06-23 21:41:00","inspection_id":"85019801","dot_number":"675742","report_state":"MI","report_number":"EVANT02897","insp_date":"2025-06-19 00:00:00","insp_start_time":"0705","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M72 NEAR WISHBONE RD","county_code_state":"MI","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226459","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:36.000000Z","updated_at":"2025-06-28T10:00:36.000000Z","inspection_violations":[{"id":14395785,"change_date":"2025-06-23 21:41:00","inspection_id":"85019801","insp_violation_id":"266988743","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:59.000000Z","updated_at":"2025-06-27T10:17:56.000000Z","normalized_code":"3922SLLS2"},{"id":14395786,"change_date":"2025-06-23 21:41:00","inspection_id":"85019801","insp_violation_id":"266988744","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:59.000000Z","updated_at":"2025-06-27T10:17:56.000000Z","normalized_code":"3922SLLSIV"},{"id":14395787,"change_date":"2025-06-23 21:41:00","inspection_id":"85019801","insp_violation_id":"266988745","seq_no":"3","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:59.000000Z","updated_at":"2025-06-27T10:17:56.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14693039,"change_date":"2025-06-23 21:41:00","inspection_id":"85019801","insp_unit_id":"207510212","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"39657","insp_unit_license":"BD95626","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4PL039687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:10.000000Z"}]},{"id":8896974,"change_date":"2025-06-13 21:40:00","inspection_id":"84949571","dot_number":"675742","report_state":"MI","report_number":"ESCOT02805","insp_date":"2025-06-13 00:00:00","insp_start_time":"0820","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S-C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225505","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-17T10:00:39.000000Z","inspection_violations":[{"id":14261318,"change_date":"2025-06-13 21:40:00","inspection_id":"84949571","insp_violation_id":"266836806","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"207381494","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:44.000000Z","updated_at":"2025-06-17T10:20:52.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":14575281,"change_date":"2025-06-13 21:40:00","inspection_id":"84949571","insp_unit_id":"207381493","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"20404","insp_unit_license":"RC44165","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR0SN204042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:41.000000Z","updated_at":"2025-06-17T09:45:52.000000Z"},{"id":14575282,"change_date":"2025-06-13 21:40:00","inspection_id":"84949571","insp_unit_id":"207381494","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"837720","insp_unit_license":"E620975","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2539EU046426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:41.000000Z","updated_at":"2025-06-17T09:45:52.000000Z"}]},{"id":8910817,"change_date":"2025-06-16 21:39:00","inspection_id":"84964387","dot_number":"675742","report_state":"MI","report_number":"ESCOT02808","insp_date":"2025-06-13 00:00:00","insp_start_time":"1140","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S-C","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225664","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:24.000000Z","updated_at":"2025-06-20T10:00:29.000000Z","inspection_violations":[{"id":14288569,"change_date":"2025-06-16 21:39:00","inspection_id":"84964387","insp_violation_id":"266867406","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207408442","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:34.000000Z","updated_at":"2025-06-20T10:15:52.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14599887,"change_date":"2025-06-16 21:39:00","inspection_id":"84964387","insp_unit_id":"207408441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"510903","insp_unit_license":"BE064427","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZSZR5SN299331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:38.000000Z"},{"id":14599888,"change_date":"2025-06-16 21:39:00","inspection_id":"84964387","insp_unit_id":"207408442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"15346","insp_unit_license":"UNKNOWN","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B2GL965773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:38.000000Z"}]},{"id":8468589,"change_date":"2025-04-25 21:36:00","inspection_id":"84497142","dot_number":"675742","report_state":"MI","report_number":"ESCOT02635","insp_date":"2025-04-25 00:00:00","insp_start_time":"0525","insp_end_time":"0545","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W I-696@MIDDLEBELT RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"1996734A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219127","transaction_code":"A","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-04-25 21:36:00","snet_input_date":"2025-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:34.000000Z","inspection_violations":[{"id":13387145,"change_date":"2025-04-25 21:36:00","inspection_id":"84497142","insp_violation_id":"265829057","seq_no":"1","part_no":"392","part_no_section":"3-F","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:45.000000Z","normalized_code":"3923F"},{"id":13387146,"change_date":"2025-04-25 21:36:00","inspection_id":"84497142","insp_violation_id":"265829058","seq_no":"2","part_no":"392","part_no_section":"2-SLLML","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-04-28T10:35:51.000000Z","updated_at":"2025-04-29T10:23:45.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":13759310,"change_date":"2025-04-25 21:36:00","inspection_id":"84497142","insp_unit_id":"206489995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BE19617","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML1SL780842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:29.000000Z"}]},{"id":7865295,"change_date":"2025-02-13 21:40:00","inspection_id":"83862451","dot_number":"675742","report_state":"MI","report_number":"KIRKB04897","insp_date":"2025-02-12 00:00:00","insp_start_time":"0825","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"92131","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1209974","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12290727,"change_date":"2025-02-13 21:40:00","inspection_id":"83862451","insp_violation_id":"264507578","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"205315416","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3939ALTSIR"},{"id":12290728,"change_date":"2025-02-13 21:40:00","inspection_id":"83862451","insp_violation_id":"264507579","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"205315417","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":12694636,"change_date":"2025-02-13 21:40:00","inspection_id":"83862451","insp_unit_id":"205315416","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"215791","insp_unit_license":"RC02040","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR8SN215791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"},{"id":12694637,"change_date":"2025-02-13 21:40:00","inspection_id":"83862451","insp_unit_id":"205315417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"837817","insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"}]},{"id":7784667,"change_date":"2025-02-04 21:40:00","inspection_id":"83777867","dot_number":"675742","report_state":"MI","report_number":"PEIFM06935","insp_date":"2025-02-04 00:00:00","insp_start_time":"0450","insp_end_time":"0520","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1208659","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2025-02-04 21:40:00","snet_input_date":"2025-02-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:54.000000Z","updated_at":"2025-03-17T20:59:54.000000Z","inspection_violations":[{"id":12164044,"change_date":"2025-02-04 21:40:00","inspection_id":"83777867","insp_violation_id":"264334131","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205154250","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:22.000000Z","updated_at":"2025-03-17T22:05:22.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":12563198,"change_date":"2025-02-04 21:40:00","inspection_id":"83777867","insp_unit_id":"205154250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB73169","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML6KH496348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:44.000000Z","updated_at":"2025-03-17T23:53:44.000000Z"}]},{"id":7329194,"change_date":"2024-12-03 21:40:00","inspection_id":"83299266","dot_number":"675742","report_state":"MI","report_number":"MOREM05623","insp_date":"2024-12-03 00:00:00","insp_start_time":"0729","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I69 OVERPASS","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202975","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-12-03 21:40:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[{"id":11459713,"change_date":"2024-12-03 21:40:00","inspection_id":"83299266","insp_violation_id":"263197476","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLL"},{"id":11459714,"change_date":"2024-12-03 21:40:00","inspection_id":"83299266","insp_violation_id":"263197477","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:41.000000Z","updated_at":"2025-03-17T22:01:41.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11823315,"change_date":"2024-12-03 21:40:00","inspection_id":"83299266","insp_unit_id":"204154167","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"204042","insp_unit_license":"RC44165","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR0SN204042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"},{"id":11823316,"change_date":"2024-12-03 21:40:00","inspection_id":"83299266","insp_unit_id":"204154168","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"E620975","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2539EU046426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7260830,"change_date":"2024-11-22 21:41:00","inspection_id":"83227095","dot_number":"675742","report_state":"MI","report_number":"DAWDD03776","insp_date":"2024-11-22 00:00:00","insp_start_time":"1115","insp_end_time":"1157","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 AT SCALE","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARMELA","shipping_paper_number":"1923770","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202199","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-11-22 21:41:00","snet_input_date":"2024-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-22 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:40.000000Z","updated_at":"2025-03-17T20:47:40.000000Z","inspection_violations":[{"id":11351025,"change_date":"2024-11-22 21:41:00","inspection_id":"83227095","insp_violation_id":"263046577","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:07.000000Z","updated_at":"2025-03-17T22:01:07.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":11711752,"change_date":"2024-11-22 21:41:00","inspection_id":"83227095","insp_unit_id":"204015043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"215791","insp_unit_license":"RC02040","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR8SN215791","insp_unit_decal":"Y","insp_unit_decal_number":"34635922","created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"},{"id":11711753,"change_date":"2024-11-22 21:41:00","inspection_id":"83227095","insp_unit_id":"204015044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"NONE","insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"Y","insp_unit_decal_number":"34635923","created_at":"2025-03-17T23:44:23.000000Z","updated_at":"2025-03-17T23:44:23.000000Z"}]},{"id":6933554,"change_date":"2024-10-10 21:42:00","inspection_id":"82880230","dot_number":"675742","report_state":"MI","report_number":"HINCA00510","insp_date":"2024-10-09 00:00:00","insp_start_time":"1115","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B LEVERING RD @ LARK LAKE RD","county_code_state":"MI","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE VILLAGE MART","shipping_paper_number":"1899746A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1197697","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[{"id":10807340,"change_date":"2024-10-10 21:42:00","inspection_id":"82880230","insp_violation_id":"262291637","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":"X4446611","created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"3922"},{"id":10807341,"change_date":"2024-10-10 21:42:00","inspection_id":"82880230","insp_violation_id":"262291638","seq_no":"2","part_no":"391","part_no_section":"45(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:21.000000Z","updated_at":"2025-03-17T21:58:21.000000Z","normalized_code":"39145A"}],"inspection_per_units":[{"id":11182422,"change_date":"2024-10-10 21:42:00","inspection_id":"82880230","insp_unit_id":"203359084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"067839","insp_unit_license":"BC23662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML6LL067839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"}]},{"id":6575362,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","dot_number":"675742","report_state":"MI","report_number":"HAMIZ01133","insp_date":"2024-08-27 00:00:00","insp_start_time":"0928","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTWICK PINES REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1191794","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10219710,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","insp_violation_id":"261863781","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202979002","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39311"},{"id":10219711,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","insp_violation_id":"261863782","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"202979002","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39021TB"},{"id":10219712,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","insp_violation_id":"261863783","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202979003","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10600434,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","insp_unit_id":"202979002","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"275446","insp_unit_license":"RB86168","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR1MN275446","insp_unit_decal":"Y","insp_unit_decal_number":"34302303","created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"},{"id":10600435,"change_date":"2024-09-17 21:45:00","inspection_id":"82498875","insp_unit_id":"202979003","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"15351","insp_unit_license":"266335A","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965840","insp_unit_decal":"Y","insp_unit_decal_number":"34302304","created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"}]},{"id":6586380,"change_date":"2024-08-28 21:42:00","inspection_id":"82510541","dot_number":"675742","report_state":"MI","report_number":"ELDEH00622","insp_date":"2024-08-26 00:00:00","insp_start_time":"0935","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB @ CURTIS RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192608","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10240083,"change_date":"2024-08-28 21:42:00","inspection_id":"82510541","insp_violation_id":"261467201","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"3922"},{"id":10240084,"change_date":"2024-08-28 21:42:00","inspection_id":"82510541","insp_violation_id":"261467202","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:36.000000Z","updated_at":"2025-03-17T21:55:36.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10618409,"change_date":"2024-08-28 21:42:00","inspection_id":"82510541","insp_unit_id":"202632739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"533119","insp_unit_license":"BD95624","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML0RS533119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":6357512,"change_date":"2024-09-17 21:45:00","inspection_id":"82266375","dot_number":"675742","report_state":"MI","report_number":"ANDER06573","insp_date":"2024-07-29 00:00:00","insp_start_time":"2310","insp_end_time":"2340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 23 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188069","transaction_code":"C","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870339,"change_date":"2024-09-17 21:45:00","inspection_id":"82266375","insp_violation_id":"261857335","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202973862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10245188,"change_date":"2024-09-17 21:45:00","inspection_id":"82266375","insp_unit_id":"202973862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB73169","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML6KH496348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":5985794,"change_date":"2024-06-13 21:42:00","inspection_id":"81867094","dot_number":"675742","report_state":"MI","report_number":"ELDEH00524","insp_date":"2024-06-11 00:00:00","insp_start_time":"0435","insp_end_time":"0448","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ KOCHVILLE RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","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":"1182171","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9285830,"change_date":"2024-06-13 21:42:00","inspection_id":"81867094","insp_violation_id":"260072430","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:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9641526,"change_date":"2024-06-13 21:42:00","inspection_id":"81867094","insp_unit_id":"201383338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"392844","insp_unit_license":"RB59686","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZTZR9KN392844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9641527,"change_date":"2024-06-13 21:42:00","inspection_id":"81867094","insp_unit_id":"201383339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"837817","insp_unit_license":"3145914","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965790","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5755775,"change_date":"2024-05-15 21:43:00","inspection_id":"81617388","dot_number":"675742","report_state":"MI","report_number":"ELDEH00495","insp_date":"2024-05-15 00:00:00","insp_start_time":"0345","insp_end_time":"0405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ MM147","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178642","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:43.000000Z","updated_at":"2025-03-17T20:16:43.000000Z","inspection_violations":[{"id":8908270,"change_date":"2024-05-15 21:43:00","inspection_id":"81617388","insp_violation_id":"259519358","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9270657,"change_date":"2024-05-15 21:43:00","inspection_id":"81617388","insp_unit_id":"200906829","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"065742","insp_unit_license":"BC23655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML3LL065742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5723212,"change_date":"2024-05-11 21:31:00","inspection_id":"81582021","dot_number":"675742","report_state":"MI","report_number":"DEJOS01052","insp_date":"2024-05-09 00:00:00","insp_start_time":"1605","insp_end_time":"1625","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRASS LAKE SCALES E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-11 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1178026","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":"00675742","upload_search_indicator":null,"census_search_date":"2024-05-11 21:31:00","snet_input_date":"2024-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-11 21:31:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:16.000000Z","updated_at":"2025-03-17T20:16:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9218254,"change_date":"2024-05-11 21:31:00","inspection_id":"81582021","insp_unit_id":"200841648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD31368","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML1PL878325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"}]},{"id":5690311,"change_date":"2024-05-07 21:42:00","inspection_id":"81546349","dot_number":"675742","report_state":"MI","report_number":"PEIFM06255","insp_date":"2024-05-07 00:00:00","insp_start_time":"0545","insp_end_time":"0605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB AT 5 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1177344","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-05-07 21:42:00","snet_input_date":"2024-05-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-07 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:29.000000Z","updated_at":"2025-03-17T20:15:29.000000Z","inspection_violations":[{"id":8802855,"change_date":"2024-05-07 21:42:00","inspection_id":"81546349","insp_violation_id":"259364984","seq_no":"1","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"200772470","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:36.000000Z","updated_at":"2025-03-17T21:48:36.000000Z","normalized_code":"37611D1"},{"id":8802856,"change_date":"2024-05-07 21:42:00","inspection_id":"81546349","insp_violation_id":"259364985","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200772470","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:36.000000Z","updated_at":"2025-03-17T21:48:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9165407,"change_date":"2024-05-07 21:42:00","inspection_id":"81546349","insp_unit_id":"200772470","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB73169","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML6KH496348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:18.000000Z","updated_at":"2025-03-17T23:18:18.000000Z"}]},{"id":5019594,"change_date":"2024-02-09 21:41:00","inspection_id":"80814902","dot_number":"675742","report_state":"MI","report_number":"STRAL02732","insp_date":"2024-02-08 00:00:00","insp_start_time":"1942","insp_end_time":"2002","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DUNES TRUCK PLAZA","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21000","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":"1164186","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-02-09 21:41:00","snet_input_date":"2024-02-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-09 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:05.000000Z","updated_at":"2025-03-17T20:02:05.000000Z","inspection_violations":[{"id":7733349,"change_date":"2024-02-09 21:41:00","inspection_id":"80814902","insp_violation_id":"257763850","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199357273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:23.000000Z","updated_at":"2025-03-17T21:43:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8079165,"change_date":"2024-02-09 21:41:00","inspection_id":"80814902","insp_unit_id":"199357273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"25","insp_unit_license":"BD17396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXPL189996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:12.000000Z","updated_at":"2025-03-17T23:08:12.000000Z"}]},{"id":5019625,"change_date":"2024-02-09 21:41:00","inspection_id":"80814936","dot_number":"675742","report_state":"MI","report_number":"OSHEE02280","insp_date":"2024-02-08 00:00:00","insp_start_time":"1217","insp_end_time":"1232","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"9 MILE @ ERWIN RD","county_code_state":"MI","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1164233","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-02-09 21:41:00","snet_input_date":"2024-02-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-09 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:05.000000Z","updated_at":"2025-03-17T20:02:05.000000Z","inspection_violations":[{"id":7733397,"change_date":"2024-02-09 21:41:00","inspection_id":"80814936","insp_violation_id":"257763910","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:23.000000Z","updated_at":"2025-03-17T21:43:23.000000Z","normalized_code":"3922"},{"id":7733398,"change_date":"2024-02-09 21:41:00","inspection_id":"80814936","insp_violation_id":"257763911","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:23.000000Z","updated_at":"2025-03-17T21:43:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8079217,"change_date":"2024-02-09 21:41:00","inspection_id":"80814936","insp_unit_id":"199357336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"065742","insp_unit_license":"BC23655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML3LL065742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:12.000000Z","updated_at":"2025-03-17T23:08:12.000000Z"}]},{"id":4977439,"change_date":"2024-02-05 21:40:00","inspection_id":"80768707","dot_number":"675742","report_state":"MI","report_number":"HINCA00162","insp_date":"2024-02-02 00:00:00","insp_start_time":"1405","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B US-131 @ EAST ST","county_code_state":"MI","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1163045","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7667043,"change_date":"2024-02-05 21:40:00","inspection_id":"80768707","insp_violation_id":"257666586","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4329741","created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8011013,"change_date":"2024-02-05 21:40:00","inspection_id":"80768707","insp_unit_id":"199269680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"067839","insp_unit_license":"BC23662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML6LL067839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"}]},{"id":4664404,"change_date":"2023-12-19 21:41:00","inspection_id":"80426499","dot_number":"675742","report_state":"MI","report_number":"PEIFM05942","insp_date":"2023-12-19 00:00:00","insp_start_time":"0055","insp_end_time":"0102","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB AT 2 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HEINEN","shipping_paper_number":"8730","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1157769","transaction_code":"A","transaction_date":"2023-12-19 00:00:00","upload_date":"2023-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-12-19 21:41:00","snet_input_date":"2023-12-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-19 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:21.000000Z","updated_at":"2025-03-17T19:55:21.000000Z","inspection_violations":[{"id":7211080,"change_date":"2023-12-19 21:41:00","inspection_id":"80426499","insp_violation_id":"256964624","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198577082","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7502262,"change_date":"2023-12-19 21:41:00","inspection_id":"80426499","insp_unit_id":"198577082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC11872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMMLXLH105546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:04.000000Z","updated_at":"2025-03-17T23:03:04.000000Z"}]},{"id":3777151,"change_date":"2023-08-30 21:44:00","inspection_id":"79444353","dot_number":"675742","report_state":"MI","report_number":"BLAKD03937","insp_date":"2023-08-18 00:00:00","insp_start_time":"0620","insp_end_time":"0634","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"SB 75 @ DUNBAR","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1140916","transaction_code":"C","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-08-18 21:41:00","snet_input_date":"2023-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-18 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:19.000000Z","updated_at":"2025-03-17T19:37:19.000000Z","inspection_violations":[{"id":5826297,"change_date":"2023-08-30 21:44:00","inspection_id":"79444353","insp_violation_id":"254981392","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:03.000000Z","updated_at":"2025-03-17T21:34:03.000000Z","normalized_code":"3922"},{"id":5826298,"change_date":"2023-08-30 21:44:00","inspection_id":"79444353","insp_violation_id":"254981393","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:03.000000Z","updated_at":"2025-03-17T21:34:03.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":6072934,"change_date":"2023-08-30 21:44:00","inspection_id":"79444353","insp_unit_id":"196811623","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105546","insp_unit_license":"BC11872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMMLXLH105546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:02.000000Z","updated_at":"2025-03-17T22:51:02.000000Z"}]},{"id":3768407,"change_date":"2023-08-30 21:45:00","inspection_id":"79434573","dot_number":"675742","report_state":"MI","report_number":"OMILJ04288","insp_date":"2023-08-17 00:00:00","insp_start_time":"1025","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ MM 23","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1140631","transaction_code":"C","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-08-17 21:43:00","snet_input_date":"2023-08-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-17 21:43:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:17.000000Z","updated_at":"2025-03-17T19:37:17.000000Z","inspection_violations":[{"id":5811601,"change_date":"2023-08-30 21:45:00","inspection_id":"79434573","insp_violation_id":"254987696","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:56.000000Z","updated_at":"2025-03-17T21:33:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6058863,"change_date":"2023-08-30 21:45:00","inspection_id":"79434573","insp_unit_id":"196816191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"066386","insp_unit_license":"BC23654","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML1LL066386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:55.000000Z","updated_at":"2025-03-17T22:50:55.000000Z"}]},{"id":3447447,"change_date":"2023-07-06 21:43:00","inspection_id":"79074930","dot_number":"675742","report_state":"MI","report_number":"OSHEE02035","insp_date":"2023-07-05 00:00:00","insp_start_time":"0950","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LAKE ST @ BRIDGE ST","county_code_state":"MI","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1133725","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-07-06 21:43:00","snet_input_date":"2023-07-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-06 21:43:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:19.000000Z","updated_at":"2025-03-17T19:31:19.000000Z","inspection_violations":[{"id":5314982,"change_date":"2023-07-06 21:43:00","inspection_id":"79074930","insp_violation_id":"253903668","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4233350","created_at":"2025-03-17T21:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5543678,"change_date":"2023-07-06 21:43:00","inspection_id":"79074930","insp_unit_id":"195859823","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC23673","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML5LL067282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:45.000000Z","updated_at":"2025-03-17T22:46:45.000000Z"}]},{"id":3342794,"change_date":"2023-06-22 21:42:00","inspection_id":"78957473","dot_number":"675742","report_state":"MI","report_number":"BENNK00369","insp_date":"2023-06-21 00:00:00","insp_start_time":"1325","insp_end_time":"1331","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I75","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1131604","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:19.000000Z","updated_at":"2025-03-17T19:29:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5374112,"change_date":"2023-06-22 21:42:00","inspection_id":"78957473","insp_unit_id":"195625406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD11181","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML8JH578287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"}]},{"id":3142031,"change_date":"2023-05-25 21:42:00","inspection_id":"78730744","dot_number":"675742","report_state":"MI","report_number":"WONTD00473","insp_date":"2023-05-24 00:00:00","insp_start_time":"1550","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PLANK RD @ LOVES","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1127906","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-05-25 21:42:00","snet_input_date":"2023-05-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:19.000000Z","updated_at":"2025-03-17T19:25:19.000000Z","inspection_violations":[{"id":4836610,"change_date":"2023-05-25 21:42:00","inspection_id":"78730744","insp_violation_id":"253080646","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195145024","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"3939A"},{"id":4836611,"change_date":"2023-05-25 21:42:00","inspection_id":"78730744","insp_violation_id":"253080647","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195145024","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:29.000000Z","updated_at":"2025-03-17T21:29:29.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5053583,"change_date":"2023-05-25 21:42:00","inspection_id":"78730744","insp_unit_id":"195145024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105546","insp_unit_license":"BC11872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMMLXLH105546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"}]},{"id":3068183,"change_date":"2023-05-17 21:43:00","inspection_id":"78647594","dot_number":"675742","report_state":"MI","report_number":"MALOJ01759","insp_date":"2023-05-16 00:00:00","insp_start_time":"0930","insp_end_time":"1019","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 S\/B @ HARTWICK PINES RA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1126286","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4935756,"change_date":"2023-05-17 21:43:00","inspection_id":"78647594","insp_unit_id":"194983208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"275446","insp_unit_license":"RB86168","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR1MN275446","insp_unit_decal":"Y","insp_unit_decal_number":"32662173","created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"},{"id":4935757,"change_date":"2023-05-17 21:43:00","inspection_id":"78647594","insp_unit_id":"194983209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"15351","insp_unit_license":"26-6335A","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B2GL965840","insp_unit_decal":"Y","insp_unit_decal_number":"32662177","created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"}]},{"id":2862668,"change_date":"2023-04-21 21:41:00","inspection_id":"78415115","dot_number":"675742","report_state":"MI","report_number":"ANDER05440","insp_date":"2023-04-21 00:00:00","insp_start_time":"0550","insp_end_time":"0620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 24 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1122962","transaction_code":"A","transaction_date":"2023-04-21 00:00:00","upload_date":"2023-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-04-21 21:41:00","snet_input_date":"2023-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-21 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:39.000000Z","updated_at":"2025-03-17T19:19:39.000000Z","inspection_violations":[{"id":4393123,"change_date":"2023-04-21 21:41:00","inspection_id":"78415115","insp_violation_id":"252369754","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4189442","created_at":"2025-03-17T21:27:31.000000Z","updated_at":"2025-03-17T21:27:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4606001,"change_date":"2023-04-21 21:41:00","inspection_id":"78415115","insp_unit_id":"194520872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"-","insp_unit_license":"BD17396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXPL189996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:20.000000Z","updated_at":"2025-03-17T22:39:20.000000Z"}]},{"id":2565970,"change_date":"2023-03-13 21:42:00","inspection_id":"78078087","dot_number":"675742","report_state":"MI","report_number":"HADZM03575","insp_date":"2023-03-10 00:00:00","insp_start_time":"1645","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ VAN HORN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OWENS","shipping_paper_number":"189381B","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1117126","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-03-13 21:42:00","snet_input_date":"2023-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-13 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:04.000000Z","updated_at":"2025-03-17T19:14:04.000000Z","inspection_violations":[{"id":3946203,"change_date":"2023-03-13 21:42:00","inspection_id":"78078087","insp_violation_id":"251629360","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4191149","created_at":"2025-03-17T21:25:31.000000Z","updated_at":"2025-03-17T21:25:31.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":4129501,"change_date":"2023-03-13 21:42:00","inspection_id":"78078087","insp_unit_id":"193843070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"152051","insp_unit_license":"BC60103","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML7MH152051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:35.000000Z","updated_at":"2025-03-17T22:35:35.000000Z"}]},{"id":2346418,"change_date":"2023-04-11 12:04:00","inspection_id":"77827833","dot_number":"675742","report_state":"MI","report_number":"PATTM04163","insp_date":"2023-02-09 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1113225","transaction_code":"C","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-02-10 21:40:00","snet_input_date":"2023-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:57.000000Z","updated_at":"2025-03-17T19:09:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3775881,"change_date":"2023-04-11 12:04:00","inspection_id":"77827833","insp_unit_id":"194305057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC60101","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML9MH152049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:03.000000Z","updated_at":"2025-03-17T22:33:03.000000Z"}]},{"id":2201905,"change_date":"2023-01-23 21:41:00","inspection_id":"77663280","dot_number":"675742","report_state":"MI","report_number":"STOCC03969","insp_date":"2023-01-23 00:00:00","insp_start_time":"0930","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B US12","county_code_state":"MI","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARMELA FOODS INC","shipping_paper_number":"1567736","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1110286","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-01-23 21:41:00","snet_input_date":"2023-01-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-23 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:19.000000Z","updated_at":"2025-03-17T19:07:19.000000Z","inspection_violations":[{"id":3400149,"change_date":"2023-01-23 21:41:00","inspection_id":"77663280","insp_violation_id":"250711870","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193003976","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:06.000000Z","updated_at":"2025-03-17T21:23:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3543910,"change_date":"2023-01-23 21:41:00","inspection_id":"77663280","insp_unit_id":"193003976","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"067276","insp_unit_license":"BC23672","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXLL067276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:24.000000Z","updated_at":"2025-03-17T22:31:24.000000Z"}]},{"id":2181796,"change_date":"2023-01-19 21:44:00","inspection_id":"77640237","dot_number":"675742","report_state":"MI","report_number":"HADZM03434","insp_date":"2023-01-18 00:00:00","insp_start_time":"1640","insp_end_time":"1655","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ SPRINGWELLS","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/AA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1109780","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-01-19 21:44:00","snet_input_date":"2023-01-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:55.000000Z","updated_at":"2025-03-17T19:06:55.000000Z","inspection_violations":[{"id":3370346,"change_date":"2023-01-19 21:44:00","inspection_id":"77640237","insp_violation_id":"250662115","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3511784,"change_date":"2023-01-19 21:44:00","inspection_id":"77640237","insp_unit_id":"192958500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"564507","insp_unit_license":"BC51549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXML564507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:11.000000Z","updated_at":"2025-03-17T22:31:11.000000Z"}]},{"id":2141011,"change_date":"2023-01-13 21:40:00","inspection_id":"77593273","dot_number":"675742","report_state":"MI","report_number":"PATTM04109","insp_date":"2023-01-13 00:00:00","insp_start_time":"0815","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1109125","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-01-13 21:40:00","snet_input_date":"2023-01-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-13 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:12.000000Z","updated_at":"2025-03-17T19:06:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3445520,"change_date":"2023-01-13 21:40:00","inspection_id":"77593273","insp_unit_id":"192867929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC51550","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML1ML564508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:42.000000Z","updated_at":"2025-03-17T22:30:42.000000Z"}]},{"id":2095769,"change_date":"2023-01-09 21:42:00","inspection_id":"77541441","dot_number":"675742","report_state":"MI","report_number":"SILKS03421","insp_date":"2023-01-07 00:00:00","insp_start_time":"1215","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"540R3","location_desc":"I94 E @ BATTLE CREEK RA","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108191","transaction_code":"A","transaction_date":"2023-01-07 00:00:00","upload_date":"2023-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2023-01-09 21:42:00","snet_input_date":"2023-01-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-09 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:10.000000Z","updated_at":"2025-03-17T19:05:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3372093,"change_date":"2023-01-09 21:42:00","inspection_id":"77541441","insp_unit_id":"192764112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC37781","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4NL672588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:09.000000Z","updated_at":"2025-03-17T22:30:09.000000Z"}]},{"id":1842917,"change_date":"2022-11-30 21:40:00","inspection_id":"77252286","dot_number":"675742","report_state":"MI","report_number":"BOSSL00008","insp_date":"2022-11-30 00:00:00","insp_start_time":"1244","insp_end_time":"1332","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB M6 @ BROADMMOR","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARMELA FOOD DISTRIBUTING INC","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":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103933","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[{"id":2874521,"change_date":"2022-11-30 21:40:00","inspection_id":"77252286","insp_violation_id":"249850759","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:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3922"},{"id":2874522,"change_date":"2022-11-30 21:40:00","inspection_id":"77252286","insp_violation_id":"249850760","seq_no":"2","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4145395","created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":2965152,"change_date":"2022-11-30 21:40:00","inspection_id":"77252286","insp_unit_id":"192192853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"564505","insp_unit_license":"BC51551","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML6ML564505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"}]},{"id":1834157,"change_date":"2022-11-29 21:41:00","inspection_id":"77242334","dot_number":"675742","report_state":"MI","report_number":"HARRK00868","insp_date":"2022-11-29 00:00:00","insp_start_time":"0545","insp_end_time":"0610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ M-39","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTIPLE","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103618","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-11-29 21:41:00","snet_input_date":"2022-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:22.000000Z","updated_at":"2025-03-17T19:00:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2950962,"change_date":"2022-11-29 21:41:00","inspection_id":"77242334","insp_unit_id":"192172182","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"672588","insp_unit_license":"BC37781","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4NL672588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:12.000000Z","updated_at":"2025-03-17T22:27:12.000000Z"}]},{"id":1295550,"change_date":"2022-09-15 21:40:00","inspection_id":"76621166","dot_number":"675742","report_state":"OH","report_number":"9455300244","insp_date":"2022-09-15 00:00:00","insp_start_time":"1246","insp_end_time":"1308","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"1501927A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1616401","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2085343,"change_date":"2022-09-15 21:40:00","inspection_id":"76621166","insp_unit_id":"190923309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"189996","insp_unit_license":"BD17396","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXPL189996","insp_unit_decal":"Y","insp_unit_decal_number":"31609353","created_at":"2025-03-17T22:21:19.000000Z","updated_at":"2025-03-17T22:21:19.000000Z"}]},{"id":1098346,"change_date":"2022-08-22 21:42:00","inspection_id":"76392659","dot_number":"675742","report_state":"MI","report_number":"VANHJ02998","insp_date":"2022-08-18 00:00:00","insp_start_time":"0810","insp_end_time":"0816","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"22 1\/2 MILE RD","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARMELA","shipping_paper_number":"KZ1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1090467","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1729116,"change_date":"2022-08-22 21:42:00","inspection_id":"76392659","insp_violation_id":"247883734","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190455432","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1766579,"change_date":"2022-08-22 21:42:00","inspection_id":"76392659","insp_unit_id":"190455432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"564505","insp_unit_license":"BC51551","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML6ML564505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":973538,"change_date":"2022-08-05 21:40:00","inspection_id":"76246865","dot_number":"675742","report_state":"MI","report_number":"OSHEE01844","insp_date":"2022-08-04 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 SB @ 288 MM","county_code_state":"MI","county_code":"137","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1087580","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-08-05 21:40:00","snet_input_date":"2022-08-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:47.000000Z","updated_at":"2025-03-17T18:44:47.000000Z","inspection_violations":[{"id":1535225,"change_date":"2022-08-05 21:40:00","inspection_id":"76246865","insp_violation_id":"247543635","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4101729","created_at":"2025-03-17T21:14:14.000000Z","updated_at":"2025-03-17T21:14:14.000000Z","normalized_code":"39216A"},{"id":1535226,"change_date":"2022-08-05 21:40:00","inspection_id":"76246865","insp_violation_id":"247543636","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190158548","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:14.000000Z","updated_at":"2025-03-17T21:14:14.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1566581,"change_date":"2022-08-05 21:40:00","inspection_id":"76246865","insp_unit_id":"190158548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105528","insp_unit_license":"BB96176","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML8LH105528","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:52.000000Z","updated_at":"2025-03-17T22:17:52.000000Z"}]},{"id":551141,"change_date":"2022-06-09 21:42:00","inspection_id":"75750011","dot_number":"675742","report_state":"MI","report_number":"LECHR02689","insp_date":"2022-06-03 00:00:00","insp_start_time":"1840","insp_end_time":"1916","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"I96 EB SCALE","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078435","transaction_code":"C","transaction_date":"2022-06-03 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-06-06 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[{"id":867276,"change_date":"2022-06-09 21:42:00","inspection_id":"75750011","insp_violation_id":"246337034","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189148136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":886718,"change_date":"2022-06-09 21:42:00","inspection_id":"75750011","insp_unit_id":"189148136","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC11872","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMMLXLH105546","insp_unit_decal":"Y","insp_unit_decal_number":"31292534","created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]},{"id":489493,"change_date":"2022-06-09 21:42:00","inspection_id":"75676864","dot_number":"675742","report_state":"MI","report_number":"MCGEJ02439","insp_date":"2022-05-25 00:00:00","insp_start_time":"1753","insp_end_time":"1809","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"M66 SB @ KALKASKA ST","county_code_state":"MI","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1077100","transaction_code":"C","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:20.000000Z","updated_at":"2025-03-17T18:36:20.000000Z","inspection_violations":[{"id":776031,"change_date":"2022-06-09 21:42:00","inspection_id":"75676864","insp_violation_id":"246337655","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189148737","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:10:40.000000Z","updated_at":"2025-03-17T21:10:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":787153,"change_date":"2022-06-09 21:42:00","inspection_id":"75676864","insp_unit_id":"189148737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"64918","insp_unit_license":"BC23663","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML9LL064918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"}]},{"id":445371,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","dot_number":"675742","report_state":"MI","report_number":"MANIJ01091","insp_date":"2022-05-17 00:00:00","insp_start_time":"1139","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MASSEY'S FISH","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"5","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1076079","transaction_code":"C","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:36.000000Z","updated_at":"2025-03-17T18:35:36.000000Z","inspection_violations":[{"id":703168,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_violation_id":"246338627","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3903E"},{"id":703169,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_violation_id":"246338628","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4048671","created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3958A1"},{"id":703170,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_violation_id":"246338629","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189149689","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39345D"},{"id":703171,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_violation_id":"246338630","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189149690","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"39348A"},{"id":703172,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_violation_id":"246338631","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189149690","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":717775,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_unit_id":"189149689","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"255049","insp_unit_license":"DB07981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR0NL255049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"},{"id":717776,"change_date":"2022-06-09 21:42:00","inspection_id":"75623999","insp_unit_id":"189149690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2539EU046421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"}]},{"id":43761,"change_date":"2022-03-25 21:31:00","inspection_id":"75141254","dot_number":"675742","report_state":"MI","report_number":"BARTC01845","insp_date":"2022-03-24 00:00:00","insp_start_time":"1550","insp_end_time":"1604","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"16 RD @ 35 RD","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1069064","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00675742","upload_search_indicator":null,"census_search_date":"2022-03-25 21:31:00","snet_input_date":"2022-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"CARMELA FOOD DISTRIBUTING INC","insp_carrier_street":"18350 15 MILE ROAD","insp_carrier_city":"FRASER","insp_carrier_state":"MI","insp_carrier_zip_code":"48026","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[{"id":61582,"change_date":"2022-03-25 21:31:00","inspection_id":"75141254","insp_violation_id":"244782114","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4032233","created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":70564,"change_date":"2022-03-25 21:31:00","inspection_id":"75141254","insp_unit_id":"187824866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"564508","insp_unit_license":"BC51550","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML1ML564508","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/675742\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/675742\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/675742\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/675742\/inspections","per_page":100,"prev_page_url":null,"to":61,"total":61}