{"current_page":1,"data":[{"id":12339279,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","dot_number":"2993181","report_state":"TX","report_number":"V262442597","insp_date":"2026-06-27 00:00:00","insp_start_time":"1546","insp_end_time":"1634","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10800  TX35","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENSTRUCTURES RICHARDSON","shipping_paper_number":"1929844","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-07-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10014346","transaction_code":"A","transaction_date":"2026-07-01 00:00:00","upload_date":"2026-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2026-07-01 21:42:00","snet_input_date":"2026-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-01 21:42:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2026-07-04T09:41:59.000000Z","updated_at":"2026-07-13T09:31:48.000000Z","inspection_violations":[{"id":21476411,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259836","seq_no":"1","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"39311TU"},{"id":21476412,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259837","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"39378"},{"id":21476413,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259838","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"3939"},{"id":21476414,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259839","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"3939"},{"id":21476415,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259840","seq_no":"5","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"3939T"},{"id":21476416,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259841","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"214407909","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"3939TS"},{"id":21476417,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259842","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"214407910","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"39617C"},{"id":21476418,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_violation_id":"275259843","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"214407910","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:02:33.000000Z","updated_at":"2026-07-13T09:42:36.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21428792,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_unit_id":"214407909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"99N817N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:19.000000Z","updated_at":"2026-07-13T09:03:33.000000Z"},{"id":21428793,"change_date":"2026-07-01 21:42:00","inspection_id":"88298622","insp_unit_id":"214407910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"NA","insp_unit_license":"10P817N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B482XX1135942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:19.000000Z","updated_at":"2026-07-13T09:03:33.000000Z"}]},{"id":11889061,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","dot_number":"2993181","report_state":"TX","report_number":"7FAA9DCRHE","insp_date":"2026-05-06 00:00:00","insp_start_time":"1015","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"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":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"17","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"16","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9950983","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2026-05-14T12:39:35.000000Z","updated_at":"2026-05-23T09:31:23.000000Z","inspection_violations":[{"id":20677492,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205364","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39395A"},{"id":20677500,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205372","seq_no":"12","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39617C"},{"id":20677503,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205375","seq_no":"15","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213510941","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39347E"},{"id":20677496,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205368","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39347E"},{"id":20677489,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205361","seq_no":"1","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-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"38323A2"},{"id":20677491,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205363","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39378"},{"id":20677493,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205365","seq_no":"5","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"393209E"},{"id":20677494,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205366","seq_no":"6","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39375C"},{"id":20677495,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205367","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39347E"},{"id":20677497,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205369","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39347E"},{"id":20677498,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205370","seq_no":"10","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39353B"},{"id":20677499,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205371","seq_no":"11","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"3963A1BOS"},{"id":20677501,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205373","seq_no":"13","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213510941","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39617C"},{"id":20677502,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205374","seq_no":"14","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"213510941","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"393205C"},{"id":20677504,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205376","seq_no":"16","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"213510941","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39353B"},{"id":20677505,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205377","seq_no":"17","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"3929BAINACTIVEINTRA"},{"id":20677490,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_violation_id":"274205362","seq_no":"2","part_no":"390","part_no_section":"21(g)(3)","insp_viol_unit":"1","insp_unit_id":"213510940","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:59:19.000000Z","updated_at":"2026-05-23T09:45:37.000000Z","normalized_code":"39021G3"}],"inspection_per_units":[{"id":20671103,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_unit_id":"213510941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"79T745N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01B482XX1135942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:41.000000Z","updated_at":"2026-05-23T09:04:26.000000Z"},{"id":20671102,"change_date":"2026-05-12 21:39:00","inspection_id":"87827091","insp_unit_id":"213510940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83T745N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:41.000000Z","updated_at":"2026-05-23T09:04:26.000000Z"}]},{"id":11842287,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","dot_number":"2993181","report_state":"TX","report_number":"7F889DJYJY","insp_date":"2026-05-04 00:00:00","insp_start_time":"0850","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9944630","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2026-05-06 21:41:00","snet_input_date":"2026-05-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2026-05-09T09:40:21.000000Z","updated_at":"2026-05-16T13:24:41.000000Z","inspection_violations":[{"id":20594914,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092573","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213418161","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"3922RG"},{"id":20594915,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092574","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"213418161","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"3939H"},{"id":20594916,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092575","seq_no":"3","part_no":"393","part_no_section":"24C","insp_viol_unit":"1","insp_unit_id":"213418161","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"39324C"},{"id":20594917,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092576","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"213418161","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"39375C"},{"id":20594918,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092577","seq_no":"6","part_no":"393","part_no_section":"53BMAN","insp_viol_unit":"2","insp_unit_id":"213418162","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"39353BMAN"},{"id":20594919,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092578","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213418162","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"3939"},{"id":20594920,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_violation_id":"274092579","seq_no":"8","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213418161","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-09T10:01:21.000000Z","updated_at":"2026-05-16T12:57:04.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":20594552,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_unit_id":"213418162","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"127B503","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:34.000000Z","updated_at":"2026-05-16T12:32:18.000000Z"},{"id":20594551,"change_date":"2026-05-06 21:41:00","inspection_id":"87777928","insp_unit_id":"213418161","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1N69747","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:34.000000Z","updated_at":"2026-05-16T12:32:18.000000Z"}]},{"id":11428142,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","dot_number":"2993181","report_state":"TX","report_number":"7DY69DGTEQ","insp_date":"2026-03-19 00:00:00","insp_start_time":"0747","insp_end_time":"0818","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"14","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9890273","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2026-03-23T09:46:36.000000Z","updated_at":"2026-03-31T09:31:17.000000Z","inspection_violations":[{"id":19278234,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526662","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"3922RG"},{"id":19278235,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526663","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"3922RG"},{"id":19278236,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526664","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"212243287","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39617C"},{"id":19278237,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526665","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39395A"},{"id":19278238,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526666","seq_no":"5","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39395F"},{"id":19278239,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526667","seq_no":"6","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39375C"},{"id":19278240,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526668","seq_no":"7","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39375C"},{"id":19278241,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526669","seq_no":"8","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39375C"},{"id":19278242,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526670","seq_no":"9","part_no":"393","part_no_section":"75A4","insp_viol_unit":"2","insp_unit_id":"212243287","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39375A4"},{"id":19278243,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526671","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"39378"},{"id":19278244,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526672","seq_no":"11","part_no":"393","part_no_section":"203E","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"393203E"},{"id":19278245,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526673","seq_no":"12","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"999"},{"id":19278246,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526674","seq_no":"13","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"3939H"},{"id":19278247,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_violation_id":"272526675","seq_no":"14","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212243286","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:54.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19576684,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_unit_id":"212243286","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"1N69747","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:03.000000Z","updated_at":"2026-03-31T09:11:01.000000Z"},{"id":19576685,"change_date":"2026-03-20 21:39:00","inspection_id":"87344299","insp_unit_id":"212243287","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"127B503","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:03.000000Z","updated_at":"2026-03-31T09:11:01.000000Z"}]},{"id":11544998,"change_date":"2026-04-01 21:40:00","inspection_id":"87467567","dot_number":"2993181","report_state":"TX","report_number":"7DVI9DCBIS","insp_date":"2026-03-16 00:00:00","insp_start_time":"1852","insp_end_time":"1903","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8900  CLINTON DR","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9902062","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2026-04-04T09:43:33.000000Z","updated_at":"2026-04-12T09:32:43.000000Z","inspection_violations":[{"id":19505841,"change_date":"2026-04-01 21:40:00","inspection_id":"87467567","insp_violation_id":"272802761","seq_no":"1","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-04-03T10:13:31.000000Z","updated_at":"2026-04-11T09:48:58.000000Z","normalized_code":"38323A2"},{"id":19505842,"change_date":"2026-04-01 21:40:00","inspection_id":"87467567","insp_violation_id":"272802762","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:31.000000Z","updated_at":"2026-04-11T09:48:58.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":19782554,"change_date":"2026-04-01 21:40:00","inspection_id":"87467567","insp_unit_id":"212485133","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"1N69747","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:48.000000Z","updated_at":"2026-04-12T09:11:41.000000Z"}]},{"id":9927471,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","dot_number":"2993181","report_state":"TX","report_number":"79EH9DCR7U","insp_date":"2025-10-06 00:00:00","insp_start_time":"1655","insp_end_time":"1715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  MCCARTY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9723196","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-10-16T10:00:41.000000Z","updated_at":"2025-10-17T10:00:57.000000Z","inspection_violations":[{"id":16382604,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_violation_id":"269266223","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209440877","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:16:01.000000Z","updated_at":"2025-10-17T10:16:22.000000Z","normalized_code":"3922RG"},{"id":16382605,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_violation_id":"269266224","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209440877","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:16:01.000000Z","updated_at":"2025-10-17T10:16:22.000000Z","normalized_code":"39395A"},{"id":16382606,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_violation_id":"269266225","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209440878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:16:01.000000Z","updated_at":"2025-10-17T10:16:22.000000Z","normalized_code":"3939"},{"id":16382607,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_violation_id":"269266226","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209440878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:16:01.000000Z","updated_at":"2025-10-17T10:16:22.000000Z","normalized_code":"3939"},{"id":16382608,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_violation_id":"269266227","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"209440878","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:16:01.000000Z","updated_at":"2025-10-17T10:16:22.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16476829,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_unit_id":"209440877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK65DV16406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:46:03.000000Z"},{"id":16476830,"change_date":"2025-10-13 21:37:00","inspection_id":"86033287","insp_unit_id":"209440878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"Z24059","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148304T1567373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:56.000000Z","updated_at":"2025-10-17T09:46:03.000000Z"}]},{"id":9839690,"change_date":"2025-10-02 21:42:00","inspection_id":"85941140","dot_number":"2993181","report_state":"TX","report_number":"79459DCQ7C","insp_date":"2025-09-26 00:00:00","insp_start_time":"0553","insp_end_time":"0605","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9300  CLINTON DR","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9712829","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-10-05T10:01:57.000000Z","updated_at":"2025-10-05T10:01:57.000000Z","inspection_violations":[{"id":16203923,"change_date":"2025-10-02 21:42:00","inspection_id":"85941140","insp_violation_id":"269064644","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209268424","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:45.000000Z","updated_at":"2025-10-05T10:17:45.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16316923,"change_date":"2025-10-02 21:42:00","inspection_id":"85941140","insp_unit_id":"209268424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1N69747","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:01.000000Z","updated_at":"2025-10-05T09:47:01.000000Z"},{"id":16316924,"change_date":"2025-10-02 21:42:00","inspection_id":"85941140","insp_unit_id":"209268425","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"127B503","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:01.000000Z","updated_at":"2025-10-05T09:47:01.000000Z"}]},{"id":9512098,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","dot_number":"2993181","report_state":"TX","report_number":"782E9DCN28","insp_date":"2025-08-19 00:00:00","insp_start_time":"1456","insp_end_time":"1529","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"13","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9676454","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2025-08-26 21:40:00","snet_input_date":"2025-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-08-29T10:43:07.000000Z","updated_at":"2025-09-05T10:46:47.000000Z","inspection_violations":[{"id":15516979,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262443","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39360C"},{"id":15516980,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262444","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39378"},{"id":15516981,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262445","seq_no":"3","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39355C1"},{"id":15516982,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262446","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"3922RG"},{"id":15516983,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262447","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208594079","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"3922RG"},{"id":15516984,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262448","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"208594079","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39617C"},{"id":15516985,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262449","seq_no":"8","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39021A"},{"id":15516986,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262450","seq_no":"9","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39395A"},{"id":15516987,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262451","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"3939"},{"id":15516988,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262452","seq_no":"12","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208594079","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"3939"},{"id":15516989,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262453","seq_no":"13","part_no":"393","part_no_section":"11TT","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39311TT"},{"id":15516990,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262454","seq_no":"14","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"208594078","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39311TL"},{"id":15516991,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_violation_id":"268262455","seq_no":"15","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"208594079","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":15696387,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_unit_id":"208594078","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK65DV16406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:43.000000Z","updated_at":"2025-09-05T09:46:11.000000Z"},{"id":15696388,"change_date":"2025-08-26 21:40:00","inspection_id":"85597401","insp_unit_id":"208594079","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"Z24059","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N148304T1567373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:43.000000Z","updated_at":"2025-09-05T09:46:11.000000Z"}]},{"id":8085895,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","dot_number":"2993181","report_state":"TX","report_number":"72LA9DCJ2I","insp_date":"2025-02-03 00:00:00","insp_start_time":"1017","insp_end_time":"1035","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1200  NORMANDY RD","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HYUNDAI STEEL","shipping_paper_number":"RV1699917","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-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"2","driver_viol_total":"6","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9517174","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"27415 GAITLIN LN","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12636516,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952501","seq_no":"1","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":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"38323A2"},{"id":12636517,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952502","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39141A"},{"id":12636518,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952503","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922RG"},{"id":12636519,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952504","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922RG"},{"id":12636520,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952505","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3922RG"},{"id":12636521,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_violation_id":"264952506","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":13055154,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_unit_id":"205739982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L19761","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"},{"id":13055155,"change_date":"2025-03-11 21:41:00","inspection_id":"84094144","insp_unit_id":"205739983","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"121S","insp_unit_license":"075C123","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2489TA854310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:20.000000Z","updated_at":"2025-03-17T23:59:20.000000Z"}]},{"id":3286934,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","dot_number":"2993181","report_state":"TX","report_number":"V231031145","insp_date":"2023-06-05 00:00:00","insp_start_time":"0759","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"PENINSULA ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF STREAM","shipping_paper_number":"510117412","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"9005500","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2023-06-14 21:42:00","snet_input_date":"2023-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-14 21:42:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T19:28:08.000000Z","updated_at":"2025-03-17T19:28:08.000000Z","inspection_violations":[{"id":5070178,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_violation_id":"253512183","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195502966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"39311"},{"id":5070179,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_violation_id":"253512184","seq_no":"2","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"1","insp_unit_id":"195502966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"39313C3"},{"id":5070180,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_violation_id":"253512185","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195502966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3939A"},{"id":5070181,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_violation_id":"253512186","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195502966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3939A"},{"id":5070182,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_violation_id":"253512187","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195502967","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:34.000000Z","updated_at":"2025-03-17T21:30:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5285042,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_unit_id":"195502966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"1L19761","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK45PU99894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"},{"id":5285043,"change_date":"2023-06-14 21:42:00","inspection_id":"78894559","insp_unit_id":"195502967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"12","insp_unit_license":"127B503","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:40.000000Z","updated_at":"2025-03-17T22:44:40.000000Z"}]},{"id":2957438,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","dot_number":"2993181","report_state":"TX","report_number":"6KN99DBTL3","insp_date":"2023-04-29 00:00:00","insp_start_time":"0938","insp_end_time":"1009","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"12300  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF STREAM","shipping_paper_number":"100363241","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-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"14","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8969352","transaction_code":"C","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2023-05-03 21:42:00","snet_input_date":"2023-04-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-03 21:42:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T19:21:25.000000Z","updated_at":"2025-03-17T19:21:25.000000Z","inspection_violations":[{"id":4540384,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694803","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39360C"},{"id":4540385,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694804","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"393203C"},{"id":4540386,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694805","seq_no":"3","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39324A"},{"id":4540387,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694806","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3939A"},{"id":4540388,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694807","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39378"},{"id":4540389,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694808","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39378"},{"id":4540390,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694809","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39375C"},{"id":4540391,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694810","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3939A"},{"id":4540392,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694811","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3939A"},{"id":4540393,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694812","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194811944","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3922"},{"id":4540394,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694813","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"3922"},{"id":4540395,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694814","seq_no":"13","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39617C"},{"id":4540396,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694815","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194811944","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"39617C"},{"id":4540397,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_violation_id":"252694816","seq_no":"15","part_no":"393","part_no_section":"201(c)","insp_viol_unit":"1","insp_unit_id":"194811943","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:12.000000Z","updated_at":"2025-03-17T21:28:12.000000Z","normalized_code":"393201C"}],"inspection_per_units":[{"id":4759008,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_unit_id":"194811943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"460250G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK65DV16406","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"},{"id":4759009,"change_date":"2023-05-08 21:42:00","inspection_id":"78522405","insp_unit_id":"194811944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"075C123","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2489TA854310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:30.000000Z","updated_at":"2025-03-17T22:40:30.000000Z"}]},{"id":2307117,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","dot_number":"2993181","report_state":"TX","report_number":"6IAB9DCGKG","insp_date":"2023-02-03 00:00:00","insp_start_time":"1106","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115342","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8897586","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T19:09:14.000000Z","updated_at":"2025-03-17T19:09:14.000000Z","inspection_violations":[{"id":3556372,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975753","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39378"},{"id":3556373,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975754","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39395F"},{"id":3556374,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975755","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3939A"},{"id":3556375,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975756","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3939A"},{"id":3556376,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975757","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3939A"},{"id":3556377,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975758","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"193251802","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39319"},{"id":3556378,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975759","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193251803","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39375A3"},{"id":3556379,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975760","seq_no":"8","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"193251803","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"393205C"},{"id":3556380,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975761","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193251803","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"3922"},{"id":3556381,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_violation_id":"250975762","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193251803","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:47.000000Z","updated_at":"2025-03-17T21:23:47.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3714011,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_unit_id":"193251802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M61520","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR79LAF8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:36.000000Z","updated_at":"2025-03-17T22:32:36.000000Z"},{"id":3714012,"change_date":"2023-02-06 21:41:00","inspection_id":"77782932","insp_unit_id":"193251803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"075C123","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2489TA854310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:36.000000Z","updated_at":"2025-03-17T22:32:36.000000Z"}]},{"id":1930878,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","dot_number":"2993181","report_state":"TX","report_number":"6GN89DBTBM","insp_date":"2022-12-06 00:00:00","insp_start_time":"0833","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HYUNDAI STEEL USA","shipping_paper_number":"163814","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-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8848300","transaction_code":"A","transaction_date":"2022-12-12 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2022-12-12 21:44:00","snet_input_date":"2022-12-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-12 21:44:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T19:02:13.000000Z","updated_at":"2025-03-17T19:02:13.000000Z","inspection_violations":[{"id":3001590,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063649","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"192392165","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"393203A"},{"id":3001591,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063650","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"192392165","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39355D1"},{"id":3001592,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063651","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192392165","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"3922"},{"id":3001593,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063652","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192392165","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39347E"},{"id":3001594,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063653","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192392165","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39353B"},{"id":3001595,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063654","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192392166","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39347E"},{"id":3001596,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063655","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192392166","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39347E"},{"id":3001597,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063656","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"192392166","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39347E"},{"id":3001598,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063657","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"192392166","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39353B"},{"id":3001599,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_violation_id":"250063658","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192392166","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3107359,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_unit_id":"192392165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"53602","insp_unit_license":"700089G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK26LU41670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:17.000000Z","updated_at":"2025-03-17T22:28:17.000000Z"},{"id":3107360,"change_date":"2022-12-12 21:44:00","inspection_id":"77353153","insp_unit_id":"192392166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"700114G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:17.000000Z","updated_at":"2025-03-17T22:28:17.000000Z"}]},{"id":2247116,"change_date":"2023-01-27 21:41:00","inspection_id":"77714956","dot_number":"2993181","report_state":"TX","report_number":"6GH79DGTIY","insp_date":"2022-11-30 00:00:00","insp_start_time":"0735","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP NORTH WES","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GSM","shipping_paper_number":"100317257","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-01-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"8889728","transaction_code":"A","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2023-01-27 21:41:00","snet_input_date":"2022-11-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-27 21:41:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T19:08:07.000000Z","updated_at":"2025-03-17T19:08:07.000000Z","inspection_violations":[{"id":3471868,"change_date":"2023-01-27 21:41:00","inspection_id":"77714956","insp_violation_id":"250830720","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193111778","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:23:24.000000Z","updated_at":"2025-03-17T21:23:24.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":3617002,"change_date":"2023-01-27 21:41:00","inspection_id":"77714956","insp_unit_id":"193111778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"53602","insp_unit_license":"665287G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK26LU41670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"},{"id":3617003,"change_date":"2023-01-27 21:41:00","inspection_id":"77714956","insp_unit_id":"193111779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"665266G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:56.000000Z","updated_at":"2025-03-17T22:31:56.000000Z"}]},{"id":988069,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","dot_number":"2993181","report_state":"TX","report_number":"6D6A9DAZUC","insp_date":"2022-08-03 00:00:00","insp_start_time":"0945","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  CLINTON DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"16","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8736451","transaction_code":"C","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2022-08-08 21:40:00","snet_input_date":"2022-08-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-08 21:40:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T18:45:05.000000Z","updated_at":"2025-03-17T18:45:05.000000Z","inspection_violations":[{"id":1559124,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642708","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39395A"},{"id":1559125,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642709","seq_no":"2","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"393203A"},{"id":1559126,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642710","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559127,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642711","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39311"},{"id":1559128,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642712","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559129,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642713","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559130,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642714","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39319"},{"id":1559131,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642715","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559132,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642716","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559133,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642717","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559134,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642718","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"3939A"},{"id":1559135,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642719","seq_no":"12","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"393203C"},{"id":1559136,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642720","seq_no":"13","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39360C"},{"id":1559137,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642721","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39375A3"},{"id":1559138,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642722","seq_no":"15","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190246776","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39617C"},{"id":1559139,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_violation_id":"247642723","seq_no":"16","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190246777","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:19.000000Z","updated_at":"2025-03-17T21:14:19.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1590606,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_unit_id":"190246776","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M41945","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK26LU41670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"},{"id":1590607,"change_date":"2022-08-10 21:40:00","inspection_id":"76263720","insp_unit_id":"190246777","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"127B503","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:02.000000Z","updated_at":"2025-03-17T22:18:02.000000Z"}]},{"id":492769,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","dot_number":"2993181","report_state":"TX","report_number":"6B089DBU1T","insp_date":"2022-05-17 00:00:00","insp_start_time":"0803","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RICHARDSON GROUP","shipping_paper_number":"1283404","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"15","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8667360","transaction_code":"A","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02993181","upload_search_indicator":"M","census_search_date":"2022-05-26 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T18:36:21.000000Z","updated_at":"2025-03-17T18:36:21.000000Z","inspection_violations":[{"id":781643,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106294","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39347E"},{"id":781644,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106295","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39347E"},{"id":781645,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106296","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39353B"},{"id":781646,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106297","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3963A1"},{"id":781647,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106298","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39347E"},{"id":781648,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106299","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39353B"},{"id":781649,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106300","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39345D"},{"id":781650,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106301","seq_no":"8","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39395A"},{"id":781651,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106302","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3939A"},{"id":781652,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106303","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3939A"},{"id":781653,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106304","seq_no":"11","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"393201A"},{"id":781654,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106305","seq_no":"12","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"393106B"},{"id":781655,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106306","seq_no":"13","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39617C"},{"id":781656,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106307","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188938913","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39617C"},{"id":781657,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_violation_id":"246106308","seq_no":"15","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188938912","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":792359,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_unit_id":"188938912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRED","insp_unit_company":"53602","insp_unit_license":"123418G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK26LU41670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:04.000000Z","updated_at":"2025-03-17T22:13:04.000000Z"},{"id":792360,"change_date":"2022-05-26 21:43:00","inspection_id":"75680880","insp_unit_id":"188938913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"123899G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJF48276TL386523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:04.000000Z","updated_at":"2025-03-17T22:13:04.000000Z"}]},{"id":398996,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","dot_number":"2993181","report_state":"TX","report_number":"6AUA9DJV21","insp_date":"2022-05-11 00:00:00","insp_start_time":"1030","insp_end_time":"1119","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","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-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8655061","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":"02993181","upload_search_indicator":"M","census_search_date":"2022-05-16 21:43:00","snet_input_date":"2022-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"DAVID TRIGUEROS","insp_carrier_street":"28979 SAN BERNARD RIVER LOOP","insp_carrier_city":"SPRING","insp_carrier_state":"TX","insp_carrier_zip_code":"77386","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0936978","created_at":"2025-03-17T18:34:28.000000Z","updated_at":"2025-03-17T18:34:28.000000Z","inspection_violations":[{"id":624220,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855454","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188738095","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39395A"},{"id":624221,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855455","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188738095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"3939A"},{"id":624222,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855456","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188738096","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"3939A"},{"id":624223,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855457","seq_no":"4","part_no":"393","part_no_section":"86(a)(3)","insp_viol_unit":"2","insp_unit_id":"188738096","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"39386A3"},{"id":624224,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855458","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"188738096","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"393207A"},{"id":624225,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_violation_id":"245855459","seq_no":"6","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"188738096","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:57.000000Z","updated_at":"2025-03-17T21:09:57.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":644906,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_unit_id":"188738095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M38566","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSZYB4XPA37914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"},{"id":644907,"change_date":"2022-05-17 21:43:00","inspection_id":"75569199","insp_unit_id":"188738096","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"120581G","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N1482CXY5991491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2993181\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2993181\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2993181\/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\/2993181\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}