{"current_page":1,"data":[{"id":12570476,"change_date":"2026-07-28 21:41:00","inspection_id":"88538445","dot_number":"541596","report_state":"MI","report_number":"ROLLJ03167","insp_date":"2026-07-28 00:00:00","insp_start_time":"1426","insp_end_time":"1506","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PAVEMENT MAINTENANCE","shipping_paper_number":"1038245","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"276500","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":"3852980","transaction_code":"A","transaction_date":"2026-07-28 00:00:00","upload_date":"2026-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":"2026-07-28 21:41:00","snet_input_date":"2026-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-28 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-31T09:41:30.000000Z","updated_at":"2026-08-08T09:31:34.000000Z","inspection_violations":[{"id":21886374,"change_date":"2026-07-28 21:41:00","inspection_id":"88538445","insp_violation_id":"275781953","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"214858722","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4733743","created_at":"2026-07-31T10:02:51.000000Z","updated_at":"2026-08-08T09:43:19.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":21826486,"change_date":"2026-07-28 21:41:00","inspection_id":"88538445","insp_unit_id":"214858722","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC48906","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD12SLVP7105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:14.000000Z","updated_at":"2026-08-08T09:02:49.000000Z"},{"id":21826487,"change_date":"2026-07-28 21:41:00","inspection_id":"88538445","insp_unit_id":"214858723","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"E217244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841MC052333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:14.000000Z","updated_at":"2026-08-08T09:02:49.000000Z"},{"id":21826488,"change_date":"2026-07-28 21:41:00","inspection_id":"88538445","insp_unit_id":"214858724","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"F371699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1749MC052334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-31T09:18:14.000000Z","updated_at":"2026-08-08T09:02:49.000000Z"}]},{"id":11872902,"change_date":"2026-05-11 21:38:00","inspection_id":"87810055","dot_number":"541596","report_state":"MI","report_number":"BOSSL01086","insp_date":"2026-05-11 00:00:00","insp_start_time":"1435","insp_end_time":"1500","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"121","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3301021","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:22.000000Z","updated_at":"2026-05-22T09:30:39.000000Z","inspection_violations":[{"id":20651071,"change_date":"2026-05-11 21:38:00","inspection_id":"87810055","insp_violation_id":"274167839","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:39.000000Z","updated_at":"2026-05-22T09:42:13.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":20644459,"change_date":"2026-05-11 21:38:00","inspection_id":"87810055","insp_unit_id":"213478074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB87850","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X5LJ304560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:04.000000Z","updated_at":"2026-05-22T09:03:07.000000Z"},{"id":20644460,"change_date":"2026-05-11 21:38:00","inspection_id":"87810055","insp_unit_id":"213478075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E146582","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2437TC096429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:04.000000Z","updated_at":"2026-05-22T09:03:07.000000Z"}]},{"id":12031262,"change_date":"2026-05-28 21:42:00","inspection_id":"87971471","dot_number":"541596","report_state":"IL","report_number":"5000230038","insp_date":"2026-04-21 00:00:00","insp_start_time":"0620","insp_end_time":"0701","registration_date":"2026-05-28 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"294NB","county_code_state":"IL","county_code":"031","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":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2475916","transaction_code":"C","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-04-21 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:36.000000Z","updated_at":"2026-06-08T09:30:13.000000Z","inspection_violations":[{"id":20934714,"change_date":"2026-05-28 21:42:00","inspection_id":"87971471","insp_violation_id":"274562233","seq_no":"1","part_no":"392","part_no_section":"2LC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0002300196","created_at":"2026-05-30T09:58:01.000000Z","updated_at":"2026-06-08T09:44:00.000000Z","normalized_code":"3922LC"}],"inspection_per_units":[{"id":20912093,"change_date":"2026-05-28 21:42:00","inspection_id":"87971471","insp_unit_id":"213804253","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"5","insp_unit_license":"RC49494","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD1XSLWC0732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:45.000000Z","updated_at":"2026-06-08T09:01:15.000000Z"},{"id":20912094,"change_date":"2026-05-28 21:42:00","inspection_id":"87971471","insp_unit_id":"213804254","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"E338498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TTF532A4B3566770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:45.000000Z","updated_at":"2026-06-08T09:01:15.000000Z"}]},{"id":11554789,"change_date":"2026-04-02 21:39:00","inspection_id":"87477888","dot_number":"541596","report_state":"MI","report_number":"BURGM07198","insp_date":"2026-04-01 00:00:00","insp_start_time":"1220","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MILLVILLE RD","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMRIZE","shipping_paper_number":"326880031","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"262000","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":"1264719","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:57:00.000000Z","updated_at":"2026-04-13T09:31:21.000000Z","inspection_violations":[{"id":19527854,"change_date":"2026-04-02 21:39:00","inspection_id":"87477888","insp_violation_id":"272828365","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":"X4674277","created_at":"2026-04-05T10:26:46.000000Z","updated_at":"2026-04-12T10:18:09.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19801775,"change_date":"2026-04-02 21:39:00","inspection_id":"87477888","insp_unit_id":"212506246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"250","insp_unit_license":"RC45290","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG5SLUR8187","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":19801776,"change_date":"2026-04-02 21:39:00","inspection_id":"87477888","insp_unit_id":"212506247","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"L20","insp_unit_license":"F371702","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25375C009404","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":19801777,"change_date":"2026-04-02 21:39:00","inspection_id":"87477888","insp_unit_id":"212506248","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"L21","insp_unit_license":"E912270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19515C009405","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":11501084,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","dot_number":"541596","report_state":"MI","report_number":"SHEPZ05588","insp_date":"2026-03-25 00:00:00","insp_start_time":"0935","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 E\/B @ ELM RD","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":"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":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1264131","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:44.000000Z","updated_at":"2026-04-07T09:32:28.000000Z","inspection_violations":[{"id":19420302,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","insp_violation_id":"272692154","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":"X4669937","created_at":"2026-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"3922SLLLR"},{"id":19420303,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","insp_violation_id":"272692155","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","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-03-30T10:20:07.000000Z","updated_at":"2026-04-07T09:48:43.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19702848,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","insp_unit_id":"212384437","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"250","insp_unit_license":"RC45290","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG5SLUR8187","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:50.000000Z"},{"id":19702849,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","insp_unit_id":"212384438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"L20","insp_unit_license":"F371702","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25375C009404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:50.000000Z"},{"id":19702850,"change_date":"2026-03-27 21:40:00","inspection_id":"87421183","insp_unit_id":"212384439","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"L21","insp_unit_license":"E912270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19515C009405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:25.000000Z","updated_at":"2026-04-07T09:08:50.000000Z"}]},{"id":10164882,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","dot_number":"541596","report_state":"MI","report_number":"AKERT00668","insp_date":"2025-11-07 00:00:00","insp_start_time":"1420","insp_end_time":"1543","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 MM 43","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"326874091","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"264000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250032","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:44.000000Z","updated_at":"2025-11-14T10:30:51.000000Z","inspection_violations":[{"id":16874086,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856789","seq_no":"1","part_no":"396","part_no_section":"3A1-ALATR","insp_viol_unit":"2","insp_unit_id":"209947246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"3963A1ALATR"},{"id":16874087,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856790","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209947246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"39345B2BAIR"},{"id":16874088,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856791","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209947246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"39345B2BAIR"},{"id":16874089,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856792","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209947246","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"39347E"},{"id":16874090,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856793","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"209947246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"39353BB"},{"id":16874091,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_violation_id":"269856794","seq_no":"6","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"3","insp_unit_id":"209947247","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4608109","created_at":"2025-11-13T10:31:04.000000Z","updated_at":"2025-11-14T10:31:31.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":16925518,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_unit_id":"209947245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"264","insp_unit_license":"RC55389","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD1XTLWT8198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:42.000000Z","updated_at":"2025-11-14T10:01:04.000000Z"},{"id":16925519,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_unit_id":"209947246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"E890570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25335C009402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:42.000000Z","updated_at":"2025-11-14T10:01:04.000000Z"},{"id":16925520,"change_date":"2025-11-10 21:39:00","inspection_id":"86283863","insp_unit_id":"209947247","insp_unit_type_id":"2","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":null,"insp_unit_license":"E890571","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19585C009403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:42.000000Z","updated_at":"2025-11-14T10:01:04.000000Z"}]},{"id":9792555,"change_date":"2025-09-26 21:40:00","inspection_id":"85891534","dot_number":"541596","report_state":"MI","report_number":"DETGT05486","insp_date":"2025-09-24 00:00:00","insp_start_time":"1215","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 W\/B @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"326876","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1243357","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:09.000000Z","updated_at":"2025-09-30T10:01:09.000000Z","inspection_violations":[{"id":16104136,"change_date":"2025-09-26 21:40:00","inspection_id":"85891534","insp_violation_id":"268951540","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4601968","created_at":"2025-09-30T10:16:51.000000Z","updated_at":"2025-09-30T10:16:51.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16228939,"change_date":"2025-09-26 21:40:00","inspection_id":"85891534","insp_unit_id":"209173419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"259","insp_unit_license":"RC49496","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD18SLWC0731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:50.000000Z"},{"id":16228940,"change_date":"2025-09-26 21:40:00","inspection_id":"85891534","insp_unit_id":"209173420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCOA","insp_unit_company":"L32","insp_unit_license":"E890595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC036037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:50.000000Z"},{"id":16228941,"change_date":"2025-09-26 21:40:00","inspection_id":"85891534","insp_unit_id":"209173421","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCOA","insp_unit_company":"L33","insp_unit_license":"E890596","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC036038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:50.000000Z"}]},{"id":9594603,"change_date":"2025-09-04 21:41:00","inspection_id":"85684107","dot_number":"541596","report_state":"MI","report_number":"MYERD01587","insp_date":"2025-09-04 00:00:00","insp_start_time":"0805","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E @ 96 MM","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VERPLANK","shipping_paper_number":"153953","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"232000","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":"1239375","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-04 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:31.000000Z","updated_at":"2025-09-10T10:45:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15842060,"change_date":"2025-09-04 21:41:00","inspection_id":"85684107","insp_unit_id":"208752355","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"193","insp_unit_license":"RB60747","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0XXKJ240918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:02.000000Z"},{"id":15842061,"change_date":"2025-09-04 21:41:00","inspection_id":"85684107","insp_unit_id":"208752356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACC","insp_unit_company":null,"insp_unit_license":"E912272","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2845AC018374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:02.000000Z"},{"id":15842062,"change_date":"2025-09-04 21:41:00","inspection_id":"85684107","insp_unit_id":"208752357","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACC","insp_unit_company":null,"insp_unit_license":"F128038","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1742AC018375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:02.000000Z"}]},{"id":9051717,"change_date":"2025-07-02 21:40:00","inspection_id":"85113108","dot_number":"541596","report_state":"MI","report_number":"BESSJ01193","insp_date":"2025-07-01 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ FOLWLERVILLE SCALES","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"262000","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":"1228158","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:24.000000Z","updated_at":"2025-07-07T10:07:24.000000Z","inspection_violations":[{"id":14562155,"change_date":"2025-07-02 21:40:00","inspection_id":"85113108","insp_violation_id":"267176000","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:42.000000Z","updated_at":"2025-07-06T10:17:42.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14850539,"change_date":"2025-07-02 21:40:00","inspection_id":"85113108","insp_unit_id":"207679848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"257","insp_unit_license":"RB74644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD19SLVT5238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:11.000000Z","updated_at":"2025-07-06T09:45:55.000000Z"},{"id":14850540,"change_date":"2025-07-02 21:40:00","inspection_id":"85113108","insp_unit_id":"207679849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L14","insp_unit_license":"E146577","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25394C007973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:11.000000Z","updated_at":"2025-07-06T09:45:55.000000Z"},{"id":14850541,"change_date":"2025-07-02 21:40:00","inspection_id":"85113108","insp_unit_id":"207679850","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L15","insp_unit_license":"E146579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19564C007972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:11.000000Z","updated_at":"2025-07-06T09:45:55.000000Z"}]},{"id":6721789,"change_date":"2024-09-17 21:45:00","inspection_id":"82654771","dot_number":"541596","report_state":"MI","report_number":"DETGT04885","insp_date":"2024-09-12 00:00:00","insp_start_time":"0935","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 @ HAWKINS RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1194657","transaction_code":"C","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:28.000000Z","updated_at":"2025-03-17T20:36:28.000000Z","inspection_violations":[{"id":10464122,"change_date":"2024-09-17 21:45:00","inspection_id":"82654771","insp_violation_id":"261861775","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:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10838546,"change_date":"2024-09-17 21:45:00","inspection_id":"82654771","insp_unit_id":"202977578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"253","insp_unit_license":"RB74641","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD17SLVP7102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"},{"id":10838547,"change_date":"2024-09-17 21:45:00","inspection_id":"82654771","insp_unit_id":"202977579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"L212","insp_unit_license":"E217244","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841MC052333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"},{"id":10838548,"change_date":"2024-09-17 21:45:00","inspection_id":"82654771","insp_unit_id":"202977580","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MAC","insp_unit_company":"L213","insp_unit_license":"E217245","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1749MC052334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":6357857,"change_date":"2024-09-17 21:45:00","inspection_id":"82266745","dot_number":"541596","report_state":"MI","report_number":"FELDW00332","insp_date":"2024-07-30 00:00:00","insp_start_time":"1330","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DETROIT SALT COMPANY","shipping_paper_number":"CS024-16703","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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":"212000","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":"1188368","transaction_code":"C","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","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":9871003,"change_date":"2024-09-17 21:45:00","inspection_id":"82266745","insp_violation_id":"261862862","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"202978288","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":10245774,"change_date":"2024-09-17 21:45:00","inspection_id":"82266745","insp_unit_id":"202978288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"192","insp_unit_license":"RB60746","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X8KJ240917","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":10245775,"change_date":"2024-09-17 21:45:00","inspection_id":"82266745","insp_unit_id":"202978289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"L80","insp_unit_license":"E890593","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253FXWS510935","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":10245776,"change_date":"2024-09-17 21:45:00","inspection_id":"82266745","insp_unit_id":"202978290","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"L81","insp_unit_license":"E890594","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F4WS510940","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":6103410,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","dot_number":"541596","report_state":"MI","report_number":"RAMSB01922","insp_date":"2024-06-27 00:00:00","insp_start_time":"1050","insp_end_time":"1211","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 WB AT BELLEVILLE RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DETROIT SALT COMPANY","shipping_paper_number":"887659","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1184126","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9472903,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_violation_id":"260373766","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4376871","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9472904,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_violation_id":"260373767","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"201646149","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39347E"},{"id":9472905,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_violation_id":"260373768","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"201646149","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9830596,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_unit_id":"201646147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"256","insp_unit_license":"RB74651","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD16SLVP7107","insp_unit_decal":"Y","insp_unit_decal_number":"34301256","created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9830597,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_unit_id":"201646148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"L-192","insp_unit_license":"D821996","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2845KC046547","insp_unit_decal":"Y","insp_unit_decal_number":"34301257","created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9830598,"change_date":"2024-06-28 21:39:00","inspection_id":"81993809","insp_unit_id":"201646149","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MAC","insp_unit_company":"L-193","insp_unit_license":"D821995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1724KC046548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":6250232,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","dot_number":"541596","report_state":"MI","report_number":"MOREM05342","insp_date":"2024-06-24 00:00:00","insp_start_time":"1255","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLLEGE RD","county_code_state":"MI","county_code":"065","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOFFMAN WESTERN","shipping_paper_number":"497197","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"262000","viol_total":"9","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":"1186335","transaction_code":"C","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[{"id":9710246,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869328","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":"X4396442","created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"},{"id":9710247,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869329","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"202983343","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39021TA"},{"id":9710248,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869330","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202983343","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"},{"id":9710249,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869331","seq_no":"4","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39375A"},{"id":9710250,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869332","seq_no":"5","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39375A"},{"id":9710251,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869333","seq_no":"6","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39375A1"},{"id":9710252,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869334","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3963A1"},{"id":9710253,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869335","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39311"},{"id":9710254,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_violation_id":"261869336","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"202983345","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"10-227-24","created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10070735,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_unit_id":"202983343","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"250","insp_unit_license":"BD83494","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG5SLUR8187","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10070736,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_unit_id":"202983344","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L20","insp_unit_license":"E912271","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25375C009404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10070737,"change_date":"2024-09-17 21:45:00","inspection_id":"82151718","insp_unit_id":"202983345","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L21","insp_unit_license":"E912270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19515C009405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6586236,"change_date":"2024-08-28 21:42:00","inspection_id":"82510386","dot_number":"541596","report_state":"MI","report_number":"DISCD02487","insp_date":"2024-06-19 00:00:00","insp_start_time":"1207","insp_end_time":"1223","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROBINSON TWP","county_code_state":"MI","county_code":"121","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192295","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","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":10239794,"change_date":"2024-08-28 21:42:00","inspection_id":"82510386","insp_violation_id":"261466808","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10618169,"change_date":"2024-08-28 21:42:00","inspection_id":"82510386","insp_unit_id":"202632447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"541596","insp_unit_license":"RC40588","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD14SLVP7106","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":10618170,"change_date":"2024-08-28 21:42:00","inspection_id":"82510386","insp_unit_id":"202632448","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E890586","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2847KC046551","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":5543927,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","dot_number":"541596","report_state":"MI","report_number":"SCIBA02391","insp_date":"2024-04-17 00:00:00","insp_start_time":"1120","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARR RD","county_code_state":"MI","county_code":"121","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-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1174337","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:43.000000Z","updated_at":"2025-03-17T20:12:43.000000Z","inspection_violations":[{"id":8566571,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","insp_violation_id":"259009803","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200466672","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"39311"},{"id":8566572,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","insp_violation_id":"259009804","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200466673","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8930300,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","insp_unit_id":"200466672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RB74647","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD1XRLUR8159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"},{"id":8930301,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","insp_unit_id":"200466673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"D821993","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841KC046545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"},{"id":8930302,"change_date":"2024-04-18 21:40:00","inspection_id":"81386960","insp_unit_id":"200466674","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"D821992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1720KC046546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"}]},{"id":5544041,"change_date":"2024-04-18 21:40:00","inspection_id":"81387086","dot_number":"541596","report_state":"MI","report_number":"DISCD02428","insp_date":"2024-04-17 00:00:00","insp_start_time":"0925","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EGLESTON TWP","county_code_state":"MI","county_code":"121","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"309117","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1174359","transaction_code":"A","transaction_date":"2024-04-17 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:44.000000Z","updated_at":"2025-03-17T20:12:44.000000Z","inspection_violations":[{"id":8566785,"change_date":"2024-04-18 21:40:00","inspection_id":"81387086","insp_violation_id":"259010070","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":"X4349264","created_at":"2025-03-17T21:47:31.000000Z","updated_at":"2025-03-17T21:47:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8930492,"change_date":"2024-04-18 21:40:00","inspection_id":"81387086","insp_unit_id":"200466894","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"82","insp_unit_license":"RC37390","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X4GJ132947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"},{"id":8930493,"change_date":"2024-04-18 21:40:00","inspection_id":"81387086","insp_unit_id":"200466895","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"SLVR","insp_unit_license":"E146582","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2437TC096429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"}]},{"id":5523789,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","dot_number":"541596","report_state":"MI","report_number":"MYERZ00330","insp_date":"2024-04-16 00:00:00","insp_start_time":"1308","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 WB @ 60TH AVE","county_code_state":"MI","county_code":"139","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-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"202000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1173945","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[{"id":8533889,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_violation_id":"258959125","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"3","insp_unit_id":"200422284","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":"X4304351","created_at":"2025-03-17T21:47:20.000000Z","updated_at":"2025-03-17T21:47:20.000000Z","normalized_code":"393100B"},{"id":8533890,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_violation_id":"258959126","seq_no":"2","part_no":"393","part_no_section":"23","insp_viol_unit":"3","insp_unit_id":"200422284","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:47:20.000000Z","updated_at":"2025-03-17T21:47:20.000000Z","normalized_code":"39323"},{"id":8533891,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_violation_id":"258959127","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200422282","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:20.000000Z","updated_at":"2025-03-17T21:47:20.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8897806,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_unit_id":"200422282","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"89","insp_unit_license":"RB74648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X5HJ157423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"},{"id":8897807,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_unit_id":"200422283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"-","insp_unit_license":"E890593","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253FXWS510935","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"},{"id":8897808,"change_date":"2024-04-16 21:41:00","inspection_id":"81365030","insp_unit_id":"200422284","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"-","insp_unit_license":"E890594","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F4WS510940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":4987743,"change_date":"2024-02-06 21:42:00","inspection_id":"80779880","dot_number":"541596","report_state":"MI","report_number":"LULAN02239","insp_date":"2024-02-05 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1163231","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:37.000000Z","updated_at":"2025-03-17T20:01:37.000000Z","inspection_violations":[{"id":7681729,"change_date":"2024-02-06 21:42:00","inspection_id":"80779880","insp_violation_id":"257686968","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199290022","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8027523,"change_date":"2024-02-06 21:42:00","inspection_id":"80779880","insp_unit_id":"199290022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC27056","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWFG8RPUR8185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"},{"id":8027524,"change_date":"2024-02-06 21:42:00","inspection_id":"80779880","insp_unit_id":"199290023","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E890584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2849KC046549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"},{"id":8027525,"change_date":"2024-02-06 21:42:00","inspection_id":"80779880","insp_unit_id":"199290024","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E890585","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1722KC046550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"}]},{"id":4351717,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","dot_number":"541596","report_state":"MI","report_number":"BOSSL00356","insp_date":"2023-11-02 00:00:00","insp_start_time":"1400","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 @ ALPINE AVE","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"YELLOW ROSE TRANSPORT INC","shipping_paper_number":"484757","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-03 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"262000","viol_total":"5","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":"1152153","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-03 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:08.000000Z","updated_at":"2025-03-17T19:49:08.000000Z","inspection_violations":[{"id":6730753,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_violation_id":"256211094","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197900293","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39395A"},{"id":6730754,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_violation_id":"256211095","seq_no":"2","part_no":"393","part_no_section":"203(e)","insp_viol_unit":"1","insp_unit_id":"197900293","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"393203E"},{"id":6730755,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_violation_id":"256211096","seq_no":"3","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"3","insp_unit_id":"197900295","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"39375A"},{"id":6730756,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_violation_id":"256211097","seq_no":"4","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"3","insp_unit_id":"197900295","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"393100B"},{"id":6730757,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_violation_id":"256211098","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"3","insp_unit_id":"197900295","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6998534,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_unit_id":"197900293","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"242","insp_unit_license":"RC27055","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBWD15RPUR8157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:44.000000Z","updated_at":"2025-03-17T22:58:44.000000Z"},{"id":6998535,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_unit_id":"197900294","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"-","insp_unit_license":"E890570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25335C009402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:44.000000Z","updated_at":"2025-03-17T22:58:44.000000Z"},{"id":6998536,"change_date":"2023-11-03 21:41:00","inspection_id":"80082234","insp_unit_id":"197900295","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"-","insp_unit_license":"E890571","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19585C009403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:44.000000Z","updated_at":"2025-03-17T22:58:44.000000Z"}]},{"id":4205533,"change_date":"2023-10-16 21:43:00","inspection_id":"79920784","dot_number":"541596","report_state":"MI","report_number":"PENNJ00848","insp_date":"2023-10-13 00:00:00","insp_start_time":"1400","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOLCIM","shipping_paper_number":"326825281","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149621","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:13.000000Z","updated_at":"2025-03-17T19:46:13.000000Z","inspection_violations":[{"id":6511953,"change_date":"2023-10-16 21:43:00","inspection_id":"79920784","insp_violation_id":"255857790","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197574624","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4274438","created_at":"2025-03-17T21:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6763075,"change_date":"2023-10-16 21:43:00","inspection_id":"79920784","insp_unit_id":"197574623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"204","insp_unit_license":"RB86590","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X7LJ304561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"},{"id":6763076,"change_date":"2023-10-16 21:43:00","inspection_id":"79920784","insp_unit_id":"197574624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L36","insp_unit_license":"E890578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2848HC041027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"},{"id":6763077,"change_date":"2023-10-16 21:43:00","inspection_id":"79920784","insp_unit_id":"197574625","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E890579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1920HC041028","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"}]},{"id":4162345,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","dot_number":"541596","report_state":"MI","report_number":"FRIZS02838","insp_date":"2023-10-09 00:00:00","insp_start_time":"1215","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 W\/B IONIA SCALE","county_code_state":"MI","county_code":"067","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"182000","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148967","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:26.000000Z","updated_at":"2025-03-17T19:45:26.000000Z","inspection_violations":[{"id":6441815,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744846","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"3922"},{"id":6441816,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744847","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197476092","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39383G"},{"id":6441817,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744848","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197476093","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345B2"},{"id":6441818,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744849","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197476093","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345B2"},{"id":6441819,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744850","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"3","insp_unit_id":"197476094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345B2"},{"id":6441820,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744851","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"3","insp_unit_id":"197476094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345B2"},{"id":6441821,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744852","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"3","insp_unit_id":"197476094","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345B2"},{"id":6441822,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744853","seq_no":"8","part_no":"393","part_no_section":"70(c)","insp_viol_unit":"3","insp_unit_id":"197476094","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39370C"},{"id":6441823,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_violation_id":"255744854","seq_no":"9","part_no":"393","part_no_section":"70(c)","insp_viol_unit":"3","insp_unit_id":"197476094","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39370C"}],"inspection_per_units":[{"id":6692620,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_unit_id":"197476092","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"192","insp_unit_license":"RB60746","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X8KJ240917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"},{"id":6692621,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_unit_id":"197476093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"LEAD","insp_unit_license":"E890572","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC034272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"},{"id":6692622,"change_date":"2023-10-10 21:41:00","inspection_id":"79873034","insp_unit_id":"197476094","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"PUP","insp_unit_license":"E890573","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC034273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"}]},{"id":3833918,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","dot_number":"541596","report_state":"MI","report_number":"ROBEJ00227","insp_date":"2023-08-24 00:00:00","insp_start_time":"1400","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B IONIA SCALE","county_code_state":"MI","county_code":"067","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":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"198000","viol_total":"15","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142589","transaction_code":"C","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:32.000000Z","updated_at":"2025-03-17T19:38:32.000000Z","inspection_violations":[{"id":5920676,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989029","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3922"},{"id":5920677,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989030","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196817186","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5920678,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989031","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196817186","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920679,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989032","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196817186","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39353B"},{"id":5920680,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989033","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920681,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989034","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39353B"},{"id":5920682,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989035","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920683,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989036","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920684,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989037","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920685,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989038","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920686,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989039","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5920687,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989040","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"},{"id":5920688,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989041","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"},{"id":5920689,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989042","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"},{"id":5920690,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_violation_id":"254989043","seq_no":"15","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"3","insp_unit_id":"196817187","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":6164234,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_unit_id":"196817185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"210","insp_unit_license":"RB87851","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X9MJ428249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"},{"id":6164235,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_unit_id":"196817186","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACC","insp_unit_company":"SILVER","insp_unit_license":"E912160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA253X5C009400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"},{"id":6164236,"change_date":"2023-08-30 21:45:00","inspection_id":"79507979","insp_unit_id":"196817187","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MACC","insp_unit_company":"SILVER","insp_unit_license":"E912161","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19545C009401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"}]},{"id":3802951,"change_date":"2023-08-22 21:43:00","inspection_id":"79473260","dot_number":"541596","report_state":"MI","report_number":"SCIBA02212","insp_date":"2023-07-21 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MAPLE ISLAND","county_code_state":"MI","county_code":"127","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":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1141585","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[{"id":5866063,"change_date":"2023-08-22 21:43:00","inspection_id":"79473260","insp_violation_id":"254804501","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:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6114564,"change_date":"2023-08-22 21:43:00","inspection_id":"79473260","insp_unit_id":"196665378","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB88723","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X6GJ132948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3304502,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","dot_number":"541596","report_state":"MI","report_number":"DISCD02182","insp_date":"2023-06-14 00:00:00","insp_start_time":"1208","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MUSKEGON\/VERPLANK","county_code_state":"MI","county_code":"121","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"469353","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"228000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1130557","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-16 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[{"id":5095963,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_violation_id":"253553663","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:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"39216A"},{"id":5095964,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_violation_id":"253553664","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195541505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"3922"},{"id":5095965,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_violation_id":"253553665","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195541505","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"39311"},{"id":5095966,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_violation_id":"253553666","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"195541506","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"3922"},{"id":5095967,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_violation_id":"253553667","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"195541506","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:40.000000Z","updated_at":"2025-03-17T21:30:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5312681,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_unit_id":"195541504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"210","insp_unit_license":"RB87851","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X9MJ428249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5312682,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_unit_id":"195541505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L16","insp_unit_license":"D226026","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA253X5C009400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5312683,"change_date":"2023-06-16 21:40:00","inspection_id":"78914567","insp_unit_id":"195541506","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L17","insp_unit_license":"D226031","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19545C009401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":3274353,"change_date":"2023-06-13 21:42:00","inspection_id":"78880217","dot_number":"541596","report_state":"MI","report_number":"BURGM05356","insp_date":"2023-06-09 00:00:00","insp_start_time":"1120","insp_end_time":"1136","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALLEGAN RD","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VERPLANK","shipping_paper_number":"468818","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1130074","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:45.000000Z","updated_at":"2025-03-17T19:27:45.000000Z","inspection_violations":[{"id":5048494,"change_date":"2023-06-13 21:42:00","inspection_id":"78880217","insp_violation_id":"253475869","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":"X4233434","created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5264799,"change_date":"2023-06-13 21:42:00","inspection_id":"78880217","insp_unit_id":"195473669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"190","insp_unit_license":"RB60744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X4KJ240915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5264800,"change_date":"2023-06-13 21:42:00","inspection_id":"78880217","insp_unit_id":"195473670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L190","insp_unit_license":"D281993","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841KC046545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5264801,"change_date":"2023-06-13 21:42:00","inspection_id":"78880217","insp_unit_id":"195473671","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L191","insp_unit_license":"D821992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1720KC046546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"}]},{"id":3212684,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","dot_number":"541596","report_state":"MI","report_number":"RODRR02157","insp_date":"2023-06-02 00:00:00","insp_start_time":"0850","insp_end_time":"0925","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 WB @ M-104","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"307272","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"228000","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":"1128968","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"16861 120TH AVE","insp_carrier_city":"NUNICA","insp_carrier_state":"MI","insp_carrier_zip_code":"49448","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:30.000000Z","updated_at":"2025-03-17T19:26:30.000000Z","inspection_violations":[{"id":4949616,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","insp_violation_id":"253283638","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:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"39216A"},{"id":4949617,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","insp_violation_id":"253283639","seq_no":"2","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":"X229313","created_at":"2025-03-17T21:30:02.000000Z","updated_at":"2025-03-17T21:30:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5166704,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","insp_unit_id":"195317215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"81","insp_unit_license":"RB74650","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X2GJ476986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:43.000000Z","updated_at":"2025-03-17T22:43:43.000000Z"},{"id":5166705,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","insp_unit_id":"195317216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"A658674","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02434LK019904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:43.000000Z","updated_at":"2025-03-17T22:43:43.000000Z"},{"id":5166706,"change_date":"2023-06-05 21:42:00","inspection_id":"78810635","insp_unit_id":"195317217","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D226017","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F4WS510937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:43.000000Z","updated_at":"2025-03-17T22:43:43.000000Z"}]},{"id":2828561,"change_date":"2023-04-18 21:42:00","inspection_id":"78376636","dot_number":"541596","report_state":"MI","report_number":"RODRR02090","insp_date":"2023-04-17 00:00:00","insp_start_time":"1515","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"68TH AVE NB @ I-96","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"OTTAWA COUNTY FARMS","shipping_paper_number":"975208","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"220000","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":"1122306","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[{"id":4340281,"change_date":"2023-04-18 21:42:00","inspection_id":"78376636","insp_violation_id":"252286613","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:18.000000Z","updated_at":"2025-03-17T21:27:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4553003,"change_date":"2023-04-18 21:42:00","inspection_id":"78376636","insp_unit_id":"194447004","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"69","insp_unit_license":"BD32699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDGGGG00J368258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4553004,"change_date":"2023-04-18 21:42:00","inspection_id":"78376636","insp_unit_id":"194447005","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACD","insp_unit_company":null,"insp_unit_license":"E217242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1745MC052332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4553005,"change_date":"2023-04-18 21:42:00","inspection_id":"78376636","insp_unit_id":"194447006","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MACD","insp_unit_company":null,"insp_unit_license":"E217243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1745MC052332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":2767982,"change_date":"2023-04-11 12:04:00","inspection_id":"78308172","dot_number":"541596","report_state":"MI","report_number":"WORDN04157","insp_date":"2023-04-10 00:00:00","insp_start_time":"1203","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"510R4","location_desc":"COVERT REST AREA","county_code_state":"MI","county_code":"159","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"00974631","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"232000","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":"1121238","transaction_code":"A","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4247010,"change_date":"2023-04-11 12:04:00","inspection_id":"78308172","insp_violation_id":"252130313","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4200198","created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4455153,"change_date":"2023-04-11 12:04:00","inspection_id":"78308172","insp_unit_id":"194305166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"97","insp_unit_license":"RB74647","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X7JJ196018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"},{"id":4455154,"change_date":"2023-04-11 12:04:00","inspection_id":"78308172","insp_unit_id":"194305167","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L24","insp_unit_license":"C028812","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841AC018372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"},{"id":4455155,"change_date":"2023-04-11 12:04:00","inspection_id":"78308172","insp_unit_id":"194305168","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L25","insp_unit_license":"C028811","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1749AC018373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"}]},{"id":2625036,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","dot_number":"541596","report_state":"MI","report_number":"WORDN04110","insp_date":"2023-03-21 00:00:00","insp_start_time":"1205","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"220267900","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1118705","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[{"id":4035775,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_violation_id":"251780941","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4194720","created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3922"},{"id":4035776,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_violation_id":"251780942","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193981263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3939A"},{"id":4035777,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_violation_id":"251780943","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193981263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3939A"},{"id":4035778,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_violation_id":"251780944","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"193981263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39319"},{"id":4035779,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_violation_id":"251780945","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193981263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4225564,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_unit_id":"193981263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"RB74649","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X3HJ157422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"},{"id":4225565,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_unit_id":"193981264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L32","insp_unit_license":"D243488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC036037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"},{"id":4225566,"change_date":"2023-03-21 21:41:00","inspection_id":"78145069","insp_unit_id":"193981265","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L33","insp_unit_license":"D243489","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC036038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"}]},{"id":2614158,"change_date":"2023-03-20 21:41:00","inspection_id":"78132791","dot_number":"541596","report_state":"MI","report_number":"WORDN04102","insp_date":"2023-03-17 00:00:00","insp_start_time":"1204","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"220267654","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1118277","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:52.000000Z","updated_at":"2025-03-17T19:14:52.000000Z","inspection_violations":[{"id":4020215,"change_date":"2023-03-20 21:41:00","inspection_id":"78132791","insp_violation_id":"251755891","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4194278","created_at":"2025-03-17T21:25:52.000000Z","updated_at":"2025-03-17T21:25:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4208168,"change_date":"2023-03-20 21:41:00","inspection_id":"78132791","insp_unit_id":"193957058","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"204","insp_unit_license":"RB86590","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X7LJ304561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"},{"id":4208169,"change_date":"2023-03-20 21:41:00","inspection_id":"78132791","insp_unit_id":"193957059","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L208","insp_unit_license":"E008136","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XLC051213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"},{"id":4208170,"change_date":"2023-03-20 21:41:00","inspection_id":"78132791","insp_unit_id":"193957060","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L209","insp_unit_license":"E008137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729LC051214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"}]},{"id":2357980,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","dot_number":"541596","report_state":"MI","report_number":"KILYJ01751","insp_date":"2023-02-10 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"VB CRC","shipping_paper_number":"297821","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"202000","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":"1113342","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[{"id":3631444,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","insp_violation_id":"251101130","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193368588","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39395A"},{"id":3631445,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","insp_violation_id":"251101131","seq_no":"2","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"3","insp_unit_id":"193368590","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":3794766,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","insp_unit_id":"193368588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"89","insp_unit_license":"RB74648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X5HJ157423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"},{"id":3794767,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","insp_unit_id":"193368589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"L72","insp_unit_license":"E146581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2538VC096828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"},{"id":3794768,"change_date":"2023-02-13 21:43:00","inspection_id":"77840937","insp_unit_id":"193368590","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":"L73","insp_unit_license":"A658685","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M9DS2538VC096828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"}]},{"id":1458634,"change_date":"2022-10-06 21:40:00","inspection_id":"76810762","dot_number":"541596","report_state":"MI","report_number":"RODRR01939","insp_date":"2022-10-05 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 EB @ 25 MM","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"452183","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1097500","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2296380,"change_date":"2022-10-06 21:40:00","inspection_id":"76810762","insp_violation_id":"248877665","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":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2348133,"change_date":"2022-10-06 21:40:00","inspection_id":"76810762","insp_unit_id":"191310408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X5MJ428250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2348134,"change_date":"2022-10-06 21:40:00","inspection_id":"76810762","insp_unit_id":"191310409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"A658709","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU263F12S780376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2348135,"change_date":"2022-10-06 21:40:00","inspection_id":"76810762","insp_unit_id":"191310410","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"A658698","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU195F6XS613858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":748395,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","dot_number":"541596","report_state":"MI","report_number":"BRADD00672","insp_date":"2022-06-29 00:00:00","insp_start_time":"0900","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCKFORD RA","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"182000","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":"1082076","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:53.000000Z","updated_at":"2025-03-17T18:40:53.000000Z","inspection_violations":[{"id":1177831,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","insp_violation_id":"246884355","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"189600111","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"},{"id":1177832,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","insp_violation_id":"246884356","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189600110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1203318,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","insp_unit_id":"189600109","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"190","insp_unit_license":"RB60744","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X4KJ240915","insp_unit_decal":"Y","insp_unit_decal_number":"31293129","created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1203319,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","insp_unit_id":"189600110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L190","insp_unit_license":"D821993","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2841KC046545","insp_unit_decal":"Y","insp_unit_decal_number":"31293130","created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"},{"id":1203320,"change_date":"2022-07-05 21:42:00","inspection_id":"75983552","insp_unit_id":"189600111","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L191","insp_unit_license":"D821992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1720KC046546","insp_unit_decal":"Y","insp_unit_decal_number":"31293131","created_at":"2025-03-17T22:15:34.000000Z","updated_at":"2025-03-17T22:15:34.000000Z"}]},{"id":697426,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","dot_number":"541596","report_state":"MI","report_number":"POWEL02662","insp_date":"2022-06-24 00:00:00","insp_start_time":"0830","insp_end_time":"0916","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"961583","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1081482","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094359,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","insp_violation_id":"246726890","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"},{"id":1094360,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","insp_violation_id":"246726891","seq_no":"2","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"189471325","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":1120421,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","insp_unit_id":"189471324","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"RB74649","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X3HJ157422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120422,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","insp_unit_id":"189471325","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L32","insp_unit_license":"D243488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC036037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120423,"change_date":"2022-06-27 21:40:00","inspection_id":"75923558","insp_unit_id":"189471326","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L32","insp_unit_license":"D243489","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC036038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":697457,"change_date":"2022-06-27 21:40:00","inspection_id":"75923596","dot_number":"541596","report_state":"MI","report_number":"HAYND00210","insp_date":"2022-06-23 00:00:00","insp_start_time":"1305","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"YELLOW ROSE TRANSPORT","shipping_paper_number":"326789719","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1081321","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094413,"change_date":"2022-06-27 21:40:00","inspection_id":"75923596","insp_violation_id":"246726964","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4077845","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1120474,"change_date":"2022-06-27 21:40:00","inspection_id":"75923596","insp_unit_id":"189471393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"RB74649","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X3HJ157422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120475,"change_date":"2022-06-27 21:40:00","inspection_id":"75923596","insp_unit_id":"189471394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L32","insp_unit_license":"D243488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC036037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120476,"change_date":"2022-06-27 21:40:00","inspection_id":"75923596","insp_unit_id":"189471395","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L33","insp_unit_license":"D243489","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC036038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":697267,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","dot_number":"541596","report_state":"MI","report_number":"HAYND00206","insp_date":"2022-06-22 00:00:00","insp_start_time":"1135","insp_end_time":"1258","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AGGREGATE","shipping_paper_number":"326789545","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"173300","viol_total":"12","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1081336","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094096,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726523","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4078258","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"},{"id":1094097,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726524","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189470981","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39311"},{"id":1094098,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726525","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"189470982","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39345D"},{"id":1094099,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726526","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4078258","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3929A"},{"id":1094100,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726527","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189470982","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"},{"id":1094101,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726528","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"189470982","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39353B"},{"id":1094102,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726529","seq_no":"7","part_no":"393","part_no_section":"70(c)","insp_viol_unit":"1","insp_unit_id":"189470981","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39370C"},{"id":1094103,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726530","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"},{"id":1094104,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726531","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39353B"},{"id":1094105,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726532","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"},{"id":1094106,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726533","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"},{"id":1094107,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_violation_id":"246726534","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"189470983","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1120130,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_unit_id":"189470981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RB87852","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X5MJ428250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120131,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_unit_id":"189470982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"18","insp_unit_license":"E146573","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA25335C009409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120132,"change_date":"2022-06-27 21:40:00","inspection_id":"75923377","insp_unit_id":"189470983","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UNK","insp_unit_company":"19","insp_unit_license":"E146572","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA19585C009403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":407435,"change_date":"2022-06-09 21:42:00","inspection_id":"75579091","dot_number":"541596","report_state":"MI","report_number":"BURGM04550","insp_date":"2022-05-16 00:00:00","insp_start_time":"0814","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M99","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"YELLOEW ROSE","shipping_paper_number":"959189","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.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-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"210000","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":"1075756","transaction_code":"C","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:46.000000Z","updated_at":"2025-03-17T18:34:46.000000Z","inspection_violations":[{"id":636923,"change_date":"2022-06-09 21:42:00","inspection_id":"75579091","insp_violation_id":"246331413","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:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":657785,"change_date":"2022-06-09 21:42:00","inspection_id":"75579091","insp_unit_id":"189143949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"191","insp_unit_license":"RB60745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X6KJ240916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"},{"id":657786,"change_date":"2022-06-09 21:42:00","inspection_id":"75579091","insp_unit_id":"189143950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L214","insp_unit_license":"E217246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2845MC052335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"},{"id":657787,"change_date":"2022-06-09 21:42:00","inspection_id":"75579091","insp_unit_id":"189143951","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L215","insp_unit_license":"E217247","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1742MC052336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"}]},{"id":62176,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","dot_number":"541596","report_state":"MI","report_number":"WORDN03481","insp_date":"2022-03-28 00:00:00","insp_start_time":"1256","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"220255250","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","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":"1069528","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00541596","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"YELLOW ROSE TRANSPORT INC","insp_carrier_street":"3531 BUSCH DR","insp_carrier_city":"GRANDVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"49418","insp_colonia":null,"docket_number":"269565","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[{"id":89403,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","insp_violation_id":"244834400","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4037490","created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3922"},{"id":89404,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","insp_violation_id":"244834401","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187873049","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":100994,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","insp_unit_id":"187873049","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"91","insp_unit_license":"RB74645","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZDP0X6JJ196012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100995,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","insp_unit_id":"187873050","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"L30","insp_unit_license":"D243093","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA284XGC034272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100996,"change_date":"2022-03-29 21:42:00","inspection_id":"75164399","insp_unit_id":"187873051","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"L31","insp_unit_license":"D243094","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA1729GC034273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/541596\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/541596\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/541596\/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\/541596\/inspections","per_page":100,"prev_page_url":null,"to":38,"total":38}