{"current_page":1,"data":[{"id":11358016,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","dot_number":"2391423","report_state":"TX","report_number":"V262260359","insp_date":"2026-03-11 00:00:00","insp_start_time":"1017","insp_end_time":"1046","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"N\/B IH-35 & WESTINGH","county_code_state":"TX","county_code":"491","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9882996","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2026-03-12 21:40:00","snet_input_date":"2026-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2026-03-15T09:40:02.000000Z","updated_at":"2026-03-23T09:32:41.000000Z","inspection_violations":[{"id":19137939,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375286","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"212111319","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"39311TU"},{"id":19137940,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375287","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"212111320","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"39355E"},{"id":19137941,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375288","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212111320","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"3939"},{"id":19137942,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375289","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212111319","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"39617C"},{"id":19137943,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375290","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212111319","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"39617C"},{"id":19137944,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375291","seq_no":"6","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"212111319","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"3965B"},{"id":19137945,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375292","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212111319","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"3922RG"},{"id":19137946,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_violation_id":"272375293","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"212111320","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:45.000000Z","updated_at":"2026-03-23T09:51:59.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19438586,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_unit_id":"212111319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5011","insp_unit_license":"1L81738","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD49X4CD135325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:44.000000Z","updated_at":"2026-03-23T09:11:18.000000Z"},{"id":19438587,"change_date":"2026-03-12 21:40:00","inspection_id":"87276542","insp_unit_id":"212111320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ARMC","insp_unit_company":null,"insp_unit_license":"226C129","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C28MA000058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:44.000000Z","updated_at":"2026-03-23T09:11:18.000000Z"}]},{"id":11131317,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","dot_number":"2391423","report_state":"TX","report_number":"7CRB9DND08","insp_date":"2026-02-04 00:00:00","insp_start_time":"1101","insp_end_time":"1321","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-0130 IN WILLIAMSON CO. (412","county_code_state":"TX","county_code":"491","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"198600","viol_total":"8","oos_total":"3","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9849527","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2026-02-16T10:38:48.000000Z","updated_at":"2026-02-24T10:31:08.000000Z","inspection_violations":[{"id":18647957,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797126","seq_no":"1","part_no":"392","part_no_section":"15","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"39215"},{"id":18647958,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797127","seq_no":"2","part_no":"383","part_no_section":"23A2","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":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"38323A2"},{"id":18647959,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797128","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"211622561","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3922W"},{"id":18647960,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797129","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"211622562","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3922W"},{"id":18647961,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797130","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"211622562","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3922W"},{"id":18647962,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797131","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"211622561","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3922W"},{"id":18647963,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797132","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211622562","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3922RG"},{"id":18647964,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_violation_id":"271797133","seq_no":"9","part_no":"395","part_no_section":"8A-NON-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:45.000000Z","updated_at":"2026-02-24T10:39:52.000000Z","normalized_code":"3958ANONELD"}],"inspection_per_units":[{"id":18988312,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_unit_id":"211622561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5023","insp_unit_license":"1M22141","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXD40X2ND769458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:35.000000Z"},{"id":18988313,"change_date":"2026-02-13 21:39:00","inspection_id":"87044808","insp_unit_id":"211622562","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"154B894","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"40FSK533XL1038160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:06.000000Z","updated_at":"2026-02-24T10:03:35.000000Z"}]},{"id":8964890,"change_date":"2025-06-23 21:41:00","inspection_id":"85021861","dot_number":"2391423","report_state":"TX","report_number":"V251895928","insp_date":"2025-06-19 00:00:00","insp_start_time":"1028","insp_end_time":"1043","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"N\/B TOLL 130 & FM 97","county_code_state":"TX","county_code":"491","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64601","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":"9614196","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-06-28T10:00:39.000000Z","updated_at":"2025-06-28T10:00:39.000000Z","inspection_violations":[{"id":14400692,"change_date":"2025-06-23 21:41:00","inspection_id":"85021861","insp_violation_id":"266995593","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207514381","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:06.000000Z","updated_at":"2025-06-27T10:18:15.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14696231,"change_date":"2025-06-23 21:41:00","inspection_id":"85021861","insp_unit_id":"207514381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"5004","insp_unit_license":"HFF0175","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3XJ0X7HM369540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:41.000000Z","updated_at":"2025-06-27T09:46:22.000000Z"}]},{"id":7414926,"change_date":"2024-12-16 21:40:00","inspection_id":"83389379","dot_number":"2391423","report_state":"TX","report_number":"V241692890","insp_date":"2024-12-10 00:00:00","insp_start_time":"1031","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1695","county_code_state":"TX","county_code":"309","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9449637","transaction_code":"C","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-12-13 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-13 21:41:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:50:47.000000Z","updated_at":"2025-03-17T20:50:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18635830,"change_date":null,"inspection_id":"83389379","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L81738","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD49X4CD135325","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18794872,"change_date":null,"inspection_id":"83389379","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"LEDW","insp_unit_company":null,"insp_unit_license":"177C886","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L9GA73A6DL033155","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7062515,"change_date":"2024-10-28 21:40:00","inspection_id":"83017203","dot_number":"2391423","report_state":"TX","report_number":"6ZQB9DJR53","insp_date":"2024-10-23 00:00:00","insp_start_time":"1104","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN BEXAR CO. (554-594)","county_code_state":"TX","county_code":"029","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-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"12","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9412443","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-10-28 21:40:00","snet_input_date":"2024-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-28 21:40:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:43:24.000000Z","updated_at":"2025-03-17T20:43:24.000000Z","inspection_violations":[{"id":18425641,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18425642,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347A"},{"id":18425643,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"},{"id":18425644,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39378"},{"id":18425645,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18425646,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1"},{"id":18425647,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BOS"},{"id":18425648,"change_date":null,"inspection_id":"83017203","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3965BHWSLIW"}],"inspection_per_units":[{"id":18708652,"change_date":null,"inspection_id":"83017203","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"1M57420","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11C97M052269","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6991052,"change_date":"2024-10-18 21:42:00","inspection_id":"82941320","dot_number":"2391423","report_state":"TX","report_number":"6ZJD9DIP7P","insp_date":"2024-10-16 00:00:00","insp_start_time":"1304","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-1604 IN BEXAR CO. (488-582)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"9405506","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:41:48.000000Z","updated_at":"2025-03-17T20:41:48.000000Z","inspection_violations":[{"id":18424329,"change_date":null,"inspection_id":"82941320","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311"},{"id":18424330,"change_date":null,"inspection_id":"82941320","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":18629954,"change_date":null,"inspection_id":"82941320","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1N31263","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVSG5FE5PHUK7971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7040168,"change_date":"2024-10-24 21:42:00","inspection_id":"82993480","dot_number":"2391423","report_state":"TX","report_number":"6ZJA9DIR4N","insp_date":"2024-10-16 00:00:00","insp_start_time":"1039","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN BEXAR CO. (545-596)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128200","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9410515","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-10-24 21:42:00","snet_input_date":"2024-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-24 21:42:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"8309 CROSS PARK DRIVE","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78754","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:42:58.000000Z","updated_at":"2025-03-17T20:42:58.000000Z","inspection_violations":[{"id":18425239,"change_date":null,"inspection_id":"82993480","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39311TL"},{"id":18425240,"change_date":null,"inspection_id":"82993480","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18425241,"change_date":null,"inspection_id":"82993480","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":18708351,"change_date":null,"inspection_id":"82993480","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L81736","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPTD49X1GD258330","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18789255,"change_date":null,"inspection_id":"82993480","insp_unit_id":"2","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"071B200","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC423212G3158089","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5333134,"change_date":"2024-03-20 21:43:00","inspection_id":"81156844","dot_number":"2391423","report_state":"TX","report_number":"6TJB9DLK90","insp_date":"2024-03-14 00:00:00","insp_start_time":"1055","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14800  TAMARON PASS","county_code_state":"TX","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"5551 SHERRI ANNA","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-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"35180","viol_total":"6","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9227605","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[{"id":18392195,"change_date":null,"inspection_id":"81156844","insp_violation_id":null,"seq_no":null,"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":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2"},{"id":18392196,"change_date":null,"inspection_id":"81156844","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":18606842,"change_date":null,"inspection_id":"81156844","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"SCY5390","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRNBL5NG255589","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18763403,"change_date":null,"inspection_id":"81156844","insp_unit_id":"2","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"398017K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4P5T92425K1304471","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5333016,"change_date":"2024-03-20 21:43:00","inspection_id":"81156723","dot_number":"2391423","report_state":"TX","report_number":"6TB99DMG40","insp_date":"2024-03-06 00:00:00","insp_start_time":"0925","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN WILLIAMSON CO. (252","county_code_state":"TX","county_code":"491","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-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"67600","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":"9227556","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[{"id":18392191,"change_date":null,"inspection_id":"81156723","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18392192,"change_date":null,"inspection_id":"81156723","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":18606839,"change_date":null,"inspection_id":"81156723","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1L81737","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3XJ0X0HM369539","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4840763,"change_date":"2024-01-16 21:45:00","inspection_id":"80619142","dot_number":"2391423","report_state":"TX","report_number":"6RT89DSO5M","insp_date":"2024-01-12 00:00:00","insp_start_time":"0800","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-1604 IN BEXAR CO. (488-582)","county_code_state":"TX","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FM 2252","shipping_paper_number":"15284","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-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"64601","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":"9173271","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:58:47.000000Z","updated_at":"2025-03-17T19:58:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18599691,"change_date":null,"inspection_id":"80619142","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"HFF0175","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2NP3XJ0X7HM369540","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4840637,"change_date":"2024-01-16 21:45:00","inspection_id":"80618999","dot_number":"2391423","report_state":"TX","report_number":"V241243633","insp_date":"2024-01-10 00:00:00","insp_start_time":"1028","insp_end_time":"1114","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11525 FM2601","county_code_state":"TX","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA","shipping_paper_number":"27008933","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-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"6","oos_total":"2","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9174112","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:58:47.000000Z","updated_at":"2025-03-17T19:58:47.000000Z","inspection_violations":[{"id":18382999,"change_date":null,"inspection_id":"80618999","insp_violation_id":null,"seq_no":null,"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":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2"},{"id":18383000,"change_date":null,"inspection_id":"80618999","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A"},{"id":18383001,"change_date":null,"inspection_id":"80618999","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375GLOAD"}],"inspection_per_units":[{"id":18599686,"change_date":null,"inspection_id":"80618999","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1N54771","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVSG5FE5PHUK7971","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4541024,"change_date":"2023-12-01 21:43:00","inspection_id":"80291156","dot_number":"2391423","report_state":"TX","report_number":"V231233123","insp_date":"2023-11-28 00:00:00","insp_start_time":"1657","insp_end_time":"1710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 SB MM 321","county_code_state":"TX","county_code":"309","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOBSITE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9137906","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2023-12-01 21:43:00","snet_input_date":"2023-11-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-01 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:52:57.000000Z","updated_at":"2025-03-17T19:52:57.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3169649,"change_date":"2023-05-30 21:43:00","inspection_id":"78762067","dot_number":"2391423","report_state":"TX","report_number":"6LE99DAN3Y","insp_date":"2023-05-26 00:00:00","insp_start_time":"0830","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4000 S SH 130 HWY","county_code_state":"TX","county_code":"453","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"35180","viol_total":"14","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8992060","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:25:44.000000Z","updated_at":"2025-03-17T19:25:44.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2994048,"change_date":"2023-06-05 21:43:00","inspection_id":"78564020","dot_number":"2391423","report_state":"TX","report_number":"V231021378","insp_date":"2023-05-01 00:00:00","insp_start_time":"1455","insp_end_time":"1534","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"35","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"D GUERRA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"98001","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":"8972785","transaction_code":"C","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2023-05-08 21:43:00","snet_input_date":"2023-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-08 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:22:17.000000Z","updated_at":"2025-03-17T19:22:17.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1998329,"change_date":"2022-12-21 21:40:00","inspection_id":"77430271","dot_number":"2391423","report_state":"TX","report_number":"6GMA9DJQO4","insp_date":"2022-12-05 00:00:00","insp_start_time":"1007","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN BEXAR CO. (133-173)","county_code_state":"TX","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64601","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":"8857385","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-12-21 21:40:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-21 21:40:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T19:03:22.000000Z","updated_at":"2025-03-17T19:03:22.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1199972,"change_date":"2022-09-01 21:42:00","inspection_id":"76510590","dot_number":"2391423","report_state":"TX","report_number":"6DR90XNJEM","insp_date":"2022-08-24 00:00:00","insp_start_time":"0902","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0027 IN KERR CO. (446-484)","county_code_state":"TX","county_code":"265","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOBSITE","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-09-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","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":"8760516","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-09-01 21:42:00","snet_input_date":"2022-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-01 21:42:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T18:48:41.000000Z","updated_at":"2025-03-17T18:48:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":793218,"change_date":"2022-07-13 21:40:00","inspection_id":"76035674","dot_number":"2391423","report_state":"TX","report_number":"6C890XTMEU","insp_date":"2022-06-30 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":"2022-07-13 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0046 IN GUADALUPE CO. (530-","county_code_state":"TX","county_code":"187","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":"2022-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52320","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8709226","transaction_code":"C","transaction_date":"2022-07-12 00:00:00","upload_date":"2022-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-07-11 21:42:00","snet_input_date":"2022-06-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-11 21:42:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T18:41:37.000000Z","updated_at":"2025-03-17T18:41:37.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":683903,"change_date":"2022-06-23 21:40:00","inspection_id":"75907390","dot_number":"2391423","report_state":"TX","report_number":"6BVD0XNJBP","insp_date":"2022-06-17 00:00:00","insp_start_time":"1354","insp_end_time":"1406","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0027 IN KERR CO. (446-484)","county_code_state":"TX","county_code":"265","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CENTER POINT JOBSITE","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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"87000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8693490","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-06-23 21:40:00","snet_input_date":"2022-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T18:39:48.000000Z","updated_at":"2025-03-17T18:39:48.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":323091,"change_date":"2022-05-04 21:41:00","inspection_id":"75478383","dot_number":"2391423","report_state":"TX","report_number":"6AGE0AMAD3","insp_date":"2022-04-27 00:00:00","insp_start_time":"1443","insp_end_time":"1502","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"S. SEGUIN ST","county_code_state":"TX","county_code":"091","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","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-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64601","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":"8644459","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-04-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T18:33:18.000000Z","updated_at":"2025-03-17T18:33:18.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":228312,"change_date":"2022-04-21 21:43:00","inspection_id":"75365351","dot_number":"2391423","report_state":"TX","report_number":"6A399DIRZ9","insp_date":"2022-04-14 00:00:00","insp_start_time":"0900","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN BEXAR CO. (133-173)","county_code_state":"TX","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-04-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"136119","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":"8630982","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02391423","upload_search_indicator":"M","census_search_date":"2022-04-21 21:43:00","snet_input_date":"2022-04-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-21 21:43:00","insp_carrier_name":"D GUERRA CONSTRUCTION LLC","insp_carrier_street":"9810 FM 969","insp_carrier_city":"AUSTIN","insp_carrier_state":"TX","insp_carrier_zip_code":"78724","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0179437","created_at":"2025-03-17T18:31:33.000000Z","updated_at":"2025-03-17T18:31:33.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2391423\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2391423\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2391423\/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\/2391423\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}