{"current_page":1,"data":[{"id":8067706,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","dot_number":"3878526","report_state":"TN","report_number":"I038950140","insp_date":"2025-03-08 00:00:00","insp_start_time":"1548","insp_end_time":"1650","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NIOTA TN","county_code_state":"TN","county_code":"107","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RED D ARC","shipping_paper_number":"12820128569","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-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1451434","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[{"id":12609172,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","insp_violation_id":"264915674","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"205705160","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3929A2C"},{"id":12609173,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","insp_violation_id":"264915675","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205705159","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"39360C"},{"id":12609174,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","insp_violation_id":"264915676","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":13026325,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","insp_unit_id":"205705159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"A520607","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"},{"id":13026326,"change_date":"2025-03-10 21:38:00","inspection_id":"84075037","insp_unit_id":"205705160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":"100","insp_unit_license":"159717A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"4Z1GF4026PS009805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:58.000000Z","updated_at":"2025-03-17T23:58:58.000000Z"}]},{"id":7697664,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","dot_number":"3878526","report_state":"NY","report_number":"SPD4050078","insp_date":"2025-01-17 00:00:00","insp_start_time":"1302","insp_end_time":"1407","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GEDDES NY","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SUNBELT RENTAL","shipping_paper_number":"2692608","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-01-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"44400","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281317","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2025-01-24 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:56.000000Z","updated_at":"2025-03-17T20:57:56.000000Z","inspection_violations":[{"id":12027181,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_violation_id":"264153021","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"S250035984","created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"38323A2LCDLN"},{"id":12027182,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_violation_id":"264153022","seq_no":"2","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"204984445","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39367C7VF"},{"id":12027183,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_violation_id":"264153023","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"204984445","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3939AHLLH"},{"id":12027184,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_violation_id":"264153024","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204984445","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":12421395,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_unit_id":"204984445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"A520607","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"},{"id":12421396,"change_date":"2025-01-24 21:39:00","inspection_id":"83686230","insp_unit_id":"204984446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"159718A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":7664590,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","dot_number":"3878526","report_state":"NY","report_number":"SPF3020492","insp_date":"2025-01-13 00:00:00","insp_start_time":"1240","insp_end_time":"1339","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"KINGSTON NY","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"12","oos_total":"5","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1269177","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[{"id":11974945,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084875","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39141AMCPC"},{"id":11974946,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084876","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3922SLLIFTA"},{"id":11974947,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084877","seq_no":"3","part_no":"393","part_no_section":"207C-SBML","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"393207CSBML"},{"id":11974948,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084878","seq_no":"4","part_no":"393","part_no_section":"207C-SBML","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"393207CSBML"},{"id":11974949,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084879","seq_no":"5","part_no":"393","part_no_section":"207C-SBML","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"393207CSBML"},{"id":11974950,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084880","seq_no":"6","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39355D1B"},{"id":11974951,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084881","seq_no":"7","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8F56JWVZKW","created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39375A3TAOL"},{"id":11974952,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084882","seq_no":"8","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39381H"},{"id":11974953,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084883","seq_no":"9","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8F56JWVZJC","created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39395A1"},{"id":11974954,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084884","seq_no":"10","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8F56JWVZH4","created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39395F"},{"id":11974955,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084885","seq_no":"11","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"204920428","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALLPL"},{"id":11974956,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_violation_id":"264084886","seq_no":"12","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"8F56JWVZCN","created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":12367716,"change_date":"2025-01-20 21:34:00","inspection_id":"83651626","insp_unit_id":"204920428","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"RWH9384","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GDJ7H1D1XJ852535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:29.000000Z","updated_at":"2025-03-17T23:51:29.000000Z"}]},{"id":7592589,"change_date":"2025-01-10 21:39:00","inspection_id":"83576001","dot_number":"3878526","report_state":"NC","report_number":"0006715766","insp_date":"2025-01-09 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"GRANVI","location_desc":"GRANVILLE COUNTY, I-85, N","county_code_state":"NC","county_code":"077","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RITCHIE BROS","shipping_paper_number":"4259","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-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2248797","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":"M","census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:42.000000Z","updated_at":"2025-03-17T20:55:42.000000Z","inspection_violations":[{"id":11869149,"change_date":"2025-01-10 21:39:00","inspection_id":"83576001","insp_violation_id":"263861214","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"204747002","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3300000","created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":12250727,"change_date":"2025-01-10 21:39:00","inspection_id":"83576001","insp_unit_id":"204747001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"A520608","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3C7WRTCL2PG528459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"},{"id":12250728,"change_date":"2025-01-10 21:39:00","inspection_id":"83576001","insp_unit_id":"204747002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COMM","insp_unit_company":null,"insp_unit_license":"159718A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"}]},{"id":7402537,"change_date":"2024-12-12 21:41:00","inspection_id":"83376360","dot_number":"3878526","report_state":"VA","report_number":"5233001973","insp_date":"2024-12-10 00:00:00","insp_start_time":"1319","insp_end_time":"1403","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ATKINS VA","county_code_state":"VA","county_code":"173","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"STAR BUILDING SYSTEMS","shipping_paper_number":"451670.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":"U","pen_cen_match":"I","final_status_date":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","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":"1150051","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:43.000000Z","updated_at":"2025-03-17T20:50:43.000000Z","inspection_violations":[{"id":11567490,"change_date":"2024-12-12 21:41:00","inspection_id":"83376360","insp_violation_id":"263415300","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204342816","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:19.000000Z","updated_at":"2025-03-17T22:02:19.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":11941766,"change_date":"2024-12-12 21:41:00","inspection_id":"83376360","insp_unit_id":"204342816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"A520607","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"Y","insp_unit_decal_number":"34607917","created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"},{"id":11941767,"change_date":"2024-12-12 21:41:00","inspection_id":"83376360","insp_unit_id":"204342817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":"100","insp_unit_license":"159717A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"4Z1GF4527P2015573","insp_unit_decal":"Y","insp_unit_decal_number":"34607918","created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"}]},{"id":6412513,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","dot_number":"3878526","report_state":"AL","report_number":"MBJP006174","insp_date":"2024-08-07 00:00:00","insp_start_time":"0740","insp_end_time":"0830","registration_date":"2024-08-09 00:00:00","region":"CT","ci_status_code":"C","location":"05","location_desc":"BAY MINETTE, AL","county_code_state":"AL","county_code":"003","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED RENTALS","shipping_paper_number":"5606391","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-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","viol_total":"4","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1017690","transaction_code":"C","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2024-08-07 21:41:00","snet_input_date":"2024-08-07 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-08-07 21:41:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"142223","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:54.000000Z","updated_at":"2025-03-17T20:29:54.000000Z","inspection_violations":[{"id":9956376,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_violation_id":"261108317","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:08.000000Z","updated_at":"2025-03-17T21:54:08.000000Z","normalized_code":"39524C2III"},{"id":9956377,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_violation_id":"261108318","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:08.000000Z","updated_at":"2025-03-17T21:54:08.000000Z","normalized_code":"3958E1"},{"id":9956378,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_violation_id":"261108319","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:08.000000Z","updated_at":"2025-03-17T21:54:08.000000Z","normalized_code":"3958E1"},{"id":9956379,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_violation_id":"261108320","seq_no":"4","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"202316234","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:54:08.000000Z","updated_at":"2025-03-17T21:54:08.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":10334504,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_unit_id":"202316233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"A520607","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"},{"id":10334505,"change_date":"2024-08-09 21:38:00","inspection_id":"82325307","insp_unit_id":"202316234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"100","insp_unit_license":"159717A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"4Z1GF4527P2015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:04.000000Z","updated_at":"2025-03-17T23:30:04.000000Z"}]},{"id":6215640,"change_date":"2024-07-15 21:41:00","inspection_id":"82114407","dot_number":"3878526","report_state":"UT","report_number":"24FT001044","insp_date":"2024-07-11 00:00:00","insp_start_time":"1040","insp_end_time":"1111","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"MONTICELLO UT","county_code_state":"UT","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","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-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","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":"653415","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:48.000000Z","updated_at":"2025-03-17T20:25:48.000000Z","inspection_violations":[{"id":9653915,"change_date":"2024-07-15 21:41:00","inspection_id":"82114407","insp_violation_id":"260635419","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"201879186","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:42.000000Z","updated_at":"2025-03-17T21:52:42.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":10014115,"change_date":"2024-07-15 21:41:00","inspection_id":"82114407","insp_unit_id":"201879186","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"1","insp_unit_license":"C712ER","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:45.000000Z","updated_at":"2025-03-17T23:26:45.000000Z"},{"id":10014116,"change_date":"2024-07-15 21:41:00","inspection_id":"82114407","insp_unit_id":"201879187","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"YPV092","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4527P2015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:45.000000Z","updated_at":"2025-03-17T23:26:45.000000Z"}]},{"id":5814601,"change_date":"2024-05-22 21:40:00","inspection_id":"81681246","dot_number":"3878526","report_state":"NY","report_number":"SPB3020079","insp_date":"2024-05-16 00:00:00","insp_start_time":"1107","insp_end_time":"1221","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TUPPER LAKE NY","county_code_state":"NY","county_code":null,"insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","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":"504828","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"267 LANGLEY DR #1218","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30046","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:54.000000Z","updated_at":"2025-03-17T20:17:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9364678,"change_date":"2024-05-22 21:40:00","inspection_id":"81681246","insp_unit_id":"201027562","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"C712ER","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:13.000000Z","updated_at":"2025-03-17T23:20:13.000000Z"},{"id":9364679,"change_date":"2024-05-22 21:40:00","inspection_id":"81681246","insp_unit_id":"201027563","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"YPV092","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:13.000000Z","updated_at":"2025-03-17T23:20:13.000000Z"}]},{"id":5805216,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","dot_number":"3878526","report_state":"NY","report_number":"SPB0362873","insp_date":"2024-05-15 00:00:00","insp_start_time":"2115","insp_end_time":"2201","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"WEBB BROTHERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","viol_total":"13","oos_total":"3","driver_viol_total":"8","driver_oos_total":"2","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2925183","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":"M","census_search_date":"2024-05-21 21:46:00","snet_input_date":"2024-05-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"267 LANGLEY DR #1218","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30046","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:51.000000Z","updated_at":"2025-03-17T20:17:51.000000Z","inspection_violations":[{"id":8992247,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637711","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3J20HTZ","created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3922"},{"id":8992248,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637712","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3958E1"},{"id":8992249,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637713","seq_no":"3","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3953A3I"},{"id":8992250,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637714","seq_no":"4","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3953A2"},{"id":8992251,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637715","seq_no":"5","part_no":"395","part_no_section":"22(h)(1)","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:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39522H1"},{"id":8992252,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637716","seq_no":"6","part_no":"395","part_no_section":"22(h)(2)","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:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39522H2"},{"id":8992253,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637717","seq_no":"7","part_no":"395","part_no_section":"22(h)(3)","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:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39522H3"},{"id":8992254,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637718","seq_no":"8","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:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39522H4"},{"id":8992255,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637719","seq_no":"9","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"201007179","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39021B"},{"id":8992256,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637720","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201007179","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39311"},{"id":8992257,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637721","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201007179","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39311"},{"id":8992258,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637722","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201007179","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3922"},{"id":8992259,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_violation_id":"259637723","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201007180","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9349579,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_unit_id":"201007179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"C712ER","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"},{"id":9349580,"change_date":"2024-05-21 21:46:00","inspection_id":"81670789","insp_unit_id":"201007180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"YPV092","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"}]},{"id":5540098,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","dot_number":"3878526","report_state":"TN","report_number":"I030H30320","insp_date":"2024-04-12 00:00:00","insp_start_time":"0902","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"KNXEN","location_desc":"KNOX COUNTY SCALES EB","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"04122024","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"38900","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1728389","transaction_code":"C","transaction_date":"2024-05-08 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2024-04-18 21:39:00","snet_input_date":"2024-04-12 00:00:00","source_office":"2TNS001","mcmis_add_date":"2024-04-18 21:39:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"267 LANGLEY DR #1218","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30046","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:42.000000Z","updated_at":"2025-05-11T10:15:38.000000Z","inspection_violations":[{"id":13596164,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","insp_violation_id":"266075526","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"M","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:21:01.000000Z","updated_at":"2025-05-10T11:35:32.000000Z","normalized_code":"39021TB2DOT"},{"id":13596165,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","insp_violation_id":"266075527","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:21:01.000000Z","updated_at":"2025-05-10T11:35:32.000000Z","normalized_code":"3958EHOSPD"},{"id":13596166,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","insp_violation_id":"266075528","seq_no":"3","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"206716103","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:21:01.000000Z","updated_at":"2025-05-10T11:35:32.000000Z","normalized_code":"393130BCHVE"}],"inspection_per_units":[{"id":13958384,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","insp_unit_id":"206716102","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2","insp_unit_license":"C505ES","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3C7WRTCL2PG528459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:32:55.000000Z","updated_at":"2025-05-11T03:21:24.000000Z"},{"id":13958385,"change_date":"2025-05-07 21:45:00","inspection_id":"81382762","insp_unit_id":"206716103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"100","insp_unit_license":"TV82K30","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"4Z1GF4026PS009805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:32:55.000000Z","updated_at":"2025-05-11T03:21:24.000000Z"}]},{"id":4359388,"change_date":"2023-11-06 21:41:00","inspection_id":"80090623","dot_number":"3878526","report_state":"AL","report_number":"1218000855","insp_date":"2023-11-06 00:00:00","insp_start_time":"1300","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AL","county_code":"039","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","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":"981650","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":"M","census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"2ALS001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"8798 LIZELIA ROAD","insp_carrier_city":"MERIDIAN","insp_carrier_state":"MS","insp_carrier_zip_code":"39305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:10.000000Z","updated_at":"2025-03-17T19:49:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7010927,"change_date":"2023-11-06 21:41:00","inspection_id":"80090623","insp_unit_id":"197916383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"C720EB","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:51.000000Z","updated_at":"2025-03-17T22:58:51.000000Z"},{"id":7010928,"change_date":"2023-11-06 21:41:00","inspection_id":"80090623","insp_unit_id":"197916384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"1","insp_unit_license":"YPV092","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:51.000000Z","updated_at":"2025-03-17T22:58:51.000000Z"}]},{"id":4083908,"change_date":"2023-09-28 21:41:00","inspection_id":"79786224","dot_number":"3878526","report_state":"SD","report_number":"0041008422","insp_date":"2023-09-26 00:00:00","insp_start_time":"1033","insp_end_time":"1103","registration_date":null,"region":"MT","ci_status_code":"C","location":"41","location_desc":"41","county_code_state":"SD","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"HYSTER-YALE GROUP INC","shipping_paper_number":"WLWHBE2358793","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59500","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":"652565","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":"M","census_search_date":"2023-09-28 21:41:00","snet_input_date":"2023-09-28 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-09-28 21:41:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"2135 GLEN PARKE COURT","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30044","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:36.000000Z","updated_at":"2025-03-17T19:43:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6566120,"change_date":"2023-09-28 21:41:00","inspection_id":"79786224","insp_unit_id":"197301707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"C720EB","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"Y","insp_unit_decal_number":"33133034","created_at":"2025-03-17T22:55:07.000000Z","updated_at":"2025-03-17T22:55:07.000000Z"},{"id":6566121,"change_date":"2023-09-28 21:41:00","inspection_id":"79786224","insp_unit_id":"197301708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"1","insp_unit_license":"YPV092","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4527PS015573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:07.000000Z","updated_at":"2025-03-17T22:55:07.000000Z"}]},{"id":3987610,"change_date":"2023-09-16 21:30:00","inspection_id":"79679000","dot_number":"3878526","report_state":"MO","report_number":"W102000040","insp_date":"2023-09-13 00:00:00","insp_start_time":"1342","insp_end_time":"1424","registration_date":null,"region":"CD","ci_status_code":"C","location":"A1N","location_desc":"PLATTE CITYMO","county_code_state":"MO","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"372577","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":"2023-09-16 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"38900","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":"54184","transaction_code":"A","transaction_date":"2023-09-16 00:00:00","upload_date":"2023-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2023-09-16 21:30:00","snet_input_date":"2023-09-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-09-16 21:30:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"267 LANGLEY DR #1218","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30046","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:37.000000Z","updated_at":"2025-03-17T19:41:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6411881,"change_date":"2023-09-16 21:30:00","inspection_id":"79679000","insp_unit_id":"197088474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"C202EK","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRTCL2PG528459","insp_unit_decal":"Y","insp_unit_decal_number":"33043482","created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"},{"id":6411882,"change_date":"2023-09-16 21:30:00","inspection_id":"79679000","insp_unit_id":"197088475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATOR TRAI","insp_unit_company":null,"insp_unit_license":"TV82K30","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4026PS009805","insp_unit_decal":"Y","insp_unit_decal_number":"33043484","created_at":"2025-03-17T22:53:51.000000Z","updated_at":"2025-03-17T22:53:51.000000Z"}]},{"id":3412490,"change_date":"2023-06-30 21:40:00","inspection_id":"79035732","dot_number":"3878526","report_state":"TN","report_number":"TBYT000624","insp_date":"2023-06-29 00:00:00","insp_start_time":"1131","insp_end_time":"1153","registration_date":null,"region":"CT","ci_status_code":"C","location":"57","location_desc":"PARKING AREA","county_code_state":"TN","county_code":"077","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"WOLF CREEK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"44400","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":"1657012","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2023-06-30 21:40:00","snet_input_date":"2023-06-30 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"2135 GLEN PARKE CT","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30044-6991","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:35.000000Z","updated_at":"2025-03-17T19:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5486504,"change_date":"2023-06-30 21:40:00","inspection_id":"79035732","insp_unit_id":"195780396","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"C720EB","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:17.000000Z","updated_at":"2025-03-17T22:46:17.000000Z"},{"id":5486505,"change_date":"2023-06-30 21:40:00","inspection_id":"79035732","insp_unit_id":"195780397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":null,"insp_unit_license":"TV82K30","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4026P9009805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:17.000000Z","updated_at":"2025-03-17T22:46:17.000000Z"}]},{"id":2849861,"change_date":"2023-04-20 21:42:00","inspection_id":"78400602","dot_number":"3878526","report_state":"KY","report_number":"CV44602595","insp_date":"2023-04-19 00:00:00","insp_start_time":"0954","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"9808","location_desc":"WALTON","county_code_state":"KY","county_code":"015","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"FRANKLIN INDUSTRIES","shipping_paper_number":"2084457","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-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"2160488","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":"M","census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-20 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"267 LANGLEY DR #1218","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30046","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:17.000000Z","updated_at":"2025-03-17T19:19:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4585719,"change_date":"2023-04-20 21:42:00","inspection_id":"78400602","insp_unit_id":"194491955","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"C720EB","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"Y","insp_unit_decal_number":"32724547","created_at":"2025-03-17T22:39:10.000000Z","updated_at":"2025-03-17T22:39:10.000000Z"},{"id":4585720,"change_date":"2023-04-20 21:42:00","inspection_id":"78400602","insp_unit_id":"194491956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"1","insp_unit_license":"TV82K30","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4026PS009805","insp_unit_decal":"Y","insp_unit_decal_number":"32724548","created_at":"2025-03-17T22:39:10.000000Z","updated_at":"2025-03-17T22:39:10.000000Z"}]},{"id":2511028,"change_date":"2023-03-30 21:40:00","inspection_id":"78015271","dot_number":"3878526","report_state":"TN","report_number":"TFEZ000064","insp_date":"2023-03-04 00:00:00","insp_start_time":"1448","insp_end_time":"1530","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"SHELBY DR","county_code_state":"TN","county_code":"157","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"UNIFORM STRAIGHT","shipping_paper_number":"041624288960313","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":"Y","pen_cen_match":"I","final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26400","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":"1633620","transaction_code":"C","transaction_date":"2023-03-04 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03878526","upload_search_indicator":null,"census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-06 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"MAGIC TRANSPORT LLC","insp_carrier_street":"2135 GLEN PARKE CT","insp_carrier_city":"LAWRENCEVILLE","insp_carrier_state":"GA","insp_carrier_zip_code":"30044-6991","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:56.000000Z","updated_at":"2025-03-17T19:12:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4041185,"change_date":"2023-03-30 21:40:00","inspection_id":"78015271","insp_unit_id":"194142610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"01","insp_unit_license":"C720EB","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"3C7WRNFL3NG299715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"},{"id":4041186,"change_date":"2023-03-30 21:40:00","inspection_id":"78015271","insp_unit_id":"194142611","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"01","insp_unit_license":"TV82K30","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"4Z1GF4026PS009805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3878526\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3878526\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3878526\/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\/3878526\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}