{"current_page":1,"data":[{"id":11626153,"change_date":"2026-04-12 21:33:00","inspection_id":"87554544","dot_number":"2119119","report_state":"IL","report_number":"5014500021","insp_date":"2026-04-10 00:00:00","insp_start_time":"0940","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"022","location_desc":"022 - PITTSFIELD - US36 & US54","county_code_state":"IL","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CERTAINTEED LLC","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-04-12 21:33: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":"2466515","transaction_code":"A","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-10 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-04-12 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-23T09:30:24.000000Z","updated_at":"2026-04-23T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20220645,"change_date":"2026-04-12 21:33:00","inspection_id":"87554544","insp_unit_id":"212974083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W4","insp_unit_license":"16KR1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPFA97X0VN429761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-23T09:03:24.000000Z","updated_at":"2026-04-23T09:03:24.000000Z"},{"id":20220646,"change_date":"2026-04-12 21:33:00","inspection_id":"87554544","insp_unit_id":"212974084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":"001","insp_unit_license":"15L4JF","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1R1F74823WK980998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-23T09:03:24.000000Z","updated_at":"2026-04-23T09:03:24.000000Z"}]},{"id":10039443,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","dot_number":"2119119","report_state":"MO","report_number":"W135009978","insp_date":"2025-10-21 00:00:00","insp_start_time":"0840","insp_end_time":"0949","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"HAYTI MO","county_code_state":"MO","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREENBRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2461501","transaction_code":"A","transaction_date":"2025-10-26 00:00:00","upload_date":"2025-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-10-26 21:34:00","snet_input_date":"2025-10-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-26 21:34:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-29T10:00:28.000000Z","updated_at":"2025-10-30T10:00:20.000000Z","inspection_violations":[{"id":16607382,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523733","seq_no":"1","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"209661426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"39311A1LFTSM"},{"id":16607383,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523734","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"209661426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3939AHLLH"},{"id":16607384,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523735","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209661426","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"39360D"},{"id":16607385,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523736","seq_no":"4","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"209661427","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3922SLLMF"},{"id":16607386,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523737","seq_no":"5","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"2","insp_unit_id":"209661427","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"393201AFRCLS"},{"id":16607387,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523738","seq_no":"6","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"209661427","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3939ALTSI"},{"id":16607388,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523739","seq_no":"7","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"209661427","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3939ALLPL"},{"id":16607389,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523740","seq_no":"8","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":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3922SLLED"},{"id":16607390,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523741","seq_no":"9","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:47.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"39216D"},{"id":16607391,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_violation_id":"269523742","seq_no":"10","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"209661426","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-29T10:15:48.000000Z","updated_at":"2025-10-30T10:15:30.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":16679124,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_unit_id":"209661426","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W8","insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-29T09:45:40.000000Z","updated_at":"2025-10-30T09:45:28.000000Z"},{"id":16679125,"change_date":"2025-10-26 21:34:00","inspection_id":"86151602","insp_unit_id":"209661427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"60L6VX","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYFS2459VA125832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-29T09:45:40.000000Z","updated_at":"2025-10-30T09:45:28.000000Z"}]},{"id":9916695,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","dot_number":"2119119","report_state":"MO","report_number":"0384000966","insp_date":"2025-10-07 00:00:00","insp_start_time":"0255","insp_end_time":"1605","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EOLIA MO","county_code_state":"MO","county_code":"163","insp_level_id":"2","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":"2025-10-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2396755","transaction_code":"A","transaction_date":"2025-10-11 00:00:00","upload_date":"2025-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-10-11 21:33:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-11 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-14T10:01:33.000000Z","updated_at":"2025-10-15T10:00:20.000000Z","inspection_violations":[{"id":16363921,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245361","seq_no":"4","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"209420083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"3939ALTSIR"},{"id":16363922,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245362","seq_no":"5","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209420083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"3939ALBL"},{"id":16363923,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245363","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209420083","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"39345B2BAIR"},{"id":16363924,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245364","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"209420083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"3939AHLLH"},{"id":16363925,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245365","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209420083","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"39617CPI"},{"id":16363926,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245366","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209420084","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"39617CPI"},{"id":16363927,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_violation_id":"269245367","seq_no":"7","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"209420084","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-14T10:17:34.000000Z","updated_at":"2025-10-15T10:15:32.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":16457458,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_unit_id":"209420083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"W 10","insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:58.000000Z","updated_at":"2025-10-15T09:45:24.000000Z"},{"id":16457459,"change_date":"2025-10-11 21:33:00","inspection_id":"86021901","insp_unit_id":"209420084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEHAUF","insp_unit_company":"NIR 11","insp_unit_license":"64L7VX","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1H2P04524SW080801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:58.000000Z","updated_at":"2025-10-15T09:45:24.000000Z"}]},{"id":9823686,"change_date":"2025-10-01 21:39:00","inspection_id":"85924178","dot_number":"2119119","report_state":"MO","report_number":"5745002495","insp_date":"2025-09-30 00:00:00","insp_start_time":"1410","insp_end_time":"1440","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2350066","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-10-01 21:39:00","snet_input_date":"2025-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-01 21:39:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-04T10:01:36.000000Z","updated_at":"2025-10-05T10:00:31.000000Z","inspection_violations":[{"id":16169581,"change_date":"2025-10-01 21:39:00","inspection_id":"85924178","insp_violation_id":"269023365","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"209234239","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:44.000000Z","updated_at":"2025-10-05T10:15:48.000000Z","normalized_code":"3922SLLMF"},{"id":16169582,"change_date":"2025-10-01 21:39:00","inspection_id":"85924178","insp_violation_id":"269023366","seq_no":"2","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":"2025-10-04T10:17:44.000000Z","updated_at":"2025-10-05T10:15:48.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16286343,"change_date":"2025-10-01 21:39:00","inspection_id":"85924178","insp_unit_id":"209234238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W14","insp_unit_license":"53KT0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB8X7SN378053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:46:58.000000Z","updated_at":"2025-10-05T09:45:40.000000Z"},{"id":16286344,"change_date":"2025-10-01 21:39:00","inspection_id":"85924178","insp_unit_id":"209234239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUMMIT TRA","insp_unit_company":"DT04","insp_unit_license":"18L2AW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2822LE573039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:46:58.000000Z","updated_at":"2025-10-05T09:45:40.000000Z"}]},{"id":9704386,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","dot_number":"2119119","report_state":"MO","report_number":"5745002459","insp_date":"2025-09-17 00:00:00","insp_start_time":"1320","insp_end_time":"1355","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2289679","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:43.000000Z","updated_at":"2025-09-23T10:01:43.000000Z","inspection_violations":[{"id":15926733,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750671","seq_no":"1","part_no":"393","part_no_section":"75B-TF","insp_viol_unit":"1","insp_unit_id":"208996837","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"39375BTF"},{"id":15926734,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750672","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208996838","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15926735,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750673","seq_no":"3","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"208996838","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"393100BC"},{"id":15926736,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750674","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208996838","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15926737,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750675","seq_no":"5","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"208996837","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"3939ALBL"},{"id":15926738,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750676","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"208996838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"3939ALIL"},{"id":15926739,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_violation_id":"268750677","seq_no":"7","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"208996838","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:23.000000Z","updated_at":"2025-09-22T10:16:09.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16065688,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_unit_id":"208996837","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W6","insp_unit_license":"29KR2J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X1XN488358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:47.000000Z","updated_at":"2025-09-21T09:45:24.000000Z"},{"id":16065689,"change_date":"2025-09-17 21:40:00","inspection_id":"85799204","insp_unit_id":"208996838","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PT165014","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"5TU344027JS000294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:47.000000Z","updated_at":"2025-09-21T09:45:24.000000Z"}]},{"id":9691758,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","dot_number":"2119119","report_state":"MO","report_number":"0230000729","insp_date":"2025-09-15 00:00:00","insp_start_time":"0742","insp_end_time":"0905","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BLOOMSDALE MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","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":"2025-09-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"13","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2281761","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-09-16 21:39:00","snet_input_date":"2025-09-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-16 21:39:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:00:57.000000Z","updated_at":"2025-09-23T10:00:32.000000Z","inspection_violations":[{"id":15898742,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717875","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39375A3TAOL"},{"id":15898743,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717876","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39375A3TAOL"},{"id":15898744,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717877","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39347E"},{"id":15898745,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717878","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3965BL"},{"id":15898746,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717879","seq_no":"5","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39353BB"},{"id":15898747,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717880","seq_no":"6","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3939ALSML"},{"id":15898748,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717881","seq_no":"7","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3963A1BOS"},{"id":15898749,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717882","seq_no":"8","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3965BL"},{"id":15898750,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717883","seq_no":"9","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3963A1F"},{"id":15898751,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717884","seq_no":"10","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3939ALLPL"},{"id":15898752,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717885","seq_no":"11","part_no":"393","part_no_section":"47A-BCFSBD","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39347ABCFSBD"},{"id":15898753,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717886","seq_no":"12","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"208971860","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"3965BHWSL"},{"id":15898754,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_violation_id":"268717887","seq_no":"13","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"208971861","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:20.000000Z","updated_at":"2025-09-20T10:15:25.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":16042955,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_unit_id":"208971860","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W6","insp_unit_license":"29KR2J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X1XN488358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:38.000000Z","updated_at":"2025-09-20T09:45:14.000000Z"},{"id":16042956,"change_date":"2025-09-16 21:39:00","inspection_id":"85786056","insp_unit_id":"208971861","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"84C0EV","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1JJF4827XWL420905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:38.000000Z","updated_at":"2025-09-20T09:45:14.000000Z"}]},{"id":9611148,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","dot_number":"2119119","report_state":"MO","report_number":"0469000842","insp_date":"2025-09-03 00:00:00","insp_start_time":"1131","insp_end_time":"1201","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"POPLAR BLUFF MO","county_code_state":"MO","county_code":"051","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-07 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"4","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":"2232350","transaction_code":"A","transaction_date":"2025-09-06 00:00:00","upload_date":"2025-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-09-07 21:33:00","snet_input_date":"2025-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-07 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:55.000000Z","updated_at":"2025-09-10T10:45:55.000000Z","inspection_violations":[{"id":15716725,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","insp_violation_id":"268507089","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"208788007","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:49:02.000000Z","updated_at":"2025-09-11T10:47:32.000000Z","normalized_code":"3939AHLLH"},{"id":15716726,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","insp_violation_id":"268507090","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"208788007","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:49:02.000000Z","updated_at":"2025-09-11T10:47:32.000000Z","normalized_code":"3939ALFTSI"},{"id":15716727,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","insp_violation_id":"268507091","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208788007","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:49:02.000000Z","updated_at":"2025-09-11T10:47:32.000000Z","normalized_code":"39360D"},{"id":15716728,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","insp_violation_id":"268507092","seq_no":"4","part_no":"398","part_no_section":"8D1-MW","insp_viol_unit":"1","insp_unit_id":"208788007","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:49:02.000000Z","updated_at":"2025-09-11T10:47:32.000000Z","normalized_code":"3988D1MW"}],"inspection_per_units":[{"id":15874558,"change_date":"2025-09-07 21:33:00","inspection_id":"85703928","insp_unit_id":"208788007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W8","insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:38.000000Z","updated_at":"2025-09-11T09:53:16.000000Z"}]},{"id":8867379,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","dot_number":"2119119","report_state":"MO","report_number":"3698001843","insp_date":"2025-06-10 00:00:00","insp_start_time":"1412","insp_end_time":"1448","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"2025-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1849102","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-06-11 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-11 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:53.000000Z","updated_at":"2025-06-15T10:00:13.000000Z","inspection_violations":[{"id":14205812,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771608","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"39021TB1MC"},{"id":14205813,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771609","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"3939ALHLI"},{"id":14205814,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771610","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"39345DB"},{"id":14205815,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771611","seq_no":"4","part_no":"396","part_no_section":"3A1-BALR","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"3963A1BALR"},{"id":14205816,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771612","seq_no":"5","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"39311A1LBL"},{"id":14205817,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771613","seq_no":"6","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"39021TB2DOT"},{"id":14205818,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_violation_id":"266771614","seq_no":"7","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"207322706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:20.000000Z","updated_at":"2025-06-17T10:16:54.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":14522528,"change_date":"2025-06-11 21:41:00","inspection_id":"84918136","insp_unit_id":"207322706","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"W3","insp_unit_license":"54J4SW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ5WK949850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:04.000000Z","updated_at":"2025-06-15T09:45:17.000000Z"}]},{"id":8370198,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","dot_number":"2119119","report_state":"IA","report_number":"000P15WDCW","insp_date":"2025-04-10 00:00:00","insp_start_time":"0841","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I 29 S 125 MM","county_code_state":"IA","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WREN TRUCKING LLC","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":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"179857","viol_total":"4","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1356143","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:34.000000Z","updated_at":"2025-04-18T10:23:13.000000Z","inspection_violations":[{"id":13190507,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_violation_id":"265607547","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9OCK25041009073","created_at":"2025-04-17T10:26:48.000000Z","updated_at":"2025-04-18T10:43:58.000000Z","normalized_code":"39216"},{"id":13190508,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_violation_id":"265607548","seq_no":"2","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":"2025-04-17T10:26:48.000000Z","updated_at":"2025-04-18T10:43:58.000000Z","normalized_code":"3922SLLS1"},{"id":13190509,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_violation_id":"265607549","seq_no":"3","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:26:48.000000Z","updated_at":"2025-04-18T10:43:58.000000Z","normalized_code":"3958F01"},{"id":13190510,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_violation_id":"265607550","seq_no":"4","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9OCK25041009201","created_at":"2025-04-17T10:26:48.000000Z","updated_at":"2025-04-18T10:43:58.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":13584028,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_unit_id":"206301622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W12","insp_unit_license":"75KS0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5D49X17D742233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:56:28.000000Z","updated_at":"2025-04-18T10:01:16.000000Z"},{"id":13584029,"change_date":"2025-04-14 21:41:00","inspection_id":"84393519","insp_unit_id":"206301623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"83L9XJ","insp_unit_license":"83L9XJ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"13NE5340033517543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:56:28.000000Z","updated_at":"2025-04-18T10:01:16.000000Z"}]},{"id":8058475,"change_date":"2025-03-15 21:34:00","inspection_id":"84065104","dot_number":"2119119","report_state":"MO","report_number":"5745001806","insp_date":"2025-03-06 00:00:00","insp_start_time":"1400","insp_end_time":"1416","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1444060","transaction_code":"C","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-03-08 21:33:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-08 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:27.000000Z","updated_at":"2025-03-21T10:10:45.000000Z","inspection_violations":[{"id":12595053,"change_date":"2025-03-15 21:34:00","inspection_id":"84065104","insp_violation_id":"265062930","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-21T10:30:52.000000Z","normalized_code":"39216D"},{"id":12595052,"change_date":"2025-03-15 21:34:00","inspection_id":"84065104","insp_violation_id":"265062929","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","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":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-21T10:30:52.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13010510,"change_date":"2025-03-15 21:34:00","inspection_id":"84065104","insp_unit_id":"205821255","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"W10","insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:46.000000Z","updated_at":"2025-03-21T09:50:50.000000Z"},{"id":13010511,"change_date":"2025-03-15 21:34:00","inspection_id":"84065104","insp_unit_id":"205821256","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"66191","insp_unit_license":"7166PA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"00116738L","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:46.000000Z","updated_at":"2025-03-21T09:50:50.000000Z"}]},{"id":7969463,"change_date":"2025-02-26 21:41:00","inspection_id":"83971694","dot_number":"2119119","report_state":"IL","report_number":"4037220643","insp_date":"2025-02-25 00:00:00","insp_start_time":"1119","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57 SB","county_code_state":"IL","county_code":"199","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAIN TEED ROOFING","shipping_paper_number":"4541492","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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124543","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":"2387120","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12865483,"change_date":"2025-02-26 21:41:00","inspection_id":"83971694","insp_unit_id":"205516628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W4","insp_unit_license":"16KR1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPFA97X0VN429761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"},{"id":12865484,"change_date":"2025-02-26 21:41:00","inspection_id":"83971694","insp_unit_id":"205516629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"FB04","insp_unit_license":"15L5JF","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"13N14830831016895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7802520,"change_date":"2025-02-06 21:40:00","inspection_id":"83796564","dot_number":"2119119","report_state":"AR","report_number":"7640000373","insp_date":"2025-02-05 00:00:00","insp_start_time":"2010","insp_end_time":"2110","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"BLYTHEVILLE AR","county_code_state":"AR","county_code":"093","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":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1332719","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:18.000000Z","updated_at":"2025-03-17T21:00:18.000000Z","inspection_violations":[{"id":12193526,"change_date":"2025-02-06 21:40:00","inspection_id":"83796564","insp_violation_id":"264372828","seq_no":"1","part_no":"383","part_no_section":"95A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"500A2240507","created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"38395ALCDL"},{"id":12193527,"change_date":"2025-02-06 21:40:00","inspection_id":"83796564","insp_violation_id":"264372829","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W001425","created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12591925,"change_date":"2025-02-06 21:40:00","inspection_id":"83796564","insp_unit_id":"205188825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W8","insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:06.000000Z","updated_at":"2025-03-17T23:54:06.000000Z"},{"id":12591926,"change_date":"2025-02-06 21:40:00","inspection_id":"83796564","insp_unit_id":"205188826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"0","insp_unit_license":"19L3XA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1B9A13323PB180225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:06.000000Z","updated_at":"2025-03-17T23:54:06.000000Z"}]},{"id":6948162,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","dot_number":"2119119","report_state":"MO","report_number":"4427000925","insp_date":"2024-10-09 00:00:00","insp_start_time":"1027","insp_end_time":"1106","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-13 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"942074","transaction_code":"A","transaction_date":"2024-10-13 00:00:00","upload_date":"2024-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-10-13 21:32:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-13 21:32:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:00.000000Z","updated_at":"2025-03-17T20:41:00.000000Z","inspection_violations":[{"id":10831610,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_violation_id":"262324743","seq_no":"1","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"203388442","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39021TB1"},{"id":10831611,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_violation_id":"262324744","seq_no":"2","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"203388442","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39311A1"},{"id":10831612,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_violation_id":"262324745","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"203388442","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"3969D2"},{"id":10831613,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_violation_id":"262324746","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"39141A"},{"id":10831614,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_violation_id":"262324747","seq_no":"5","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":11206664,"change_date":"2024-10-13 21:32:00","inspection_id":"82895756","insp_unit_id":"203388442","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"W3","insp_unit_license":"54J4SW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ5WK949850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:02.000000Z","updated_at":"2025-03-17T23:39:02.000000Z"}]},{"id":6109103,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","dot_number":"2119119","report_state":"MO","report_number":"3512000405","insp_date":"2024-06-27 00:00:00","insp_start_time":"0838","insp_end_time":"0922","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FRONTENAC MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"612590","transaction_code":"A","transaction_date":"2024-06-30 00:00:00","upload_date":"2024-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-06-30 21:33:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-30 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:46.000000Z","updated_at":"2025-03-17T20:23:46.000000Z","inspection_violations":[{"id":9483190,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","insp_violation_id":"260389017","seq_no":"1","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"201659959","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:55.000000Z","updated_at":"2025-03-17T21:51:55.000000Z","normalized_code":"39381"},{"id":9483191,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","insp_violation_id":"260389018","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:55.000000Z","updated_at":"2025-03-17T21:51:55.000000Z","normalized_code":"3922"},{"id":9483192,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","insp_violation_id":"260389019","seq_no":"3","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:55.000000Z","updated_at":"2025-03-17T21:51:55.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":9839926,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","insp_unit_id":"201659959","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W14","insp_unit_license":"53KT0C","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB8X7SN378053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:55.000000Z","updated_at":"2025-03-17T23:24:55.000000Z"},{"id":9839927,"change_date":"2024-06-30 21:33:00","inspection_id":"81999894","insp_unit_id":"201659960","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"DT06","insp_unit_license":"00L8JF","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS2828ME573015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:55.000000Z","updated_at":"2025-03-17T23:24:55.000000Z"}]},{"id":6025848,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","dot_number":"2119119","report_state":"MO","report_number":"4427000685","insp_date":"2024-06-18 00:00:00","insp_start_time":"1110","insp_end_time":"1158","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"583503","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-06-19 21:37:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-19 21:37:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:14.000000Z","updated_at":"2025-03-17T20:22:14.000000Z","inspection_violations":[{"id":9350489,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_violation_id":"260189295","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"38323A2"},{"id":9350490,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_violation_id":"260189296","seq_no":"2","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201483392","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"39021TB1"},{"id":9350491,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_violation_id":"260189297","seq_no":"3","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"201483392","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"39311A1"},{"id":9350492,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_violation_id":"260189298","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"39141A"},{"id":9350493,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_violation_id":"260189299","seq_no":"5","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"201483392","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:14.000000Z","updated_at":"2025-03-17T21:51:14.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":9705598,"change_date":"2024-06-19 21:37:00","inspection_id":"81910267","insp_unit_id":"201483392","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"W3","insp_unit_license":"54J4SW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ5WK949850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:35.000000Z","updated_at":"2025-03-17T23:23:35.000000Z"}]},{"id":5705884,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","dot_number":"2119119","report_state":"MO","report_number":"0384000346","insp_date":"2024-05-03 00:00:00","insp_start_time":"1250","insp_end_time":"1515","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"TROY MO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAIN TEED LLC","shipping_paper_number":"4040938","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-09 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"130000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"467393","transaction_code":"C","transaction_date":"2024-05-09 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-05-09 21:41:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-09 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:52.000000Z","updated_at":"2025-11-26T10:30:06.000000Z","inspection_violations":[{"id":17078280,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140135","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"210186626","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"39345B2BAIR"},{"id":17078281,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140136","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"3939ALIL"},{"id":17078282,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140137","seq_no":"3","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"210186626","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"393100BC"},{"id":17078283,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140138","seq_no":"4","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"39345B2B"},{"id":17078284,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140139","seq_no":"5","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"210186626","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"39345B2B"},{"id":17078285,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140140","seq_no":"6","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"39375A3TAOL"},{"id":17078286,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140141","seq_no":"7","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"210186626","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"3939ALBL"},{"id":17078287,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140142","seq_no":"8","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"3939ALSLI"},{"id":17078288,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140143","seq_no":"9","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"3939ALSML"},{"id":17078289,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_violation_id":"270140144","seq_no":"10","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"2","insp_unit_id":"210186627","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:31:38.000000Z","updated_at":"2025-11-26T10:30:18.000000Z","normalized_code":"3963A1TAOCV"}],"inspection_per_units":[{"id":17113328,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_unit_id":"210186627","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVENS-MET","insp_unit_company":null,"insp_unit_license":"15L4JF","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1R1F74823WK980998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:17.000000Z","updated_at":"2025-11-26T10:00:07.000000Z"},{"id":17113327,"change_date":"2025-11-22 21:47:00","inspection_id":"81563214","insp_unit_id":"210186626","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W4","insp_unit_license":"16KR1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPFA97X0VN429761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:17.000000Z","updated_at":"2025-11-26T10:00:07.000000Z"}]},{"id":5742468,"change_date":"2024-05-14 21:41:00","inspection_id":"81602943","dot_number":"2119119","report_state":"IL","report_number":"4069920207","insp_date":"2024-05-03 00:00:00","insp_start_time":"0722","insp_end_time":"0732","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-270","county_code_state":"IL","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAINTEED LLC","shipping_paper_number":"800498690","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","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":"2325257","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-03 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:39.000000Z","updated_at":"2025-03-17T20:16:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9249231,"change_date":"2024-05-14 21:41:00","inspection_id":"81602943","insp_unit_id":"200880411","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"W16","insp_unit_license":"28KS3S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XKWDB9X95J089874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:04.000000Z","updated_at":"2025-03-17T23:19:04.000000Z"},{"id":9249232,"change_date":"2024-05-14 21:41:00","inspection_id":"81602943","insp_unit_id":"200880412","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAN","insp_unit_company":null,"insp_unit_license":"98L1DL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTF4520XP1040037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:04.000000Z","updated_at":"2025-03-17T23:19:04.000000Z"}]},{"id":6141809,"change_date":"2024-07-03 21:40:00","inspection_id":"82035102","dot_number":"2119119","report_state":"IL","report_number":"4069780343","insp_date":"2024-04-25 00:00:00","insp_start_time":"1400","insp_end_time":"1433","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-64","county_code_state":"IL","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","pen_cen_match":null,"final_status_date":"2024-07-03 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"132000","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":"2336388","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-25 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-07-03 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:34.000000Z","updated_at":"2025-03-17T20:24:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9893064,"change_date":"2024-07-03 21:40:00","inspection_id":"82035102","insp_unit_id":"201725688","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"W10","insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:31.000000Z","updated_at":"2025-03-17T23:25:31.000000Z"},{"id":9893065,"change_date":"2024-07-03 21:40:00","inspection_id":"82035102","insp_unit_id":"201725689","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"01","insp_unit_license":"98L1DL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTF4520XP1040037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:31.000000Z","updated_at":"2025-03-17T23:25:31.000000Z"}]},{"id":5604133,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","dot_number":"2119119","report_state":"MO","report_number":"W011006417","insp_date":"2024-04-22 00:00:00","insp_start_time":"0815","insp_end_time":"0945","registration_date":null,"region":"CD","ci_status_code":"C","location":"C5S","location_desc":"BLOOMSDALE MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CERTAINTEED","shipping_paper_number":"800477154","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":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"15","oos_total":"5","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"430787","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:51.000000Z","updated_at":"2025-03-17T20:13:51.000000Z","inspection_violations":[{"id":8664803,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158975","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8664804,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158976","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3969D2"},{"id":8664805,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158977","seq_no":"3","part_no":"383","part_no_section":"71(h)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"38371H"},{"id":8664806,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158978","seq_no":"4","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39111B4"},{"id":8664807,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158979","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39141A"},{"id":8664808,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158980","seq_no":"6","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"200590562","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"393100B"},{"id":8664809,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158981","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200590562","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39345B2"},{"id":8664810,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158982","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200590562","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39347E"},{"id":8664811,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158983","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200590562","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39353B"},{"id":8664812,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158984","seq_no":"10","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"393207A"},{"id":8664813,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158985","seq_no":"11","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39355D1"},{"id":8664814,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158986","seq_no":"12","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39360D"},{"id":8664815,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158987","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3963A1"},{"id":8664816,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158988","seq_no":"14","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3963A1"},{"id":8664817,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_violation_id":"259158989","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200590561","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9027052,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_unit_id":"200590561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"},{"id":9027053,"change_date":"2024-04-26 21:39:00","inspection_id":"81452405","insp_unit_id":"200590562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"T-101","insp_unit_license":"5551PC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1R1F04825LE900065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"}]},{"id":5264464,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","dot_number":"2119119","report_state":"MO","report_number":"W089001493","insp_date":"2024-03-11 00:00:00","insp_start_time":"1225","insp_end_time":"1318","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAYVIEW MO","county_code_state":"MO","county_code":"107","insp_level_id":"2","service_center":"MW","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":"2024-03-12 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","viol_total":"4","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":"309551","transaction_code":"A","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-03-12 21:38:00","snet_input_date":"2024-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-12 21:38:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:03.000000Z","updated_at":"2025-03-17T20:07:03.000000Z","inspection_violations":[{"id":8118727,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_violation_id":"258331403","seq_no":"1","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"199865489","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"39355D1B"},{"id":8118728,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_violation_id":"258331404","seq_no":"2","part_no":"393","part_no_section":"55D3-B","insp_viol_unit":"2","insp_unit_id":"199865490","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"39355D3B"},{"id":8118729,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_violation_id":"258331405","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199865489","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"3922SLLSR"},{"id":8118730,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_violation_id":"258331406","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"199865489","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:13.000000Z","updated_at":"2025-03-17T21:45:13.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":8477420,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_unit_id":"199865489","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"W8","insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:50.000000Z","updated_at":"2025-03-17T23:11:50.000000Z"},{"id":8477421,"change_date":"2024-03-12 21:38:00","inspection_id":"81081862","insp_unit_id":"199865490","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"SV01","insp_unit_license":"41M0EL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"13N24830715998574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:50.000000Z","updated_at":"2025-03-17T23:11:50.000000Z"}]},{"id":5221127,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","dot_number":"2119119","report_state":"MO","report_number":"4427000440","insp_date":"2024-03-05 00:00:00","insp_start_time":"1014","insp_end_time":"1054","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","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":"2024-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"295653","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2024-03-06 21:39:00","snet_input_date":"2024-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-06 21:39:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:10.000000Z","updated_at":"2025-03-17T20:06:10.000000Z","inspection_violations":[{"id":8047965,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224661","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39021TB1MC"},{"id":8047966,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224662","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39021TB2DOT"},{"id":8047967,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224663","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3922SLLSR"},{"id":8047968,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224664","seq_no":"4","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"393100BC"},{"id":8047969,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224665","seq_no":"5","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39311A1LBL"},{"id":8047970,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224666","seq_no":"6","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39311A1LIL"},{"id":8047971,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_violation_id":"258224667","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"199774882","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":8407569,"change_date":"2024-03-06 21:39:00","inspection_id":"81034298","insp_unit_id":"199774882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"66KR1Z","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ5WK949850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:10.000000Z","updated_at":"2025-03-17T23:11:10.000000Z"}]},{"id":4866762,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","dot_number":"2119119","report_state":"IL","report_number":"4005241841","insp_date":"2024-01-18 00:00:00","insp_start_time":"0625","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-72 EAST","county_code_state":"IL","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAINTEED","shipping_paper_number":"3856864","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2302628","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:13.000000Z","updated_at":"2025-03-17T19:59:13.000000Z","inspection_violations":[{"id":7500766,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_violation_id":"257416147","seq_no":"1","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"199033330","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"393104B"},{"id":7500767,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_violation_id":"257416148","seq_no":"2","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"199033330","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"393110"},{"id":7500768,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_violation_id":"257416149","seq_no":"3","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"3958A1"},{"id":7500769,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_violation_id":"257416150","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199033330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"39311"},{"id":7500770,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_violation_id":"257416151","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199033329","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7830440,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_unit_id":"199033329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"W10","insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"},{"id":7830441,"change_date":"2024-01-19 21:44:00","inspection_id":"80647576","insp_unit_id":"199033330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAVE","insp_unit_company":"T101","insp_unit_license":"5551PC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1R1F048LE900058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4579814,"change_date":"2023-12-07 21:40:00","inspection_id":"80333739","dot_number":"2119119","report_state":"MO","report_number":"0174000117","insp_date":"2023-12-06 00:00:00","insp_start_time":"1537","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":"C64","location_desc":"WB I-64 \/ E OF ROUTE DD","county_code_state":"MO","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BALLAS HOUSE DEMO","shipping_paper_number":"17976","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2092176","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-12-07 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:27.000000Z","updated_at":"2025-03-17T19:53:27.000000Z","inspection_violations":[{"id":7083152,"change_date":"2023-12-07 21:40:00","inspection_id":"80333739","insp_violation_id":"256768756","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"},{"id":7083153,"change_date":"2023-12-07 21:40:00","inspection_id":"80333739","insp_violation_id":"256768757","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198399602","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:15.000000Z","updated_at":"2025-03-17T21:40:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7366298,"change_date":"2023-12-07 21:40:00","inspection_id":"80333739","insp_unit_id":"198399602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W11","insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"}]},{"id":4253108,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","dot_number":"2119119","report_state":"MO","report_number":"0384000093","insp_date":"2023-10-20 00:00:00","insp_start_time":"0915","insp_end_time":"1120","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"13","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"74439","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-10-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:05.000000Z","updated_at":"2025-03-17T19:47:05.000000Z","inspection_violations":[{"id":6585381,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976836","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3939ALIL"},{"id":6585382,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976837","seq_no":"5","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"197680125","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39021TB1MC"},{"id":6585383,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976838","seq_no":"6","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922SLLFC"},{"id":6585384,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976839","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3922"},{"id":6585385,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976840","seq_no":"8","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39345B2B"},{"id":6585386,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976841","seq_no":"9","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39345DB"},{"id":6585387,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976842","seq_no":"10","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3939ALLPL"},{"id":6585388,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976843","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39345DB"},{"id":6585389,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976844","seq_no":"2","part_no":"393","part_no_section":"48A-BMBCAD","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39348ABMBCAD"},{"id":6585390,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976845","seq_no":"3","part_no":"393","part_no_section":"81-H","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"39381H"},{"id":6585391,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976846","seq_no":"11","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3939ALSLIWR"},{"id":6585392,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976847","seq_no":"12","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"197680126","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3939ALTSI"},{"id":6585393,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_violation_id":"255976848","seq_no":"13","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"197680125","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":6839808,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_unit_id":"197680125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"},{"id":6839809,"change_date":"2023-10-23 21:41:00","inspection_id":"79973102","insp_unit_id":"197680126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"17K1FU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1D913272ADA059563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:19.000000Z","updated_at":"2025-03-17T22:57:19.000000Z"}]},{"id":4168975,"change_date":"2025-11-22 21:48:00","inspection_id":"79880340","dot_number":"2119119","report_state":"MO","report_number":"0132000031","insp_date":"2023-10-09 00:00:00","insp_start_time":"1127","insp_end_time":"1203","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"O'FALLON MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL STONE QUARRY","shipping_paper_number":"19525407","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-11 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"64000","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":"66637","transaction_code":"C","transaction_date":"2023-10-11 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-11-26T10:30:24.000000Z","inspection_violations":[{"id":17097856,"change_date":"2025-11-22 21:48:00","inspection_id":"79880340","insp_violation_id":"270179039","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210197294","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:13.000000Z","updated_at":"2025-11-26T10:32:11.000000Z","normalized_code":"3922SLLSR"},{"id":17097857,"change_date":"2025-11-22 21:48:00","inspection_id":"79880340","insp_violation_id":"270179040","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"210197294","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:32:13.000000Z","updated_at":"2025-11-26T10:32:11.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":17117922,"change_date":"2025-11-22 21:48:00","inspection_id":"79880340","insp_unit_id":"210197294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:20.000000Z","updated_at":"2025-11-26T10:00:30.000000Z"}]},{"id":4097549,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","dot_number":"2119119","report_state":"MO","report_number":"0384000055","insp_date":"2023-09-25 00:00:00","insp_start_time":"1605","insp_end_time":"1805","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MOSCOW MILLS MO","county_code_state":"MO","county_code":"113","insp_level_id":"1","service_center":"MW","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":"2023-10-01 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"126595","viol_total":"15","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"60896","transaction_code":"A","transaction_date":"2023-10-01 00:00:00","upload_date":"2023-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":"2023-10-01 21:30:00","snet_input_date":"2023-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-01 21:30:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:40.000000Z","updated_at":"2025-03-17T19:43:40.000000Z","inspection_violations":[{"id":6341053,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585314","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"197332598","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3965BL"},{"id":6341054,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585315","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"197332598","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3939AHLLH"},{"id":6341055,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585316","seq_no":"3","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"1","insp_unit_id":"197332598","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39375A1TEPBM"},{"id":6341056,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585317","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"197332598","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39021TB1MC"},{"id":6341057,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585318","seq_no":"5","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39348ABIBD"},{"id":6341058,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585319","seq_no":"6","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39348ABIBD"},{"id":6341059,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585320","seq_no":"7","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"393207FSDAS"},{"id":6341060,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585321","seq_no":"8","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39345B2B"},{"id":6341061,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585322","seq_no":"9","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39345DB"},{"id":6341062,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585323","seq_no":"10","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":6341063,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585324","seq_no":"11","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3939ALIL"},{"id":6341064,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585325","seq_no":"12","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3939ALSML"},{"id":6341065,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585326","seq_no":"13","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3939ALTSI"},{"id":6341066,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585327","seq_no":"14","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3939ALSLIWR"},{"id":6341067,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_violation_id":"255585328","seq_no":"15","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"197332599","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:36.000000Z","updated_at":"2025-03-17T21:36:36.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":6587874,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_unit_id":"197332598","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:16.000000Z","updated_at":"2025-03-17T22:55:16.000000Z"},{"id":6587875,"change_date":"2023-10-01 21:30:00","inspection_id":"79801298","insp_unit_id":"197332599","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORSEY TRA","insp_unit_company":null,"insp_unit_license":"3524PD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1DTP10Z22NP031241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:16.000000Z","updated_at":"2025-03-17T22:55:16.000000Z"}]},{"id":3834118,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","dot_number":"2119119","report_state":"MO","report_number":"00SI000071","insp_date":"2023-08-21 00:00:00","insp_start_time":"0830","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"C70","location_desc":"7410 HALL ST","county_code_state":"MO","county_code":"510","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-08-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"18","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2089398","transaction_code":"C","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5921093,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046256","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5921094,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046257","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39353B"},{"id":5921095,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046258","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39347E"},{"id":5921096,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046259","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3922"},{"id":5921097,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046260","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3922"},{"id":5921098,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046261","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"},{"id":5921099,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046262","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"},{"id":5921100,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046263","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39378"},{"id":5921101,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046264","seq_no":"9","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39021B"},{"id":5921102,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046265","seq_no":"10","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"39375C"},{"id":5921103,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046266","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5921104,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046267","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5921105,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046268","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5921106,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046269","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5921107,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046270","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3939A"},{"id":5921108,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046271","seq_no":"16","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3929A"},{"id":5921109,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046272","seq_no":"17","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"393100B"},{"id":5921110,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_violation_id":"255046273","seq_no":"19","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196865968","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:39.000000Z","updated_at":"2025-03-17T21:34:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6164549,"change_date":"2023-09-01 21:39:00","inspection_id":"79508203","insp_unit_id":"196865968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W7","insp_unit_license":"66KR1Z","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ9WK953769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"}]},{"id":3654191,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","dot_number":"2119119","report_state":"MO","report_number":"0384001789","insp_date":"2023-07-31 00:00:00","insp_start_time":"1225","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"C61","location_desc":"US61 SB NORTH OF I-70","county_code_state":"MO","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2086309","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-02 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[{"id":5633521,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558218","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3922"},{"id":5633522,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558219","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196446721","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39021TA"},{"id":5633523,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558220","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196446721","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39311"},{"id":5633524,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558221","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196446722","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"39345B2"},{"id":5633525,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558222","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196446722","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"},{"id":5633526,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_violation_id":"254558223","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196446722","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5875677,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_unit_id":"196446721","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"W10","insp_unit_license":"02KR7T","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FTYY96VXTVA09234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5875678,"change_date":"2023-08-09 21:42:00","inspection_id":"79307012","insp_unit_id":"196446722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"17K1FU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1D913272ADA059563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3609930,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","dot_number":"2119119","report_state":"MO","report_number":"SLC5001982","insp_date":"2023-07-26 00:00:00","insp_start_time":"1305","insp_end_time":"1342","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"TESSON FERRY\/BUTLER HILL RD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"11","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2085734","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5567361,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319657","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39216A"},{"id":5567362,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319658","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39617C"},{"id":5567363,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319659","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39378"},{"id":5567364,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319660","seq_no":"4","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39021TA"},{"id":5567365,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319661","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5567366,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319662","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5567367,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319663","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"},{"id":5567368,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319664","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"39311"},{"id":5567369,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319665","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"},{"id":5567370,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319666","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"},{"id":5567371,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_violation_id":"254319667","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196229377","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5804132,"change_date":"2023-07-27 21:40:00","inspection_id":"79257491","insp_unit_id":"196229377","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W15","insp_unit_license":"91J7VS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1NPALU0X7YN550643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:49.000000Z","updated_at":"2025-03-17T22:48:49.000000Z"}]},{"id":2686859,"change_date":"2023-03-29 21:42:00","inspection_id":"78215799","dot_number":"2119119","report_state":"MO","report_number":"0193000253","insp_date":"2023-03-28 00:00:00","insp_start_time":"0840","insp_end_time":"0859","registration_date":null,"region":"CT","ci_status_code":"C","location":"C364","location_desc":"BENNINGTON PL, AT I-364","county_code_state":"MO","county_code":"189","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2065677","transaction_code":"A","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:13.000000Z","updated_at":"2025-03-17T19:16:13.000000Z","inspection_violations":[{"id":4127747,"change_date":"2023-03-29 21:42:00","inspection_id":"78215799","insp_violation_id":"251932966","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:19.000000Z","updated_at":"2025-03-17T21:26:19.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4325596,"change_date":"2023-03-29 21:42:00","inspection_id":"78215799","insp_unit_id":"194123414","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W3","insp_unit_license":"80J3SH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ5WK949850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:05.000000Z","updated_at":"2025-03-17T22:37:05.000000Z"}]},{"id":2625449,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","dot_number":"2119119","report_state":"MO","report_number":"1507019870","insp_date":"2023-03-20 00:00:00","insp_start_time":"1513","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":"C364","location_desc":"MO 364 @ ARENA PARKWAY","county_code_state":"MO","county_code":"183","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"DUNMAN DEMO","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-21 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"58000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2064398","transaction_code":"A","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-03-21 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:09.000000Z","updated_at":"2025-03-17T19:15:09.000000Z","inspection_violations":[{"id":4036429,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_violation_id":"251781873","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"193982116","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"393100B"},{"id":4036430,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_violation_id":"251781874","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982116","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"3922"},{"id":4036431,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_violation_id":"251781875","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"193982116","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"393207A"},{"id":4036432,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_violation_id":"251781876","seq_no":"4","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"193982116","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"393209D"},{"id":4036433,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_violation_id":"251781877","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193982116","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:53.000000Z","updated_at":"2025-03-17T21:25:53.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4226281,"change_date":"2023-03-21 21:41:00","inspection_id":"78145536","insp_unit_id":"193982116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:19.000000Z","updated_at":"2025-03-17T22:36:19.000000Z"}]},{"id":2402283,"change_date":"2023-02-20 21:33:00","inspection_id":"77891564","dot_number":"2119119","report_state":"AR","report_number":"E585002109","insp_date":"2023-02-20 00:00:00","insp_start_time":"1530","insp_end_time":"1555","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"GREENE COUNTY","county_code_state":"AR","county_code":"055","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-02-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1445521","transaction_code":"A","transaction_date":"2023-02-20 00:00:00","upload_date":"2023-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-20 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-02-20 21:33:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3865932,"change_date":"2023-02-20 21:33:00","inspection_id":"77891564","insp_unit_id":"193472413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W8","insp_unit_license":"66KS8X","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X84D828476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:42.000000Z","updated_at":"2025-03-17T22:33:42.000000Z"},{"id":3865933,"change_date":"2023-02-20 21:33:00","inspection_id":"77891564","insp_unit_id":"193472414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SUPR","insp_unit_company":"DT02","insp_unit_license":"82L1TT","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1S9DS4029WR573009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:42.000000Z","updated_at":"2025-03-17T22:33:42.000000Z"}]},{"id":2182246,"change_date":"2023-01-19 21:44:00","inspection_id":"77640751","dot_number":"2119119","report_state":"MO","report_number":"W135007875","insp_date":"2023-01-18 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"E164","location_desc":"HORNERSVILLE","county_code_state":"MO","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"GRENBRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"141000","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":"2054264","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-19 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-19 21:44:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:55.000000Z","updated_at":"2025-03-17T19:06:55.000000Z","inspection_violations":[{"id":3371173,"change_date":"2023-01-19 21:44:00","inspection_id":"77640751","insp_violation_id":"250663194","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192959477","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:55.000000Z","updated_at":"2025-03-17T21:22:55.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3512561,"change_date":"2023-01-19 21:44:00","inspection_id":"77640751","insp_unit_id":"192959476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W6","insp_unit_license":"29KR2J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X1XN488358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:11.000000Z","updated_at":"2025-03-17T22:31:11.000000Z"},{"id":3512562,"change_date":"2023-01-19 21:44:00","inspection_id":"77640751","insp_unit_id":"192959477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"NIR11","insp_unit_license":"64L7VX","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1H2P04524SW080801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:11.000000Z","updated_at":"2025-03-17T22:31:11.000000Z"}]},{"id":2155282,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","dot_number":"2119119","report_state":"MO","report_number":"SLC1002457","insp_date":"2023-01-13 00:00:00","insp_start_time":"1114","insp_end_time":"1153","registration_date":null,"region":"CT","ci_status_code":"C","location":"C44","location_desc":"LEWIS RD @ I-44","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2053745","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-17 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:17.000000Z","updated_at":"2025-03-17T19:06:17.000000Z","inspection_violations":[{"id":3330966,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_violation_id":"250600549","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192899491","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39378"},{"id":3330967,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_violation_id":"250600550","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"192899491","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3965B"},{"id":3330968,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_violation_id":"250600551","seq_no":"3","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"192899492","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39375A1"},{"id":3330969,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_violation_id":"250600552","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192899492","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3468070,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_unit_id":"192899491","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W4","insp_unit_license":"16KR1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPFA97X0VN429761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"},{"id":3468071,"change_date":"2023-01-17 21:42:00","inspection_id":"77610157","insp_unit_id":"192899492","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SCHI","insp_unit_company":"DT-01","insp_unit_license":"7243PB","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1263S875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"}]},{"id":1980890,"change_date":"2022-12-20 21:40:00","inspection_id":"77410242","dot_number":"2119119","report_state":"AR","report_number":"E741000823","insp_date":"2022-12-20 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"MONETTE","county_code_state":"AR","county_code":"031","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73280","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1436497","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-20 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:16.000000Z","updated_at":"2025-03-17T19:03:16.000000Z","inspection_violations":[{"id":3075087,"change_date":"2022-12-20 21:40:00","inspection_id":"77410242","insp_violation_id":"250181230","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"500A0264196","created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"3922"},{"id":3075088,"change_date":"2022-12-20 21:40:00","inspection_id":"77410242","insp_violation_id":"250181231","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192502239","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3186855,"change_date":"2022-12-20 21:40:00","inspection_id":"77410242","insp_unit_id":"192502239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W11","insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"}]},{"id":1980891,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","dot_number":"2119119","report_state":"AR","report_number":"E741000824","insp_date":"2022-12-20 00:00:00","insp_start_time":"0715","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"47","location_desc":"MANILA","county_code_state":"AR","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NUCOR","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":"N","pen_cen_match":"I","final_status_date":"2022-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"106000","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1436498","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-20 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:16.000000Z","updated_at":"2025-03-17T19:03:16.000000Z","inspection_violations":[{"id":3075089,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_violation_id":"250181232","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"500A0264197","created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"3922"},{"id":3075090,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_violation_id":"250181233","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192502240","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"3922"},{"id":3075091,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_violation_id":"250181234","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"192502240","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"393207A"},{"id":3075092,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_violation_id":"250181235","seq_no":"4","part_no":"393","part_no_section":"134(b)(3)","insp_viol_unit":"2","insp_unit_id":"192502241","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:35.000000Z","updated_at":"2025-03-17T21:21:35.000000Z","normalized_code":"393134B3"}],"inspection_per_units":[{"id":3186856,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_unit_id":"192502240","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W6","insp_unit_license":"29KR2J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XP5DB9X1XN488358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"},{"id":3186857,"change_date":"2022-12-20 21:40:00","inspection_id":"77410243","insp_unit_id":"192502241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"201","insp_unit_license":"19L3XA","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1B9A13323PB180225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"}]},{"id":1405508,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","dot_number":"2119119","report_state":"MO","report_number":"SLC5001390","insp_date":"2022-09-28 00:00:00","insp_start_time":"1035","insp_end_time":"1109","registration_date":null,"region":"CT","ci_status_code":"C","location":"C50","location_desc":"S LINDBERGH BLVD\/ ROBYN RD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"DAY SHEET","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":"I","final_status_date":"2022-09-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2034765","transaction_code":"A","transaction_date":"2022-09-29 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-09-29 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:40.000000Z","updated_at":"2025-03-17T18:52:40.000000Z","inspection_violations":[{"id":2214991,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737652","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3939A"},{"id":2214992,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737653","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3939A"},{"id":2214993,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737654","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3939A"},{"id":2214994,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737655","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39378"},{"id":2214995,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737656","seq_no":"5","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"393100B"},{"id":2214996,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737657","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"39311"},{"id":2214997,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_violation_id":"248737658","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"191185945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:08.000000Z","updated_at":"2025-03-17T21:17:08.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":2262802,"change_date":"2022-09-29 21:41:00","inspection_id":"76749275","insp_unit_id":"191185945","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W7","insp_unit_license":"66KR17","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ9WK953769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:29.000000Z","updated_at":"2025-03-17T22:22:29.000000Z"}]},{"id":1354909,"change_date":"2022-09-23 21:38:00","inspection_id":"76690543","dot_number":"2119119","report_state":"MO","report_number":"00SE003902","insp_date":"2022-09-12 00:00:00","insp_start_time":"1523","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"SIDNEY AT TEXAS","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-09-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2033532","transaction_code":"A","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-23 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-09-23 21:38:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:39.000000Z","updated_at":"2025-03-17T18:51:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2181610,"change_date":"2022-09-23 21:38:00","inspection_id":"76690543","insp_unit_id":"191068526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W11","insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:56.000000Z","updated_at":"2025-03-17T22:21:56.000000Z"}]},{"id":1196355,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","dot_number":"2119119","report_state":"MO","report_number":"SLC3001584","insp_date":"2022-08-31 00:00:00","insp_start_time":"1122","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":"C67","location_desc":"3701 S LINDBERGH BLVD","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-09-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2029799","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-01 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-09-01 21:41:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:40.000000Z","updated_at":"2025-03-17T18:48:40.000000Z","inspection_violations":[{"id":1896148,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170780","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39378"},{"id":1896149,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170781","seq_no":"2","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39324A"},{"id":1896150,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170782","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"3939A"},{"id":1896151,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170783","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39311"},{"id":1896152,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170784","seq_no":"5","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"393209D"},{"id":1896153,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_violation_id":"248170785","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190686657","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:44.000000Z","updated_at":"2025-03-17T21:15:44.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1923676,"change_date":"2022-09-01 21:41:00","inspection_id":"76506391","insp_unit_id":"190686657","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W7","insp_unit_license":"66KR17","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"2WLNCDCJ9WK953769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:13.000000Z","updated_at":"2025-03-17T22:20:13.000000Z"}]},{"id":1098646,"change_date":"2022-08-22 21:42:00","inspection_id":"76393014","dot_number":"2119119","report_state":"MO","report_number":"00SP005304","insp_date":"2022-08-19 00:00:00","insp_start_time":"0909","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"2200 S 7TH ST","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"179857","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":"2027761","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-22 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1729814,"change_date":"2022-08-22 21:42:00","inspection_id":"76393014","insp_violation_id":"247884899","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1767067,"change_date":"2022-08-22 21:42:00","inspection_id":"76393014","insp_unit_id":"190456076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"W15","insp_unit_license":"28KS3S","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XKWDB9X95J089874","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1767068,"change_date":"2022-08-22 21:42:00","inspection_id":"76393014","insp_unit_id":"190456077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"98E8YD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"13NE5340033517543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":956537,"change_date":"2022-08-03 21:42:00","inspection_id":"76226884","dot_number":"2119119","report_state":"IL","report_number":"4179790012","insp_date":"2022-08-02 00:00:00","insp_start_time":"0931","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I72","county_code_state":"IL","county_code":"171","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CERTAINTEED LLC","shipping_paper_number":"2971500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2185087","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-02 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:26.000000Z","updated_at":"2025-03-17T18:44:26.000000Z","inspection_violations":[{"id":1507248,"change_date":"2022-08-03 21:42:00","inspection_id":"76226884","insp_violation_id":"247491494","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":1539178,"change_date":"2022-08-03 21:42:00","inspection_id":"76226884","insp_unit_id":"190116325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"W4","insp_unit_license":"16KR1J","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1XPFA97X0VN429761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:41.000000Z","updated_at":"2025-03-17T22:17:41.000000Z"},{"id":1539179,"change_date":"2022-08-03 21:42:00","inspection_id":"76226884","insp_unit_id":"190116326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"98L1DL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1TTF4520XP1040037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:41.000000Z","updated_at":"2025-03-17T22:17:41.000000Z"}]},{"id":838112,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","dot_number":"2119119","report_state":"MO","report_number":"SLC7000571","insp_date":"2022-07-15 00:00:00","insp_start_time":"1307","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":"C21","location_desc":"13099 TESSON FERRY","county_code_state":"MO","county_code":"189","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"MCFRY CONSTRUCTION","shipping_paper_number":"DAY SHEET","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":"I","final_status_date":"2022-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2021741","transaction_code":"A","transaction_date":"2022-07-18 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02119119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-18 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-07-18 21:42:00","insp_carrier_name":"WREN TRUCKING LLC","insp_carrier_street":"2551 N US HWY 61","insp_carrier_city":"TROY","insp_carrier_state":"MO","insp_carrier_zip_code":"63379","insp_colonia":null,"docket_number":"738598","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:21.000000Z","updated_at":"2025-03-17T18:42:21.000000Z","inspection_violations":[{"id":1320936,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150602","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39617C"},{"id":1320937,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150603","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39378"},{"id":1320938,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150604","seq_no":"3","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39355C2"},{"id":1320939,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150605","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"3929A"},{"id":1320940,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150606","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"39345B2"},{"id":1320941,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150607","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"3939A"},{"id":1320942,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_violation_id":"247150608","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189826801","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:15.000000Z","updated_at":"2025-03-17T21:13:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1348558,"change_date":"2022-07-18 21:42:00","inspection_id":"76088149","insp_unit_id":"189826801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"W11","insp_unit_license":"61J0VG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"5KKWAECV47PX84307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:28.000000Z","updated_at":"2025-03-17T22:16:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2119119\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2119119\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2119119\/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\/2119119\/inspections","per_page":100,"prev_page_url":null,"to":42,"total":42}