{"current_page":1,"data":[{"id":12544875,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","dot_number":"1038098","report_state":"TX","report_number":"7HE99DFP7W","insp_date":"2026-07-21 00:00:00","insp_start_time":"1354","insp_end_time":"1454","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900  STATE HIGHWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BARBOURS CUT TERMINAL","shipping_paper_number":"HLBU2360335","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126100","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10042870","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-24 21:41:00","insp_carrier_name":"BAY WATER TRUCKING COMPANY LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"Y","insp_carrier_state_id":"0182413","created_at":"2026-07-27T09:41:40.000000Z","updated_at":"2026-08-04T09:31:23.000000Z","inspection_violations":[{"id":21838596,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721321","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214809458","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"39375A3TAOL"},{"id":21838594,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721319","seq_no":"1","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"214809458","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"3939TS"},{"id":21838595,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721320","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"214809458","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"39319"},{"id":21838597,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721322","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"214809459","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"3963A1"},{"id":21838598,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721323","seq_no":"5","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214809459","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"39345B2UV"},{"id":21838599,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_violation_id":"275721324","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"214809458","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:20.000000Z","updated_at":"2026-08-04T09:44:17.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":21783672,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_unit_id":"214809459","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"MCHZ 200018","insp_unit_license":"1M78484","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"LJRC28265G1024752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:02.000000Z","updated_at":"2026-08-04T09:02:53.000000Z"},{"id":21783671,"change_date":"2026-07-24 21:41:00","inspection_id":"88511551","insp_unit_id":"214809458","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M78484","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSZYB6WL972998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:02.000000Z","updated_at":"2026-08-04T09:02:53.000000Z"}]},{"id":12448839,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","dot_number":"1038098","report_state":"TX","report_number":"7H1E9DGXSP","insp_date":"2026-07-08 00:00:00","insp_start_time":"1359","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PORT OF HOUSTON BAYPORT","shipping_paper_number":"CAAU2333289","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126100","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10029624","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-14 21:41:00","insp_carrier_name":"BAY WATER TRUCKING COMPANY LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"Y","insp_carrier_state_id":"0182413","created_at":"2026-07-17T09:41:20.000000Z","updated_at":"2026-07-25T09:31:35.000000Z","inspection_violations":[{"id":21672958,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_violation_id":"275503649","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214613624","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:16.000000Z","updated_at":"2026-07-25T09:44:36.000000Z","normalized_code":"3939"},{"id":21672959,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_violation_id":"275503650","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214613624","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:16.000000Z","updated_at":"2026-07-25T09:44:36.000000Z","normalized_code":"39395F"},{"id":21672960,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_violation_id":"275503651","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214613624","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:16.000000Z","updated_at":"2026-07-25T09:44:36.000000Z","normalized_code":"39378"},{"id":21672961,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_violation_id":"275503652","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214613624","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:04:16.000000Z","updated_at":"2026-07-25T09:44:36.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21623737,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_unit_id":"214613624","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0008","insp_unit_license":"1N51693","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPSDU9X89D778734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:28.000000Z","updated_at":"2026-07-25T09:03:35.000000Z"},{"id":21623738,"change_date":"2026-07-14 21:41:00","inspection_id":"88408785","insp_unit_id":"214613625","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"MCCZ 201159","insp_unit_license":"U709516","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC28264H1009600","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:28.000000Z","updated_at":"2026-07-25T09:03:35.000000Z"}]},{"id":12215889,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","dot_number":"1038098","report_state":"TX","report_number":"7G7F9DAP3E","insp_date":"2026-06-08 00:00:00","insp_start_time":"1433","insp_end_time":"1536","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2400 E SH 225 EB PAS","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"METRIZ LOGISTICS","shipping_paper_number":"L027127R","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128700","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9996298","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-17 21:41:00","insp_carrier_name":"BAY WATER TRUCKING COMPANY LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"Y","insp_carrier_state_id":"0182413","created_at":"2026-06-20T09:43:50.000000Z","updated_at":"2026-06-28T09:31:28.000000Z","inspection_violations":[{"id":21259799,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975991","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39347E"},{"id":21259800,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975992","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39347E"},{"id":21259801,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975993","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39347E"},{"id":21259802,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975994","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"214159772","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39347E"},{"id":21259803,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975995","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39353B"},{"id":21259805,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975997","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"3963A1BOS"},{"id":21259806,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975998","seq_no":"8","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39395F"},{"id":21259807,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975999","seq_no":"9","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"214159772","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39375A3TAOL"},{"id":21259808,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274976000","seq_no":"10","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"214159771","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"3963A1"},{"id":21259809,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274976001","seq_no":"11","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214159772","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39345B2UV"},{"id":21259810,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274976002","seq_no":"12","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214159772","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39345B2UV"},{"id":21259804,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_violation_id":"274975996","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"214159772","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:06:08.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":21215966,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_unit_id":"214159771","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2014","insp_unit_license":"1M10075","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X56R127081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:14.000000Z","updated_at":"2026-06-28T09:03:04.000000Z"},{"id":21215967,"change_date":"2026-06-17 21:41:00","inspection_id":"88173389","insp_unit_id":"214159772","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"DCLZ 416204","insp_unit_license":"U463223","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412SXYT086389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:14.000000Z","updated_at":"2026-06-28T09:03:04.000000Z"}]},{"id":12031672,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","dot_number":"1038098","report_state":"TX","report_number":"7FP89DNON9","insp_date":"2026-05-21 00:00:00","insp_start_time":"0859","insp_end_time":"0947","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BARBOURS CUT TERMINAL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9970499","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-27 21:41:00","insp_carrier_name":"BAY WATER TRUCKING CO LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2026-05-30T09:39:37.000000Z","updated_at":"2026-06-07T09:31:28.000000Z","inspection_violations":[{"id":20935946,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_violation_id":"274536380","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"213780945","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-30T09:58:06.000000Z","updated_at":"2026-06-07T09:43:35.000000Z","normalized_code":"3929AA1"},{"id":20935947,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_violation_id":"274536381","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213780946","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:06.000000Z","updated_at":"2026-06-07T09:43:35.000000Z","normalized_code":"39617C"},{"id":20935948,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_violation_id":"274536382","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213780946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:06.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3939"},{"id":20935949,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_violation_id":"274536383","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213780946","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:58:06.000000Z","updated_at":"2026-06-07T09:43:39.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20912850,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_unit_id":"213780945","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M78484","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSZYB6WL972998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:46.000000Z","updated_at":"2026-06-07T09:03:24.000000Z"},{"id":20912851,"change_date":"2026-05-27 21:41:00","inspection_id":"87971904","insp_unit_id":"213780946","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"MCCZ 202424","insp_unit_license":"555831T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"7SPCC2724SN001663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:46.000000Z","updated_at":"2026-06-07T09:03:24.000000Z"}]},{"id":11900777,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","dot_number":"1038098","report_state":"TX","report_number":"7F899DGXMJ","insp_date":"2026-05-04 00:00:00","insp_start_time":"0856","insp_end_time":"0957","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9800  RED BLUFF S\/B","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126100","viol_total":"14","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9952414","transaction_code":"A","transaction_date":"2026-05-13 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"BAY WATER TRUCKING CO LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2026-05-15T12:27:01.000000Z","updated_at":"2026-05-24T09:31:53.000000Z","inspection_violations":[{"id":20698966,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234960","seq_no":"12","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3922W"},{"id":20698967,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234961","seq_no":"13","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-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3922W"},{"id":20698968,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234962","seq_no":"14","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3929AA1"},{"id":20698969,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234963","seq_no":"1","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"39347B"},{"id":20698970,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234964","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"39345B2UV"},{"id":20698971,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234965","seq_no":"3","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3963A1"},{"id":20698972,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234966","seq_no":"4","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"39355D2"},{"id":20698973,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234967","seq_no":"5","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"213535013","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3939T"},{"id":20698974,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234968","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213535013","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3939"},{"id":20698975,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234969","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213535013","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3939"},{"id":20698976,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234970","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"39347E"},{"id":20698977,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234971","seq_no":"9","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"39353B"},{"id":20698978,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234972","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3922RG"},{"id":20698979,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_violation_id":"274234973","seq_no":"11","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"213535012","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:33.000000Z","updated_at":"2026-05-24T09:45:56.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20689899,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_unit_id":"213535012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2172","insp_unit_license":"1M56325","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALXFB00XLDLG0235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:55.000000Z","updated_at":"2026-05-24T09:05:16.000000Z"},{"id":20689900,"change_date":"2026-05-13 21:42:00","inspection_id":"87839531","insp_unit_id":"213535013","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"MCCZ 201231","insp_unit_license":"U709588","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC28267H1009672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:55.000000Z","updated_at":"2026-05-24T09:05:16.000000Z"}]},{"id":11587415,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","dot_number":"1038098","report_state":"TX","report_number":"7EA99DNG7I","insp_date":"2026-03-31 00:00:00","insp_start_time":"0936","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"124100","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9909487","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-07 21:39:00","insp_carrier_name":"BAY WATER TRUCKING CO LLC","insp_carrier_street":"8000 MARKET ST SUITE 220","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"Y","insp_carrier_state_id":"0182413","created_at":"2026-04-10T09:43:22.000000Z","updated_at":"2026-04-17T09:55:30.000000Z","inspection_violations":[{"id":19595420,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_violation_id":"272920049","seq_no":"2","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"212588586","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:56.000000Z","updated_at":"2026-04-18T10:44:36.000000Z","normalized_code":"3963A1BOS"},{"id":19595421,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_violation_id":"272920050","seq_no":"3","part_no":"393","part_no_section":"75A","insp_viol_unit":"2","insp_unit_id":"212588587","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-09T10:16:56.000000Z","updated_at":"2026-04-18T10:44:36.000000Z","normalized_code":"39375A"},{"id":19595422,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_violation_id":"272920051","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212588586","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:56.000000Z","updated_at":"2026-04-18T10:44:36.000000Z","normalized_code":"3939"},{"id":19595423,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_violation_id":"272920052","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212588586","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:56.000000Z","updated_at":"2026-04-18T10:44:36.000000Z","normalized_code":"3939"},{"id":19595419,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_violation_id":"272920048","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212588586","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:56.000000Z","updated_at":"2026-04-18T10:44:36.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":19861328,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_unit_id":"212588586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003","insp_unit_license":"1L40642","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X3YR834570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:30.000000Z","updated_at":"2026-04-18T09:32:05.000000Z"},{"id":19861329,"change_date":"2026-04-07 21:39:00","inspection_id":"87513189","insp_unit_id":"212588587","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"U628218","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC28265G1024752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:30.000000Z","updated_at":"2026-04-18T09:32:05.000000Z"}]},{"id":11251888,"change_date":"2026-02-27 21:42:00","inspection_id":"87165187","dot_number":"1038098","report_state":"TX","report_number":"V262239216","insp_date":"2026-02-25 00:00:00","insp_start_time":"1041","insp_end_time":"1108","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MILESTONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9866242","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"8000 MARKET ST SUITE 240","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"Y","insp_carrier_state_id":"0182413","created_at":"2026-03-02T10:39:51.000000Z","updated_at":"2026-03-10T09:31:31.000000Z","inspection_violations":[{"id":18904945,"change_date":"2026-02-27 21:42:00","inspection_id":"87165187","insp_violation_id":"272101068","seq_no":"1","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"211888136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:01.000000Z","updated_at":"2026-03-10T09:44:49.000000Z","normalized_code":"39324A"},{"id":18904946,"change_date":"2026-02-27 21:42:00","inspection_id":"87165187","insp_violation_id":"272101069","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211888136","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:59:01.000000Z","updated_at":"2026-03-10T09:44:49.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":19238886,"change_date":"2026-02-27 21:42:00","inspection_id":"87165187","insp_unit_id":"211888136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2143","insp_unit_license":"1M77627","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWD49X66R076563","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:28.000000Z","updated_at":"2026-03-10T09:06:14.000000Z"}]},{"id":7073962,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","dot_number":"1038098","report_state":"TX","report_number":"6ZQH9DGXDB","insp_date":"2024-10-23 00:00:00","insp_start_time":"1706","insp_end_time":"1725","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"TLLU8569595","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123800","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9413587","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11043524,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_violation_id":"262621072","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203642423","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"},{"id":11043525,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_violation_id":"262621073","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203642424","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"},{"id":11043526,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_violation_id":"262621074","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203642423","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"},{"id":11043527,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_violation_id":"262621075","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203642423","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11408624,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_unit_id":"203642423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2262","insp_unit_license":"43U486M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHDB9X57N683408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"},{"id":11408625,"change_date":"2024-10-29 21:42:00","inspection_id":"83029289","insp_unit_id":"203642424","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"TNPZ 447033","insp_unit_license":"398927Z","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3C412S4RT000477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":5104890,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","dot_number":"1038098","report_state":"TX","report_number":"6SOC9DAP9S","insp_date":"2024-02-12 00:00:00","insp_start_time":"1223","insp_end_time":"1304","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"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":"2024-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123900","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9202396","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-21 21:41:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T20:03:48.000000Z","updated_at":"2025-03-17T20:03:48.000000Z","inspection_violations":[{"id":7874011,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_violation_id":"257990161","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199558317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"3939A"},{"id":7874012,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_violation_id":"257990162","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"199558317","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"39355D1"},{"id":7874013,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_violation_id":"257990163","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199558317","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"3922"},{"id":7874014,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_violation_id":"257990164","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199558318","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:02.000000Z","updated_at":"2025-03-17T21:44:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8218681,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_unit_id":"199558317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"51M433M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHDB9X57N683408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"},{"id":8218682,"change_date":"2024-02-22 21:43:00","inspection_id":"80907895","insp_unit_id":"199558318","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"TNPZ 479278","insp_unit_license":"426774Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41269JT017204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"}]},{"id":5031716,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","dot_number":"1038098","report_state":"TX","report_number":"6SI79DGP2J","insp_date":"2024-02-06 00:00:00","insp_start_time":"0706","insp_end_time":"0736","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9193373","transaction_code":"A","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T20:02:24.000000Z","updated_at":"2025-03-17T20:02:24.000000Z","inspection_violations":[{"id":7753396,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","insp_violation_id":"257793513","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"199383862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39355C1"},{"id":7753397,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","insp_violation_id":"257793514","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199383862","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39378"},{"id":7753398,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","insp_violation_id":"257793515","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199383862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39311"},{"id":7753399,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","insp_violation_id":"257793516","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199383862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8099545,"change_date":"2024-02-12 21:41:00","inspection_id":"80828142","insp_unit_id":"199383862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2262","insp_unit_license":"51M433M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPHDB9X57N683408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":4727701,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","dot_number":"1038098","report_state":"TX","report_number":"6R4C9DNISJ","insp_date":"2023-12-18 00:00:00","insp_start_time":"1223","insp_end_time":"1306","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYPORT TERMINAL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9159770","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":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[{"id":7299115,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365003","seq_no":"1","part_no":"393","part_no_section":"11UR","insp_viol_unit":"1","insp_unit_id":"204300351","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39311UR"},{"id":7299116,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365004","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204300351","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3939H"},{"id":7299117,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365005","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204300351","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3939TS"},{"id":7299118,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365006","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"204300352","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39319"},{"id":7299119,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365007","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"204300351","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39319"},{"id":7299120,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_violation_id":"263365008","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204300351","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":7604897,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_unit_id":"204300351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2268","insp_unit_license":"17R368M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X67D674861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"},{"id":7604898,"change_date":"2024-12-10 21:41:00","inspection_id":"80495586","insp_unit_id":"204300352","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"APMZ 423821","insp_unit_license":"T941117","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"LJRC4126961003130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"}]},{"id":4656402,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","dot_number":"1038098","report_state":"TX","report_number":"6R099DCIMP","insp_date":"2023-12-14 00:00:00","insp_start_time":"0955","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"13","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9151191","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T19:55:00.000000Z","updated_at":"2025-03-17T19:55:00.000000Z","inspection_violations":[{"id":7199141,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333974","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3922RG"},{"id":7199142,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333975","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39378"},{"id":7199143,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333976","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939H"},{"id":7199144,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333977","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939"},{"id":7199145,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333978","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3939TS"},{"id":7199146,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333979","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39319"},{"id":7199147,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333980","seq_no":"7","part_no":"393","part_no_section":"45PC","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39345PC"},{"id":7199148,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333981","seq_no":"8","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39375C"},{"id":7199149,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333982","seq_no":"9","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3963A1B"},{"id":7199150,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333983","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39347E"},{"id":7199151,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333984","seq_no":"11","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39347E"},{"id":7199152,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333985","seq_no":"12","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"39353B"},{"id":7199153,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_violation_id":"263333986","seq_no":"13","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204273215","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:45.000000Z","updated_at":"2025-03-17T21:40:45.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":7489396,"change_date":"2024-12-09 21:41:00","inspection_id":"80417812","insp_unit_id":"204273215","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"17R368M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP7D49X67D674861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:57.000000Z","updated_at":"2025-03-17T23:02:57.000000Z"}]},{"id":4195873,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","dot_number":"1038098","report_state":"TX","report_number":"6P7D9DNH27","insp_date":"2023-10-10 00:00:00","insp_start_time":"1348","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","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":"2023-10-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9100213","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01038098","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-13 21:41:00","insp_carrier_name":"BAY WATER TRUCKING CO","insp_carrier_street":"960 PLEASANTVILLE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"434672","insp_interstate":"N","insp_carrier_state_id":"0182413","created_at":"2025-03-17T19:45:53.000000Z","updated_at":"2025-03-17T19:45:53.000000Z","inspection_violations":[{"id":6497141,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_violation_id":"255832692","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197552022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"3939A"},{"id":6497142,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_violation_id":"255832693","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197552022","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"3939A"},{"id":6497143,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_violation_id":"255832694","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197552022","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"3965B"},{"id":6497144,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_violation_id":"255832695","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197552023","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:19.000000Z","updated_at":"2025-03-17T21:37:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6747609,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_unit_id":"197552022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2219","insp_unit_license":"1L96659","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLBGXCLBL8350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:34.000000Z","updated_at":"2025-03-17T22:56:34.000000Z"},{"id":6747610,"change_date":"2023-10-13 21:41:00","inspection_id":"79910121","insp_unit_id":"197552023","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"TNPZ 508620","insp_unit_license":"2554644","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"7L35600213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:34.000000Z","updated_at":"2025-03-17T22:56:34.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1038098\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1038098\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1038098\/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\/1038098\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}