{"current_page":1,"data":[{"id":12228434,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","dot_number":"1973213","report_state":"TX","report_number":"V262420777","insp_date":"2026-06-16 00:00:00","insp_start_time":"0920","insp_end_time":"1029","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 285 MP 366","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER & ENERGY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"Y","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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"15","oos_total":"5","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"3","hazmat_oos_total":"2","snet_sequence_id":"9998970","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2026-06-21T09:43:48.000000Z","updated_at":"2026-06-29T09:31:51.000000Z","inspection_violations":[{"id":21283744,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006671","seq_no":"1","part_no":"107","part_no_section":"601","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"107601"},{"id":21283745,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006672","seq_no":"2","part_no":"107","part_no_section":"620B","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"107620B"},{"id":21283746,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006673","seq_no":"3","part_no":"172","part_no_section":"602C1","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"172602C1"},{"id":21283747,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006674","seq_no":"4","part_no":"177","part_no_section":"817A","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"177817A"},{"id":21283748,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006675","seq_no":"5","part_no":"177","part_no_section":"823A","insp_viol_unit":"2","insp_unit_id":"214183966","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"177823A"},{"id":21283749,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006676","seq_no":"6","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-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"38323A2"},{"id":21283750,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006677","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39021A"},{"id":21283751,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006678","seq_no":"8","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-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39141APC"},{"id":21283752,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006679","seq_no":"9","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"214183966","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39343D"},{"id":21283753,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006680","seq_no":"10","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39360D"},{"id":21283754,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006681","seq_no":"11","part_no":"393","part_no_section":"95A1I","insp_viol_unit":"2","insp_unit_id":"214183966","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39395A1I"},{"id":21283755,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006682","seq_no":"12","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39395F"},{"id":21283756,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006683","seq_no":"13","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39617C"},{"id":21283757,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006684","seq_no":"14","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"214183966","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"39617C"},{"id":21283758,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_violation_id":"275006685","seq_no":"15","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214183965","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:05:30.000000Z","updated_at":"2026-06-29T09:44:06.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21236702,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_unit_id":"214183965","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"PU019","insp_unit_license":"VSY0040","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3BA3RED15349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:42.000000Z","updated_at":"2026-06-29T09:02:57.000000Z"},{"id":21236703,"change_date":"2026-06-18 21:42:00","inspection_id":"88186563","insp_unit_id":"214183966","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"532830M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4A9GF2622PM084829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:42.000000Z","updated_at":"2026-06-29T09:02:57.000000Z"}]},{"id":12236771,"change_date":"2026-06-22 21:40:00","inspection_id":"88194517","dot_number":"1973213","report_state":"TX","report_number":"V262417723","insp_date":"2026-06-12 00:00:00","insp_start_time":"0710","insp_end_time":"0755","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":"AQUA TRANSFER & ENERGY SERVIC","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":"2026-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"170251","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9999808","transaction_code":"C","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2026-06-22T09:41:32.000000Z","updated_at":"2026-07-03T09:30:14.000000Z","inspection_violations":[{"id":21297367,"change_date":"2026-06-22 21:40:00","inspection_id":"88194517","insp_violation_id":"275060628","seq_no":"1","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-22T10:03:15.000000Z","updated_at":"2026-07-03T09:43:54.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":21250790,"change_date":"2026-06-22 21:40:00","inspection_id":"88194517","insp_unit_id":"214228594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"HT010","insp_unit_license":"R736771","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX5JD476034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:52.000000Z","updated_at":"2026-07-05T09:00:57.000000Z"},{"id":21250791,"change_date":"2026-06-22 21:40:00","inspection_id":"88194517","insp_unit_id":"214228595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"002","insp_unit_license":"198B338","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL59456M1031957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:52.000000Z","updated_at":"2026-07-05T09:00:57.000000Z"}]},{"id":11345204,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","dot_number":"1973213","report_state":"TX","report_number":"7DK99DLBEA","insp_date":"2026-03-05 00:00:00","insp_start_time":"0930","insp_end_time":"1005","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":"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-03-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9879113","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2026-03-11 21:38:00","snet_input_date":"2026-03-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-11 21:38:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2026-03-14T09:38:18.000000Z","updated_at":"2026-03-22T09:32:27.000000Z","inspection_violations":[{"id":19105788,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338985","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:12.000000Z","normalized_code":"39311TL"},{"id":19105789,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338986","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:12.000000Z","normalized_code":"3963A1"},{"id":19105790,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338987","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:12.000000Z","normalized_code":"39395A"},{"id":19105791,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338988","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:12.000000Z","normalized_code":"39347E"},{"id":19105792,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338989","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:13.000000Z","normalized_code":"39347E"},{"id":19105793,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338990","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:13.000000Z","normalized_code":"39347E"},{"id":19105794,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338991","seq_no":"9","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:13.000000Z","normalized_code":"39353B"},{"id":19105795,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338992","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:13.000000Z","normalized_code":"39347E"},{"id":19105796,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338993","seq_no":"11","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:13.000000Z","normalized_code":"3963A1BOS"},{"id":19105797,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338994","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:14.000000Z","normalized_code":"3922RG"},{"id":19105798,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_violation_id":"272338995","seq_no":"2","part_no":"393","part_no_section":"11UR","insp_viol_unit":"1","insp_unit_id":"212085949","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:23.000000Z","updated_at":"2026-03-22T09:53:14.000000Z","normalized_code":"39311UR"}],"inspection_per_units":[{"id":19414995,"change_date":"2026-03-11 21:38:00","inspection_id":"87263077","insp_unit_id":"212085949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R396776","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DBEX57D688770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:56.000000Z","updated_at":"2026-03-22T09:11:16.000000Z"}]},{"id":11240617,"change_date":"2026-02-26 21:41:00","inspection_id":"87153308","dot_number":"1973213","report_state":"TX","report_number":"V262225262","insp_date":"2026-02-24 00:00:00","insp_start_time":"0834","insp_end_time":"0849","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-20 MILE MARKER 40","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER & ENERGY","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-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"81000","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":"9864078","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2026-02-26 21:41:00","snet_input_date":"2026-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-26 21:41:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2026-03-01T10:39:06.000000Z","updated_at":"2026-03-09T09:32:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19215387,"change_date":"2026-02-26 21:41:00","inspection_id":"87153308","insp_unit_id":"211861897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"8V003","insp_unit_license":"K189713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPXX4TX9RD678819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:47.000000Z","updated_at":"2026-03-09T09:10:03.000000Z"}]},{"id":10793852,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","dot_number":"1973213","report_state":"TX","report_number":"V262179187","insp_date":"2026-01-15 00:00:00","insp_start_time":"0437","insp_end_time":"0521","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US HWY 285 AND B ST","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER & ENERGY SERVIC","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"11","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9821185","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2026-01-16 21:40:00","snet_input_date":"2026-01-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-16 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2026-01-19T10:37:00.000000Z","updated_at":"2026-01-27T10:30:59.000000Z","inspection_violations":[{"id":18037261,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263950","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-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:41.000000Z","normalized_code":"38323A2"},{"id":18037268,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263957","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"3939"},{"id":18037269,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263958","seq_no":"9","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"211141410","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"39395F"},{"id":18037270,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263959","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"39617C"},{"id":18037271,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263960","seq_no":"11","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211141410","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"39617C"},{"id":18037262,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263951","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"211141410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:41.000000Z","normalized_code":"39021A"},{"id":18037263,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263952","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":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:41.000000Z","normalized_code":"39141APC"},{"id":18037264,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263953","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:41.000000Z","normalized_code":"39311"},{"id":18037265,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263954","seq_no":"5","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"39343D"},{"id":18037266,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263955","seq_no":"6","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"39375A3"},{"id":18037267,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_violation_id":"271263956","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211141411","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:42.000000Z","updated_at":"2026-01-27T10:31:42.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18122239,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_unit_id":"211141410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"CT004","insp_unit_license":"WFP7577","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL1NG141950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:30.000000Z","updated_at":"2026-01-27T10:01:06.000000Z"},{"id":18122240,"change_date":"2026-01-16 21:40:00","inspection_id":"86820090","insp_unit_id":"211141411","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"767048M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4A9BU2023RM084866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:30.000000Z","updated_at":"2026-01-27T10:01:06.000000Z"}]},{"id":9425592,"change_date":"2025-08-18 21:39:00","inspection_id":"85506404","dot_number":"1973213","report_state":"TX","report_number":"V251921656","insp_date":"2025-08-13 00:00:00","insp_start_time":"1039","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US62 EB","county_code_state":"TX","county_code":"219","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"93725","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":"9666941","transaction_code":"C","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-08-20T10:44:41.000000Z","updated_at":"2025-08-23T10:45:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15556431,"change_date":"2025-08-18 21:39:00","inspection_id":"85506404","insp_unit_id":"208453042","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"HT010","insp_unit_license":"R736771","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX5JD476034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:33.000000Z","updated_at":"2025-08-22T09:45:34.000000Z"},{"id":15556432,"change_date":"2025-08-18 21:39:00","inspection_id":"85506404","insp_unit_id":"208453043","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"002","insp_unit_license":"198B338","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL59456M1031957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:33.000000Z","updated_at":"2025-08-22T09:45:34.000000Z"}]},{"id":9380970,"change_date":"2025-08-11 21:38:00","inspection_id":"85459455","dot_number":"1973213","report_state":"TX","report_number":"V251952865","insp_date":"2025-08-05 00:00:00","insp_start_time":"1426","insp_end_time":"1508","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":"P & M FRESH WATER STATION","shipping_paper_number":"204533","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-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9661736","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-08-14T10:42:29.000000Z","updated_at":"2025-08-15T10:43:16.000000Z","inspection_violations":[{"id":15244567,"change_date":"2025-08-11 21:38:00","inspection_id":"85459455","insp_violation_id":"267955033","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":"2025-08-14T10:43:17.000000Z","updated_at":"2025-08-15T10:44:57.000000Z","normalized_code":"38323A2"},{"id":15244568,"change_date":"2025-08-11 21:38:00","inspection_id":"85459455","insp_violation_id":"267955034","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208336260","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:17.000000Z","updated_at":"2025-08-15T10:44:57.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15456686,"change_date":"2025-08-11 21:38:00","inspection_id":"85459455","insp_unit_id":"208336260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"HT012","insp_unit_license":"R777713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1PN4GY1TM018796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:35.000000Z","updated_at":"2025-08-15T09:45:54.000000Z"},{"id":15456687,"change_date":"2025-08-11 21:38:00","inspection_id":"85459455","insp_unit_id":"208336261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TROX","insp_unit_company":"VT002","insp_unit_license":"233C944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T9TA4327E1867308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:35.000000Z","updated_at":"2025-08-15T09:45:54.000000Z"}]},{"id":9336573,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","dot_number":"1973213","report_state":"TX","report_number":"77K99DKA0M","insp_date":"2025-08-01 00:00:00","insp_start_time":"0931","insp_end_time":"1027","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0820 IN TARRANT CO. (0-34)","county_code_state":"TX","county_code":"439","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9656728","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2025-08-05 21:39:00","snet_input_date":"2025-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-05 21:39:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-08-08T10:01:24.000000Z","updated_at":"2025-08-12T10:42:04.000000Z","inspection_violations":[{"id":15154786,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854380","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"208251516","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"39617C"},{"id":15154787,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854381","seq_no":"2","part_no":"393","part_no_section":"11UR","insp_viol_unit":"2","insp_unit_id":"208251516","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"39311UR"},{"id":15154788,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854382","seq_no":"3","part_no":"393","part_no_section":"11LR","insp_viol_unit":"1","insp_unit_id":"208251515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"39311LR"},{"id":15154789,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854383","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"208251515","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"3963A1"},{"id":15154790,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854384","seq_no":"6","part_no":"395","part_no_section":"8F01","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"3958F01"},{"id":15154791,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854385","seq_no":"7","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"208251516","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"39343D"},{"id":15154792,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_violation_id":"267854386","seq_no":"4","part_no":"393","part_no_section":"11S","insp_viol_unit":"1","insp_unit_id":"208251515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:59.000000Z","updated_at":"2025-08-09T10:44:50.000000Z","normalized_code":"39311S"}],"inspection_per_units":[{"id":15377861,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_unit_id":"208251515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PJD9055","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT2MED05807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:36.000000Z","updated_at":"2025-08-09T09:46:06.000000Z"},{"id":15377862,"change_date":"2025-08-05 21:39:00","inspection_id":"85412730","insp_unit_id":"208251516","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"231491H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P5FD3228E1200680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:36.000000Z","updated_at":"2025-08-09T09:46:06.000000Z"}]},{"id":9052639,"change_date":"2025-07-02 21:40:00","inspection_id":"85114094","dot_number":"1973213","report_state":"TX","report_number":"V251914093","insp_date":"2025-06-30 00:00:00","insp_start_time":"0922","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-302 MILE MAREKR 1","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WESTERN MIDSTREAM","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":"213320","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":"9624106","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":"01973213","upload_search_indicator":"M","census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-06-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-07-07T10:07:24.000000Z","updated_at":"2025-07-07T10:07:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14852075,"change_date":"2025-07-02 21:40:00","inspection_id":"85114094","insp_unit_id":"207681830","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R690069","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX6LD666492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:01.000000Z"},{"id":14852076,"change_date":"2025-07-02 21:40:00","inspection_id":"85114094","insp_unit_id":"207681831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"LB003","insp_unit_license":"226B778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL5845XP1033886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:01.000000Z"}]},{"id":9053438,"change_date":"2025-07-02 21:40:00","inspection_id":"85114960","dot_number":"1973213","report_state":"TX","report_number":"V251931678","insp_date":"2025-06-27 00:00:00","insp_start_time":"0746","insp_end_time":"0835","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACKNEY LADISH 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-07-02 21:40: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":"9624441","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":"01973213","upload_search_indicator":"M","census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-07-07T10:07:25.000000Z","updated_at":"2025-07-07T10:07:25.000000Z","inspection_violations":[{"id":14566602,"change_date":"2025-07-02 21:40:00","inspection_id":"85114960","insp_violation_id":"267182620","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"207683763","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:48.000000Z","updated_at":"2025-07-06T10:18:03.000000Z","normalized_code":"39021A"},{"id":14566603,"change_date":"2025-07-02 21:40:00","inspection_id":"85114960","insp_violation_id":"267182621","seq_no":"2","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"207683763","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:48.000000Z","updated_at":"2025-07-06T10:18:03.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":14853542,"change_date":"2025-07-02 21:40:00","inspection_id":"85114960","insp_unit_id":"207683763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R690240","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X5LD704913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:06.000000Z"},{"id":14853543,"change_date":"2025-07-02 21:40:00","inspection_id":"85114960","insp_unit_id":"207683764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DURA","insp_unit_company":null,"insp_unit_license":"244C915","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3F8KF5320S1008609","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:12.000000Z","updated_at":"2025-07-06T09:46:06.000000Z"}]},{"id":8371779,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","dot_number":"1973213","report_state":"TX","report_number":"V251817865","insp_date":"2025-04-10 00:00:00","insp_start_time":"0815","insp_end_time":"0949","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A301","location_desc":"IH45 SB CENTERVILLE SCALE","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"11","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9550107","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-04-17T10:05:41.000000Z","updated_at":"2025-04-18T10:23:47.000000Z","inspection_violations":[{"id":13194674,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613267","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":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"38323A2"},{"id":13194675,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613268","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39021A"},{"id":13194676,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613269","seq_no":"4","part_no":"392","part_no_section":"71A","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39271A"},{"id":13194677,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613270","seq_no":"5","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"206305080","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39343D"},{"id":13194678,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613271","seq_no":"6","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39360D"},{"id":13194679,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613272","seq_no":"7","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39375GLOAD"},{"id":13194680,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613273","seq_no":"8","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39375GLOAD"},{"id":13194681,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613274","seq_no":"9","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39395F"},{"id":13194682,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613275","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"206305080","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"39617C"},{"id":13194683,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613276","seq_no":"11","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"206305079","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"3922W"},{"id":13194684,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_violation_id":"265613277","seq_no":"14","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":"2025-04-17T10:29:23.000000Z","updated_at":"2025-04-18T10:47:30.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":13586728,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_unit_id":"206305079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"KTZ9609","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BTXJEC18452","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:58:07.000000Z","updated_at":"2025-04-18T10:03:56.000000Z"},{"id":13586729,"change_date":"2025-04-14 21:41:00","inspection_id":"84395167","insp_unit_id":"206305080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"546597H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9GU3325DE102560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:58:07.000000Z","updated_at":"2025-04-18T10:03:56.000000Z"}]},{"id":8230626,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","dot_number":"1973213","report_state":"TX","report_number":"V251819311","insp_date":"2025-03-19 00:00:00","insp_start_time":"0700","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4205 TX36","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER & ENERGY SERVIC","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"10","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9534801","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-30T10:38:50.000000Z","updated_at":"2025-03-31T10:31:29.000000Z","inspection_violations":[{"id":12918399,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300361","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206031967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"3939"},{"id":12918400,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300362","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206031966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"3939"},{"id":12918401,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300363","seq_no":"9","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206031966","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"39617C"},{"id":12918402,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300364","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"206031967","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"39617C"},{"id":12918393,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300355","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"1","insp_unit_id":"206031966","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"38323A2"},{"id":12918394,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300356","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206031966","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"39021A"},{"id":12918395,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300357","seq_no":"3","part_no":"391","part_no_section":"41A","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-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"39141A"},{"id":12918396,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300358","seq_no":"4","part_no":"392","part_no_section":"9A","insp_viol_unit":"1","insp_unit_id":"206031966","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"3929A"},{"id":12918397,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300359","seq_no":"5","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"206031967","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"39343D"},{"id":12918398,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_violation_id":"265300360","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206031967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:56:46.000000Z","updated_at":"2025-03-31T10:59:51.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13314679,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_unit_id":"206031967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"767048M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4A9BU2023RM084866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:29:43.000000Z","updated_at":"2025-03-31T10:10:41.000000Z"},{"id":13314678,"change_date":"2025-03-27 21:42:00","inspection_id":"84246448","insp_unit_id":"206031966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"VGZ6701","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DA7REE68958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:29:43.000000Z","updated_at":"2025-03-31T10:10:41.000000Z"}]},{"id":7475273,"change_date":"2024-12-20 21:40:00","inspection_id":"83452807","dot_number":"1973213","report_state":"TX","report_number":"V241732639","insp_date":"2024-12-17 00:00:00","insp_start_time":"1557","insp_end_time":"1708","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-302 MILE MARKER 1","county_code_state":"TX","county_code":"301","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WESTERN MIDSTREAM","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":"2024-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"208320","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9458365","transaction_code":"A","transaction_date":"2024-12-20 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[{"id":11684865,"change_date":"2024-12-20 21:40:00","inspection_id":"83452807","insp_violation_id":"263610046","seq_no":"1","part_no":"393","part_no_section":"45A-AJS","insp_viol_unit":"1","insp_unit_id":"204509536","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:56.000000Z","updated_at":"2025-03-17T22:02:56.000000Z","normalized_code":"39345AAJS"},{"id":11684866,"change_date":"2024-12-20 21:40:00","inspection_id":"83452807","insp_violation_id":"263610047","seq_no":"2","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":"2025-03-17T22:02:56.000000Z","updated_at":"2025-03-17T22:02:56.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12059670,"change_date":"2024-12-20 21:40:00","inspection_id":"83452807","insp_unit_id":"204509536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R690069","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX6LD666492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"},{"id":12059671,"change_date":"2024-12-20 21:40:00","inspection_id":"83452807","insp_unit_id":"204509537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"LB003","insp_unit_license":"226B778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL5845XP1033886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"}]},{"id":7330489,"change_date":"2024-12-10 21:42:00","inspection_id":"83300630","dot_number":"1973213","report_state":"TX","report_number":"V241599346","insp_date":"2024-11-26 00:00:00","insp_start_time":"1210","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"N AVENUE A AT ENTRY","county_code_state":"TX","county_code":"207","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER ENERGY SERVICES","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-12-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139600","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":"9442153","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-12-03 21:41:00","snet_input_date":"2024-11-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-03 21:41:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11825410,"change_date":"2024-12-10 21:42:00","inspection_id":"83300630","insp_unit_id":"204304426","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"HT007","insp_unit_license":"R690069","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX6LD666492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:36.000000Z","updated_at":"2025-03-17T23:45:36.000000Z"},{"id":11825411,"change_date":"2024-12-10 21:42:00","inspection_id":"83300630","insp_unit_id":"204304427","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAK","insp_unit_company":"LB003","insp_unit_license":"226B778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL5845XP1033886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:36.000000Z","updated_at":"2025-03-17T23:45:36.000000Z"}]},{"id":6942198,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","dot_number":"1973213","report_state":"TX","report_number":"V241619918","insp_date":"2024-10-09 00:00:00","insp_start_time":"0824","insp_end_time":"0854","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YARD","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-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9399568","transaction_code":"A","transaction_date":"2024-10-11 00:00:00","upload_date":"2024-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-10-11 21:40:00","snet_input_date":"2024-10-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-11 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:40:58.000000Z","updated_at":"2025-03-17T20:40:58.000000Z","inspection_violations":[{"id":10823323,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314174","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"203376832","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3929A2"},{"id":10823324,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314175","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"203376832","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"39345"},{"id":10823325,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314176","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"203376832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"39345D"},{"id":10823326,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314177","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203376833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3939A"},{"id":10823327,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314178","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203376833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3939A"},{"id":10823328,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314179","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203376833","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3939A"},{"id":10823329,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_violation_id":"262314180","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203376832","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11196702,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_unit_id":"203376832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"HT006","insp_unit_license":"R635802","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AN09Y49N003322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:56.000000Z","updated_at":"2025-03-17T23:38:56.000000Z"},{"id":11196703,"change_date":"2024-10-11 21:40:00","inspection_id":"82889382","insp_unit_id":"203376833","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"DF7440","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1T9B2292XR1649048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:56.000000Z","updated_at":"2025-03-17T23:38:56.000000Z"}]},{"id":6692655,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","dot_number":"1973213","report_state":"TX","report_number":"V241534033","insp_date":"2024-09-05 00:00:00","insp_start_time":"1300","insp_end_time":"1329","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BUSINESS 20 WESTBOUN","county_code_state":"TX","county_code":"389","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA TRANSFER & ENERGY SERVIC","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-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"13","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9373849","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-09-10 21:40:00","snet_input_date":"2024-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:35:40.000000Z","updated_at":"2025-03-17T20:35:40.000000Z","inspection_violations":[{"id":10418120,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723786","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","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":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"38323A2"},{"id":10418121,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723787","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202854579","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39021A"},{"id":10418122,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723788","seq_no":"3","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39141A"},{"id":10418123,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723789","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"393205C"},{"id":10418124,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723790","seq_no":"5","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"393205C"},{"id":10418125,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723791","seq_no":"6","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39343D"},{"id":10418126,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723792","seq_no":"7","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202854579","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39395F"},{"id":10418127,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723793","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39617C"},{"id":10418128,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723794","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202854579","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39617C"},{"id":10418129,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723795","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"},{"id":10418130,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723796","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202854579","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"},{"id":10418131,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723797","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202854580","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"},{"id":10418132,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_violation_id":"261723798","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202854579","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10791340,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_unit_id":"202854579","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TKC6638","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD8W3HN5PED63163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"},{"id":10791341,"change_date":"2024-09-10 21:40:00","inspection_id":"82623835","insp_unit_id":"202854580","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"465540M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9BU2025HE102539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":6491844,"change_date":"2024-08-16 21:40:00","inspection_id":"82410056","dot_number":"1973213","report_state":"TX","report_number":"V241487315","insp_date":"2024-08-14 00:00:00","insp_start_time":"0745","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH20 EB SVC RD","county_code_state":"TX","county_code":"353","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AQUA","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212936","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":"9352470","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-08-16 21:40:00","snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-16 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10080707,"change_date":"2024-08-16 21:40:00","inspection_id":"82410056","insp_violation_id":"261243388","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202442125","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3939A"},{"id":10080708,"change_date":"2024-08-16 21:40:00","inspection_id":"82410056","insp_violation_id":"261243389","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202442125","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:48.000000Z","updated_at":"2025-03-17T21:54:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10464704,"change_date":"2024-08-16 21:40:00","inspection_id":"82410056","insp_unit_id":"202442125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"HT010","insp_unit_license":"R736771","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX5JD476034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"},{"id":10464705,"change_date":"2024-08-16 21:40:00","inspection_id":"82410056","insp_unit_id":"202442126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGL","insp_unit_company":"EB01","insp_unit_license":"133C724","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"112SD5538JL082852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"}]},{"id":6506132,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","dot_number":"1973213","report_state":"TX","report_number":"V241481359","insp_date":"2024-08-12 00:00:00","insp_start_time":"1330","insp_end_time":"1457","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH35 SB SAN MARCOS SCALE","county_code_state":"TX","county_code":"209","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HOLT CAT","shipping_paper_number":"HL1000841","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-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"126600","viol_total":"9","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9354493","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10104657,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300456","seq_no":"1","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"202491957","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39387A"},{"id":10104658,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300457","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202491956","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10104659,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300458","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202491956","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10104660,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300459","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202491956","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10104661,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300460","seq_no":"5","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3958"},{"id":10104662,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300461","seq_no":"6","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3958F1"},{"id":10104663,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300462","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202491956","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3922"},{"id":10104664,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300463","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202491956","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3922"},{"id":10104665,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_violation_id":"261300464","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10487828,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_unit_id":"202491956","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R690069","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX6LD666492","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"},{"id":10487829,"change_date":"2024-08-20 21:43:00","inspection_id":"82425218","insp_unit_id":"202491957","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"226B778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5LKL5845XP1033886","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"}]},{"id":1080897,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","dot_number":"1973213","report_state":"TX","report_number":"6DCI0AGACN","insp_date":"2022-08-09 00:00:00","insp_start_time":"1805","insp_end_time":"1851","registration_date":"2022-09-15 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0018 IN WINKLER CO. (318-34","county_code_state":"TX","county_code":"495","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENERGY TRANSFER","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"8746718","transaction_code":"C","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2022-08-18 21:40:00","snet_input_date":"2022-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-18 21:40:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T18:46:51.000000Z","updated_at":"2025-03-17T18:46:51.000000Z","inspection_violations":[{"id":1704280,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449644","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39348A"},{"id":1704281,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449645","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39348A"},{"id":1704282,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449646","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39348A"},{"id":1704283,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449647","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"39348A"},{"id":1704284,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449648","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3963A1"},{"id":1704285,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449649","seq_no":"6","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"393104F3"},{"id":1704286,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_violation_id":"248449650","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190929608","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:58.000000Z","updated_at":"2025-03-17T21:14:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1738595,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_unit_id":"190929607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"RJJ0494","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTKJPVK5MH674938","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"},{"id":1738596,"change_date":"2022-09-15 21:40:00","inspection_id":"76372156","insp_unit_id":"190929608","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"761066H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P5FD4023F1221849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:58.000000Z","updated_at":"2025-03-17T22:18:58.000000Z"}]},{"id":399016,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","dot_number":"1973213","report_state":"TX","report_number":"6AUB0XRPR2","insp_date":"2022-05-11 00:00:00","insp_start_time":"1032","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"114 W COLLINS ST","county_code_state":"TX","county_code":"301","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"95080","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8655016","transaction_code":"C","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2022-05-16 21:43:00","snet_input_date":"2022-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T18:34:28.000000Z","updated_at":"2025-03-17T18:34:28.000000Z","inspection_violations":[{"id":624313,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854663","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188737699","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"3963A1"},{"id":624314,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854664","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188737699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39345B2"},{"id":624315,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854665","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188737699","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39347E"},{"id":624316,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854666","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188737699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39353B"},{"id":624317,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854667","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188737699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39311"},{"id":624318,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854668","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"188737700","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39345B2"},{"id":624319,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854669","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"188737700","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39355E"},{"id":624320,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_violation_id":"245854670","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188737700","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":644941,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_unit_id":"188737699","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4","insp_unit_license":"R587913","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AN07Y7HM024569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"},{"id":644942,"change_date":"2022-05-17 21:43:00","inspection_id":"75569222","insp_unit_id":"188737700","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VACT","insp_unit_company":"4","insp_unit_license":"190C060","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4S9V6TA25CG270008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"}]},{"id":56456,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","dot_number":"1973213","report_state":"TX","report_number":"69IE0SZE8H","insp_date":"2022-03-24 00:00:00","insp_start_time":"1437","insp_end_time":"1457","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0062 IN HOCKLEY CO. (304-31","county_code_state":"TX","county_code":"219","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"44000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8603268","transaction_code":"A","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":null,"census_search_date":"2022-03-28 21:41:00","snet_input_date":"2022-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"112953","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T18:28:28.000000Z","updated_at":"2025-03-17T18:28:28.000000Z","inspection_violations":[{"id":81438,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820482","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"187859286","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39343"},{"id":81439,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820483","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"187859287","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39343"},{"id":81440,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820484","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"187859287","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39360C"},{"id":81441,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820485","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"187859287","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39395A"},{"id":81442,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820486","seq_no":"5","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"187859287","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39360D"},{"id":81443,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_violation_id":"244820487","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"187859287","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:30.000000Z","updated_at":"2025-03-17T21:07:30.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":91814,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_unit_id":"187859286","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"761066H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P5FD4023F1221849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"},{"id":91815,"change_date":"2022-03-28 21:41:00","inspection_id":"75157309","insp_unit_id":"187859287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PJD9055","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT2MED05807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"}]},{"id":38454,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","dot_number":"1973213","report_state":"TX","report_number":"69CB9DITNP","insp_date":"2022-03-18 00:00:00","insp_start_time":"1158","insp_end_time":"1213","registration_date":"2022-03-31 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN BEXAR CO. (545-596)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8600806","transaction_code":"C","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01973213","upload_search_indicator":"M","census_search_date":"2022-03-24 21:31:00","snet_input_date":"2022-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"AQUA TRANSFER & ENERGY SERVICES LLC","insp_carrier_street":"757 W 2ND AVE","insp_carrier_city":"CORSICANA","insp_carrier_state":"TX","insp_carrier_zip_code":"75110","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0822385","created_at":"2025-03-17T18:28:09.000000Z","updated_at":"2025-03-17T18:28:09.000000Z","inspection_violations":[{"id":55369,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_violation_id":"244902843","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"187931521","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39021A"},{"id":55370,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_violation_id":"244902844","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"187931521","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39360D"},{"id":55371,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_violation_id":"244902845","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"187931521","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3963A1"},{"id":55372,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_violation_id":"244902846","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187931521","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39617C"},{"id":55373,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_violation_id":"244902847","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"187931522","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":62246,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_unit_id":"187931521","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"KMJ9700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9JEB27762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:39.000000Z","updated_at":"2025-03-17T22:08:39.000000Z"},{"id":62247,"change_date":"2022-03-31 21:41:00","inspection_id":"75134507","insp_unit_id":"187931522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"231491H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P5FD3228E1200680","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:39.000000Z","updated_at":"2025-03-17T22:08:39.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1973213\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1973213\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1973213\/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\/1973213\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}