{"current_page":1,"data":[{"id":12546147,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","dot_number":"574825","report_state":"TX","report_number":"V262499036","insp_date":"2026-07-21 00:00:00","insp_start_time":"0706","insp_end_time":"0738","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"656M US77 NB","county_code_state":"TX","county_code":"409","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INV NYLON CHEMICALS AMERICAS","shipping_paper_number":"015521330","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125220","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":"10044444","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-07-24 21:41:00","snet_input_date":"2026-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-24 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-07-27T09:41:43.000000Z","updated_at":"2026-08-04T09:31:35.000000Z","inspection_violations":[{"id":21842580,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","insp_violation_id":"275726329","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214812194","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:34.000000Z","updated_at":"2026-08-04T09:44:58.000000Z","normalized_code":"39355E"},{"id":21842581,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","insp_violation_id":"275726330","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214812193","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:34.000000Z","updated_at":"2026-08-04T09:44:58.000000Z","normalized_code":"3922RG"},{"id":21842582,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","insp_violation_id":"275726331","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"214812194","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:34.000000Z","updated_at":"2026-08-04T09:44:58.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21785914,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","insp_unit_id":"214812194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR-06","insp_unit_license":"241C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH3427LD175260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:06.000000Z","updated_at":"2026-08-04T09:03:14.000000Z"},{"id":21785913,"change_date":"2026-07-24 21:41:00","inspection_id":"88512873","insp_unit_id":"214812193","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"CT-1","insp_unit_license":"R688239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4KC9EH6RN639295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:06.000000Z","updated_at":"2026-08-04T09:03:14.000000Z"}]},{"id":12404746,"change_date":"2026-07-09 21:42:00","inspection_id":"88362547","dot_number":"574825","report_state":"TX","report_number":"V262352989","insp_date":"2026-06-26 00:00:00","insp_start_time":"1042","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX44 WB","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCHWELL ENVIRONMENTAL SOLU","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-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","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":"10019126","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-07-09 21:42:00","snet_input_date":"2026-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-09 21:42:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-07-13T09:39:33.000000Z","updated_at":"2026-07-20T09:31:40.000000Z","inspection_violations":[{"id":21586234,"change_date":"2026-07-09 21:42:00","inspection_id":"88362547","insp_violation_id":"275391783","seq_no":"1","part_no":"393","part_no_section":"11S","insp_viol_unit":"2","insp_unit_id":"214525639","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:56:30.000000Z","updated_at":"2026-07-20T09:46:26.000000Z","normalized_code":"39311S"}],"inspection_per_units":[{"id":21549435,"change_date":"2026-07-09 21:42:00","inspection_id":"88362547","insp_unit_id":"214525638","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT-2","insp_unit_license":"R722648","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV3SLVT2828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:58.000000Z","updated_at":"2026-07-20T09:03:28.000000Z"},{"id":21549436,"change_date":"2026-07-09 21:42:00","inspection_id":"88362547","insp_unit_id":"214525639","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CVT-04","insp_unit_license":"248C680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4221RL200093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:58.000000Z","updated_at":"2026-07-20T09:03:28.000000Z"}]},{"id":12261925,"change_date":"2026-06-23 21:39:00","inspection_id":"88220813","dot_number":"574825","report_state":"TX","report_number":"V262434162","insp_date":"2026-06-20 00:00:00","insp_start_time":"1947","insp_end_time":"1957","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MOTAS","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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10003737","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-06-26T09:41:00.000000Z","updated_at":"2026-07-04T09:31:13.000000Z","inspection_violations":[{"id":21343951,"change_date":"2026-06-23 21:39:00","inspection_id":"88220813","insp_violation_id":"275085727","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"214247913","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:46.000000Z","updated_at":"2026-07-04T09:44:15.000000Z","normalized_code":"39360C"},{"id":21343952,"change_date":"2026-06-23 21:39:00","inspection_id":"88220813","insp_violation_id":"275085728","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214247913","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:46.000000Z","updated_at":"2026-07-04T09:44:15.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":21293022,"change_date":"2026-06-23 21:39:00","inspection_id":"88220813","insp_unit_id":"214247914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CT-04","insp_unit_license":"217C918","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH4828PL191186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:01.000000Z"},{"id":21293021,"change_date":"2026-06-23 21:39:00","inspection_id":"88220813","insp_unit_id":"214247913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT-03","insp_unit_license":"R753287","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X0JD464859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:01.000000Z"}]},{"id":11830975,"change_date":"2026-05-05 21:40:00","inspection_id":"87766049","dot_number":"574825","report_state":"TX","report_number":"V262335034","insp_date":"2026-04-30 00:00:00","insp_start_time":"1255","insp_end_time":"1328","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"560M TX44 WB","county_code_state":"TX","county_code":"355","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9943281","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-05-05 21:40:00","snet_input_date":"2026-04-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-05 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-05-08T09:40:35.000000Z","updated_at":"2026-05-15T12:19:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20575925,"change_date":"2026-05-05 21:40:00","inspection_id":"87766049","insp_unit_id":"213395325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT03","insp_unit_license":"R753287","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X0JD464859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:32.000000Z","updated_at":"2026-05-15T11:58:34.000000Z"}]},{"id":11428432,"change_date":"2026-03-20 21:40:00","inspection_id":"87344603","dot_number":"574825","report_state":"TX","report_number":"V262240891","insp_date":"2026-03-17 00:00:00","insp_start_time":"1010","insp_end_time":"1038","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 MP 404","county_code_state":"TX","county_code":"435","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCHWELL","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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134320","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":"9890616","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-03-20 21:40:00","snet_input_date":"2026-03-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-20 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-03-23T09:46:38.000000Z","updated_at":"2026-03-31T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19578146,"change_date":"2026-03-20 21:40:00","inspection_id":"87344603","insp_unit_id":"212243877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT2","insp_unit_license":"R722648","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV3SLVT2828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:05.000000Z","updated_at":"2026-03-31T09:11:12.000000Z"},{"id":19578147,"change_date":"2026-03-20 21:40:00","inspection_id":"87344603","insp_unit_id":"212243878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR04","insp_unit_license":"217C918","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH4828PL191186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:05.000000Z","updated_at":"2026-03-31T09:11:12.000000Z"}]},{"id":11337039,"change_date":"2026-03-10 21:39:00","inspection_id":"87254446","dot_number":"574825","report_state":"TX","report_number":"V262262076","insp_date":"2026-03-05 00:00:00","insp_start_time":"1623","insp_end_time":"1633","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHURCHWELL ENVIRONMENTAL SERV","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-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"9878205","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":"00574825","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":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-03-13T09:43:56.000000Z","updated_at":"2026-03-21T09:31:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19400483,"change_date":"2026-03-10 21:39:00","inspection_id":"87254446","insp_unit_id":"212069350","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CVT-01","insp_unit_license":"R736563","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV4SPVY1271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:29.000000Z","updated_at":"2026-03-21T09:12:06.000000Z"}]},{"id":10894375,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","dot_number":"574825","report_state":"TX","report_number":"V262208745","insp_date":"2026-01-28 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"639 ANACACHO LN","county_code_state":"TX","county_code":"271","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9835213","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-01-30 21:39:00","snet_input_date":"2026-01-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-30 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-02-02T10:35:38.000000Z","updated_at":"2026-02-10T10:31:56.000000Z","inspection_violations":[{"id":18244286,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","insp_violation_id":"271520650","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"211369809","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:19.000000Z","updated_at":"2026-02-10T10:41:21.000000Z","normalized_code":"3939H"},{"id":18244287,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","insp_violation_id":"271520651","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211369810","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:19.000000Z","updated_at":"2026-02-10T10:41:21.000000Z","normalized_code":"3939"},{"id":18244288,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","insp_violation_id":"271520652","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211369810","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:19.000000Z","updated_at":"2026-02-10T10:41:21.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18316175,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","insp_unit_id":"211369809","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT-03","insp_unit_license":"R753287","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X0JD464859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-02T10:10:08.000000Z","updated_at":"2026-02-10T10:05:05.000000Z"},{"id":18316176,"change_date":"2026-01-30 21:39:00","inspection_id":"86925449","insp_unit_id":"211369810","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CVT-04","insp_unit_license":"248C680","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4221RL200093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-02T10:10:08.000000Z","updated_at":"2026-02-10T10:05:05.000000Z"}]},{"id":10590309,"change_date":"2026-01-07 21:38:00","inspection_id":"86729123","dot_number":"574825","report_state":"TX","report_number":"V252161299","insp_date":"2025-12-31 00:00:00","insp_start_time":"1335","insp_end_time":"1406","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7510 IH37 NB SVC RD","county_code_state":"TX","county_code":"355","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-01-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9808846","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2026-01-07 21:38:00","snet_input_date":"2025-12-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-07 21:38:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2026-01-10T10:34:41.000000Z","updated_at":"2026-01-18T10:31:58.000000Z","inspection_violations":[{"id":17800621,"change_date":"2026-01-07 21:38:00","inspection_id":"86729123","insp_violation_id":"271067275","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:01.000000Z","updated_at":"2026-01-18T10:32:18.000000Z","normalized_code":"38323A2"},{"id":17800622,"change_date":"2026-01-07 21:38:00","inspection_id":"86729123","insp_violation_id":"271067276","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-10T10:39:01.000000Z","updated_at":"2026-01-18T10:32:18.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17752110,"change_date":"2026-01-07 21:38:00","inspection_id":"86729123","insp_unit_id":"210959422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT4","insp_unit_license":"R736563","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV4SPVY1271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:11.000000Z","updated_at":"2026-01-18T10:01:33.000000Z"}]},{"id":9972988,"change_date":"2025-10-17 21:39:00","inspection_id":"86081723","dot_number":"574825","report_state":"TX","report_number":"V252041292","insp_date":"2025-10-14 00:00:00","insp_start_time":"1050","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 MP 404","county_code_state":"TX","county_code":"435","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CURCHWELL","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-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126320","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9729837","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-10-20T10:01:56.000000Z","updated_at":"2025-10-21T10:00:56.000000Z","inspection_violations":[{"id":16474559,"change_date":"2025-10-17 21:39:00","inspection_id":"86081723","insp_violation_id":"269371816","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209531083","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:18:03.000000Z","updated_at":"2025-10-21T10:16:44.000000Z","normalized_code":"39617C"},{"id":16474560,"change_date":"2025-10-17 21:39:00","inspection_id":"86081723","insp_violation_id":"269371817","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"209531084","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:18:03.000000Z","updated_at":"2025-10-21T10:16:44.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":16559156,"change_date":"2025-10-17 21:39:00","inspection_id":"86081723","insp_unit_id":"209531083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT4","insp_unit_license":"R736563","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV4SPVY1271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:07.000000Z","updated_at":"2025-10-21T09:46:18.000000Z"},{"id":16559157,"change_date":"2025-10-17 21:39:00","inspection_id":"86081723","insp_unit_id":"209531084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"05","insp_unit_license":"212C986","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH3426LD175282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:07.000000Z","updated_at":"2025-10-21T09:46:18.000000Z"}]},{"id":9952603,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","dot_number":"574825","report_state":"TX","report_number":"V252066486","insp_date":"2025-10-10 00:00:00","insp_start_time":"1310","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5118  TX44 EB","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BRANDT HHL ENTERPRISES INC","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-10-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9727520","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-10-18T10:02:00.000000Z","updated_at":"2025-10-19T10:01:14.000000Z","inspection_violations":[{"id":16434016,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","insp_violation_id":"269325819","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"209491365","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-10-18T10:18:13.000000Z","updated_at":"2025-10-19T10:17:10.000000Z","normalized_code":"39375A3"},{"id":16434017,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","insp_violation_id":"269325820","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"209491365","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:13.000000Z","updated_at":"2025-10-19T10:17:10.000000Z","normalized_code":"39375A3"},{"id":16434018,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","insp_violation_id":"269325821","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209491365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:13.000000Z","updated_at":"2025-10-19T10:17:10.000000Z","normalized_code":"3939"},{"id":16434019,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","insp_violation_id":"269325822","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"209491365","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:13.000000Z","updated_at":"2025-10-19T10:17:10.000000Z","normalized_code":"39311TL"}],"inspection_per_units":[{"id":16522451,"change_date":"2025-10-15 21:39:00","inspection_id":"86060284","insp_unit_id":"209491365","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT-03","insp_unit_license":"R753287","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X0JD464859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:18.000000Z","updated_at":"2025-10-19T09:46:32.000000Z"}]},{"id":9536309,"change_date":"2025-08-28 21:41:00","inspection_id":"85623049","dot_number":"574825","report_state":"TX","report_number":"V251989094","insp_date":"2025-08-27 00:00:00","insp_start_time":"0821","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHURCHWELL ENVIRONMENTAL SOLU","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-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124320","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":"9679030","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-09-06T10:42:18.000000Z","updated_at":"2025-09-06T10:42:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15739777,"change_date":"2025-08-28 21:41:00","inspection_id":"85623049","insp_unit_id":"208641275","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT-4","insp_unit_license":"R736563","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV4SPVY1271","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:40.000000Z","updated_at":"2025-09-09T09:46:40.000000Z"},{"id":15739778,"change_date":"2025-08-28 21:41:00","inspection_id":"85623049","insp_unit_id":"208641276","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"WHP4760","insp_unit_license":"212C868","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4221ML153978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:40.000000Z","updated_at":"2025-09-09T09:46:40.000000Z"}]},{"id":8356095,"change_date":"2025-04-11 21:41:00","inspection_id":"84378549","dot_number":"574825","report_state":"TX","report_number":"V251808664","insp_date":"2025-04-10 00:00:00","insp_start_time":"0848","insp_end_time":"0902","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX44 WB","county_code_state":"TX","county_code":"249","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCHWELL ENVIROMENTAL","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-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123220","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":"9547819","transaction_code":"A","transaction_date":"2025-04-11 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2025-04-11 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-11 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-04-14T10:29:52.000000Z","updated_at":"2025-04-15T10:16:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13558351,"change_date":"2025-04-11 21:41:00","inspection_id":"84378549","insp_unit_id":"206274239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CT7","insp_unit_license":"1L65909","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEDV3GSGV3854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:19:24.000000Z","updated_at":"2025-04-15T10:05:46.000000Z"},{"id":13558352,"change_date":"2025-04-11 21:41:00","inspection_id":"84378549","insp_unit_id":"206274240","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"VT176","insp_unit_license":"114613A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"1L9JD72A5HL033863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:19:24.000000Z","updated_at":"2025-04-15T10:05:46.000000Z"}]},{"id":8112047,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","dot_number":"574825","report_state":"TX","report_number":"V251803829","insp_date":"2025-03-12 00:00:00","insp_start_time":"0920","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"IRONCLAD","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-03-13 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"124320","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9522257","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2025-03-13 21:44:00","snet_input_date":"2025-03-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T21:06:52.000000Z","updated_at":"2025-03-17T21:06:52.000000Z","inspection_violations":[{"id":12684879,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_violation_id":"265031043","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"205793350","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"39355E"},{"id":12684880,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_violation_id":"265031044","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"205793350","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3939"},{"id":12684881,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_violation_id":"265031045","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205793349","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3922RG"},{"id":12684882,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_violation_id":"265031046","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"205793350","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:08.000000Z","updated_at":"2025-03-17T22:08:08.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13097736,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_unit_id":"205793349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"CT-2","insp_unit_license":"R722648","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJBPDV3SLVT2828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:48.000000Z","updated_at":"2025-03-17T23:59:48.000000Z"},{"id":13097737,"change_date":"2025-03-13 21:44:00","inspection_id":"84121650","insp_unit_id":"205793350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CRO-02","insp_unit_license":"235C957","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SH3420GC141181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:48.000000Z","updated_at":"2025-03-17T23:59:48.000000Z"}]},{"id":7431257,"change_date":"2024-12-17 21:40:00","inspection_id":"83406601","dot_number":"574825","report_state":"TX","report_number":"V241726150","insp_date":"2024-12-10 00:00:00","insp_start_time":"1228","insp_end_time":"1246","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX89 NB","county_code_state":"TX","county_code":"409","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TC OIL","shipping_paper_number":"21507","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-12-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123220","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":"9450881","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2024-12-16 21:40:00","snet_input_date":"2024-12-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-16 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T20:51:09.000000Z","updated_at":"2025-03-17T20:51:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11988889,"change_date":"2024-12-17 21:40:00","inspection_id":"83406601","insp_unit_id":"204438311","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CT9","insp_unit_license":"1M92357","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y3GM024504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:21.000000Z","updated_at":"2025-03-17T23:47:21.000000Z"},{"id":11988890,"change_date":"2024-12-17 21:40:00","inspection_id":"83406601","insp_unit_id":"204438312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR05","insp_unit_license":"212C986","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH3426LD175282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:21.000000Z","updated_at":"2025-03-17T23:47:21.000000Z"}]},{"id":6549563,"change_date":"2024-08-23 21:41:00","inspection_id":"82471411","dot_number":"574825","report_state":"TX","report_number":"V241429272","insp_date":"2024-08-21 00:00:00","insp_start_time":"1731","insp_end_time":"1744","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C101","location_desc":"IH37 SB THREE RIVERS SCALE","county_code_state":"TX","county_code":"297","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CHURCHWELL ENVIRONMENTAL","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":"2024-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125220","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":"9358978","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2024-08-23 21:41:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-23 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T20:32:47.000000Z","updated_at":"2025-03-17T20:32:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10558423,"change_date":"2024-08-23 21:41:00","inspection_id":"82471411","insp_unit_id":"202558360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"CT 1","insp_unit_license":"R688239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4KC9EH6RN639295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:21.000000Z","updated_at":"2025-03-17T23:32:21.000000Z"},{"id":10558424,"change_date":"2024-08-23 21:41:00","inspection_id":"82471411","insp_unit_id":"202558361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"5657","insp_unit_license":"241C504","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNSH3427LD175260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:21.000000Z","updated_at":"2025-03-17T23:32:21.000000Z"}]},{"id":5766141,"change_date":"2024-05-16 21:41:00","inspection_id":"81628530","dot_number":"574825","report_state":"LA","report_number":"LACK013427","insp_date":"2024-05-14 00:00:00","insp_start_time":"1601","insp_end_time":"1611","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"031","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1202752","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:05.000000Z","updated_at":"2025-03-17T20:17:05.000000Z","inspection_violations":[{"id":8925404,"change_date":"2024-05-16 21:41:00","inspection_id":"81628530","insp_violation_id":"259544721","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:11.000000Z","updated_at":"2025-03-17T21:49:11.000000Z","normalized_code":"39216A"},{"id":8925405,"change_date":"2024-05-16 21:41:00","inspection_id":"81628530","insp_violation_id":"259544722","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:11.000000Z","updated_at":"2025-03-17T21:49:11.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":9287170,"change_date":"2024-05-16 21:41:00","inspection_id":"81628530","insp_unit_id":"200928251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"361476","insp_unit_license":"K105098","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALACWFC1LDLZ4821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:27.000000Z","updated_at":"2025-03-17T23:19:27.000000Z"}]},{"id":5600908,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","dot_number":"574825","report_state":"TX","report_number":"V241348576","insp_date":"2024-04-23 00:00:00","insp_start_time":"0830","insp_end_time":"0927","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A302","location_desc":"US 59 NORTHBOUND INEZ","county_code_state":"TX","county_code":"469","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"REPUBLIC","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":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9257690","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[{"id":8660679,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153202","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39311"},{"id":8660680,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153203","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39311"},{"id":8660681,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153204","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39347E"},{"id":8660682,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153205","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39353B"},{"id":8660683,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153206","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39375A3"},{"id":8660684,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153207","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200584388","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39375A3"},{"id":8660685,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_violation_id":"259153208","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200584387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9021871,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_unit_id":"200584387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CT6","insp_unit_license":"1N23217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEDV6GSGV3850","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"},{"id":9021872,"change_date":"2024-04-25 21:43:00","inspection_id":"81448957","insp_unit_id":"200584388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR03","insp_unit_license":"128B249","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SH4821KC158189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:57.000000Z","updated_at":"2025-03-17T23:16:57.000000Z"}]},{"id":3582233,"change_date":"2023-07-24 21:42:00","inspection_id":"79226529","dot_number":"574825","report_state":"TX","report_number":"V231084943","insp_date":"2023-07-21 00:00:00","insp_start_time":"0905","insp_end_time":"0934","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 MM 59 NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCHWELL ENVIROMENTAL","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":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9035399","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T19:33:50.000000Z","updated_at":"2025-03-17T19:33:50.000000Z","inspection_violations":[{"id":5524334,"change_date":"2023-07-24 21:42:00","inspection_id":"79226529","insp_violation_id":"254248638","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196167361","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"39378"},{"id":5524335,"change_date":"2023-07-24 21:42:00","inspection_id":"79226529","insp_violation_id":"254248639","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196167362","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5760307,"change_date":"2023-07-24 21:42:00","inspection_id":"79226529","insp_unit_id":"196167361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CT8","insp_unit_license":"1M92356","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y1GM024503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:29.000000Z","updated_at":"2025-03-17T22:48:29.000000Z"},{"id":5760308,"change_date":"2023-07-24 21:42:00","inspection_id":"79226529","insp_unit_id":"196167362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"CVT02","insp_unit_license":"212C868","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4221ML153978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:29.000000Z","updated_at":"2025-03-17T22:48:29.000000Z"}]},{"id":3438488,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","dot_number":"574825","report_state":"TX","report_number":"V231037418","insp_date":"2023-07-03 00:00:00","insp_start_time":"0717","insp_end_time":"0737","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:28   16' 55.38N","county_code_state":"TX","county_code":"391","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9021474","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2023-07-05 21:42:00","snet_input_date":"2023-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T19:30:59.000000Z","updated_at":"2025-03-17T19:30:59.000000Z","inspection_violations":[{"id":5301403,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_violation_id":"253881547","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"195839622","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:38.000000Z","updated_at":"2025-03-17T21:31:38.000000Z","normalized_code":"39345"},{"id":5301404,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_violation_id":"253881548","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195839622","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:38.000000Z","updated_at":"2025-03-17T21:31:38.000000Z","normalized_code":"39345D"},{"id":5301405,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_violation_id":"253881549","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195839622","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:38.000000Z","updated_at":"2025-03-17T21:31:38.000000Z","normalized_code":"39378"},{"id":5301406,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_violation_id":"253881550","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195839621","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:38.000000Z","updated_at":"2025-03-17T21:31:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5529275,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_unit_id":"195839621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR03","insp_unit_license":"128B249","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SH4821KC158189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:38.000000Z","updated_at":"2025-03-17T22:46:38.000000Z"},{"id":5529276,"change_date":"2023-07-05 21:42:00","inspection_id":"79064820","insp_unit_id":"195839622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT03","insp_unit_license":"1L65643","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X0JD464859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:38.000000Z","updated_at":"2025-03-17T22:46:38.000000Z"}]},{"id":3171026,"change_date":"2023-06-05 21:43:00","inspection_id":"78763564","dot_number":"574825","report_state":"TX","report_number":"V231016030","insp_date":"2023-05-25 00:00:00","insp_start_time":"0705","insp_end_time":"0732","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:28   16' 55.38N","county_code_state":"TX","county_code":"391","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"51220","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":"8992188","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T19:25:44.000000Z","updated_at":"2025-03-17T19:25:44.000000Z","inspection_violations":[{"id":4887083,"change_date":"2023-06-05 21:43:00","inspection_id":"78763564","insp_violation_id":"253295847","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195326185","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39347E"},{"id":4887084,"change_date":"2023-06-05 21:43:00","inspection_id":"78763564","insp_violation_id":"253295848","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195326185","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39353B"},{"id":4887085,"change_date":"2023-06-05 21:43:00","inspection_id":"78763564","insp_violation_id":"253295849","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195326185","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:45.000000Z","updated_at":"2025-03-17T21:29:45.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":5100903,"change_date":"2023-06-05 21:43:00","inspection_id":"78763564","insp_unit_id":"195326185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CT9","insp_unit_license":"1M92357","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y3GM024504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:12.000000Z","updated_at":"2025-03-17T22:43:12.000000Z"}]},{"id":1475000,"change_date":"2022-10-10 21:35:00","inspection_id":"76829747","dot_number":"574825","report_state":"TX","report_number":"6EHA0XQYPK","insp_date":"2022-09-19 00:00:00","insp_start_time":"1008","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-10 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8794060","transaction_code":"A","transaction_date":"2022-10-10 00:00:00","upload_date":"2022-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-10-10 21:35:00","snet_input_date":"2022-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-10 21:35:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:53:49.000000Z","updated_at":"2025-03-17T18:53:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2375169,"change_date":"2022-10-10 21:35:00","inspection_id":"76829747","insp_unit_id":"191349255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"VA170","insp_unit_license":"A315412","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"1FVHG3DV5PHNW5169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:17.000000Z","updated_at":"2025-03-17T22:23:17.000000Z"}]},{"id":1207592,"change_date":"2022-09-02 21:39:00","inspection_id":"76519425","dot_number":"574825","report_state":"TX","report_number":"6DP80XQYM8","insp_date":"2022-08-22 00:00:00","insp_start_time":"0742","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"8761686","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-09-02 21:39:00","snet_input_date":"2022-08-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1942156,"change_date":"2022-09-02 21:39:00","inspection_id":"76519425","insp_unit_id":"190713164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"295","insp_unit_license":"88730X","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FVHCYFE4KHKH8237","insp_unit_decal":"Y","insp_unit_decal_number":"31588525","created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":1118946,"change_date":"2022-08-23 21:42:00","inspection_id":"76416466","dot_number":"574825","report_state":"TX","report_number":"6DKE0AGJWE","insp_date":"2022-08-17 00:00:00","insp_start_time":"1405","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN GOLIAD CO. (652-684","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HILL CORPS","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-08-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8751198","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-08-23 21:42:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:47:17.000000Z","updated_at":"2025-03-17T18:47:17.000000Z","inspection_violations":[{"id":1767702,"change_date":"2022-08-23 21:42:00","inspection_id":"76416466","insp_violation_id":"247946457","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"190503853","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39360C"},{"id":1767703,"change_date":"2022-08-23 21:42:00","inspection_id":"76416466","insp_violation_id":"247946458","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"190503854","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":1799947,"change_date":"2022-08-23 21:42:00","inspection_id":"76416466","insp_unit_id":"190503853","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT2","insp_unit_license":"1L93293","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD49X3CD164072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:21.000000Z","updated_at":"2025-03-17T22:19:21.000000Z"},{"id":1799948,"change_date":"2022-08-23 21:42:00","inspection_id":"76416466","insp_unit_id":"190503854","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"VT162","insp_unit_license":"081482A","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"1L9JB72AXCL033873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:21.000000Z","updated_at":"2025-03-17T22:19:21.000000Z"}]},{"id":1048311,"change_date":"2022-08-16 21:39:00","inspection_id":"76333679","dot_number":"574825","report_state":"TX","report_number":"6DCF0XTBIU","insp_date":"2022-08-09 00:00:00","insp_start_time":"1503","insp_end_time":"1534","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A304","location_desc":"US 59 FANNIN SOUTHBOUND","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8743858","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1651754,"change_date":"2022-08-16 21:39:00","inspection_id":"76333679","insp_violation_id":"247748899","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190337524","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3963A1"},{"id":1651755,"change_date":"2022-08-16 21:39:00","inspection_id":"76333679","insp_violation_id":"247748900","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"190337524","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":1686888,"change_date":"2022-08-16 21:39:00","inspection_id":"76333679","insp_unit_id":"190337524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CT7","insp_unit_license":"1L65143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEDV3GSGV3854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"},{"id":1686889,"change_date":"2022-08-16 21:39:00","inspection_id":"76333679","insp_unit_id":"190337525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CVT01","insp_unit_license":"163C392","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4229DL114801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":868158,"change_date":"2022-07-21 21:40:00","inspection_id":"76123253","dot_number":"574825","report_state":"TX","report_number":"6CKE0XTBHW","insp_date":"2022-07-12 00:00:00","insp_start_time":"1446","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A304","location_desc":"US 59 FANNIN SOUTHBOUND","county_code_state":"TX","county_code":"175","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8719534","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-07-21 21:40:00","snet_input_date":"2022-07-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-21 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:43:02.000000Z","updated_at":"2025-03-17T18:43:02.000000Z","inspection_violations":[{"id":1366269,"change_date":"2022-07-21 21:40:00","inspection_id":"76123253","insp_violation_id":"247240354","seq_no":"1","part_no":"390","part_no_section":"21(h)(3)","insp_viol_unit":"1","insp_unit_id":"189905192","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39021H3"}],"inspection_per_units":[{"id":1397589,"change_date":"2022-07-21 21:40:00","inspection_id":"76123253","insp_unit_id":"189905192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"293","insp_unit_license":"85349X","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"2NP3LJ9X6KM499749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:47.000000Z","updated_at":"2025-03-17T22:16:47.000000Z"}]},{"id":619587,"change_date":"2022-06-16 21:43:00","inspection_id":"75831590","dot_number":"574825","report_state":"TX","report_number":"6BK90XQYDO","insp_date":"2022-06-06 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"8681185","transaction_code":"C","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:38:30.000000Z","updated_at":"2025-03-17T18:38:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":996540,"change_date":"2022-06-16 21:43:00","inspection_id":"75831590","insp_unit_id":"189304940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2893","insp_unit_license":"93964X","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"3ALHG3DV5LDKZ0533","insp_unit_decal":"Y","insp_unit_decal_number":"31229848","created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]},{"id":618954,"change_date":"2022-06-15 21:41:00","inspection_id":"75830836","dot_number":"574825","report_state":"TX","report_number":"6B380XQYCM","insp_date":"2022-05-20 00:00:00","insp_start_time":"0808","insp_end_time":"0826","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8680418","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:38:29.000000Z","updated_at":"2025-03-17T18:38:29.000000Z","inspection_violations":[{"id":971376,"change_date":"2022-06-15 21:41:00","inspection_id":"75830836","insp_violation_id":"246488437","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189271954","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39311"},{"id":971377,"change_date":"2022-06-15 21:41:00","inspection_id":"75830836","insp_violation_id":"246488438","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189271955","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":995503,"change_date":"2022-06-15 21:41:00","inspection_id":"75830836","insp_unit_id":"189271954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L65061","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEBG9CSBS8183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:19.000000Z","updated_at":"2025-03-17T22:14:19.000000Z"},{"id":995504,"change_date":"2022-06-15 21:41:00","inspection_id":"75830836","insp_unit_id":"189271955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"C-R03","insp_unit_license":"128B249","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SH4821KC158189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:19.000000Z","updated_at":"2025-03-17T22:14:19.000000Z"}]},{"id":313051,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","dot_number":"574825","report_state":"TX","report_number":"6AI80XCNIG","insp_date":"2022-04-29 00:00:00","insp_start_time":"0815","insp_end_time":"0850","registration_date":"2022-05-17 00:00:00","region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US 77 RIVIERA","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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":null,"final_status_date":"2022-05-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8643573","transaction_code":"C","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-05-03 21:40:00","snet_input_date":"2022-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-03 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:32:58.000000Z","updated_at":"2025-03-17T18:32:58.000000Z","inspection_violations":[{"id":489366,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","insp_violation_id":"245846678","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188733014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3922"},{"id":489367,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","insp_violation_id":"245846679","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188733013","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39311"},{"id":489368,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","insp_violation_id":"245846680","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"188733014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":506708,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","insp_unit_id":"188733013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"CT-5","insp_unit_license":"1L65061","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEBG9CSBS8183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"},{"id":506709,"change_date":"2022-05-17 21:43:00","inspection_id":"75466648","insp_unit_id":"188733014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"CR01","insp_unit_license":"143099J","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SH3429GC141180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:19.000000Z","updated_at":"2025-03-17T22:11:19.000000Z"}]},{"id":292377,"change_date":"2022-05-17 21:43:00","inspection_id":"75442100","dot_number":"574825","report_state":"TX","report_number":"6AGD0XRGJ2","insp_date":"2022-04-27 00:00:00","insp_start_time":"1338","insp_end_time":"1356","registration_date":"2022-05-17 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0044 IN DUVAL CO. (476-510)","county_code_state":"TX","county_code":"131","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHURCHWELL ENV. SERVICES","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8640191","transaction_code":"C","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-04-29 21:41:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:32:36.000000Z","updated_at":"2025-03-17T18:32:36.000000Z","inspection_violations":[{"id":456631,"change_date":"2022-05-17 21:43:00","inspection_id":"75442100","insp_violation_id":"245846265","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188732807","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3939A"},{"id":456632,"change_date":"2022-05-17 21:43:00","inspection_id":"75442100","insp_violation_id":"245846266","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"188732807","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":473295,"change_date":"2022-05-17 21:43:00","inspection_id":"75442100","insp_unit_id":"188732807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"CT-2","insp_unit_license":"1L93293","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD49X3CD164072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:06.000000Z","updated_at":"2025-03-17T22:11:06.000000Z"}]},{"id":167592,"change_date":"2022-04-13 21:40:00","inspection_id":"75292897","dot_number":"574825","report_state":"TX","report_number":"69U60XQY8M","insp_date":"2022-04-05 00:00:00","insp_start_time":"0622","insp_end_time":"0704","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C106","location_desc":"US 77 NORTHBOUND\/SOUTHBOUND RE","county_code_state":"TX","county_code":"391","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8619236","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00574825","upload_search_indicator":"M","census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"BRANDT HHL ENTERPRISES INC","insp_carrier_street":"3315 HWY 44","insp_carrier_city":"ROBSTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"78380","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0133712","created_at":"2025-03-17T18:30:29.000000Z","updated_at":"2025-03-17T18:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":271570,"change_date":"2022-04-13 21:40:00","inspection_id":"75292897","insp_unit_id":"188135712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GC165","insp_unit_license":"A455818","insp_unit_license_state":"MS","insp_unit_vehicle_id_number":"1FVHG3DV5EHFN7136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:50.000000Z","updated_at":"2025-03-17T22:09:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/574825\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/574825\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/574825\/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\/574825\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}