{"current_page":1,"data":[{"id":12357825,"change_date":"2026-07-04 21:33:00","inspection_id":"88319233","dot_number":"4037274","report_state":"OK","report_number":"R513156012","insp_date":"2026-07-03 00:00:00","insp_start_time":"1835","insp_end_time":"1912","registration_date":null,"region":"CD","ci_status_code":"C","location":"05040","location_desc":"OK","county_code_state":"OK","county_code":"009","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"PROCTER & GAMBLE","shipping_paper_number":"0321581720","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-07-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3681828","transaction_code":"A","transaction_date":"2026-07-04 00:00:00","upload_date":"2026-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-07-04 21:33:00","snet_input_date":"2026-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-04 21:33:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-07T09:40:55.000000Z","updated_at":"2026-07-15T09:30:03.000000Z","inspection_violations":[{"id":21508081,"change_date":"2026-07-04 21:33:00","inspection_id":"88319233","insp_violation_id":"275300671","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"214446053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-07T10:00:51.000000Z","updated_at":"2026-07-15T09:40:24.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":21460119,"change_date":"2026-07-04 21:33:00","inspection_id":"88319233","insp_unit_id":"214446053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4246","insp_unit_license":"P1255730","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR2KSKE4246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-07T09:18:40.000000Z","updated_at":"2026-07-15T09:01:02.000000Z"},{"id":21460120,"change_date":"2026-07-04 21:33:00","inspection_id":"88319233","insp_unit_id":"214446054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HV2501628","insp_unit_license":"PD73182","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K0SJ078984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-07T09:18:40.000000Z","updated_at":"2026-07-15T09:01:02.000000Z"}]},{"id":12361899,"change_date":"2026-07-05 21:33:00","inspection_id":"88323531","dot_number":"4037274","report_state":"WI","report_number":"2620001221","insp_date":"2026-07-02 00:00:00","insp_start_time":"0829","insp_end_time":"0934","registration_date":null,"region":"CD","ci_status_code":"C","location":"S41","location_desc":"LITTLE SUAMICO WI","county_code_state":"WI","county_code":"083","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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-07-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"128889","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":"3686159","transaction_code":"A","transaction_date":"2026-07-04 00:00:00","upload_date":"2026-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-07-05 21:33:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-05 21:33:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR STE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-08T09:40:28.000000Z","updated_at":"2026-07-15T09:30:38.000000Z","inspection_violations":[{"id":21515972,"change_date":"2026-07-05 21:33:00","inspection_id":"88323531","insp_violation_id":"275309801","seq_no":"1","part_no":"393","part_no_section":"9A-LRLIWR","insp_viol_unit":"2","insp_unit_id":"214453362","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-07-08T09:58:06.000000Z","updated_at":"2026-07-15T09:41:36.000000Z","normalized_code":"3939ALRLIWR"},{"id":21515973,"change_date":"2026-07-05 21:33:00","inspection_id":"88323531","insp_violation_id":"275309802","seq_no":"2","part_no":"393","part_no_section":"67C7V-F","insp_viol_unit":"1","insp_unit_id":"214453361","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-08T09:58:06.000000Z","updated_at":"2026-07-15T09:41:36.000000Z","normalized_code":"39367C7VF"}],"inspection_per_units":[{"id":21466946,"change_date":"2026-07-05 21:33:00","inspection_id":"88323531","insp_unit_id":"214453362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"26404ST","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"13NZ542C5P1555386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-08T09:17:23.000000Z","updated_at":"2026-07-15T09:01:57.000000Z"},{"id":21466945,"change_date":"2026-07-05 21:33:00","inspection_id":"88323531","insp_unit_id":"214453361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"910","insp_unit_license":"NO PLATE","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4LSLH2179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-08T09:17:23.000000Z","updated_at":"2026-07-15T09:01:57.000000Z"}]},{"id":12361925,"change_date":"2026-07-05 21:33:00","inspection_id":"88323559","dot_number":"4037274","report_state":"GA","report_number":"1481000274","insp_date":"2026-07-02 00:00:00","insp_start_time":"1137","insp_end_time":"1154","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TUCKER GA","county_code_state":"GA","county_code":"089","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"3686180","transaction_code":"A","transaction_date":"2026-07-04 00:00:00","upload_date":"2026-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-07-05 21:33:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-05 21:33:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR STE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-08T09:40:28.000000Z","updated_at":"2026-07-15T09:30:38.000000Z","inspection_violations":[{"id":21516005,"change_date":"2026-07-05 21:33:00","inspection_id":"88323559","insp_violation_id":"275309839","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W02E326389","created_at":"2026-07-08T09:58:06.000000Z","updated_at":"2026-07-15T09:41:36.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21466988,"change_date":"2026-07-05 21:33:00","inspection_id":"88323559","insp_unit_id":"214453409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"UNIT AT001","insp_unit_license":"013768A","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3AKJGLDR3KSLE9738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-08T09:17:23.000000Z","updated_at":"2026-07-15T09:01:57.000000Z"}]},{"id":12352660,"change_date":"2026-07-03 21:37:00","inspection_id":"88313734","dot_number":"4037274","report_state":"WI","report_number":"2683000217","insp_date":"2026-06-30 00:00:00","insp_start_time":"0805","insp_end_time":"0815","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EDGERTON WI","county_code_state":"WI","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"732305","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":"3677321","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-07-03 21:37:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-03 21:37:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR STE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-06T09:43:19.000000Z","updated_at":"2026-07-14T09:32:07.000000Z","inspection_violations":[{"id":21500650,"change_date":"2026-07-03 21:37:00","inspection_id":"88313734","insp_violation_id":"275291366","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","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":"2026-07-06T10:07:22.000000Z","updated_at":"2026-07-14T09:44:45.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":21451474,"change_date":"2026-07-03 21:37:00","inspection_id":"88313734","insp_unit_id":"214436055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"32","insp_unit_license":"P1365158","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FUJHHDR9MLMJ5402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-06T09:21:34.000000Z","updated_at":"2026-07-14T09:04:07.000000Z"},{"id":21451475,"change_date":"2026-07-03 21:37:00","inspection_id":"88313734","insp_unit_id":"214436056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V507089","insp_unit_license":"HV43845","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C9KR955045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-06T09:21:34.000000Z","updated_at":"2026-07-14T09:04:07.000000Z"}]},{"id":12301951,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","dot_number":"4037274","report_state":"AZ","report_number":"XC40460808","insp_date":"2026-06-25 00:00:00","insp_start_time":"0632","insp_end_time":"0721","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZMCGS","location_desc":"SEDONA AZ","county_code_state":"AZ","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CLARION BOARDS\/WEL LOGISTICS","shipping_paper_number":"540140","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-06-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3635949","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-27 21:42:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:42:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR STE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:21.000000Z","updated_at":"2026-07-08T09:31:11.000000Z","inspection_violations":[{"id":21411048,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_violation_id":"275169687","seq_no":"1","part_no":"392","part_no_section":"2-INAT","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-06-30T09:58:51.000000Z","updated_at":"2026-07-08T09:42:05.000000Z","normalized_code":"3922INAT"},{"id":21411049,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_violation_id":"275169688","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","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":"2026-06-30T09:58:51.000000Z","updated_at":"2026-07-08T09:42:05.000000Z","normalized_code":"3922SLLDL"},{"id":21411050,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_violation_id":"275169689","seq_no":"3","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"214325941","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-30T09:58:51.000000Z","updated_at":"2026-07-08T09:42:05.000000Z","normalized_code":"39323LEU"},{"id":21411051,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_violation_id":"275169690","seq_no":"4","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"214325940","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-30T09:58:51.000000Z","updated_at":"2026-07-08T09:42:05.000000Z","normalized_code":"393209ESPSLA"}],"inspection_per_units":[{"id":21367293,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_unit_id":"214325940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1121","insp_unit_license":"010548A","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3AKJHHDR0LSLR0991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:41.000000Z","updated_at":"2026-07-08T09:02:44.000000Z"},{"id":21367294,"change_date":"2026-06-27 21:42:00","inspection_id":"88259077","insp_unit_id":"214325941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"SS122079","insp_unit_license":"594935T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532K3SS122079","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:41.000000Z","updated_at":"2026-07-08T09:02:44.000000Z"}]},{"id":12292465,"change_date":"2026-06-26 21:39:00","inspection_id":"88248538","dot_number":"4037274","report_state":"MS","report_number":"6621112072","insp_date":"2026-06-24 00:00:00","insp_start_time":"0944","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"23","location_desc":"HANCOCK COUNTY","county_code_state":"MS","county_code":"045","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1154671","transaction_code":"A","transaction_date":"2026-06-24 00:00:00","upload_date":"2026-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-26 21:39:00","snet_input_date":"2026-06-26 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-06-26 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DR","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240-1633","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-29T09:41:23.000000Z","updated_at":"2026-07-07T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21351084,"change_date":"2026-06-26 21:39:00","inspection_id":"88248538","insp_unit_id":"214305386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"P1267904","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4MSMF3376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:38.000000Z","updated_at":"2026-07-07T09:02:29.000000Z"},{"id":21351085,"change_date":"2026-06-26 21:39:00","inspection_id":"88248538","insp_unit_id":"214305387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"P853268","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D6LL226885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-29T09:16:38.000000Z","updated_at":"2026-07-07T09:02:29.000000Z"}]},{"id":12248396,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","dot_number":"4037274","report_state":"CT","report_number":"3081A00736","insp_date":"2026-06-22 00:00:00","insp_start_time":"1003","insp_end_time":"1115","registration_date":"2026-06-23 00:00:00","region":"ES","ci_status_code":"C","location":"145S","location_desc":"CT","county_code_state":"CT","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3594532","transaction_code":"C","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-22 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-22 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:49.000000Z","updated_at":"2026-07-04T09:30:13.000000Z","inspection_violations":[{"id":21319072,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_violation_id":"275076546","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"214239725","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:10.000000Z","updated_at":"2026-07-04T09:43:17.000000Z","normalized_code":"3922SLLIRP"},{"id":21319073,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_violation_id":"275076547","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214239725","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:10.000000Z","updated_at":"2026-07-04T09:43:17.000000Z","normalized_code":"39395F"},{"id":21319074,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_violation_id":"275076548","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214239725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:10.000000Z","updated_at":"2026-07-04T09:43:17.000000Z","normalized_code":"39345B2BAIR"},{"id":21319075,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_violation_id":"275076549","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214239725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:10.000000Z","updated_at":"2026-07-04T09:43:17.000000Z","normalized_code":"39345B2BAIR"},{"id":21319076,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_violation_id":"275076550","seq_no":"5","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"214239726","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:10.000000Z","updated_at":"2026-07-04T09:43:17.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":21270203,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_unit_id":"214239725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"136","insp_unit_license":"PXF6430","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR4PSUG1823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:10.000000Z","updated_at":"2026-07-05T09:03:02.000000Z"},{"id":21270204,"change_date":"2026-06-23 21:39:00","inspection_id":"88206719","insp_unit_id":"214239726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"B19197","insp_unit_license":"62L7VY","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1DW1A5323PBB19197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:10.000000Z","updated_at":"2026-07-05T09:03:02.000000Z"}]},{"id":12238090,"change_date":"2026-06-20 21:34:00","inspection_id":"88195879","dot_number":"4037274","report_state":"SC","report_number":"0288007162","insp_date":"2026-06-19 00:00:00","insp_start_time":"0816","insp_end_time":"0836","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WALTERBORO SC","county_code_state":"SC","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TARGET","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":"2026-06-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3582712","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-20 21:34:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-20 21:34:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-23T09:40:41.000000Z","updated_at":"2026-07-02T09:30:04.000000Z","inspection_violations":[{"id":21301079,"change_date":"2026-06-20 21:34:00","inspection_id":"88195879","insp_violation_id":"275027190","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WB05948","created_at":"2026-06-23T10:01:15.000000Z","updated_at":"2026-07-02T09:40:57.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":21253085,"change_date":"2026-06-20 21:34:00","inspection_id":"88195879","insp_unit_id":"214200742","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"136","insp_unit_license":"PXF6430","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR4PSUG1823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-23T09:16:55.000000Z","updated_at":"2026-07-01T09:00:49.000000Z"},{"id":21253086,"change_date":"2026-06-20 21:34:00","inspection_id":"88195879","insp_unit_id":"214200743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"7322619","insp_unit_license":"6840KJ","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C6FT280277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-23T09:16:55.000000Z","updated_at":"2026-07-01T09:00:49.000000Z"}]},{"id":12225690,"change_date":"2026-06-18 21:42:00","inspection_id":"88183680","dot_number":"4037274","report_state":"NM","report_number":"4935Q4OHKG","insp_date":"2026-06-17 00:00:00","insp_start_time":"0745","insp_end_time":"0815","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"NM","county_code_state":"NM","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"0000","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-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3574871","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:43.000000Z","updated_at":"2026-06-29T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21231947,"change_date":"2026-06-18 21:42:00","inspection_id":"88183680","insp_unit_id":"214178307","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"UNIT AT001","insp_unit_license":"013768A","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3AKJGLDR3KSLE9738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:35.000000Z","updated_at":"2026-06-29T09:02:27.000000Z"},{"id":21231948,"change_date":"2026-06-18 21:42:00","inspection_id":"88183680","insp_unit_id":"214178308","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"UNIT 7564","insp_unit_license":"403954Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D0HL027564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:35.000000Z","updated_at":"2026-06-29T09:02:27.000000Z"}]},{"id":12172333,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","dot_number":"4037274","report_state":"GA","report_number":"1435001722","insp_date":"2026-06-09 00:00:00","insp_start_time":"0910","insp_end_time":"1010","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FORSYTH GA","county_code_state":"GA","county_code":"207","insp_level_id":"3","service_center":"SH","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3526561","transaction_code":"A","transaction_date":"2026-06-11 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"9 N 3RD ST","insp_carrier_city":"NEWARK","insp_carrier_state":"OH","insp_carrier_zip_code":"43055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:33.000000Z","updated_at":"2026-06-23T09:30:54.000000Z","inspection_violations":[{"id":21184036,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_violation_id":"274873191","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W02E277135","created_at":"2026-06-16T10:05:59.000000Z","updated_at":"2026-06-23T09:42:06.000000Z","normalized_code":"3922SLLTCD"},{"id":21184037,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_violation_id":"274873192","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"W02E277136","created_at":"2026-06-16T10:05:59.000000Z","updated_at":"2026-06-23T09:42:06.000000Z","normalized_code":"3958A1HOSP"},{"id":21184038,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_violation_id":"274873193","seq_no":"3","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E06039328","created_at":"2026-06-16T10:05:59.000000Z","updated_at":"2026-06-23T09:42:06.000000Z","normalized_code":"3922SLLLR"},{"id":21184039,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_violation_id":"274873194","seq_no":"4","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:59.000000Z","updated_at":"2026-06-23T09:42:06.000000Z","normalized_code":"39522GELDMFV"},{"id":21184040,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_violation_id":"274873195","seq_no":"5","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"214070483","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:05:59.000000Z","updated_at":"2026-06-23T09:42:06.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":21143226,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_unit_id":"214070483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"910","insp_unit_license":"NO TAG","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4LSLH2179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:37.000000Z","updated_at":"2026-06-23T09:02:28.000000Z"},{"id":21143227,"change_date":"2026-06-12 21:41:00","inspection_id":"88126993","insp_unit_id":"214070484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"9004","insp_unit_license":"HV44804","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532CXLR439004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:37.000000Z","updated_at":"2026-06-23T09:02:28.000000Z"}]},{"id":12133390,"change_date":"2026-06-09 21:41:00","inspection_id":"88079587","dot_number":"4037274","report_state":"SC","report_number":"0346003473","insp_date":"2026-06-08 00:00:00","insp_start_time":"1758","insp_end_time":"1821","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHAPIN SC","county_code_state":"SC","county_code":"079","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52235","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":"3496700","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-09 21:41:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:41:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"9 N 3RD ST","insp_carrier_city":"NEWARK","insp_carrier_state":"OH","insp_carrier_zip_code":"43055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:57.000000Z","updated_at":"2026-06-20T09:32:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21080245,"change_date":"2026-06-09 21:41:00","inspection_id":"88079587","insp_unit_id":"213982686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1810","insp_unit_license":"PXF7553","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HSDZAPR9NN454576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:42.000000Z","updated_at":"2026-06-20T09:03:57.000000Z"}]},{"id":12120323,"change_date":"2026-06-07 21:34:00","inspection_id":"88065760","dot_number":"4037274","report_state":"NC","report_number":"0006882716","insp_date":"2026-06-07 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"ED","ci_status_code":"C","location":"NEAR T","location_desc":"SPRUCE PINE NC","county_code_state":"NC","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3486231","transaction_code":"A","transaction_date":"2026-06-07 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-10T09:40:00.000000Z","updated_at":"2026-06-18T09:30:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21057505,"change_date":"2026-06-07 21:34:00","inspection_id":"88065760","insp_unit_id":"213956796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"PXF6074","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4V4NC9EH9JN891107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:50.000000Z","updated_at":"2026-06-18T09:01:52.000000Z"},{"id":21057506,"change_date":"2026-06-07 21:34:00","inspection_id":"88065760","insp_unit_id":"213956797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"PF16415","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K6TS086132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:50.000000Z","updated_at":"2026-06-18T09:01:52.000000Z"}]},{"id":12117996,"change_date":"2026-06-07 21:34:00","inspection_id":"88063318","dot_number":"4037274","report_state":"KS","report_number":"9343000219","insp_date":"2026-06-05 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"CD","ci_status_code":"C","location":"#24W","location_desc":"OLATHE KS","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"T-114Y1PBHZ","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-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3484310","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"9 N 3RD ST","insp_carrier_city":"NEWARK","insp_carrier_state":"OH","insp_carrier_zip_code":"43055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-10T09:39:55.000000Z","updated_at":"2026-06-18T09:30:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21053721,"change_date":"2026-06-07 21:34:00","inspection_id":"88063318","insp_unit_id":"213952692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"02","insp_unit_license":"P1337479","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4NSMV1021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:40.000000Z","updated_at":"2026-06-18T09:01:02.000000Z"},{"id":21053722,"change_date":"2026-06-07 21:34:00","inspection_id":"88063318","insp_unit_id":"213952693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"UNIT400093","insp_unit_license":"PC36111","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0626RB522679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:40.000000Z","updated_at":"2026-06-18T09:01:02.000000Z"}]},{"id":12064022,"change_date":"2026-06-01 21:40:00","inspection_id":"88005860","dot_number":"4037274","report_state":"AR","report_number":"8240001370","insp_date":"2026-05-28 00:00:00","insp_start_time":"0622","insp_end_time":"0650","registration_date":null,"region":"CD","ci_status_code":"C","location":"301","location_desc":"VAN BUREN AR","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"CONAGRA","shipping_paper_number":"034910070441378","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-06-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"3440012","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-06-01 21:40:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:40:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:38:59.000000Z","updated_at":"2026-06-12T09:30:36.000000Z","inspection_violations":[{"id":20991662,"change_date":"2026-06-01 21:40:00","inspection_id":"88005860","insp_violation_id":"274609721","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W000122","created_at":"2026-06-05T09:54:55.000000Z","updated_at":"2026-06-12T09:40:51.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":20966355,"change_date":"2026-06-01 21:40:00","inspection_id":"88005860","insp_unit_id":"213844142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"0937","insp_unit_license":"PXE6891","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR3LSLN0937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:28.000000Z","updated_at":"2026-06-12T09:01:44.000000Z"},{"id":20966356,"change_date":"2026-06-01 21:40:00","inspection_id":"88005860","insp_unit_id":"213844143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"802327","insp_unit_license":"P858803","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532DXNL333263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:28.000000Z","updated_at":"2026-06-12T09:01:44.000000Z"}]},{"id":12026313,"change_date":"2026-05-27 21:40:00","inspection_id":"87966187","dot_number":"4037274","report_state":"CA","report_number":"NCXE003940","insp_date":"2026-05-26 00:00:00","insp_start_time":"0834","insp_end_time":"0852","registration_date":null,"region":"PS","ci_status_code":"C","location":"881","location_desc":"CA","county_code_state":"CA","county_code":"029","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":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3409218","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:29.000000Z","updated_at":"2026-06-07T09:30:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20904244,"change_date":"2026-05-27 21:40:00","inspection_id":"87966187","insp_unit_id":"213770377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"P1337479","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4NSMV1021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:32.000000Z","updated_at":"2026-06-07T09:02:03.000000Z"}]},{"id":11992131,"change_date":"2026-05-22 21:38:00","inspection_id":"87930031","dot_number":"4037274","report_state":"GA","report_number":"1409001198","insp_date":"2026-05-19 00:00:00","insp_start_time":"1350","insp_end_time":"1420","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"POOLER GA","county_code_state":"GA","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3381884","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:10.000000Z","updated_at":"2026-06-02T09:31:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20847729,"change_date":"2026-05-22 21:38:00","inspection_id":"87930031","insp_unit_id":"213702212","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"777","insp_unit_license":"RC49003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8KSKG1150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:11.000000Z","updated_at":"2026-06-02T09:04:51.000000Z"}]},{"id":11945541,"change_date":"2026-05-17 21:35:00","inspection_id":"87880901","dot_number":"4037274","report_state":"TN","report_number":"I033IG0096","insp_date":"2026-05-15 00:00:00","insp_start_time":"1802","insp_end_time":"1824","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LEBANON TN","county_code_state":"TN","county_code":"189","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3347397","transaction_code":"A","transaction_date":"2026-05-16 00:00:00","upload_date":"2026-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-17 21:35:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-17 21:35:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-20T09:41:11.000000Z","updated_at":"2026-05-28T09:30:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20771921,"change_date":"2026-05-17 21:35:00","inspection_id":"87880901","insp_unit_id":"213610253","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"704","insp_unit_license":"PXE5857","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYDP9X5MJ436704","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:20.000000Z","updated_at":"2026-05-28T09:02:07.000000Z"},{"id":20771922,"change_date":"2026-05-17 21:35:00","inspection_id":"87880901","insp_unit_id":"213610254","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNG HV2504831","insp_unit_license":"PD77180","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K3SS076432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-20T09:17:20.000000Z","updated_at":"2026-05-28T09:02:07.000000Z"}]},{"id":11922383,"change_date":"2026-05-15 21:43:00","inspection_id":"87856612","dot_number":"4037274","report_state":"OH","report_number":"3218000362","insp_date":"2026-05-13 00:00:00","insp_start_time":"1249","insp_end_time":"1313","registration_date":null,"region":"ED","ci_status_code":"C","location":"01","location_desc":"CAMBRIDGE OH","county_code_state":"OH","county_code":"059","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CABELAS","shipping_paper_number":"1500904","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-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3328887","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-15 21:43:00","snet_input_date":"2026-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:43:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:24.000000Z","updated_at":"2026-05-26T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20734710,"change_date":"2026-05-15 21:43:00","inspection_id":"87856612","insp_unit_id":"213568446","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"1033","insp_unit_license":"PXE5249","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYD49X3LJ392635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:32.000000Z","updated_at":"2026-05-26T09:02:35.000000Z"},{"id":20734711,"change_date":"2026-05-15 21:43:00","inspection_id":"87856612","insp_unit_id":"213568447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"906338","insp_unit_license":"245607T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GR1P0628PD509352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:32.000000Z","updated_at":"2026-05-26T09:02:35.000000Z"}]},{"id":11885579,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","dot_number":"4037274","report_state":"MO","report_number":"W105004692","insp_date":"2026-05-12 00:00:00","insp_start_time":"1018","insp_end_time":"1111","registration_date":null,"region":"CD","ci_status_code":"C","location":"E1S","location_desc":"CHARLESTON MO","county_code_state":"MO","county_code":"133","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TARGET CORP","shipping_paper_number":"SIQ1478006","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-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3306949","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:29.000000Z","updated_at":"2026-05-23T09:30:54.000000Z","inspection_violations":[{"id":20672664,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198139","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213503726","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39347E"},{"id":20672666,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198141","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213503726","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39347E"},{"id":20672670,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198145","seq_no":"7","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213503725","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"3939ALRLI"},{"id":20672665,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198140","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213503725","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39347E"},{"id":20672668,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198143","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213503726","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39353BB"},{"id":20672669,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198144","seq_no":"6","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213503725","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39395A4EEUS"},{"id":20672671,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198146","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"213503725","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"3963A1BOS"},{"id":20672667,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_violation_id":"274198142","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213503725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:59.000000Z","updated_at":"2026-05-23T09:44:44.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":20665187,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_unit_id":"213503725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"777","insp_unit_license":"RC49003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8KSKG1150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:31.000000Z","updated_at":"2026-05-23T09:03:46.000000Z"},{"id":20665188,"change_date":"2026-05-12 21:39:00","inspection_id":"87823468","insp_unit_id":"213503726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"664302","insp_unit_license":"4742KS","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D4FL885892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:31.000000Z","updated_at":"2026-05-23T09:03:46.000000Z"}]},{"id":11897558,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","dot_number":"4037274","report_state":"MO","report_number":"0384001206","insp_date":"2026-05-12 00:00:00","insp_start_time":"1320","insp_end_time":"1505","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WRIGHT CITY MO","county_code_state":"MO","county_code":"219","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON FULFILLMENT","shipping_paper_number":"1410972","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-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3315913","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:56.000000Z","updated_at":"2026-05-24T09:31:26.000000Z","inspection_violations":[{"id":20694430,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228384","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"213528667","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"3939ALRLI"},{"id":20694431,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228385","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213528667","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"39395A1"},{"id":20694432,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228386","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213528668","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"39347E"},{"id":20694435,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228389","seq_no":"6","part_no":"392","part_no_section":"2-SLLLR","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-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"3922SLLLR"},{"id":20694433,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228387","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213528668","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"39353BB"},{"id":20694434,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_violation_id":"274228388","seq_no":"5","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"2","insp_unit_id":"213528668","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:18.000000Z","updated_at":"2026-05-24T09:45:06.000000Z","normalized_code":"39355C2B"}],"inspection_per_units":[{"id":20684871,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_unit_id":"213528667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"910","insp_unit_license":"MAS316336-TE","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4LSLH2179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:34.000000Z","updated_at":"2026-05-24T09:04:39.000000Z"},{"id":20684872,"change_date":"2026-05-13 21:42:00","inspection_id":"87836120","insp_unit_id":"213528668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGV500300","insp_unit_license":"HV01676","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C8GT674106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:34.000000Z","updated_at":"2026-05-24T09:04:39.000000Z"}]},{"id":11869641,"change_date":"2026-05-11 21:38:00","inspection_id":"87806627","dot_number":"4037274","report_state":"TN","report_number":"I032630096","insp_date":"2026-05-09 00:00:00","insp_start_time":"2003","insp_end_time":"2020","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHATTANOOGA TN","county_code_state":"TN","county_code":"065","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"0056950176","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-05-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3295786","transaction_code":"A","transaction_date":"2026-05-10 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:17.000000Z","updated_at":"2026-05-22T09:30:17.000000Z","inspection_violations":[{"id":20645670,"change_date":"2026-05-11 21:38:00","inspection_id":"87806627","insp_violation_id":"274160734","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-05-13T13:32:21.000000Z","updated_at":"2026-05-22T09:41:31.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20639157,"change_date":"2026-05-11 21:38:00","inspection_id":"87806627","insp_unit_id":"213471801","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"001","insp_unit_license":"AY723X","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3AKJGLDR4JSHF3990","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:04:51.000000Z","updated_at":"2026-05-22T09:02:26.000000Z"},{"id":20639158,"change_date":"2026-05-11 21:38:00","inspection_id":"87806627","insp_unit_id":"213471802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V568902","insp_unit_license":"TP1774","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C3MR731191","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:04:51.000000Z","updated_at":"2026-05-22T09:02:26.000000Z"}]},{"id":11879647,"change_date":"2026-05-15 21:45:00","inspection_id":"87817170","dot_number":"4037274","report_state":"TX","report_number":"V262339331","insp_date":"2026-05-07 00:00:00","insp_start_time":"1104","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RAW DEAL LOGISTICS","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":"Y","pen_cen_match":null,"final_status_date":"2026-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9949599","transaction_code":"C","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":"M","census_search_date":"2026-05-11 21:39:00","snet_input_date":"2026-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-11 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1115515","created_at":"2026-05-13T13:15:34.000000Z","updated_at":"2026-05-26T09:30:10.000000Z","inspection_violations":[{"id":20660584,"change_date":"2026-05-15 21:45:00","inspection_id":"87817170","insp_violation_id":"274299663","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"213589055","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-13T13:33:14.000000Z","updated_at":"2026-05-26T09:45:51.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":20655582,"change_date":"2026-05-15 21:45:00","inspection_id":"87817170","insp_unit_id":"213589055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTE","insp_unit_company":"3087","insp_unit_license":"PXF0568","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HSDZAPR2KN553087","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:26.000000Z","updated_at":"2026-05-26T09:01:56.000000Z"}]},{"id":11654741,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","dot_number":"4037274","report_state":"NV","report_number":"7023029824","insp_date":"2026-04-14 00:00:00","insp_start_time":"0917","insp_end_time":"0948","registration_date":"2026-04-15 00:00:00","region":"PD","ci_status_code":"C","location":"2","location_desc":"NV","county_code_state":"NV","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"USPS","shipping_paper_number":"FA2BT","cargo_tank":null,"hazmat_placard_req":"N","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-04-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3162107","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-04-15 21:39:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:49.000000Z","updated_at":"2026-04-26T09:30:49.000000Z","inspection_violations":[{"id":20238646,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","insp_violation_id":"273620130","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-04-26T09:41:32.000000Z","updated_at":"2026-04-26T09:41:32.000000Z","normalized_code":"3922SLLTCD"},{"id":20238647,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","insp_violation_id":"273620131","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213031037","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:41:32.000000Z","updated_at":"2026-04-26T09:41:32.000000Z","normalized_code":"3922SLLSR"},{"id":20238648,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","insp_violation_id":"273620132","seq_no":"3","part_no":"393","part_no_section":"60E","insp_viol_unit":"1","insp_unit_id":"213031037","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-26T09:41:32.000000Z","updated_at":"2026-04-26T09:41:32.000000Z","normalized_code":"39360E"}],"inspection_per_units":[{"id":20272983,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","insp_unit_id":"213031037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"777","insp_unit_license":"RC49003","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR8KSKG1150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:03:32.000000Z","updated_at":"2026-04-26T09:03:32.000000Z"},{"id":20272984,"change_date":"2026-04-15 21:39:00","inspection_id":"87584429","insp_unit_id":"213031038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"620018","insp_unit_license":"PD39553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D4SL476916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:03:32.000000Z","updated_at":"2026-04-26T09:03:32.000000Z"}]},{"id":11650408,"change_date":"2026-04-15 21:38:00","inspection_id":"87579977","dot_number":"4037274","report_state":"LA","report_number":"LANKS00606","insp_date":"2026-04-13 00:00:00","insp_start_time":"2052","insp_end_time":"2108","registration_date":null,"region":"CD","ci_status_code":"C","location":"50","location_desc":"DELHI LA","county_code_state":"LA","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3159700","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:17.000000Z","updated_at":"2026-04-26T09:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20265332,"change_date":"2026-04-15 21:38:00","inspection_id":"87579977","insp_unit_id":"213023080","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"001","insp_unit_license":"ZP33071","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR1LSLH2298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:37.000000Z","updated_at":"2026-04-26T09:02:37.000000Z"},{"id":20265333,"change_date":"2026-04-15 21:38:00","inspection_id":"87579977","insp_unit_id":"213023081","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGV570584","insp_unit_license":"P895407","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C3MR733359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:02:37.000000Z","updated_at":"2026-04-26T09:02:37.000000Z"}]},{"id":11659253,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","dot_number":"4037274","report_state":"AL","report_number":"1856001346","insp_date":"2026-04-13 00:00:00","insp_start_time":"1058","insp_end_time":"1139","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GADSDEN AL","county_code_state":"AL","county_code":"055","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"THE CHILDREN'S PLACE CHILDREN'S APPAREL","shipping_paper_number":"42605888971","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-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3165751","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:40.000000Z","updated_at":"2026-04-27T09:30:40.000000Z","inspection_violations":[{"id":20249286,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","insp_violation_id":"273633148","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-04-27T09:43:08.000000Z","updated_at":"2026-04-27T09:43:08.000000Z","normalized_code":"3922SLLS1"},{"id":20249287,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","insp_violation_id":"273633149","seq_no":"2","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"213040593","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:08.000000Z","updated_at":"2026-04-27T09:43:08.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":20249288,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","insp_violation_id":"273633150","seq_no":"3","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:08.000000Z","updated_at":"2026-04-27T09:43:08.000000Z","normalized_code":"39522GELDMFV"}],"inspection_per_units":[{"id":20281438,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","insp_unit_id":"213040593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"001","insp_unit_license":"ZP33071","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR1LSLH2298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:15.000000Z","updated_at":"2026-04-27T09:03:15.000000Z"},{"id":20281439,"change_date":"2026-04-16 21:40:00","inspection_id":"87589165","insp_unit_id":"213040594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"AZNGV570584","insp_unit_license":"P895407","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C3MR733359","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:15.000000Z","updated_at":"2026-04-27T09:03:15.000000Z"}]},{"id":11534929,"change_date":"2026-04-01 21:39:00","inspection_id":"87456943","dot_number":"4037274","report_state":"MO","report_number":"W158004223","insp_date":"2026-03-30 00:00:00","insp_start_time":"0811","insp_end_time":"0845","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SILVA MO","county_code_state":"MO","county_code":"223","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KIMBERLYCLARK","shipping_paper_number":"0056761467","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-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3099494","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-04-01 21:39:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-01 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:15.000000Z","updated_at":"2026-04-12T09:30:46.000000Z","inspection_violations":[{"id":19490321,"change_date":"2026-04-01 21:39:00","inspection_id":"87456943","insp_violation_id":"272781336","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"212462038","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:12:56.000000Z","updated_at":"2026-04-11T09:46:33.000000Z","normalized_code":"3922SLLMF"},{"id":19490322,"change_date":"2026-04-01 21:39:00","inspection_id":"87456943","insp_violation_id":"272781337","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212462037","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:12:56.000000Z","updated_at":"2026-04-11T09:46:33.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":19764137,"change_date":"2026-04-01 21:39:00","inspection_id":"87456943","insp_unit_id":"212462037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"443","insp_unit_license":"P1329934","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR3NSMZ7682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:34.000000Z","updated_at":"2026-04-12T09:08:05.000000Z"},{"id":19764138,"change_date":"2026-04-01 21:39:00","inspection_id":"87456943","insp_unit_id":"212462038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"GV2501325","insp_unit_license":"PD97204","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0624SK629848","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:34.000000Z","updated_at":"2026-04-12T09:08:05.000000Z"}]},{"id":11424963,"change_date":"2026-03-20 21:39:00","inspection_id":"87340931","dot_number":"4037274","report_state":"SC","report_number":"0182000328","insp_date":"2026-03-20 00:00:00","insp_start_time":"0724","insp_end_time":"0743","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROCK HILL SC","county_code_state":"SC","county_code":"091","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3030750","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:32.000000Z","updated_at":"2026-03-31T09:30:47.000000Z","inspection_violations":[{"id":19273973,"change_date":"2026-03-20 21:39:00","inspection_id":"87340931","insp_violation_id":"272519689","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"PCWB322277","created_at":"2026-03-23T10:13:31.000000Z","updated_at":"2026-03-31T09:49:01.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":19571485,"change_date":"2026-03-20 21:39:00","inspection_id":"87340931","insp_unit_id":"212236020","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"PXE6891","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR3LSLN0937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:58.000000Z","updated_at":"2026-03-31T09:08:53.000000Z"},{"id":19571486,"change_date":"2026-03-20 21:39:00","inspection_id":"87340931","insp_unit_id":"212236021","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"PC92237","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K6RS025145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:29:58.000000Z","updated_at":"2026-03-31T09:08:53.000000Z"}]},{"id":10906310,"change_date":"2026-02-02 21:38:00","inspection_id":"86937994","dot_number":"4037274","report_state":"KS","report_number":"HP93330490","insp_date":"2026-01-30 00:00:00","insp_start_time":"1748","insp_end_time":"1806","registration_date":null,"region":"CT","ci_status_code":"C","location":"#37","location_desc":"LIBERAL M.C.I.S. #37A","county_code_state":"KS","county_code":"175","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"ONT5-116R2LJWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-02 21:38: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":"1387686","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2026-02-02 21:38:00","snet_input_date":"2026-01-30 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-02-02 21:38:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE 900","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-05T10:35:43.000000Z","updated_at":"2026-02-13T10:30:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18339070,"change_date":"2026-02-02 21:38:00","inspection_id":"86937994","insp_unit_id":"211396942","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"HV2603901","insp_unit_license":"PF28534","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K1TS098902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:41.000000Z","updated_at":"2026-02-13T10:05:17.000000Z"},{"id":18339069,"change_date":"2026-02-02 21:38:00","inspection_id":"86937994","insp_unit_id":"211396941","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"701","insp_unit_license":"P1313410","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR0NSNB8774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:41.000000Z","updated_at":"2026-02-13T10:05:17.000000Z"}]},{"id":10314969,"change_date":"2025-12-01 21:38:00","inspection_id":"86441495","dot_number":"4037274","report_state":"NM","report_number":"0309P99B8P","insp_date":"2025-11-29 00:00:00","insp_start_time":"0907","insp_end_time":"0927","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"1127CVZDS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:38: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":"2236679","transaction_code":"A","transaction_date":"2025-11-29 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04037274","upload_search_indicator":null,"census_search_date":"2025-12-01 21:38:00","snet_input_date":"2025-12-01 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-12-01 21:38:00","insp_carrier_name":"RAWDEAL LOGISTICS LLC","insp_carrier_street":"1255 KEMPER MEADOW DRIVE SUITE","insp_carrier_city":"CINCINNATI","insp_carrier_state":"OH","insp_carrier_zip_code":"45240","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:30.000000Z","updated_at":"2025-12-05T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17225427,"change_date":"2025-12-01 21:38:00","inspection_id":"86441495","insp_unit_id":"210325318","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT777","insp_unit_license":"P1267904","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR4MSMF3376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:32.000000Z","updated_at":"2025-12-05T10:00:51.000000Z"},{"id":17225428,"change_date":"2025-12-01 21:38:00","inspection_id":"86441495","insp_unit_id":"210325319","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT2303417","insp_unit_license":"PB54959","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K7PS062475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:32.000000Z","updated_at":"2025-12-05T10:00:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4037274\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4037274\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4037274\/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\/4037274\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}