{"current_page":1,"data":[{"id":12282676,"change_date":"2026-06-25 21:51:00","inspection_id":"88242541","dot_number":"3791348","report_state":"TX","report_number":"7GI79DACO4","insp_date":"2026-06-19 00:00:00","insp_start_time":"0645","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-0130 IN TRAVIS CO. (426-461","county_code_state":"TX","county_code":"453","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-25 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"10005905","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-06-25 21:51:00","snet_input_date":"2026-06-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-25 21:51:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2026-06-28T09:39:53.000000Z","updated_at":"2026-06-28T09:39:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21327591,"change_date":"2026-06-25 21:51:00","inspection_id":"88242541","insp_unit_id":"214289583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"4530003","insp_unit_license":"K216686","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7PED21631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:34.000000Z","updated_at":"2026-06-28T09:15:34.000000Z"},{"id":21327592,"change_date":"2026-06-25 21:51:00","inspection_id":"88242541","insp_unit_id":"214289584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIRE","insp_unit_company":null,"insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:34.000000Z","updated_at":"2026-06-28T09:15:34.000000Z"}]},{"id":11989058,"change_date":"2026-05-22 08:07:00","inspection_id":"87926735","dot_number":"3791348","report_state":"IA","report_number":"000P15FC3F","insp_date":"2026-05-20 00:00:00","insp_start_time":"0744","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB I29","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"4-HORN TRENCH","shipping_paper_number":"TUBS","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-05-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1401969","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:06.000000Z","updated_at":"2026-06-02T09:31:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20842516,"change_date":"2026-05-22 08:07:00","inspection_id":"87926735","insp_unit_id":"213695425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRK45500","insp_unit_license":"K223736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDTF4HT8SDA05004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:58.000000Z","updated_at":"2026-06-02T09:04:13.000000Z"},{"id":20842517,"change_date":"2026-05-22 08:07:00","inspection_id":"87926735","insp_unit_id":"213695426","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"6001","insp_unit_license":"271C992","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3629TB093383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:58.000000Z","updated_at":"2026-06-02T09:04:13.000000Z"}]},{"id":11708217,"change_date":"2026-04-21 21:38:00","inspection_id":"87635029","dot_number":"3791348","report_state":"LA","report_number":"LANMS00939","insp_date":"2026-04-20 00:00:00","insp_start_time":"1350","insp_end_time":"1406","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MINDEN LA","county_code_state":"LA","county_code":null,"insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"3190301","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:42.000000Z","updated_at":"2026-05-02T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20374874,"change_date":"2026-04-21 21:38:00","inspection_id":"87635029","insp_unit_id":"213135581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"TRK454006","insp_unit_license":"K216690","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT1RDA34374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:55.000000Z","updated_at":"2026-05-02T09:03:02.000000Z"},{"id":20374875,"change_date":"2026-04-21 21:38:00","inspection_id":"87635029","insp_unit_id":"213135582","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANCH KING","insp_unit_company":"TRL GN5002","insp_unit_license":"168045N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA4022SB092492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:55.000000Z","updated_at":"2026-05-02T09:03:02.000000Z"}]},{"id":11531654,"change_date":"2026-03-31 21:40:00","inspection_id":"87453443","dot_number":"3791348","report_state":"IA","report_number":"000P16D9ZZ","insp_date":"2026-03-28 00:00:00","insp_start_time":"1125","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","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":"N","pen_cen_match":null,"final_status_date":"2026-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1395359","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-03-31 21:40:00","snet_input_date":"2026-03-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-31 21:40:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-03T09:46:20.000000Z","updated_at":"2026-04-11T09:31:22.000000Z","inspection_violations":[{"id":19482602,"change_date":"2026-03-31 21:40:00","inspection_id":"87453443","insp_violation_id":"272772484","seq_no":"1","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"212453758","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:12:36.000000Z","updated_at":"2026-04-11T09:45:24.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":19757262,"change_date":"2026-03-31 21:40:00","inspection_id":"87453443","insp_unit_id":"212453757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRK45500","insp_unit_license":"K223736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDTF4HT8SDA05004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-03T09:24:40.000000Z","updated_at":"2026-04-11T09:04:14.000000Z"},{"id":19757263,"change_date":"2026-03-31 21:40:00","inspection_id":"87453443","insp_unit_id":"212453758","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HARRIS","insp_unit_company":null,"insp_unit_license":"271C992","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3629TB093383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-03T09:24:40.000000Z","updated_at":"2026-04-11T09:04:14.000000Z"}]},{"id":11478742,"change_date":"2026-03-25 21:40:00","inspection_id":"87397776","dot_number":"3791348","report_state":"TX","report_number":"V262282395","insp_date":"2026-03-23 00:00:00","insp_start_time":"0938","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8754  US59 SB","county_code_state":"TX","county_code":"347","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4 HORN","shipping_paper_number":"9852","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9894812","transaction_code":"A","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2026-03-28T09:44:51.000000Z","updated_at":"2026-04-05T09:32:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19662015,"change_date":"2026-03-25 21:40:00","inspection_id":"87397776","insp_unit_id":"212337841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"454006","insp_unit_license":"K216690","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT1RDA34374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:02.000000Z","updated_at":"2026-04-05T09:19:18.000000Z"},{"id":19662016,"change_date":"2026-03-25 21:40:00","inspection_id":"87397776","insp_unit_id":"212337842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":"5002","insp_unit_license":"168045N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA4022SB092492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-28T09:23:02.000000Z","updated_at":"2026-04-05T09:19:18.000000Z"}]},{"id":11336804,"change_date":"2026-03-10 21:39:00","inspection_id":"87254198","dot_number":"3791348","report_state":"TX","report_number":"V262261242","insp_date":"2026-03-05 00:00:00","insp_start_time":"0810","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TOLL 130 SB","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4 HORN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"9877683","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-03-10 21:39:00","snet_input_date":"2026-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-10 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2026-03-13T09:43:56.000000Z","updated_at":"2026-03-21T09:31:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19400077,"change_date":"2026-03-10 21:39:00","inspection_id":"87254198","insp_unit_id":"212068913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"453003","insp_unit_license":"K216686","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7PED21631","insp_unit_decal":"Y","insp_unit_decal_number":"35968143","created_at":"2026-03-13T09:23:29.000000Z","updated_at":"2026-03-21T09:12:03.000000Z"},{"id":19400078,"change_date":"2026-03-10 21:39:00","inspection_id":"87254198","insp_unit_id":"212068914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"0","insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"Y","insp_unit_decal_number":"35968144","created_at":"2026-03-13T09:23:29.000000Z","updated_at":"2026-03-21T09:12:03.000000Z"}]},{"id":11151691,"change_date":"2026-02-17 21:39:00","inspection_id":"87066345","dot_number":"3791348","report_state":"TX","report_number":"7D0C9DNK97","insp_date":"2026-02-13 00:00:00","insp_start_time":"1237","insp_end_time":"1311","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9851412","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2026-02-20T10:37:51.000000Z","updated_at":"2026-02-28T10:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19025031,"change_date":"2026-02-17 21:39:00","inspection_id":"87066345","insp_unit_id":"211667383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K221519","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT8RDA34291","insp_unit_decal":"Y","insp_unit_decal_number":"35975891","created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:04:00.000000Z"},{"id":19025032,"change_date":"2026-02-17 21:39:00","inspection_id":"87066345","insp_unit_id":"211667384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTD","insp_unit_company":null,"insp_unit_license":"168044N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA4024SB092493","insp_unit_decal":"Y","insp_unit_decal_number":"35975892","created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:04:00.000000Z"}]},{"id":10793658,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","dot_number":"3791348","report_state":"TX","report_number":"V262186863","insp_date":"2026-01-13 00:00:00","insp_start_time":"0957","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX130 TOLL SB N OF F","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"3003-T","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9821146","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2026-01-16 21:40:00","snet_input_date":"2026-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-16 21:40:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2026-01-19T10:37:00.000000Z","updated_at":"2026-01-27T10:30:58.000000Z","inspection_violations":[{"id":18036746,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","insp_violation_id":"271263266","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211141017","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:39.000000Z","normalized_code":"39617C"},{"id":18036747,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","insp_violation_id":"271263267","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211141018","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:39.000000Z","normalized_code":"39617C"},{"id":18036748,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","insp_violation_id":"271263268","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211141017","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:39.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18121913,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","insp_unit_id":"211141017","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3003-T","insp_unit_license":"K216686","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7PED21631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:30.000000Z","updated_at":"2026-01-27T10:01:04.000000Z"},{"id":18121914,"change_date":"2026-01-16 21:40:00","inspection_id":"86819888","insp_unit_id":"211141018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:30.000000Z","updated_at":"2026-01-27T10:01:04.000000Z"}]},{"id":10484033,"change_date":"2025-12-19 21:40:00","inspection_id":"86618141","dot_number":"3791348","report_state":"TX","report_number":"7B699DQA3T","insp_date":"2025-12-09 00:00:00","insp_start_time":"0856","insp_end_time":"0908","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN FORT BEND CO. (95-1","county_code_state":"TX","county_code":"157","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46500","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":"9791453","transaction_code":"A","transaction_date":"2025-12-19 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-12-19 21:40:00","snet_input_date":"2025-12-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-19 21:40:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2025-12-22T10:32:10.000000Z","updated_at":"2025-12-30T10:34:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17553764,"change_date":"2025-12-19 21:40:00","inspection_id":"86618141","insp_unit_id":"210730033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"`","insp_unit_license":"K216685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7NED57591","insp_unit_decal":"Y","insp_unit_decal_number":"35655659","created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:29.000000Z"},{"id":17553765,"change_date":"2025-12-19 21:40:00","inspection_id":"86618141","insp_unit_id":"210730034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTD","insp_unit_company":null,"insp_unit_license":"530737M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3026NB084961","insp_unit_decal":"Y","insp_unit_decal_number":"35655660","created_at":"2025-12-22T10:02:09.000000Z","updated_at":"2025-12-30T10:01:29.000000Z"}]},{"id":10240924,"change_date":"2025-11-19 21:39:00","inspection_id":"86363738","dot_number":"3791348","report_state":"TX","report_number":"7ADD9DNK6N","insp_date":"2025-11-10 00:00:00","insp_start_time":"1229","insp_end_time":"1317","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"42400","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":"9762300","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-11-19 21:39:00","snet_input_date":"2025-11-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-19 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2025-11-23T10:31:50.000000Z","updated_at":"2025-11-23T10:31:50.000000Z","inspection_violations":[{"id":17029721,"change_date":"2025-11-19 21:39:00","inspection_id":"86363738","insp_violation_id":"270068266","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210126784","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-23T10:32:22.000000Z","updated_at":"2025-11-23T10:32:22.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":17068894,"change_date":"2025-11-19 21:39:00","inspection_id":"86363738","insp_unit_id":"210126783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K216689","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT9RDA34364","insp_unit_decal":"Y","insp_unit_decal_number":"35653800","created_at":"2025-11-23T10:01:51.000000Z","updated_at":"2025-11-23T10:01:51.000000Z"},{"id":17068895,"change_date":"2025-11-19 21:39:00","inspection_id":"86363738","insp_unit_id":"210126784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"001863N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3628PB088276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:51.000000Z","updated_at":"2025-11-23T10:01:51.000000Z"}]},{"id":10240964,"change_date":"2025-11-19 21:39:00","inspection_id":"86363782","dot_number":"3791348","report_state":"TX","report_number":"7ADE9DGX4X","insp_date":"2025-11-10 00:00:00","insp_start_time":"1424","insp_end_time":"1446","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","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":"9762361","transaction_code":"A","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-11-19 21:39:00","snet_input_date":"2025-11-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-19 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2025-11-23T10:31:50.000000Z","updated_at":"2025-11-23T10:31:50.000000Z","inspection_violations":[{"id":17029834,"change_date":"2025-11-19 21:39:00","inspection_id":"86363782","insp_violation_id":"270068418","seq_no":"1","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"210126853","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-11-23T10:32:22.000000Z","updated_at":"2025-11-23T10:32:22.000000Z","normalized_code":"39343D"},{"id":17029835,"change_date":"2025-11-19 21:39:00","inspection_id":"86363782","insp_violation_id":"270068419","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"210126853","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-11-23T10:32:22.000000Z","updated_at":"2025-11-23T10:32:22.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":17068950,"change_date":"2025-11-19 21:39:00","inspection_id":"86363782","insp_unit_id":"210126852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45.200 1-T","insp_unit_license":"K216685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7NED57591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:51.000000Z","updated_at":"2025-11-23T10:01:51.000000Z"},{"id":17068951,"change_date":"2025-11-19 21:39:00","inspection_id":"86363782","insp_unit_id":"210126853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MTD","insp_unit_company":null,"insp_unit_license":"530737M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3026NB084961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:51.000000Z","updated_at":"2025-11-23T10:01:51.000000Z"}]},{"id":10149147,"change_date":"2025-11-07 21:40:00","inspection_id":"86267266","dot_number":"3791348","report_state":"TX","report_number":"V252106373","insp_date":"2025-11-05 00:00:00","insp_start_time":"1101","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-360 @ RM-2222","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNSTATE EQUIPMENT CO.","shipping_paper_number":"13873478","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"9750848","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1041161","created_at":"2025-11-10T10:31:45.000000Z","updated_at":"2025-11-11T10:31:09.000000Z","inspection_violations":[{"id":16846582,"change_date":"2025-11-07 21:40:00","inspection_id":"86267266","insp_violation_id":"269819445","seq_no":"1","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"209911533","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:33:00.000000Z","updated_at":"2025-11-11T10:32:27.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":16896571,"change_date":"2025-11-07 21:40:00","inspection_id":"86267266","insp_unit_id":"209911533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1631","insp_unit_license":"K216686","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7PED21631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:17.000000Z","updated_at":"2025-11-11T10:01:21.000000Z"},{"id":16896572,"change_date":"2025-11-07 21:40:00","inspection_id":"86267266","insp_unit_id":"209911534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"6945","insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:17.000000Z","updated_at":"2025-11-11T10:01:21.000000Z"}]},{"id":9744806,"change_date":"2025-09-22 21:39:00","inspection_id":"85841701","dot_number":"3791348","report_state":"TX","report_number":"V252000391","insp_date":"2025-09-16 00:00:00","insp_start_time":"1322","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"4 HORN TRENCH & SHORING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9703021","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-09-25T10:00:26.000000Z","updated_at":"2025-09-25T10:00:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16139662,"change_date":"2025-09-22 21:39:00","inspection_id":"85841701","insp_unit_id":"209077599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45-4007","insp_unit_license":"Z901488","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1FDUF4HT8RDA34291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:27.000000Z","updated_at":"2025-09-26T09:45:42.000000Z"},{"id":16139663,"change_date":"2025-09-22 21:39:00","inspection_id":"85841701","insp_unit_id":"209077600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANH","insp_unit_company":"5003","insp_unit_license":"168044N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA4024SB092493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:27.000000Z","updated_at":"2025-09-26T09:45:42.000000Z"}]},{"id":9605547,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","dot_number":"3791348","report_state":"TX","report_number":"V252009566","insp_date":"2025-09-02 00:00:00","insp_start_time":"0912","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9688325","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-09-10T10:45:49.000000Z","updated_at":"2025-09-10T10:45:49.000000Z","inspection_violations":[{"id":15703775,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_violation_id":"268492482","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"208773637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39348A"},{"id":15703776,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_violation_id":"268492483","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"208773637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39348A"},{"id":15703777,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_violation_id":"268492484","seq_no":"3","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"208773637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39348A"},{"id":15703778,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_violation_id":"268492485","seq_no":"4","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"208773637","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39348A"},{"id":15703779,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_violation_id":"268492486","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"208773637","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15861242,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_unit_id":"208773636","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRR45-4007","insp_unit_license":"Z901488","insp_unit_license_state":"LA","insp_unit_vehicle_id_number":"1FDUF4HT8RDA34291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"},{"id":15861243,"change_date":"2025-09-05 21:39:00","inspection_id":"85695626","insp_unit_id":"208773637","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":"TRLGN-5003","insp_unit_license":"168044N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA4024SB092493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"}]},{"id":8085943,"change_date":"2025-03-11 21:41:00","inspection_id":"84094194","dot_number":"3791348","report_state":"TX","report_number":"738H9DGXOW","insp_date":"2025-02-26 00:00:00","insp_start_time":"1712","insp_end_time":"1732","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4200  RED BLUFF N\/B","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4-HORN TRENCH & SHORING, 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":"Y","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56500","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":"9517262","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-02-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13055223,"change_date":"2025-03-11 21:41:00","inspection_id":"84094194","insp_unit_id":"205740055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"45-3003-T","insp_unit_license":"TNZ5702","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7PED21631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"},{"id":13055224,"change_date":"2025-03-11 21:41:00","inspection_id":"84094194","insp_unit_id":"205740056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIRE","insp_unit_company":null,"insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"}]},{"id":7608533,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","dot_number":"3791348","report_state":"TX","report_number":"71XB9DGXL6","insp_date":"2025-01-10 00:00:00","insp_start_time":"1105","insp_end_time":"1147","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4-HORN TRENCH & SHORING 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":"Y","pen_cen_match":null,"final_status_date":"2025-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9472007","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-03-17T20:56:07.000000Z","updated_at":"2025-03-17T20:56:07.000000Z","inspection_violations":[{"id":11895181,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_violation_id":"263917293","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204786870","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39360D"},{"id":11895182,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_violation_id":"263917294","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204786871","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3922RG"},{"id":11895183,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_violation_id":"263917295","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204786871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3939"},{"id":11895184,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_violation_id":"263917296","seq_no":"5","part_no":"393","part_no_section":"104B","insp_viol_unit":"2","insp_unit_id":"204786871","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"393104B"},{"id":11895185,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_violation_id":"263917297","seq_no":"6","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"204786870","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":12276946,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_unit_id":"204786870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TXF3951","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDTF4HT5PED12910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"},{"id":12276947,"change_date":"2025-01-13 21:46:00","inspection_id":"83592854","insp_unit_id":"204786871","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"592009M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4024RM110070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"}]},{"id":7040432,"change_date":"2024-12-27 21:38:00","inspection_id":"82993763","dot_number":"3791348","report_state":"TX","report_number":"V241661135","insp_date":"2024-10-22 00:00:00","insp_start_time":"1231","insp_end_time":"1244","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR 307","county_code_state":"TX","county_code":"491","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"30300","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":"9410867","transaction_code":"C","transaction_date":"2024-12-27 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2024-10-24 21:42:00","snet_input_date":"2024-10-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-03-17T20:42:58.000000Z","updated_at":"2025-03-17T20:42:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11354663,"change_date":"2024-12-27 21:38:00","inspection_id":"82993763","insp_unit_id":"204573172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"412","insp_unit_license":"TNZ5703","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT8KEG65654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"},{"id":11354664,"change_date":"2024-12-27 21:38:00","inspection_id":"82993763","insp_unit_id":"204573173","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"412","insp_unit_license":"592025M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5R8GF4023PM106945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":4634830,"change_date":"2024-12-06 21:44:00","inspection_id":"80394182","dot_number":"3791348","report_state":"TX","report_number":"6QZ79DCEGT","insp_date":"2023-12-13 00:00:00","insp_start_time":"0736","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"455  BETHJE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4 HORN TRAFFIC AND BARRICADE","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":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"46500","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":"9149384","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-12-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-14 21:43:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-03-17T19:54:35.000000Z","updated_at":"2025-03-17T19:54:35.000000Z","inspection_violations":[{"id":7164780,"change_date":"2024-12-06 21:44:00","inspection_id":"80394182","insp_violation_id":"263291164","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204234411","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:37.000000Z","updated_at":"2025-03-17T21:40:37.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":7454616,"change_date":"2024-12-06 21:44:00","inspection_id":"80394182","insp_unit_id":"204234411","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRK452001","insp_unit_license":"SCD3394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7NED57591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"},{"id":7454617,"change_date":"2024-12-06 21:44:00","inspection_id":"80394182","insp_unit_id":"204234412","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"AMEB","insp_unit_company":"TRLGN2001","insp_unit_license":"530737M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3026NB084961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:39.000000Z","updated_at":"2025-03-17T23:02:39.000000Z"}]},{"id":1699421,"change_date":"2022-11-10 21:39:00","inspection_id":"77087776","dot_number":"3791348","report_state":"TX","report_number":"6FPA9DFXEA","insp_date":"2022-11-02 00:00:00","insp_start_time":"1059","insp_end_time":"1117","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"4 HORN TRENCH & SHORING, 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":"Y","pen_cen_match":null,"final_status_date":"2022-11-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"46500","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":"8821535","transaction_code":"C","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03791348","upload_search_indicator":"M","census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"4-HORN TRENCH & SHORING LLC","insp_carrier_street":"8003 RED BLUFF RD","insp_carrier_city":"PASADENA","insp_carrier_state":"TX","insp_carrier_zip_code":"77507-1169","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1041161","created_at":"2025-03-17T18:57:49.000000Z","updated_at":"2025-03-17T18:57:49.000000Z","inspection_violations":[{"id":2664149,"change_date":"2022-11-10 21:39:00","inspection_id":"77087776","insp_violation_id":"249551278","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"191910036","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:33.000000Z","updated_at":"2025-03-17T21:19:33.000000Z","normalized_code":"39343"},{"id":2664150,"change_date":"2022-11-10 21:39:00","inspection_id":"77087776","insp_violation_id":"249551279","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191910035","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:33.000000Z","updated_at":"2025-03-17T21:19:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2734469,"change_date":"2022-11-10 21:39:00","inspection_id":"77087776","insp_unit_id":"191910035","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SCD3394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDUF4HT7NED57591","insp_unit_decal":"Y","insp_unit_decal_number":"31927377","created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"},{"id":2734470,"change_date":"2022-11-10 21:39:00","inspection_id":"77087776","insp_unit_id":"191910036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMEM","insp_unit_company":null,"insp_unit_license":"329551M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3026NB084961","insp_unit_decal":"Y","insp_unit_decal_number":"31927378","created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3791348\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3791348\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3791348\/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\/3791348\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}