{"current_page":1,"data":[{"id":12412725,"change_date":"2026-07-10 21:41:00","inspection_id":"88370821","dot_number":"1834809","report_state":"TN","report_number":"I031J60665","insp_date":"2026-07-08 00:00:00","insp_start_time":"1603","insp_end_time":"1620","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"3721575","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2026-07-10 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-10 21:41:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-14T09:40:28.000000Z","updated_at":"2026-07-21T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21563484,"change_date":"2026-07-10 21:41:00","inspection_id":"88370821","insp_unit_id":"214541011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4E10333","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1FDSW5HT3TEC76257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:14.000000Z","updated_at":"2026-07-21T09:02:26.000000Z"},{"id":21563485,"change_date":"2026-07-10 21:41:00","inspection_id":"88370821","insp_unit_id":"214541012","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"T4","insp_unit_license":"6391TE7","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-14T09:17:14.000000Z","updated_at":"2026-07-21T09:02:26.000000Z"}]},{"id":11431311,"change_date":"2026-03-21 21:33:00","inspection_id":"87347599","dot_number":"1834809","report_state":"TN","report_number":"I033AL2462","insp_date":"2026-03-19 00:00:00","insp_start_time":"1140","insp_end_time":"1210","registration_date":null,"region":"CD","ci_status_code":"C","location":"HAYWDW","location_desc":"STANTON TN","county_code_state":"TN","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MID SOUTH BORING & PIPING LLC","shipping_paper_number":"03192026","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"134875","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3032786","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2026-03-21 21:33:00","snet_input_date":"2026-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-21 21:33:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-24T09:42:33.000000Z","updated_at":"2026-04-01T09:30:21.000000Z","inspection_violations":[{"id":19285995,"change_date":"2026-03-21 21:33:00","inspection_id":"87347599","insp_violation_id":"272534069","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"212249015","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2026-03-24T10:03:47.000000Z","updated_at":"2026-04-01T09:52:02.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":19582856,"change_date":"2026-03-21 21:33:00","inspection_id":"87347599","insp_unit_id":"212249015","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"DOTU0001","insp_unit_license":"K6870HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"2HSCUAPR79C091390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-24T09:20:26.000000Z","updated_at":"2026-04-01T09:06:19.000000Z"},{"id":19582857,"change_date":"2026-03-21 21:33:00","inspection_id":"87347599","insp_unit_id":"212249016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOLDEN TRA","insp_unit_company":null,"insp_unit_license":"403TE42","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"12HLB3623LN353143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-24T09:20:26.000000Z","updated_at":"2026-04-01T09:06:19.000000Z"}]},{"id":6794378,"change_date":"2024-09-23 21:40:00","inspection_id":"82732447","dot_number":"1834809","report_state":"AL","report_number":"MOCV005414","insp_date":"2024-09-23 00:00:00","insp_start_time":"1045","insp_end_time":"1113","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WEIGH STATION","county_code_state":"AL","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"154350","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":"1024515","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-23 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:46.000000Z","updated_at":"2025-03-17T20:37:46.000000Z","inspection_violations":[{"id":10581540,"change_date":"2024-09-23 21:40:00","inspection_id":"82732447","insp_violation_id":"261979688","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"~W001643","created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10956241,"change_date":"2024-09-23 21:40:00","inspection_id":"82732447","insp_unit_id":"203079285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"#1","insp_unit_license":"K6870HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"2HSCUAPR79C091390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:30.000000Z","updated_at":"2025-03-17T23:36:30.000000Z"},{"id":10956242,"change_date":"2024-09-23 21:40:00","inspection_id":"82732447","insp_unit_id":"203079286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"L1503","insp_unit_license":"437130T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5JYLB5280FP151059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:30.000000Z","updated_at":"2025-03-17T23:36:30.000000Z"}]},{"id":4965632,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","dot_number":"1834809","report_state":"IL","report_number":"3998331600","insp_date":"2024-01-31 00:00:00","insp_start_time":"0934","insp_end_time":"1049","registration_date":"2024-02-15 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"I 57","county_code_state":"IL","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MID SOUTH BORING AND PIPING 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":"2024-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33350","viol_total":"17","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":"2304994","transaction_code":"C","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2024-02-02 21:42:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-02-02 21:42:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:12.000000Z","updated_at":"2025-03-17T20:01:12.000000Z","inspection_violations":[{"id":7647746,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865565","seq_no":"1","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:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3958A1"},{"id":7647747,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865566","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39617C"},{"id":7647748,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865567","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199447419","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39617C"},{"id":7647749,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865568","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7647750,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865569","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39395A"},{"id":7647751,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865570","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39395F"},{"id":7647752,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865571","seq_no":"7","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39522H1"},{"id":7647753,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865572","seq_no":"8","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39522H4"},{"id":7647754,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865573","seq_no":"9","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39522H2"},{"id":7647755,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865574","seq_no":"10","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39522H3"},{"id":7647756,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865575","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7647757,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865576","seq_no":"12","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021TB"},{"id":7647758,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865577","seq_no":"13","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021TB"},{"id":7647759,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865578","seq_no":"14","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021TB"},{"id":7647760,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865579","seq_no":"15","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021TB"},{"id":7647761,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865580","seq_no":"16","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"199447418","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39021TA"},{"id":7647762,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_violation_id":"257865581","seq_no":"17","part_no":"396","part_no_section":"1","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:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3961"}],"inspection_per_units":[{"id":7991689,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_unit_id":"199447418","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"Q4KYYGC","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GC4YNE77RF285769","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"},{"id":7991690,"change_date":"2024-02-15 21:42:00","inspection_id":"80755766","insp_unit_id":"199447419","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ERID","insp_unit_company":null,"insp_unit_license":"491613T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1E9BF322XPS230523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"}]},{"id":4382158,"change_date":"2023-11-14 21:41:00","inspection_id":"80116201","dot_number":"1834809","report_state":"MS","report_number":"1031011704","insp_date":"2023-11-07 00:00:00","insp_start_time":"0905","insp_end_time":"0928","registration_date":"2023-11-09 00:00:00","region":"CT","ci_status_code":"C","location":"T-92","location_desc":"FULTON SCALE US 78 EAST","county_code_state":"MS","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1052444","transaction_code":"C","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-08 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:50.000000Z","updated_at":"2025-03-17T19:49:50.000000Z","inspection_violations":[{"id":6779795,"change_date":"2023-11-14 21:41:00","inspection_id":"80116201","insp_violation_id":"256381004","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"198048853","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:36.000000Z","updated_at":"2025-03-17T21:38:36.000000Z","normalized_code":"39375A"},{"id":6779796,"change_date":"2023-11-14 21:41:00","inspection_id":"80116201","insp_violation_id":"256381005","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"198048854","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:36.000000Z","updated_at":"2025-03-17T21:38:36.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7047367,"change_date":"2023-11-14 21:41:00","inspection_id":"80116201","insp_unit_id":"198048853","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"K6771HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FUBB1B893DL10732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:09.000000Z","updated_at":"2025-03-17T22:59:09.000000Z"},{"id":7047368,"change_date":"2023-11-14 21:41:00","inspection_id":"80116201","insp_unit_id":"198048854","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BETT","insp_unit_company":"01","insp_unit_license":"87624TE","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MNDP242791000053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:09.000000Z","updated_at":"2025-03-17T22:59:09.000000Z"}]},{"id":3273482,"change_date":"2023-06-13 21:42:00","inspection_id":"78879224","dot_number":"1834809","report_state":"TN","report_number":"TEYY004363","insp_date":"2023-06-09 00:00:00","insp_start_time":"1630","insp_end_time":"1704","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"THP 4 HAYWOOD SCALES - EAST","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MID SOUTH BORING & PIPING LLC","shipping_paper_number":"06092023","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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","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":"1652959","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2023-06-13 21:42:00","snet_input_date":"2023-06-13 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:44.000000Z","updated_at":"2025-03-17T19:27:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5263322,"change_date":"2023-06-13 21:42:00","inspection_id":"78879224","insp_unit_id":"195471880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"550","insp_unit_license":"H513545","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FD0W5GT2BEC42012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5263323,"change_date":"2023-06-13 21:42:00","inspection_id":"78879224","insp_unit_id":"195471881","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T4","insp_unit_license":"6391TE7","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"}]},{"id":2931900,"change_date":"2023-05-01 21:39:00","inspection_id":"78493668","dot_number":"1834809","report_state":"TN","report_number":"XXXX000005","insp_date":"2023-04-28 00:00:00","insp_start_time":"0630","insp_end_time":"1905","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"THP 4 HAYWOOD COUNTY SCALE","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MIDSOUTH BORING AND PIPING LLC","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-05-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","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":"1643185","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2023-05-01 21:39:00","snet_input_date":"2023-05-01 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-05-01 21:39:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:55.000000Z","updated_at":"2025-03-17T19:20:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4717286,"change_date":"2023-05-01 21:39:00","inspection_id":"78493668","insp_unit_id":"194675548","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H513545","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FD0W5GT2BEC42012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"},{"id":4717287,"change_date":"2023-05-01 21:39:00","inspection_id":"78493668","insp_unit_id":"194675549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELT","insp_unit_company":null,"insp_unit_license":"6391TE7","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:11.000000Z","updated_at":"2025-03-17T22:40:11.000000Z"}]},{"id":2433084,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","dot_number":"1834809","report_state":"KY","report_number":"S156000134","insp_date":"2023-02-22 00:00:00","insp_start_time":"1429","insp_end_time":"1524","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SHELBYVILLE","county_code_state":"KY","county_code":"211","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2023-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37300","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":"2150464","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":"M","census_search_date":"2023-02-23 21:40:00","snet_input_date":"2023-02-23 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:27.000000Z","updated_at":"2025-03-17T19:11:27.000000Z","inspection_violations":[{"id":3746532,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294778","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193540939","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39021TB"},{"id":3746533,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294779","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193540940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"},{"id":3746534,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294780","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"193540939","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39348A"},{"id":3746535,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294781","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193540939","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39617C"},{"id":3746536,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294782","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193540940","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39617C"},{"id":3746537,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294783","seq_no":"6","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"193540940","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39343"},{"id":3746538,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_violation_id":"251294784","seq_no":"7","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"193540939","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":3915352,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_unit_id":"193540939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"H460762","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FD8W3G67BEC02428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"},{"id":3915353,"change_date":"2023-02-23 21:40:00","inspection_id":"77926791","insp_unit_id":"193540940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"}]},{"id":1833553,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","dot_number":"1834809","report_state":"TN","report_number":"TCJW006554","insp_date":"2022-11-28 00:00:00","insp_start_time":"1645","insp_end_time":"1735","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"THP 4 HAYWOOD SCALES - EAST","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MID SOUTH BORING & PIPING LLC","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":"2022-11-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1614495","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2022-11-29 21:41:00","snet_input_date":"2022-11-29 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-29 21:41:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:22.000000Z","updated_at":"2025-03-17T19:00:22.000000Z","inspection_violations":[{"id":2861673,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_violation_id":"249828469","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192170939","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"39395F"},{"id":2861674,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_violation_id":"249828470","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"192170940","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"39343"},{"id":2861675,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_violation_id":"249828471","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192170940","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3939A"},{"id":2861676,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_violation_id":"249828472","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192170940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:20:38.000000Z","updated_at":"2025-03-17T21:20:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2949912,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_unit_id":"192170939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"37614H2","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FTWF33F4YEB11742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"},{"id":2949913,"change_date":"2022-11-29 21:41:00","inspection_id":"77241637","insp_unit_id":"192170940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"NONE","insp_unit_license":"NONE","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"NONE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1645679,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","dot_number":"1834809","report_state":"TN","report_number":"TFFS000072","insp_date":"2022-10-31 00:00:00","insp_start_time":"1600","insp_end_time":"1634","registration_date":null,"region":"CT","ci_status_code":"C","location":"I65","location_desc":"I65 NB MM 110","county_code_state":"TN","county_code":"147","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"MID SOUTH SPETIC","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":"N","pen_cen_match":"I","final_status_date":"2022-11-01 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"41500","viol_total":"4","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1608654","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:02.000000Z","updated_at":"2025-03-17T18:57:02.000000Z","inspection_violations":[{"id":2582525,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_violation_id":"249365731","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191744888","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"39375A3"},{"id":2582526,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_violation_id":"249365732","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191744888","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3939A"},{"id":2582527,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_violation_id":"249365733","seq_no":"3","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"191744889","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"393205A"},{"id":2582528,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_violation_id":"249365734","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191744889","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:19:11.000000Z","updated_at":"2025-03-17T21:19:11.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":2647748,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_unit_id":"191744888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"02","insp_unit_license":"H440538","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FDAF56F3YEB79141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:09.000000Z","updated_at":"2025-03-17T22:25:09.000000Z"},{"id":2647749,"change_date":"2022-11-01 21:40:00","inspection_id":"77026245","insp_unit_id":"191744889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELS","insp_unit_company":"34","insp_unit_license":"UNKNOWN","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:09.000000Z","updated_at":"2025-03-17T22:25:09.000000Z"}]},{"id":1237442,"change_date":"2022-09-08 21:38:00","inspection_id":"76553839","dot_number":"1834809","report_state":"KY","report_number":"CV41292947","insp_date":"2022-09-07 00:00:00","insp_start_time":"1410","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"9801","location_desc":"SHELBYVILLE","county_code_state":"KY","county_code":"211","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MID SOUTH BORING & PIPING 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":"2022-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"2120367","transaction_code":"A","transaction_date":"2022-09-08 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":"M","census_search_date":"2022-09-08 21:38:00","snet_input_date":"2022-09-08 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[{"id":1959993,"change_date":"2022-09-08 21:38:00","inspection_id":"76553839","insp_violation_id":"248279429","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190783028","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ED01412","created_at":"2025-03-17T21:16:00.000000Z","updated_at":"2025-03-17T21:16:00.000000Z","normalized_code":"3922"},{"id":1959994,"change_date":"2022-09-08 21:38:00","inspection_id":"76553839","insp_violation_id":"248279430","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190783029","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:00.000000Z","updated_at":"2025-03-17T21:16:00.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1991253,"change_date":"2022-09-08 21:38:00","inspection_id":"76553839","insp_unit_id":"190783028","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5","insp_unit_license":"K6870HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"2HSCUAPR79C091390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"},{"id":1991254,"change_date":"2022-09-08 21:38:00","inspection_id":"76553839","insp_unit_id":"190783029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELT","insp_unit_company":null,"insp_unit_license":"75TE083","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"}]},{"id":501494,"change_date":"2022-05-27 21:40:00","inspection_id":"75691110","dot_number":"1834809","report_state":"KY","report_number":"CV43952530","insp_date":"2022-05-26 00:00:00","insp_start_time":"1245","insp_end_time":"1346","registration_date":null,"region":"CT","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MID SOUTH BORING & PIPING LLC","shipping_paper_number":"05262022","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-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32800","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":"2102384","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01834809","upload_search_indicator":null,"census_search_date":"2022-05-27 21:40:00","snet_input_date":"2022-05-27 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-05-27 21:40:00","insp_carrier_name":"MID SOUTH BORING & PIPING LLC","insp_carrier_street":"1132 COLLIERVILLE-ARLINGTON RD","insp_carrier_city":"COLLIERVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"38017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:38.000000Z","updated_at":"2025-03-17T18:36:38.000000Z","inspection_violations":[{"id":796899,"change_date":"2022-05-27 21:40:00","inspection_id":"75691110","insp_violation_id":"246132164","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188958686","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:10:47.000000Z","updated_at":"2025-03-17T21:10:47.000000Z","normalized_code":"39375A3"},{"id":796900,"change_date":"2022-05-27 21:40:00","inspection_id":"75691110","insp_violation_id":"246132165","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188958686","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:47.000000Z","updated_at":"2025-03-17T21:10:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":806114,"change_date":"2022-05-27 21:40:00","inspection_id":"75691110","insp_unit_id":"188958685","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"129H182","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FTNW21F91EB49823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"},{"id":806115,"change_date":"2022-05-27 21:40:00","inspection_id":"75691110","insp_unit_id":"188958686","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELT","insp_unit_company":"34","insp_unit_license":"MISSING","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4MWFS44292N009558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1834809\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1834809\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1834809\/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\/1834809\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}