{"current_page":1,"data":[{"id":9988483,"change_date":"2025-10-20 21:40:00","inspection_id":"86098108","dot_number":"1944533","report_state":"TX","report_number":"V252058265","insp_date":"2025-10-16 00:00:00","insp_start_time":"1305","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AAA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9732414","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2025-10-20 21:40:00","snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-10-23T10:00:45.000000Z","updated_at":"2025-10-24T10:01:12.000000Z","inspection_violations":[{"id":16505494,"change_date":"2025-10-20 21:40:00","inspection_id":"86098108","insp_violation_id":"269408165","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"209561556","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:07.000000Z","updated_at":"2025-10-24T10:17:06.000000Z","normalized_code":"39311"},{"id":16505495,"change_date":"2025-10-20 21:40:00","inspection_id":"86098108","insp_violation_id":"269408166","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-10-23T10:16:07.000000Z","updated_at":"2025-10-24T10:17:06.000000Z","normalized_code":"3922W"},{"id":16505496,"change_date":"2025-10-20 21:40:00","inspection_id":"86098108","insp_violation_id":"269408167","seq_no":"3","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-10-23T10:16:07.000000Z","updated_at":"2025-10-24T10:17:06.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16586789,"change_date":"2025-10-20 21:40:00","inspection_id":"86098108","insp_unit_id":"209561556","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-24","insp_unit_license":"MHT2817","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3DV9KHKN1209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:49.000000Z","updated_at":"2025-10-24T09:46:27.000000Z"}]},{"id":7984160,"change_date":"2025-02-27 21:42:00","inspection_id":"83987089","dot_number":"1944533","report_state":"TX","report_number":"V251788083","insp_date":"2025-02-21 00:00:00","insp_start_time":"1530","insp_end_time":"1602","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"19803  TX6","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AAA FLEXIBLE PIPE CLEANING CO","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-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72100","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":"9509423","transaction_code":"A","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12889291,"change_date":"2025-02-27 21:42:00","inspection_id":"83987089","insp_unit_id":"205545741","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-26","insp_unit_license":"PYP7179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVMG3DVXLHLV0718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"}]},{"id":7546267,"change_date":"2025-01-03 21:39:00","inspection_id":"83527276","dot_number":"1944533","report_state":"TX","report_number":"71FG9DGXJK","insp_date":"2024-12-23 00:00:00","insp_start_time":"1642","insp_end_time":"1707","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":"AAA FLEXIBLE PIPE CLEANING CO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"9464014","transaction_code":"A","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2025-01-03 21:39:00","snet_input_date":"2024-12-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:54:53.000000Z","updated_at":"2025-03-17T20:54:53.000000Z","inspection_violations":[{"id":11794162,"change_date":"2025-01-03 21:39:00","inspection_id":"83527276","insp_violation_id":"263751587","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204647557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922W"},{"id":11794163,"change_date":"2025-01-03 21:39:00","inspection_id":"83527276","insp_violation_id":"263751588","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204647557","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12175386,"change_date":"2025-01-03 21:39:00","inspection_id":"83527276","insp_unit_id":"204647557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"BH22","insp_unit_license":"JFB6352","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV2HPHZ5264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:26.000000Z","updated_at":"2025-03-17T23:49:26.000000Z"}]},{"id":7392910,"change_date":"2024-12-13 21:41:00","inspection_id":"83366279","dot_number":"1944533","report_state":"TX","report_number":"70V89DJVV0","insp_date":"2024-12-03 00:00:00","insp_start_time":"0836","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"9444305","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11925991,"change_date":"2024-12-13 21:41:00","inspection_id":"83366279","insp_unit_id":"204376671","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PCY6162","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3DV0LHLW0286","insp_unit_decal":"Y","insp_unit_decal_number":"34553676","created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7278742,"change_date":"2024-11-25 21:44:00","inspection_id":"83246017","dot_number":"1944533","report_state":"TX","report_number":"70J79DBAD7","insp_date":"2024-11-21 00:00:00","insp_start_time":"0740","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AAA FLEXIBLE PIPE CLEANING","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-11-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9435358","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2024-11-25 21:44:00","snet_input_date":"2024-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-25 21:44:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:47:46.000000Z","updated_at":"2025-03-17T20:47:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11740683,"change_date":"2024-11-25 21:44:00","inspection_id":"83246017","insp_unit_id":"204052150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-18","insp_unit_license":"MHT2858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS9BDBD1076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":6540977,"change_date":"2024-08-22 21:43:00","inspection_id":"82462246","dot_number":"1944533","report_state":"TX","report_number":"6XYC9DKY89","insp_date":"2024-08-20 00:00:00","insp_start_time":"1225","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN GALVESTON CO. (502-","county_code_state":"TX","county_code":"167","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9357799","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2024-08-22 21:43:00","snet_input_date":"2024-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:32:44.000000Z","updated_at":"2025-03-17T20:32:44.000000Z","inspection_violations":[{"id":10162886,"change_date":"2024-08-22 21:43:00","inspection_id":"82462246","insp_violation_id":"261358140","seq_no":"1","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:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10544569,"change_date":"2024-08-22 21:43:00","inspection_id":"82462246","insp_unit_id":"202540067","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-26","insp_unit_license":"PYP7179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVMG3DVXLHLV0718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":5074798,"change_date":"2024-02-16 21:42:00","inspection_id":"80875215","dot_number":"1944533","report_state":"TX","report_number":"6SO79DNNHD","insp_date":"2024-02-12 00:00:00","insp_start_time":"0755","insp_end_time":"0837","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"9198591","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2024-02-16 21:42:00","snet_input_date":"2024-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-16 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:03:07.000000Z","updated_at":"2025-03-17T20:03:07.000000Z","inspection_violations":[{"id":7822199,"change_date":"2024-02-16 21:42:00","inspection_id":"80875215","insp_violation_id":"257893244","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199472814","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:50.000000Z","updated_at":"2025-03-17T21:43:50.000000Z","normalized_code":"3965B"},{"id":7822200,"change_date":"2024-02-16 21:42:00","inspection_id":"80875215","insp_violation_id":"257893245","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199472814","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:50.000000Z","updated_at":"2025-03-17T21:43:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8169560,"change_date":"2024-02-16 21:42:00","inspection_id":"80875215","insp_unit_id":"199472814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH18","insp_unit_license":"MHT2858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS9BDBD1076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:02.000000Z","updated_at":"2025-03-17T23:09:02.000000Z"}]},{"id":4989778,"change_date":"2024-02-06 21:42:00","inspection_id":"80782157","dot_number":"1944533","report_state":"TX","report_number":"6SB99DFX8L","insp_date":"2024-01-30 00:00:00","insp_start_time":"0956","insp_end_time":"1034","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9189220","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8031014,"change_date":"2024-02-06 21:42:00","inspection_id":"80782157","insp_unit_id":"199295441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"JFB6352","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV2HPHZ5264","insp_unit_decal":"Y","insp_unit_decal_number":"33619953","created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4364978,"change_date":"2023-11-06 21:42:00","inspection_id":"80096916","dot_number":"1944533","report_state":"TX","report_number":"6PR89DKYQN","insp_date":"2023-10-30 00:00:00","insp_start_time":"0809","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9117908","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:49:30.000000Z","updated_at":"2025-03-17T19:49:30.000000Z","inspection_violations":[{"id":6752777,"change_date":"2023-11-06 21:42:00","inspection_id":"80096916","insp_violation_id":"256245008","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197929995","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"},{"id":6752778,"change_date":"2023-11-06 21:42:00","inspection_id":"80096916","insp_violation_id":"256245009","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197929995","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"},{"id":6752779,"change_date":"2023-11-06 21:42:00","inspection_id":"80096916","insp_violation_id":"256245010","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"197929995","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":7020482,"change_date":"2023-11-06 21:42:00","inspection_id":"80096916","insp_unit_id":"197929995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-24","insp_unit_license":"MHT2817","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3DV9KHKN1209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:56.000000Z","updated_at":"2025-03-17T22:58:56.000000Z"}]},{"id":3918010,"change_date":"2023-09-06 21:43:00","inspection_id":"79601755","dot_number":"1944533","report_state":"TX","report_number":"6NV89DCKLU","insp_date":"2023-08-23 00:00:00","insp_start_time":"0818","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  PATTERSON ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","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-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9068784","transaction_code":"A","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-09-06 21:43:00","snet_input_date":"2023-08-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-06 21:43:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:40:08.000000Z","updated_at":"2025-03-17T19:40:08.000000Z","inspection_violations":[{"id":6055204,"change_date":"2023-09-06 21:43:00","inspection_id":"79601755","insp_violation_id":"255120870","seq_no":"1","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"196931742","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3929"},{"id":6055205,"change_date":"2023-09-06 21:43:00","inspection_id":"79601755","insp_violation_id":"255120871","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196931742","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6300202,"change_date":"2023-09-06 21:43:00","inspection_id":"79601755","insp_unit_id":"196931742","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"DZX5254","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6FDGL5807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:57.000000Z","updated_at":"2025-03-17T22:52:57.000000Z"}]},{"id":3698283,"change_date":"2023-08-08 21:42:00","inspection_id":"79356595","dot_number":"1944533","report_state":"TX","report_number":"6N999DGXGB","insp_date":"2023-08-01 00:00:00","insp_start_time":"0858","insp_end_time":"0918","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":"2023-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9047247","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-08-08 21:42:00","snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-08 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[{"id":5702299,"change_date":"2023-08-08 21:42:00","inspection_id":"79356595","insp_violation_id":"254539783","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196429694","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5946333,"change_date":"2023-08-08 21:42:00","inspection_id":"79356595","insp_unit_id":"196429694","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-26","insp_unit_license":"PYP7179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVMG3DVXLHLV0718","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"}]},{"id":3046626,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","dot_number":"1944533","report_state":"TX","report_number":"6KX89DNN4K","insp_date":"2023-05-09 00:00:00","insp_start_time":"0805","insp_end_time":"0844","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1800 S BATTLEGROUND","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-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"8978286","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-05-15 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:23:22.000000Z","updated_at":"2025-03-17T19:23:22.000000Z","inspection_violations":[{"id":4680339,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","insp_violation_id":"252838347","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194936332","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"},{"id":4680340,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","insp_violation_id":"252838348","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194936332","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3939A"},{"id":4680341,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","insp_violation_id":"252838349","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194936332","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3922"},{"id":4680342,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","insp_violation_id":"252838350","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194936332","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:51.000000Z","updated_at":"2025-03-17T21:28:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4901466,"change_date":"2023-05-15 21:42:00","inspection_id":"78623471","insp_unit_id":"194936332","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"BH23","insp_unit_license":"LFV9384","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV0KPKU9308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:39.000000Z","updated_at":"2025-03-17T22:41:39.000000Z"}]},{"id":2751795,"change_date":"2023-04-06 21:40:00","inspection_id":"78289907","dot_number":"1944533","report_state":"TX","report_number":"6JYA9DBTJA","insp_date":"2023-04-04 00:00:00","insp_start_time":"1013","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","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-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8948032","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[{"id":4224111,"change_date":"2023-04-06 21:40:00","inspection_id":"78289907","insp_violation_id":"252092631","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194268965","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4429316,"change_date":"2023-04-06 21:40:00","inspection_id":"78289907","insp_unit_id":"194268965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH21","insp_unit_license":"HSG5337","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG5CY6GHHN2575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"}]},{"id":2721859,"change_date":"2023-04-03 21:40:00","inspection_id":"78256035","dot_number":"1944533","report_state":"TX","report_number":"6JT79DNN2L","insp_date":"2023-03-30 00:00:00","insp_start_time":"0754","insp_end_time":"0812","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500 S BATTLEGROUND","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-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"8944715","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[{"id":4182105,"change_date":"2023-04-03 21:40:00","inspection_id":"78256035","insp_violation_id":"252022257","seq_no":"1","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"194201757","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:35.000000Z","updated_at":"2025-03-17T21:26:35.000000Z","normalized_code":"393201D"},{"id":4182106,"change_date":"2023-04-03 21:40:00","inspection_id":"78256035","insp_violation_id":"252022258","seq_no":"2","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"194201757","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:35.000000Z","updated_at":"2025-03-17T21:26:35.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":4381408,"change_date":"2023-04-03 21:40:00","inspection_id":"78256035","insp_unit_id":"194201757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"VH20","insp_unit_license":"CNC8160","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTWGAATX9J087193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2606109,"change_date":"2023-03-21 21:42:00","inspection_id":"78123802","dot_number":"1944533","report_state":"TX","report_number":"6JDC9DKYJ1","insp_date":"2023-03-14 00:00:00","insp_start_time":"1208","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8932026","transaction_code":"C","transaction_date":"2023-03-21 00:00:00","upload_date":"2023-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-03-17 21:43:00","snet_input_date":"2023-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-17 21:43:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:14:50.000000Z","updated_at":"2025-03-17T19:14:50.000000Z","inspection_violations":[{"id":4010666,"change_date":"2023-03-21 21:42:00","inspection_id":"78123802","insp_violation_id":"251787285","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"193987598","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"393100A"},{"id":4010667,"change_date":"2023-03-21 21:42:00","inspection_id":"78123802","insp_violation_id":"251787286","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193987598","insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"3922"},{"id":4010668,"change_date":"2023-03-21 21:42:00","inspection_id":"78123802","insp_violation_id":"251787287","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193987598","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4195229,"change_date":"2023-03-21 21:42:00","inspection_id":"78123802","insp_unit_id":"193987598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"BH-22","insp_unit_license":"JFB6352","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKHAXDV2HPHZ5264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:06.000000Z","updated_at":"2025-03-17T22:36:06.000000Z"}]},{"id":2470720,"change_date":"2023-02-28 21:41:00","inspection_id":"77969407","dot_number":"1944533","report_state":"TX","report_number":"6IR79DNO0K","insp_date":"2023-02-20 00:00:00","insp_start_time":"0737","insp_end_time":"0752","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8916291","transaction_code":"A","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-02-28 21:41:00","snet_input_date":"2023-02-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:12:08.000000Z","updated_at":"2025-03-17T19:12:08.000000Z","inspection_violations":[{"id":3803630,"change_date":"2023-02-28 21:41:00","inspection_id":"77969407","insp_violation_id":"251393442","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193628584","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:54.000000Z","updated_at":"2025-03-17T21:24:54.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":3976574,"change_date":"2023-02-28 21:41:00","inspection_id":"77969407","insp_unit_id":"193628584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH-19","insp_unit_license":"CJT0186","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS8DHFH1740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:29.000000Z","updated_at":"2025-03-17T22:34:29.000000Z"}]},{"id":2360346,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","dot_number":"1944533","report_state":"TX","report_number":"6IF99DCRDJ","insp_date":"2023-02-08 00:00:00","insp_start_time":"0932","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","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-02-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60780","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8901943","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-02-13 21:43:00","snet_input_date":"2023-02-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:10:17.000000Z","updated_at":"2025-03-17T19:10:17.000000Z","inspection_violations":[{"id":3635809,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108539","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3939A"},{"id":3635810,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108540","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39311"},{"id":3635811,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108541","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39311"},{"id":3635812,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108542","seq_no":"4","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3929A2"},{"id":3635813,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108543","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39311"},{"id":3635814,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108544","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3939A"},{"id":3635815,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_violation_id":"251108545","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"193374857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":3798960,"change_date":"2023-02-13 21:43:00","inspection_id":"77843658","insp_unit_id":"193374857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH21","insp_unit_license":"HSG5337","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG5CY6GHHN2575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:12.000000Z","updated_at":"2025-03-17T22:33:12.000000Z"}]},{"id":2145354,"change_date":"2023-01-13 21:41:00","inspection_id":"77598281","dot_number":"1944533","report_state":"TX","report_number":"6HGE9DCNYO","insp_date":"2023-01-04 00:00:00","insp_start_time":"1406","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2500  NORTH SERVICE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AAA FLEXIBLE PIPE CLEANING","shipping_paper_number":"3777","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-01-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"8876762","transaction_code":"A","transaction_date":"2023-01-13 00:00:00","upload_date":"2023-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2023-01-13 21:41:00","snet_input_date":"2023-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-13 21:41:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T19:06:14.000000Z","updated_at":"2025-03-17T19:06:14.000000Z","inspection_violations":[{"id":3319594,"change_date":"2023-01-13 21:41:00","inspection_id":"77598281","insp_violation_id":"250580868","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"192877926","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"39360D"},{"id":3319595,"change_date":"2023-01-13 21:41:00","inspection_id":"77598281","insp_violation_id":"250580869","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192877926","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:40.000000Z","updated_at":"2025-03-17T21:22:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3452558,"change_date":"2023-01-13 21:41:00","inspection_id":"77598281","insp_unit_id":"192877926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"CJT0186","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS8DHFH1740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:44.000000Z","updated_at":"2025-03-17T22:30:44.000000Z"}]},{"id":1222631,"change_date":"2022-09-06 21:43:00","inspection_id":"76536801","dot_number":"1944533","report_state":"TX","report_number":"6DYH9DFXC1","insp_date":"2022-08-31 00:00:00","insp_start_time":"1714","insp_end_time":"1729","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200  RED BLUFF RD N","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":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-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"8763162","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2022-09-06 21:43:00","snet_input_date":"2022-08-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-06 21:43:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T18:49:18.000000Z","updated_at":"2025-03-17T18:49:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1967554,"change_date":"2022-09-06 21:43:00","inspection_id":"76536801","insp_unit_id":"190748904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"DZX5254","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYCY6FDGL5807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:31.000000Z","updated_at":"2025-03-17T22:20:31.000000Z"}]},{"id":986626,"change_date":"2022-08-08 21:40:00","inspection_id":"76262061","dot_number":"1944533","report_state":"TX","report_number":"6CO99DBZ2N","insp_date":"2022-07-16 00:00:00","insp_start_time":"0908","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP SITE","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-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8735012","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-07-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1555251,"change_date":"2022-08-08 21:40:00","inspection_id":"76262061","insp_violation_id":"247577761","seq_no":"1","part_no":"383","part_no_section":"93(b)(3)","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:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"38393B3"}],"inspection_per_units":[{"id":1588105,"change_date":"2022-08-08 21:40:00","inspection_id":"76262061","insp_unit_id":"190190372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"MHT2858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS9BDBD1076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"}]},{"id":371704,"change_date":"2022-05-12 21:42:00","inspection_id":"75536064","dot_number":"1944533","report_state":"TX","report_number":"6AMB9DBGJ7","insp_date":"2022-05-03 00:00:00","insp_start_time":"1025","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AAA","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-05-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8652162","transaction_code":"C","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2022-05-11 21:40:00","snet_input_date":"2022-05-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T18:34:01.000000Z","updated_at":"2025-03-17T18:34:01.000000Z","inspection_violations":[{"id":582883,"change_date":"2022-05-12 21:42:00","inspection_id":"75536064","insp_violation_id":"245760269","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188658128","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"3939A"},{"id":582884,"change_date":"2022-05-12 21:42:00","inspection_id":"75536064","insp_violation_id":"245760270","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"188658128","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":601379,"change_date":"2022-05-12 21:42:00","inspection_id":"75536064","insp_unit_id":"188658128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BH18","insp_unit_license":"MHT2858","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHCYBS9BDBD1076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"}]},{"id":64953,"change_date":"2022-03-29 21:42:00","inspection_id":"75167788","dot_number":"1944533","report_state":"TX","report_number":"69GA9DCBXA","insp_date":"2022-03-22 00:00:00","insp_start_time":"1042","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","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":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64740","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":"8604015","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01944533","upload_search_indicator":"M","census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"AAA FLEXIBLE PIPE CLEANING COMPANY","insp_carrier_street":"3900 UNDERWOOD ROAD","insp_carrier_city":"LA PORTE","insp_carrier_state":"TX","insp_carrier_zip_code":"77571-3930","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0002845","created_at":"2025-03-17T18:28:46.000000Z","updated_at":"2025-03-17T18:28:46.000000Z","inspection_violations":[{"id":94440,"change_date":"2022-03-29 21:42:00","inspection_id":"75167788","insp_violation_id":"244843580","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187880724","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3922"},{"id":94441,"change_date":"2022-03-29 21:42:00","inspection_id":"75167788","insp_violation_id":"244843581","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"187880724","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":105673,"change_date":"2022-03-29 21:42:00","inspection_id":"75167788","insp_unit_id":"187880724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PCY6162","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHG3DV0LHLW0286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:53.000000Z","updated_at":"2025-03-17T22:08:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1944533\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1944533\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1944533\/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\/1944533\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}