{"current_page":1,"data":[{"id":12704751,"change_date":"2026-08-12 21:43:00","inspection_id":"88679474","dot_number":"1692972","report_state":"MI","report_number":"WILLD04363","insp_date":"2026-08-12 00:00:00","insp_start_time":"1000","insp_end_time":"1105","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"3968106","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-15T09:41:34.000000Z","updated_at":"2026-08-21T09:34:39.000000Z","inspection_violations":[{"id":22117439,"change_date":"2026-08-12 21:43:00","inspection_id":"88679474","insp_violation_id":"276082734","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X473","created_at":"2026-08-15T10:02:16.000000Z","updated_at":"2026-08-21T09:45:38.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":22048877,"change_date":"2026-08-12 21:43:00","inspection_id":"88679474","insp_unit_id":"215116621","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BE23082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NPKHM6X1TM775811","insp_unit_decal":"Y","insp_unit_decal_number":"36680086","created_at":"2026-08-15T09:18:09.000000Z","updated_at":"2026-08-21T09:07:12.000000Z"}]},{"id":12373929,"change_date":"2026-07-07 21:40:00","inspection_id":"88336468","dot_number":"1692972","report_state":"MI","report_number":"KOCHJ02508","insp_date":"2026-07-07 00:00:00","insp_start_time":"1250","insp_end_time":"1305","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"421837A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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":"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":"3699722","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":"01692972","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":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:21.000000Z","updated_at":"2026-07-18T09:30:48.000000Z","inspection_violations":[{"id":21535321,"change_date":"2026-07-07 21:40:00","inspection_id":"88336468","insp_violation_id":"275337341","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:32.000000Z","updated_at":"2026-07-18T09:42:24.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21487018,"change_date":"2026-07-07 21:40:00","inspection_id":"88336468","insp_unit_id":"214477661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD35665","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML0JH501560","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":11855940,"change_date":"2026-05-08 21:38:00","inspection_id":"87792166","dot_number":"1692972","report_state":"MI","report_number":"FOXMA01868","insp_date":"2026-05-08 00:00:00","insp_start_time":"0655","insp_end_time":"0710","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"067","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-08 21:38: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":"3283827","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-11T09:39:58.000000Z","updated_at":"2026-05-19T09:30:37.000000Z","inspection_violations":[{"id":20620952,"change_date":"2026-05-08 21:38:00","inspection_id":"87792166","insp_violation_id":"274126801","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:47.000000Z","updated_at":"2026-05-19T09:42:03.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":20616995,"change_date":"2026-05-08 21:38:00","inspection_id":"87792166","insp_unit_id":"213444761","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BE23082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NPKHM6X1TM775811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:20.000000Z","updated_at":"2026-05-19T09:02:40.000000Z"}]},{"id":11554799,"change_date":"2026-04-02 21:39:00","inspection_id":"87477898","dot_number":"1692972","report_state":"MI","report_number":"NESBA02656","insp_date":"2026-03-31 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@CLINTONVILLE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1264866","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-03-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-05T09:57:00.000000Z","updated_at":"2026-04-13T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19801793,"change_date":"2026-04-02 21:39:00","inspection_id":"87477898","insp_unit_id":"212506265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"16","insp_unit_license":"BD04579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV7P5T51698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:19.000000Z","updated_at":"2026-04-13T09:04:30.000000Z"}]},{"id":10297684,"change_date":"2025-12-04 21:38:00","inspection_id":"86423242","dot_number":"1692972","report_state":"MI","report_number":"ZYLSJ01617","insp_date":"2025-11-24 00:00:00","insp_start_time":"1045","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BUD'S TOW YARD","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"406302A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-26 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"25950","viol_total":"2","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":"1251926","transaction_code":"C","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2025-11-26 21:38:00","snet_input_date":"2025-11-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-08T10:30:44.000000Z","inspection_violations":[{"id":17323592,"change_date":"2025-12-04 21:38:00","inspection_id":"86423242","insp_violation_id":"270464695","seq_no":"1","part_no":"392","part_no_section":"2-SLTFC","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-12-07T10:32:12.000000Z","updated_at":"2025-12-08T10:31:20.000000Z","normalized_code":"3922SLTFC"},{"id":17323593,"change_date":"2025-12-04 21:38:00","inspection_id":"86423242","insp_violation_id":"270464696","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","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-12-07T10:32:12.000000Z","updated_at":"2025-12-08T10:31:20.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":17293109,"change_date":"2025-12-04 21:38:00","inspection_id":"86423242","insp_unit_id":"210416629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"22","insp_unit_license":"BD84310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AT5R5T50440","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:53.000000Z"}]},{"id":8146620,"change_date":"2025-03-18 21:40:00","inspection_id":"84158031","dot_number":"1692972","report_state":"MI","report_number":"BACZM02638","insp_date":"2025-03-18 00:00:00","insp_start_time":"0952","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"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-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213868","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-21T10:34:40.000000Z","updated_at":"2025-03-22T10:36:33.000000Z","inspection_violations":[{"id":12749920,"change_date":"2025-03-18 21:40:00","inspection_id":"84158031","insp_violation_id":"265108184","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4494063","created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:46.000000Z","normalized_code":"39141AMCPC"},{"id":12749921,"change_date":"2025-03-18 21:40:00","inspection_id":"84158031","insp_violation_id":"265108185","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:46.000000Z","normalized_code":"3922SLLLR"},{"id":12749922,"change_date":"2025-03-18 21:40:00","inspection_id":"84158031","insp_violation_id":"265108186","seq_no":"3","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:46.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13158710,"change_date":"2025-03-18 21:40:00","inspection_id":"84158031","insp_unit_id":"205861780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BC49986","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0L5S57733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:07:02.000000Z","updated_at":"2025-03-22T10:00:29.000000Z"}]},{"id":8097277,"change_date":"2025-03-12 21:40:00","inspection_id":"84106120","dot_number":"1692972","report_state":"MI","report_number":"LITTJ05412","insp_date":"2025-03-11 00:00:00","insp_start_time":"1120","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ SASHABAW","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LEO'S CONEY ISLAND","shipping_paper_number":"2900","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212872","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-17T21:06:19.000000Z","inspection_violations":[{"id":12658197,"change_date":"2025-03-12 21:40:00","inspection_id":"84106120","insp_violation_id":"264979585","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4502502","created_at":"2025-03-17T22:07:57.000000Z","updated_at":"2025-03-17T22:07:57.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":13073598,"change_date":"2025-03-12 21:40:00","inspection_id":"84106120","insp_unit_id":"205761631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"18","insp_unit_license":"BD45382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML3HH741597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"}]},{"id":7462446,"change_date":"2024-12-19 21:41:00","inspection_id":"83439301","dot_number":"1692972","report_state":"MI","report_number":"NESBA01802","insp_date":"2024-12-18 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@SASHABAW RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"383072A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1204870","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-12-19 21:41:00","snet_input_date":"2024-12-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-19 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:54.000000Z","updated_at":"2025-03-17T20:51:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12038890,"change_date":"2024-12-19 21:41:00","inspection_id":"83439301","insp_unit_id":"204481501","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2","insp_unit_license":"BC72674","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML3FH662461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:56.000000Z","updated_at":"2025-03-17T23:47:56.000000Z"}]},{"id":7372447,"change_date":"2024-12-09 21:41:00","inspection_id":"83344882","dot_number":"1692972","report_state":"MI","report_number":"BALLB05013","insp_date":"2024-12-09 00:00:00","insp_start_time":"0920","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"RAMP","location_desc":"I94 E @ 9  MILE","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"382396A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1203731","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-12-09 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11519955,"change_date":"2024-12-09 21:41:00","inspection_id":"83344882","insp_violation_id":"263331822","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3922SLLLR"},{"id":11519956,"change_date":"2024-12-09 21:41:00","inspection_id":"83344882","insp_violation_id":"263331823","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11893185,"change_date":"2024-12-09 21:41:00","inspection_id":"83344882","insp_unit_id":"204271514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"9","insp_unit_license":"BD35664","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0K4S57218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":7372445,"change_date":"2024-12-09 21:41:00","inspection_id":"83344880","dot_number":"1692972","report_state":"MI","report_number":"BACZM02558","insp_date":"2024-12-06 00:00:00","insp_start_time":"0943","insp_end_time":"1012","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MIUTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-12-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1203649","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-12-09 21:41:00","snet_input_date":"2024-12-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11519953,"change_date":"2024-12-09 21:41:00","inspection_id":"83344880","insp_violation_id":"263331820","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3922SLLLR"},{"id":11519954,"change_date":"2024-12-09 21:41:00","inspection_id":"83344880","insp_violation_id":"263331821","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":11893182,"change_date":"2024-12-09 21:41:00","inspection_id":"83344880","insp_unit_id":"204271511","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD45382","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML3HH741597","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":7174721,"change_date":"2024-11-12 21:42:00","inspection_id":"83136119","dot_number":"1692972","report_state":"MI","report_number":"LOPEL01695","insp_date":"2024-11-04 00:00:00","insp_start_time":"1340","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MIDDLEBELT RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"1200702","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11209131,"change_date":"2024-11-12 21:42:00","inspection_id":"83136119","insp_violation_id":"262849070","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11572591,"change_date":"2024-11-12 21:42:00","inspection_id":"83136119","insp_unit_id":"203842202","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"8","insp_unit_license":"BD30850","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML4KH601940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":7039050,"change_date":"2024-10-24 21:41:00","inspection_id":"82992293","dot_number":"1692972","report_state":"MI","report_number":"DAWDD03745","insp_date":"2024-10-22 00:00:00","insp_start_time":"1120","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT FARMINGTON","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1199256","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[{"id":10984880,"change_date":"2024-10-24 21:41:00","inspection_id":"82992293","insp_violation_id":"262541857","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"3922SLLLR"},{"id":10984881,"change_date":"2024-10-24 21:41:00","inspection_id":"82992293","insp_violation_id":"262541858","seq_no":"2","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-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":11352487,"change_date":"2024-10-24 21:41:00","inspection_id":"82992293","insp_unit_id":"203574247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"14","insp_unit_license":"BC49986","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0L5S57733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6990274,"change_date":"2024-10-18 21:42:00","inspection_id":"82940510","dot_number":"1692972","report_state":"MI","report_number":"DAWDD03739","insp_date":"2024-10-16 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1198449","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":10904783,"change_date":"2024-10-18 21:42:00","inspection_id":"82940510","insp_violation_id":"262428294","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-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":11274804,"change_date":"2024-10-18 21:42:00","inspection_id":"82940510","insp_unit_id":"203475651","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"14","insp_unit_license":"BC49986","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0L5S57733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6084320,"change_date":"2024-06-26 21:43:00","inspection_id":"81973349","dot_number":"1692972","report_state":"MI","report_number":"FOXMA01335","insp_date":"2024-06-25 00:00:00","insp_start_time":"1135","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT MM 52","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"1183705","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9442143,"change_date":"2024-06-26 21:43:00","inspection_id":"81973349","insp_violation_id":"260329487","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4393223","created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"39216A"},{"id":9442144,"change_date":"2024-06-26 21:43:00","inspection_id":"81973349","insp_violation_id":"260329488","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":"X4393223","created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9799782,"change_date":"2024-06-26 21:43:00","inspection_id":"81973349","insp_unit_id":"201607329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BD35664","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0K4S57218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":6046836,"change_date":"2024-06-26 21:43:00","inspection_id":"81932971","dot_number":"1692972","report_state":"MI","report_number":"BACZM02375","insp_date":"2024-06-21 00:00:00","insp_start_time":"0945","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ LAKE RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"370841A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1183366","transaction_code":"C","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-06-21 21:39:00","snet_input_date":"2024-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-21 21:39:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:36.000000Z","updated_at":"2025-03-17T20:22:36.000000Z","inspection_violations":[{"id":9379559,"change_date":"2024-06-26 21:43:00","inspection_id":"81932971","insp_violation_id":"260328631","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:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"3922"},{"id":9379560,"change_date":"2024-06-26 21:43:00","inspection_id":"81932971","insp_violation_id":"260328632","seq_no":"2","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:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"3922"},{"id":9379561,"change_date":"2024-06-26 21:43:00","inspection_id":"81932971","insp_violation_id":"260328633","seq_no":"3","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4378174","created_at":"2025-03-17T21:51:21.000000Z","updated_at":"2025-03-17T21:51:21.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":9739085,"change_date":"2024-06-26 21:43:00","inspection_id":"81932971","insp_unit_id":"201606607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"22","insp_unit_license":"BD84310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AT5R5T50440","insp_unit_decal":"Y","insp_unit_decal_number":"33976641","created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":5868141,"change_date":"2024-05-29 21:41:00","inspection_id":"81739002","dot_number":"1692972","report_state":"MI","report_number":"KERSD00564","insp_date":"2024-05-28 00:00:00","insp_start_time":"1120","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 WB @ TIREMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","shipping_paper_number":"88410","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1180256","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:04.000000Z","updated_at":"2025-03-17T20:19:04.000000Z","inspection_violations":[{"id":9098456,"change_date":"2024-05-29 21:41:00","inspection_id":"81739002","insp_violation_id":"259792322","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:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3922"},{"id":9098457,"change_date":"2024-05-29 21:41:00","inspection_id":"81739002","insp_violation_id":"259792323","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:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9451212,"change_date":"2024-05-29 21:41:00","inspection_id":"81739002","insp_unit_id":"201137632","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"11","insp_unit_license":"BD04579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV7P5T51698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:03.000000Z","updated_at":"2025-03-17T23:21:03.000000Z"}]},{"id":5607987,"change_date":"2024-04-26 21:39:00","inspection_id":"81456648","dot_number":"1692972","report_state":"MI","report_number":"LITTJ05027","insp_date":"2024-04-25 00:00:00","insp_start_time":"0950","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ METTETAL","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 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":"1175839","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9033327,"change_date":"2024-04-26 21:39:00","inspection_id":"81456648","insp_unit_id":"200598838","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BC72674","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML3FH662461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5215296,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","dot_number":"1692972","report_state":"MI","report_number":"RAMSB01791","insp_date":"2024-03-04 00:00:00","insp_start_time":"0926","insp_end_time":"0944","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I275 SB AT ECORSE RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1167559","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:47.000000Z","updated_at":"2025-03-17T20:05:47.000000Z","inspection_violations":[{"id":8036802,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","insp_violation_id":"258208761","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":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39216A"},{"id":8036803,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","insp_violation_id":"258208762","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3922"},{"id":8036804,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","insp_violation_id":"258208763","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"39141A"},{"id":8036805,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","insp_violation_id":"258208764","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8397761,"change_date":"2024-03-05 21:41:00","inspection_id":"81028026","insp_unit_id":"199762210","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"BD04578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X3HM166680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:05.000000Z","updated_at":"2025-03-17T23:11:05.000000Z"}]},{"id":4702953,"change_date":"2023-12-26 21:40:00","inspection_id":"80468762","dot_number":"1692972","report_state":"MI","report_number":"DAWDD03218","insp_date":"2023-12-22 00:00:00","insp_start_time":"1259","insp_end_time":"1322","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT FARMINGTON","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"P&L","shipping_paper_number":"12222023","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1158462","transaction_code":"A","transaction_date":"2023-12-22 00:00:00","upload_date":"2023-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-12-26 21:40:00","snet_input_date":"2023-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-26 21:40:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:08.000000Z","updated_at":"2025-03-17T19:56:08.000000Z","inspection_violations":[{"id":7264054,"change_date":"2023-12-26 21:40:00","inspection_id":"80468762","insp_violation_id":"257049199","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:41:06.000000Z","updated_at":"2025-03-17T21:41:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7564629,"change_date":"2023-12-26 21:40:00","inspection_id":"80468762","insp_unit_id":"198665311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"21","insp_unit_license":"BD71959","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV0P5T53549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:36.000000Z","updated_at":"2025-03-17T23:03:36.000000Z"}]},{"id":4125228,"change_date":"2023-10-04 21:41:00","inspection_id":"79832105","dot_number":"1692972","report_state":"MI","report_number":"DAWDD03095","insp_date":"2023-10-03 00:00:00","insp_start_time":"0903","insp_end_time":"0927","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 AT 6 MILE RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"P & L FOOD WHOLESALERS","shipping_paper_number":"352831","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-04 21:41: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":"1148457","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-10-04 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:26.000000Z","updated_at":"2025-03-17T19:44:26.000000Z","inspection_violations":[{"id":6384173,"change_date":"2023-10-04 21:41:00","inspection_id":"79832105","insp_violation_id":"255656474","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197396859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3922"},{"id":6384174,"change_date":"2023-10-04 21:41:00","inspection_id":"79832105","insp_violation_id":"255656475","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197396859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:47.000000Z","updated_at":"2025-03-17T21:36:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6632635,"change_date":"2023-10-04 21:41:00","inspection_id":"79832105","insp_unit_id":"197396859","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"19","insp_unit_license":"BA06305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML6HH746096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:38.000000Z","updated_at":"2025-03-17T22:55:38.000000Z"}]},{"id":3723026,"change_date":"2023-08-30 21:44:00","inspection_id":"79384098","dot_number":"1692972","report_state":"MI","report_number":"ELDEH00265","insp_date":"2023-08-09 00:00:00","insp_start_time":"1015","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ KING 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":"2023-08-11 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":"1139524","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5740659,"change_date":"2023-08-30 21:44:00","inspection_id":"79384098","insp_violation_id":"254983833","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":"X4253277","created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5986283,"change_date":"2023-08-30 21:44:00","inspection_id":"79384098","insp_unit_id":"196813411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"BD04578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X3HM166680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3522475,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","dot_number":"1692972","report_state":"MI","report_number":"CHESJ04621","insp_date":"2023-07-14 00:00:00","insp_start_time":"0915","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W I-96 @ 8 MILE","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"9","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135756","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5431463,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097439","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":"X4241536","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5431464,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097440","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"38323A2"},{"id":5431465,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097441","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"},{"id":5431466,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097442","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3963A1"},{"id":5431467,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097443","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3963A1"},{"id":5431468,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097444","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39347A"},{"id":5431469,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097445","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3963A1"},{"id":5431470,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097446","seq_no":"8","part_no":"396","part_no_section":"7","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4241536","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3967"},{"id":5431471,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_violation_id":"254097447","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196032238","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5663767,"change_date":"2023-07-17 21:41:00","inspection_id":"79159282","insp_unit_id":"196032238","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BD04577","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML9JH488145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3166914,"change_date":"2023-05-30 21:42:00","inspection_id":"78758916","dot_number":"1692972","report_state":"MI","report_number":"ELDEH00186","insp_date":"2023-05-30 00:00:00","insp_start_time":"1320","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB @ MT MORRIS RD","county_code_state":"MI","county_code":"049","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":"2023-05-30 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":"1128387","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[{"id":4877645,"change_date":"2023-05-30 21:42:00","inspection_id":"78758916","insp_violation_id":"253146070","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"3922"},{"id":4877646,"change_date":"2023-05-30 21:42:00","inspection_id":"78758916","insp_violation_id":"253146071","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:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5093831,"change_date":"2023-05-30 21:42:00","inspection_id":"78758916","insp_unit_id":"195200531","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"15","insp_unit_license":"BC12208","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTEUMML2KH562334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:08.000000Z","updated_at":"2025-03-17T22:43:08.000000Z"}]},{"id":2656385,"change_date":"2023-03-24 21:41:00","inspection_id":"78180456","dot_number":"1692972","report_state":"MI","report_number":"POWEL03070","insp_date":"2023-03-24 00:00:00","insp_start_time":"0715","insp_end_time":"0742","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ D-19","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119136","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:34.000000Z","updated_at":"2025-03-17T19:15:34.000000Z","inspection_violations":[{"id":4082323,"change_date":"2023-03-24 21:41:00","inspection_id":"78180456","insp_violation_id":"251857990","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":"X4183836","created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3922"},{"id":4082324,"change_date":"2023-03-24 21:41:00","inspection_id":"78180456","insp_violation_id":"251857991","seq_no":"2","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4183836","created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39115A"},{"id":4082325,"change_date":"2023-03-24 21:41:00","inspection_id":"78180456","insp_violation_id":"251857992","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4276678,"change_date":"2023-03-24 21:41:00","inspection_id":"78180456","insp_unit_id":"194054617","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"9","insp_unit_license":"BC18041","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNE8JV0K4S57218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":2369584,"change_date":"2023-02-14 21:41:00","inspection_id":"77854186","dot_number":"1692972","report_state":"MI","report_number":"LITTJ04332","insp_date":"2023-02-14 00:00:00","insp_start_time":"1005","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ 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":"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":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1113901","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3648655,"change_date":"2023-02-14 21:41:00","inspection_id":"77854186","insp_violation_id":"251130466","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39282A1"},{"id":3648656,"change_date":"2023-02-14 21:41:00","inspection_id":"77854186","insp_violation_id":"251130467","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:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":3813044,"change_date":"2023-02-14 21:41:00","inspection_id":"77854186","insp_unit_id":"193394824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"BD04578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHHM6X3HM166680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2226249,"change_date":"2023-01-25 21:42:00","inspection_id":"77690995","dot_number":"1692972","report_state":"MI","report_number":"WILLD02560","insp_date":"2023-01-24 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TELEGRAPH & SQUARE LAKE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-25 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":"1110643","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2023-01-25 21:42:00","snet_input_date":"2023-01-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:43.000000Z","updated_at":"2025-03-17T19:07:43.000000Z","inspection_violations":[{"id":3438098,"change_date":"2023-01-25 21:42:00","inspection_id":"77690995","insp_violation_id":"250775417","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193063475","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:14.000000Z","updated_at":"2025-03-17T21:23:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3583162,"change_date":"2023-01-25 21:42:00","inspection_id":"77690995","insp_unit_id":"193063475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB80810","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML4KH601940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"}]},{"id":243341,"change_date":"2022-06-09 21:42:00","inspection_id":"75383228","dot_number":"1692972","report_state":"MI","report_number":"WATTR03040","insp_date":"2022-04-20 00:00:00","insp_start_time":"1127","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRAND RIVER RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"320222A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1072958","transaction_code":"C","transaction_date":"2022-04-20 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01692972","upload_search_indicator":null,"census_search_date":"2022-04-25 21:41:00","snet_input_date":"2022-04-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"P & L FOOD WHOLESALERS","insp_carrier_street":"9030 GENERAL DRIVE","insp_carrier_city":"PLYMOUTH","insp_carrier_state":"MI","insp_carrier_zip_code":"48170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:51.000000Z","updated_at":"2025-03-17T18:31:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":394655,"change_date":"2022-06-09 21:42:00","inspection_id":"75383228","insp_unit_id":"189153905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"BB32340","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML9JH488145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1692972\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1692972\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1692972\/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\/1692972\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}