{"current_page":1,"data":[{"id":11383467,"change_date":"2026-03-16 21:38:00","inspection_id":"87297702","dot_number":"2156376","report_state":"WA","report_number":"2151000114","insp_date":"2026-03-11 00:00:00","insp_start_time":"0915","insp_end_time":"0924","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"105000","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":"3009302","transaction_code":"A","transaction_date":"2026-03-15 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2026-03-16 21:38:00","snet_input_date":"2026-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-16 21:38:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-19T09:37:43.000000Z","updated_at":"2026-03-27T09:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19493112,"change_date":"2026-03-16 21:38:00","inspection_id":"87297702","insp_unit_id":"212150862","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"TSXZ243498","insp_unit_license":"4HF7811","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"LJRC2824X66000575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:36.000000Z","updated_at":"2026-03-27T09:04:21.000000Z"},{"id":19493113,"change_date":"2026-03-16 21:38:00","inspection_id":"87297702","insp_unit_id":"212150863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"77AA","insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:36.000000Z","updated_at":"2026-03-27T09:04:21.000000Z"}]},{"id":11264125,"change_date":"2026-03-02 21:38:00","inspection_id":"87178097","dot_number":"2156376","report_state":"WA","report_number":"X773000335","insp_date":"2026-02-26 00:00:00","insp_start_time":"0527","insp_end_time":"0557","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"KALAMA WA","county_code_state":"WA","county_code":"015","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"125200","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":"2952424","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2026-03-02 21:38:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-02 21:38:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-05T10:38:59.000000Z","updated_at":"2026-03-13T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19262232,"change_date":"2026-03-02 21:38:00","inspection_id":"87178097","insp_unit_id":"211913959","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"777A","insp_unit_license":"RP13467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:42.000000Z","updated_at":"2026-03-13T09:06:40.000000Z"},{"id":19262233,"change_date":"2026-03-02 21:38:00","inspection_id":"87178097","insp_unit_id":"211913960","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"MECH HANDL","insp_unit_company":"AMPZ 419077","insp_unit_license":"T792103","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3M2CG40215S000053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-05T10:14:42.000000Z","updated_at":"2026-03-13T09:06:40.000000Z"}]},{"id":11258566,"change_date":"2026-03-01 21:33:00","inspection_id":"87172184","dot_number":"2156376","report_state":"WA","report_number":"2025001149","insp_date":"2026-02-24 00:00:00","insp_start_time":"0739","insp_end_time":"0754","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"132500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2947475","transaction_code":"A","transaction_date":"2026-02-28 00:00:00","upload_date":"2026-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2026-03-01 21:33:00","snet_input_date":"2026-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-01 21:33:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-04T10:38:37.000000Z","updated_at":"2026-03-12T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19251133,"change_date":"2026-03-01 21:33:00","inspection_id":"87172184","insp_unit_id":"211901706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"77AA","insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-04T10:14:37.000000Z","updated_at":"2026-03-12T09:03:02.000000Z"},{"id":19251134,"change_date":"2026-03-01 21:33:00","inspection_id":"87172184","insp_unit_id":"211901707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"DECZ400414","insp_unit_license":"2941148","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S1PT407895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-04T10:14:37.000000Z","updated_at":"2026-03-12T09:03:02.000000Z"}]},{"id":10855340,"change_date":"2026-01-25 21:33:00","inspection_id":"86884607","dot_number":"2156376","report_state":"WA","report_number":"0642004698","insp_date":"2026-01-20 00:00:00","insp_start_time":"1124","insp_end_time":"1200","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"ROYAL CITY WA","county_code_state":"WA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VERDSIAN LIFE SCIENCE","shipping_paper_number":"118220","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118320","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2810582","transaction_code":"A","transaction_date":"2026-01-24 00:00:00","upload_date":"2026-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2026-01-25 21:33:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-25 21:33:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-28T10:36:19.000000Z","updated_at":"2026-02-05T10:30:08.000000Z","inspection_violations":[{"id":18159236,"change_date":"2026-01-25 21:33:00","inspection_id":"86884607","insp_violation_id":"271413722","seq_no":"1","part_no":"392","part_no_section":"2-SLLIP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-28T10:41:43.000000Z","updated_at":"2026-02-05T10:35:55.000000Z","normalized_code":"3922SLLIP"}],"inspection_per_units":[{"id":18239101,"change_date":"2026-01-25 21:33:00","inspection_id":"86884607","insp_unit_id":"211278244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"777A","insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-28T10:08:20.000000Z","updated_at":"2026-02-05T10:02:03.000000Z"},{"id":18239102,"change_date":"2026-01-25 21:33:00","inspection_id":"86884607","insp_unit_id":"211278245","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"AIMZ201556","insp_unit_license":"T928528","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"CB791181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-28T10:08:20.000000Z","updated_at":"2026-02-05T10:02:03.000000Z"}]},{"id":10211600,"change_date":"2025-11-16 21:33:00","inspection_id":"86332922","dot_number":"2156376","report_state":"WA","report_number":"2033006023","insp_date":"2025-11-11 00:00:00","insp_start_time":"1230","insp_end_time":"1330","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"1","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-16 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2548244","transaction_code":"A","transaction_date":"2025-11-15 00:00:00","upload_date":"2025-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-11-16 21:33:00","snet_input_date":"2025-11-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-16 21:33:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-19T10:30:28.000000Z","updated_at":"2025-11-20T10:30:16.000000Z","inspection_violations":[{"id":16966456,"change_date":"2025-11-16 21:33:00","inspection_id":"86332922","insp_violation_id":"269981743","seq_no":"1","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"210052640","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-19T10:30:44.000000Z","updated_at":"2025-11-20T10:30:26.000000Z","normalized_code":"39343ATPV"}],"inspection_per_units":[{"id":17010432,"change_date":"2025-11-16 21:33:00","inspection_id":"86332922","insp_unit_id":"210052640","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-19T10:00:40.000000Z","updated_at":"2025-11-20T10:00:20.000000Z"},{"id":17010433,"change_date":"2025-11-16 21:33:00","inspection_id":"86332922","insp_unit_id":"210052641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"TSG2 449754","insp_unit_license":"3827266","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LT1CC41264C000117","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-19T10:00:40.000000Z","updated_at":"2025-11-20T10:00:20.000000Z"}]},{"id":9993154,"change_date":"2025-10-21 21:38:00","inspection_id":"86102925","dot_number":"2156376","report_state":"WA","report_number":"2075000460","insp_date":"2025-10-16 00:00:00","insp_start_time":"1347","insp_end_time":"1359","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-10-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"2437670","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-10-21 21:38:00","snet_input_date":"2025-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-21 21:38:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-24T10:01:42.000000Z","updated_at":"2025-10-25T10:00:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16594606,"change_date":"2025-10-21 21:38:00","inspection_id":"86102925","insp_unit_id":"209569920","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:46:59.000000Z","updated_at":"2025-10-25T09:45:11.000000Z"},{"id":16594607,"change_date":"2025-10-21 21:38:00","inspection_id":"86102925","insp_unit_id":"209569921","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"1VD9556","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S2MT401423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:46:59.000000Z","updated_at":"2025-10-25T09:45:11.000000Z"}]},{"id":9067873,"change_date":"2025-07-06 21:32:00","inspection_id":"85130094","dot_number":"2156376","report_state":"WA","report_number":"2105004298","insp_date":"2025-07-01 00:00:00","insp_start_time":"1115","insp_end_time":"1149","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-06 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120050","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1954590","transaction_code":"A","transaction_date":"2025-07-05 00:00:00","upload_date":"2025-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-07-06 21:32:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-06 21:32:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-09T10:00:21.000000Z","updated_at":"2025-07-11T10:44:14.000000Z","inspection_violations":[{"id":14595123,"change_date":"2025-07-06 21:32:00","inspection_id":"85130094","insp_violation_id":"267215421","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"207711361","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-09T10:43:08.000000Z","updated_at":"2025-07-10T10:42:02.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":14878875,"change_date":"2025-07-06 21:32:00","inspection_id":"85130094","insp_unit_id":"207711360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-09T09:45:33.000000Z","updated_at":"2025-07-10T09:45:05.000000Z"},{"id":14878876,"change_date":"2025-07-06 21:32:00","inspection_id":"85130094","insp_unit_id":"207711361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AIMZ040738","insp_unit_license":"U413853","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S53T139203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-09T09:45:33.000000Z","updated_at":"2025-07-10T09:45:05.000000Z"}]},{"id":8752026,"change_date":"2025-05-28 21:42:00","inspection_id":"84795848","dot_number":"2156376","report_state":"WA","report_number":"0714002798","insp_date":"2025-05-23 00:00:00","insp_start_time":"0931","insp_end_time":"0947","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1788700","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-05-28 21:42:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-28 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-31T10:01:20.000000Z","updated_at":"2025-06-01T10:00:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14311478,"change_date":"2025-05-28 21:42:00","inspection_id":"84795848","insp_unit_id":"207093660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:44.000000Z","updated_at":"2025-06-01T09:46:49.000000Z"},{"id":14311479,"change_date":"2025-05-28 21:42:00","inspection_id":"84795848","insp_unit_id":"207093661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYSTER COR","insp_unit_company":null,"insp_unit_license":"2941282","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C412S6VT009286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-31T09:46:44.000000Z","updated_at":"2025-06-01T09:46:49.000000Z"}]},{"id":8358469,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","dot_number":"2156376","report_state":"WA","report_number":"2085002240","insp_date":"2025-04-10 00:00:00","insp_start_time":"1110","insp_end_time":"1145","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"1","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-12 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1585137","transaction_code":"C","transaction_date":"2025-04-12 00:00:00","upload_date":"2025-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-04-12 21:33:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-12 21:33:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-15T10:14:21.000000Z","updated_at":"2026-01-10T10:30:06.000000Z","inspection_violations":[{"id":17694706,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","insp_violation_id":"270945429","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"210846652","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-02T10:40:16.000000Z","updated_at":"2026-01-10T10:30:17.000000Z","normalized_code":"3939ALSLIWR"},{"id":17694707,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","insp_violation_id":"270945430","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"210846652","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-02T10:40:16.000000Z","updated_at":"2026-01-10T10:30:17.000000Z","normalized_code":"3939ALTSI"},{"id":17694708,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","insp_violation_id":"270945431","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"210846652","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:16.000000Z","updated_at":"2026-01-10T10:30:17.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":17649782,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","insp_unit_id":"210846651","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"Y","insp_unit_decal_number":"35226187","created_at":"2026-01-02T10:06:17.000000Z","updated_at":"2026-01-10T10:00:06.000000Z"},{"id":17649783,"change_date":"2025-12-30 21:36:00","inspection_id":"84381035","insp_unit_id":"210846652","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"TSXZ253404","insp_unit_license":"4JN7064","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"LJRC2824371019385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-02T10:06:17.000000Z","updated_at":"2026-01-10T10:00:06.000000Z"}]},{"id":8052014,"change_date":"2025-03-07 21:38:00","inspection_id":"84058339","dot_number":"2156376","report_state":"WA","report_number":"X769007366","insp_date":"2025-03-05 00:00:00","insp_start_time":"1326","insp_end_time":"1410","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC53","location_desc":"CLE ELUM WA","county_code_state":"WA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"119700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1442080","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:25.000000Z","updated_at":"2025-03-17T21:05:25.000000Z","inspection_violations":[{"id":12584065,"change_date":"2025-03-07 21:38:00","inspection_id":"84058339","insp_violation_id":"264885560","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205675260","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39378AWS"},{"id":12584066,"change_date":"2025-03-07 21:38:00","inspection_id":"84058339","insp_violation_id":"264885561","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"205675260","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":12999987,"change_date":"2025-03-07 21:38:00","inspection_id":"84058339","insp_unit_id":"205675260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"777A","insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:35.000000Z","updated_at":"2025-03-17T23:58:35.000000Z"},{"id":12999988,"change_date":"2025-03-07 21:38:00","inspection_id":"84058339","insp_unit_id":"205675261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"TSXZ247610","insp_unit_license":"2527403","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC2826651013997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:35.000000Z","updated_at":"2025-03-17T23:58:35.000000Z"}]},{"id":7857524,"change_date":"2025-02-13 21:39:00","inspection_id":"83854355","dot_number":"2156376","report_state":"WA","report_number":"2082001819","insp_date":"2025-02-11 00:00:00","insp_start_time":"1259","insp_end_time":"1323","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","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":"U","pen_cen_match":"I","final_status_date":"2025-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118230","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1356932","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-02-13 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:39:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[{"id":12281396,"change_date":"2025-02-13 21:39:00","inspection_id":"83854355","insp_violation_id":"264495123","seq_no":"1","part_no":"393","part_no_section":"201A-FRSC","insp_viol_unit":"2","insp_unit_id":"205300066","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"393201AFRSC"},{"id":12281397,"change_date":"2025-02-13 21:39:00","inspection_id":"83854355","insp_violation_id":"264495124","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"205300065","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":12681912,"change_date":"2025-02-13 21:39:00","inspection_id":"83854355","insp_unit_id":"205300065","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"},{"id":12681913,"change_date":"2025-02-13 21:39:00","inspection_id":"83854355","insp_unit_id":"205300066","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"5116ZS","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3C383S3PT330053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":7708336,"change_date":"2025-01-25 21:33:00","inspection_id":"83697457","dot_number":"2156376","report_state":"WA","report_number":"2016001180","insp_date":"2025-01-23 00:00:00","insp_start_time":"1155","insp_end_time":"1226","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC26","location_desc":"FEDERAL WAY WA","county_code_state":"WA","county_code":"033","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2025-01-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"1286093","transaction_code":"A","transaction_date":"2025-01-25 00:00:00","upload_date":"2025-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2025-01-25 21:33:00","snet_input_date":"2025-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-25 21:33:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:17.000000Z","updated_at":"2025-03-17T20:58:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12438814,"change_date":"2025-01-25 21:33:00","inspection_id":"83697457","insp_unit_id":"205004996","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"813384","insp_unit_license":"2697894","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3C402K6NJ102394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:15.000000Z","updated_at":"2025-03-17T23:52:15.000000Z"},{"id":12438815,"change_date":"2025-01-25 21:33:00","inspection_id":"83697457","insp_unit_id":"205004997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:15.000000Z","updated_at":"2025-03-17T23:52:15.000000Z"}]},{"id":7444627,"change_date":"2024-12-18 21:40:00","inspection_id":"83420587","dot_number":"2156376","report_state":"WA","report_number":"2086001442","insp_date":"2024-12-16 00:00:00","insp_start_time":"0914","insp_end_time":"0926","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"LAKEWOOD WA","county_code_state":"WA","county_code":"053","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"124350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1168457","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:31.000000Z","updated_at":"2025-03-17T20:51:31.000000Z","inspection_violations":[{"id":11633010,"change_date":"2024-12-18 21:40:00","inspection_id":"83420587","insp_violation_id":"263534548","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4A0923021","created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":12009998,"change_date":"2024-12-18 21:40:00","inspection_id":"83420587","insp_unit_id":"204445226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"553","insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"},{"id":12009999,"change_date":"2024-12-18 21:40:00","inspection_id":"83420587","insp_unit_id":"204445227","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"BUNKHOUSE","insp_unit_company":null,"insp_unit_license":"92091AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"5EF4GC406JB790425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:34.000000Z","updated_at":"2025-03-17T23:47:34.000000Z"}]},{"id":7409504,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","dot_number":"2156376","report_state":"WA","report_number":"X819006946","insp_date":"2024-12-11 00:00:00","insp_start_time":"0959","insp_end_time":"1041","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"TUMWATER WA","county_code_state":"WA","county_code":"067","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121400","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1151727","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-12-13 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-13 21:40:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:45.000000Z","updated_at":"2025-03-17T20:50:45.000000Z","inspection_violations":[{"id":11577557,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_violation_id":"263955748","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"204805733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"39345B2BAIR"},{"id":11577558,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_violation_id":"263955749","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"204805734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3939ALSLI"},{"id":11577559,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_violation_id":"263955750","seq_no":"3","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"204805734","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"39323LEU"},{"id":11577560,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_violation_id":"263955751","seq_no":"4","part_no":"393","part_no_section":"207B-AALPME-OOS","insp_viol_unit":"2","insp_unit_id":"204805734","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"393207BAALPMEOOS"}],"inspection_per_units":[{"id":11953081,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_unit_id":"204805733","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"RP12467","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ4FN182613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:57.000000Z","updated_at":"2025-03-17T23:46:57.000000Z"},{"id":11953082,"change_date":"2025-01-14 21:54:00","inspection_id":"83383684","insp_unit_id":"204805734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"3683XG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1D9SC5341BG512370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:57.000000Z","updated_at":"2025-03-17T23:46:57.000000Z"}]},{"id":5913828,"change_date":"2024-06-05 21:41:00","inspection_id":"81788796","dot_number":"2156376","report_state":"WA","report_number":"0935006144","insp_date":"2024-06-04 00:00:00","insp_start_time":"1440","insp_end_time":"1454","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2024-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"540753","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:51.000000Z","updated_at":"2025-03-17T20:19:51.000000Z","inspection_violations":[{"id":9169810,"change_date":"2024-06-05 21:41:00","inspection_id":"81788796","insp_violation_id":"259906259","seq_no":"1","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"1","insp_unit_id":"201236033","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"387301A"}],"inspection_per_units":[{"id":9525235,"change_date":"2024-06-05 21:41:00","inspection_id":"81788796","insp_unit_id":"201236033","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"},{"id":9525236,"change_date":"2024-06-05 21:41:00","inspection_id":"81788796","insp_unit_id":"201236034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"5116ZS","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3H3C383S3PT330053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"}]},{"id":5540904,"change_date":"2024-04-18 21:39:00","inspection_id":"81383640","dot_number":"2156376","report_state":"WA","report_number":"2063000349","insp_date":"2024-04-16 00:00:00","insp_start_time":"1650","insp_end_time":"1715","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"YAKIMA WA","county_code_state":"WA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WASHINGTON FRUIT GROWERS","shipping_paper_number":"1786880","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"409449","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-04-18 21:39:00","snet_input_date":"2024-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-18 21:39:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:42.000000Z","updated_at":"2025-03-17T20:12:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8925409,"change_date":"2024-04-18 21:39:00","inspection_id":"81383640","insp_unit_id":"200459757","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"553","insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"},{"id":8925410,"change_date":"2024-04-18 21:39:00","inspection_id":"81383640","insp_unit_id":"200459758","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"92091AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"5EF4GC406JB790425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:04.000000Z","updated_at":"2025-03-17T23:16:04.000000Z"}]},{"id":5283689,"change_date":"2024-03-14 21:41:00","inspection_id":"81102751","dot_number":"2156376","report_state":"WA","report_number":"2063000324","insp_date":"2024-03-11 00:00:00","insp_start_time":"1135","insp_end_time":"1205","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC47","location_desc":"NACHES WA","county_code_state":"WA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALLAN BROS., INC","shipping_paper_number":"4349290","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"316844","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-03-14 21:41:00","snet_input_date":"2024-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:27.000000Z","updated_at":"2025-03-17T20:07:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8508458,"change_date":"2024-03-14 21:41:00","inspection_id":"81102751","insp_unit_id":"199906685","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"553","insp_unit_license":"74494RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:06.000000Z","updated_at":"2025-03-17T23:12:06.000000Z"},{"id":8508459,"change_date":"2024-03-14 21:41:00","inspection_id":"81102751","insp_unit_id":"199906686","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"92091AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"5EF4GC406JB790425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:06.000000Z","updated_at":"2025-03-17T23:12:06.000000Z"}]},{"id":5186909,"change_date":"2024-03-01 21:39:00","inspection_id":"80997004","dot_number":"2156376","report_state":"WA","report_number":"2016000173","insp_date":"2024-02-26 00:00:00","insp_start_time":"1320","insp_end_time":"1342","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC26","location_desc":"FEDERAL WAY WA","county_code_state":"WA","county_code":"033","insp_level_id":"3","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":"U","pen_cen_match":"I","final_status_date":"2024-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"285210","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8351638,"change_date":"2024-03-01 21:39:00","inspection_id":"80997004","insp_unit_id":"199704714","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"},{"id":8351639,"change_date":"2024-03-01 21:39:00","inspection_id":"80997004","insp_unit_id":"199704715","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"4S98","insp_unit_license":"8962ZD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1P9CC4145GN343198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4346874,"change_date":"2023-11-03 21:40:00","inspection_id":"80076869","dot_number":"2156376","report_state":"WA","report_number":"2075000044","insp_date":"2023-11-03 00:00:00","insp_start_time":"1350","insp_end_time":"1409","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"LAKEWOOD WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"86120","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":"2023-11-03 21:40:00","snet_input_date":"2023-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-03 21:40:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:06.000000Z","updated_at":"2025-03-17T19:49:06.000000Z","inspection_violations":[{"id":6724541,"change_date":"2023-11-03 21:40:00","inspection_id":"80076869","insp_violation_id":"256201447","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0767842","created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6990829,"change_date":"2023-11-03 21:40:00","inspection_id":"80076869","insp_unit_id":"197890228","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"},{"id":6990830,"change_date":"2023-11-03 21:40:00","inspection_id":"80076869","insp_unit_id":"197890229","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":null,"insp_unit_license":"3817805","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41264JT003548","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"}]},{"id":4194987,"change_date":"2023-10-13 21:41:00","inspection_id":"79909127","dot_number":"2156376","report_state":"WA","report_number":"W732004404","insp_date":"2023-10-10 00:00:00","insp_start_time":"0927","insp_end_time":"0941","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC26","location_desc":"SC26  FEDERAL WAY NORTHBOUND","county_code_state":"WA","county_code":"033","insp_level_id":"3","service_center":"WE","census_source_id":"4","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-10-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2597549","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-13 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-13 21:41:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:53.000000Z","updated_at":"2025-03-17T19:45:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6746266,"change_date":"2023-10-13 21:41:00","inspection_id":"79909127","insp_unit_id":"197550159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"RP00499","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLBGXDSBS6883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:34.000000Z","updated_at":"2025-03-17T22:56:34.000000Z"}]},{"id":3718053,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","dot_number":"2156376","report_state":"WA","report_number":"W717004356","insp_date":"2023-08-09 00:00:00","insp_start_time":"1352","insp_end_time":"1413","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC33","location_desc":"SC33   BOW HILL (POE)","county_code_state":"WA","county_code":"057","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COLUMBIA FRUIT PROCESSING LLC","shipping_paper_number":"4-34286","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-08-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125350","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2586082","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-10 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-10 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:10.000000Z","updated_at":"2025-03-17T19:36:10.000000Z","inspection_violations":[{"id":5733290,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","insp_violation_id":"254591522","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:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"3922"},{"id":5733291,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","insp_violation_id":"254591523","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196476694","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39345B2"},{"id":5733292,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","insp_violation_id":"254591524","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196476694","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:32.000000Z","updated_at":"2025-03-17T21:33:32.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":5978205,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","insp_unit_id":"196476694","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"553","insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"},{"id":5978206,"change_date":"2023-08-10 21:42:00","inspection_id":"79378611","insp_unit_id":"196476695","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"21","insp_unit_license":"92091AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"5EF4GC406JB790425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:14.000000Z","updated_at":"2025-03-17T22:50:14.000000Z"}]},{"id":2919490,"change_date":"2023-04-28 21:39:00","inspection_id":"78479905","dot_number":"2156376","report_state":"WA","report_number":"W819005137","insp_date":"2023-04-27 00:00:00","insp_start_time":"0945","insp_end_time":"1016","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC07","location_desc":"SC07   FT LEWIS NORTHBOUND","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MORGAN CFS","shipping_paper_number":"2615-2","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":"2023-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2567852","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-28 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:29.000000Z","updated_at":"2025-03-17T19:20:29.000000Z","inspection_violations":[{"id":4480563,"change_date":"2023-04-28 21:39:00","inspection_id":"78479905","insp_violation_id":"252509380","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0269466","created_at":"2025-03-17T21:27:55.000000Z","updated_at":"2025-03-17T21:27:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4697312,"change_date":"2023-04-28 21:39:00","inspection_id":"78479905","insp_unit_id":"194648269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"RP00499","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLBGXDSBS6883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"},{"id":4697313,"change_date":"2023-04-28 21:39:00","inspection_id":"78479905","insp_unit_id":"194648270","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4SP7524","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3C412S45T233818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"}]},{"id":2424733,"change_date":"2023-02-22 21:40:00","inspection_id":"77917448","dot_number":"2156376","report_state":"WA","report_number":"W502022036","insp_date":"2023-02-21 00:00:00","insp_start_time":"0620","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC77","location_desc":"SC77   KELSO","county_code_state":"WA","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"INTERCITY SEATTLE","shipping_paper_number":"HHMU 5426621","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":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"135350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2554018","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-22 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[{"id":3733831,"change_date":"2023-02-22 21:40:00","inspection_id":"77917448","insp_violation_id":"251275173","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0096512","created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3902737,"change_date":"2023-02-22 21:40:00","inspection_id":"77917448","insp_unit_id":"193524189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"553","insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"},{"id":3902738,"change_date":"2023-02-22 21:40:00","inspection_id":"77917448","insp_unit_id":"193524190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"D5327","insp_unit_license":"3682XG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1D9SC5343BG51237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"}]},{"id":2390988,"change_date":"2023-02-16 21:42:00","inspection_id":"77878809","dot_number":"2156376","report_state":"WA","report_number":"W819004878","insp_date":"2023-02-15 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC07","location_desc":"SC07   FT LEWIS NORTHBOUND","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2552768","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-16 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-16 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:44.000000Z","updated_at":"2025-03-17T19:10:44.000000Z","inspection_violations":[{"id":3681452,"change_date":"2023-02-16 21:42:00","inspection_id":"77878809","insp_violation_id":"251188012","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193445027","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"3939A"},{"id":3681453,"change_date":"2023-02-16 21:42:00","inspection_id":"77878809","insp_violation_id":"251188013","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193445027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:23.000000Z","updated_at":"2025-03-17T21:24:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3847576,"change_date":"2023-02-16 21:42:00","inspection_id":"77878809","insp_unit_id":"193445026","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"C98005X","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLBGXDSBS6883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"},{"id":3847577,"change_date":"2023-02-16 21:42:00","inspection_id":"77878809","insp_unit_id":"193445027","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"JIMD","insp_unit_company":null,"insp_unit_license":"U418493","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"KR1SM2329XD100356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:33.000000Z","updated_at":"2025-03-17T22:33:33.000000Z"}]},{"id":1844670,"change_date":"2022-11-30 21:40:00","inspection_id":"77254332","dot_number":"2156376","report_state":"WA","report_number":"B701000048","insp_date":"2022-11-29 00:00:00","insp_start_time":"1450","insp_end_time":"1535","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC39","location_desc":"SC39   EVERETT SOUTHBOUND","county_code_state":"WA","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COMPTEX \/ FYE FRP","shipping_paper_number":"9540000381","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":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"174000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2537429","transaction_code":"A","transaction_date":"2022-11-29 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:43.000000Z","updated_at":"2025-03-17T19:00:43.000000Z","inspection_violations":[{"id":2877303,"change_date":"2022-11-30 21:40:00","inspection_id":"77254332","insp_violation_id":"249855745","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"192197400","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39345B2"},{"id":2877304,"change_date":"2022-11-30 21:40:00","inspection_id":"77254332","insp_violation_id":"249855746","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192197399","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:40.000000Z","updated_at":"2025-03-17T21:20:40.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":2968204,"change_date":"2022-11-30 21:40:00","inspection_id":"77254332","insp_unit_id":"192197399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"},{"id":2968205,"change_date":"2022-11-30 21:40:00","inspection_id":"77254332","insp_unit_id":"192197400","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"4817RC","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"88480017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:19.000000Z","updated_at":"2025-03-17T22:27:19.000000Z"}]},{"id":1198868,"change_date":"2022-09-01 21:42:00","inspection_id":"76509382","dot_number":"2156376","report_state":"WA","report_number":"W101002796","insp_date":"2022-08-31 00:00:00","insp_start_time":"1341","insp_end_time":"1351","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC07","location_desc":"SC07   FT LEWIS NORTHBOUND","county_code_state":"WA","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"2517983","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-01 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-09-01 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:40.000000Z","updated_at":"2025-03-17T18:48:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1927984,"change_date":"2022-09-01 21:42:00","inspection_id":"76509382","insp_unit_id":"190692634","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:15.000000Z","updated_at":"2025-03-17T22:20:15.000000Z"},{"id":1927985,"change_date":"2022-09-01 21:42:00","inspection_id":"76509382","insp_unit_id":"190692635","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"8961ZD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1P9CC4144GN343197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:15.000000Z","updated_at":"2025-03-17T22:20:15.000000Z"}]},{"id":751476,"change_date":"2022-07-05 21:42:00","inspection_id":"75987221","dot_number":"2156376","report_state":"WA","report_number":"W210005821","insp_date":"2022-07-01 00:00:00","insp_start_time":"1736","insp_end_time":"1748","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"TACOMA","county_code_state":"WA","county_code":"053","insp_level_id":"3","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":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"2505258","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-05 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:54.000000Z","updated_at":"2025-03-17T18:40:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1208729,"change_date":"2022-07-05 21:42:00","inspection_id":"75987221","insp_unit_id":"189607853","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"RP00499","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLBGXDSBS6883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"},{"id":1208730,"change_date":"2022-07-05 21:42:00","inspection_id":"75987221","insp_unit_id":"189607854","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"8959ZD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1P9CC4140GN343195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"}]},{"id":408930,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","dot_number":"2156376","report_state":"WA","report_number":"W113000404","insp_date":"2022-05-16 00:00:00","insp_start_time":"1110","insp_end_time":"1146","registration_date":null,"region":"PT","ci_status_code":"C","location":"27","location_desc":"PORT OF TACOMA","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2495376","transaction_code":"A","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-17 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:47.000000Z","updated_at":"2025-03-17T18:34:47.000000Z","inspection_violations":[{"id":639433,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_violation_id":"245842504","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2A0206283","created_at":"2025-03-17T21:09:59.000000Z","updated_at":"2025-03-17T21:09:59.000000Z","normalized_code":"39216A"},{"id":639434,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_violation_id":"245842505","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"188730089","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:59.000000Z","updated_at":"2025-03-17T21:09:59.000000Z","normalized_code":"39375A1"},{"id":639435,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_violation_id":"245842506","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188730090","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:59.000000Z","updated_at":"2025-03-17T21:09:59.000000Z","normalized_code":"3963A1"},{"id":639436,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_violation_id":"245842507","seq_no":"4","part_no":"393","part_no_section":"126","insp_viol_unit":"2","insp_unit_id":"188730090","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:59.000000Z","updated_at":"2025-03-17T21:09:59.000000Z","normalized_code":"393126"}],"inspection_per_units":[{"id":660326,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_unit_id":"188730089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"553","insp_unit_license":"75594RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ2CN542554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"},{"id":660327,"change_date":"2022-05-17 21:43:00","inspection_id":"75580901","insp_unit_id":"188730090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMR","insp_unit_company":null,"insp_unit_license":"U482320","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC462161010053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"}]},{"id":64154,"change_date":"2022-03-29 21:42:00","inspection_id":"75166817","dot_number":"2156376","report_state":"WA","report_number":"W311000598","insp_date":"2022-03-28 00:00:00","insp_start_time":"0848","insp_end_time":"0904","registration_date":null,"region":"PT","ci_status_code":"C","location":"39","location_desc":"EB","county_code_state":"WA","county_code":"077","insp_level_id":"3","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":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"114350","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":"2482950","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02156376","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-29 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"MAGIC TRUCKING SERVICES LLC","insp_carrier_street":"31010 7TH PL S","insp_carrier_city":"FEDERAL WAY","insp_carrier_state":"WA","insp_carrier_zip_code":"98003","insp_colonia":null,"docket_number":"749586","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:46.000000Z","updated_at":"2025-03-17T18:28:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":104353,"change_date":"2022-03-29 21:42:00","inspection_id":"75166817","insp_unit_id":"187878431","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"53951RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EJ49N271943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":104354,"change_date":"2022-03-29 21:42:00","inspection_id":"75166817","insp_unit_id":"187878432","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HDMZ403548","insp_unit_license":"U154163","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S8RT002998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2156376\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2156376\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2156376\/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\/2156376\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}