{"current_page":1,"data":[{"id":12444378,"change_date":"2026-07-14 21:41:00","inspection_id":"88404041","dot_number":"2086035","report_state":"MI","report_number":"BARTC03302","insp_date":"2026-07-14 00:00:00","insp_start_time":"1010","insp_end_time":"1052","registration_date":null,"region":"ED","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"3747583","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":"2026-07-14 21:41:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-14 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889-9754","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-17T09:41:09.000000Z","updated_at":"2026-07-25T09:30:58.000000Z","inspection_violations":[{"id":21665652,"change_date":"2026-07-14 21:41:00","inspection_id":"88404041","insp_violation_id":"275493618","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4719420","created_at":"2026-07-17T10:03:49.000000Z","updated_at":"2026-07-25T09:43:28.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":21616395,"change_date":"2026-07-14 21:41:00","inspection_id":"88404041","insp_unit_id":"214604962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BE27133","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHALD16FPGM2311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:12.000000Z","updated_at":"2026-07-25T09:02:27.000000Z"},{"id":21616396,"change_date":"2026-07-14 21:41:00","inspection_id":"88404041","insp_unit_id":"214604963","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"F229868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2556J1223371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:12.000000Z","updated_at":"2026-07-25T09:02:27.000000Z"}]},{"id":11665564,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","dot_number":"2086035","report_state":"MI","report_number":"AKERT00742","insp_date":"2026-04-16 00:00:00","insp_start_time":"0904","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"4878 S ALGER RD","county_code_state":"MI","county_code":"057","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"151000","viol_total":"19","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":"1266617","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:36.000000Z","updated_at":"2026-04-27T09:31:36.000000Z","inspection_violations":[{"id":20262079,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649559","seq_no":"15","part_no":"393","part_no_section":"203D-CBP","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393203DCBP"},{"id":20262080,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649560","seq_no":"16","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39330B"},{"id":20262065,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649545","seq_no":"1","part_no":"393","part_no_section":"203E-CBP","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393203ECBP"},{"id":20262066,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649546","seq_no":"2","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393207ASAPPAS"},{"id":20262067,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649547","seq_no":"3","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393207ASAPPAS"},{"id":20262068,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649548","seq_no":"4","part_no":"393","part_no_section":"75A1-TFSMF","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39375A1TFSMF"},{"id":20262069,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649549","seq_no":"5","part_no":"393","part_no_section":"75A1-TFSMF","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39375A1TFSMF"},{"id":20262070,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649550","seq_no":"6","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39375A3TFL"},{"id":20262071,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649551","seq_no":"7","part_no":"393","part_no_section":"75A3-TFL","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39375A3TFL"},{"id":20262074,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649554","seq_no":"10","part_no":"393","part_no_section":"47A-BCFSBD-SA","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39347ABCFSBDSA"},{"id":20262075,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649555","seq_no":"11","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39348ABMBCBD"},{"id":20262076,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649556","seq_no":"12","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39348ABMBCBD"},{"id":20262077,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649557","seq_no":"13","part_no":"393","part_no_section":"201A-FRMC","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393201AFRMC"},{"id":20262078,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649558","seq_no":"14","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"393203ACBP"},{"id":20262081,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649561","seq_no":"17","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"3963A1TAOCV"},{"id":20262082,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649562","seq_no":"18","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"3963A1TAOCV"},{"id":20262083,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649563","seq_no":"19","part_no":"396","part_no_section":"7A-UOC","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"3967AUOC"},{"id":20262072,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649552","seq_no":"8","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"3963A1HCM"},{"id":20262073,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_violation_id":"273649553","seq_no":"9","part_no":"393","part_no_section":"47A-BCFSBD-SA","insp_viol_unit":"1","insp_unit_id":"213054138","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:45:00.000000Z","updated_at":"2026-04-27T09:45:00.000000Z","normalized_code":"39347ABCFSBDSA"}],"inspection_per_units":[{"id":20292602,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_unit_id":"213054138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE27132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDL40X1GJ473714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"},{"id":20292603,"change_date":"2026-04-16 21:41:00","inspection_id":"87595892","insp_unit_id":"213054139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"F229867","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2450P1223313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"}]},{"id":11173554,"change_date":"2026-02-19 21:40:00","inspection_id":"87089436","dot_number":"2086035","report_state":"MI","report_number":"RICKE01014","insp_date":"2026-02-17 00:00:00","insp_start_time":"1605","insp_end_time":"1630","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B M-66 & MISSAUKEE MTN ROAD","county_code_state":"MI","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1259844","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:38:04.000000Z","updated_at":"2026-03-02T10:31:04.000000Z","inspection_violations":[{"id":18731101,"change_date":"2026-02-19 21:40:00","inspection_id":"87089436","insp_violation_id":"271897634","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4658382","created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:34.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19068240,"change_date":"2026-02-19 21:40:00","inspection_id":"87089436","insp_unit_id":"211713747","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"227","insp_unit_license":"E911924","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9FF2558P1223443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:03:59.000000Z"},{"id":19068241,"change_date":"2026-02-19 21:40:00","inspection_id":"87089436","insp_unit_id":"211713748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"125","insp_unit_license":"BE54213","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWL40X3PR265120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:03:59.000000Z"}]},{"id":11047311,"change_date":"2026-02-04 21:39:00","inspection_id":"86957202","dot_number":"2086035","report_state":"MI","report_number":"DELMT02473","insp_date":"2026-02-03 00:00:00","insp_start_time":"1545","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I94 NEAR EATON RAPIDS 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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","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":"1257893","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:00.000000Z","updated_at":"2026-02-15T10:30:46.000000Z","inspection_violations":[{"id":18302643,"change_date":"2026-02-04 21:39:00","inspection_id":"86957202","insp_violation_id":"271595222","seq_no":"1","part_no":"393","part_no_section":"116E-CL","insp_viol_unit":"1","insp_unit_id":"211440888","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-02-07T10:45:37.000000Z","updated_at":"2026-02-15T10:40:12.000000Z","normalized_code":"393116ECL"}],"inspection_per_units":[{"id":18375648,"change_date":"2026-02-04 21:39:00","inspection_id":"86957202","insp_unit_id":"211440888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE27134","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDL40X1MR462029","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:11:02.000000Z","updated_at":"2026-02-15T10:05:26.000000Z"},{"id":18375649,"change_date":"2026-02-04 21:39:00","inspection_id":"86957202","insp_unit_id":"211440889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"F229870","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF255XM1223412","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:11:02.000000Z","updated_at":"2026-02-15T10:05:26.000000Z"}]},{"id":10297517,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","dot_number":"2086035","report_state":"MI","report_number":"DOWEM03289","insp_date":"2025-11-24 00:00:00","insp_start_time":"1345","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B I-75","county_code_state":"MI","county_code":"137","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-26 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"184000","viol_total":"7","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1251980","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-26 21:38:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-29T10:31:40.000000Z","updated_at":"2025-12-08T10:30:43.000000Z","inspection_violations":[{"id":17323263,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460186","seq_no":"1","part_no":"391","part_no_section":"41B10-MC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"39141B10MC"},{"id":17323264,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460187","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","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-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"3922SLLED"},{"id":17323265,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460188","seq_no":"3","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"1","insp_unit_id":"210412998","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"393207FSDAS"},{"id":17323266,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460189","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210412998","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"39347E"},{"id":17323267,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460190","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"210412998","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"39353BB"},{"id":17323268,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460191","seq_no":"6","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"210412998","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"39343ATPV"},{"id":17323269,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_violation_id":"270460192","seq_no":"7","part_no":"393","part_no_section":"45D-BHCR","insp_viol_unit":"1","insp_unit_id":"210412998","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:11.000000Z","updated_at":"2025-12-08T10:31:17.000000Z","normalized_code":"39345DBHCR"}],"inspection_per_units":[{"id":17292818,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_unit_id":"210412998","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BD94305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:52.000000Z"},{"id":17292819,"change_date":"2025-12-04 21:38:00","inspection_id":"86423065","insp_unit_id":"210412999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"32","insp_unit_license":"F229874","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5385P1223325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:52.000000Z"}]},{"id":10200787,"change_date":"2025-12-04 21:38:00","inspection_id":"86321636","dot_number":"2086035","report_state":"MI","report_number":"RICKE00904","insp_date":"2025-11-13 00:00:00","insp_start_time":"0920","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B M-115 & 70TH AVE","county_code_state":"MI","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CHERRY CREEK","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-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","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":"1250636","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:28.000000Z","updated_at":"2025-12-08T10:30:33.000000Z","inspection_violations":[{"id":17320130,"change_date":"2025-12-04 21:38:00","inspection_id":"86321636","insp_violation_id":"270463179","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:58.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17290249,"change_date":"2025-12-04 21:38:00","inspection_id":"86321636","insp_unit_id":"210415308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"123","insp_unit_license":"BD98532","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWL40X5MR416826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:40.000000Z"},{"id":17290250,"change_date":"2025-12-04 21:38:00","inspection_id":"86321636","insp_unit_id":"210415309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTR","insp_unit_company":"213","insp_unit_license":"D991950","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2558K1223387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:40.000000Z"}]},{"id":10092712,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","dot_number":"2086035","report_state":"MI","report_number":"ROLLJ02919","insp_date":"2025-10-30 00:00:00","insp_start_time":"1216","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"232500","viol_total":"15","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248727","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-31 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-03T11:04:54.000000Z","updated_at":"2025-11-04T11:01:02.000000Z","inspection_violations":[{"id":16718952,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657808","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4616285","created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3922SLLEWA2"},{"id":16718953,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657809","seq_no":"2","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3963A1BALR"},{"id":16718954,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657810","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39395F"},{"id":16718955,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657811","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39360C"},{"id":16718956,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657812","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39345B2BAIR"},{"id":16718957,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657813","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39347E"},{"id":16718958,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657814","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39353BB"},{"id":16718959,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657815","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4616285","created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3963A1BOS"},{"id":16718960,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657816","seq_no":"9","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"209776611","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3929A2C"},{"id":16718961,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657817","seq_no":"10","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"209776612","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39348ABIBD"},{"id":16718962,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657818","seq_no":"11","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"209776612","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39348ABIBD"},{"id":16718963,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657819","seq_no":"12","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"209776612","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3963A1BALAC"},{"id":16718964,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657820","seq_no":"13","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"3","insp_unit_id":"209776613","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39348ABIBD"},{"id":16718965,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657821","seq_no":"14","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"3","insp_unit_id":"209776613","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"39345B2BAIR"},{"id":16718966,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_violation_id":"269657822","seq_no":"15","part_no":"396","part_no_section":"3A1-BNMH","insp_viol_unit":"3","insp_unit_id":"209776613","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-03T11:17:48.000000Z","updated_at":"2025-11-04T11:16:28.000000Z","normalized_code":"3963A1BNMH"}],"inspection_per_units":[{"id":16780724,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_unit_id":"209776611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BE09633","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:18.000000Z","updated_at":"2025-11-04T10:46:17.000000Z"},{"id":16780725,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_unit_id":"209776612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"THWY","insp_unit_company":"207","insp_unit_license":"E590303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA284XT1011598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:18.000000Z","updated_at":"2025-11-04T10:46:17.000000Z"},{"id":16780726,"change_date":"2025-10-31 21:40:00","inspection_id":"86207868","insp_unit_id":"209776613","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"THWY","insp_unit_company":"208","insp_unit_license":"E590304","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA2832T1011599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-03T10:47:18.000000Z","updated_at":"2025-11-04T10:46:17.000000Z"}]},{"id":10030622,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","dot_number":"2086035","report_state":"MI","report_number":"MCKEN00193","insp_date":"2025-10-24 00:00:00","insp_start_time":"0805","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"3 MILE RD","county_code_state":"MI","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"146000","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":"1247704","transaction_code":"A","transaction_date":"2025-10-24 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-27T10:01:53.000000Z","updated_at":"2025-10-28T10:01:11.000000Z","inspection_violations":[{"id":16591313,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","insp_violation_id":"269504244","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:31.000000Z","normalized_code":"3922SLLS3"},{"id":16591314,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","insp_violation_id":"269504245","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209644747","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:31.000000Z","normalized_code":"39345B2BAIR"},{"id":16591315,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","insp_violation_id":"269504246","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209644746","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:31.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16664346,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","insp_unit_id":"209644746","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD98532","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWL40X5MR416826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:29.000000Z"},{"id":16664347,"change_date":"2025-10-24 21:40:00","inspection_id":"86142365","insp_unit_id":"209644747","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTR","insp_unit_company":"BLK","insp_unit_license":"D991950","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2558K1223387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:29.000000Z"}]},{"id":9770498,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","dot_number":"2086035","report_state":"MI","report_number":"FALAS00376","insp_date":"2025-09-22 00:00:00","insp_start_time":"1420","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"YOUNGS PRARIE INSPECTION SITE","county_code_state":"MI","county_code":"149","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1242999","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:16.000000Z","updated_at":"2025-09-28T10:00:41.000000Z","inspection_violations":[{"id":16059283,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_violation_id":"268900636","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"1","insp_unit_id":"209127293","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:07.000000Z","updated_at":"2025-09-28T10:16:08.000000Z","normalized_code":"3922SLLEWG2"},{"id":16059284,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_violation_id":"268900637","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"209127293","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:07.000000Z","updated_at":"2025-09-28T10:16:08.000000Z","normalized_code":"3922SLLEWA2"},{"id":16059285,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_violation_id":"268900638","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"209127293","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:07.000000Z","updated_at":"2025-09-28T10:16:08.000000Z","normalized_code":"3922SLLEWA2"},{"id":16059286,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_violation_id":"268900639","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"2","insp_unit_id":"209127294","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:17:07.000000Z","updated_at":"2025-09-28T10:16:08.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":16186601,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_unit_id":"209127293","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"RC52509","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X37J198452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:11.000000Z"},{"id":16186602,"change_date":"2025-09-24 21:42:00","inspection_id":"85868396","insp_unit_id":"209127294","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"F229873","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4P04529GF044908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:11.000000Z"}]},{"id":9473091,"change_date":"2025-08-21 21:41:00","inspection_id":"85556431","dot_number":"2086035","report_state":"MI","report_number":"MOREM06092","insp_date":"2025-08-20 00:00:00","insp_start_time":"1155","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DEWITT REST AREA","county_code_state":"MI","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"QUALITY HARDWOODS","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":null,"final_status_date":"2025-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","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":"1237477","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":"35226","created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[{"id":15436895,"change_date":"2025-08-21 21:41:00","inspection_id":"85556431","insp_violation_id":"268170568","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4583954","created_at":"2025-08-24T10:48:50.000000Z","updated_at":"2025-08-25T10:44:54.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":15624974,"change_date":"2025-08-21 21:41:00","inspection_id":"85556431","insp_unit_id":"208516708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"103","insp_unit_license":"BD75558","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD10JPJP8637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:08.000000Z"},{"id":15624975,"change_date":"2025-08-21 21:41:00","inspection_id":"85556431","insp_unit_id":"208516709","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"23","insp_unit_license":"F229868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2556J1223371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:08.000000Z"}]},{"id":9364573,"change_date":"2025-08-08 21:39:00","inspection_id":"85442312","dot_number":"2086035","report_state":"MI","report_number":"MCKEN00126","insp_date":"2025-08-06 00:00:00","insp_start_time":"1055","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TUSTIN REST AREA","county_code_state":"MI","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"135500","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1235023","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":15212198,"change_date":"2025-08-08 21:39:00","inspection_id":"85442312","insp_violation_id":"267918733","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208306020","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:29.000000Z","updated_at":"2025-08-12T10:45:29.000000Z","normalized_code":"39378AWS"},{"id":15212199,"change_date":"2025-08-08 21:39:00","inspection_id":"85442312","insp_violation_id":"267918734","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"208306020","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:29.000000Z","updated_at":"2025-08-12T10:45:29.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":15428524,"change_date":"2025-08-08 21:39:00","inspection_id":"85442312","insp_unit_id":"208306020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLUE","insp_unit_license":"BD94325","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPXL40X7PD829198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:58.000000Z"},{"id":15428525,"change_date":"2025-08-08 21:39:00","inspection_id":"85442312","insp_unit_id":"208306021","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"BLACK","insp_unit_license":"E595226","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9FF2553N1223427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:58.000000Z"}]},{"id":8896851,"change_date":"2025-06-13 21:40:00","inspection_id":"84949442","dot_number":"2086035","report_state":"MI","report_number":"ELDEH00810","insp_date":"2025-06-11 00:00:00","insp_start_time":"0705","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"JEROME ST @ MAIN ST","county_code_state":"MI","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1225277","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:13.000000Z","updated_at":"2025-06-17T10:00:38.000000Z","inspection_violations":[{"id":14261035,"change_date":"2025-06-13 21:40:00","inspection_id":"84949442","insp_violation_id":"266836489","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:44.000000Z","updated_at":"2025-06-17T10:20:51.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":14575073,"change_date":"2025-06-13 21:40:00","inspection_id":"84949442","insp_unit_id":"207381250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BD94305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:40.000000Z","updated_at":"2025-06-17T09:45:51.000000Z"},{"id":14575074,"change_date":"2025-06-13 21:40:00","inspection_id":"84949442","insp_unit_id":"207381251","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"NONE","insp_unit_license":"E310306","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB2521V7C60876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-16T09:46:40.000000Z","updated_at":"2025-06-17T09:45:51.000000Z"}]},{"id":8558927,"change_date":"2025-05-06 21:40:00","inspection_id":"84592384","dot_number":"2086035","report_state":"MI","report_number":"EVANT02843","insp_date":"2025-05-05 00:00:00","insp_start_time":"1250","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ THUMB LAKE RD","county_code_state":"MI","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"179300","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":"1220203","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD SUMNER","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-09T10:26:05.000000Z","updated_at":"2025-05-10T10:51:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13921416,"change_date":"2025-05-06 21:40:00","inspection_id":"84592384","insp_unit_id":"206665140","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"225","insp_unit_license":"E758132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5383P1223436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:13:57.000000Z","updated_at":"2025-05-10T10:01:50.000000Z"},{"id":13921417,"change_date":"2025-05-06 21:40:00","inspection_id":"84592384","insp_unit_id":"206665141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BE09633","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:13:57.000000Z","updated_at":"2025-05-10T10:01:50.000000Z"}]},{"id":6489966,"change_date":"2024-09-17 21:45:00","inspection_id":"82408072","dot_number":"2086035","report_state":"MI","report_number":"BARTC02681","insp_date":"2024-08-14 00:00:00","insp_start_time":"0855","insp_end_time":"0932","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ 50 RD","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"166000","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":"1190493","transaction_code":"C","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10076633,"change_date":"2024-09-17 21:45:00","inspection_id":"82408072","insp_violation_id":"261857685","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":"X4420956","created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10461462,"change_date":"2024-09-17 21:45:00","inspection_id":"82408072","insp_unit_id":"202974093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BD94305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"},{"id":10461463,"change_date":"2024-09-17 21:45:00","inspection_id":"82408072","insp_unit_id":"202974094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"E945910","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5084W1223092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:23.000000Z","updated_at":"2025-03-17T23:31:23.000000Z"}]},{"id":6403842,"change_date":"2024-09-17 21:45:00","inspection_id":"82315961","dot_number":"2086035","report_state":"MI","report_number":"ROLLJ02553","insp_date":"2024-08-05 00:00:00","insp_start_time":"1813","insp_end_time":"1847","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"156500","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":"1188840","transaction_code":"C","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:51.000000Z","updated_at":"2025-03-17T20:29:51.000000Z","inspection_violations":[{"id":9940291,"change_date":"2024-09-17 21:45:00","inspection_id":"82315961","insp_violation_id":"261871091","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202984922","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4419296","created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10320240,"change_date":"2024-09-17 21:45:00","inspection_id":"82315961","insp_unit_id":"202984922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD94305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:58.000000Z","updated_at":"2025-03-17T23:29:58.000000Z"},{"id":10320241,"change_date":"2024-09-17 21:45:00","inspection_id":"82315961","insp_unit_id":"202984923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EXPRE","insp_unit_company":null,"insp_unit_license":"E945909","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9FD1780GE064410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:58.000000Z","updated_at":"2025-03-17T23:29:58.000000Z"}]},{"id":5930343,"change_date":"2024-06-06 21:41:00","inspection_id":"81806854","dot_number":"2086035","report_state":"MI","report_number":"MCGEJ03225","insp_date":"2024-06-03 00:00:00","insp_start_time":"0810","insp_end_time":"0902","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SB @ 4 MILE RD","county_code_state":"MI","county_code":"039","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"146000","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":"1181501","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9196411,"change_date":"2024-06-06 21:41:00","inspection_id":"81806854","insp_violation_id":"259944244","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":"X4382641","created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9551926,"change_date":"2024-06-06 21:41:00","inspection_id":"81806854","insp_unit_id":"201269717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"103","insp_unit_license":"BD75558","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD10JPJP8637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"},{"id":9551927,"change_date":"2024-06-06 21:41:00","inspection_id":"81806854","insp_unit_id":"201269718","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTSI","insp_unit_company":"202","insp_unit_license":"E568112","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9FF2557M1223283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5723115,"change_date":"2024-05-11 21:31:00","inspection_id":"81581913","dot_number":"2086035","report_state":"MI","report_number":"BACZM02295","insp_date":"2024-05-08 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-11 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"137500","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":"1178079","transaction_code":"A","transaction_date":"2024-05-08 00:00:00","upload_date":"2024-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-11 21:31:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:16.000000Z","updated_at":"2025-03-17T20:16:16.000000Z","inspection_violations":[{"id":8855612,"change_date":"2024-05-11 21:31:00","inspection_id":"81581913","insp_violation_id":"259445206","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"2","insp_unit_id":"200841457","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":9218089,"change_date":"2024-05-11 21:31:00","inspection_id":"81581913","insp_unit_id":"200841456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD75560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"},{"id":9218090,"change_date":"2024-05-11 21:31:00","inspection_id":"81581913","insp_unit_id":"200841457","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOLE","insp_unit_company":null,"insp_unit_license":"E590306","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"12HLB533XYN405884","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:46.000000Z","updated_at":"2025-03-17T23:18:46.000000Z"}]},{"id":5435093,"change_date":"2024-04-04 21:42:00","inspection_id":"81268066","dot_number":"2086035","report_state":"MI","report_number":"BURGM05963","insp_date":"2024-04-03 00:00:00","insp_start_time":"1235","insp_end_time":"1337","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCOTT RD","county_code_state":"MI","county_code":"037","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"217500","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":"1171535","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[{"id":8390044,"change_date":"2024-04-04 21:42:00","inspection_id":"81268066","insp_violation_id":"258747784","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":"X4355436","created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8754777,"change_date":"2024-04-04 21:42:00","inspection_id":"81268066","insp_unit_id":"200237777","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BD75560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"},{"id":8754778,"change_date":"2024-04-04 21:42:00","inspection_id":"81268066","insp_unit_id":"200237778","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"THRU","insp_unit_company":"207","insp_unit_license":"E590303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA2832T1011599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"},{"id":8754779,"change_date":"2024-04-04 21:42:00","inspection_id":"81268066","insp_unit_id":"200237779","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"THRU","insp_unit_company":"208","insp_unit_license":"E590304","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA284XT1011598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5381200,"change_date":"2024-03-27 21:42:00","inspection_id":"81209037","dot_number":"2086035","report_state":"MI","report_number":"HINCA00224","insp_date":"2024-03-26 00:00:00","insp_start_time":"1330","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":"LOT","location_desc":"MARATHON @ I-75 EXIT 270","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1170889","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:25.000000Z","updated_at":"2025-03-17T20:09:25.000000Z","inspection_violations":[{"id":8305703,"change_date":"2024-03-27 21:42:00","inspection_id":"81209037","insp_violation_id":"258615701","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":"X4346975","created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8666416,"change_date":"2024-03-27 21:42:00","inspection_id":"81209037","insp_unit_id":"200116083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"125","insp_unit_license":"BD57258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWL40X3PR265120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:37.000000Z","updated_at":"2025-03-17T23:13:37.000000Z"},{"id":8666417,"change_date":"2024-03-27 21:42:00","inspection_id":"81209037","insp_unit_id":"200116084","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":null,"insp_unit_license":"E911924","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9FF2558P1223443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:37.000000Z","updated_at":"2025-03-17T23:13:37.000000Z"}]},{"id":5331261,"change_date":"2024-03-20 21:43:00","inspection_id":"81154780","dot_number":"2086035","report_state":"MI","report_number":"ROLLJ02418","insp_date":"2024-03-19 00:00:00","insp_start_time":"0800","insp_end_time":"0834","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","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":"169500","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":"1169896","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":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","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":8224925,"change_date":"2024-03-20 21:43:00","inspection_id":"81154780","insp_violation_id":"258493595","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200009406","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4347209","created_at":"2025-03-17T21:45:47.000000Z","updated_at":"2025-03-17T21:45:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8585612,"change_date":"2024-03-20 21:43:00","inspection_id":"81154780","insp_unit_id":"200009406","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BD75560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX196","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":8585613,"change_date":"2024-03-20 21:43:00","inspection_id":"81154780","insp_unit_id":"200009407","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELOU","insp_unit_company":null,"insp_unit_license":"E925430","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2D92G5389R2004043","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":5306793,"change_date":"2024-03-18 21:38:00","inspection_id":"81128092","dot_number":"2086035","report_state":"MI","report_number":"BARTC02537","insp_date":"2024-03-15 00:00:00","insp_start_time":"0845","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ 50 RD","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"196300","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":"1169279","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[{"id":8183793,"change_date":"2024-03-18 21:38:00","inspection_id":"81128092","insp_violation_id":"258432929","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:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8546353,"change_date":"2024-03-18 21:38:00","inspection_id":"81128092","insp_unit_id":"199958624","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BD75560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"},{"id":8546354,"change_date":"2024-03-18 21:38:00","inspection_id":"81128092","insp_unit_id":"199958625","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELOU","insp_unit_company":"229","insp_unit_license":"E942702","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2D92G5380R200404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"}]},{"id":5258419,"change_date":"2024-03-11 21:43:00","inspection_id":"81075398","dot_number":"2086035","report_state":"MI","report_number":"SCIBA02372","insp_date":"2024-03-07 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OAK","county_code_state":"MI","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1168572","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-11 21:43:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:44.000000Z","updated_at":"2025-03-17T20:06:44.000000Z","inspection_violations":[{"id":8108414,"change_date":"2024-03-11 21:43:00","inspection_id":"81075398","insp_violation_id":"258314977","seq_no":"1","part_no":"393","part_no_section":"116","insp_viol_unit":"2","insp_unit_id":"199852684","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"393116"}],"inspection_per_units":[{"id":8467430,"change_date":"2024-03-11 21:43:00","inspection_id":"81075398","insp_unit_id":"199852683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD75560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:44.000000Z","updated_at":"2025-03-17T23:11:44.000000Z"},{"id":8467431,"change_date":"2024-03-11 21:43:00","inspection_id":"81075398","insp_unit_id":"199852684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELOU","insp_unit_company":null,"insp_unit_license":"E942702","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2D92G5380R2004044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:44.000000Z","updated_at":"2025-03-17T23:11:44.000000Z"}]},{"id":4966073,"change_date":"2024-02-02 21:42:00","inspection_id":"80756260","dot_number":"2086035","report_state":"MI","report_number":"CINIM01853","insp_date":"2024-02-01 00:00:00","insp_start_time":"1505","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 NB @ MM 125","county_code_state":"MI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-02 21:42: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":"1162782","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-02 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:12.000000Z","updated_at":"2025-03-17T20:01:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7992431,"change_date":"2024-02-02 21:42:00","inspection_id":"80756260","insp_unit_id":"199245564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BD64013","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"},{"id":7992432,"change_date":"2024-02-02 21:42:00","inspection_id":"80756260","insp_unit_id":"199245565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELOU","insp_unit_company":null,"insp_unit_license":"E925430","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2D92G5389R2004043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"}]},{"id":4802934,"change_date":"2024-01-10 21:44:00","inspection_id":"80577736","dot_number":"2086035","report_state":"MI","report_number":"KOCHJ01429","insp_date":"2024-01-08 00:00:00","insp_start_time":"1525","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-81 @ RINGLE RD","county_code_state":"MI","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1160208","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":7408583,"change_date":"2024-01-10 21:44:00","inspection_id":"80577736","insp_violation_id":"257274033","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:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7727499,"change_date":"2024-01-10 21:44:00","inspection_id":"80577736","insp_unit_id":"198898452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"109","insp_unit_license":"RB70279","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X4KD624109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":3868169,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","dot_number":"2086035","report_state":"MI","report_number":"ROLLJ02290","insp_date":"2023-08-30 00:00:00","insp_start_time":"0725","insp_end_time":"0839","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M55 EB @ 13 RD","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-30 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"164000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143501","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-30 21:45:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:22.000000Z","updated_at":"2025-03-17T19:39:22.000000Z","inspection_violations":[{"id":5975394,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","insp_violation_id":"254990859","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196818584","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4270793","created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"3922"},{"id":5975395,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","insp_violation_id":"254990860","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196818585","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"3939A"},{"id":5975396,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","insp_violation_id":"254990861","seq_no":"3","part_no":"393","part_no_section":"116","insp_viol_unit":"2","insp_unit_id":"196818585","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:54.000000Z","updated_at":"2025-03-17T21:34:54.000000Z","normalized_code":"393116"}],"inspection_per_units":[{"id":6218682,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","insp_unit_id":"196818584","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"118","insp_unit_license":"BD53470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X2MD757423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"},{"id":6218683,"change_date":"2023-08-30 21:45:00","inspection_id":"79546225","insp_unit_id":"196818585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTSI","insp_unit_company":"225","insp_unit_license":"E758132","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9DF5383P1223436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:14.000000Z","updated_at":"2025-03-17T22:52:14.000000Z"}]},{"id":3845492,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","dot_number":"2086035","report_state":"MI","report_number":"WASCC00364","insp_date":"2023-08-25 00:00:00","insp_start_time":"1135","insp_end_time":"1214","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SHOULDER","county_code_state":"MI","county_code":"005","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":"2023-08-28 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"52000","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":"1142786","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":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","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":5939428,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","insp_violation_id":"254989884","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"3","insp_unit_id":"196817804","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"39375A"},{"id":5939429,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","insp_violation_id":"254989885","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"3","insp_unit_id":"196817804","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:41.000000Z","updated_at":"2025-03-17T21:34:41.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6182735,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","insp_unit_id":"196817804","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"HILF","insp_unit_company":null,"insp_unit_license":"E203928","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H9DFM335R1022024","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":6182736,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","insp_unit_id":"196817805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC10855","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X45J116091","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":6182737,"change_date":"2023-08-30 21:45:00","inspection_id":"79520958","insp_unit_id":"196817806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HILF","insp_unit_company":null,"insp_unit_license":"E203924","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H9DCM3L6R1022025","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":3824023,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","dot_number":"2086035","report_state":"MI","report_number":"STREJ01692","insp_date":"2023-08-23 00:00:00","insp_start_time":"1105","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N\/B SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"146000","viol_total":"15","oos_total":"4","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142376","transaction_code":"C","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:29.000000Z","updated_at":"2025-03-17T19:38:29.000000Z","inspection_violations":[{"id":5903561,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989714","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3922"},{"id":5903562,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989715","seq_no":"2","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347B"},{"id":5903563,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989716","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347E"},{"id":5903564,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989717","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347E"},{"id":5903565,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989718","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39353B"},{"id":5903566,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989719","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4220261","created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3963A1"},{"id":5903567,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989720","seq_no":"7","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"196817675","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39355D1"},{"id":5903568,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989721","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347E"},{"id":5903569,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989722","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347E"},{"id":5903570,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989723","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39347E"},{"id":5903571,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989724","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39353B"},{"id":5903572,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989725","seq_no":"12","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39375C"},{"id":5903573,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989726","seq_no":"13","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39355D3"},{"id":5903574,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989727","seq_no":"14","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4220261","created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393110"},{"id":5903575,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_violation_id":"254989728","seq_no":"15","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"196817676","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393110"}],"inspection_per_units":[{"id":6148238,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_unit_id":"196817675","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"119","insp_unit_license":"BD53472","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHALDR5APAT2642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:39.000000Z","updated_at":"2025-03-17T22:51:39.000000Z"},{"id":6148239,"change_date":"2023-08-30 21:45:00","inspection_id":"79496745","insp_unit_id":"196817676","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"204","insp_unit_license":"D595457","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9CF2451J1223246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:39.000000Z","updated_at":"2025-03-17T22:51:39.000000Z"}]},{"id":3522479,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","dot_number":"2086035","report_state":"MI","report_number":"FRIZS02762","insp_date":"2023-07-17 00:00:00","insp_start_time":"1050","insp_end_time":"1219","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-46 @ NCG CINAMA PARKING LOT","county_code_state":"MI","county_code":"057","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","viol_total":"14","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135675","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5431479,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097455","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39395A"},{"id":5431480,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097456","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39395F"},{"id":5431481,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097457","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39345D"},{"id":5431482,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097458","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39348A"},{"id":5431483,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097459","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39345B2"},{"id":5431484,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097460","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196032243","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4249915","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3963A1"},{"id":5431485,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097461","seq_no":"7","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"393104F3"},{"id":5431486,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097462","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39345B2"},{"id":5431487,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097463","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39347E"},{"id":5431488,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097464","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39353B"},{"id":5431489,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097465","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39347E"},{"id":5431490,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097466","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39347E"},{"id":5431491,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097467","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39347E"},{"id":5431492,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_violation_id":"254097468","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196032244","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5663772,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_unit_id":"196032243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"106","insp_unit_license":"RC10855","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X45J116091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"},{"id":5663773,"change_date":"2023-07-17 21:41:00","inspection_id":"79159286","insp_unit_id":"196032244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"221","insp_unit_license":"E310302","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5HTAB2521V7C60876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3323356,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","dot_number":"2086035","report_state":"MI","report_number":"LARSE03201","insp_date":"2023-06-19 00:00:00","insp_start_time":"0905","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N. DAGGET RD","county_code_state":"MI","county_code":"117","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1131275","transaction_code":"C","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:53.000000Z","updated_at":"2025-03-17T19:28:53.000000Z","inspection_violations":[{"id":5125835,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931695","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195884271","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4233918","created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3922"},{"id":5125836,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931696","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195884271","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39375G"},{"id":5125837,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931697","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195884271","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39375G"},{"id":5125838,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931698","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195884271","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4233918","created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3963A1"},{"id":5125839,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931699","seq_no":"5","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"2","insp_unit_id":"195884272","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"387303B4"},{"id":5125840,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931700","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195884272","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39347E"},{"id":5125841,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931701","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"195884272","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39353B"},{"id":5125842,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931702","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195884272","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39347E"},{"id":5125843,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_violation_id":"253931703","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195884272","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":5342403,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_unit_id":"195884271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"102","insp_unit_license":"BB26662","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDL40X4DJ358990","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"},{"id":5342404,"change_date":"2023-07-07 21:41:00","inspection_id":"78935739","insp_unit_id":"195884272","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TTTI","insp_unit_company":"203","insp_unit_license":"D787823","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T9FF2551M1223280","insp_unit_decal":"Y","insp_unit_decal_number":"000","created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":2436058,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","dot_number":"2086035","report_state":"MI","report_number":"POWEL03036","insp_date":"2023-02-21 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"213200","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114811","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[{"id":3750474,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302414","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193549054","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39347E"},{"id":3750475,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302415","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"193549054","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39353B"},{"id":3750476,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302416","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"193549054","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39347E"},{"id":3750477,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302417","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193549053","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39347E"},{"id":3750478,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302418","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"193549053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39353B"},{"id":3750479,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_violation_id":"251302419","seq_no":"6","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:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3920518,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_unit_id":"193549052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"114","insp_unit_license":"BD20715","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJABD14LPLX1967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"},{"id":3920519,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_unit_id":"193549053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"THRUW","insp_unit_company":null,"insp_unit_license":"E590303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA284XT1011598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"},{"id":3920520,"change_date":"2023-02-23 21:40:00","inspection_id":"77930261","insp_unit_id":"193549054","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"THRUW","insp_unit_company":null,"insp_unit_license":"E590304","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA2832T1011599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"}]},{"id":1458605,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","dot_number":"2086035","report_state":"MI","report_number":"MOREM04407","insp_date":"2022-10-05 00:00:00","insp_start_time":"1252","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GREEN ROAD REST AREA","county_code_state":"MI","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"237000","viol_total":"24","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"24","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097547","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:28.000000Z","updated_at":"2025-03-17T18:53:28.000000Z","inspection_violations":[{"id":2296314,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877586","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4132179","created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2296315,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877587","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39617C"},{"id":2296316,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877588","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2296317,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877589","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3939A"},{"id":2296318,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877590","seq_no":"5","part_no":"393","part_no_section":"83(f)","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39383F"},{"id":2296319,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877591","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191310353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39345D"},{"id":2296320,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877592","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2296321,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877593","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39617C"},{"id":2296322,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877594","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4132179","created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296323,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877595","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39353B"},{"id":2296324,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877596","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296325,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877597","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296326,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877598","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296327,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877599","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296328,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877600","seq_no":"15","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296329,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877601","seq_no":"16","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"191310354","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39375G"},{"id":2296330,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877602","seq_no":"17","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2296331,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877603","seq_no":"18","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39617C"},{"id":2296332,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877604","seq_no":"19","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296333,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877605","seq_no":"20","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39353B"},{"id":2296334,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877606","seq_no":"21","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296335,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877607","seq_no":"22","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2296336,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877608","seq_no":"23","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4132179","created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39348A"},{"id":2296337,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_violation_id":"248877609","seq_no":"24","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"191310355","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2348082,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_unit_id":"191310353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"103","insp_unit_license":"RC18477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJALD10JPJP8637","insp_unit_decal":"Y","insp_unit_decal_number":"31655521","created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2348083,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_unit_id":"191310354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"THRUW","insp_unit_company":"207","insp_unit_license":"E590303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA284XT1011598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"},{"id":2348084,"change_date":"2022-10-06 21:40:00","inspection_id":"76810731","insp_unit_id":"191310355","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"THRUW","insp_unit_company":null,"insp_unit_license":"E590304","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2T9FA2832T1011599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":660242,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","dot_number":"2086035","report_state":"MI","report_number":"BURGM04641","insp_date":"2022-06-16 00:00:00","insp_start_time":"1145","insp_end_time":"1247","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCOTT RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WILBUR-ELLIS","shipping_paper_number":"17726","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","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":"1080846","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:28.000000Z","updated_at":"2025-03-17T18:39:28.000000Z","inspection_violations":[{"id":1038756,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_violation_id":"246620409","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":"X4073367","created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"},{"id":1038757,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_violation_id":"246620410","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189379336","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"},{"id":1038758,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_violation_id":"246620411","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"189379334","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1061190,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_unit_id":"189379334","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"BENS","insp_unit_company":"847","insp_unit_license":"E457222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT48G6YMAS1238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"},{"id":1061191,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_unit_id":"189379335","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"109","insp_unit_license":"RB70279","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X4KD624109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"},{"id":1061192,"change_date":"2022-06-21 21:42:00","inspection_id":"75879775","insp_unit_id":"189379336","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":"846","insp_unit_license":"E457221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT48D7YMAS1237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:44.000000Z","updated_at":"2025-03-17T22:14:44.000000Z"}]},{"id":539686,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","dot_number":"2086035","report_state":"MI","report_number":"ROLLJ01820","insp_date":"2022-06-02 00:00:00","insp_start_time":"1057","insp_end_time":"1133","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 @ BUS 131","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"800000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078136","transaction_code":"C","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-03 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:06.000000Z","updated_at":"2025-03-17T18:37:06.000000Z","inspection_violations":[{"id":852196,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341341","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:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3922"},{"id":852197,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341342","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189152315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3939A"},{"id":852198,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341343","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189152315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3939A"},{"id":852199,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341344","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189152316","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39617C"},{"id":852200,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341345","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189152316","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39375C"},{"id":852201,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341346","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189152316","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3939A"},{"id":852202,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341347","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"3","insp_unit_id":"189152317","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"39617C"},{"id":852203,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_violation_id":"246341348","seq_no":"8","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"3","insp_unit_id":"189152317","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":868493,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_unit_id":"189152315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"106","insp_unit_license":"RC10855","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X45J11609","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"},{"id":868494,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_unit_id":"189152316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"211","insp_unit_license":"D451367","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DTP16L35MP030006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"},{"id":868495,"change_date":"2022-06-09 21:42:00","inspection_id":"75736525","insp_unit_id":"189152317","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"DORS","insp_unit_company":"212","insp_unit_license":"D451368","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DTP10C25MP030009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":265521,"change_date":"2022-06-09 21:42:00","inspection_id":"75409949","dot_number":"2086035","report_state":"MI","report_number":"FLOHC00339","insp_date":"2022-04-26 00:00:00","insp_start_time":"0935","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M66 @ 12 MILE RD","county_code_state":"MI","county_code":"133","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":"2022-04-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073550","transaction_code":"C","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-27 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:13.000000Z","updated_at":"2025-03-17T18:32:13.000000Z","inspection_violations":[{"id":408252,"change_date":"2022-06-09 21:42:00","inspection_id":"75409949","insp_violation_id":"246333389","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:00.000000Z","updated_at":"2025-03-17T21:09:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":429681,"change_date":"2022-06-09 21:42:00","inspection_id":"75409949","insp_unit_id":"189145315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB95903","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD49XX7J930406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"},{"id":429682,"change_date":"2022-06-09 21:42:00","inspection_id":"75409949","insp_unit_id":"189145316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":null,"insp_unit_license":"E457221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT48D7YMAS1237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"},{"id":429683,"change_date":"2022-06-09 21:42:00","inspection_id":"75409949","insp_unit_id":"189145317","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"BENS","insp_unit_company":null,"insp_unit_license":"E457222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT48G6YMAS1238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"}]},{"id":120189,"change_date":"2022-04-06 21:40:00","inspection_id":"75234472","dot_number":"2086035","report_state":"MI","report_number":"HUGHB02029","insp_date":"2022-04-04 00:00:00","insp_start_time":"0950","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"208000","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":"1070653","transaction_code":"A","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02086035","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-06 21:40:00","insp_carrier_name":"J MCGILL TRUCKING INC","insp_carrier_street":"8746 W POLK RD","insp_carrier_city":"SUMNER","insp_carrier_state":"MI","insp_carrier_zip_code":"48889","insp_colonia":null,"docket_number":"728017","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:46.000000Z","updated_at":"2025-03-17T18:29:46.000000Z","inspection_violations":[{"id":177551,"change_date":"2022-04-06 21:40:00","inspection_id":"75234472","insp_violation_id":"244996350","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:07:52.000000Z","updated_at":"2025-03-17T21:07:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":194515,"change_date":"2022-04-06 21:40:00","inspection_id":"75234472","insp_unit_id":"188016423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB70279","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X4KD624109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:23.000000Z","updated_at":"2025-03-17T22:09:23.000000Z"},{"id":194516,"change_date":"2022-04-06 21:40:00","inspection_id":"75234472","insp_unit_id":"188016424","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"C253707","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1A9AD2838BP432322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:23.000000Z","updated_at":"2025-03-17T22:09:23.000000Z"},{"id":194517,"change_date":"2022-04-06 21:40:00","inspection_id":"75234472","insp_unit_id":"188016425","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"C253708","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1A9AD283XBP432323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:23.000000Z","updated_at":"2025-03-17T22:09:23.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2086035\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2086035\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2086035\/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\/2086035\/inspections","per_page":100,"prev_page_url":null,"to":35,"total":35}