{"current_page":1,"data":[{"id":5665017,"change_date":"2024-05-03 21:39:00","inspection_id":"81518861","dot_number":"3904429","report_state":"TX","report_number":"6UW59DBA7Y","insp_date":"2024-05-02 00:00:00","insp_start_time":"0540","insp_end_time":"0555","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"A&V TANK EXPRESS LLC","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9264152","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2024-05-03 21:39:00","snet_input_date":"2024-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-03 21:39:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T20:15:04.000000Z","updated_at":"2025-03-17T20:15:04.000000Z","inspection_violations":[{"id":8763108,"change_date":"2024-05-03 21:39:00","inspection_id":"81518861","insp_violation_id":"259307846","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200719487","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:24.000000Z","updated_at":"2025-03-17T21:48:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9124209,"change_date":"2024-05-03 21:39:00","inspection_id":"81518861","insp_unit_id":"200719487","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"02","insp_unit_license":"1M76533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDT9X1YD536670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"},{"id":9124210,"change_date":"2024-05-03 21:39:00","inspection_id":"81518861","insp_unit_id":"200719488","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"092B523","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN4126X7T06733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"}]},{"id":4990808,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","dot_number":"3904429","report_state":"TX","report_number":"V241318546","insp_date":"2024-02-01 00:00:00","insp_start_time":"1015","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"24133 IH69 NB SVC RD","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON CEMENT","shipping_paper_number":"722260450","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":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"13","oos_total":"5","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9189937","transaction_code":"C","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-02-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7688177,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767214","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"38323A2"},{"id":7688178,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767215","seq_no":"2","part_no":"393","part_no_section":"104(d)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"393104D"},{"id":7688179,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767216","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39345B2"},{"id":7688180,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767217","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39375A3"},{"id":7688181,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767218","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39375A3"},{"id":7688182,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767219","seq_no":"6","part_no":"393","part_no_section":"75(e)","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39375E"},{"id":7688183,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767220","seq_no":"7","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39378"},{"id":7688184,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767221","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3939A"},{"id":7688185,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767222","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3939A"},{"id":7688186,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767223","seq_no":"10","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39395F"},{"id":7688187,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767224","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39617C"},{"id":7688188,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767225","seq_no":"12","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199359905","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39617C"},{"id":7688189,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_violation_id":"257767226","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199359906","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8032723,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_unit_id":"199359905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"04","insp_unit_license":"T1655305","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1XPFDU9X15D858470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"},{"id":8032724,"change_date":"2024-02-09 21:42:00","inspection_id":"80783287","insp_unit_id":"199359906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"T04","insp_unit_license":"092B523","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN4126X7T06733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4572067,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","dot_number":"3904429","report_state":"TX","report_number":"6QKA9DCILA","insp_date":"2023-11-28 00:00:00","insp_start_time":"1050","insp_end_time":"1120","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":"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-12-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9141081","transaction_code":"A","transaction_date":"2023-12-06 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2023-12-06 21:42:00","snet_input_date":"2023-11-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:53:25.000000Z","updated_at":"2025-03-17T19:53:25.000000Z","inspection_violations":[{"id":7072353,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750751","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"},{"id":7072354,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750752","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"},{"id":7072355,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750753","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"},{"id":7072356,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750754","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"},{"id":7072357,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750755","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"},{"id":7072358,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_violation_id":"256750756","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198381367","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":7353636,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_unit_id":"198381366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M61869","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG23LK21429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"},{"id":7353637,"change_date":"2023-12-06 21:42:00","inspection_id":"80325228","insp_unit_id":"198381367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"5026259","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HTSN422667U10863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"}]},{"id":3698986,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","dot_number":"3904429","report_state":"TX","report_number":"6NCF9DCE44","insp_date":"2023-08-04 00:00:00","insp_start_time":"1439","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  DACOMA ST","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":"120000","viol_total":"19","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"17","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9047794","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":"03904429","upload_search_indicator":"M","census_search_date":"2023-08-08 21:42:00","snet_input_date":"2023-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-08 21:42:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[{"id":5704446,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542479","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39375A3"},{"id":5704447,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542480","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3965B"},{"id":5704448,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542481","seq_no":"3","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39375A2"},{"id":5704449,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542482","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39141A"},{"id":5704450,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542483","seq_no":"5","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"38323A2"},{"id":5704451,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542484","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39395F"},{"id":5704452,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542485","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39395A"},{"id":5704453,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542486","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3922"},{"id":5704454,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542487","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39617C"},{"id":5704455,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542488","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3922"},{"id":5704456,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542489","seq_no":"11","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39378"},{"id":5704457,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542490","seq_no":"12","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39378"},{"id":5704458,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542491","seq_no":"13","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39379"},{"id":5704459,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542492","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3939A"},{"id":5704460,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542493","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3939A"},{"id":5704461,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542494","seq_no":"16","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39330"},{"id":5704462,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542495","seq_no":"17","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"3939A"},{"id":5704463,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542496","seq_no":"18","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196431091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39311"},{"id":5704464,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_violation_id":"254542497","seq_no":"19","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"196431092","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:26.000000Z","updated_at":"2025-03-17T21:33:26.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5947489,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_unit_id":"196431091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"T1435737","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FUJA6CG23LK21429","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":5947490,"change_date":"2023-08-08 21:42:00","inspection_id":"79357348","insp_unit_id":"196431092","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1734","insp_unit_license":"5026259","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HTSN422667U10863","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":3645083,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","dot_number":"3904429","report_state":"TX","report_number":"6N689DCOOJ","insp_date":"2023-07-29 00:00:00","insp_start_time":"0819","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 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":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-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9042056","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[{"id":5620782,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_violation_id":"254405153","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"38323A2"},{"id":5620783,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_violation_id":"254405154","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39141A"},{"id":5620784,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_violation_id":"254405155","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196307466","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39617C"},{"id":5620785,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_violation_id":"254405156","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196307466","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3922"},{"id":5620786,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_violation_id":"254405157","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196307467","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5861056,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_unit_id":"196307466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"03","insp_unit_license":"T1435737","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FUJA6CG23LK21429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"},{"id":5861057,"change_date":"2023-08-01 21:42:00","inspection_id":"79296876","insp_unit_id":"196307467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"1734","insp_unit_license":"5026259","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5HTSN422667U10863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"}]},{"id":3645000,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","dot_number":"3904429","report_state":"TX","report_number":"6N379DBBJU","insp_date":"2023-07-26 00:00:00","insp_start_time":"0739","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KATY HOCKLEY RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SESCO","shipping_paper_number":"9564800","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-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"13","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9041453","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[{"id":5620476,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404775","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3922"},{"id":5620477,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404776","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"196307295","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39375A3"},{"id":5620478,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404777","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39375C"},{"id":5620479,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404778","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39375C"},{"id":5620480,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404779","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3922"},{"id":5620481,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404780","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39311"},{"id":5620482,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404781","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39617C"},{"id":5620483,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404782","seq_no":"8","part_no":"387","part_no_section":"7(a)","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3877A"},{"id":5620484,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404783","seq_no":"9","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"196307294","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39021A"},{"id":5620485,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404784","seq_no":"10","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"196307295","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39347G"},{"id":5620486,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404785","seq_no":"11","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"196307295","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39347G"},{"id":5620487,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404786","seq_no":"12","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"196307295","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39347G"},{"id":5620488,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_violation_id":"254404787","seq_no":"13","part_no":"393","part_no_section":"47(g)","insp_viol_unit":"2","insp_unit_id":"196307295","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39347G"}],"inspection_per_units":[{"id":5860913,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_unit_id":"196307294","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"79T145M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6AV22LJ84785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"},{"id":5860914,"change_date":"2023-08-01 21:42:00","inspection_id":"79296782","insp_unit_id":"196307295","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"092B523","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN4126X7T06733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"}]},{"id":2327850,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","dot_number":"3904429","report_state":"TX","report_number":"6IAA9DGTON","insp_date":"2023-02-03 00:00:00","insp_start_time":"1009","insp_end_time":"1052","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12200  EAST FWY SOUT","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-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8898806","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2023-02-08 21:39:00","snet_input_date":"2023-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[{"id":3585132,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_violation_id":"251023413","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193299404","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"39378"},{"id":3585133,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_violation_id":"251023414","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193299404","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"3939A"},{"id":3585134,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_violation_id":"251023415","seq_no":"3","part_no":"393","part_no_section":"50(b)","insp_viol_unit":"2","insp_unit_id":"193299405","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"39350B"},{"id":3585135,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_violation_id":"251023416","seq_no":"4","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"193299404","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"393209E"},{"id":3585136,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_violation_id":"251023417","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193299404","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3746428,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_unit_id":"193299404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"830491G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDT9X1YD536670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"},{"id":3746429,"change_date":"2023-02-08 21:39:00","inspection_id":"77806291","insp_unit_id":"193299405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"01","insp_unit_license":"092B523","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN4126X7T06733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"}]},{"id":2350492,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","dot_number":"3904429","report_state":"TX","report_number":"6I789DCI9T","insp_date":"2023-01-31 00:00:00","insp_start_time":"0825","insp_end_time":"0900","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":"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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8900473","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03904429","upload_search_indicator":"M","census_search_date":"2023-02-10 21:40:00","snet_input_date":"2023-01-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"A&V TANK EXPRESS LLC","insp_carrier_street":"1405 LAKE CITY LN","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047-1251","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1046957","created_at":"2025-03-17T19:09:58.000000Z","updated_at":"2025-03-17T19:09:58.000000Z","inspection_violations":[{"id":3621105,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082078","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193351038","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"3922"},{"id":3621106,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082079","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193351038","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39617C"},{"id":3621107,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082080","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193351038","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39378"},{"id":3621108,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082081","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"38323A2"},{"id":3621109,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082082","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39141A"},{"id":3621110,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_violation_id":"251082083","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193351039","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3782832,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_unit_id":"193351038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"728733G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDT9X1YD536670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:05.000000Z","updated_at":"2025-03-17T22:33:05.000000Z"},{"id":3782833,"change_date":"2023-02-10 21:40:00","inspection_id":"77832416","insp_unit_id":"193351039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":null,"insp_unit_license":"092B523","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5HTSN4126X7T06733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:05.000000Z","updated_at":"2025-03-17T22:33:05.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3904429\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3904429\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3904429\/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\/3904429\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}