{"current_page":1,"data":[{"id":9989333,"change_date":"2025-10-20 21:40:00","inspection_id":"86098981","dot_number":"537119","report_state":"TX","report_number":"V252079944","insp_date":"2025-10-16 00:00:00","insp_start_time":"1155","insp_end_time":"1207","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311 DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-20 21:40: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":"9731988","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":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-10-23T10:00:46.000000Z","updated_at":"2025-10-24T10:01:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16588259,"change_date":"2025-10-20 21:40:00","inspection_id":"86098981","insp_unit_id":"209563164","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1221","insp_unit_license":"3MBP241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA8CW065994","insp_unit_decal":"Y","insp_unit_decal_number":"35677398","created_at":"2025-10-23T09:45:52.000000Z","updated_at":"2025-10-24T09:46:34.000000Z"}]},{"id":9989335,"change_date":"2025-10-20 21:40:00","inspection_id":"86098983","dot_number":"537119","report_state":"TX","report_number":"V252079946","insp_date":"2025-10-16 00:00:00","insp_start_time":"1235","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311 DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"9731993","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":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-10-23T10:00:46.000000Z","updated_at":"2025-10-24T10:01:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16588261,"change_date":"2025-10-20 21:40:00","inspection_id":"86098983","insp_unit_id":"209563166","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1120","insp_unit_license":"T84217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC1AB0B2047729","insp_unit_decal":"Y","insp_unit_decal_number":"35677400","created_at":"2025-10-23T09:45:52.000000Z","updated_at":"2025-10-24T09:46:34.000000Z"}]},{"id":9999400,"change_date":"2025-10-21 21:39:00","inspection_id":"86109519","dot_number":"537119","report_state":"TX","report_number":"79O99DFI19","insp_date":"2025-10-16 00:00:00","insp_start_time":"1140","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311  DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9732719","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-10-24T10:01:58.000000Z","updated_at":"2025-10-25T10:01:01.000000Z","inspection_violations":[{"id":16525457,"change_date":"2025-10-21 21:39:00","inspection_id":"86109519","insp_violation_id":"269430196","seq_no":"1","part_no":"393","part_no_section":"62A","insp_viol_unit":"1","insp_unit_id":"209582593","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-24T10:18:04.000000Z","updated_at":"2025-10-25T10:16:29.000000Z","normalized_code":"39362A"},{"id":16525458,"change_date":"2025-10-21 21:39:00","inspection_id":"86109519","insp_violation_id":"269430197","seq_no":"2","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"209582593","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:04.000000Z","updated_at":"2025-10-25T10:16:29.000000Z","normalized_code":"3963A1B"},{"id":16525459,"change_date":"2025-10-21 21:39:00","inspection_id":"86109519","insp_violation_id":"269430198","seq_no":"3","part_no":"395","part_no_section":"8F11","insp_viol_unit":"1","insp_unit_id":"209582593","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:04.000000Z","updated_at":"2025-10-25T10:16:29.000000Z","normalized_code":"3958F11"}],"inspection_per_units":[{"id":16606497,"change_date":"2025-10-21 21:39:00","inspection_id":"86109519","insp_unit_id":"209582593","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"1222","insp_unit_license":"3MBP242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA0CW066010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:09.000000Z","updated_at":"2025-10-25T09:46:12.000000Z"}]},{"id":10047468,"change_date":"2025-10-27 21:39:00","inspection_id":"86160109","dot_number":"537119","report_state":"TX","report_number":"V252080110","insp_date":"2025-10-16 00:00:00","insp_start_time":"1215","insp_end_time":"1225","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"DECKER LAKE RD","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BILLS","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-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9737573","transaction_code":"A","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-10-30T10:00:49.000000Z","updated_at":"2025-11-01T10:01:14.000000Z","inspection_violations":[{"id":16626804,"change_date":"2025-10-27 21:39:00","inspection_id":"86160109","insp_violation_id":"269546024","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209678952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-30T10:16:06.000000Z","updated_at":"2025-10-31T10:17:08.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":16695062,"change_date":"2025-10-27 21:39:00","inspection_id":"86160109","insp_unit_id":"209678952","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VANM","insp_unit_company":"0719","insp_unit_license":"T82183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B172047270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:54.000000Z","updated_at":"2025-10-31T09:46:30.000000Z"}]},{"id":10108134,"change_date":"2025-11-03 21:39:00","inspection_id":"86224064","dot_number":"537119","report_state":"TX","report_number":"79OF9DKC84","insp_date":"2025-10-16 00:00:00","insp_start_time":"1519","insp_end_time":"1541","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-3177 IN TRAVIS CO. (434-438","county_code_state":"TX","county_code":"453","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":"2025-11-03 21:39: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":"9744061","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-11-06T10:30:44.000000Z","updated_at":"2025-11-07T10:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16810049,"change_date":"2025-11-03 21:39:00","inspection_id":"86224064","insp_unit_id":"209809021","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":null,"insp_unit_license":"3MBP242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA0CW066010","insp_unit_decal":"Y","insp_unit_decal_number":"35656192","created_at":"2025-11-06T10:00:38.000000Z","updated_at":"2025-11-07T10:01:08.000000Z"}]},{"id":7004707,"change_date":"2024-10-21 21:41:00","inspection_id":"82955886","dot_number":"537119","report_state":"TX","report_number":"V241629063","insp_date":"2024-10-17 00:00:00","insp_start_time":"1249","insp_end_time":"1318","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"DECKER LANE","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BILL'S","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9406994","transaction_code":"A","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":10930046,"change_date":"2024-10-21 21:41:00","inspection_id":"82955886","insp_violation_id":"262463946","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203505890","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"39311"},{"id":10930047,"change_date":"2024-10-21 21:41:00","inspection_id":"82955886","insp_violation_id":"262463947","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203505890","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3965B"},{"id":10930048,"change_date":"2024-10-21 21:41:00","inspection_id":"82955886","insp_violation_id":"262463948","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203505890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11298476,"change_date":"2024-10-21 21:41:00","inspection_id":"82955886","insp_unit_id":"203505890","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"1120","insp_unit_license":"T84217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC1AB0B2047729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"}]},{"id":7026985,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","dot_number":"537119","report_state":"TX","report_number":"V241557370","insp_date":"2024-10-17 00:00:00","insp_start_time":"1318","insp_end_time":"1357","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"DECKER LAKE RD","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9409964","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10967758,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","insp_violation_id":"262518463","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"203550987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39319"},{"id":10967759,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","insp_violation_id":"262518464","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203550987","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3939TS"},{"id":10967760,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","insp_violation_id":"262518465","seq_no":"3","part_no":"395","part_no_section":"24D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39524D"},{"id":10967761,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","insp_violation_id":"262518466","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203550987","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11333160,"change_date":"2024-10-23 21:42:00","inspection_id":"82979557","insp_unit_id":"203550987","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1222","insp_unit_license":"3MBP242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA0CW066010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":7040449,"change_date":"2024-10-25 21:41:00","inspection_id":"82993780","dot_number":"537119","report_state":"TX","report_number":"V241652052","insp_date":"2024-10-17 00:00:00","insp_start_time":"1238","insp_end_time":"1256","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"DECKER LAKE RD","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"9410816","transaction_code":"C","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-03-17T20:42:58.000000Z","updated_at":"2025-03-17T20:42:58.000000Z","inspection_violations":[{"id":10988224,"change_date":"2024-10-25 21:41:00","inspection_id":"82993780","insp_violation_id":"262568727","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"203595859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"3963A1"},{"id":10988225,"change_date":"2024-10-25 21:41:00","inspection_id":"82993780","insp_violation_id":"262568728","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203595859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11354695,"change_date":"2024-10-25 21:41:00","inspection_id":"82993780","insp_unit_id":"203595859","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1221","insp_unit_license":"3MBP241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA8CW065994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":7040452,"change_date":"2024-10-24 21:42:00","inspection_id":"82993783","dot_number":"537119","report_state":"TX","report_number":"V241652065","insp_date":"2024-10-17 00:00:00","insp_start_time":"1254","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"DECKER LAKE RD","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9410802","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"268020","insp_interstate":"Y","insp_carrier_state_id":"0071286","created_at":"2025-03-17T20:42:58.000000Z","updated_at":"2025-03-17T20:42:58.000000Z","inspection_violations":[{"id":10988253,"change_date":"2024-10-24 21:42:00","inspection_id":"82993783","insp_violation_id":"262546664","seq_no":"1","part_no":"393","part_no_section":"62C","insp_viol_unit":"1","insp_unit_id":"203577131","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:17.000000Z","updated_at":"2025-03-17T21:59:17.000000Z","normalized_code":"39362C"}],"inspection_per_units":[{"id":11354700,"change_date":"2024-10-24 21:42:00","inspection_id":"82993783","insp_unit_id":"203577131","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"0718","insp_unit_license":"3MBP244","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B472047344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6434397,"change_date":"2024-08-10 21:31:00","inspection_id":"82348617","dot_number":"537119","report_state":"US","report_number":"1750001112","insp_date":"2024-08-09 00:00:00","insp_start_time":"1108","insp_end_time":"1138","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CORPUS CHRISTI TX","county_code_state":"TX","county_code":"355","insp_level_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2024-08-10 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","viol_total":"1","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":"732627","transaction_code":"A","transaction_date":"2024-08-10 00:00:00","upload_date":"2024-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":null,"census_search_date":"2024-08-10 21:31:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-10 21:31:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9992643,"change_date":"2024-08-10 21:31:00","inspection_id":"82348617","insp_violation_id":"261118775","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"202324910","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":10370152,"change_date":"2024-08-10 21:31:00","inspection_id":"82348617","insp_unit_id":"202324910","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VAN HOOL B","insp_unit_company":"0719","insp_unit_license":"T82183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B172047270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:30.000000Z","updated_at":"2025-03-17T23:30:30.000000Z"}]},{"id":6434398,"change_date":"2024-08-10 21:31:00","inspection_id":"82348618","dot_number":"537119","report_state":"US","report_number":"1750001111","insp_date":"2024-08-09 00:00:00","insp_start_time":"1032","insp_end_time":"1105","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CORPUS CHRISTI TX","county_code_state":"TX","county_code":"355","insp_level_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2024-08-10 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"732626","transaction_code":"A","transaction_date":"2024-08-10 00:00:00","upload_date":"2024-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":null,"census_search_date":"2024-08-10 21:31:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-10 21:31:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10370153,"change_date":"2024-08-10 21:31:00","inspection_id":"82348618","insp_unit_id":"202324911","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VAN HOOL B","insp_unit_company":"0718","insp_unit_license":"3MBP244","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B472047344","insp_unit_decal":"Y","insp_unit_decal_number":"34402547","created_at":"2025-03-17T23:30:30.000000Z","updated_at":"2025-03-17T23:30:30.000000Z"}]},{"id":6440308,"change_date":"2024-08-12 21:42:00","inspection_id":"82354999","dot_number":"537119","report_state":"US","report_number":"1750001113","insp_date":"2024-08-09 00:00:00","insp_start_time":"1138","insp_end_time":"1220","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CORPUS CHRISTI TX","county_code_state":"TX","county_code":"355","insp_level_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2024-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"738559","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:38.000000Z","updated_at":"2025-03-17T20:30:38.000000Z","inspection_violations":[{"id":10002013,"change_date":"2024-08-12 21:42:00","inspection_id":"82354999","insp_violation_id":"261131044","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202336347","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:25.000000Z","updated_at":"2025-03-17T21:54:25.000000Z","normalized_code":"3963A1"},{"id":10002014,"change_date":"2024-08-12 21:42:00","inspection_id":"82354999","insp_violation_id":"261131045","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202336347","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:25.000000Z","updated_at":"2025-03-17T21:54:25.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":10380055,"change_date":"2024-08-12 21:42:00","inspection_id":"82354999","insp_unit_id":"202336347","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":"1222","insp_unit_license":"3MBP242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA0CW066010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:36.000000Z","updated_at":"2025-03-17T23:30:36.000000Z"}]},{"id":4264910,"change_date":"2023-10-23 21:42:00","inspection_id":"79986418","dot_number":"537119","report_state":"TX","report_number":"V231205574","insp_date":"2023-10-19 00:00:00","insp_start_time":"1150","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311 DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9107439","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0071286","created_at":"2025-03-17T19:47:25.000000Z","updated_at":"2025-03-17T19:47:25.000000Z","inspection_violations":[{"id":6598364,"change_date":"2023-10-23 21:42:00","inspection_id":"79986418","insp_violation_id":"255997926","seq_no":"1","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"197705120","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":6859246,"change_date":"2023-10-23 21:42:00","inspection_id":"79986418","insp_unit_id":"197705120","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1222","insp_unit_license":"3MBP242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA0CW066010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"}]},{"id":4286858,"change_date":"2023-10-25 21:42:00","inspection_id":"80010718","dot_number":"537119","report_state":"TX","report_number":"V231205641","insp_date":"2023-10-19 00:00:00","insp_start_time":"1308","insp_end_time":"1318","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30  17'31.48\"N L","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BILLS SPARKLING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9109636","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0071286","created_at":"2025-03-17T19:47:51.000000Z","updated_at":"2025-03-17T19:47:51.000000Z","inspection_violations":[{"id":6632298,"change_date":"2023-10-25 21:42:00","inspection_id":"80010718","insp_violation_id":"256050995","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197751720","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:56.000000Z","updated_at":"2025-03-17T21:37:56.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6894596,"change_date":"2023-10-25 21:42:00","inspection_id":"80010718","insp_unit_id":"197751720","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"2011","insp_unit_license":"T84217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC1AB0B2047729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:47.000000Z","updated_at":"2025-03-17T22:57:47.000000Z"}]},{"id":4344418,"change_date":"2023-11-02 21:42:00","inspection_id":"80074288","dot_number":"537119","report_state":"TX","report_number":"6PGD9DKC0R","insp_date":"2023-10-19 00:00:00","insp_start_time":"1319","insp_end_time":"1338","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-3177 IN TRAVIS CO. (434-438","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37800","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":"9116278","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0071286","created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[{"id":6721155,"change_date":"2023-11-02 21:42:00","inspection_id":"80074288","insp_violation_id":"256197157","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197885921","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:22.000000Z","updated_at":"2025-03-17T21:38:22.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6987074,"change_date":"2023-11-02 21:42:00","inspection_id":"80074288","insp_unit_id":"197885921","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":null,"insp_unit_license":"3MBP241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2MG3JMBA8CW065994","insp_unit_decal":"Y","insp_unit_decal_number":"33436370","created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"}]},{"id":4425307,"change_date":"2023-11-14 21:42:00","inspection_id":"80163856","dot_number":"537119","report_state":"TX","report_number":"6PGF9DSH3V","insp_date":"2023-10-19 00:00:00","insp_start_time":"1608","insp_end_time":"1631","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311  DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"9124690","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0071286","created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7116866,"change_date":"2023-11-14 21:42:00","inspection_id":"80163856","insp_unit_id":"198062033","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"0719","insp_unit_license":"T82183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B172047270","insp_unit_decal":"Y","insp_unit_decal_number":"33310563","created_at":"2025-03-17T22:59:45.000000Z","updated_at":"2025-03-17T22:59:45.000000Z"}]},{"id":4425332,"change_date":"2023-11-14 21:42:00","inspection_id":"80163883","dot_number":"537119","report_state":"TX","report_number":"6PGC9DSH3Q","insp_date":"2023-10-19 00:00:00","insp_start_time":"1251","insp_end_time":"1303","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7311  DECKER LN","county_code_state":"TX","county_code":"453","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50700","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":"9124685","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00537119","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"BILLS SPARKLING CITY CHARTER INC","insp_carrier_street":"1726 RHEW RD","insp_carrier_city":"CORPUS CHRISTI","insp_carrier_state":"TX","insp_carrier_zip_code":"78409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0071286","created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[{"id":6847861,"change_date":"2023-11-14 21:42:00","inspection_id":"80163883","insp_violation_id":"256396077","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"198062080","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39383G"},{"id":6847862,"change_date":"2023-11-14 21:42:00","inspection_id":"80163883","insp_violation_id":"256396078","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198062080","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7116908,"change_date":"2023-11-14 21:42:00","inspection_id":"80163883","insp_unit_id":"198062080","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"0719","insp_unit_license":"T82183","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"YE2CC17B172047270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:45.000000Z","updated_at":"2025-03-17T22:59:45.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/537119\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/537119\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/537119\/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\/537119\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}