{"current_page":1,"data":[{"id":7295470,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","dot_number":"3170964","report_state":"TX","report_number":"V241706799","insp_date":"2024-11-26 00:00:00","insp_start_time":"1550","insp_end_time":"1627","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"637  FM51","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","shipping_paper_number":"1972625224","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9439340","transaction_code":"A","transaction_date":"2024-11-27 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-27 21:40:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:48:11.000000Z","updated_at":"2025-03-17T20:48:11.000000Z","inspection_violations":[{"id":11407576,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","insp_violation_id":"263131418","seq_no":"1","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"204089862","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"393205C"},{"id":11407577,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","insp_violation_id":"263131419","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204089862","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"39375C"},{"id":11407578,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","insp_violation_id":"263131420","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204089862","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:27.000000Z","updated_at":"2025-03-17T22:01:27.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11767890,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","insp_unit_id":"204089862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"481","insp_unit_license":"173B844","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W9103220YW172481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"},{"id":11767891,"change_date":"2024-11-27 21:40:00","inspection_id":"83263729","insp_unit_id":"204089863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27","insp_unit_license":"1N43155","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:58.000000Z","updated_at":"2025-03-17T23:44:58.000000Z"}]},{"id":7280158,"change_date":"2024-11-25 21:44:00","inspection_id":"83247500","dot_number":"3170964","report_state":"TX","report_number":"V241709770","insp_date":"2024-11-22 00:00:00","insp_start_time":"1021","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX114 EB","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","shipping_paper_number":"19751100907","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9436854","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-25 21:44:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:48:06.000000Z","updated_at":"2025-03-17T20:48:06.000000Z","inspection_violations":[{"id":11381499,"change_date":"2024-11-25 21:44:00","inspection_id":"83247500","insp_violation_id":"263090306","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204055532","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:18.000000Z","updated_at":"2025-03-17T22:01:18.000000Z","normalized_code":"39378"},{"id":11381500,"change_date":"2024-11-25 21:44:00","inspection_id":"83247500","insp_violation_id":"263090307","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204055532","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:18.000000Z","updated_at":"2025-03-17T22:01:18.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":11743147,"change_date":"2024-11-25 21:44:00","inspection_id":"83247500","insp_unit_id":"204055532","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"1N43156","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"},{"id":11743148,"change_date":"2024-11-25 21:44:00","inspection_id":"83247500","insp_unit_id":"204055533","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":"3","insp_unit_license":"Y76311","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC1116266P006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":7185775,"change_date":"2024-11-13 21:40:00","inspection_id":"83147798","dot_number":"3170964","report_state":"TX","report_number":"V241607712","insp_date":"2024-11-12 00:00:00","insp_start_time":"1610","insp_end_time":"1638","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WALNUT CREEK DR AT T","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"-","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9427515","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[{"id":11229590,"change_date":"2024-11-13 21:40:00","inspection_id":"83147798","insp_violation_id":"262877310","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"203864349","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"393209E"},{"id":11229591,"change_date":"2024-11-13 21:40:00","inspection_id":"83147798","insp_violation_id":"262877311","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203864349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":11590393,"change_date":"2024-11-13 21:40:00","inspection_id":"83147798","insp_unit_id":"203864349","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"00","insp_unit_license":"RLT0660","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV7GPHT4275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:07.000000Z","updated_at":"2025-03-17T23:43:07.000000Z"}]},{"id":6934728,"change_date":"2024-10-10 21:42:00","inspection_id":"82881459","dot_number":"3170964","report_state":"TX","report_number":"V241594609","insp_date":"2024-10-08 00:00:00","insp_start_time":"1004","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:32  56'37.97\"N","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1972606412","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-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"9398585","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11184458,"change_date":"2024-10-10 21:42:00","inspection_id":"82881459","insp_unit_id":"203361952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WE28","insp_unit_license":"SLP8015","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV3JLJU5493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:48.000000Z","updated_at":"2025-03-17T23:38:48.000000Z"}]},{"id":6941522,"change_date":"2024-10-11 21:40:00","inspection_id":"82888669","dot_number":"3170964","report_state":"TX","report_number":"6ZB89DSU8M","insp_date":"2024-10-08 00:00:00","insp_start_time":"0740","insp_end_time":"0817","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SHAWNEE","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1975095940","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-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9399360","transaction_code":"A","transaction_date":"2024-10-11 00:00:00","upload_date":"2024-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-11 21:40:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:40:58.000000Z","updated_at":"2025-03-17T20:40:58.000000Z","inspection_violations":[{"id":10821247,"change_date":"2024-10-11 21:40:00","inspection_id":"82888669","insp_violation_id":"262311375","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203375352","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:58:26.000000Z","updated_at":"2025-03-17T21:58:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11195528,"change_date":"2024-10-11 21:40:00","inspection_id":"82888669","insp_unit_id":"203375352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27","insp_unit_license":"1N43155","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:56.000000Z","updated_at":"2025-03-17T23:38:56.000000Z"},{"id":11195529,"change_date":"2024-10-11 21:40:00","inspection_id":"82888669","insp_unit_id":"203375353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"00","insp_unit_license":"148B143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3427GR136861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:56.000000Z","updated_at":"2025-03-17T23:38:56.000000Z"}]},{"id":6771939,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","dot_number":"3170964","report_state":"TX","report_number":"V241575064","insp_date":"2024-09-18 00:00:00","insp_start_time":"1410","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 114 WB","county_code_state":"TX","county_code":"497","insp_level_id":"2","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":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60500","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9381894","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[{"id":10547555,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","insp_violation_id":"261931226","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"203035080","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39360C"},{"id":10547556,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","insp_violation_id":"261931227","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"203035080","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39375C"},{"id":10547557,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","insp_violation_id":"261931228","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"203035080","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"39375C"},{"id":10547558,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","insp_violation_id":"261931229","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203035080","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:05.000000Z","updated_at":"2025-03-17T21:57:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10920233,"change_date":"2024-09-19 21:42:00","inspection_id":"82708188","insp_unit_id":"203035080","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"25","insp_unit_license":"RLT0660","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV7GPHT4275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"}]},{"id":6723905,"change_date":"2024-09-13 21:42:00","inspection_id":"82657011","dot_number":"3170964","report_state":"TX","report_number":"V241559005","insp_date":"2024-09-12 00:00:00","insp_start_time":"0948","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US380 DECATUR SCALE","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HEIDELBERG","shipping_paper_number":"1972595613","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-09-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9377212","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:36:29.000000Z","updated_at":"2025-03-17T20:36:29.000000Z","inspection_violations":[{"id":10469055,"change_date":"2024-09-13 21:42:00","inspection_id":"82657011","insp_violation_id":"261797643","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:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10842199,"change_date":"2024-09-13 21:42:00","inspection_id":"82657011","insp_unit_id":"202919281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27","insp_unit_license":"1N43155","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"},{"id":10842200,"change_date":"2024-09-13 21:42:00","inspection_id":"82657011","insp_unit_id":"202919282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"481","insp_unit_license":"173B844","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W9103220YW172481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"}]},{"id":6723350,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","dot_number":"3170964","report_state":"TX","report_number":"6YKD9DPQZ7","insp_date":"2024-09-11 00:00:00","insp_start_time":"1319","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035E IN DENTON CO. (447-46","county_code_state":"TX","county_code":"121","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"19","oos_total":"5","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"18","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9376737","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:36:29.000000Z","updated_at":"2025-03-17T20:36:29.000000Z","inspection_violations":[{"id":10467512,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795711","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39347E"},{"id":10467513,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795712","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39353B"},{"id":10467514,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795713","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3963A1"},{"id":10467515,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795714","seq_no":"4","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"38323A2"},{"id":10467516,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795715","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39378"},{"id":10467517,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795716","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39345B2"},{"id":10467518,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795717","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3965B"},{"id":10467519,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795718","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3963A1"},{"id":10467520,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795719","seq_no":"9","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39347A"},{"id":10467521,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795720","seq_no":"10","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39347A"},{"id":10467522,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795721","seq_no":"11","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39347D"},{"id":10467523,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795722","seq_no":"12","part_no":"393","part_no_section":"13(c)(2)","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39313C2"},{"id":10467524,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795723","seq_no":"13","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39355D2"},{"id":10467525,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795724","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39617C"},{"id":10467526,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795725","seq_no":"15","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"},{"id":10467527,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795726","seq_no":"16","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202918164","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"},{"id":10467528,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795727","seq_no":"17","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"},{"id":10467529,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795728","seq_no":"18","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"},{"id":10467530,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_violation_id":"261795729","seq_no":"19","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"202918165","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":10841257,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_unit_id":"202918164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"1N43156","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"},{"id":10841258,"change_date":"2024-09-13 21:42:00","inspection_id":"82656438","insp_unit_id":"202918165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"148B145","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1D9SD3423ER661287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"}]},{"id":6491466,"change_date":"2024-08-16 21:40:00","inspection_id":"82409664","dot_number":"3170964","report_state":"TX","report_number":"V241505830","insp_date":"2024-08-12 00:00:00","insp_start_time":"0844","insp_end_time":"0908","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"JOHNSON RANCH LN","county_code_state":"TX","county_code":"337","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WATTS EXCAVATING","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","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":"9352532","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-16 21:40:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10079608,"change_date":"2024-08-16 21:40:00","inspection_id":"82409664","insp_violation_id":"261241780","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202441301","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10464062,"change_date":"2024-08-16 21:40:00","inspection_id":"82409664","insp_unit_id":"202441301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WE26","insp_unit_license":"1N43156","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"},{"id":10464063,"change_date":"2024-08-16 21:40:00","inspection_id":"82409664","insp_unit_id":"202441302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":"3","insp_unit_license":"Y76311","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC1116266P006286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"}]},{"id":6337384,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","dot_number":"3170964","report_state":"TX","report_number":"V241491653","insp_date":"2024-07-26 00:00:00","insp_start_time":"0653","insp_end_time":"0719","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX101 SB","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG","shipping_paper_number":"1972575410","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-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9337173","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:28:18.000000Z","updated_at":"2025-03-17T20:28:18.000000Z","inspection_violations":[{"id":9839944,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_violation_id":"260900533","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"202127829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39311"},{"id":9839945,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_violation_id":"260900534","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"202127828","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"393209E"},{"id":9839946,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_violation_id":"260900535","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202127828","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3939A"},{"id":9839947,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_violation_id":"260900536","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202127829","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3939A"},{"id":9839948,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_violation_id":"260900537","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202127829","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10212133,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_unit_id":"202127828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"26","insp_unit_license":"1N43156","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"},{"id":10212134,"change_date":"2024-07-29 21:42:00","inspection_id":"82244837","insp_unit_id":"202127829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"985","insp_unit_license":"226B413","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1R9ESB508XL008985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"}]},{"id":6074474,"change_date":"2024-06-25 21:42:00","inspection_id":"81962781","dot_number":"3170964","report_state":"TX","report_number":"V241443746","insp_date":"2024-06-21 00:00:00","insp_start_time":"1119","insp_end_time":"1137","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 380 MP 578","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"9308350","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:23:01.000000Z","updated_at":"2025-03-17T20:23:01.000000Z","inspection_violations":[{"id":9425888,"change_date":"2024-06-25 21:42:00","inspection_id":"81962781","insp_violation_id":"260305566","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"201586505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"393203C"},{"id":9425889,"change_date":"2024-06-25 21:42:00","inspection_id":"81962781","insp_violation_id":"260305567","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201586505","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3939A"},{"id":9425890,"change_date":"2024-06-25 21:42:00","inspection_id":"81962781","insp_violation_id":"260305568","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201586505","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9783738,"change_date":"2024-06-25 21:42:00","inspection_id":"81962781","insp_unit_id":"201586505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"28","insp_unit_license":"SLP8015","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV3JLJU5493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"}]},{"id":5361678,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","dot_number":"3170964","report_state":"TX","report_number":"V241309637","insp_date":"2024-03-22 00:00:00","insp_start_time":"1206","insp_end_time":"1216","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:33   11' 43.32N","county_code_state":"TX","county_code":"237","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"H5","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9231651","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"DRAWBRIDGE PIPELINE SERVICES LLC","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":8273343,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566735","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200074050","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39347E"},{"id":8273344,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566736","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200074050","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39347E"},{"id":8273345,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566737","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200074050","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39353B"},{"id":8273346,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566738","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200074049","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39375A3"},{"id":8273347,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566739","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200074050","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"39375A3"},{"id":8273348,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_violation_id":"258566740","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"200074050","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8634860,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_unit_id":"200074049","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"0","insp_unit_license":"1N10229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X3JD487987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:18.000000Z","updated_at":"2025-03-17T23:13:18.000000Z"},{"id":8634861,"change_date":"2024-03-25 21:41:00","inspection_id":"81187941","insp_unit_id":"200074050","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"ED2634","insp_unit_license":"148B143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3427GR136861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:18.000000Z","updated_at":"2025-03-17T23:13:18.000000Z"}]},{"id":4999618,"change_date":"2024-02-07 21:41:00","inspection_id":"80792985","dot_number":"3170964","report_state":"TX","report_number":"V241319411","insp_date":"2024-02-02 00:00:00","insp_start_time":"0805","insp_end_time":"0819","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 101 NB","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6708360","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130600","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":"9191522","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T20:01:41.000000Z","updated_at":"2025-03-17T20:01:41.000000Z","inspection_violations":[{"id":7701954,"change_date":"2024-02-07 21:41:00","inspection_id":"80792985","insp_violation_id":"257718288","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199316223","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3965B"},{"id":7701955,"change_date":"2024-02-07 21:41:00","inspection_id":"80792985","insp_violation_id":"257718289","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199316223","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8047145,"change_date":"2024-02-07 21:41:00","inspection_id":"80792985","insp_unit_id":"199316223","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"1N10229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X3JD487987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"},{"id":8047146,"change_date":"2024-02-07 21:41:00","inspection_id":"80792985","insp_unit_id":"199316224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"T22","insp_unit_license":"148B143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3427GR136861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"}]},{"id":4238860,"change_date":"2023-10-19 21:41:00","inspection_id":"79957475","dot_number":"3170964","report_state":"TX","report_number":"V231181219","insp_date":"2023-10-18 00:00:00","insp_start_time":"0831","insp_end_time":"0908","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX101 NB","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"P&K STONE","shipping_paper_number":"947299","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-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"9105225","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:46:41.000000Z","updated_at":"2025-03-17T19:46:41.000000Z","inspection_violations":[{"id":6564279,"change_date":"2023-10-19 21:41:00","inspection_id":"79957475","insp_violation_id":"255943444","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197649705","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"39375A3"},{"id":6564280,"change_date":"2023-10-19 21:41:00","inspection_id":"79957475","insp_violation_id":"255943445","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197649705","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:39.000000Z","updated_at":"2025-03-17T21:37:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6817237,"change_date":"2023-10-19 21:41:00","inspection_id":"79957475","insp_unit_id":"197649705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WE25","insp_unit_license":"RLT0660","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV7GPHT4275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:09.000000Z","updated_at":"2025-03-17T22:57:09.000000Z"}]},{"id":4127681,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","dot_number":"3170964","report_state":"TX","report_number":"V231145428","insp_date":"2023-09-27 00:00:00","insp_start_time":"1357","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:33   14' 21.18N","county_code_state":"TX","county_code":"497","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6638734","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9091935","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-04 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:44:26.000000Z","updated_at":"2025-03-17T19:44:26.000000Z","inspection_violations":[{"id":6389153,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664578","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"197402841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"39355C1"},{"id":6389154,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664579","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"197402842","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"39355E"},{"id":6389155,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664580","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197402841","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"39375A3"},{"id":6389156,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664581","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197402842","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"3963A1"},{"id":6389157,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664582","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197402841","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"3922"},{"id":6389158,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_violation_id":"255664583","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197402842","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6636816,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_unit_id":"197402841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"NE24","insp_unit_license":"RLT0661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJALDR7EPFK9333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"},{"id":6636817,"change_date":"2023-10-04 21:41:00","inspection_id":"79834802","insp_unit_id":"197402842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"10","insp_unit_license":"148B145","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1D9SD3423ER661287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:41.000000Z","updated_at":"2025-03-17T22:55:41.000000Z"}]},{"id":3985778,"change_date":"2023-09-15 21:40:00","inspection_id":"79677020","dot_number":"3170964","report_state":"TX","report_number":"V231154758","insp_date":"2023-09-12 00:00:00","insp_start_time":"0730","insp_end_time":"0752","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:33   14' 21.18N","county_code_state":"TX","county_code":"497","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6628079","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"130600","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9076144","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[{"id":6165115,"change_date":"2023-09-15 21:40:00","inspection_id":"79677020","insp_violation_id":"255303395","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197084739","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3963A1"},{"id":6165116,"change_date":"2023-09-15 21:40:00","inspection_id":"79677020","insp_violation_id":"255303396","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:35:48.000000Z","updated_at":"2025-03-17T21:35:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6408959,"change_date":"2023-09-15 21:40:00","inspection_id":"79677020","insp_unit_id":"197084739","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"1N10229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X3JD487987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"},{"id":6408960,"change_date":"2023-09-15 21:40:00","inspection_id":"79677020","insp_unit_id":"197084740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"T22","insp_unit_license":"226B413","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1R9ESB508XL008985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3313172,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","dot_number":"3170964","report_state":"TX","report_number":"6LXC0XSDET","insp_date":"2023-06-14 00:00:00","insp_start_time":"1238","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0101 IN WISE CO. (228-240)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HANSON","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":"2023-06-19 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"9008290","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-19 21:36:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:28:33.000000Z","updated_at":"2025-03-17T19:28:33.000000Z","inspection_violations":[{"id":5110641,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","insp_violation_id":"253577677","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195561737","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3922"},{"id":5110642,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","insp_violation_id":"253577678","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195561737","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3922"},{"id":5110643,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","insp_violation_id":"253577679","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195561736","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:45.000000Z","updated_at":"2025-03-17T21:30:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5326790,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","insp_unit_id":"195561736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WE26","insp_unit_license":"RTP2352","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:01.000000Z","updated_at":"2025-03-17T22:45:01.000000Z"},{"id":5326791,"change_date":"2023-06-19 21:36:00","inspection_id":"78924384","insp_unit_id":"195561737","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"JL1A","insp_unit_license":"173B844","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W9103220YW172481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:01.000000Z","updated_at":"2025-03-17T22:45:01.000000Z"}]},{"id":2822184,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","dot_number":"3170964","report_state":"TX","report_number":"6K6E0XMRSQ","insp_date":"2023-04-12 00:00:00","insp_start_time":"1349","insp_end_time":"1409","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0114 IN WISE CO. (558-586)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"34306718","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"8","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8955240","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-17 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:18:52.000000Z","updated_at":"2025-03-17T19:18:52.000000Z","inspection_violations":[{"id":4330726,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271893","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39216A"},{"id":4330727,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271894","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"194432820","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39395B"},{"id":4330728,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271895","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194432820","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3965B"},{"id":4330729,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271896","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194432820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39311"},{"id":4330730,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271897","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194432820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39311"},{"id":4330731,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271898","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194432820","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"39311"},{"id":4330732,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271899","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194432821","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3939A"},{"id":4330733,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_violation_id":"252271900","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194432821","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:14.000000Z","updated_at":"2025-03-17T21:27:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4542641,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_unit_id":"194432820","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"ME27","insp_unit_license":"RTP2351","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:49.000000Z","updated_at":"2025-03-17T22:38:49.000000Z"},{"id":4542642,"change_date":"2023-04-17 21:41:00","inspection_id":"78369497","insp_unit_id":"194432821","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"ME27T","insp_unit_license":"173B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1R9ESB508XL008985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:49.000000Z","updated_at":"2025-03-17T22:38:49.000000Z"}]},{"id":2802834,"change_date":"2023-04-13 21:43:00","inspection_id":"78347492","dot_number":"3170964","report_state":"TX","report_number":"6K4H0XSEV4","insp_date":"2023-04-10 00:00:00","insp_start_time":"1712","insp_end_time":"1734","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0081 IN WISE CO. (228-264)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"P&K STONE","shipping_paper_number":"900738","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-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60500","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":"8953065","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:18:29.000000Z","updated_at":"2025-03-17T19:18:29.000000Z","inspection_violations":[{"id":4302909,"change_date":"2023-04-13 21:43:00","inspection_id":"78347492","insp_violation_id":"252221085","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194383270","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39347E"},{"id":4302910,"change_date":"2023-04-13 21:43:00","inspection_id":"78347492","insp_violation_id":"252221086","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194383270","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39353B"},{"id":4302911,"change_date":"2023-04-13 21:43:00","inspection_id":"78347492","insp_violation_id":"252221087","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194383270","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:08.000000Z","updated_at":"2025-03-17T21:27:08.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":4511248,"change_date":"2023-04-13 21:43:00","inspection_id":"78347492","insp_unit_id":"194383270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"25","insp_unit_license":"RLT0660","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV7GPHT4275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:34.000000Z","updated_at":"2025-03-17T22:38:34.000000Z"}]},{"id":2752140,"change_date":"2023-04-06 21:40:00","inspection_id":"78290293","dot_number":"3170964","report_state":"TX","report_number":"6JXG0VJOMI","insp_date":"2023-04-03 00:00:00","insp_start_time":"1648","insp_end_time":"1707","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0081 IN WISE CO. (228-264)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2023-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8947971","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:17:22.000000Z","updated_at":"2025-03-17T19:17:22.000000Z","inspection_violations":[{"id":4225021,"change_date":"2023-04-06 21:40:00","inspection_id":"78290293","insp_violation_id":"252093762","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194269692","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3965B"},{"id":4225022,"change_date":"2023-04-06 21:40:00","inspection_id":"78290293","insp_violation_id":"252093763","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194269693","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4429900,"change_date":"2023-04-06 21:40:00","inspection_id":"78290293","insp_unit_id":"194269692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"20","insp_unit_license":"1L90751","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X0GD337280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"},{"id":4429901,"change_date":"2023-04-06 21:40:00","inspection_id":"78290293","insp_unit_id":"194269693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"148B145","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1D9SD3423ER661287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"}]},{"id":2722426,"change_date":"2023-04-03 21:41:00","inspection_id":"78256657","dot_number":"3170964","report_state":"TX","report_number":"6JUE0XSEUG","insp_date":"2023-03-31 00:00:00","insp_start_time":"1416","insp_end_time":"1433","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0081 IN WISE CO. (228-264)","county_code_state":"TX","county_code":"497","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2023-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"57100","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":"8945099","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[{"id":4183443,"change_date":"2023-04-03 21:41:00","inspection_id":"78256657","insp_violation_id":"252023823","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194202890","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4382370,"change_date":"2023-04-03 21:41:00","inspection_id":"78256657","insp_unit_id":"194202890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WE28","insp_unit_license":"SLP8015","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV3JLJU5493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2568862,"change_date":"2023-03-13 21:43:00","inspection_id":"78081418","dot_number":"3170964","report_state":"TX","report_number":"6J690XSETB","insp_date":"2023-03-07 00:00:00","insp_start_time":"0932","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VULCAN","shipping_paper_number":"65556970","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-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"57100","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":"8927151","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[{"id":3951756,"change_date":"2023-03-13 21:43:00","inspection_id":"78081418","insp_violation_id":"251638072","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193849995","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:32.000000Z","updated_at":"2025-03-17T21:25:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4134634,"change_date":"2023-03-13 21:43:00","inspection_id":"78081418","insp_unit_id":"193849995","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WE28","insp_unit_license":"SLP8015","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KKWAVDV3JLJU5493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:38.000000Z","updated_at":"2025-03-17T22:35:38.000000Z"}]},{"id":2659171,"change_date":"2023-03-24 21:41:00","inspection_id":"78183597","dot_number":"3170964","report_state":"TX","report_number":"6ISD9DGN1N","insp_date":"2023-02-21 00:00:00","insp_start_time":"1310","insp_end_time":"1328","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN DENTON CO. (368-625)","county_code_state":"TX","county_code":"121","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"8936207","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[{"id":4088200,"change_date":"2023-03-24 21:41:00","inspection_id":"78183597","insp_violation_id":"251866600","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194060945","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39345B2"},{"id":4088201,"change_date":"2023-03-24 21:41:00","inspection_id":"78183597","insp_violation_id":"251866601","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"194060945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"393203C"},{"id":4088202,"change_date":"2023-03-24 21:41:00","inspection_id":"78183597","insp_violation_id":"251866602","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194060945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4281330,"change_date":"2023-03-24 21:41:00","inspection_id":"78183597","insp_unit_id":"194060945","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WE28","insp_unit_license":"SLP8015","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NP5LB9X85D849214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:43.000000Z","updated_at":"2025-03-17T22:36:43.000000Z"}]},{"id":2417899,"change_date":"2023-02-21 21:42:00","inspection_id":"77909585","dot_number":"3170964","report_state":"TX","report_number":"6IKF0XRZG0","insp_date":"2023-02-13 00:00:00","insp_start_time":"1505","insp_end_time":"1525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1810 IN WISE CO. (526-544)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8908212","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-21 21:42:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:11:06.000000Z","updated_at":"2025-03-17T19:11:06.000000Z","inspection_violations":[{"id":3723026,"change_date":"2023-02-21 21:42:00","inspection_id":"77909585","insp_violation_id":"251255889","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:34.000000Z","updated_at":"2025-03-17T21:24:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3891458,"change_date":"2023-02-21 21:42:00","inspection_id":"77909585","insp_unit_id":"193506997","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"1N10229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X3JD487987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"},{"id":3891459,"change_date":"2023-02-21 21:42:00","inspection_id":"77909585","insp_unit_id":"193506998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"T22","insp_unit_license":"148B143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3427GR136861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:52.000000Z","updated_at":"2025-03-17T22:33:52.000000Z"}]},{"id":2236786,"change_date":"2023-01-26 21:42:00","inspection_id":"77702998","dot_number":"3170964","report_state":"TX","report_number":"6HZ70XQSEK","insp_date":"2023-01-23 00:00:00","insp_start_time":"0719","insp_end_time":"0739","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1810 IN WISE CO. (526-544)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"6462776","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8889337","transaction_code":"A","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-26 21:42:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:07:47.000000Z","updated_at":"2025-03-17T19:07:47.000000Z","inspection_violations":[{"id":3455763,"change_date":"2023-01-26 21:42:00","inspection_id":"77702998","insp_violation_id":"250804118","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3600622,"change_date":"2023-01-26 21:42:00","inspection_id":"77702998","insp_unit_id":"193088803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"22","insp_unit_license":"1N10229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X3JD487987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:50.000000Z","updated_at":"2025-03-17T22:31:50.000000Z"},{"id":3600623,"change_date":"2023-01-26 21:42:00","inspection_id":"77702998","insp_unit_id":"193088804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"22","insp_unit_license":"148B143","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3427GR136861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:50.000000Z","updated_at":"2025-03-17T22:31:50.000000Z"}]},{"id":2161183,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","dot_number":"3170964","report_state":"TX","report_number":"6HP90AJDBE","insp_date":"2023-01-13 00:00:00","insp_start_time":"0836","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WATTS","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":"N","pen_cen_match":null,"final_status_date":"2023-01-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8880007","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:06:34.000000Z","updated_at":"2025-03-17T19:06:34.000000Z","inspection_violations":[{"id":3342334,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617298","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:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"3922"},{"id":3342335,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617299","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192913008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"39311"},{"id":3342336,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617300","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192913008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"3939A"},{"id":3342337,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617301","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"192913009","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"39345"},{"id":3342338,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617302","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192913009","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"3939A"},{"id":3342339,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617303","seq_no":"7","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192913009","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"393207A"},{"id":3342340,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617304","seq_no":"8","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192913009","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"393207A"},{"id":3342341,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_violation_id":"250617305","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192913009","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:49.000000Z","updated_at":"2025-03-17T21:22:49.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":3478327,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_unit_id":"192913008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"24","insp_unit_license":"RLT0661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5KJJALDR7EPFK9333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"},{"id":3478328,"change_date":"2023-01-17 21:43:00","inspection_id":"77616896","insp_unit_id":"192913009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"T24","insp_unit_license":"148B144","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T97A3025X1247463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"}]},{"id":2159678,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","dot_number":"3170964","report_state":"TX","report_number":"6HM70XRZDA","insp_date":"2023-01-10 00:00:00","insp_start_time":"0706","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1810 IN WISE CO. (526-544)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6454265","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-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8878230","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:06:18.000000Z","updated_at":"2025-03-17T19:06:18.000000Z","inspection_violations":[{"id":3338425,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612670","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:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3922"},{"id":3338426,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612671","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192910090","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39378"},{"id":3338427,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612672","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192910090","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39617C"},{"id":3338428,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612673","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"192910090","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39375A3"},{"id":3338429,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612674","seq_no":"5","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"192910090","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"39375A1"},{"id":3338430,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_violation_id":"250612675","seq_no":"6","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:22:46.000000Z","updated_at":"2025-03-17T21:22:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3475789,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_unit_id":"192910090","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"21","insp_unit_license":"1N10227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD40X2AD795356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"},{"id":3475790,"change_date":"2023-01-17 21:42:00","inspection_id":"77615240","insp_unit_id":"192910091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"T21","insp_unit_license":"173B844","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W9103220YW172481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:56.000000Z","updated_at":"2025-03-17T22:30:56.000000Z"}]},{"id":1976976,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","dot_number":"3170964","report_state":"TX","report_number":"6GW80AFLNM","insp_date":"2022-12-15 00:00:00","insp_start_time":"0735","insp_end_time":"0847","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0114 IN DENTON CO. (588-602","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6441850","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8854970","transaction_code":"A","transaction_date":"2022-12-19 00:00:00","upload_date":"2022-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-19 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T19:02:59.000000Z","updated_at":"2025-03-17T19:02:59.000000Z","inspection_violations":[{"id":3070371,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_violation_id":"250174073","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:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3922"},{"id":3070372,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_violation_id":"250174074","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192494645","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3922"},{"id":3070373,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_violation_id":"250174075","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"192494645","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"393207A"},{"id":3070374,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_violation_id":"250174076","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192494645","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3181211,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_unit_id":"192494645","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"173B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1R9ESB508XL008985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:47.000000Z","updated_at":"2025-03-17T22:28:47.000000Z"},{"id":3181212,"change_date":"2022-12-19 21:41:00","inspection_id":"77405896","insp_unit_id":"192494646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27","insp_unit_license":"RTP2351","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:47.000000Z","updated_at":"2025-03-17T22:28:47.000000Z"}]},{"id":1616899,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","dot_number":"3170964","report_state":"TX","report_number":"6FD70XRZ89","insp_date":"2022-10-21 00:00:00","insp_start_time":"0732","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6407558","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-10-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8812415","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-27 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:56:20.000000Z","updated_at":"2025-03-17T18:56:20.000000Z","inspection_violations":[{"id":2540580,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","insp_violation_id":"249295084","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:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"3922"},{"id":2540581,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","insp_violation_id":"249295085","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"191680519","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"393205C"},{"id":2540582,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","insp_violation_id":"249295086","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191680518","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:59.000000Z","updated_at":"2025-03-17T21:18:59.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2601939,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","insp_unit_id":"191680518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"21","insp_unit_license":"1N10227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD40X2AD795356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:50.000000Z","updated_at":"2025-03-17T22:24:50.000000Z"},{"id":2601940,"change_date":"2022-10-27 21:41:00","inspection_id":"76993376","insp_unit_id":"191680519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"JL1A","insp_unit_license":"173B844","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1W9103220YW172481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:50.000000Z","updated_at":"2025-03-17T22:24:50.000000Z"}]},{"id":1104376,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","dot_number":"3170964","report_state":"TX","report_number":"6DM60XSEJ0","insp_date":"2022-08-19 00:00:00","insp_start_time":"0549","insp_end_time":"0610","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0081 IN WISE CO. (228-264)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6348002","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-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8749893","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-22 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:47:13.000000Z","updated_at":"2025-03-17T18:47:13.000000Z","inspection_violations":[{"id":1741691,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_violation_id":"247904977","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190470880","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:08.000000Z","updated_at":"2025-03-17T21:15:08.000000Z","normalized_code":"3965B"},{"id":1741692,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_violation_id":"247904978","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"190470880","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:08.000000Z","updated_at":"2025-03-17T21:15:08.000000Z","normalized_code":"393209E"},{"id":1741693,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_violation_id":"247904979","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190470881","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:08.000000Z","updated_at":"2025-03-17T21:15:08.000000Z","normalized_code":"3939A"},{"id":1741694,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_violation_id":"247904980","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190470880","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:08.000000Z","updated_at":"2025-03-17T21:15:08.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":1776806,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_unit_id":"190470880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"27","insp_unit_license":"RTP2351","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X83D594340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"},{"id":1776807,"change_date":"2022-08-22 21:43:00","inspection_id":"76399475","insp_unit_id":"190470881","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAV","insp_unit_company":"T27","insp_unit_license":"148B144","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T97A3025X1247463","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:13.000000Z","updated_at":"2025-03-17T22:19:13.000000Z"}]},{"id":753546,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","dot_number":"3170964","report_state":"TX","report_number":"6C799DKAG8","insp_date":"2022-06-29 00:00:00","insp_start_time":"1056","insp_end_time":"1204","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0820 IN TARRANT CO. (0-34)","county_code_state":"TX","county_code":"439","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":"2022-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"76400","viol_total":"22","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8702839","transaction_code":"C","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:40:55.000000Z","updated_at":"2025-03-17T18:40:55.000000Z","inspection_violations":[{"id":1189182,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930419","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"},{"id":1189183,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930420","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"},{"id":1189184,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930421","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"},{"id":1189185,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930422","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39617C"},{"id":1189186,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930423","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39617C"},{"id":1189187,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930424","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39021A"},{"id":1189188,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930425","seq_no":"8","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39343D"},{"id":1189189,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930426","seq_no":"9","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39360D"},{"id":1189190,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930427","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3939A"},{"id":1189191,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930428","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3939A"},{"id":1189192,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930429","seq_no":"12","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39319"},{"id":1189193,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930430","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3939A"},{"id":1189194,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930431","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3939A"},{"id":1189195,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930432","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3939A"},{"id":1189196,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930433","seq_no":"16","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39311"},{"id":1189197,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930434","seq_no":"17","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"39311"},{"id":1189198,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930435","seq_no":"18","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3929A2"},{"id":1189199,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930436","seq_no":"19","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"393100A"},{"id":1189200,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930437","seq_no":"20","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"393110B"},{"id":1189201,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930438","seq_no":"21","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"393104B"},{"id":1189202,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930439","seq_no":"22","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"189638362","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3969D2"},{"id":1189203,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_violation_id":"246930440","seq_no":"23","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189638363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:33.000000Z","updated_at":"2025-03-17T21:12:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1212166,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_unit_id":"189638362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"106","insp_unit_license":"MVT9765","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GB4KVCY5KF240756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"},{"id":1212167,"change_date":"2022-07-06 21:41:00","inspection_id":"75989531","insp_unit_id":"189638363","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"276017K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4T9T3FG20K1116108","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:38.000000Z","updated_at":"2025-03-17T22:15:38.000000Z"}]},{"id":732681,"change_date":"2022-06-30 21:42:00","inspection_id":"75965133","dot_number":"3170964","report_state":"TX","report_number":"6C6B0XSDQD","insp_date":"2022-06-28 00:00:00","insp_start_time":"1055","insp_end_time":"1113","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WATTS","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-06-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"8700385","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-30 21:42:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:40:33.000000Z","updated_at":"2025-03-17T18:40:33.000000Z","inspection_violations":[{"id":1154653,"change_date":"2022-06-30 21:42:00","inspection_id":"75965133","insp_violation_id":"246839485","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"189559738","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:23.000000Z","updated_at":"2025-03-17T21:12:23.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":1177980,"change_date":"2022-06-30 21:42:00","inspection_id":"75965133","insp_unit_id":"189559738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"11","insp_unit_license":"MJJ2034","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3LJ0X3FM255639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:25.000000Z","updated_at":"2025-03-17T22:15:25.000000Z"}]},{"id":609928,"change_date":"2022-06-14 21:43:00","inspection_id":"75820068","dot_number":"3170964","report_state":"TX","report_number":"6BHA0VJO74","insp_date":"2022-06-03 00:00:00","insp_start_time":"1010","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6280024","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-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8679484","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:38:27.000000Z","updated_at":"2025-03-17T18:38:27.000000Z","inspection_violations":[{"id":959354,"change_date":"2022-06-14 21:43:00","inspection_id":"75820068","insp_violation_id":"246467243","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:11:28.000000Z","updated_at":"2025-03-17T21:11:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":981132,"change_date":"2022-06-14 21:43:00","inspection_id":"75820068","insp_unit_id":"189250655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RTP2352","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X94D829216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"},{"id":981133,"change_date":"2022-06-14 21:43:00","inspection_id":"75820068","insp_unit_id":"189250656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"344450M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU343422FS000618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"}]},{"id":399188,"change_date":"2022-05-17 21:43:00","inspection_id":"75569427","dot_number":"3170964","report_state":"TX","report_number":"6AUF0XSEEI","insp_date":"2022-05-11 00:00:00","insp_start_time":"1511","insp_end_time":"1538","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0380 IN WISE CO. (560-590)","county_code_state":"TX","county_code":"497","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":"N","pen_cen_match":null,"final_status_date":"2022-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"130400","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":"8655284","transaction_code":"C","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:34:28.000000Z","updated_at":"2025-03-17T18:34:28.000000Z","inspection_violations":[{"id":624853,"change_date":"2022-05-17 21:43:00","inspection_id":"75569427","insp_violation_id":"245853966","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188737310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39617C"},{"id":624854,"change_date":"2022-05-17 21:43:00","inspection_id":"75569427","insp_violation_id":"245853967","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188737310","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":645232,"change_date":"2022-05-17 21:43:00","inspection_id":"75569427","insp_unit_id":"188737309","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"16","insp_unit_license":"1N10228","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPWDB9X19D780654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"},{"id":645233,"change_date":"2022-05-17 21:43:00","inspection_id":"75569427","insp_unit_id":"188737310","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":"T16","insp_unit_license":"X05383","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU1140257S000870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:10.000000Z","updated_at":"2025-03-17T22:12:10.000000Z"}]},{"id":208852,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","dot_number":"3170964","report_state":"TX","report_number":"6A3A0VJPF8","insp_date":"2022-04-14 00:00:00","insp_start_time":"0958","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US 380 @ US 287","county_code_state":"TX","county_code":"497","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8628140","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-19 21:45:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:31:13.000000Z","updated_at":"2025-03-17T18:31:13.000000Z","inspection_violations":[{"id":321428,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_violation_id":"245254341","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188235412","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:36.000000Z","updated_at":"2025-03-17T21:08:36.000000Z","normalized_code":"39360C"},{"id":321429,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_violation_id":"245254342","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188235412","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:36.000000Z","updated_at":"2025-03-17T21:08:36.000000Z","normalized_code":"3939A"},{"id":321430,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_violation_id":"245254343","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"188235413","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:08:36.000000Z","updated_at":"2025-03-17T21:08:36.000000Z","normalized_code":"39375A3"},{"id":321431,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_violation_id":"245254344","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"188235413","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:08:36.000000Z","updated_at":"2025-03-17T21:08:36.000000Z","normalized_code":"393207A"},{"id":321432,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_violation_id":"245254345","seq_no":"5","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:08:36.000000Z","updated_at":"2025-03-17T21:08:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":338919,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_unit_id":"188235412","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"20","insp_unit_license":"1L90751","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD49X0GD337280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:13.000000Z","updated_at":"2025-03-17T22:10:13.000000Z"},{"id":338920,"change_date":"2022-04-19 21:45:00","inspection_id":"75342094","insp_unit_id":"188235413","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"173B843","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3420FR136442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:13.000000Z","updated_at":"2025-03-17T22:10:13.000000Z"}]},{"id":149149,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","dot_number":"3170964","report_state":"TX","report_number":"69QC0AJDKF","insp_date":"2022-04-01 00:00:00","insp_start_time":"1224","insp_end_time":"1251","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-1810 IN WISE CO. (526-544)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"6230253","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8615909","transaction_code":"A","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:30:09.000000Z","updated_at":"2025-03-17T18:30:09.000000Z","inspection_violations":[{"id":221370,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082111","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3922"},{"id":221371,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082112","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188090171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3922"},{"id":221372,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082113","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188090171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3922"},{"id":221373,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082114","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188090172","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3922"},{"id":221374,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082115","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188090172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3939A"},{"id":221375,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_violation_id":"245082116","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188090172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":241809,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_unit_id":"188090171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"130","insp_unit_license":"1L90813","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X75N863333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"},{"id":241810,"change_date":"2022-04-11 21:41:00","inspection_id":"75270927","insp_unit_id":"188090172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"148B124","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"591SD3420FR136442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"}]},{"id":90583,"change_date":"2022-04-07 21:39:00","inspection_id":"75198915","dot_number":"3170964","report_state":"TX","report_number":"69M90XSDKC","insp_date":"2022-03-28 00:00:00","insp_start_time":"0850","insp_end_time":"0909","registration_date":"2022-04-07 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0101 IN WISE CO. (228-240)","county_code_state":"TX","county_code":"497","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WATTS","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","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":"8608062","transaction_code":"C","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03170964","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-01 21:39:00","insp_carrier_name":"WATTS EXCAVATING","insp_carrier_street":"106 CR 1180","insp_carrier_city":"ALVORD","insp_carrier_state":"TX","insp_carrier_zip_code":"76225","insp_colonia":null,"docket_number":"118303","insp_interstate":"N","insp_carrier_state_id":"0988616","created_at":"2025-03-17T18:29:09.000000Z","updated_at":"2025-03-17T18:29:09.000000Z","inspection_violations":[{"id":135348,"change_date":"2022-04-07 21:39:00","inspection_id":"75198915","insp_violation_id":"245033070","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188046553","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"3939A"},{"id":135349,"change_date":"2022-04-07 21:39:00","inspection_id":"75198915","insp_violation_id":"245033071","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188046552","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":147260,"change_date":"2022-04-07 21:39:00","inspection_id":"75198915","insp_unit_id":"188046552","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"130","insp_unit_license":"1L90813","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPFDB9X75N863333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:07.000000Z","updated_at":"2025-03-17T22:09:07.000000Z"},{"id":147261,"change_date":"2022-04-07 21:39:00","inspection_id":"75198915","insp_unit_id":"188046553","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VIKI","insp_unit_company":"8","insp_unit_license":"X69854","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1V9CR46357N062230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:07.000000Z","updated_at":"2025-03-17T22:09:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3170964\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3170964\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3170964\/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\/3170964\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}