{"current_page":1,"data":[{"id":10611766,"change_date":"2026-01-09 21:39:00","inspection_id":"86751673","dot_number":"3062587","report_state":"TX","report_number":"7BZ99DST0A","insp_date":"2026-01-07 00:00:00","insp_start_time":"0938","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN COLLIN CO. (630-1285","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","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":"9811627","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2026-01-09 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-09 21:39:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2026-01-12T10:34:47.000000Z","updated_at":"2026-01-20T10:30:49.000000Z","inspection_violations":[{"id":17841108,"change_date":"2026-01-09 21:39:00","inspection_id":"86751673","insp_violation_id":"271112133","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211001818","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-12T10:39:35.000000Z","updated_at":"2026-01-20T10:31:25.000000Z","normalized_code":"39617C"},{"id":17841109,"change_date":"2026-01-09 21:39:00","inspection_id":"86751673","insp_violation_id":"271112134","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211001819","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-12T10:39:35.000000Z","updated_at":"2026-01-20T10:31:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17791699,"change_date":"2026-01-09 21:39:00","inspection_id":"86751673","insp_unit_id":"211001818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"WRB9398","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HTXSEC58695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:48.000000Z","updated_at":"2026-01-20T10:00:53.000000Z"},{"id":17791700,"change_date":"2026-01-09 21:39:00","inspection_id":"86751673","insp_unit_id":"211001819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"924361M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4126P6274446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:48.000000Z","updated_at":"2026-01-20T10:00:53.000000Z"}]},{"id":9206252,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","dot_number":"3062587","report_state":"TX","report_number":"775D9DKF6N","insp_date":"2025-07-17 00:00:00","insp_start_time":"1302","insp_end_time":"1335","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"190000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9643994","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-07-25T10:45:32.000000Z","inspection_violations":[{"id":14880548,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_violation_id":"267542998","seq_no":"1","part_no":"392","part_no_section":"9A1","insp_viol_unit":"2","insp_unit_id":"207989008","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"3929A1"},{"id":14880549,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_violation_id":"267542999","seq_no":"2","part_no":"392","part_no_section":"9A2","insp_viol_unit":"2","insp_unit_id":"207989008","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"3929A2"},{"id":14880550,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_violation_id":"267543000","seq_no":"3","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"207989008","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"393130"},{"id":14880551,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_violation_id":"267543001","seq_no":"4","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"207989008","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":15134901,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_unit_id":"207989007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BHU-1","insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:37.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"},{"id":15134902,"change_date":"2025-07-21 21:41:00","inspection_id":"85275732","insp_unit_id":"207989008","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"219C217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKR00511NM128653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:37.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"}]},{"id":8818162,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","dot_number":"3062587","report_state":"TX","report_number":"V251894805","insp_date":"2025-06-02 00:00:00","insp_start_time":"1142","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US75 SB SVC RD \/ COL","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITIES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"9598674","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-06-07T10:01:09.000000Z","updated_at":"2025-06-09T10:00:45.000000Z","inspection_violations":[{"id":14113213,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","insp_violation_id":"266668132","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207228845","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:17:02.000000Z","updated_at":"2025-06-08T10:17:57.000000Z","normalized_code":"3939"},{"id":14113214,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","insp_violation_id":"266668133","seq_no":"2","part_no":"392","part_no_section":"2WC","insp_viol_unit":"2","insp_unit_id":"207228846","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:17:02.000000Z","updated_at":"2025-06-08T10:17:57.000000Z","normalized_code":"3922WC"},{"id":14113215,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","insp_violation_id":"266668134","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207228845","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-07T10:17:02.000000Z","updated_at":"2025-06-08T10:17:57.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14435495,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","insp_unit_id":"207228845","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"0","insp_unit_license":"TVL6538","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK88DZ66482","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:19.000000Z","updated_at":"2025-06-08T09:46:06.000000Z"},{"id":14435496,"change_date":"2025-06-04 21:41:00","inspection_id":"84865924","insp_unit_id":"207228846","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"0","insp_unit_license":"600032M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1V9CR46298N062336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:19.000000Z","updated_at":"2025-06-08T09:46:06.000000Z"}]},{"id":7585234,"change_date":"2025-01-09 21:41:00","inspection_id":"83568262","dot_number":"3062587","report_state":"TX","report_number":"V251584673","insp_date":"2025-01-07 00:00:00","insp_start_time":"1533","insp_end_time":"1556","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX114 EB","county_code_state":"TX","county_code":"121","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITIES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"210280","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":"9470577","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2025-01-09 21:41:00","snet_input_date":"2025-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-09 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12238918,"change_date":"2025-01-09 21:41:00","inspection_id":"83568262","insp_unit_id":"204732858","insp_unit_type_id":"6","insp_unit_number":"3","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"219C217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKR00511NM128653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"},{"id":12238919,"change_date":"2025-01-09 21:41:00","inspection_id":"83568262","insp_unit_id":"204732859","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9771","insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"},{"id":12238920,"change_date":"2025-01-09 21:41:00","inspection_id":"83568262","insp_unit_id":"204732860","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":null,"insp_unit_license":"219C215","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ05331NM128652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:05.000000Z","updated_at":"2025-03-17T23:50:05.000000Z"}]},{"id":6953303,"change_date":"2024-10-14 21:37:00","inspection_id":"82901228","dot_number":"3062587","report_state":"TX","report_number":"6ZCE9DSTD2","insp_date":"2024-10-09 00:00:00","insp_start_time":"1401","insp_end_time":"1418","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN COLLIN CO. (630-1285","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","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-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","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":"9400489","transaction_code":"A","transaction_date":"2024-10-14 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T20:41:02.000000Z","updated_at":"2025-03-17T20:41:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11215270,"change_date":"2024-10-14 21:37:00","inspection_id":"82901228","insp_unit_id":"203398986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PKD8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HT0MEC15244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:08.000000Z","updated_at":"2025-03-17T23:39:08.000000Z"},{"id":11215271,"change_date":"2024-10-14 21:37:00","inspection_id":"82901228","insp_unit_id":"203398987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"924361M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HT0MEC15244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:08.000000Z","updated_at":"2025-03-17T23:39:08.000000Z"}]},{"id":6480513,"change_date":"2024-08-15 21:43:00","inspection_id":"82397863","dot_number":"3062587","report_state":"TX","report_number":"V241496415","insp_date":"2024-08-14 00:00:00","insp_start_time":"1012","insp_end_time":"1039","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US75 NB SVC RD","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COMPANY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"9351554","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2024-08-15 21:43:00","snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-15 21:43:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T20:31:31.000000Z","updated_at":"2025-03-17T20:31:31.000000Z","inspection_violations":[{"id":10063539,"change_date":"2024-08-15 21:43:00","inspection_id":"82397863","insp_violation_id":"261219941","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202419110","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39375A3"},{"id":10063540,"change_date":"2024-08-15 21:43:00","inspection_id":"82397863","insp_violation_id":"261219942","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202419110","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"39617C"},{"id":10063541,"change_date":"2024-08-15 21:43:00","inspection_id":"82397863","insp_violation_id":"261219943","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202419110","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:43.000000Z","updated_at":"2025-03-17T21:54:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10445791,"change_date":"2024-08-15 21:43:00","inspection_id":"82397863","insp_unit_id":"202419110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"TFF3847","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV9GDFZ4022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:15.000000Z","updated_at":"2025-03-17T23:31:15.000000Z"}]},{"id":5966925,"change_date":"2024-06-11 21:43:00","inspection_id":"81846549","dot_number":"3062587","report_state":"TX","report_number":"V241450815","insp_date":"2024-06-07 00:00:00","insp_start_time":"1311","insp_end_time":"1342","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX114 EB AT IRON HOR","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR","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-06-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9298381","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2024-06-11 21:43:00","snet_input_date":"2024-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-11 21:43:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T20:21:03.000000Z","updated_at":"2025-03-17T20:21:03.000000Z","inspection_violations":[{"id":9256735,"change_date":"2024-06-11 21:43:00","inspection_id":"81846549","insp_violation_id":"260031116","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201345194","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"39617C"},{"id":9256736,"change_date":"2024-06-11 21:43:00","inspection_id":"81846549","insp_violation_id":"260031117","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201345194","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:45.000000Z","updated_at":"2025-03-17T21:50:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9611319,"change_date":"2024-06-11 21:43:00","inspection_id":"81846549","insp_unit_id":"201345194","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TFF3874","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FMJK1HT0MEA78608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:40.000000Z","updated_at":"2025-03-17T23:22:40.000000Z"}]},{"id":5513359,"change_date":"2024-04-15 21:41:00","inspection_id":"81353627","dot_number":"3062587","report_state":"TX","report_number":"V241369195","insp_date":"2024-04-12 00:00:00","insp_start_time":"0911","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2903 US380 EB","county_code_state":"TX","county_code":"085","insp_level_id":"2","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-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9248421","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2024-04-15 21:41:00","snet_input_date":"2024-04-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-15 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T20:11:58.000000Z","updated_at":"2025-03-17T20:11:58.000000Z","inspection_violations":[{"id":8518230,"change_date":"2024-04-15 21:41:00","inspection_id":"81353627","insp_violation_id":"258937238","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3929A1"},{"id":8518231,"change_date":"2024-04-15 21:41:00","inspection_id":"81353627","insp_violation_id":"258937239","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200401729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8881067,"change_date":"2024-04-15 21:41:00","inspection_id":"81353627","insp_unit_id":"200401729","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TFF3847","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHG3DV9GDFZ4022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:38.000000Z","updated_at":"2025-03-17T23:15:38.000000Z"}]},{"id":4274565,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","dot_number":"3062587","report_state":"TX","report_number":"6PFA9DGU6M","insp_date":"2023-10-18 00:00:00","insp_start_time":"1009","insp_end_time":"1132","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  HARRY MCKILLOP","county_code_state":"TX","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITIES LLC","shipping_paper_number":"S133284","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","viol_total":"11","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9108393","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[{"id":6611485,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019270","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:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"38323A2"},{"id":6611486,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019271","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:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39141A"},{"id":6611487,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019272","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3939A"},{"id":6611488,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019273","seq_no":"3","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"197725916","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"393104B"},{"id":6611489,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019274","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39395A"},{"id":6611490,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019275","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197725916","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"},{"id":6611491,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019276","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"},{"id":6611492,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019277","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39617C"},{"id":6611493,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019278","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197725916","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39617C"},{"id":6611494,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019279","seq_no":"10","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39341"},{"id":6611495,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_violation_id":"256019280","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197725915","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6874857,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_unit_id":"197725915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PKD8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HT0MEC15244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:38.000000Z","updated_at":"2025-03-17T22:57:38.000000Z"},{"id":6874858,"change_date":"2023-10-24 21:40:00","inspection_id":"79997145","insp_unit_id":"197725916","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"508000M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F382XL6088080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:38.000000Z","updated_at":"2025-03-17T22:57:38.000000Z"}]},{"id":2743579,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","dot_number":"3062587","report_state":"TX","report_number":"6JGA9DPN1T","insp_date":"2023-03-17 00:00:00","insp_start_time":"0852","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0380 IN DENTON CO. (592-626","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"214380","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8947212","transaction_code":"A","transaction_date":"2023-04-05 00:00:00","upload_date":"2023-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2023-04-05 21:41:00","snet_input_date":"2023-03-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-05 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T19:17:19.000000Z","updated_at":"2025-03-17T19:17:19.000000Z","inspection_violations":[{"id":4212078,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070525","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194249301","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4212079,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070526","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194249301","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"},{"id":4212080,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070527","seq_no":"4","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"194249301","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39375G"},{"id":4212081,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070528","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194249301","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"39378"},{"id":4212082,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070529","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194249302","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3939A"},{"id":4212083,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_violation_id":"252070530","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194249302","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:41.000000Z","updated_at":"2025-03-17T21:26:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4416487,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_unit_id":"194249301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"},{"id":4416488,"change_date":"2023-04-05 21:41:00","inspection_id":"78280530","insp_unit_id":"194249302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"2196217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKR00511NM128653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:46.000000Z","updated_at":"2025-03-17T22:37:46.000000Z"}]},{"id":1824769,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","dot_number":"3062587","report_state":"TX","report_number":"6EVE9DNEGL","insp_date":"2022-10-03 00:00:00","insp_start_time":"1446","insp_end_time":"1544","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN DENTON CO. (2155-246","county_code_state":"TX","county_code":"121","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"234660","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8835974","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-11-28 21:41:00","snet_input_date":"2022-10-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T19:00:19.000000Z","updated_at":"2025-03-17T19:00:19.000000Z","inspection_violations":[{"id":2849876,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_violation_id":"249808882","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3922"},{"id":2849877,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_violation_id":"249808883","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3922"},{"id":2849878,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_violation_id":"249808884","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2935976,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_unit_id":"192151452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"001","insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"},{"id":2935977,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_unit_id":"192151453","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"219C215","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ05331NM128652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"},{"id":2935978,"change_date":"2022-11-28 21:41:00","inspection_id":"77231776","insp_unit_id":"192151454","insp_unit_type_id":"6","insp_unit_number":"3","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"219C217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKR00511NM128653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:06.000000Z","updated_at":"2025-03-17T22:27:06.000000Z"}]},{"id":987200,"change_date":"2022-09-27 21:40:00","inspection_id":"76262721","dot_number":"3062587","report_state":"TX","report_number":"6D489DFYFY","insp_date":"2022-08-01 00:00:00","insp_start_time":"0824","insp_end_time":"0900","registration_date":"2022-09-27 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0377 IN DENTON CO. (228-268","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITIES","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":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"214380","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":"8735742","transaction_code":"C","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1556688,"change_date":"2022-09-27 21:40:00","inspection_id":"76262721","insp_violation_id":"248677578","seq_no":"1","part_no":"393","part_no_section":"75(a)(4)","insp_viol_unit":"2","insp_unit_id":"191128519","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:18.000000Z","updated_at":"2025-03-17T21:14:18.000000Z","normalized_code":"39375A4"}],"inspection_per_units":[{"id":1589099,"change_date":"2022-09-27 21:40:00","inspection_id":"76262721","insp_unit_id":"191128518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"},{"id":1589100,"change_date":"2022-09-27 21:40:00","inspection_id":"76262721","insp_unit_id":"191128519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"47172P2","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ05331NM128652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:00.000000Z","updated_at":"2025-03-17T22:18:00.000000Z"}]},{"id":361087,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","dot_number":"3062587","report_state":"TX","report_number":"6AN99DKFEY","insp_date":"2022-05-04 00:00:00","insp_start_time":"0900","insp_end_time":"1012","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"13","oos_total":"6","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"8650695","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T18:33:57.000000Z","updated_at":"2025-03-17T18:33:57.000000Z","inspection_violations":[{"id":565875,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708212","seq_no":"1","part_no":"383","part_no_section":"93(b)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"38393B3"},{"id":565876,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708213","seq_no":"2","part_no":"383","part_no_section":"93(b)(4)","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:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"38393B4"},{"id":565877,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708214","seq_no":"3","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:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"38323A2"},{"id":565878,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708215","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39395A"},{"id":565879,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708216","seq_no":"5","part_no":"392","part_no_section":"8","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3928"},{"id":565880,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708217","seq_no":"6","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"107620B"},{"id":565881,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708218","seq_no":"7","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"2","insp_unit_id":"188613493","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"172504A"},{"id":565882,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708219","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39617C"},{"id":565883,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708220","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188613493","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39617C"},{"id":565884,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708221","seq_no":"10","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"188613493","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"393110B"},{"id":565885,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708222","seq_no":"11","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"39021A"},{"id":565886,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708223","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188613492","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3922"},{"id":565887,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_violation_id":"245708224","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188613493","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":584043,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_unit_id":"188613492","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"LGN6985","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3BT9KEC30703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"},{"id":584044,"change_date":"2022-05-10 21:40:00","inspection_id":"75523566","insp_unit_id":"188613493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"074617M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V1W2422N2135071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]},{"id":269467,"change_date":"2022-04-27 21:40:00","inspection_id":"75414647","dot_number":"3062587","report_state":"TX","report_number":"6A7F0XJG44","insp_date":"2022-04-18 00:00:00","insp_start_time":"1516","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITIES","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8636097","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-04-27 21:40:00","snet_input_date":"2022-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-27 21:40:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T18:32:14.000000Z","updated_at":"2025-03-17T18:32:14.000000Z","inspection_violations":[{"id":416337,"change_date":"2022-04-27 21:40:00","inspection_id":"75414647","insp_violation_id":"245422404","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:09:00.000000Z","updated_at":"2025-03-17T21:09:00.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":436516,"change_date":"2022-04-27 21:40:00","inspection_id":"75414647","insp_unit_id":"188380343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"0","insp_unit_license":"PKD8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HT0MEC15244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:53.000000Z","updated_at":"2025-03-17T22:10:53.000000Z"},{"id":436517,"change_date":"2022-04-27 21:40:00","inspection_id":"75414647","insp_unit_id":"188380344","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"0","insp_unit_license":"170146M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F382XL6088080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:53.000000Z","updated_at":"2025-03-17T22:10:53.000000Z"}]},{"id":303212,"change_date":"2022-05-02 21:41:00","inspection_id":"75454993","dot_number":"3062587","report_state":"TX","report_number":"6A7C9DLM6G","insp_date":"2022-04-18 00:00:00","insp_start_time":"1243","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"PANTHER CREEK PKWY","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BLUE STAR UTILITES","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"234660","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":"8640290","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-05-02 21:41:00","snet_input_date":"2022-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-02 21:41:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T18:32:54.000000Z","updated_at":"2025-03-17T18:32:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":490676,"change_date":"2022-05-02 21:41:00","inspection_id":"75454993","insp_unit_id":"188461682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"47172G8","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ05331NM128652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:13.000000Z","updated_at":"2025-03-17T22:11:13.000000Z"},{"id":490677,"change_date":"2022-05-02 21:41:00","inspection_id":"75454993","insp_unit_id":"188461683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9771","insp_unit_license":"1N15430","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXP4EX7PD829771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:13.000000Z","updated_at":"2025-03-17T22:11:13.000000Z"},{"id":490678,"change_date":"2022-05-02 21:41:00","inspection_id":"75454993","insp_unit_id":"188461684","insp_unit_type_id":"6","insp_unit_number":"3","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"47172P3","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKR00511NM128653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:13.000000Z","updated_at":"2025-03-17T22:11:13.000000Z"}]},{"id":13540,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","dot_number":"3062587","report_state":"TX","report_number":"69CA9DHX07","insp_date":"2022-03-18 00:00:00","insp_start_time":"0954","insp_end_time":"1027","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0114 IN TARRANT CO. (604-61","county_code_state":"TX","county_code":"439","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-03-21 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"43400","viol_total":"3","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8597388","transaction_code":"A","transaction_date":"2022-03-21 00:00:00","upload_date":"2022-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03062587","upload_search_indicator":"M","census_search_date":"2022-03-21 21:32:00","snet_input_date":"2022-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-21 21:32:00","insp_carrier_name":"BLUE STAR UTILITIES LLC","insp_carrier_street":"2600 CHAMBERS ST","insp_carrier_city":"VENUS","insp_carrier_state":"TX","insp_carrier_zip_code":"76084","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0940383","created_at":"2025-03-17T18:27:46.000000Z","updated_at":"2025-03-17T18:27:46.000000Z","inspection_violations":[{"id":19063,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","insp_violation_id":"244686919","seq_no":"1","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"187737828","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:11.000000Z","updated_at":"2025-03-17T21:07:11.000000Z","normalized_code":"39343D"},{"id":19064,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","insp_violation_id":"244686920","seq_no":"2","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"187737828","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:11.000000Z","updated_at":"2025-03-17T21:07:11.000000Z","normalized_code":"393130"},{"id":19065,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","insp_violation_id":"244686921","seq_no":"3","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"187737828","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:07:11.000000Z","updated_at":"2025-03-17T21:07:11.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":22077,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","insp_unit_id":"187737827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PKD8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD0X5HT0MEC15244","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:24.000000Z","updated_at":"2025-03-17T22:08:24.000000Z"},{"id":22078,"change_date":"2022-03-21 21:32:00","inspection_id":"75098078","insp_unit_id":"187737828","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"170146M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F382XL6088080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:24.000000Z","updated_at":"2025-03-17T22:08:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3062587\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3062587\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3062587\/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\/3062587\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}