{"count":50,"carriers":[{"dot_number":"62291","legal_name":"MAGIC TRANSPORT INC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"220 EASTLAND DR S","phy_city":"TWIN FALLS","phy_state":"ID","phy_zip":"83301","phy_country":"US","phone":"2087337033","mc_number":"MC-140150","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":7,"total_drivers":5,"total_cdl":5,"mcs150_mileage":309000,"mcs150_mileage_year":"2020","mcs150_date":"20211112 1239","add_date":"19740601","officer_1":"ROBERT L. FRANKLIN, III","officer_2":"HOLLACE CLAIBORN","fleet_size_class":"D","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:35:37","updated_at":"2026-05-16 01:35:37"},{"dot_number":"276043","legal_name":"MAGIC TRANSPORT INC","dba_name":"","entity_type":"OTHER-APPLYING FOR MC","operating_status":"OTHER-APPLYING FOR MC","phy_street":"220 EASTLAND DRIVE SOUTH","phy_city":"TWIN FALLS","phy_state":"ID","phy_zip":"83301","phy_country":"US","phone":"2087337174","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":4,"total_drivers":7,"total_cdl":0,"mcs150_mileage":391000,"mcs150_mileage_year":"2003","mcs150_date":"20040330 2042","add_date":"19860714","officer_1":"ROBERT L. FRANKLIN III","officer_2":"","fleet_size_class":"C","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:36:51","updated_at":"2026-05-16 01:36:51"},{"dot_number":"299491","legal_name":"MAGIC TRANSPORT INC","dba_name":"","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"221 W MARQUETTE ST","phy_city":"OTTAWA","phy_state":"IL","phy_zip":"61350-1913","phy_country":"US","phone":"","mc_number":"MC-201331","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19870814","officer_1":"","officer_2":"","fleet_size_class":"0","business_type":"CORPORATION","duns_number":"617029004","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:36:52","updated_at":"2026-05-16 01:36:52"},{"dot_number":"441134","legal_name":"689786 ONTARIO INC","dba_name":"MAGIC TRANSPORTATION","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"594740 CTY ROAD 59 SOUTH","phy_city":"WOODSTOCK","phy_state":"ON","phy_zip":"N4S 7V8","phy_country":"CA","phone":"5194567320","mc_number":"MC-238830","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":13,"total_drivers":14,"total_cdl":14,"mcs150_mileage":600141,"mcs150_mileage_year":"2025","mcs150_date":"20250318 1013","add_date":"19910328","officer_1":"JEFF VANRYSWYCK","officer_2":"JIM LANGEVELD","fleet_size_class":"F","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:38:17","updated_at":"2026-05-16 01:38:17"},{"dot_number":"510332","legal_name":"SAMRAAT TRANSPORT INC","dba_name":"MAGIC TRANSPORTATION","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"2111 GEER RD  SUITE 214 & 216","phy_city":"TURLOCK","phy_state":"CA","phy_zip":"95380","phy_country":"US","phone":"2096327548","mc_number":"MC-293727","mc_number_2":"MC-260891","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":34,"total_drivers":45,"total_cdl":15,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19930125","officer_1":"","officer_2":"","fleet_size_class":"L","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:38:42","updated_at":"2026-05-16 01:38:42"},{"dot_number":"554338","legal_name":"MAGIC TRANSPORTATION INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"2567 MORGAN LAKE DRIVE","phy_city":"MARIETTA","phy_state":"GA","phy_zip":"30066","phy_country":"US","phone":"7705650753","mc_number":"MC-273599","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":198000,"mcs150_mileage_year":"2009","mcs150_date":"20090824 1448","add_date":"19940323","officer_1":"APRIL GALLAGHER","officer_2":"JEFF GALLAGHER","fleet_size_class":"A","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C;B","source":"census","ingested_at":"2026-05-16 01:39:07","updated_at":"2026-05-16 01:39:07"},{"dot_number":"662752","legal_name":"MAGIC TRANSPORTATION SERVICES INC","dba_name":"","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"3801 WHITEHALL ST","phy_city":"JACKSONVILLE","phy_state":"FL","phy_zip":"32206","phy_country":"US","phone":"9043561000","mc_number":"MC-310222","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":15,"total_drivers":50,"total_cdl":50,"mcs150_mileage":2617888,"mcs150_mileage_year":"2000","mcs150_date":"20011105 0000","add_date":"19961011","officer_1":"","officer_2":"","fleet_size_class":"G","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:39:53","updated_at":"2026-05-16 01:39:53"},{"dot_number":"696915","legal_name":"MAGIC TRANSPORT ENTERPRISES CORP","dba_name":"","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"2632 SKAN CT","phy_city":"ORLANDO","phy_state":"FL","phy_zip":"32839","phy_country":"US","phone":"4074254367","mc_number":"MC-322841","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":4,"total_drivers":5,"total_cdl":5,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20030520 0000","add_date":"19970708","officer_1":"","officer_2":"","fleet_size_class":"C","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:14","updated_at":"2026-05-16 01:40:14"},{"dot_number":"729847","legal_name":"KARL R JONES","dba_name":"BLACK MAGIC TRANSIT","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"6551 BOCK RD","phy_city":"OXON HILL","phy_state":"MD","phy_zip":"20745","phy_country":"US","phone":"3018392495","mc_number":"MC-333934","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":2,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19980212","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:30","updated_at":"2026-05-16 01:40:30"},{"dot_number":"754857","legal_name":"NICOLAS TORO ANACLETO & MARIA DOLORES TORO","dba_name":"MAGIC TRANSPORT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"8729 BREEZY BROWN","phy_city":"LAS VEGAS","phy_state":"NV","phy_zip":"89143","phy_country":"US","phone":"7028122323","mc_number":"MC-341186","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":56459,"mcs150_mileage_year":"2024","mcs150_date":"20250319 0000","add_date":"19980618","officer_1":"NICOLAS TORO ANACLETO","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:30","updated_at":"2026-05-16 01:40:30"},{"dot_number":"813455","legal_name":"MAGIC TRANSPORTATION COMPANY INC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"5757 CLAY AVENUE SW","phy_city":"GRAND RAPIDS","phy_state":"MI","phy_zip":"49548","phy_country":"US","phone":"6165321333","mc_number":"MC-361445","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":23,"total_drivers":16,"total_cdl":16,"mcs150_mileage":773304,"mcs150_mileage_year":"2024","mcs150_date":"20250326 1140","add_date":"19990603","officer_1":"GREG DEMULL","officer_2":"","fleet_size_class":"I","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:55","updated_at":"2026-05-16 01:40:55"},{"dot_number":"833698","legal_name":"DANIEL S FARSON","dba_name":"MOUNTAIN MAGIC TRANSPORTATION","entity_type":"OTHER-APPLYING FOR MC","operating_status":"OTHER-APPLYING FOR MC","phy_street":"5481 RIVERDALE LN","phy_city":"THORNTON","phy_state":"CO","phy_zip":"80229","phy_country":"US","phone":"3032546754","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":2,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20030808 0000","add_date":"19991018","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:41:23","updated_at":"2026-05-16 01:41:23"},{"dot_number":"854685","legal_name":"LIKE MAGIC TRANSPORTATION INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"9800 HIRSCH ROAD","phy_city":"HOUSTON","phy_state":"TX","phy_zip":"77016","phy_country":"US","phone":"2819142193","mc_number":"MC-377482","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":44000,"mcs150_mileage_year":"2007","mcs150_date":"20150526 1655","add_date":"20000211","officer_1":"MARGARET ROBERTS","officer_2":"DANIEL ROBERTS JR","fleet_size_class":"A","business_type":"","duns_number":"168818362","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:41:24","updated_at":"2026-05-16 01:41:24"},{"dot_number":"929648","legal_name":"JAMES BAPTIST","dba_name":"MAGIC TRANSPORTATION","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"4257 WEST WILCOX","phy_city":"CHICAGO","phy_state":"IL","phy_zip":"60624","phy_country":"US","phone":"7737226293","mc_number":"MC-400363","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"20010130","officer_1":"","officer_2":"","fleet_size_class":"0","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:42:11","updated_at":"2026-05-16 01:42:11"},{"dot_number":"1052170","legal_name":"JIM HEINEN","dba_name":"MAGIC TRANSFER","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"616 N 5TH ST #8","phy_city":"LIVINGSTON","phy_state":"MT","phy_zip":"59047","phy_country":"US","phone":"4065813971","mc_number":"MC-439903","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":100000,"mcs150_mileage_year":"2018","mcs150_date":"20191004 2201","add_date":"20020903","officer_1":"JIM HEINEN","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:43:10","updated_at":"2026-05-16 01:43:10"},{"dot_number":"1266662","legal_name":"1559875 ONTARIO LIMITED","dba_name":"MAGIC TRANSPORT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"486 BLVD BRAZEAU","phy_city":"NEW LISKEARD","phy_state":"ON","phy_zip":"P0J 1P0","phy_country":"CA","phone":"7056794135","mc_number":"MC-495219","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2024","mcs150_date":"20250730 0000","add_date":"20040714","officer_1":"JOSEE AM MATTEAU","officer_2":"MARIO DENOMME","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:11","updated_at":"2026-05-16 01:44:11"},{"dot_number":"1320074","legal_name":"MAGIC TRANSPORTATION INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"55 COLUMBO AVE","phy_city":"COPIAGUE","phy_state":"NY","phy_zip":"11726","phy_country":"US","phone":"6316088234","mc_number":"MC-507070","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":2,"total_drivers":1,"total_cdl":1,"mcs150_mileage":500000,"mcs150_mileage_year":"2011","mcs150_date":"20111128 1049","add_date":"20050110","officer_1":"BETH KINGSBURY","officer_2":"KATARZYNA BAGINSKI","fleet_size_class":"B","business_type":"","duns_number":"180674249","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"1320074","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:25","updated_at":"2026-05-16 01:44:25"},{"dot_number":"1607412","legal_name":"MAGIC TRANSPORT INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE;OTHER-594412","operating_status":"AUTHORIZED FOR HIRE;OTHER-594412","phy_street":"#2 WEAVER STREET STE  #206","phy_city":"FALL RIVER","phy_state":"MA","phy_zip":"02720","phy_country":"US","phone":"5086753134","mc_number":"MC-594412","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":5,"total_drivers":0,"total_cdl":0,"mcs150_mileage":480000,"mcs150_mileage_year":"2008","mcs150_date":"20100816 0000","add_date":"20070214","officer_1":"PENNI ILGES","officer_2":"","fleet_size_class":"C","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:46:42","updated_at":"2026-05-16 01:46:42"},{"dot_number":"1704737","legal_name":"MAGIC TRANSPORTS LLC","dba_name":"MAGIC TRANSPORTS","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"61310 TIMBERBEND DRIVE","phy_city":"LACOMBE","phy_state":"LA","phy_zip":"70445","phy_country":"US","phone":"5044213673","mc_number":"MC-625654","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2010","mcs150_date":"20110720 0000","add_date":"20071102","officer_1":"MERLIN HAYDEL","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:17","updated_at":"2026-05-16 01:47:17"},{"dot_number":"1717620","legal_name":"JAMAAL BEHNETT ALI","dba_name":"MAGIC TRANSPORTATION LLC","entity_type":"OTHER-UNAUTHORIZ","operating_status":"OTHER-UNAUTHORIZ","phy_street":"1029 SOUTH 8TH ST","phy_city":"CAMDEN","phy_state":"NJ","phy_zip":"08103","phy_country":"US","phone":"8563620672","mc_number":"MC-629932","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":2000,"mcs150_mileage_year":"2007","mcs150_date":"20071214 1528","add_date":"20071214","officer_1":"JAMAAL BEHNETT ALI","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:17","updated_at":"2026-05-16 01:47:17"},{"dot_number":"1750039","legal_name":"MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"1434 W 2450 S","phy_city":"WOODS CROSS","phy_state":"UT","phy_zip":"84087","phy_country":"US","phone":"8016048486","mc_number":"MC-1557357","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":111000,"mcs150_mileage_year":"2024","mcs150_date":"20250528 1640","add_date":"20080318","officer_1":"JABES M DE JESUS CABRERA","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:57","updated_at":"2026-05-16 01:47:57"},{"dot_number":"1836527","legal_name":"BEATRIZ A CASTRO","dba_name":"MAGIC TRANSPORT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"810 S MINNESOTA AVE  APT #1","phy_city":"ALTON","phy_state":"TX","phy_zip":"78573","phy_country":"US","phone":"9565298718","mc_number":"MC-665742","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":3,"total_drivers":3,"total_cdl":3,"mcs150_mileage":19213,"mcs150_mileage_year":"2010","mcs150_date":"20120725 0000","add_date":"20081209","officer_1":"BEATRIZ A CASTRO","officer_2":"BEATRIZ A CASTRO","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:48:25","updated_at":"2026-05-16 01:48:25"},{"dot_number":"1885945","legal_name":"AZTECA MAGIC TRANSPORT INC","dba_name":"AZTECA MAGIC TRANSPORT & ZALDIVAR TRUCKING","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"502 BROADMOOR AVE","phy_city":"LA PUENTE","phy_state":"CA","phy_zip":"91744","phy_country":"US","phone":"6263360645","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":3,"total_drivers":2,"total_cdl":2,"mcs150_mileage":52000,"mcs150_mileage_year":"2023","mcs150_date":"20240917 1843","add_date":"20090505","officer_1":"FERNANDO ZALDIVAR HUERTA","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:48:43","updated_at":"2026-05-16 01:48:43"},{"dot_number":"2194511","legal_name":"KEITH JEWELL","dba_name":"MAGIC TRANSPORTATION","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"7709 ST ANDREWS CHURCH RD","phy_city":"LOUISVILLE","phy_state":"KY","phy_zip":"40214","phy_country":"US","phone":"5029351071","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20110927 0000","add_date":"20110921","officer_1":"KEITH JEWELL","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:01","updated_at":"2026-05-16 01:51:01"},{"dot_number":"2223266","legal_name":"MARINDA MOORE","dba_name":"MAGIC TRANSPORTATION","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"2515 GOLDSMITH LN","phy_city":"LOUISVILLE","phy_state":"KY","phy_zip":"40218","phy_country":"US","phone":"5024598545","mc_number":"MC-322048","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"20111119","officer_1":"","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"B","source":"census","ingested_at":"2026-05-16 01:51:02","updated_at":"2026-05-16 01:51:02"},{"dot_number":"2268374","legal_name":"MAGIC TRANSPORT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"142509 COUNTY ROAD L","phy_city":"MERRILL","phy_state":"WI","phy_zip":"54452","phy_country":"US","phone":"7152183967","mc_number":"MC-774510","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":2,"mcs150_mileage":59709,"mcs150_mileage_year":"2024","mcs150_date":"20250304 1155","add_date":"20120131","officer_1":"MICHAEL GILE","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:15","updated_at":"2026-05-16 01:51:15"},{"dot_number":"2341212","legal_name":"BLUE MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"PRIVATE PASSENGER, BUSINESS;PRIVATE PASSENGER, NON-BUSINESS","operating_status":"PRIVATE PASSENGER, BUSINESS;PRIVATE PASSENGER, NON-BUSINESS","phy_street":"1113 SOUTH WEBSTER AVENUE","phy_city":"SCRANTON","phy_state":"PA","phy_zip":"18505","phy_country":"US","phone":"5708710711","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20120910 1508","add_date":"20120910","officer_1":"THOMAS RICE","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:48","updated_at":"2026-05-16 01:51:48"},{"dot_number":"2377377","legal_name":"AUTOMAGIC LLC","dba_name":"AUTOMAGIC TRANSPORT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"104 INDUSTRIAL PARK DR STE B","phy_city":"CUMMING","phy_state":"GA","phy_zip":"30040","phy_country":"US","phone":"6784565303","mc_number":"MC-817301","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":1,"total_drivers":2,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20140122 0000","add_date":"20130210","officer_1":"JACOB LAMM","officer_2":"MARK FRIESEMAN","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:06","updated_at":"2026-05-16 01:52:06"},{"dot_number":"2389466","legal_name":"MAGIC TRANSPORT HORSE RESCUE","dba_name":"","entity_type":"EXEMPT FOR HIRE","operating_status":"EXEMPT FOR HIRE","phy_street":"4076 HUMMINGBIRD LN","phy_city":"STEVENSVILLE","phy_state":"MT","phy_zip":"59870","phy_country":"US","phone":"4062409370","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":3,"total_cdl":1,"mcs150_mileage":100,"mcs150_mileage_year":"2013","mcs150_date":"20130321 0000","add_date":"20130321","officer_1":"SUSANN WILSON","officer_2":"NATHAN WILSON","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:07","updated_at":"2026-05-16 01:52:07"},{"dot_number":"2402826","legal_name":"MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"20440 SCHOOLCRAFT","phy_city":"DETROIT","phy_state":"MI","phy_zip":"48223","phy_country":"US","phone":"3136753158","mc_number":"MC-826502","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20130503 1514","add_date":"20130503","officer_1":"ALI HESSI","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:30","updated_at":"2026-05-16 01:52:30"},{"dot_number":"2420503","legal_name":"MAGIC TRANSPORT","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"6640 PEARL RD UNIT 606","phy_city":"PARMA HTS","phy_state":"OH","phy_zip":"44130","phy_country":"US","phone":"2162440360","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":25,"total_drivers":25,"total_cdl":25,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20130924 0000","add_date":"20130710","officer_1":"JASON SWAIN","officer_2":"ALEX ZAYTSEV","fleet_size_class":"J","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:31","updated_at":"2026-05-16 01:52:31"},{"dot_number":"2424984","legal_name":"MAGIC TRANS INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"3371 GLENDALE BLVD # 429","phy_city":"LOS ANGELES","phy_state":"CA","phy_zip":"90039","phy_country":"US","phone":"3235331664","mc_number":"MC-835519","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":3,"total_drivers":3,"total_cdl":3,"mcs150_mileage":300343,"mcs150_mileage_year":"2021","mcs150_date":"20220603 1116","add_date":"20130726","officer_1":"ARAM GRIGORYAN","officer_2":"MARINE JUKHYAN","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:31","updated_at":"2026-05-16 01:52:31"},{"dot_number":"2434955","legal_name":"PURE MAGIC TRANSPORTATION","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"9814 LAWNDALE","phy_city":"KANSAS CITY","phy_state":"MO","phy_zip":"64137","phy_country":"US","phone":"8168240808","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20130904 1512","add_date":"20130904","officer_1":"MARCUS PRYOR","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:31","updated_at":"2026-05-16 01:52:31"},{"dot_number":"2497115","legal_name":"MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"1827 VINTAGE DR","phy_city":"EASTON","phy_state":"PA","phy_zip":"18045","phy_country":"US","phone":"7325984818","mc_number":"MC-865311","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20140418 1016","add_date":"20140417","officer_1":"MACIEJ CURLEJ","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:53:05","updated_at":"2026-05-16 01:53:05"},{"dot_number":"2564624","legal_name":"SP MAGIC TRANSPORT INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"356 SUMPTER ST APT 2","phy_city":"BROOKLYN","phy_state":"NY","phy_zip":"11233","phy_country":"US","phone":"9292560655","mc_number":"MC-895347","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2013","mcs150_date":"20141211 1553","add_date":"20141211","officer_1":"ODWANE CAMPBELL","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:53:25","updated_at":"2026-05-16 01:53:25"},{"dot_number":"2786496","legal_name":"FARDOWSA ABDULLAHI","dba_name":"MAGIC TRANSIT","entity_type":"PRIVATE PASSENGER, NON-BUSINESS;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PASSENGER, NON-BUSINESS;AUTHORIZED FOR HIRE","phy_street":"2871 CHESFIELD DR","phy_city":"COLUMBUS","phy_state":"OH","phy_zip":"43204","phy_country":"US","phone":"6144460300","mc_number":"MC-928721","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20150827 1736","add_date":"20150730","officer_1":"FARDOWASA ABDULLAHI","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:54:49","updated_at":"2026-05-16 01:54:49"},{"dot_number":"3006204","legal_name":"MAGIC TRANSPORT AND RECOVERY LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"300 EAGLE CT","phy_city":"STOCKBRIDGE","phy_state":"GA","phy_zip":"30281","phy_country":"US","phone":"2154502566","mc_number":"MC-26695","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"Y","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2016","mcs150_date":"20171222 1239","add_date":"20170510","officer_1":"MICHAEL MASON","officer_2":"TAHLID MASON","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:56:56","updated_at":"2026-05-16 01:56:56"},{"dot_number":"3018914","legal_name":"GLOBAL MAGIC TRANSPORTATION INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"2023 MIFFLIN ST","phy_city":"PHILADELPHIA","phy_state":"PA","phy_zip":"19145","phy_country":"US","phone":"8569127700","mc_number":"MC-33253","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":0,"total_drivers":4,"total_cdl":2,"mcs150_mileage":1,"mcs150_mileage_year":"2017","mcs150_date":"20170829 1731","add_date":"20170616","officer_1":"MICHAEL LEESE","officer_2":"SAUL LANDERS","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:56:56","updated_at":"2026-05-16 01:56:56"},{"dot_number":"3019345","legal_name":"BLUE MAGIC TRANSPORT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"22 FAIRWAY BLVD APT D","phy_city":"COLUMBUS","phy_state":"OH","phy_zip":"43213","phy_country":"US","phone":"6142864591","mc_number":"MC-33476","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20180521 0000","add_date":"20170618","officer_1":"BRIAN K HARRIS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:56:56","updated_at":"2026-05-16 01:56:56"},{"dot_number":"3122689","legal_name":"MAGIC TRANS LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1251 N EDDY ST SUITE 200","phy_city":"NORTH BEND","phy_state":"IN","phy_zip":"46617","phy_country":"US","phone":"5642354168","mc_number":"MC-88855","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2024","mcs150_date":"20250714 1334","add_date":"20180412","officer_1":"VICTOR MARDARI","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":2.71,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:57:38","updated_at":"2026-05-16 01:57:38"},{"dot_number":"3154587","legal_name":"BLACK MAGIC TRUCKING","dba_name":"BLACK MAGIC INC|BLACK MAGIC INCORPORATED|BLACK MAGIC TRUCKING|BLACK MAGIC TRANSPORTATION|BLACK MAGIC","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE;EXEMPT FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE;EXEMPT FOR HIRE","phy_street":"2018 1/2 TULARE ST","phy_city":"SELMA","phy_state":"CA","phy_zip":"93662","phy_country":"US","phone":"5598199649","mc_number":"MC-106888","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":5,"total_cdl":3,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20180627 2217","add_date":"20180627","officer_1":"JARNAIL SINGH SANDHU","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:57:50","updated_at":"2026-05-16 01:57:50"},{"dot_number":"3199789","legal_name":"BLUE MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1201 PICKEREL CIR","phy_city":"ORLANDO","phy_state":"FL","phy_zip":"32839","phy_country":"US","phone":"4072886464","mc_number":"MC-164930","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20181012 1344","add_date":"20181012","officer_1":"LATASHA MARIA WRIGHT","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:58:04","updated_at":"2026-05-16 01:58:04"},{"dot_number":"3212906","legal_name":"BLUE MAGIC TRANSPORTATION LLC","dba_name":"","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"262 BLACK POLK RD","phy_city":"PRENTISS","phy_state":"MS","phy_zip":"39474-3151","phy_country":"US","phone":"6012976946","mc_number":"MC-1004028","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":1,"total_drivers":2,"total_cdl":2,"mcs150_mileage":1,"mcs150_mileage_year":"2020","mcs150_date":"20211022 1109","add_date":"20181115","officer_1":"THOMAS HATHORN","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:58:05","updated_at":"2026-05-16 01:58:05"},{"dot_number":"3261359","legal_name":"BLACK MAGIC TRANSPORT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1035 INDIAN CREEK TRL","phy_city":"DALLAS","phy_state":"TX","phy_zip":"75241-1930","phy_country":"US","phone":"2149371321","mc_number":"MC-1075031","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"Y","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":104000,"mcs150_mileage_year":"2025","mcs150_date":"20260122 2006","add_date":"20190320","officer_1":"TOBY MCGILBRA","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:58:41","updated_at":"2026-05-16 01:58:41"},{"dot_number":"3378509","legal_name":"MAGIC TRANSPORTATION AND FREIGHT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1816 E WOOD LN","phy_city":"MT PROSPECT","phy_state":"IL","phy_zip":"60056","phy_country":"US","phone":"8474090222","mc_number":"MC-1083983","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20200107 1058","add_date":"20200107","officer_1":"RICHARD J WOLNIK JR.","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"B","source":"census","ingested_at":"2026-05-16 01:59:19","updated_at":"2026-05-16 01:59:19"},{"dot_number":"3395985","legal_name":"MAGIC TRANSPORT INC","dba_name":"MAGIC LOGISTICS","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"13286 VANTAGE WAY","phy_city":"JACKSONVILLE","phy_state":"FL","phy_zip":"32218","phy_country":"US","phone":"7876751353","mc_number":"MC-1102471","mc_number_2":"FF-37167","mc_number_3":"","carrier_operation":"","hm_indicator":"Y","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20231012 1138","add_date":"20200214","officer_1":"JORGE MANGUAL","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"F","source":"census","ingested_at":"2026-05-16 01:59:36","updated_at":"2026-05-16 01:59:36"},{"dot_number":"3447980","legal_name":"BAYOU MAGIC TRANSPORT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"282 FRANCIS RD","phy_city":"DOWNSVILLE","phy_state":"LA","phy_zip":"71234","phy_country":"US","phone":"3183814925","mc_number":"MC-996535","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":90000,"mcs150_mileage_year":"2025","mcs150_date":"20260315 0934","add_date":"20200701","officer_1":"BOBBY B BORDELON","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:59:56","updated_at":"2026-05-16 01:59:56"},{"dot_number":"3452220","legal_name":"BLU MAGIC TRANSPORT LLC","dba_name":"BLU MAGIC TRANSPORT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"8661 CASTLEMILL CIR","phy_city":"NOTTINGHAM","phy_state":"MD","phy_zip":"21236","phy_country":"US","phone":"4102413748","mc_number":"MC-1124249","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2021","mcs150_date":"20221206 0000","add_date":"20200710","officer_1":"RICKEY A GRYCE","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:59:56","updated_at":"2026-05-16 01:59:56"},{"dot_number":"3579889","legal_name":"MAGIC TRANSPORTS LLC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"16405 E 99TH AVE","phy_city":"COMMERCE CITY","phy_state":"CO","phy_zip":"80022","phy_country":"US","phone":"3035024190","mc_number":"MC-1208849","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1000,"mcs150_mileage_year":"2022","mcs150_date":"20231031 0000","add_date":"20210302","officer_1":"ROLANDO GUTIERREZ","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 02:00:52","updated_at":"2026-05-16 02:00:52"},{"dot_number":"3692094","legal_name":"MAGIC TRANSPORT LLC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"14701 WESTPARK DR","phy_city":"HOUSTON","phy_state":"TX","phy_zip":"77082","phy_country":"US","phone":"8328881558","mc_number":"MC-1508274","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"Y","power_units":2,"total_drivers":2,"total_cdl":2,"mcs150_mileage":186558,"mcs150_mileage_year":"2024","mcs150_date":"20241204 0000","add_date":"20210802","officer_1":"ARMANDO PLANCARTE","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 02:01:49","updated_at":"2026-05-16 02:01:49"}]}