{"current_page":1,"data":[{"id":3738284,"change_date":"2023-10-23 21:42:00","inspection_id":"79401164","dot_number":"3122689","report_state":"WA","report_number":"W626000110","insp_date":"2023-08-12 00:00:00","insp_start_time":"1320","insp_end_time":"1415","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"SB","county_code_state":"WA","county_code":"001","insp_level_id":"2","service_center":"WE","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-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2586558","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:33.000000Z","updated_at":"2025-03-17T19:36:33.000000Z","inspection_violations":[{"id":5765499,"change_date":"2023-10-23 21:42:00","inspection_id":"79401164","insp_violation_id":"255992096","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197701548","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:43.000000Z","updated_at":"2025-03-17T21:33:43.000000Z","normalized_code":"3922"},{"id":5765500,"change_date":"2023-10-23 21:42:00","inspection_id":"79401164","insp_violation_id":"255992097","seq_no":"3","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"197701548","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:43.000000Z","updated_at":"2025-03-17T21:33:43.000000Z","normalized_code":"37611D1"},{"id":5765501,"change_date":"2023-10-23 21:42:00","inspection_id":"79401164","insp_violation_id":"255992098","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197701548","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:43.000000Z","updated_at":"2025-03-17T21:33:43.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6011177,"change_date":"2023-10-23 21:42:00","inspection_id":"79401164","insp_unit_id":"197701548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"101","insp_unit_license":"TEMP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X8PJ251079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"}]},{"id":3273620,"change_date":"2023-06-13 21:42:00","inspection_id":"78879378","dot_number":"3122689","report_state":"IA","report_number":"000P136NGZ","insp_date":"2023-06-09 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 60NB BY SHELDON, IA","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NUTRIEN AG SOLUTIONS","shipping_paper_number":"ST25411172","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1278411","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:44.000000Z","updated_at":"2025-03-17T19:27:44.000000Z","inspection_violations":[{"id":5047622,"change_date":"2023-06-13 21:42:00","inspection_id":"78879378","insp_violation_id":"253474564","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195472170","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39021TB"},{"id":5047623,"change_date":"2023-06-13 21:42:00","inspection_id":"78879378","insp_violation_id":"253474565","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195472170","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1HIL23060909033","created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5263570,"change_date":"2023-06-13 21:42:00","inspection_id":"78879378","insp_unit_id":"195472170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"400A","insp_unit_license":"98624RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X5NJ125940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5263571,"change_date":"2023-06-13 21:42:00","inspection_id":"78879378","insp_unit_id":"195472171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1520","insp_unit_license":"01263AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0626FW703172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"}]},{"id":3195495,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","dot_number":"3122689","report_state":"WA","report_number":"W709011373","insp_date":"2023-05-31 00:00:00","insp_start_time":"0414","insp_end_time":"0450","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"STANWOOD","county_code_state":"WA","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"PURE LINE","shipping_paper_number":"22-2330","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2574538","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2023-10-17 21:42:00","snet_input_date":"2023-06-01 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-06-01 21:43:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:08.000000Z","updated_at":"2025-03-17T19:26:08.000000Z","inspection_violations":[{"id":4922891,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_violation_id":"255992122","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197701587","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3939A"},{"id":4922892,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_violation_id":"255992123","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197701586","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3922"},{"id":4922893,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_violation_id":"255992124","seq_no":"3","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"197701586","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"37611D1"},{"id":4922894,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_violation_id":"255992125","seq_no":"4","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:56.000000Z","updated_at":"2025-03-17T21:29:56.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":5139983,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_unit_id":"197701586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RP09822","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X4PJ254592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"},{"id":5139984,"change_date":"2023-10-23 21:42:00","inspection_id":"78791350","insp_unit_id":"197701587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"01263AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0626FW703172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"}]},{"id":3133106,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","dot_number":"3122689","report_state":"UT","report_number":"23FE000221","insp_date":"2023-05-24 00:00:00","insp_start_time":"0712","insp_end_time":"0747","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"I-15 NB","county_code_state":"UT","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"USFS-PHOENIX","shipping_paper_number":"20019292","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-06-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"883754","transaction_code":"C","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":"2023-06-05 21:43:00","snet_input_date":"2023-05-24 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-05-24 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4822812,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_violation_id":"253289422","seq_no":"1","part_no":"395","part_no_section":"30(b)(1)","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:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39530B1"},{"id":4822813,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_violation_id":"253289423","seq_no":"2","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:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39524C2III"},{"id":4822814,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_violation_id":"253289424","seq_no":"3","part_no":"395","part_no_section":"24(c)(2)(ii)","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:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39524C2II"},{"id":4822815,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_violation_id":"253289425","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195322069","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"C178339925","created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39360C"},{"id":4822816,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_violation_id":"253289426","seq_no":"5","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"195322069","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"C178339925","created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":5039397,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_unit_id":"195322069","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"400","insp_unit_license":"98624RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X5NJ125940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:43.000000Z","updated_at":"2025-03-17T22:42:43.000000Z"},{"id":5039398,"change_date":"2023-06-05 21:43:00","inspection_id":"78720716","insp_unit_id":"195322070","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1520","insp_unit_license":"01263AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0626FW703172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:43.000000Z","updated_at":"2025-03-17T22:42:43.000000Z"}]},{"id":3007051,"change_date":"2023-05-09 21:43:00","inspection_id":"78578567","dot_number":"3122689","report_state":"CA","report_number":"ND64006612","insp_date":"2023-04-30 00:00:00","insp_start_time":"1025","insp_end_time":"1049","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS J.P.O.E. C.V.E.F.","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WELLS","shipping_paper_number":"750546229","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14893443","transaction_code":"A","transaction_date":"2023-04-30 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":"N\/A","created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[{"id":4619747,"change_date":"2023-05-09 21:43:00","inspection_id":"78578567","insp_violation_id":"252733618","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194844561","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4838466,"change_date":"2023-05-09 21:43:00","inspection_id":"78578567","insp_unit_id":"194844561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHT 412","insp_unit_license":"98232RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X7NJ145332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"},{"id":4838467,"change_date":"2023-05-09 21:43:00","inspection_id":"78578567","insp_unit_id":"194844562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT 3946","insp_unit_license":"A4895871","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GR1A062XPW503946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":2840061,"change_date":"2023-04-19 21:42:00","inspection_id":"78389654","dot_number":"3122689","report_state":"KY","report_number":"CV42253786","insp_date":"2023-04-18 00:00:00","insp_start_time":"1235","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"9813","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"HORMEL","shipping_paper_number":"705901","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-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2160197","transaction_code":"A","transaction_date":"2023-04-19 00:00:00","upload_date":"2023-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-19 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-04-19 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:14.000000Z","updated_at":"2025-03-17T19:19:14.000000Z","inspection_violations":[{"id":4357488,"change_date":"2023-04-19 21:42:00","inspection_id":"78389654","insp_violation_id":"252314389","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"194471741","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"EH55305","created_at":"2025-03-17T21:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"39375A"},{"id":4357489,"change_date":"2023-04-19 21:42:00","inspection_id":"78389654","insp_violation_id":"252314390","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"EH55305","created_at":"2025-03-17T21:27:20.000000Z","updated_at":"2025-03-17T21:27:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4570580,"change_date":"2023-04-19 21:42:00","inspection_id":"78389654","insp_unit_id":"194471741","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"JD36UD","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLDR1JSHU5009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:03.000000Z","updated_at":"2025-03-17T22:39:03.000000Z"},{"id":4570581,"change_date":"2023-04-19 21:42:00","inspection_id":"78389654","insp_unit_id":"194471742","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5312","insp_unit_license":"56990AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2537N2691717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:03.000000Z","updated_at":"2025-03-17T22:39:03.000000Z"}]},{"id":2799406,"change_date":"2023-04-13 21:43:00","inspection_id":"78343539","dot_number":"3122689","report_state":"MI","report_number":"MORRS00640","insp_date":"2023-04-12 00:00:00","insp_start_time":"1305","insp_end_time":"1332","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SOUTHBOUND","county_code_state":"MI","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1121870","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4296013,"change_date":"2023-04-13 21:43:00","inspection_id":"78343539","insp_violation_id":"252210408","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4192047","created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"},{"id":4296014,"change_date":"2023-04-13 21:43:00","inspection_id":"78343539","insp_violation_id":"252210409","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4505508,"change_date":"2023-04-13 21:43:00","inspection_id":"78343539","insp_unit_id":"194375424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"77134RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH4KN204164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"},{"id":4505509,"change_date":"2023-04-13 21:43:00","inspection_id":"78343539","insp_unit_id":"194375425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"591369ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1TTF532C1F3856715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2685934,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","dot_number":"3122689","report_state":"IA","report_number":"000TT688DH","insp_date":"2023-03-23 00:00:00","insp_start_time":"0738","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 NB","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CLAAS PARTS","shipping_paper_number":"11290","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1268320","transaction_code":"C","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-03-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:12.000000Z","updated_at":"2025-03-17T19:16:12.000000Z","inspection_violations":[{"id":4126128,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","insp_violation_id":"253499055","seq_no":"1","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:19.000000Z","updated_at":"2025-03-17T21:26:19.000000Z","normalized_code":"39522G"},{"id":4126129,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","insp_violation_id":"253499056","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195494145","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:19.000000Z","updated_at":"2025-03-17T21:26:19.000000Z","normalized_code":"39360D"},{"id":4126130,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","insp_violation_id":"253499057","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T28523032308061","created_at":"2025-03-17T21:26:19.000000Z","updated_at":"2025-03-17T21:26:19.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":4323984,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","insp_unit_id":"195494145","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"400A","insp_unit_license":"98624RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X5NJ125940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:03.000000Z","updated_at":"2025-03-17T22:37:03.000000Z"},{"id":4323985,"change_date":"2023-06-14 21:41:00","inspection_id":"78214734","insp_unit_id":"195494146","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"SF1858","insp_unit_license":"P717865","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAP0629JK281963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:03.000000Z","updated_at":"2025-03-17T22:37:03.000000Z"}]},{"id":2635532,"change_date":"2023-03-22 21:42:00","inspection_id":"78156853","dot_number":"3122689","report_state":"MO","report_number":"W182008611","insp_date":"2023-03-21 00:00:00","insp_start_time":"1109","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"G60","location_desc":"HWY 60 AT HWY AM","county_code_state":"MO","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"AMERICOLD","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-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2064655","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-22 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:13.000000Z","updated_at":"2025-03-17T19:15:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4242746,"change_date":"2023-03-22 21:42:00","inspection_id":"78156853","insp_unit_id":"194006142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"JD36UD","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLDR1JSHU5009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:26.000000Z","updated_at":"2025-03-17T22:36:26.000000Z"},{"id":4242747,"change_date":"2023-03-22 21:42:00","inspection_id":"78156853","insp_unit_id":"194006143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5312","insp_unit_license":"56990AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2537N2691717","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:26.000000Z","updated_at":"2025-03-17T22:36:26.000000Z"}]},{"id":2575384,"change_date":"2023-03-14 21:41:00","inspection_id":"78088696","dot_number":"3122689","report_state":"MS","report_number":"3011010963","insp_date":"2023-03-13 00:00:00","insp_start_time":"1149","insp_end_time":"1202","registration_date":null,"region":"CT","ci_status_code":"C","location":"Y-99","location_desc":"BOVINA SCALE I-20 EAST","county_code_state":"MS","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PRODUCE SOURCE","shipping_paper_number":"38008","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":null,"final_status_date":"2023-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1016999","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-14 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-03-14 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:07.000000Z","updated_at":"2025-03-17T19:14:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4144823,"change_date":"2023-03-14 21:41:00","inspection_id":"78088696","insp_unit_id":"193862949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"445","insp_unit_license":"TEMPORARY","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X4PJ254592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:42.000000Z","updated_at":"2025-03-17T22:35:42.000000Z"},{"id":4144824,"change_date":"2023-03-14 21:41:00","inspection_id":"78088696","insp_unit_id":"193862950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5521","insp_unit_license":"01295AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0628EW702443","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:42.000000Z","updated_at":"2025-03-17T22:35:42.000000Z"}]},{"id":2526690,"change_date":"2023-06-01 21:43:00","inspection_id":"78033121","dot_number":"3122689","report_state":"NV","report_number":"7468019379","insp_date":"2023-03-06 00:00:00","insp_start_time":"1345","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"3","location_desc":"WELLS","county_code_state":"NV","county_code":"007","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"731629","transaction_code":"C","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2023-06-01 21:43:00","snet_input_date":"2023-03-06 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-03-07 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[{"id":3884971,"change_date":"2023-06-01 21:43:00","inspection_id":"78033121","insp_violation_id":"253220524","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195265228","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4067158,"change_date":"2023-06-01 21:43:00","inspection_id":"78033121","insp_unit_id":"195265227","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYD49X4PJ254592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"},{"id":4067159,"change_date":"2023-06-01 21:43:00","inspection_id":"78033121","insp_unit_id":"195265228","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"01295AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0621EW702445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:09.000000Z","updated_at":"2025-03-17T22:35:09.000000Z"}]},{"id":2369314,"change_date":"2024-01-03 21:44:00","inspection_id":"77853883","dot_number":"3122689","report_state":"IL","report_number":"4178400138","insp_date":"2023-02-13 00:00:00","insp_start_time":"1000","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"073","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GOLDEN WEST PRODUCE CO","shipping_paper_number":"37673","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-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"114000","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":"2223025","transaction_code":"C","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2024-01-03 21:44:00","snet_input_date":"2023-02-13 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3812584,"change_date":"2024-01-03 21:44:00","inspection_id":"77853883","insp_unit_id":"198795074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"101","insp_unit_license":"01087AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X8PJ251079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3812585,"change_date":"2024-01-03 21:44:00","inspection_id":"77853883","insp_unit_id":"198795075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ELBER","insp_unit_company":"2104","insp_unit_license":"01087AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2532N2691723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2192742,"change_date":"2023-11-28 21:41:00","inspection_id":"77652803","dot_number":"3122689","report_state":"TN","report_number":"TFGV000012","insp_date":"2023-01-19 00:00:00","insp_start_time":"1850","insp_end_time":"1955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 S","county_code_state":"TN","county_code":"107","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"VENTURA FOODS","shipping_paper_number":"23846","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1624608","transaction_code":"C","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-01-20 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:58.000000Z","updated_at":"2025-03-17T19:06:58.000000Z","inspection_violations":[{"id":3386825,"change_date":"2023-11-28 21:41:00","inspection_id":"77652803","insp_violation_id":"256594153","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198241512","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:01.000000Z","updated_at":"2025-03-17T21:23:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3529106,"change_date":"2023-11-28 21:41:00","inspection_id":"77652803","insp_unit_id":"198241512","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"UTIM","insp_unit_company":"101","insp_unit_license":"TEMP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X8PJ251079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:18.000000Z","updated_at":"2025-03-17T22:31:18.000000Z"},{"id":3529107,"change_date":"2023-11-28 21:41:00","inspection_id":"77652803","insp_unit_id":"198241513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMR","insp_unit_company":"5411","insp_unit_license":"TS2738","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"527SR5324KL018780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:18.000000Z","updated_at":"2025-03-17T22:31:18.000000Z"}]},{"id":2116466,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","dot_number":"3122689","report_state":"ND","report_number":"TR80000968","insp_date":"2023-01-06 00:00:00","insp_start_time":"1200","insp_end_time":"1252","registration_date":null,"region":"CT","ci_status_code":"C","location":"93","location_desc":"ROADSIDE - CASSELTON","county_code_state":"ND","county_code":"017","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CUMMINGS CORPORATION","shipping_paper_number":"11290","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"366994","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-09 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-01-11 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:33.000000Z","updated_at":"2025-03-17T19:05:33.000000Z","inspection_violations":[{"id":3277167,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","insp_violation_id":"250511511","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7294056","created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"3922"},{"id":3277168,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","insp_violation_id":"250511512","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"192813800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39345D"},{"id":3277169,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","insp_violation_id":"250511513","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"192813800","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:29.000000Z","updated_at":"2025-03-17T21:22:29.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":3406466,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","insp_unit_id":"192813799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"411","insp_unit_license":"91377RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH6MN287521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"},{"id":3406467,"change_date":"2023-01-11 21:42:00","inspection_id":"77565279","insp_unit_id":"192813800","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"20904","insp_unit_license":"91719AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3V532C8DT097184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:25.000000Z","updated_at":"2025-03-17T22:30:25.000000Z"}]},{"id":1799170,"change_date":"2022-11-22 21:41:00","inspection_id":"77202336","dot_number":"3122689","report_state":"MT","report_number":"H630000823","insp_date":"2022-11-21 00:00:00","insp_start_time":"1200","insp_end_time":"1257","registration_date":null,"region":"MT","ci_status_code":"C","location":"630","location_desc":"BROADUS SCALE","county_code_state":"MT","county_code":"075","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"C.R.G. ELECTRIC","shipping_paper_number":"160105","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"975755","transaction_code":"A","transaction_date":"2022-11-21 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-22 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:42.000000Z","updated_at":"2025-03-17T18:59:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2894085,"change_date":"2022-11-22 21:41:00","inspection_id":"77202336","insp_unit_id":"192091962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"011","insp_unit_license":"TEMP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XP4D49X4GD348043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"},{"id":2894086,"change_date":"2022-11-22 21:41:00","inspection_id":"77202336","insp_unit_id":"192091963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"01601AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1TTF532A0P3353600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1672826,"change_date":"2022-11-03 21:42:00","inspection_id":"77057323","dot_number":"3122689","report_state":"CA","report_number":"NC0Q002281","insp_date":"2022-10-31 00:00:00","insp_start_time":"0734","insp_end_time":"0803","registration_date":null,"region":"PT","ci_status_code":"C","location":"830","location_desc":"CACHE CREEK SCALES","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WAYNE FARMS LLC","shipping_paper_number":"589793","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"14661236","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:26.000000Z","updated_at":"2025-03-17T18:57:26.000000Z","inspection_violations":[{"id":2624053,"change_date":"2022-11-03 21:42:00","inspection_id":"77057323","insp_violation_id":"249434046","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"191805595","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW292330","created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":2691083,"change_date":"2022-11-03 21:42:00","inspection_id":"77057323","insp_unit_id":"191805594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"400A\/WHT","insp_unit_license":"98624RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9X5NJ125940","insp_unit_decal":"Y","insp_unit_decal_number":"31896487","created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"},{"id":2691084,"change_date":"2022-11-03 21:42:00","inspection_id":"77057323","insp_unit_id":"191805595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5578\/REF","insp_unit_license":"01264AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2531FU195608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"}]},{"id":1594652,"change_date":"2023-11-22 21:39:00","inspection_id":"76967707","dot_number":"3122689","report_state":"UT","report_number":"23TR000068","insp_date":"2022-10-21 00:00:00","insp_start_time":"2015","insp_end_time":"2052","registration_date":null,"region":"MT","ci_status_code":"C","location":"PERRY","location_desc":"PERRY PORT OF ENTRY","county_code_state":"UT","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONTINENTAL FARM AND FOREST","shipping_paper_number":"12590","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-11-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"862965","transaction_code":"C","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":"2023-11-22 21:39:00","snet_input_date":"2022-10-21 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-10-25 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:58.000000Z","updated_at":"2025-03-17T18:55:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2565945,"change_date":"2023-11-22 21:39:00","inspection_id":"76967707","insp_unit_id":"198188625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"104","insp_unit_license":"TEMP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYDP9XPJ251078","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"},{"id":2565946,"change_date":"2023-11-22 21:39:00","inspection_id":"76967707","insp_unit_id":"198188626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1520","insp_unit_license":"01263AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0626FW703172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:36.000000Z","updated_at":"2025-03-17T22:24:36.000000Z"}]},{"id":1538494,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","dot_number":"3122689","report_state":"NY","report_number":"SPA0274851","insp_date":"2022-10-12 00:00:00","insp_start_time":"1145","insp_end_time":"1244","registration_date":null,"region":"ET","ci_status_code":"C","location":"40647B","location_desc":"RTS 5 AND 77","county_code_state":"NY","county_code":"037","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":"N","pen_cen_match":null,"final_status_date":"2022-10-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2760233","transaction_code":"C","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-18 21:39:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:53.000000Z","updated_at":"2025-03-17T18:54:53.000000Z","inspection_violations":[{"id":2422278,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_violation_id":"249111283","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191513587","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:18.000000Z","updated_at":"2025-03-17T21:18:18.000000Z","normalized_code":"3939A"},{"id":2422279,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_violation_id":"249111284","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"191513587","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:18.000000Z","updated_at":"2025-03-17T21:18:18.000000Z","normalized_code":"39355E"},{"id":2422280,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_violation_id":"249111285","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:18:18.000000Z","updated_at":"2025-03-17T21:18:18.000000Z","normalized_code":"3958E1"},{"id":2422281,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_violation_id":"249111286","seq_no":"4","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:18:18.000000Z","updated_at":"2025-03-17T21:18:18.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":2475730,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_unit_id":"191513586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"91377RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH6MN287521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:58.000000Z","updated_at":"2025-03-17T22:23:58.000000Z"},{"id":2475731,"change_date":"2022-10-19 21:40:00","inspection_id":"76902869","insp_unit_id":"191513587","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"91719AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3V532C8DT097184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:58.000000Z","updated_at":"2025-03-17T22:23:58.000000Z"}]},{"id":1489228,"change_date":"2022-12-28 21:39:00","inspection_id":"76846356","dot_number":"3122689","report_state":"MT","report_number":"H637000359","insp_date":"2022-10-09 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"MT","ci_status_code":"C","location":"0637","location_desc":"BILLINGS EB SCALE","county_code_state":"MT","county_code":"111","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COPPER RIVER SEAFOODS","shipping_paper_number":"2781","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","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":"972801","transaction_code":"C","transaction_date":"2022-12-28 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-11 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:08.000000Z","updated_at":"2025-03-17T18:54:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2396755,"change_date":"2022-12-28 21:39:00","inspection_id":"76846356","insp_unit_id":"192609615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"404","insp_unit_license":"94798RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD9X9ND760559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"},{"id":2396756,"change_date":"2022-12-28 21:39:00","inspection_id":"76846356","insp_unit_id":"192609616","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"01295AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA621EW702445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"}]},{"id":1366810,"change_date":"2022-09-26 21:40:00","inspection_id":"76704330","dot_number":"3122689","report_state":"MT","report_number":"J655000674","insp_date":"2022-09-26 00:00:00","insp_start_time":"0115","insp_end_time":"0134","registration_date":null,"region":"MT","ci_status_code":"C","location":"655","location_desc":"BUTTE SCALE","county_code_state":"MT","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARBIDE INDUSTRIES LLC","shipping_paper_number":"LVBOL2209728","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"971522","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-26 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-09-26 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:57.000000Z","updated_at":"2025-03-17T18:51:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2201013,"change_date":"2022-09-26 21:40:00","inspection_id":"76704330","insp_unit_id":"191097103","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97829RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3HSDZAPR4KN120385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:05.000000Z","updated_at":"2025-03-17T22:22:05.000000Z"},{"id":2201014,"change_date":"2022-09-26 21:40:00","inspection_id":"76704330","insp_unit_id":"191097104","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"657489ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1UYVS2532AU892116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:05.000000Z","updated_at":"2025-03-17T22:22:05.000000Z"}]},{"id":1406356,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","dot_number":"3122689","report_state":"OR","report_number":"AAAE000201","insp_date":"2022-08-04 00:00:00","insp_start_time":"1025","insp_end_time":"1047","registration_date":null,"region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"TIER ONE, USA GLOBAL","shipping_paper_number":"132824,2222587","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1210888","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-29 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-09-29 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":"230522","created_at":"2025-03-17T18:52:41.000000Z","updated_at":"2025-03-17T18:52:41.000000Z","inspection_violations":[{"id":2216442,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740254","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191188175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39311"},{"id":2216443,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740255","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191188175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39311"},{"id":2216444,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740256","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"191188175","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39345"},{"id":2216445,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740257","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191188175","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WM634007","created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3922"},{"id":2216446,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740258","seq_no":"5","part_no":"395","part_no_section":"26(b)","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:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39526B"},{"id":2216447,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_violation_id":"248740259","seq_no":"6","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":2264254,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_unit_id":"191188175","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"350","insp_unit_license":"81911RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH9JN889065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:29.000000Z","updated_at":"2025-03-17T22:22:29.000000Z"},{"id":2264255,"change_date":"2022-09-29 21:41:00","inspection_id":"76750304","insp_unit_id":"191188176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5578","insp_unit_license":"01264AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:29.000000Z","updated_at":"2025-03-17T22:22:29.000000Z"}]},{"id":915303,"change_date":"2023-06-23 21:40:00","inspection_id":"76178758","dot_number":"3122689","report_state":"MT","report_number":"H670000084","insp_date":"2022-07-27 00:00:00","insp_start_time":"1530","insp_end_time":"1619","registration_date":"2022-09-16 00:00:00","region":"MT","ci_status_code":"C","location":null,"location_desc":"HAUGAN POE","county_code_state":"MT","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"LOWES","shipping_paper_number":"55616","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"965194","transaction_code":"C","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:44.000000Z","updated_at":"2025-03-17T18:43:44.000000Z","inspection_violations":[{"id":1442901,"change_date":"2023-06-23 21:40:00","inspection_id":"76178758","insp_violation_id":"253674813","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195651122","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1473410,"change_date":"2023-06-23 21:40:00","inspection_id":"76178758","insp_unit_id":"195651122","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"404\/RED","insp_unit_license":"94798RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD9X9ND760559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:15.000000Z","updated_at":"2025-03-17T22:17:15.000000Z"},{"id":1473411,"change_date":"2023-06-23 21:40:00","inspection_id":"76178758","insp_unit_id":"195651123","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"01086AH","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2530N2691722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:15.000000Z","updated_at":"2025-03-17T22:17:15.000000Z"}]},{"id":877346,"change_date":"2022-07-22 21:40:00","inspection_id":"76133833","dot_number":"3122689","report_state":"CA","report_number":"ND4O002724","insp_date":"2022-07-21 00:00:00","insp_start_time":"1832","insp_end_time":"1854","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14517389","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:05.000000Z","updated_at":"2025-03-17T18:43:05.000000Z","inspection_violations":[{"id":1382085,"change_date":"2022-07-22 21:40:00","inspection_id":"76133833","insp_violation_id":"247266980","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189926768","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KA14969","created_at":"2025-03-17T21:13:32.000000Z","updated_at":"2025-03-17T21:13:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1412431,"change_date":"2022-07-22 21:40:00","inspection_id":"76133833","insp_unit_id":"189926767","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"404\/RED","insp_unit_license":"94798RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XPBD9X9ND760559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:52.000000Z","updated_at":"2025-03-17T22:16:52.000000Z"},{"id":1412432,"change_date":"2022-07-22 21:40:00","inspection_id":"76133833","insp_unit_id":"189926768","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1520\/WHT","insp_unit_license":"01263A","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1GRAA0626FW703172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:52.000000Z","updated_at":"2025-03-17T22:16:52.000000Z"}]},{"id":433702,"change_date":"2022-05-19 21:42:00","inspection_id":"75610311","dot_number":"3122689","report_state":"MT","report_number":"H661000161","insp_date":"2022-05-18 00:00:00","insp_start_time":"0755","insp_end_time":"0833","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"HAUGAN SCALE","county_code_state":"MT","county_code":"061","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"FOREVER GREEN TREE FARM","shipping_paper_number":"20146","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"958523","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-19 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:10.000000Z","updated_at":"2025-03-17T18:35:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":699370,"change_date":"2022-05-19 21:42:00","inspection_id":"75610311","insp_unit_id":"188792328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"350","insp_unit_license":"81911RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH9JN889065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"},{"id":699371,"change_date":"2022-05-19 21:42:00","inspection_id":"75610311","insp_unit_id":"188792329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"11299AB","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2537BU171906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"}]},{"id":302022,"change_date":"2022-05-12 21:41:00","inspection_id":"75453570","dot_number":"3122689","report_state":"SD","report_number":"004D012347","insp_date":"2022-04-29 00:00:00","insp_start_time":"2140","insp_end_time":"2208","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"TILFORD POE","county_code_state":"SD","county_code":"093","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"COLUMBIA REACH PACK","shipping_paper_number":"9977334","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"616144","transaction_code":"C","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-02 00:00:00","source_office":"4SDS001","mcmis_add_date":"2022-05-02 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:54.000000Z","updated_at":"2025-03-17T18:32:54.000000Z","inspection_violations":[{"id":469785,"change_date":"2022-05-12 21:41:00","inspection_id":"75453570","insp_violation_id":"245756737","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39524C2II"},{"id":469786,"change_date":"2022-05-12 21:41:00","inspection_id":"75453570","insp_violation_id":"245756738","seq_no":"2","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":"WARNING","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":488769,"change_date":"2022-05-12 21:41:00","inspection_id":"75453570","insp_unit_id":"188655669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"411","insp_unit_license":"91377RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH6MN287521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:11.000000Z","updated_at":"2025-03-17T22:11:11.000000Z"},{"id":488770,"change_date":"2022-05-12 21:41:00","inspection_id":"75453570","insp_unit_id":"188655670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"416735","insp_unit_license":"01191001","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GRAA0621EW702445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:11.000000Z","updated_at":"2025-03-17T22:11:11.000000Z"}]},{"id":291554,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","dot_number":"3122689","report_state":"WA","report_number":"W531004021","insp_date":"2022-04-28 00:00:00","insp_start_time":"1850","insp_end_time":"2020","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KANSAS MARINE- WEST COAST","shipping_paper_number":"0681008443016","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2491251","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-29 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:36.000000Z","updated_at":"2025-03-17T18:32:36.000000Z","inspection_violations":[{"id":454966,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_violation_id":"245487236","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188432634","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3939A"},{"id":454967,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_violation_id":"245487237","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"188432634","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39378"},{"id":454968,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_violation_id":"245487238","seq_no":"3","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"188432634","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"393207F"},{"id":454969,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_violation_id":"245487239","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188432635","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39375A3"},{"id":454970,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_violation_id":"245487240","seq_no":"5","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"188432635","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":471980,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_unit_id":"188432634","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"JC14QB","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLDR1JSHU5009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:06.000000Z","updated_at":"2025-03-17T22:11:06.000000Z"},{"id":471981,"change_date":"2022-04-29 21:41:00","inspection_id":"75441178","insp_unit_id":"188432635","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"163000","insp_unit_license":"71918AE","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2538GU615401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:06.000000Z","updated_at":"2025-03-17T22:11:06.000000Z"}]},{"id":291032,"change_date":"2022-05-03 21:39:00","inspection_id":"75440562","dot_number":"3122689","report_state":"OR","report_number":"AADB000635","insp_date":"2022-04-28 00:00:00","insp_start_time":"1100","insp_end_time":"1141","registration_date":null,"region":"PT","ci_status_code":"C","location":"1507","location_desc":"ASHLAND POE - 3.5 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KANSAS MARINE CO","shipping_paper_number":"8443016","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202081","transaction_code":"C","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-29 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":"230522","created_at":"2025-03-17T18:32:36.000000Z","updated_at":"2025-03-17T18:32:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":471028,"change_date":"2022-05-03 21:39:00","inspection_id":"75440562","insp_unit_id":"188480683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"JC14QB","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLDR1JSHU5009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:06.000000Z","updated_at":"2025-03-17T22:11:06.000000Z"},{"id":471029,"change_date":"2022-05-03 21:39:00","inspection_id":"75440562","insp_unit_id":"188480684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"16500","insp_unit_license":"71918AE","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:06.000000Z","updated_at":"2025-03-17T22:11:06.000000Z"}]},{"id":221768,"change_date":"2022-04-21 21:40:00","inspection_id":"75357528","dot_number":"3122689","report_state":"VA","report_number":"6226001780","insp_date":"2022-04-20 00:00:00","insp_start_time":"0930","insp_end_time":"1007","registration_date":null,"region":"ET","ci_status_code":"C","location":"077","location_desc":"77 S EXT 14 OFF RAMP","county_code_state":"VA","county_code":"035","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"REFRESCO BEVERAGES US INC","shipping_paper_number":"83568771","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"830427","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-21 00:00:00","source_office":"1VAS001","mcmis_add_date":"2022-04-21 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:31.000000Z","updated_at":"2025-03-17T18:31:31.000000Z","inspection_violations":[{"id":340836,"change_date":"2022-04-21 21:40:00","inspection_id":"75357528","insp_violation_id":"245288102","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:43.000000Z","updated_at":"2025-03-17T21:08:43.000000Z","normalized_code":"3922"},{"id":340837,"change_date":"2022-04-21 21:40:00","inspection_id":"75357528","insp_violation_id":"245288103","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188265087","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:43.000000Z","updated_at":"2025-03-17T21:08:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":359332,"change_date":"2022-04-21 21:40:00","inspection_id":"75357528","insp_unit_id":"188265087","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407","insp_unit_license":"JD16KG","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLBG1GSHN4495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:20.000000Z","updated_at":"2025-03-17T22:10:20.000000Z"},{"id":359333,"change_date":"2022-04-21 21:40:00","inspection_id":"75357528","insp_unit_id":"188265088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3044","insp_unit_license":"37919AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533EM975804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:20.000000Z","updated_at":"2025-03-17T22:10:20.000000Z"}]},{"id":216056,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","dot_number":"3122689","report_state":"PA","report_number":"E917210977","insp_date":"2022-04-19 00:00:00","insp_start_time":"0625","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"BIG LOTS PARKING LOT","county_code_state":"PA","county_code":"121","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SCHWANS","shipping_paper_number":"190419","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-20 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2247199","transaction_code":"C","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-04-20 21:44:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:16.000000Z","updated_at":"2025-03-17T18:31:16.000000Z","inspection_violations":[{"id":332370,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_violation_id":"252722213","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T9082817-2","created_at":"2025-03-17T21:08:37.000000Z","updated_at":"2025-03-17T21:08:37.000000Z","normalized_code":"3922"},{"id":332371,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_violation_id":"252722214","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194836825","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T9082818-3","created_at":"2025-03-17T21:08:37.000000Z","updated_at":"2025-03-17T21:08:37.000000Z","normalized_code":"39395A"},{"id":332372,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_violation_id":"252722215","seq_no":"3","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:08:37.000000Z","updated_at":"2025-03-17T21:08:37.000000Z","normalized_code":"39522H1"},{"id":332373,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_violation_id":"252722216","seq_no":"4","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:08:37.000000Z","updated_at":"2025-03-17T21:08:37.000000Z","normalized_code":"39522H3"}],"inspection_per_units":[{"id":350828,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_unit_id":"194836825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407","insp_unit_license":"JD16KG","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLBG1GSHN4495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:17.000000Z","updated_at":"2025-03-17T22:10:17.000000Z"},{"id":350829,"change_date":"2023-05-09 21:42:00","inspection_id":"75350795","insp_unit_id":"194836826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3044","insp_unit_license":"37919AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533EM975804","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:17.000000Z","updated_at":"2025-03-17T22:10:17.000000Z"}]},{"id":145508,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","dot_number":"3122689","report_state":"IN","report_number":"5476019799","insp_date":"2022-04-10 00:00:00","insp_start_time":"1735","insp_end_time":"1822","registration_date":null,"region":"ET","ci_status_code":"C","location":"4365N","location_desc":"#43  I-65 NB  JACKSON","county_code_state":"IN","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SCOTLYNN SWEET PAC GROWER LLC","shipping_paper_number":"219461","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2123804","transaction_code":"C","transaction_date":"2022-05-31 00:00:00","upload_date":"2022-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-11 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-04-11 21:40:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:08.000000Z","updated_at":"2025-03-17T18:30:08.000000Z","inspection_violations":[{"id":214968,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","insp_violation_id":"246214369","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39522H4"},{"id":214969,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","insp_violation_id":"246214370","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189036997","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"},{"id":214970,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","insp_violation_id":"246214371","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189036997","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":235565,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","insp_unit_id":"189036997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"175","insp_unit_license":"P1130258","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FUJGLDR3CSBE2451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"},{"id":235566,"change_date":"2022-06-02 21:42:00","inspection_id":"75266469","insp_unit_id":"189036998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5578","insp_unit_license":"01136404","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1UYVS2531FU195608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"}]},{"id":52917,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","dot_number":"3122689","report_state":"MN","report_number":"0ADO002722","insp_date":"2022-03-28 00:00:00","insp_start_time":"0756","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CRUNCH PAK LLC","shipping_paper_number":"PPS149845","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1320892","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-28 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:27.000000Z","updated_at":"2025-03-17T18:28:27.000000Z","inspection_violations":[{"id":74904,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_violation_id":"244808819","seq_no":"1","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3958E1"},{"id":74905,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_violation_id":"244808820","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187848845","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"39617C"},{"id":74906,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_violation_id":"244808821","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"187848846","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"39617C"},{"id":74907,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_violation_id":"244808822","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187848845","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3922"},{"id":74908,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_violation_id":"244808823","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"187848846","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:26.000000Z","updated_at":"2025-03-17T21:07:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":85579,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_unit_id":"187848845","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407","insp_unit_license":"JD16KG","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3AKJGLBG1GSHN4495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:46.000000Z","updated_at":"2025-03-17T22:08:46.000000Z"},{"id":85580,"change_date":"2022-03-28 21:41:00","inspection_id":"75152946","insp_unit_id":"187848846","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"160491","insp_unit_license":"71807AE","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1UYVS2533GU412092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:46.000000Z","updated_at":"2025-03-17T22:08:46.000000Z"}]},{"id":82744,"change_date":"2022-03-31 21:41:00","inspection_id":"75189366","dot_number":"3122689","report_state":"MT","report_number":"H637000010","insp_date":"2022-03-27 00:00:00","insp_start_time":"2300","insp_end_time":"2326","registration_date":null,"region":"MT","ci_status_code":"C","location":"0637","location_desc":"BILLINGS EB SCALE","county_code_state":"MT","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"GEF LOGISTICS","shipping_paper_number":"G032044303","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"953579","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03122689","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"MAGIC TRANS LLC","insp_carrier_street":"11335 NE 122ND WAY STE 105","insp_carrier_city":"KIRKLAND","insp_carrier_state":"WA","insp_carrier_zip_code":"98034","insp_colonia":null,"docket_number":"88855","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":134262,"change_date":"2022-03-31 21:41:00","inspection_id":"75189366","insp_unit_id":"187923825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"411","insp_unit_license":"91377RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH6MN287521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"},{"id":134263,"change_date":"2022-03-31 21:41:00","inspection_id":"75189366","insp_unit_id":"187923826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"20904","insp_unit_license":"91719AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3V532C8DT097184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3122689\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3122689\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3122689\/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\/3122689\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}