{"current_page":1,"data":[{"id":12490863,"change_date":"2026-07-19 21:34:00","inspection_id":"88454111","dot_number":"1617057","report_state":"MI","report_number":"LYDEC04837","insp_date":"2026-07-18 00:00:00","insp_start_time":"2203","insp_end_time":"2302","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"093","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":"U","pen_cen_match":"I","final_status_date":"2026-07-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"198400","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":"3789256","transaction_code":"A","transaction_date":"2026-07-19 00:00:00","upload_date":"2026-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2026-07-19 21:34:00","snet_input_date":"2026-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-19 21:34:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-22T09:41:19.000000Z","updated_at":"2026-07-30T09:30:09.000000Z","inspection_violations":[{"id":21744863,"change_date":"2026-07-19 21:34:00","inspection_id":"88454111","insp_violation_id":"275598532","seq_no":"1","part_no":"393","part_no_section":"48A-BLMCBAD","insp_viol_unit":"2","insp_unit_id":"214701594","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-22T10:01:24.000000Z","updated_at":"2026-07-30T09:40:28.000000Z","normalized_code":"39348ABLMCBAD"}],"inspection_per_units":[{"id":21694061,"change_date":"2026-07-19 21:34:00","inspection_id":"88454111","insp_unit_id":"214701593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BE28188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT8TN309147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-22T09:18:31.000000Z","updated_at":"2026-07-30T09:01:10.000000Z"},{"id":21694062,"change_date":"2026-07-19 21:34:00","inspection_id":"88454111","insp_unit_id":"214701594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-22T09:18:31.000000Z","updated_at":"2026-07-30T09:01:10.000000Z"}]},{"id":12248183,"change_date":"2026-06-22 21:39:00","inspection_id":"88206500","dot_number":"1617057","report_state":"MI","report_number":"BESSJ01487","insp_date":"2026-06-22 00:00:00","insp_start_time":"0810","insp_end_time":"0855","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"141400","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":"3593283","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:48.000000Z","updated_at":"2026-07-03T09:30:41.000000Z","inspection_violations":[{"id":21318703,"change_date":"2026-06-22 21:39:00","inspection_id":"88206500","insp_violation_id":"275050921","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:08.000000Z","updated_at":"2026-07-03T09:42:46.000000Z","normalized_code":"3922SLLEWG1"}],"inspection_per_units":[{"id":21269883,"change_date":"2026-06-22 21:39:00","inspection_id":"88206500","insp_unit_id":"214220338","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRENC","insp_unit_company":"N\/A","insp_unit_license":"F269438","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLPBDU82TB000671","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:10.000000Z","updated_at":"2026-07-05T09:01:38.000000Z"},{"id":21269884,"change_date":"2026-06-22 21:39:00","inspection_id":"88206500","insp_unit_id":"214220339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2612","insp_unit_license":"BE28187","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPAAPT2TN338066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:10.000000Z","updated_at":"2026-07-05T09:01:38.000000Z"}]},{"id":11759718,"change_date":"2026-04-27 21:39:00","inspection_id":"87690052","dot_number":"1617057","report_state":"MI","report_number":"LYDEC04663","insp_date":"2026-04-25 00:00:00","insp_start_time":"2311","insp_end_time":"2329","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"C836605","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"201220","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":"1267808","transaction_code":"A","transaction_date":"2026-04-25 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-30T09:39:38.000000Z","updated_at":"2026-05-08T09:31:01.000000Z","inspection_violations":[{"id":20445634,"change_date":"2026-04-27 21:39:00","inspection_id":"87690052","insp_violation_id":"273879628","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4679913","created_at":"2026-04-30T09:59:01.000000Z","updated_at":"2026-05-08T09:42:13.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":20459694,"change_date":"2026-04-27 21:39:00","inspection_id":"87690052","insp_unit_id":"213247672","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1869","insp_unit_license":"E994549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1B9SP4985RE601576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:37.000000Z","updated_at":"2026-05-08T09:03:43.000000Z"},{"id":20459693,"change_date":"2026-04-27 21:39:00","inspection_id":"87690052","insp_unit_id":"213247671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2418","insp_unit_license":"BD36911","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X3RD610468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:37.000000Z","updated_at":"2026-05-08T09:03:43.000000Z"}]},{"id":10524508,"change_date":"2025-12-29 21:37:00","inspection_id":"86660366","dot_number":"1617057","report_state":"OH","report_number":"1144000084","insp_date":"2025-12-27 00:00:00","insp_start_time":"1507","insp_end_time":"1542","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TUBERGEN DAIRY FARM","shipping_paper_number":"0055609320","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"197320","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":"2705334","transaction_code":"A","transaction_date":"2025-12-28 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-12-29 21:37:00","snet_input_date":"2025-12-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-29 21:37:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-01T10:34:31.000000Z","updated_at":"2026-01-09T10:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17626995,"change_date":"2025-12-29 21:37:00","inspection_id":"86660366","insp_unit_id":"210815483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2420","insp_unit_license":"BD71467","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0RD668729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:13.000000Z","updated_at":"2026-01-09T10:00:19.000000Z"},{"id":17626996,"change_date":"2025-12-29 21:37:00","inspection_id":"86660366","insp_unit_id":"210815484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"0812","insp_unit_license":"F269426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T94T4980LA311007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:13.000000Z","updated_at":"2026-01-09T10:00:19.000000Z"}]},{"id":10019591,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","dot_number":"1617057","report_state":"MI","report_number":"RAMSB02239","insp_date":"2025-10-22 00:00:00","insp_start_time":"0530","insp_end_time":"0624","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 WB AT M59","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247491","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:55.000000Z","updated_at":"2025-10-27T10:01:08.000000Z","inspection_violations":[{"id":16571061,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_violation_id":"269480289","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":"X4607067","created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"3922SLLS2"},{"id":16571062,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_violation_id":"269480290","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4607067","created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"39141APC"},{"id":16571063,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_violation_id":"269480291","seq_no":"3","part_no":"392","part_no_section":"2-SLLDL","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-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"3922SLLDL"},{"id":16571064,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_violation_id":"269480292","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"209623382","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"3922SLLIRP"},{"id":16571065,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_violation_id":"269480293","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209623383","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4607067","created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":16644571,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_unit_id":"209623382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2424","insp_unit_license":"RC45787","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD49X0RD896605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:23.000000Z"},{"id":16644572,"change_date":"2025-10-23 21:39:00","inspection_id":"86130774","insp_unit_id":"209623383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1060","insp_unit_license":"5026306","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5WSABB238KN090483","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:23.000000Z"}]},{"id":10019580,"change_date":"2025-10-23 21:39:00","inspection_id":"86130762","dot_number":"1617057","report_state":"MI","report_number":"RAMSB02238","insp_date":"2025-10-20 00:00:00","insp_start_time":"1210","insp_end_time":"1308","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":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TUBERGEN DAIRY FARM","shipping_paper_number":"0055609237","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"1247517","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:55.000000Z","updated_at":"2025-10-27T10:01:08.000000Z","inspection_violations":[{"id":16571041,"change_date":"2025-10-23 21:39:00","inspection_id":"86130762","insp_violation_id":"269480265","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4601270","created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"3922SLLEWG2"},{"id":16571042,"change_date":"2025-10-23 21:39:00","inspection_id":"86130762","insp_violation_id":"269480266","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209623362","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-26T10:18:00.000000Z","updated_at":"2025-10-27T10:16:50.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16644553,"change_date":"2025-10-23 21:39:00","inspection_id":"86130762","insp_unit_id":"209623361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2421","insp_unit_license":"RC38609","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPAAPRXRN739474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:23.000000Z"},{"id":16644554,"change_date":"2025-10-23 21:39:00","inspection_id":"86130762","insp_unit_id":"209623362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRMC","insp_unit_company":"1036","insp_unit_license":"D487286","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4982HB000002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:11.000000Z","updated_at":"2025-10-27T09:46:23.000000Z"}]},{"id":9802590,"change_date":"2025-09-29 21:38:00","inspection_id":"85902097","dot_number":"1617057","report_state":"OH","report_number":"1200000127","insp_date":"2025-09-27 00:00:00","insp_start_time":"1019","insp_end_time":"1101","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MMPA","shipping_paper_number":"C821264","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":"2025-09-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"201200","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":"2340093","transaction_code":"A","transaction_date":"2025-09-28 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-09-29 21:38:00","snet_input_date":"2025-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-29 21:38:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:14.000000Z","updated_at":"2025-10-03T10:00:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16245827,"change_date":"2025-09-29 21:38:00","inspection_id":"85902097","insp_unit_id":"209191886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2418","insp_unit_license":"BD36911","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X3RD610468","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:15.000000Z","updated_at":"2025-10-03T09:45:20.000000Z"},{"id":16245828,"change_date":"2025-09-29 21:38:00","inspection_id":"85902097","insp_unit_id":"209191887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1869","insp_unit_license":"E994549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1B9SP4985RE601576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:15.000000Z","updated_at":"2025-10-03T09:45:20.000000Z"}]},{"id":9751328,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","dot_number":"1617057","report_state":"OH","report_number":"0519000026","insp_date":"2025-09-22 00:00:00","insp_start_time":"0632","insp_end_time":"0809","registration_date":null,"region":"ED","ci_status_code":"C","location":"04","location_desc":"HUBBARD OH","county_code_state":"OH","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"3","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2313495","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-09-23 21:42:00","snet_input_date":"2025-09-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-23 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:41.000000Z","updated_at":"2025-09-26T10:00:22.000000Z","inspection_violations":[{"id":16024433,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859575","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"209089893","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"3939ALSLI"},{"id":16024434,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859576","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"3958A1HOSP"},{"id":16024435,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859577","seq_no":"3","part_no":"383","part_no_section":"51A-SOUT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"38351ASOUT"},{"id":16024436,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859578","seq_no":"4","part_no":"391","part_no_section":"49J-MDP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"39149JMDP"},{"id":16024437,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859579","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209089893","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"3922SLLIFTA"},{"id":16024438,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859580","seq_no":"6","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209089894","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"39355EB"},{"id":16024439,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_violation_id":"268859581","seq_no":"7","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"209089894","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:41.000000Z","updated_at":"2025-09-27T10:15:44.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":16152989,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_unit_id":"209089893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2424","insp_unit_license":"RC45787","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD49X0RD896605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:04.000000Z","updated_at":"2025-09-27T09:45:25.000000Z"},{"id":16152990,"change_date":"2025-09-23 21:42:00","inspection_id":"85848557","insp_unit_id":"209089894","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER STA","insp_unit_company":"1890","insp_unit_license":"H8S161","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA4329CN042965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:04.000000Z","updated_at":"2025-09-27T09:45:25.000000Z"}]},{"id":9600471,"change_date":"2025-09-05 21:39:00","inspection_id":"85690201","dot_number":"1617057","report_state":"OH","report_number":"1200000121","insp_date":"2025-09-03 00:00:00","insp_start_time":"1119","insp_end_time":"1143","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TUBERGEN DAIRY FARM","shipping_paper_number":"55466144","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":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2224468","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:42.000000Z","updated_at":"2025-09-10T10:45:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15852914,"change_date":"2025-09-05 21:39:00","inspection_id":"85690201","insp_unit_id":"208763554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RC43402","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X7SD700906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:25.000000Z","updated_at":"2025-09-10T09:46:25.000000Z"},{"id":15852915,"change_date":"2025-09-05 21:39:00","inspection_id":"85690201","insp_unit_id":"208763555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:25.000000Z","updated_at":"2025-09-10T09:46:25.000000Z"}]},{"id":9499716,"change_date":"2025-08-25 21:40:00","inspection_id":"85584451","dot_number":"1617057","report_state":"MI","report_number":"LYDEC04363","insp_date":"2025-08-24 00:00:00","insp_start_time":"1958","insp_end_time":"2045","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"201220","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":"1237767","transaction_code":"A","transaction_date":"2025-08-24 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:44.000000Z","updated_at":"2025-08-29T10:42:44.000000Z","inspection_violations":[{"id":15491691,"change_date":"2025-08-25 21:40:00","inspection_id":"85584451","insp_violation_id":"268233664","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208569712","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:52.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15673769,"change_date":"2025-08-25 21:40:00","inspection_id":"85584451","insp_unit_id":"208569711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2418","insp_unit_license":"BB36911","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X3RD610468","insp_unit_decal":"Y","insp_unit_decal_number":"35457065","created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:03.000000Z"},{"id":15673770,"change_date":"2025-08-25 21:40:00","inspection_id":"85584451","insp_unit_id":"208569712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1869","insp_unit_license":"E994549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1B9SP4985RE601576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:03.000000Z"}]},{"id":9428520,"change_date":"2025-08-16 21:33:00","inspection_id":"85509445","dot_number":"1617057","report_state":"OH","report_number":"1200000113","insp_date":"2025-08-14 00:00:00","insp_start_time":"1254","insp_end_time":"1335","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MMPA","shipping_paper_number":"C832447","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":"2025-08-16 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"2137337","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-08-16 21:33:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-16 21:33:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:44.000000Z","updated_at":"2025-08-20T10:44:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15542854,"change_date":"2025-08-16 21:33:00","inspection_id":"85509445","insp_unit_id":"208429095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"2422","insp_unit_license":"RC38610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSLGAPRXRN749449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-19T09:46:13.000000Z","updated_at":"2025-08-20T09:45:09.000000Z"},{"id":15542855,"change_date":"2025-08-16 21:33:00","inspection_id":"85509445","insp_unit_id":"208429096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER STA","insp_unit_company":"1101","insp_unit_license":"E972050","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4523CN043168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-19T09:46:13.000000Z","updated_at":"2025-08-20T09:45:09.000000Z"}]},{"id":9288191,"change_date":"2025-07-30 21:40:00","inspection_id":"85362031","dot_number":"1617057","report_state":"MI","report_number":"LULAN02724","insp_date":"2025-07-29 00:00:00","insp_start_time":"2000","insp_end_time":"2030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B US-23 @ WILLIS","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1233278","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:14.000000Z","updated_at":"2025-08-04T10:01:14.000000Z","inspection_violations":[{"id":15058289,"change_date":"2025-07-30 21:40:00","inspection_id":"85362031","insp_violation_id":"267745963","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":"X4569706","created_at":"2025-08-02T10:43:41.000000Z","updated_at":"2025-08-03T10:44:11.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15292144,"change_date":"2025-07-30 21:40:00","inspection_id":"85362031","insp_unit_id":"208159093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2014","insp_unit_license":"RB91379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X1LD732109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:27.000000Z","updated_at":"2025-08-03T09:45:56.000000Z"},{"id":15292145,"change_date":"2025-07-30 21:40:00","inspection_id":"85362031","insp_unit_id":"208159094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"19-1041","insp_unit_license":"5026303","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5WSABB232KN090480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:27.000000Z","updated_at":"2025-08-03T09:45:56.000000Z"}]},{"id":9257199,"change_date":"2025-07-27 21:33:00","inspection_id":"85329307","dot_number":"1617057","report_state":"OH","report_number":"1200000106","insp_date":"2025-07-25 00:00:00","insp_start_time":"1106","insp_end_time":"1131","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MMPA","shipping_paper_number":"C832426","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":"2025-07-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"167000","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":"2046729","transaction_code":"A","transaction_date":"2025-07-26 00:00:00","upload_date":"2025-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-07-27 21:33:00","snet_input_date":"2025-07-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-27 21:33:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:29.000000Z","updated_at":"2025-07-31T10:00:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15234946,"change_date":"2025-07-27 21:33:00","inspection_id":"85329307","insp_unit_id":"208097455","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"2422","insp_unit_license":"RC38610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSLGAPRXRN749449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-30T09:45:31.000000Z","updated_at":"2025-08-01T09:45:08.000000Z"},{"id":15234947,"change_date":"2025-07-27 21:33:00","inspection_id":"85329307","insp_unit_id":"208097456","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER STA","insp_unit_company":null,"insp_unit_license":"E972050","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4523CN043168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-30T09:45:31.000000Z","updated_at":"2025-08-01T09:45:08.000000Z"}]},{"id":8725362,"change_date":"2025-05-23 21:39:00","inspection_id":"84767703","dot_number":"1617057","report_state":"MI","report_number":"MOREM05902","insp_date":"2025-05-22 00:00:00","insp_start_time":"1024","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MT HOPE HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MMPA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222611","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[{"id":13920435,"change_date":"2025-05-23 21:39:00","inspection_id":"84767703","insp_violation_id":"266447625","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:03.000000Z","updated_at":"2025-05-27T10:26:10.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14264124,"change_date":"2025-05-23 21:39:00","inspection_id":"84767703","insp_unit_id":"207042913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1808","insp_unit_license":"BD36832","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD49X8JJ198789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"},{"id":14264125,"change_date":"2025-05-23 21:39:00","inspection_id":"84767703","insp_unit_id":"207042914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BURC","insp_unit_company":null,"insp_unit_license":"E574130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4537EN045405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"}]},{"id":8194916,"change_date":"2025-03-24 21:40:00","inspection_id":"84208959","dot_number":"1617057","report_state":"MI","report_number":"PATTM04969","insp_date":"2025-03-24 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-24 21:40: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":"1214595","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-03-24 21:40:00","snet_input_date":"2025-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-24 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:32.000000Z","updated_at":"2025-03-28T10:14:14.000000Z","inspection_violations":[{"id":12849904,"change_date":"2025-03-24 21:40:00","inspection_id":"84208959","insp_violation_id":"265221339","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-27T10:29:37.000000Z","updated_at":"2025-03-28T10:40:45.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":13248754,"change_date":"2025-03-24 21:40:00","inspection_id":"84208959","insp_unit_id":"205959679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC45845","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X8SD679255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T09:57:37.000000Z","updated_at":"2025-03-28T10:04:50.000000Z"}]},{"id":7974967,"change_date":"2025-02-27 21:40:00","inspection_id":"83977434","dot_number":"1617057","report_state":"OH","report_number":"3239000271","insp_date":"2025-02-25 00:00:00","insp_start_time":"0818","insp_end_time":"0838","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BOWLING GREEN OH","county_code_state":"OH","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TUBERGEN DAIRY FARM","shipping_paper_number":"55465713","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":"2025-02-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"182000","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":"1405754","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-02-27 21:40:00","snet_input_date":"2025-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-27 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:40.000000Z","updated_at":"2025-03-17T21:03:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12874453,"change_date":"2025-02-27 21:40:00","inspection_id":"83977434","insp_unit_id":"205527146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2115","insp_unit_license":"BD36818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1MD730875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"},{"id":12874454,"change_date":"2025-02-27 21:40:00","inspection_id":"83977434","insp_unit_id":"205527147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"}]},{"id":7915149,"change_date":"2025-02-20 21:40:00","inspection_id":"83914750","dot_number":"1617057","report_state":"OH","report_number":"1200000035","insp_date":"2025-02-17 00:00:00","insp_start_time":"1011","insp_end_time":"1043","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NORWALK OH","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TUBERGEN DAIRY FARM","shipping_paper_number":"TUB1","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":"U","pen_cen_match":"I","final_status_date":"2025-02-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1379472","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2025-02-20 21:40:00","snet_input_date":"2025-02-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[{"id":12366354,"change_date":"2025-02-20 21:40:00","inspection_id":"83914750","insp_violation_id":"264604931","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:24.000000Z","updated_at":"2025-03-17T22:06:24.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":12776587,"change_date":"2025-02-20 21:40:00","inspection_id":"83914750","insp_unit_id":"205411541","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2115","insp_unit_license":"BD36818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1MD730875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:09.000000Z","updated_at":"2025-03-17T23:56:09.000000Z"},{"id":12776588,"change_date":"2025-02-20 21:40:00","inspection_id":"83914750","insp_unit_id":"205411542","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:09.000000Z","updated_at":"2025-03-17T23:56:09.000000Z"}]},{"id":6808943,"change_date":"2024-09-24 21:42:00","inspection_id":"82747854","dot_number":"1617057","report_state":"MI","report_number":"WASCC00700","insp_date":"2024-09-21 00:00:00","insp_start_time":"1110","insp_end_time":"1138","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OFF RAMP","county_code_state":"MI","county_code":"057","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1195861","transaction_code":"A","transaction_date":"2024-09-21 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-09-24 21:42:00","snet_input_date":"2024-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-24 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:12.000000Z","updated_at":"2025-03-17T20:38:12.000000Z","inspection_violations":[{"id":10601970,"change_date":"2024-09-24 21:42:00","inspection_id":"82747854","insp_violation_id":"262009647","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203109294","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"39311"},{"id":10601971,"change_date":"2024-09-24 21:42:00","inspection_id":"82747854","insp_violation_id":"262009648","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203109294","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"39617C"},{"id":10601972,"change_date":"2024-09-24 21:42:00","inspection_id":"82747854","insp_violation_id":"262009649","seq_no":"3","part_no":"393","part_no_section":"70(b)(1)(ii)","insp_viol_unit":"1","insp_unit_id":"203109294","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:22.000000Z","updated_at":"2025-03-17T21:57:22.000000Z","normalized_code":"39370B1II"}],"inspection_per_units":[{"id":10980080,"change_date":"2024-09-24 21:42:00","inspection_id":"82747854","insp_unit_id":"203109294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB73088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X5KD276078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:45.000000Z","updated_at":"2025-03-17T23:36:45.000000Z"}]},{"id":6701751,"change_date":"2024-09-11 21:41:00","inspection_id":"82633500","dot_number":"1617057","report_state":"OH","report_number":"1721004299","insp_date":"2024-09-11 00:00:00","insp_start_time":"1130","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"00571","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"TUUBERGEN DAIRY FARM","shipping_paper_number":"55465551","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-09-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"196200","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":"1755419","transaction_code":"A","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-09-11 21:41:00","snet_input_date":"2024-09-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-09-11 21:41:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:03.000000Z","updated_at":"2025-03-17T20:36:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10806176,"change_date":"2024-09-11 21:41:00","inspection_id":"82633500","insp_unit_id":"202873342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2115","insp_unit_license":"BD36818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X1MD730875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:53.000000Z","updated_at":"2025-03-17T23:34:53.000000Z"},{"id":10806177,"change_date":"2024-09-11 21:41:00","inspection_id":"82633500","insp_unit_id":"202873343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E851299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980GB000367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:53.000000Z","updated_at":"2025-03-17T23:34:53.000000Z"}]},{"id":6604917,"change_date":"2024-09-03 21:41:00","inspection_id":"82530482","dot_number":"1617057","report_state":"IN","report_number":"5476002179","insp_date":"2024-08-29 00:00:00","insp_start_time":"1147","insp_end_time":"1307","registration_date":null,"region":"ED","ci_status_code":"C","location":"4365N","location_desc":"SEYMOUR IN","county_code_state":"IN","county_code":"071","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"797713","transaction_code":"C","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-08-30 21:39:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-30 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:02.000000Z","updated_at":"2025-03-17T20:34:02.000000Z","inspection_violations":[{"id":10271315,"change_date":"2024-09-03 21:41:00","inspection_id":"82530482","insp_violation_id":"261557788","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202713550","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:43.000000Z","updated_at":"2025-03-17T21:55:43.000000Z","normalized_code":"39617C"},{"id":10271316,"change_date":"2024-09-03 21:41:00","inspection_id":"82530482","insp_violation_id":"261557789","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:43.000000Z","updated_at":"2025-03-17T21:55:43.000000Z","normalized_code":"39141A"},{"id":10271317,"change_date":"2024-09-03 21:41:00","inspection_id":"82530482","insp_violation_id":"261557790","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:43.000000Z","updated_at":"2025-03-17T21:55:43.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":10648754,"change_date":"2024-09-03 21:41:00","inspection_id":"82530482","insp_unit_id":"202713550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:16.000000Z","updated_at":"2025-03-17T23:33:16.000000Z"}]},{"id":6378704,"change_date":"2024-08-02 21:40:00","inspection_id":"82289029","dot_number":"1617057","report_state":"OH","report_number":"3220008399","insp_date":"2024-08-01 00:00:00","insp_start_time":"1638","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":"13930","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1744557","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-08-02 21:40:00","snet_input_date":"2024-08-02 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-02 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:08.000000Z","updated_at":"2025-03-17T20:29:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10279287,"change_date":"2024-08-02 21:40:00","inspection_id":"82289029","insp_unit_id":"202211661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2422","insp_unit_license":"RC38610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSLGAPRXRN749449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:28.000000Z","updated_at":"2025-03-17T23:29:28.000000Z"},{"id":10279288,"change_date":"2024-08-02 21:40:00","inspection_id":"82289029","insp_unit_id":"202211662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E972064","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4989JB000150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:28.000000Z","updated_at":"2025-03-17T23:29:28.000000Z"}]},{"id":6357545,"change_date":"2024-09-17 21:45:00","inspection_id":"82266410","dot_number":"1617057","report_state":"MI","report_number":"DELMT01373","insp_date":"2024-07-30 00:00:00","insp_start_time":"1850","insp_end_time":"1950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I94 NEAR HAWKINS RD.","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","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":"189000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188096","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":"01617057","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","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":9870390,"change_date":"2024-09-17 21:45:00","inspection_id":"82266410","insp_violation_id":"261861452","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3958A1"},{"id":9870391,"change_date":"2024-09-17 21:45:00","inspection_id":"82266410","insp_violation_id":"261861453","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202977343","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10245241,"change_date":"2024-09-17 21:45:00","inspection_id":"82266410","insp_unit_id":"202977342","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD71467","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X0RD668729","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":10245242,"change_date":"2024-09-17 21:45:00","inspection_id":"82266410","insp_unit_id":"202977343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MGM","insp_unit_company":null,"insp_unit_license":"D497285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ASUS16292S028799","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":6208204,"change_date":"2024-07-12 21:39:00","inspection_id":"82106443","dot_number":"1617057","report_state":"OH","report_number":"1200004116","insp_date":"2024-07-12 00:00:00","insp_start_time":"1134","insp_end_time":"1152","registration_date":null,"region":"ET","ci_status_code":"C","location":"07739","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MMPA\/SUPERIOR DAIRY","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1739871","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-07-12 21:39:00","snet_input_date":"2024-07-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:46.000000Z","updated_at":"2025-03-17T20:25:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10001496,"change_date":"2024-07-12 21:39:00","inspection_id":"82106443","insp_unit_id":"201863763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC38610","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSLGAPRXRN749449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:39.000000Z","updated_at":"2025-03-17T23:26:39.000000Z"},{"id":10001497,"change_date":"2024-07-12 21:39:00","inspection_id":"82106443","insp_unit_id":"201863764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EZLD","insp_unit_company":null,"insp_unit_license":"C487286","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1L8TAAKD83A077194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:39.000000Z","updated_at":"2025-03-17T23:26:39.000000Z"}]},{"id":5755682,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","dot_number":"1617057","report_state":"MI","report_number":"RUSSC01625","insp_date":"2024-05-14 00:00:00","insp_start_time":"1200","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S.A.C.","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-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1178575","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:43.000000Z","updated_at":"2025-03-17T20:16:43.000000Z","inspection_violations":[{"id":8908025,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","insp_violation_id":"259518991","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:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8908026,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","insp_violation_id":"259518992","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200906602","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39345D"},{"id":8908027,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","insp_violation_id":"259518993","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"200906603","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":9270494,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","insp_unit_id":"200906602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"},{"id":9270495,"change_date":"2024-05-15 21:43:00","inspection_id":"81617274","insp_unit_id":"200906603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1121","insp_unit_license":"DB23608","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSABB230KN090767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":6142636,"change_date":"2024-07-03 21:40:00","inspection_id":"82036046","dot_number":"1617057","report_state":"IL","report_number":"4290030092","insp_date":"2024-05-05 00:00:00","insp_start_time":"0800","insp_end_time":"0824","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-294 S\/B MP 24.25","county_code_state":"IL","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FOREMOST MILK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2336448","transaction_code":"A","transaction_date":"2024-05-05 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-07-03 21:40:00","snet_input_date":"2024-05-05 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[{"id":9535372,"change_date":"2024-07-03 21:40:00","inspection_id":"82036046","insp_violation_id":"260462270","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201727288","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"39347E"},{"id":9535373,"change_date":"2024-07-03 21:40:00","inspection_id":"82036046","insp_violation_id":"260462271","seq_no":"2","part_no":"393","part_no_section":"60(b)","insp_viol_unit":"1","insp_unit_id":"201727287","insp_violation_category_id":"26","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:07.000000Z","updated_at":"2025-03-17T21:52:07.000000Z","normalized_code":"39360B"}],"inspection_per_units":[{"id":9894443,"change_date":"2024-07-03 21:40:00","inspection_id":"82036046","insp_unit_id":"201727287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2013","insp_unit_license":"RB68700","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X8LD691283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:31.000000Z","updated_at":"2025-03-17T23:25:31.000000Z"},{"id":9894444,"change_date":"2024-07-03 21:40:00","inspection_id":"82036046","insp_unit_id":"201727288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"U1835","insp_unit_license":"E9E404","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA42214N036824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:31.000000Z","updated_at":"2025-03-17T23:25:31.000000Z"}]},{"id":5472654,"change_date":"2024-04-09 21:42:00","inspection_id":"81309107","dot_number":"1617057","report_state":"OH","report_number":"1200004027","insp_date":"2024-04-06 00:00:00","insp_start_time":"0955","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"07720","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"TUBERGEN DAIRY","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"189000","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":"1717296","transaction_code":"A","transaction_date":"2024-04-06 00:00:00","upload_date":"2024-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-04-09 21:42:00","snet_input_date":"2024-04-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-09 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:11.000000Z","updated_at":"2025-03-17T20:11:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8815355,"change_date":"2024-04-09 21:42:00","inspection_id":"81309107","insp_unit_id":"200314987","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC22725","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X0DJ340949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:01.000000Z","updated_at":"2025-03-17T23:15:01.000000Z"},{"id":8815356,"change_date":"2024-04-09 21:42:00","inspection_id":"81309107","insp_unit_id":"200314988","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:01.000000Z","updated_at":"2025-03-17T23:15:01.000000Z"}]},{"id":5331251,"change_date":"2024-03-20 21:43:00","inspection_id":"81154769","dot_number":"1617057","report_state":"MI","report_number":"LYDEC03616","insp_date":"2024-03-19 00:00:00","insp_start_time":"1830","insp_end_time":"1853","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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"196200","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":"1169695","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:17.000000Z","updated_at":"2025-03-17T20:08:17.000000Z","inspection_violations":[{"id":8224917,"change_date":"2024-03-20 21:43:00","inspection_id":"81154769","insp_violation_id":"258493585","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"200009390","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8585598,"change_date":"2024-03-20 21:43:00","inspection_id":"81154769","insp_unit_id":"200009390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1309","insp_unit_license":"BC27725","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X0DJ340949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"},{"id":8585599,"change_date":"2024-03-20 21:43:00","inspection_id":"81154769","insp_unit_id":"200009391","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:53.000000Z","updated_at":"2025-03-17T23:12:53.000000Z"}]},{"id":5089624,"change_date":"2024-02-20 21:42:00","inspection_id":"80891365","dot_number":"1617057","report_state":"MI","report_number":"POWEL03509","insp_date":"2024-02-16 00:00:00","insp_start_time":"1045","insp_end_time":"1110","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":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1165584","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":7845582,"change_date":"2024-02-20 21:42:00","inspection_id":"80891365","insp_violation_id":"257925580","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"199502548","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8193890,"change_date":"2024-02-20 21:42:00","inspection_id":"80891365","insp_unit_id":"199502548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193891,"change_date":"2024-02-20 21:42:00","inspection_id":"80891365","insp_unit_id":"199502549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":null,"insp_unit_license":"56947T","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA43275N037573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4561344,"change_date":"2023-12-05 21:43:00","inspection_id":"80313514","dot_number":"1617057","report_state":"OH","report_number":"0700003929","insp_date":"2023-12-05 00:00:00","insp_start_time":"1113","insp_end_time":"1136","registration_date":null,"region":"ET","ci_status_code":"C","location":"077224","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MMPA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"196200","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":"1692585","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2023-12-05 21:43:00","snet_input_date":"2023-12-05 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:21.000000Z","updated_at":"2025-03-17T19:53:21.000000Z","inspection_violations":[{"id":7054146,"change_date":"2023-12-05 21:43:00","inspection_id":"80313514","insp_violation_id":"256719289","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":7336132,"change_date":"2023-12-05 21:43:00","inspection_id":"80313514","insp_unit_id":"198356951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1309","insp_unit_license":"BC22725","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X0DJ340949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"},{"id":7336133,"change_date":"2023-12-05 21:43:00","inspection_id":"80313514","insp_unit_id":"198356952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D487285","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLFL4980HB000001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4244355,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","dot_number":"1617057","report_state":"NY","report_number":"SPD0215654","insp_date":"2023-10-16 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","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-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2880803","transaction_code":"A","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2023-10-20 21:40:00","snet_input_date":"2023-10-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-20 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS FARM LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:02.000000Z","updated_at":"2025-03-17T19:47:02.000000Z","inspection_violations":[{"id":6572288,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_violation_id":"255954479","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197659509","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"3922"},{"id":6572289,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_violation_id":"255954480","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"3958F1"},{"id":6572290,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_violation_id":"255954481","seq_no":"3","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"39522G"},{"id":6572291,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_violation_id":"255954482","seq_no":"4","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":6825439,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_unit_id":"197659509","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2014","insp_unit_license":"RB91379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X1LD732109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:13.000000Z","updated_at":"2025-03-17T22:57:13.000000Z"},{"id":6825440,"change_date":"2023-10-20 21:40:00","inspection_id":"79963361","insp_unit_id":"197659510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1760","insp_unit_license":"56447T","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA43225N037450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:13.000000Z","updated_at":"2025-03-17T22:57:13.000000Z"}]},{"id":3845397,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","dot_number":"1617057","report_state":"MI","report_number":"BURGM05534","insp_date":"2023-08-25 00:00:00","insp_start_time":"1145","insp_end_time":"1229","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PACKARD HWY","county_code_state":"MI","county_code":"045","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1142729","transaction_code":"C","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[{"id":5939224,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","insp_violation_id":"254982329","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"3922"},{"id":5939225,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","insp_violation_id":"254982330","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196812232","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"3939A"},{"id":5939226,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","insp_violation_id":"254982331","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196812232","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6182577,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","insp_unit_id":"196812232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2014","insp_unit_license":"RB91379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X1LD732109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"},{"id":6182578,"change_date":"2023-08-30 21:44:00","inspection_id":"79520840","insp_unit_id":"196812233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1123","insp_unit_license":"D823607","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSABB234KN090769","insp_unit_decal":"Y","insp_unit_decal_number":"33029341","created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":2909201,"change_date":"2023-04-27 21:42:00","inspection_id":"78468137","dot_number":"1617057","report_state":"IN","report_number":"9761000958","insp_date":"2023-04-24 00:00:00","insp_start_time":"1114","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"2269S","location_desc":"#22  I-69  SB  HUNTINGTON","county_code_state":"IN","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"DFA","shipping_paper_number":"T-172455","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2186845","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":"M","census_search_date":"2023-04-27 21:42:00","snet_input_date":"2023-04-25 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-04-27 21:42:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[{"id":4462988,"change_date":"2023-04-27 21:42:00","inspection_id":"78468137","insp_violation_id":"252481101","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":"178619285","created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"39216A"},{"id":4462989,"change_date":"2023-04-27 21:42:00","inspection_id":"78468137","insp_violation_id":"252481102","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194624303","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4680236,"change_date":"2023-04-27 21:42:00","inspection_id":"78468137","insp_unit_id":"194624302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4680237,"change_date":"2023-04-27 21:42:00","inspection_id":"78468137","insp_unit_id":"194624303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"0092","insp_unit_license":"87901T","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA4328YN033276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"}]},{"id":2012265,"change_date":"2022-12-26 21:31:00","inspection_id":"77446023","dot_number":"1617057","report_state":"MI","report_number":"LYDEC03067","insp_date":"2022-12-22 00:00:00","insp_start_time":"2141","insp_end_time":"2159","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DRB","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-12-26 21:31: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":"1106816","transaction_code":"A","transaction_date":"2022-12-22 00:00:00","upload_date":"2022-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-12-26 21:31:00","snet_input_date":"2022-12-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-26 21:31:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3123140,"change_date":"2022-12-26 21:31:00","inspection_id":"77446023","insp_violation_id":"250259840","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:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3237496,"change_date":"2022-12-26 21:31:00","inspection_id":"77446023","insp_unit_id":"192574296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB73088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X5KD276078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"},{"id":3237497,"change_date":"2022-12-26 21:31:00","inspection_id":"77446023","insp_unit_id":"192574297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":null,"insp_unit_license":"E568008","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4324HN048759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1869515,"change_date":"2022-12-05 21:40:00","inspection_id":"77282779","dot_number":"1617057","report_state":"MI","report_number":"PRIED02064","insp_date":"2022-12-02 00:00:00","insp_start_time":"1208","insp_end_time":"1251","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MISSION @ VERNON","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1104388","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:06.000000Z","updated_at":"2025-03-17T19:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3008745,"change_date":"2022-12-05 21:40:00","inspection_id":"77282779","insp_unit_id":"192255730","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC34110","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1AN07Y0DM014853","insp_unit_decal":"Y","insp_unit_decal_number":"32004793","created_at":"2025-03-17T22:27:35.000000Z","updated_at":"2025-03-17T22:27:35.000000Z"}]},{"id":1869516,"change_date":"2022-12-05 21:40:00","inspection_id":"77282780","dot_number":"1617057","report_state":"MI","report_number":"PRIED02065","insp_date":"2022-12-02 00:00:00","insp_start_time":"1249","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MISSION @ ERWIN","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1104369","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"MCGUIRE BROS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:06.000000Z","updated_at":"2025-03-17T19:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3008746,"change_date":"2022-12-05 21:40:00","inspection_id":"77282780","insp_unit_id":"192255731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB73088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X5KD276078","insp_unit_decal":"Y","insp_unit_decal_number":"32004794","created_at":"2025-03-17T22:27:35.000000Z","updated_at":"2025-03-17T22:27:35.000000Z"}]},{"id":1707920,"change_date":"2022-11-09 21:40:00","inspection_id":"77097598","dot_number":"1617057","report_state":"MI","report_number":"PRIED02045","insp_date":"2022-11-09 00:00:00","insp_start_time":"1306","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MISSION @ VERNON","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1101681","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2747606,"change_date":"2022-11-09 21:40:00","inspection_id":"77097598","insp_unit_id":"191883989","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB68700","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X8LD691283","insp_unit_decal":"Y","insp_unit_decal_number":"32004838","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1707921,"change_date":"2022-11-09 21:40:00","inspection_id":"77097599","dot_number":"1617057","report_state":"MI","report_number":"PRIED02046","insp_date":"2022-11-09 00:00:00","insp_start_time":"1400","insp_end_time":"1456","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"VERNON @ MISSION","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1101724","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2747607,"change_date":"2022-11-09 21:40:00","inspection_id":"77097599","insp_unit_id":"191883990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB75553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD49X1JJ198794","insp_unit_decal":"Y","insp_unit_decal_number":"32004840","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2747608,"change_date":"2022-11-09 21:40:00","inspection_id":"77097599","insp_unit_id":"191883991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":null,"insp_unit_license":"E574130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4537EN045405","insp_unit_decal":"Y","insp_unit_decal_number":"32004839","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1707922,"change_date":"2022-11-09 21:40:00","inspection_id":"77097600","dot_number":"1617057","report_state":"MI","report_number":"PRIED02047","insp_date":"2022-11-09 00:00:00","insp_start_time":"1507","insp_end_time":"1543","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BATTLE @ MISSION","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1101699","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2747609,"change_date":"2022-11-09 21:40:00","inspection_id":"77097600","insp_unit_id":"191883992","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB83506","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X9KD624027","insp_unit_decal":"Y","insp_unit_decal_number":"32004841","created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1669560,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","dot_number":"1617057","report_state":"OH","report_number":"3238016807","insp_date":"2022-11-02 00:00:00","insp_start_time":"1140","insp_end_time":"1255","registration_date":"2022-12-12 00:00:00","region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MLT","shipping_paper_number":"C 643745","cargo_tank":"NON","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1624414","transaction_code":"C","transaction_date":"2022-11-02 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-03 21:42:00","snet_input_date":"2022-11-03 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:25.000000Z","updated_at":"2025-03-17T18:57:25.000000Z","inspection_violations":[{"id":2618201,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053963","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39378"},{"id":2618202,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053964","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39617C"},{"id":2618203,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053965","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39347E"},{"id":2618204,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053966","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"39353B"},{"id":2618205,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053967","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"3963A1"},{"id":2618206,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_violation_id":"250053968","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192384725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2685815,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_unit_id":"192384725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"356-6","insp_unit_license":"RB59252","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X3CD145538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:25.000000Z","updated_at":"2025-03-17T22:25:25.000000Z"},{"id":2685816,"change_date":"2022-12-12 21:43:00","inspection_id":"77053596","insp_unit_id":"192384726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"0721","insp_unit_license":"D561659","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4320HN049133","insp_unit_decal":"Y","insp_unit_decal_number":"31945047","created_at":"2025-03-17T22:25:25.000000Z","updated_at":"2025-03-17T22:25:25.000000Z"}]},{"id":1647103,"change_date":"2022-11-01 21:40:00","inspection_id":"77027938","dot_number":"1617057","report_state":"MI","report_number":"PRIED02035","insp_date":"2022-10-31 00:00:00","insp_start_time":"1230","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MISSION @ COLEMAN","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1100520","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2584933,"change_date":"2022-11-01 21:40:00","inspection_id":"77027938","insp_violation_id":"249369351","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748300","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2650245,"change_date":"2022-11-01 21:40:00","inspection_id":"77027938","insp_unit_id":"191748300","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD01413","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6JD476949","insp_unit_decal":"Y","insp_unit_decal_number":"32004792","created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"},{"id":2650246,"change_date":"2022-11-01 21:40:00","inspection_id":"77027938","insp_unit_id":"191748301","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"D621680","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1B9SP4980JE601327","insp_unit_decal":"Y","insp_unit_decal_number":"32004791","created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1647104,"change_date":"2022-11-01 21:40:00","inspection_id":"77027939","dot_number":"1617057","report_state":"MI","report_number":"PRIED02036","insp_date":"2022-10-31 00:00:00","insp_start_time":"1434","insp_end_time":"1458","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLEMAN @ MISSION","county_code_state":"MI","county_code":"073","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1100482","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2650247,"change_date":"2022-11-01 21:40:00","inspection_id":"77027939","insp_unit_id":"191748302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC22725","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X0DJ340949","insp_unit_decal":"Y","insp_unit_decal_number":"32004795","created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":1422259,"change_date":"2022-10-03 21:40:00","inspection_id":"76768648","dot_number":"1617057","report_state":"MI","report_number":"POWEL02827","insp_date":"2022-10-02 00:00:00","insp_start_time":"1100","insp_end_time":"1121","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STEENBLIK","shipping_paper_number":"26854","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-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1097025","transaction_code":"A","transaction_date":"2022-10-02 00:00:00","upload_date":"2022-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-10-03 21:40:00","snet_input_date":"2022-10-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-03 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:01.000000Z","updated_at":"2025-03-17T18:53:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2289726,"change_date":"2022-10-03 21:40:00","inspection_id":"76768648","insp_unit_id":"191226745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1911","insp_unit_license":"RB83506","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X9KD624027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:39.000000Z","updated_at":"2025-03-17T22:22:39.000000Z"},{"id":2289727,"change_date":"2022-10-03 21:40:00","inspection_id":"76768648","insp_unit_id":"191226746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALR","insp_unit_company":"0092","insp_unit_license":"87901T","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA4328YN033276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:39.000000Z","updated_at":"2025-03-17T22:22:39.000000Z"}]},{"id":1249518,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","dot_number":"1617057","report_state":"OH","report_number":"1808003484","insp_date":"2022-09-09 00:00:00","insp_start_time":"1221","insp_end_time":"1319","registration_date":"2022-09-19 00:00:00","region":"ET","ci_status_code":"C","location":"15130","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"151","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MICHIGAN MILK PRODUCERS ASSOCIATION","shipping_paper_number":"C618470","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1615142","transaction_code":"C","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-09-09 21:38:00","snet_input_date":"2022-09-09 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-09-09 21:38:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:43.000000Z","updated_at":"2025-03-17T18:49:43.000000Z","inspection_violations":[{"id":1977759,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","insp_violation_id":"248501420","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190973965","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39345D"},{"id":1977760,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","insp_violation_id":"248501421","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190973965","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39311"},{"id":1977761,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","insp_violation_id":"248501422","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190973966","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":2010959,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","insp_unit_id":"190973965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"356-6","insp_unit_license":"RB59252","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X3CD145538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:49.000000Z","updated_at":"2025-03-17T22:20:49.000000Z"},{"id":2010960,"change_date":"2022-09-19 21:40:00","inspection_id":"76567770","insp_unit_id":"190973966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1121","insp_unit_license":"D823608","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSABB230KN090767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:49.000000Z","updated_at":"2025-03-17T22:20:49.000000Z"}]},{"id":1046508,"change_date":"2022-08-16 21:39:00","inspection_id":"76331588","dot_number":"1617057","report_state":"OH","report_number":"1808003415","insp_date":"2022-08-15 00:00:00","insp_start_time":"1023","insp_end_time":"1059","registration_date":null,"region":"ET","ci_status_code":"C","location":"15130","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MLT TRANSPORT","shipping_paper_number":"C639759","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1611161","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1683874,"change_date":"2022-08-16 21:39:00","inspection_id":"76331588","insp_unit_id":"190331729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"},{"id":1683875,"change_date":"2022-08-16 21:39:00","inspection_id":"76331588","insp_unit_id":"190331730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1139","insp_unit_license":"D636529","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5WSAA4324JN049741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"}]},{"id":828504,"change_date":"2022-07-15 21:40:00","inspection_id":"76076984","dot_number":"1617057","report_state":"WI","report_number":"2722001193","insp_date":"2022-07-14 00:00:00","insp_start_time":"1208","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":"12(62)","location_desc":"JEFFERSON (TOWN)","county_code_state":"WI","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"866068","transaction_code":"A","transaction_date":"2022-07-15 00:00:00","upload_date":"2022-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":"M","census_search_date":"2022-07-15 21:40:00","snet_input_date":"2022-07-15 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"MCGUIRE BROTHERS FARMS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:17.000000Z","updated_at":"2025-03-17T18:42:17.000000Z","inspection_violations":[{"id":1305592,"change_date":"2022-07-15 21:40:00","inspection_id":"76076984","insp_violation_id":"247121286","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:10.000000Z","updated_at":"2025-03-17T21:13:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1332909,"change_date":"2022-07-15 21:40:00","inspection_id":"76076984","insp_unit_id":"189802269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1912","insp_unit_license":"RB78538","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXDP9X3LD640582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"},{"id":1332910,"change_date":"2022-07-15 21:40:00","inspection_id":"76076984","insp_unit_id":"189802270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"0677","insp_unit_license":"95976T","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"5WSAA45262N035080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:22.000000Z","updated_at":"2025-03-17T22:16:22.000000Z"}]},{"id":347902,"change_date":"2022-06-09 21:42:00","inspection_id":"75508167","dot_number":"1617057","report_state":"MI","report_number":"KIRKB03442","insp_date":"2022-05-06 00:00:00","insp_start_time":"1405","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 & GRAND RIVER-HOWELL","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1074573","transaction_code":"C","transaction_date":"2022-05-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01617057","upload_search_indicator":null,"census_search_date":"2022-05-09 21:41:00","snet_input_date":"2022-05-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-09 21:41:00","insp_carrier_name":"MCGUIRE BROTHERS LLC","insp_carrier_street":"6644 N MISSION RD","insp_carrier_city":"ROSEBUSH","insp_carrier_state":"MI","insp_carrier_zip_code":"48878","insp_colonia":null,"docket_number":"38278","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:39.000000Z","updated_at":"2025-03-17T18:33:39.000000Z","inspection_violations":[{"id":545552,"change_date":"2022-06-09 21:42:00","inspection_id":"75508167","insp_violation_id":"246336355","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:37.000000Z","updated_at":"2025-03-17T21:09:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":562555,"change_date":"2022-06-09 21:42:00","inspection_id":"75508167","insp_unit_id":"189147525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1910","insp_unit_license":"RB73088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X5KD276078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"},{"id":562556,"change_date":"2022-06-09 21:42:00","inspection_id":"75508167","insp_unit_id":"189147526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALR","insp_unit_company":"1562","insp_unit_license":"2570417","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5WSAA43299N040657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1617057\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1617057\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1617057\/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\/1617057\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}