{"current_page":1,"data":[{"id":12261574,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","dot_number":"2448037","report_state":"TX","report_number":"V262439586","insp_date":"2026-06-22 00:00:00","insp_start_time":"1115","insp_end_time":"1152","registration_date":null,"region":"CT","ci_status_code":"C","location":"TX302","location_desc":"TX302 MENTONE SCALE","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10004336","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":"02448037","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2026-06-26T09:40:59.000000Z","updated_at":"2026-07-04T09:31:13.000000Z","inspection_violations":[{"id":21343134,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_violation_id":"275084800","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"214247255","insp_violation_category_id":"20","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:07.000000Z","normalized_code":"39319"},{"id":21343135,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_violation_id":"275084801","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"214247255","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-26T10:01:46.000000Z","updated_at":"2026-07-04T09:44:07.000000Z","normalized_code":"3939TS"},{"id":21343136,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_violation_id":"275084802","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"214247254","insp_violation_category_id":"30","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:07.000000Z","normalized_code":"3963A1"},{"id":21343137,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_violation_id":"275084803","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:46.000000Z","updated_at":"2026-07-04T09:44:07.000000Z","normalized_code":"3922W"},{"id":21343138,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_violation_id":"275084804","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-26T10:01:46.000000Z","updated_at":"2026-07-04T09:44:07.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":21292404,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_unit_id":"214247255","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"T-4","insp_unit_license":"162B022","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA43294N036732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:31.000000Z","updated_at":"2026-07-04T09:04:47.000000Z"},{"id":21292403,"change_date":"2026-06-23 21:39:00","inspection_id":"88220448","insp_unit_id":"214247254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"589873","insp_unit_license":"R823677","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDV6PDNS5210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:31.000000Z","updated_at":"2026-07-04T09:04:47.000000Z"}]},{"id":11966936,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","dot_number":"2448037","report_state":"TX","report_number":"7FI89DVB2O","insp_date":"2026-05-14 00:00:00","insp_start_time":"0851","insp_end_time":"0914","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0349 IN MARTIN CO. (290-322","county_code_state":"TX","county_code":"317","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9960290","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2026-05-19 21:41:00","snet_input_date":"2026-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2026-05-22T09:41:18.000000Z","updated_at":"2026-05-30T09:31:23.000000Z","inspection_violations":[{"id":20816451,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_violation_id":"274376842","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"213652526","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:50.000000Z","updated_at":"2026-05-30T09:42:18.000000Z","normalized_code":"3963A1"},{"id":20816450,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_violation_id":"274376841","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213652526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:50.000000Z","updated_at":"2026-05-30T09:42:18.000000Z","normalized_code":"3939"},{"id":20816452,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_violation_id":"274376843","seq_no":"3","part_no":"393","part_no_section":"13C3","insp_viol_unit":"2","insp_unit_id":"213652527","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:50.000000Z","updated_at":"2026-05-30T09:42:18.000000Z","normalized_code":"39313C3"},{"id":20816453,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_violation_id":"274376844","seq_no":"4","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"213652526","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:50.000000Z","updated_at":"2026-05-30T09:42:18.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":20806660,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_unit_id":"213652526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R642822","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDV1PDNS5213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-22T09:21:58.000000Z","updated_at":"2026-05-30T09:03:55.000000Z"},{"id":20806661,"change_date":"2026-05-19 21:41:00","inspection_id":"87903447","insp_unit_id":"213652527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"083C687","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H4T04321ML008001","insp_unit_decal":"Y","insp_unit_decal_number":"36287501","created_at":"2026-05-22T09:21:59.000000Z","updated_at":"2026-05-30T09:03:55.000000Z"}]},{"id":9324084,"change_date":"2025-08-04 21:39:00","inspection_id":"85399763","dot_number":"2448037","report_state":"TX","report_number":"77J99DJK86","insp_date":"2025-07-31 00:00:00","insp_start_time":"0903","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0349 IN MIDLAND CO. (324-35","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9654818","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-08-07T10:44:53.000000Z","updated_at":"2025-08-08T10:00:49.000000Z","inspection_violations":[{"id":15130909,"change_date":"2025-08-04 21:39:00","inspection_id":"85399763","insp_violation_id":"267828131","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"208227646","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-07T10:45:41.000000Z","updated_at":"2025-08-08T10:44:04.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":15355547,"change_date":"2025-08-04 21:39:00","inspection_id":"85399763","insp_unit_id":"208227645","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3133624","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV6NSMS9005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:32.000000Z","updated_at":"2025-08-08T09:45:59.000000Z"},{"id":15355548,"change_date":"2025-08-04 21:39:00","inspection_id":"85399763","insp_unit_id":"208227646","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WLKR","insp_unit_company":null,"insp_unit_license":"240C798","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA432XCN042862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:32.000000Z","updated_at":"2025-08-08T09:45:59.000000Z"}]},{"id":9053004,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","dot_number":"2448037","report_state":"TX","report_number":"V251918384","insp_date":"2025-06-26 00:00:00","insp_start_time":"1335","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR 300 EAST MENTONE","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WATER SPECIALTIES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"9623994","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-06-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-07-07T10:07:25.000000Z","updated_at":"2025-07-07T10:07:25.000000Z","inspection_violations":[{"id":14565303,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_violation_id":"267180628","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"207682739","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:47.000000Z","updated_at":"2025-07-06T10:17:57.000000Z","normalized_code":"39021A"},{"id":14565304,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_violation_id":"267180629","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207682739","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:47.000000Z","updated_at":"2025-07-06T10:17:57.000000Z","normalized_code":"39360C"},{"id":14565305,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_violation_id":"267180630","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"207682740","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:47.000000Z","updated_at":"2025-07-06T10:17:57.000000Z","normalized_code":"3922W"},{"id":14565306,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_violation_id":"267180631","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"207682739","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:47.000000Z","updated_at":"2025-07-06T10:17:57.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":14852768,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_unit_id":"207682739","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"472833","insp_unit_license":"R734568","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EH7SN670168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:03.000000Z"},{"id":14852769,"change_date":"2025-07-02 21:40:00","inspection_id":"85114500","insp_unit_id":"207682740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"T-11","insp_unit_license":"241B120","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA4321CN042863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:03.000000Z"}]},{"id":8974268,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","dot_number":"2448037","report_state":"TX","report_number":"V251922940","insp_date":"2025-06-21 00:00:00","insp_start_time":"0849","insp_end_time":"0911","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"220 E SH302","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WATER","shipping_paper_number":"29788","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-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9616299","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-06-24 21:41:00","snet_input_date":"2025-06-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-24 21:41:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-06-28T10:00:55.000000Z","updated_at":"2025-06-28T10:00:55.000000Z","inspection_violations":[{"id":14422086,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","insp_violation_id":"267019666","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"207533227","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:29.000000Z","updated_at":"2025-06-28T10:17:57.000000Z","normalized_code":"39021A"},{"id":14422087,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","insp_violation_id":"267019667","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"207533228","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-27T10:17:29.000000Z","updated_at":"2025-06-28T10:17:57.000000Z","normalized_code":"39345"},{"id":14422088,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","insp_violation_id":"267019668","seq_no":"3","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"207533228","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:29.000000Z","updated_at":"2025-06-28T10:17:57.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":14713705,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","insp_unit_id":"207533227","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"091","insp_unit_license":"R606682","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR4PN210613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:39.000000Z","updated_at":"2025-06-28T09:46:00.000000Z"},{"id":14713706,"change_date":"2025-06-24 21:41:00","inspection_id":"85031774","insp_unit_id":"207533228","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"T11","insp_unit_license":"241B120","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA4321CN042863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:39.000000Z","updated_at":"2025-06-28T09:46:00.000000Z"}]},{"id":8806817,"change_date":"2025-06-04 21:41:00","inspection_id":"84853917","dot_number":"2448037","report_state":"TX","report_number":"75MF9DPXP9","insp_date":"2025-05-23 00:00:00","insp_start_time":"1538","insp_end_time":"1606","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5800  BRIARWOOD AVE","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TARGA","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-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9597625","transaction_code":"C","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-06-06T10:01:07.000000Z","updated_at":"2025-06-09T10:00:20.000000Z","inspection_violations":[{"id":14102612,"change_date":"2025-06-04 21:41:00","inspection_id":"84853917","insp_violation_id":"266664666","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"207226732","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:16:47.000000Z","updated_at":"2025-06-08T10:17:13.000000Z","normalized_code":"39311TL"},{"id":14102613,"change_date":"2025-06-04 21:41:00","inspection_id":"84853917","insp_violation_id":"266664667","seq_no":"3","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":"2025-06-07T10:16:47.000000Z","updated_at":"2025-06-08T10:17:13.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14425717,"change_date":"2025-06-04 21:41:00","inspection_id":"84853917","insp_unit_id":"207226732","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"252376","insp_unit_license":"R665066","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHLDV8RDUN2120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:13.000000Z","updated_at":"2025-06-08T09:45:27.000000Z"},{"id":14425718,"change_date":"2025-06-04 21:41:00","inspection_id":"84853917","insp_unit_id":"207226733","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"T-7","insp_unit_license":"147B424","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"10BAB6238GF0D4361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:13.000000Z","updated_at":"2025-06-08T09:45:27.000000Z"}]},{"id":8648841,"change_date":"2025-05-15 21:44:00","inspection_id":"84686840","dot_number":"2448037","report_state":"TX","report_number":"75C89DNZ9G","insp_date":"2025-05-13 00:00:00","insp_start_time":"0730","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"4A106","location_desc":"IH20 EB ODESSA SCALE","county_code_state":"TX","county_code":"135","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ACE WATER SPECIALTIES","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-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9578626","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-05-15 21:44:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-15 21:44:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-05-18T10:04:40.000000Z","updated_at":"2025-05-19T10:06:36.000000Z","inspection_violations":[{"id":13761361,"change_date":"2025-05-15 21:44:00","inspection_id":"84686840","insp_violation_id":"266260199","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206889814","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:17.000000Z","updated_at":"2025-05-19T10:32:54.000000Z","normalized_code":"3963A1"},{"id":13761362,"change_date":"2025-05-15 21:44:00","inspection_id":"84686840","insp_violation_id":"266260200","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206889814","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-18T10:32:17.000000Z","updated_at":"2025-05-19T10:32:54.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":14125033,"change_date":"2025-05-15 21:44:00","inspection_id":"84686840","insp_unit_id":"206889814","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"804","insp_unit_license":"1N68863","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEBG9GSHN4305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:26.000000Z","updated_at":"2025-05-19T09:52:35.000000Z"},{"id":14125034,"change_date":"2025-05-15 21:44:00","inspection_id":"84686840","insp_unit_id":"206889815","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"T-9","insp_unit_license":"223C360","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA432XHN049429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:26.000000Z","updated_at":"2025-05-19T09:52:35.000000Z"}]},{"id":7853918,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","dot_number":"2448037","report_state":"TX","report_number":"72O99DPXM7","insp_date":"2025-02-06 00:00:00","insp_start_time":"0901","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0349 IN MIDLAND CO. (324-35","county_code_state":"TX","county_code":"329","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WESTERN","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"15","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9496144","transaction_code":"C","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2025-02-12 21:39:00","snet_input_date":"2025-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-12 21:39:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-03-17T21:01:12.000000Z","updated_at":"2025-03-17T21:01:12.000000Z","inspection_violations":[{"id":12274545,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511708","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3922W"},{"id":12274546,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511709","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39378"},{"id":12274547,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511710","seq_no":"3","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39355D2"},{"id":12274548,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511711","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3939TS"},{"id":12274549,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511712","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3939"},{"id":12274550,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511713","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3939"},{"id":12274551,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511714","seq_no":"7","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39345B2PC"},{"id":12274552,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511715","seq_no":"8","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"393203C"},{"id":12274553,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511716","seq_no":"9","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39311TL"},{"id":12274554,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511717","seq_no":"10","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3963A1B"},{"id":12274555,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511718","seq_no":"11","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3963A1B"},{"id":12274556,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511719","seq_no":"12","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39347B"},{"id":12274557,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511720","seq_no":"13","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39347E"},{"id":12274558,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511721","seq_no":"14","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"39353B"},{"id":12274559,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_violation_id":"264511722","seq_no":"15","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"205318104","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:53.000000Z","updated_at":"2025-03-17T22:05:53.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12675860,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_unit_id":"205318104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"808","insp_unit_license":"1N42639","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEDV2ESFS7658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:02.000000Z","updated_at":"2025-03-17T23:55:02.000000Z"},{"id":12675861,"change_date":"2025-02-13 21:40:00","inspection_id":"83850622","insp_unit_id":"205318105","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"WLKR","insp_unit_company":"T-11","insp_unit_license":"241B120","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA4321CN042863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:02.000000Z","updated_at":"2025-03-17T23:55:02.000000Z"}]},{"id":7073707,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","dot_number":"2448037","report_state":"TX","report_number":"6ZRA9DPXJ9","insp_date":"2024-10-24 00:00:00","insp_start_time":"1012","insp_end_time":"1026","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0349 IN MIDLAND CO. (324-35","county_code_state":"TX","county_code":"329","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENLINK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9413510","transaction_code":"C","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11042633,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_violation_id":"262668582","seq_no":"1","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"203685151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39355D2"},{"id":11042634,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_violation_id":"262668583","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"203685151","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39360C"},{"id":11042635,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_violation_id":"262668584","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"203685151","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39311TL"},{"id":11042636,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_violation_id":"262668585","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203685151","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"},{"id":11042637,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_violation_id":"262668586","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"203685152","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11408189,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_unit_id":"203685151","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"807","insp_unit_license":"1N68810","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEBG3HSHW0196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"},{"id":11408190,"change_date":"2024-10-31 21:42:00","inspection_id":"83029020","insp_unit_id":"203685152","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"WLKR","insp_unit_company":"T-6","insp_unit_license":"241C006","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5WSAA43205N037656","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":3423287,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","dot_number":"2448037","report_state":"TX","report_number":"V231040847","insp_date":"2023-06-21 00:00:00","insp_start_time":"1451","insp_end_time":"1536","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH158","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WATER SPECIALTIES","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-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9019870","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-06-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-03-17T19:30:54.000000Z","updated_at":"2025-03-17T19:30:54.000000Z","inspection_violations":[{"id":5278448,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_violation_id":"253844538","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"195804730","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"393100A"},{"id":5278449,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_violation_id":"253844539","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195804729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39311"},{"id":5278450,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_violation_id":"253844540","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"195804729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39355D3"},{"id":5278451,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_violation_id":"253844541","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195804729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5503839,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_unit_id":"195804729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"807","insp_unit_license":"1N11543","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGED67ELFV2897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"},{"id":5503840,"change_date":"2023-07-03 21:38:00","inspection_id":"79047853","insp_unit_id":"195804730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"T7","insp_unit_license":"147B424","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"10BAB6238GF0D4361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:25.000000Z","updated_at":"2025-03-17T22:46:25.000000Z"}]},{"id":485121,"change_date":"2022-05-25 21:42:00","inspection_id":"75671588","dot_number":"2448037","report_state":"TX","report_number":"6B2A0AHVDP","insp_date":"2022-05-19 00:00:00","insp_start_time":"0955","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0349 IN MARTIN CO. (290-322","county_code_state":"TX","county_code":"317","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACE WATER SPECIALTIES","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"106000","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":"8666392","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-03-17T18:36:18.000000Z","updated_at":"2025-03-17T18:36:18.000000Z","inspection_violations":[{"id":769504,"change_date":"2022-05-25 21:42:00","inspection_id":"75671588","insp_violation_id":"246082835","seq_no":"1","part_no":"393","part_no_section":"70","insp_viol_unit":"2","insp_unit_id":"188918620","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39370"}],"inspection_per_units":[{"id":780218,"change_date":"2022-05-25 21:42:00","inspection_id":"75671588","insp_unit_id":"188918619","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"802","insp_unit_license":"1M96406","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEDR1CSBS3915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"},{"id":780219,"change_date":"2022-05-25 21:42:00","inspection_id":"75671588","insp_unit_id":"188918620","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"T-1","insp_unit_license":"083C687","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1H4T04321ML008001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"}]},{"id":259325,"change_date":"2022-04-26 21:42:00","inspection_id":"75402688","dot_number":"2448037","report_state":"TX","report_number":"6AA79DPX65","insp_date":"2022-04-21 00:00:00","insp_start_time":"0749","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0250 IN MIDLAND CO. (274-28","county_code_state":"TX","county_code":"329","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LUCID ROADRUNNER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8634706","transaction_code":"A","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02448037","upload_search_indicator":"M","census_search_date":"2022-04-26 21:42:00","snet_input_date":"2022-04-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"ACE WATER SPECIALTIES LLC","insp_carrier_street":"3011 TODD DR","insp_carrier_city":"MIDLAND","insp_carrier_state":"TX","insp_carrier_zip_code":"79705","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0902903","created_at":"2025-03-17T18:31:56.000000Z","updated_at":"2025-03-17T18:31:56.000000Z","inspection_violations":[{"id":399569,"change_date":"2022-04-26 21:42:00","inspection_id":"75402688","insp_violation_id":"245389969","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188354591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"39311"},{"id":399570,"change_date":"2022-04-26 21:42:00","inspection_id":"75402688","insp_violation_id":"245389970","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188354592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:55.000000Z","updated_at":"2025-03-17T21:08:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":420026,"change_date":"2022-04-26 21:42:00","inspection_id":"75402688","insp_unit_id":"188354591","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"801","insp_unit_license":"1M90959","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEDV5DSFA7870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"},{"id":420027,"change_date":"2022-04-26 21:42:00","inspection_id":"75402688","insp_unit_id":"188354592","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"162B252","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"10BAB62W16F0B6521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2448037\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2448037\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2448037\/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\/2448037\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}