{"current_page":1,"data":[{"id":12436511,"change_date":"2026-07-13 21:40:00","inspection_id":"88395806","dot_number":"813455","report_state":"MI","report_number":"ZYLSJ01673","insp_date":"2026-07-13 00:00:00","insp_start_time":"1255","insp_end_time":"1315","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SS&E","shipping_paper_number":"4027","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3741726","transaction_code":"A","transaction_date":"2026-07-13 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2026-07-13 21:40:00","snet_input_date":"2026-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:37.000000Z","updated_at":"2026-07-24T09:31:13.000000Z","inspection_violations":[{"id":21650635,"change_date":"2026-07-13 21:40:00","inspection_id":"88395806","insp_violation_id":"275472382","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T10:00:32.000000Z","updated_at":"2026-07-24T09:44:45.000000Z","normalized_code":"39216D"},{"id":21650636,"change_date":"2026-07-13 21:40:00","inspection_id":"88395806","insp_violation_id":"275472383","seq_no":"2","part_no":"393","part_no_section":"104F4-C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T10:00:32.000000Z","updated_at":"2026-07-24T09:44:45.000000Z","normalized_code":"393104F4C"}],"inspection_per_units":[{"id":21603218,"change_date":"2026-07-13 21:40:00","inspection_id":"88395806","insp_unit_id":"214588642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2240","insp_unit_license":"RC27313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT6RN431143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:17:23.000000Z","updated_at":"2026-07-24T09:02:44.000000Z"},{"id":21603219,"change_date":"2026-07-13 21:40:00","inspection_id":"88395806","insp_unit_id":"214588643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"324001","insp_unit_license":"F058345","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5325RA073628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:17:23.000000Z","updated_at":"2026-07-24T09:02:44.000000Z"}]},{"id":10279681,"change_date":"2025-12-04 21:38:00","inspection_id":"86404335","dot_number":"813455","report_state":"MI","report_number":"HUGHB03375","insp_date":"2025-11-21 00:00:00","insp_start_time":"1245","insp_end_time":"1302","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US 31 & 12MM","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1251852","transaction_code":"C","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-24 21:39:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:49.000000Z","updated_at":"2025-12-08T10:30:41.000000Z","inspection_violations":[{"id":17322818,"change_date":"2025-12-04 21:38:00","inspection_id":"86404335","insp_violation_id":"270461694","seq_no":"1","part_no":"393","part_no_section":"11A1-LRLM","insp_viol_unit":"1","insp_unit_id":"210414166","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:14.000000Z","normalized_code":"39311A1LRLM"},{"id":17322819,"change_date":"2025-12-04 21:38:00","inspection_id":"86404335","insp_violation_id":"270461695","seq_no":"2","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"210414166","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:14.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":17292389,"change_date":"2025-12-04 21:38:00","inspection_id":"86404335","insp_unit_id":"210414166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC27313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT6RN431143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:28.000000Z","updated_at":"2025-12-08T10:00:50.000000Z"}]},{"id":10173016,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","dot_number":"813455","report_state":"IN","report_number":"1028900152","insp_date":"2025-11-06 00:00:00","insp_start_time":"0710","insp_end_time":"0817","registration_date":null,"region":"CS","ci_status_code":"C","location":"1394W","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"QUAILTY EDGE","shipping_paper_number":"19713","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"4","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":"2529917","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:32.000000Z","updated_at":"2025-11-16T10:30:18.000000Z","inspection_violations":[{"id":16893045,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_violation_id":"269874904","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"209962203","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:39.000000Z","normalized_code":"39345B2BAIR"},{"id":16893046,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_violation_id":"269874905","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209962203","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:39.000000Z","normalized_code":"39347E"},{"id":16893047,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_violation_id":"269874906","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"209962203","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:39.000000Z","normalized_code":"39353BB"},{"id":16893048,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_violation_id":"269874907","seq_no":"4","part_no":"395","part_no_section":"3A2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:39.000000Z","normalized_code":"3953A2HOSPD"}],"inspection_per_units":[{"id":16941005,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_unit_id":"209962202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2232","insp_unit_license":"RC17797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR4PN620889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:28.000000Z","updated_at":"2025-11-16T10:00:21.000000Z"},{"id":16941006,"change_date":"2025-11-12 21:40:00","inspection_id":"86292396","insp_unit_id":"209962203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"21405","insp_unit_license":"E876764","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA532XEA027576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:28.000000Z","updated_at":"2025-11-16T10:00:21.000000Z"}]},{"id":9959319,"change_date":"2025-10-16 21:40:00","inspection_id":"86067337","dot_number":"813455","report_state":"MS","report_number":"1009011563","insp_date":"2025-10-15 00:00:00","insp_start_time":"0911","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"71","location_desc":"TISHOMINGO COUNTY","county_code_state":"MS","county_code":"141","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1124975","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-15 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:42.000000Z","updated_at":"2025-10-20T10:00:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16535754,"change_date":"2025-10-16 21:40:00","inspection_id":"86067337","insp_unit_id":"209504119","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2202","insp_unit_license":"RB99642","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X9LD664068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:55.000000Z","updated_at":"2025-10-20T09:46:03.000000Z"},{"id":16535755,"change_date":"2025-10-16 21:40:00","inspection_id":"86067337","insp_unit_id":"209504120","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21222","insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:55.000000Z","updated_at":"2025-10-20T09:46:03.000000Z"}]},{"id":8792686,"change_date":"2025-06-02 21:39:00","inspection_id":"84838969","dot_number":"813455","report_state":"AL","report_number":"1332004376","insp_date":"2025-06-02 00:00:00","insp_start_time":"1109","insp_end_time":"1138","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FLORENCE AL","county_code_state":"AL","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1811995","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:25.000000Z","updated_at":"2025-06-06T10:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14388377,"change_date":"2025-06-02 21:39:00","inspection_id":"84838969","insp_unit_id":"207176440","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"RC17798","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"3HSPCAPR9PN619835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:24.000000Z","updated_at":"2025-06-06T09:45:25.000000Z"},{"id":14388378,"change_date":"2025-06-02 21:39:00","inspection_id":"84838969","insp_unit_id":"207176441","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"C407082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4826CA020897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:24.000000Z","updated_at":"2025-06-06T09:45:25.000000Z"}]},{"id":8754998,"change_date":"2025-05-28 21:43:00","inspection_id":"84798985","dot_number":"813455","report_state":"AL","report_number":"1332004361","insp_date":"2025-05-28 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FLORENCE AL","county_code_state":"AL","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"STEEL SUMMIT","shipping_paper_number":"95197","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1791770","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2025-05-28 21:43:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:34.000000Z","updated_at":"2025-06-01T10:00:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14320264,"change_date":"2025-05-28 21:43:00","inspection_id":"84798985","insp_unit_id":"207099720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2201","insp_unit_license":"RB99643","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X7LD664067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:50.000000Z","updated_at":"2025-06-01T09:47:21.000000Z"},{"id":14320265,"change_date":"2025-05-28 21:43:00","inspection_id":"84798985","insp_unit_id":"207099721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"2133","insp_unit_license":"C251742","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4820BA020098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:50.000000Z","updated_at":"2025-06-01T09:47:21.000000Z"}]},{"id":8757557,"change_date":"2025-05-28 21:43:00","inspection_id":"84801687","dot_number":"813455","report_state":"IL","report_number":"4290140008","insp_date":"2025-04-23 00:00:00","insp_start_time":"1636","insp_end_time":"1643","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80 E\/B","county_code_state":"IL","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-28 21:43:00","post_acc_ind":"Y","gross_comb_veh_wt":"80000","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":"2409062","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-05-28 21:43:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:37.000000Z","updated_at":"2025-06-01T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14324136,"change_date":"2025-05-28 21:43:00","inspection_id":"84801687","insp_unit_id":"207105851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2232","insp_unit_license":"RC17797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR4PN620889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:52.000000Z","updated_at":"2025-06-01T09:47:36.000000Z"}]},{"id":8437141,"change_date":"2025-04-22 21:41:00","inspection_id":"84464054","dot_number":"813455","report_state":"AL","report_number":"1332004268","insp_date":"2025-04-22 00:00:00","insp_start_time":"0825","insp_end_time":"0855","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FLORENCE AL","county_code_state":"AL","county_code":"077","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50500","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":"1628141","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:06.000000Z","updated_at":"2025-04-26T10:27:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13702927,"change_date":"2025-04-22 21:41:00","inspection_id":"84464054","insp_unit_id":"206428812","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2201","insp_unit_license":"RB99643","insp_unit_license_state":"AL","insp_unit_vehicle_id_number":"1XPBD49X7LD664067","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:08:45.000000Z","updated_at":"2025-04-26T09:57:56.000000Z"}]},{"id":8095857,"change_date":"2025-03-12 21:40:00","inspection_id":"84104609","dot_number":"813455","report_state":"MS","report_number":"1018011781","insp_date":"2025-03-11 00:00:00","insp_start_time":"1109","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":"T-95","location_desc":"IUKA SCALE US 72 WEST","county_code_state":"MS","county_code":"141","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1093529","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-12 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-17T21:06:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13071285,"change_date":"2025-03-12 21:40:00","inspection_id":"84104609","insp_unit_id":"205759000","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2202","insp_unit_license":"RB99542","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X9LD664068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"},{"id":13071286,"change_date":"2025-03-12 21:40:00","inspection_id":"84104609","insp_unit_id":"205759001","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"21222","insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"}]},{"id":7108223,"change_date":"2024-11-03 21:33:00","inspection_id":"83065715","dot_number":"813455","report_state":"TN","report_number":"I3A0370024","insp_date":"2024-11-01 00:00:00","insp_start_time":"1010","insp_end_time":"1031","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ARDMORE TN","county_code_state":"TN","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"74923","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":"2024-11-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"1015753","transaction_code":"A","transaction_date":"2024-11-03 00:00:00","upload_date":"2024-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2024-11-03 21:33:00","snet_input_date":"2024-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-03 21:33:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:16.000000Z","updated_at":"2025-03-17T20:44:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11464525,"change_date":"2024-11-03 21:33:00","inspection_id":"83065715","insp_unit_id":"203709743","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2202","insp_unit_license":"RB99642","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X9LD664068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"},{"id":11464526,"change_date":"2024-11-03 21:33:00","inspection_id":"83065715","insp_unit_id":"203709744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"}]},{"id":10576694,"change_date":"2026-01-06 21:39:00","inspection_id":"86714884","dot_number":"813455","report_state":"TN","report_number":"I037B31010","insp_date":"2024-10-24 00:00:00","insp_start_time":"0601","insp_end_time":"0615","registration_date":null,"region":"CT","ci_status_code":"C","location":"UNK","location_desc":"GILES COUNTY SCALE","county_code_state":"TN","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"73137","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1779430","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-24 00:00:00","source_office":"2TNS001","mcmis_add_date":"2026-01-06 21:39:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:29.000000Z","updated_at":"2026-01-17T10:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17726169,"change_date":"2026-01-06 21:39:00","inspection_id":"86714884","insp_unit_id":"210928398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2202","insp_unit_license":"RB9964","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X9LD664068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:52.000000Z"},{"id":17726170,"change_date":"2026-01-06 21:39:00","inspection_id":"86714884","insp_unit_id":"210928399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:52.000000Z"}]},{"id":6842967,"change_date":"2024-09-28 21:34:00","inspection_id":"82783895","dot_number":"813455","report_state":"TN","report_number":"I039581084","insp_date":"2024-09-27 00:00:00","insp_start_time":"0720","insp_end_time":"0751","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ARDMORE TN","county_code_state":"TN","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"STEEL SUMMIT","shipping_paper_number":"70607","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"894148","transaction_code":"A","transaction_date":"2024-09-28 00:00:00","upload_date":"2024-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2024-09-28 21:34:00","snet_input_date":"2024-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-28 21:34:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:58.000000Z","updated_at":"2025-03-17T20:38:58.000000Z","inspection_violations":[{"id":10658622,"change_date":"2024-09-28 21:34:00","inspection_id":"82783895","insp_violation_id":"262084596","seq_no":"1","part_no":"393","part_no_section":"47(f)","insp_viol_unit":"2","insp_unit_id":"203175768","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARN","created_at":"2025-03-17T21:57:35.000000Z","updated_at":"2025-03-17T21:57:35.000000Z","normalized_code":"39347F"}],"inspection_per_units":[{"id":11035176,"change_date":"2024-09-28 21:34:00","inspection_id":"82783895","insp_unit_id":"203175767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2202","insp_unit_license":"RB99642","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X9LD664068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:18.000000Z","updated_at":"2025-03-17T23:37:18.000000Z"},{"id":11035177,"change_date":"2024-09-28 21:34:00","inspection_id":"82783895","insp_unit_id":"203175768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:18.000000Z","updated_at":"2025-03-17T23:37:18.000000Z"}]},{"id":6805719,"change_date":"2024-09-24 21:41:00","inspection_id":"82744441","dot_number":"813455","report_state":"AL","report_number":"BCCV009442","insp_date":"2024-09-24 00:00:00","insp_start_time":"0512","insp_end_time":"0544","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"083","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGIC STEEL","shipping_paper_number":"70236","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-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130500","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":"1024617","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-24 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:11.000000Z","updated_at":"2025-03-17T20:38:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10974650,"change_date":"2024-09-24 21:41:00","inspection_id":"82744441","insp_unit_id":"203102259","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2200","insp_unit_license":"RB99644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X5LD664066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"},{"id":10974651,"change_date":"2024-09-24 21:41:00","inspection_id":"82744441","insp_unit_id":"203102260","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21143","insp_unit_license":"C251741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4822BA020099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"}]},{"id":6631977,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","dot_number":"813455","report_state":"MI","report_number":"WARRJ02651","insp_date":"2024-08-28 00:00:00","insp_start_time":"1255","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BAY CITY REST AREA (SB I75)","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"182495","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-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192850","transaction_code":"C","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10315472,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","insp_violation_id":"261873688","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202986927","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3939A"},{"id":10315473,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","insp_violation_id":"261873689","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202986928","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39347E"},{"id":10315474,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","insp_violation_id":"261873690","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202986928","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10692342,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","insp_unit_id":"202986927","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"223","insp_unit_license":"RC17797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR4PN620889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10692343,"change_date":"2024-09-17 21:46:00","inspection_id":"82559377","insp_unit_id":"202986928","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":null,"insp_unit_license":"C596190","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5321EA027577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6555491,"change_date":"2024-08-26 21:41:00","inspection_id":"82477712","dot_number":"813455","report_state":"IN","report_number":"9761002494","insp_date":"2024-08-22 00:00:00","insp_start_time":"1107","insp_end_time":"1155","registration_date":null,"region":"ED","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPRING VALLEY","shipping_paper_number":"0147235","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"780435","transaction_code":"A","transaction_date":"2024-08-25 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:49.000000Z","updated_at":"2025-03-17T20:32:49.000000Z","inspection_violations":[{"id":10185760,"change_date":"2024-08-26 21:41:00","inspection_id":"82477712","insp_violation_id":"261390251","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202569491","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"39375A3"},{"id":10185761,"change_date":"2024-08-26 21:41:00","inspection_id":"82477712","insp_violation_id":"261390252","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202569491","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10568161,"change_date":"2024-08-26 21:41:00","inspection_id":"82477712","insp_unit_id":"202569491","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2232","insp_unit_license":"RC17797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR4PN620889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:28.000000Z","updated_at":"2025-03-17T23:32:28.000000Z"},{"id":10568162,"change_date":"2024-08-26 21:41:00","inspection_id":"82477712","insp_unit_id":"202569492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"21425","insp_unit_license":"C676694","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5321EA028258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:28.000000Z","updated_at":"2025-03-17T23:32:28.000000Z"}]},{"id":6227911,"change_date":"2024-07-23 21:42:00","inspection_id":"82127681","dot_number":"813455","report_state":"AL","report_number":"BCCV009269","insp_date":"2024-07-16 00:00:00","insp_start_time":"0753","insp_end_time":"0827","registration_date":"2024-07-23 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"103","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"STEEL SUMMIT","shipping_paper_number":"62785","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"130500","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":"1014001","transaction_code":"C","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-16 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-07-16 21:43:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:12.000000Z","updated_at":"2025-03-17T20:26:12.000000Z","inspection_violations":[{"id":9676041,"change_date":"2024-07-23 21:42:00","inspection_id":"82127681","insp_violation_id":"260792071","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:48.000000Z","updated_at":"2025-03-17T21:52:48.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10034323,"change_date":"2024-07-23 21:42:00","inspection_id":"82127681","insp_unit_id":"202020908","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2200","insp_unit_license":"RB99644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X5LD664066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:57.000000Z","updated_at":"2025-03-17T23:26:57.000000Z"},{"id":10034324,"change_date":"2024-07-23 21:42:00","inspection_id":"82127681","insp_unit_id":"202020909","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"0903","insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:57.000000Z","updated_at":"2025-03-17T23:26:57.000000Z"}]},{"id":6024721,"change_date":"2024-06-19 21:37:00","inspection_id":"81909050","dot_number":"813455","report_state":"TN","report_number":"I3A0860316","insp_date":"2024-06-13 00:00:00","insp_start_time":"0559","insp_end_time":"0615","registration_date":null,"region":"CD","ci_status_code":"C","location":"GILEN","location_desc":"ARDMORE TN","county_code_state":"TN","county_code":"055","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"STEEL SUMMIT","shipping_paper_number":"59500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"132500","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":"582477","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2024-06-19 21:37:00","snet_input_date":"2024-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-19 21:37:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:13.000000Z","updated_at":"2025-03-17T20:22:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9703707,"change_date":"2024-06-19 21:37:00","inspection_id":"81909050","insp_unit_id":"201481153","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2200","insp_unit_license":"RB99644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X5LD664066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:32.000000Z","updated_at":"2025-03-17T23:23:32.000000Z"},{"id":9703708,"change_date":"2024-06-19 21:37:00","inspection_id":"81909050","insp_unit_id":"201481154","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"21222","insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:32.000000Z","updated_at":"2025-03-17T23:23:32.000000Z"}]},{"id":5201411,"change_date":"2024-03-14 21:41:00","inspection_id":"81012900","dot_number":"813455","report_state":"AL","report_number":"BCCV008951","insp_date":"2024-03-04 00:00:00","insp_start_time":"1034","insp_end_time":"1112","registration_date":"2024-03-14 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"079","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MAGIC STEEL","shipping_paper_number":"48635","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"994365","transaction_code":"C","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:43.000000Z","updated_at":"2025-03-17T20:05:43.000000Z","inspection_violations":[{"id":8019054,"change_date":"2024-03-14 21:41:00","inspection_id":"81012900","insp_violation_id":"258378822","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:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3922"},{"id":8019055,"change_date":"2024-03-14 21:41:00","inspection_id":"81012900","insp_violation_id":"258378823","seq_no":"2","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":8374998,"change_date":"2024-03-14 21:41:00","inspection_id":"81012900","insp_unit_id":"199909331","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2200","insp_unit_license":"RB99644","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPBD49X5LD664066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"},{"id":8374999,"change_date":"2024-03-14 21:41:00","inspection_id":"81012900","insp_unit_id":"199909332","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21222","insp_unit_license":"C407083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"}]},{"id":5144869,"change_date":"2024-02-27 21:39:00","inspection_id":"80951640","dot_number":"813455","report_state":"MI","report_number":"BURGM99596","insp_date":"2024-02-26 00:00:00","insp_start_time":"1230","insp_end_time":"1251","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COOPER RD","county_code_state":"MI","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGIC STEEL SALES","shipping_paper_number":"48814","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"1166517","transaction_code":"A","transaction_date":"2024-02-26 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-27 21:39:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:32.000000Z","updated_at":"2025-03-17T20:04:32.000000Z","inspection_violations":[{"id":7933556,"change_date":"2024-02-27 21:39:00","inspection_id":"80951640","insp_violation_id":"258061225","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:44:19.000000Z","updated_at":"2025-03-17T21:44:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8283785,"change_date":"2024-02-27 21:39:00","inspection_id":"80951640","insp_unit_id":"199621267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2240","insp_unit_license":"RC27313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT6RN431143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"},{"id":8283786,"change_date":"2024-02-27 21:39:00","inspection_id":"80951640","insp_unit_id":"199621268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21153","insp_unit_license":"C251737","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4820BA020103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:03.000000Z","updated_at":"2025-03-17T23:10:03.000000Z"}]},{"id":4987836,"change_date":"2024-02-06 21:42:00","inspection_id":"80779981","dot_number":"813455","report_state":"MI","report_number":"RODRR02474","insp_date":"2024-02-05 00:00:00","insp_start_time":"1205","insp_end_time":"1305","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 WB @ M-104","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"GRR837809-1-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":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"1163310","transaction_code":"A","transaction_date":"2024-02-05 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:37.000000Z","updated_at":"2025-03-17T20:01:37.000000Z","inspection_violations":[{"id":7681884,"change_date":"2024-02-06 21:42:00","inspection_id":"80779981","insp_violation_id":"257687152","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":"X4306467","created_at":"2025-03-17T21:43:07.000000Z","updated_at":"2025-03-17T21:43:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8027683,"change_date":"2024-02-06 21:42:00","inspection_id":"80779981","insp_unit_id":"199290199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2240","insp_unit_license":"RC27313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT6RN431143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"},{"id":8027684,"change_date":"2024-02-06 21:42:00","inspection_id":"80779981","insp_unit_id":"199290200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"C330425","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4846CA021579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:45.000000Z","updated_at":"2025-03-17T23:07:45.000000Z"}]},{"id":4885596,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","dot_number":"813455","report_state":"MI","report_number":"MOREM04988","insp_date":"2024-01-23 00:00:00","insp_start_time":"1306","insp_end_time":"1324","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I69 0VERPASS","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"QUALITY EDGE","shipping_paper_number":"14342","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-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1161387","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:36.000000Z","updated_at":"2025-03-17T19:59:36.000000Z","inspection_violations":[{"id":7527576,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","insp_violation_id":"257455911","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3922"},{"id":7527577,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","insp_violation_id":"257455912","seq_no":"2","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"39522H4"},{"id":7527578,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","insp_violation_id":"257455913","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:20.000000Z","updated_at":"2025-03-17T21:42:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7860925,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","insp_unit_id":"199073094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2232","insp_unit_license":"RC17797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR4PN620889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"},{"id":7860926,"change_date":"2024-01-23 21:45:00","inspection_id":"80668024","insp_unit_id":"199073095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"C676693","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA532XEA028257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:16.000000Z","updated_at":"2025-03-17T23:06:16.000000Z"}]},{"id":3824083,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","dot_number":"813455","report_state":"MI","report_number":"LARSE03305","insp_date":"2023-08-23 00:00:00","insp_start_time":"1320","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SARANAC REST AREA","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STEEL SUPPLY AND ENGINEERING","shipping_paper_number":"23-1-115","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1142432","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":"00813455","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":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","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":5903730,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","insp_violation_id":"254985987","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196814807","insp_violation_category_id":"14","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":5903731,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","insp_violation_id":"254985988","seq_no":"2","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"196814808","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":"393110B"},{"id":5903732,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","insp_violation_id":"254985989","seq_no":"3","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"2","insp_unit_id":"196814808","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4264766","created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393100C"}],"inspection_per_units":[{"id":6148336,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","insp_unit_id":"196814807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2240","insp_unit_license":"RC27313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT6RN431143","insp_unit_decal":"Y","insp_unit_decal_number":"33003184","created_at":"2025-03-17T22:51:39.000000Z","updated_at":"2025-03-17T22:51:39.000000Z"},{"id":6148337,"change_date":"2023-08-30 21:44:00","inspection_id":"79496814","insp_unit_id":"196814808","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"323006","insp_unit_license":"E840534","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5322PA067461","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":2944289,"change_date":"2023-05-02 21:40:00","inspection_id":"78507553","dot_number":"813455","report_state":"MI","report_number":"RODRR02118","insp_date":"2023-05-01 00:00:00","insp_start_time":"1357","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-45 EB @ 128TH AVE","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"1124352","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-02 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:21.000000Z","updated_at":"2025-03-17T19:21:21.000000Z","inspection_violations":[{"id":4520295,"change_date":"2023-05-02 21:40:00","inspection_id":"78507553","insp_violation_id":"252570155","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:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4737426,"change_date":"2023-05-02 21:40:00","inspection_id":"78507553","insp_unit_id":"194703162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2235","insp_unit_license":"RC23043","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPT7PN639688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"},{"id":4737427,"change_date":"2023-05-02 21:40:00","inspection_id":"78507553","insp_unit_id":"194703163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"C300684","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5081CA020778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:21.000000Z","updated_at":"2025-03-17T22:40:21.000000Z"}]},{"id":2818005,"change_date":"2023-04-17 21:41:00","inspection_id":"78364787","dot_number":"813455","report_state":"MI","report_number":"WARRJ02114","insp_date":"2023-04-14 00:00:00","insp_start_time":"0900","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"350P4","location_desc":"SWARTZ CREEK REST AREA(I69 EB)","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"QUALITY EDGE","shipping_paper_number":"11986","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1122183","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:34.000000Z","updated_at":"2025-03-17T19:18:34.000000Z","inspection_violations":[{"id":4323960,"change_date":"2023-04-17 21:41:00","inspection_id":"78364787","insp_violation_id":"252259486","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194422044","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:13.000000Z","updated_at":"2025-03-17T21:27:13.000000Z","normalized_code":"3922"},{"id":4323961,"change_date":"2023-04-17 21:41:00","inspection_id":"78364787","insp_violation_id":"252259487","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"194422045","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:13.000000Z","updated_at":"2025-03-17T21:27:13.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":4535480,"change_date":"2023-04-17 21:41:00","inspection_id":"78364787","insp_unit_id":"194422044","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"230","insp_unit_license":"RC14393","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPCAPR9PN373207","insp_unit_decal":"Y","insp_unit_decal_number":"32661153","created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"},{"id":4535481,"change_date":"2023-04-17 21:41:00","inspection_id":"78364787","insp_unit_id":"194422045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21405","insp_unit_license":"C596189","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA532XEA027576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:46.000000Z","updated_at":"2025-03-17T22:38:46.000000Z"}]},{"id":1647017,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","dot_number":"813455","report_state":"MI","report_number":"SCIBA02029","insp_date":"2022-10-31 00:00:00","insp_start_time":"1250","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BLUE HERON DR","county_code_state":"MI","county_code":"139","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1100492","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[{"id":2584742,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","insp_violation_id":"249369100","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748104","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"},{"id":2584743,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","insp_violation_id":"249369101","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748104","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"},{"id":2584744,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","insp_violation_id":"249369102","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748104","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"},{"id":2584745,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","insp_violation_id":"249369103","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191748104","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2650091,"change_date":"2022-11-01 21:40:00","inspection_id":"77027837","insp_unit_id":"191748104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2063","insp_unit_license":"RB78083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD49X06J107845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:11.000000Z","updated_at":"2025-03-17T22:25:11.000000Z"}]},{"id":660584,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","dot_number":"813455","report_state":"MI","report_number":"RODRR01815","insp_date":"2022-06-21 00:00:00","insp_start_time":"0830","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FAIRVIEW AVE NB @ MAIN AVE","county_code_state":"MI","county_code":"139","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"169327","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"131200","viol_total":"10","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1080835","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","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":1039317,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621103","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3922"},{"id":1039318,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621104","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4071653","created_at":"2025-03-17T21:11:50.000000Z","updated_at":"2025-03-17T21:11:50.000000Z","normalized_code":"3963A1"},{"id":1039319,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621105","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039320,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621106","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"16","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":"39353B"},{"id":1039321,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621107","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039322,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621108","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039323,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621109","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039324,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621110","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039325,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621111","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"},{"id":1039326,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_violation_id":"246621112","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189380007","insp_violation_category_id":"15","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":"39347E"}],"inspection_per_units":[{"id":1061760,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_unit_id":"189380007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2125","insp_unit_license":"RA19398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPHD49X3CD160951","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":1061761,"change_date":"2022-06-21 21:42:00","inspection_id":"75880154","insp_unit_id":"189380008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"81202","insp_unit_license":"C300684","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5081CA020778","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":289401,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","dot_number":"813455","report_state":"IN","report_number":"4956019525","insp_date":"2022-04-28 00:00:00","insp_start_time":"1053","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"5570W","location_desc":"#55  I-70 WB  WAYNE","county_code_state":"IN","county_code":"177","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"OHIO MULCH","shipping_paper_number":"8191573","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":"I","final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"2126630","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-29 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:35.000000Z","updated_at":"2025-03-17T18:32:35.000000Z","inspection_violations":[{"id":451262,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480755","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":"165340661","created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3922"},{"id":451263,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480756","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188426925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39021TB"},{"id":451264,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480757","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188426925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3939A"},{"id":451265,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480758","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188426925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3965B"},{"id":451266,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480759","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188426925","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39347E"},{"id":451267,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_violation_id":"245480760","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188426925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":468294,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_unit_id":"188426925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2110","insp_unit_license":"RA62984","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKAD49X4BJ296433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"},{"id":468295,"change_date":"2022-04-29 21:41:00","inspection_id":"75438620","insp_unit_id":"188426926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"E188905","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTBE2128L1003366","insp_unit_decal":"Y","insp_unit_decal_number":"31395864","created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"}]},{"id":146162,"change_date":"2022-06-09 21:42:00","inspection_id":"75267226","dot_number":"813455","report_state":"MI","report_number":"BRADD00610","insp_date":"2022-04-07 00:00:00","insp_start_time":"0820","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"28TH ST","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1070944","transaction_code":"C","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:08.000000Z","updated_at":"2025-03-17T18:30:08.000000Z","inspection_violations":[{"id":215993,"change_date":"2022-06-09 21:42:00","inspection_id":"75267226","insp_violation_id":"246329314","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":236721,"change_date":"2022-06-09 21:42:00","inspection_id":"75267226","insp_unit_id":"189142235","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2124","insp_unit_license":"RA19395","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPHD49X5CD160949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"}]},{"id":60164,"change_date":"2022-03-29 21:42:00","inspection_id":"75161941","dot_number":"813455","report_state":"MS","report_number":"U033006632","insp_date":"2022-03-29 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":"057","location_desc":"W\/B E OF FULTON","county_code_state":"MS","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"MAGIC STEEL","shipping_paper_number":"93580-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"958603","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-29 00:00:00","source_office":"2MSS002","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":97525,"change_date":"2022-03-29 21:42:00","inspection_id":"75161941","insp_unit_id":"187867941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2220","insp_unit_license":"RC04204","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSPAAPR4NN610186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:50.000000Z","updated_at":"2025-03-17T22:08:50.000000Z"},{"id":97526,"change_date":"2022-03-29 21:42:00","inspection_id":"75161941","insp_unit_id":"187867942","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"21202","insp_unit_license":"C407081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA4828CA020898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:50.000000Z","updated_at":"2025-03-17T22:08:50.000000Z"}]},{"id":19846,"change_date":"2022-03-22 21:31:00","inspection_id":"75106859","dot_number":"813455","report_state":"MI","report_number":"PENNJ00551","insp_date":"2022-03-21 00:00:00","insp_start_time":"1920","insp_end_time":"2000","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGIC STEEL SALES LLC","shipping_paper_number":"23590","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-22 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1068674","transaction_code":"A","transaction_date":"2022-03-21 00:00:00","upload_date":"2022-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00813455","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-22 21:31:00","insp_carrier_name":"MAGIC TRANSPORTATION COMPANY INC","insp_carrier_street":"5757 CLAY AVENUE SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49548","insp_colonia":null,"docket_number":"361445","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:48.000000Z","updated_at":"2025-03-17T18:27:48.000000Z","inspection_violations":[{"id":27520,"change_date":"2022-03-22 21:31:00","inspection_id":"75106859","insp_violation_id":"244702992","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"187754917","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:15.000000Z","updated_at":"2025-03-17T21:07:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":31991,"change_date":"2022-03-22 21:31:00","inspection_id":"75106859","insp_unit_id":"187754916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2125","insp_unit_license":"RA19398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPHD49X3CD160951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"},{"id":31992,"change_date":"2022-03-22 21:31:00","inspection_id":"75106859","insp_unit_id":"187754917","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"C300684","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MAPA5081CA020778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:27.000000Z","updated_at":"2025-03-17T22:08:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/813455\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/813455\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/813455\/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\/813455\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}