{"current_page":1,"data":[{"id":12195722,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","dot_number":"2272638","report_state":"TX","report_number":"V262387123","insp_date":"2026-06-11 00:00:00","insp_start_time":"1305","insp_end_time":"1349","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 60 EB 630","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KELLY BURT DOZER","shipping_paper_number":"673733","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9993062","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2026-06-15 21:42:00","snet_input_date":"2026-06-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-15 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HIGHWAY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2026-06-18T09:41:06.000000Z","updated_at":"2026-06-24T09:32:48.000000Z","inspection_violations":[{"id":21223675,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_violation_id":"274927671","seq_no":"1","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"214120140","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:01:20.000000Z","updated_at":"2026-06-24T09:44:26.000000Z","normalized_code":"393203C"},{"id":21223676,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_violation_id":"274927672","seq_no":"2","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"214120140","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-18T10:01:20.000000Z","updated_at":"2026-06-24T09:44:26.000000Z","normalized_code":"393207A"},{"id":21223677,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_violation_id":"274927673","seq_no":"3","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"214120140","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:01:20.000000Z","updated_at":"2026-06-24T09:44:26.000000Z","normalized_code":"39324A"},{"id":21223678,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_violation_id":"274927674","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"214120140","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:01:20.000000Z","updated_at":"2026-06-24T09:44:26.000000Z","normalized_code":"3939"},{"id":21223679,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_violation_id":"274927675","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-18T10:01:20.000000Z","updated_at":"2026-06-24T09:44:26.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":21182639,"change_date":"2026-06-15 21:42:00","inspection_id":"88152392","insp_unit_id":"214120140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"VDK2912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:18:07.000000Z","updated_at":"2026-06-24T09:05:32.000000Z"}]},{"id":12043984,"change_date":"2026-05-28 21:42:00","inspection_id":"87984715","dot_number":"2272638","report_state":"TX","report_number":"V262373565","insp_date":"2026-05-26 00:00:00","insp_start_time":"1510","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 5 MILES S HEARN","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZAS TRUCKING","shipping_paper_number":"N\/A","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-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9972189","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2026-05-28 21:42:00","snet_input_date":"2026-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HIGHWAY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2026-06-01T09:40:04.000000Z","updated_at":"2026-06-08T09:31:49.000000Z","inspection_violations":[{"id":20956475,"change_date":"2026-05-28 21:42:00","inspection_id":"87984715","insp_violation_id":"274564485","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213805581","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"39395A"},{"id":20956473,"change_date":"2026-05-28 21:42:00","inspection_id":"87984715","insp_violation_id":"274564483","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213805581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"39311"},{"id":20956474,"change_date":"2026-05-28 21:42:00","inspection_id":"87984715","insp_violation_id":"274564484","seq_no":"2","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"213805581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:50.000000Z","updated_at":"2026-06-08T09:44:17.000000Z","normalized_code":"39324A"}],"inspection_per_units":[{"id":20933312,"change_date":"2026-05-28 21:42:00","inspection_id":"87984715","insp_unit_id":"213805581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"25","insp_unit_license":"XTT4826","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y96M032291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:22.000000Z","updated_at":"2026-06-08T09:04:09.000000Z"}]},{"id":12000064,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","dot_number":"2272638","report_state":"TX","report_number":"V262369200","insp_date":"2026-05-20 00:00:00","insp_start_time":"1000","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 21 EB 640","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI MATERIALS","shipping_paper_number":"165349","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","viol_total":"6","oos_total":"3","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9966484","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2026-05-22 21:39:00","snet_input_date":"2026-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 21:39:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HIGHWAY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2026-05-25T09:41:21.000000Z","updated_at":"2026-06-02T09:32:58.000000Z","inspection_violations":[{"id":20877989,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458699","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213717332","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"3922RG"},{"id":20877985,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458695","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-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"38323A2"},{"id":20877986,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458696","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-05-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"39141APC"},{"id":20877987,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458697","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"213717332","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"39311"},{"id":20877988,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458698","seq_no":"4","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"213717332","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"393209D"},{"id":20877990,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_violation_id":"274458700","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:18.000000Z","updated_at":"2026-06-02T09:45:38.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20860603,"change_date":"2026-05-22 21:39:00","inspection_id":"87938469","insp_unit_id":"213717332","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M11","insp_unit_license":"YDF3579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18YX1W137250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:37.000000Z","updated_at":"2026-06-02T09:06:29.000000Z"}]},{"id":11544297,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","dot_number":"2272638","report_state":"TX","report_number":"V262142457","insp_date":"2026-03-27 00:00:00","insp_start_time":"0645","insp_end_time":"0721","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6","county_code_state":"TX","county_code":"395","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MEDNOZA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9903132","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":"02272638","upload_search_indicator":"M","census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2026-04-04T09:43:33.000000Z","updated_at":"2026-04-12T09:32:38.000000Z","inspection_violations":[{"id":19503766,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_violation_id":"272800199","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212483754","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:27.000000Z","updated_at":"2026-04-11T09:48:39.000000Z","normalized_code":"3939"},{"id":19503767,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_violation_id":"272800200","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"212483754","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:27.000000Z","updated_at":"2026-04-11T09:48:39.000000Z","normalized_code":"3939H"},{"id":19503768,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_violation_id":"272800201","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212483754","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:27.000000Z","updated_at":"2026-04-11T09:48:39.000000Z","normalized_code":"3939"},{"id":19503769,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_violation_id":"272800202","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"212483754","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:27.000000Z","updated_at":"2026-04-11T09:48:39.000000Z","normalized_code":"39395A"},{"id":19503765,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_violation_id":"272800198","seq_no":"1","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:27.000000Z","updated_at":"2026-04-11T09:48:39.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":19781382,"change_date":"2026-04-01 21:40:00","inspection_id":"87466843","insp_unit_id":"212483754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M06","insp_unit_license":"VDK2910","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y94N155891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:48.000000Z","updated_at":"2026-04-12T09:11:33.000000Z"}]},{"id":11489955,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","dot_number":"2272638","report_state":"TX","report_number":"V262239228","insp_date":"2026-03-25 00:00:00","insp_start_time":"0823","insp_end_time":"0911","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 21 MP 642","county_code_state":"TX","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9897551","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2026-03-29T09:54:18.000000Z","updated_at":"2026-04-06T09:33:44.000000Z","inspection_violations":[{"id":19399011,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666869","seq_no":"1","part_no":"393","part_no_section":"205A","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"393205A"},{"id":19399012,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666870","seq_no":"2","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"393205C"},{"id":19399013,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666871","seq_no":"3","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"393205C"},{"id":19399014,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666872","seq_no":"4","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"39348A"},{"id":19399015,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666873","seq_no":"5","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"39383G"},{"id":19399016,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666874","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"39617C"},{"id":19399017,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666875","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"3963A1"},{"id":19399018,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_violation_id":"272666876","seq_no":"8","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"212361382","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-29T10:23:32.000000Z","updated_at":"2026-04-06T09:55:02.000000Z","normalized_code":"3965BHWSLIW"}],"inspection_per_units":[{"id":19682762,"change_date":"2026-03-26 21:40:00","inspection_id":"87409620","insp_unit_id":"212361382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"MP","insp_unit_license":"VDK2912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:03.000000Z","updated_at":"2026-04-06T09:12:59.000000Z"}]},{"id":9745269,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","dot_number":"2272638","report_state":"TX","report_number":"V252019373","insp_date":"2025-09-17 00:00:00","insp_start_time":"0840","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6232  TX21 WB","county_code_state":"TX","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","shipping_paper_number":"157594","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"10","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9702206","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-09-22 21:39:00","snet_input_date":"2025-09-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-09-25T10:00:27.000000Z","updated_at":"2025-09-25T10:00:27.000000Z","inspection_violations":[{"id":16009547,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846661","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"39347E"},{"id":16009548,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846662","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"39347E"},{"id":16009549,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846663","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"39353B"},{"id":16009550,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846664","seq_no":"4","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"39375A3"},{"id":16009551,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846665","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"39617C"},{"id":16009552,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846666","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"3963A1BOS"},{"id":16009553,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846667","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"3922W"},{"id":16009554,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846668","seq_no":"8","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"3922W"},{"id":16009555,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846669","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"3922RG"},{"id":16009556,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_violation_id":"268846670","seq_no":"10","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209078559","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-25T10:15:42.000000Z","updated_at":"2025-09-26T10:16:10.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16140525,"change_date":"2025-09-22 21:39:00","inspection_id":"85842225","insp_unit_id":"209078559","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"24","insp_unit_license":"VYX5565","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y15M020649","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:27.000000Z","updated_at":"2025-09-26T09:45:45.000000Z"}]},{"id":9381130,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","dot_number":"2272638","report_state":"TX","report_number":"77QA9DJZ2Q","insp_date":"2025-08-07 00:00:00","insp_start_time":"1036","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-2854 IN MONTGOMERY CO. (660","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA BCS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9660947","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-08-14T10:42:29.000000Z","updated_at":"2025-08-15T10:43:16.000000Z","inspection_violations":[{"id":15245093,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955681","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"3929A2C"},{"id":15245094,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955682","seq_no":"2","part_no":"393","part_no_section":"203B","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"393203B"},{"id":15245095,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955683","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"3939"},{"id":15245096,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955684","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"3939"},{"id":15245097,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955685","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"3939"},{"id":15245098,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_violation_id":"267955686","seq_no":"6","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"208336565","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-14T10:43:18.000000Z","updated_at":"2025-08-15T10:44:59.000000Z","normalized_code":"393104C"}],"inspection_per_units":[{"id":15456963,"change_date":"2025-08-11 21:38:00","inspection_id":"85459619","insp_unit_id":"208336565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"01","insp_unit_license":"VMN7924","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AN09Y2DM011806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:35.000000Z","updated_at":"2025-08-15T09:45:55.000000Z"}]},{"id":9366261,"change_date":"2025-08-08 21:40:00","inspection_id":"85443989","dot_number":"2272638","report_state":"TX","report_number":"V251968291","insp_date":"2025-08-06 00:00:00","insp_start_time":"0902","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13385  TX36","county_code_state":"TX","county_code":"477","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SITE 1","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9659999","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-08-08 21:40:00","snet_input_date":"2025-08-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-08 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-08-12T10:44:16.000000Z","updated_at":"2025-08-12T10:44:16.000000Z","inspection_violations":[{"id":15216965,"change_date":"2025-08-08 21:40:00","inspection_id":"85443989","insp_violation_id":"267924172","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208309309","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:36.000000Z","updated_at":"2025-08-12T10:45:50.000000Z","normalized_code":"39360C"},{"id":15216966,"change_date":"2025-08-08 21:40:00","inspection_id":"85443989","insp_violation_id":"267924173","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208309309","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:36.000000Z","updated_at":"2025-08-12T10:45:50.000000Z","normalized_code":"3939"},{"id":15216967,"change_date":"2025-08-08 21:40:00","inspection_id":"85443989","insp_violation_id":"267924174","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208309309","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:36.000000Z","updated_at":"2025-08-12T10:45:50.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":15431507,"change_date":"2025-08-08 21:40:00","inspection_id":"85443989","insp_unit_id":"208309309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M22","insp_unit_license":"RTM8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y33W151921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:27.000000Z","updated_at":"2025-08-12T09:46:09.000000Z"}]},{"id":8770276,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","dot_number":"2272638","report_state":"TX","report_number":"V251883790","insp_date":"2025-05-22 00:00:00","insp_start_time":"1117","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 50 MP 414","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TRAVIS MATERIALS","shipping_paper_number":"18609","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-05-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9594083","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-05-29 21:42:00","snet_input_date":"2025-05-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-29 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-06-01T10:01:25.000000Z","updated_at":"2025-06-04T10:00:45.000000Z","inspection_violations":[{"id":14013692,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553541","seq_no":"1","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"207133541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39311LR"},{"id":14013693,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553542","seq_no":"2","part_no":"393","part_no_section":"11UR","insp_viol_unit":"2","insp_unit_id":"207133541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39311UR"},{"id":14013694,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553543","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207133540","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39360C"},{"id":14013695,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553544","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207133540","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"3939"},{"id":14013696,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553545","seq_no":"5","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207133540","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39395A"},{"id":14013697,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553546","seq_no":"6","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207133540","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39395F"},{"id":14013698,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553547","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"207133541","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39617C"},{"id":14013699,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_violation_id":"266553548","seq_no":"8","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207133540","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:42.000000Z","updated_at":"2025-06-02T10:17:52.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":14347787,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_unit_id":"207133540","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"102","insp_unit_license":"1N57109","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AN07Y0DM013475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:46.000000Z","updated_at":"2025-06-02T09:46:00.000000Z"},{"id":14347788,"change_date":"2025-05-29 21:42:00","inspection_id":"84815218","insp_unit_id":"207133541","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"206","insp_unit_license":"219C492","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"56EA75C23GA000036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:46.000000Z","updated_at":"2025-06-02T09:46:00.000000Z"}]},{"id":8550565,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","dot_number":"2272638","report_state":"TX","report_number":"V251850531","insp_date":"2025-05-01 00:00:00","insp_start_time":"1015","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6 AT OLD BRYAN HWY","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9568703","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-05-08T10:03:47.000000Z","updated_at":"2025-05-09T10:23:46.000000Z","inspection_violations":[{"id":13549502,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015429","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"39021A"},{"id":13549503,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015430","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"39360C"},{"id":13549504,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015431","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"39375A3"},{"id":13549505,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015432","seq_no":"4","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"39383G"},{"id":13549506,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015433","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"3922RG"},{"id":13549507,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_violation_id":"266015434","seq_no":"5","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"206649272","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:28:34.000000Z","updated_at":"2025-05-09T10:47:56.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":13905794,"change_date":"2025-05-05 21:40:00","inspection_id":"84583682","insp_unit_id":"206649272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M23","insp_unit_license":"VYX5566","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y86N005733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:58:07.000000Z","updated_at":"2025-05-09T10:05:12.000000Z"}]},{"id":8536151,"change_date":"2025-05-02 21:41:00","inspection_id":"84568408","dot_number":"2272638","report_state":"TX","report_number":"V251863832","insp_date":"2025-04-30 00:00:00","insp_start_time":"1009","insp_end_time":"1053","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM60 AT BLUE JAY TRL","county_code_state":"TX","county_code":"051","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SITE ONE","shipping_paper_number":"SNOOK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9567576","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-04-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-05-05T10:16:15.000000Z","updated_at":"2025-05-06T10:06:46.000000Z","inspection_violations":[{"id":13520969,"change_date":"2025-05-02 21:41:00","inspection_id":"84568408","insp_violation_id":"265983026","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206621349","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:56:19.000000Z","updated_at":"2025-05-06T10:36:28.000000Z","normalized_code":"39395A"},{"id":13520970,"change_date":"2025-05-02 21:41:00","inspection_id":"84568408","insp_violation_id":"265983027","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:56:19.000000Z","updated_at":"2025-05-06T10:36:28.000000Z","normalized_code":"3922W"},{"id":13520971,"change_date":"2025-05-02 21:41:00","inspection_id":"84568408","insp_violation_id":"265983028","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:56:19.000000Z","updated_at":"2025-05-06T10:36:28.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":13880039,"change_date":"2025-05-02 21:41:00","inspection_id":"84568408","insp_unit_id":"206621349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M24","insp_unit_license":"VYX5565","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y15M020649","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:07:30.000000Z","updated_at":"2025-05-07T10:07:07.000000Z"}]},{"id":8476175,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","dot_number":"2272638","report_state":"TX","report_number":"V251828962","insp_date":"2025-04-24 00:00:00","insp_start_time":"1555","insp_end_time":"1621","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-28 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9562482","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-04-28 21:36:00","snet_input_date":"2025-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-28 21:36:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-05-01T10:00:50.000000Z","updated_at":"2025-05-02T10:23:43.000000Z","inspection_violations":[{"id":13401984,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","insp_violation_id":"265846458","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206505094","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:19:33.000000Z","updated_at":"2025-05-02T10:46:57.000000Z","normalized_code":"39378"},{"id":13401985,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","insp_violation_id":"265846459","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:19:33.000000Z","updated_at":"2025-05-02T10:46:57.000000Z","normalized_code":"3922W"},{"id":13401986,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","insp_violation_id":"265846460","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:19:33.000000Z","updated_at":"2025-05-02T10:46:57.000000Z","normalized_code":"3922W"},{"id":13401987,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","insp_violation_id":"265846461","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206505094","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:19:33.000000Z","updated_at":"2025-05-02T10:46:57.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13773005,"change_date":"2025-04-28 21:36:00","inspection_id":"84505019","insp_unit_id":"206505094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M07","insp_unit_license":"VDK2911","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y26N004240","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:48:45.000000Z","updated_at":"2025-05-02T09:57:58.000000Z"}]},{"id":7834302,"change_date":"2025-02-10 21:40:00","inspection_id":"83830041","dot_number":"2272638","report_state":"TX","report_number":"V251758798","insp_date":"2025-02-06 00:00:00","insp_start_time":"1330","insp_end_time":"1356","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX21 EB AT BEDNAR LN","county_code_state":"TX","county_code":"051","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LYP","shipping_paper_number":"SBL","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-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9493967","transaction_code":"A","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-02-10 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T21:00:48.000000Z","updated_at":"2025-03-17T21:00:48.000000Z","inspection_violations":[{"id":12242925,"change_date":"2025-02-10 21:40:00","inspection_id":"83830041","insp_violation_id":"264444067","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205255054","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:45.000000Z","updated_at":"2025-03-17T22:05:45.000000Z","normalized_code":"3965B"},{"id":12242926,"change_date":"2025-02-10 21:40:00","inspection_id":"83830041","insp_violation_id":"264444068","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205255054","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:45.000000Z","updated_at":"2025-03-17T22:05:45.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12643917,"change_date":"2025-02-10 21:40:00","inspection_id":"83830041","insp_unit_id":"205255054","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M11","insp_unit_license":"WCP9465","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18YX1W137250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]},{"id":7674262,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","dot_number":"2272638","report_state":"TX","report_number":"V251712228","insp_date":"2025-01-15 00:00:00","insp_start_time":"1124","insp_end_time":"1149","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1215 FM1484","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN","shipping_paper_number":"68057179","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9479279","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11991747,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106580","seq_no":"1","part_no":"392","part_no_section":"9A2","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3929A2"},{"id":11991748,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106581","seq_no":"2","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"393205C"},{"id":11991749,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106582","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39347E"},{"id":11991750,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106583","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39347E"},{"id":11991751,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106584","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39353B"},{"id":11991752,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106585","seq_no":"6","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39395A"},{"id":11991753,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_violation_id":"264106586","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204939445","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12383457,"change_date":"2025-01-21 21:40:00","inspection_id":"83661840","insp_unit_id":"204939445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"VDK2912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7474764,"change_date":"2025-01-03 21:39:00","inspection_id":"83452275","dot_number":"2272638","report_state":"TX","report_number":"71B99DJZO2","insp_date":"2024-12-19 00:00:00","insp_start_time":"0922","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0336 IN MONTGOMERY CO. (674","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9458232","transaction_code":"C","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2025-01-03 21:39:00","snet_input_date":"2024-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[{"id":11683400,"change_date":"2025-01-03 21:39:00","inspection_id":"83452275","insp_violation_id":"263752205","seq_no":"1","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"204647861","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:56.000000Z","updated_at":"2025-03-17T22:02:56.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":12058815,"change_date":"2025-01-03 21:39:00","inspection_id":"83452275","insp_unit_id":"204647861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"VDK2912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"}]},{"id":7452040,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","dot_number":"2272638","report_state":"TX","report_number":"V241712201","insp_date":"2024-12-12 00:00:00","insp_start_time":"0827","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"26152  TX105 W","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9454461","transaction_code":"C","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:51:34.000000Z","updated_at":"2025-03-17T20:51:34.000000Z","inspection_violations":[{"id":11646367,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582395","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39021A"},{"id":11646368,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582396","seq_no":"2","part_no":"392","part_no_section":"9A2","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3929A2"},{"id":11646369,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582397","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39311"},{"id":11646370,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582398","seq_no":"4","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"393201A"},{"id":11646371,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582399","seq_no":"5","part_no":"393","part_no_section":"203B","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"393203B"},{"id":11646372,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582400","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39378"},{"id":11646373,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582401","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939"},{"id":11646374,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582402","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939"},{"id":11646375,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582403","seq_no":"9","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39395A"},{"id":11646376,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582404","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"39617C"},{"id":11646377,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582405","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922RG"},{"id":11646378,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_violation_id":"263582406","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204485755","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":12022079,"change_date":"2024-12-19 21:41:00","inspection_id":"83428400","insp_unit_id":"204485755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M23","insp_unit_license":"VNB4778","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y86N005733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:43.000000Z","updated_at":"2025-03-17T23:47:43.000000Z"}]},{"id":7221776,"change_date":"2024-11-18 21:41:00","inspection_id":"83185931","dot_number":"2272638","report_state":"TX","report_number":"V241696390","insp_date":"2024-11-13 00:00:00","insp_start_time":"0826","insp_end_time":"0847","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 190 MP 664","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RESIDENCE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9430069","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11648901,"change_date":"2024-11-18 21:41:00","inspection_id":"83185931","insp_unit_id":"203937840","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"11","insp_unit_license":"VRT3647","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18YX1W137250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":7116209,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","dot_number":"2272638","report_state":"TX","report_number":"V241673136","insp_date":"2024-10-30 00:00:00","insp_start_time":"0721","insp_end_time":"0806","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6 SB SVC RD AT WES","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9417574","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:44:19.000000Z","updated_at":"2025-03-17T20:44:19.000000Z","inspection_violations":[{"id":11113326,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718313","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-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"38323A2"},{"id":11113327,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718314","seq_no":"2","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"393209E"},{"id":11113328,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718315","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39378"},{"id":11113329,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718316","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3939"},{"id":11113330,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718317","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3939H"},{"id":11113331,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718318","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3939"},{"id":11113332,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718319","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3965B"},{"id":11113333,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718320","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3965B"},{"id":11113334,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_violation_id":"262718321","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203727423","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11477568,"change_date":"2024-11-04 21:41:00","inspection_id":"83074210","insp_unit_id":"203727423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M11","insp_unit_license":"VRT3647","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18YX1W137250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":6964590,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","dot_number":"2272638","report_state":"TX","report_number":"V241637530","insp_date":"2024-10-11 00:00:00","insp_start_time":"1053","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 MP 604","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA","shipping_paper_number":"1362023051","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9402950","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-10-15 21:43:00","snet_input_date":"2024-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-15 21:43:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:41:23.000000Z","updated_at":"2025-03-17T20:41:23.000000Z","inspection_violations":[{"id":10861271,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367451","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203422853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39311"},{"id":10861272,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367452","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203422853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39311"},{"id":10861273,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367453","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"203422853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39311"},{"id":10861274,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367454","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"203422852","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39360D"},{"id":10861275,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367455","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203422852","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39378"},{"id":10861276,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367456","seq_no":"6","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"203422852","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39383G"},{"id":10861277,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367457","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203422852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"3939A"},{"id":10861278,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_violation_id":"262367458","seq_no":"8","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"203422852","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:40.000000Z","updated_at":"2025-03-17T21:58:40.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":11232955,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_unit_id":"203422852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M104","insp_unit_license":"1N06726","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y37N011781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"},{"id":11232956,"change_date":"2024-10-15 21:43:00","inspection_id":"82913146","insp_unit_id":"203422853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"ED2634","insp_unit_license":"266651E","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UNSD3426NS188088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"}]},{"id":6668481,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","dot_number":"2272638","report_state":"TX","report_number":"V241534618","insp_date":"2024-09-04 00:00:00","insp_start_time":"0833","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 MP 604","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INDIO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9371502","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-09-06 21:41:00","snet_input_date":"2024-09-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-06 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:35:13.000000Z","updated_at":"2025-03-17T20:35:13.000000Z","inspection_violations":[{"id":10377858,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665024","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39378"},{"id":10377859,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665025","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39383G"},{"id":10377860,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665026","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3939A"},{"id":10377861,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665027","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3939A"},{"id":10377862,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665028","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3939A"},{"id":10377863,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665029","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3963A1"},{"id":10377864,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_violation_id":"261665030","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202804120","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10751729,"change_date":"2024-09-06 21:41:00","inspection_id":"82598131","insp_unit_id":"202804120","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M10","insp_unit_license":"RTM8558","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y91W137241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"}]},{"id":6668482,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","dot_number":"2272638","report_state":"TX","report_number":"V241534619","insp_date":"2024-09-04 00:00:00","insp_start_time":"0920","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 MP 602","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SITE ONE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9371503","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-09-06 21:41:00","snet_input_date":"2024-09-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-06 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:35:13.000000Z","updated_at":"2025-03-17T20:35:13.000000Z","inspection_violations":[{"id":10377865,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665031","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"393209E"},{"id":10377866,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665032","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39330"},{"id":10377867,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665033","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39345B2"},{"id":10377868,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665034","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"39360C"},{"id":10377869,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665035","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3965B"},{"id":10377870,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_violation_id":"261665036","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202804121","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10751730,"change_date":"2024-09-06 21:41:00","inspection_id":"82598132","insp_unit_id":"202804121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M22","insp_unit_license":"RTM8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y33W151921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:20.000000Z","updated_at":"2025-03-17T23:34:20.000000Z"}]},{"id":6505727,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","dot_number":"2272638","report_state":"TX","report_number":"V241486153","insp_date":"2024-08-15 00:00:00","insp_start_time":"0955","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BURGESS LN AT TX47 N","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","shipping_paper_number":"143726","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50860","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9353728","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-08-19 21:42:00","snet_input_date":"2024-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-19 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10103311,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","insp_violation_id":"261444736","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"38323A2"},{"id":10103312,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","insp_violation_id":"261444737","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39141A"},{"id":10103313,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","insp_violation_id":"261444738","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"202612835","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39347A"},{"id":10103314,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","insp_violation_id":"261444739","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202612835","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":10487116,"change_date":"2024-08-27 21:43:00","inspection_id":"82424802","insp_unit_id":"202612835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"6","insp_unit_license":"VDK2910","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y94N155891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"}]},{"id":5836787,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","dot_number":"2272638","report_state":"TX","report_number":"V241419311","insp_date":"2024-05-16 00:00:00","insp_start_time":"0650","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6 SB","county_code_state":"TX","county_code":"395","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9283412","transaction_code":"A","transaction_date":"2024-05-24 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-05-24 21:39:00","snet_input_date":"2024-05-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-24 21:39:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:18:18.000000Z","updated_at":"2025-03-17T20:18:18.000000Z","inspection_violations":[{"id":9044710,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716866","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"38323A2"},{"id":9044711,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716867","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39145B"},{"id":9044712,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716868","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201073834","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39347E"},{"id":9044713,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716869","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201073834","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39353B"},{"id":9044714,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716870","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201073834","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9044715,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_violation_id":"259716871","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201073834","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9400266,"change_date":"2024-05-24 21:39:00","inspection_id":"81705291","insp_unit_id":"201073834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"VDK2912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:35.000000Z","updated_at":"2025-03-17T23:20:35.000000Z"}]},{"id":5634602,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","dot_number":"2272638","report_state":"TX","report_number":"V241364519","insp_date":"2024-04-24 00:00:00","insp_start_time":"1436","insp_end_time":"1715","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30  30'07.71\"N L","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50860","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9261192","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8713532,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231557","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39360C"},{"id":8713533,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231558","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"39378"},{"id":8713534,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231559","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3939A"},{"id":8713535,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231560","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3939A"},{"id":8713536,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231561","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3939A"},{"id":8713537,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_violation_id":"259231562","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200654619","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9076092,"change_date":"2024-04-30 21:42:00","inspection_id":"81485791","insp_unit_id":"200654619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M10","insp_unit_license":"RTM8558","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA18Y91W137241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:27.000000Z","updated_at":"2025-03-17T23:17:27.000000Z"}]},{"id":5462058,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","dot_number":"2272638","report_state":"TX","report_number":"V241364499","insp_date":"2024-04-03 00:00:00","insp_start_time":"0745","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6 SB SVC RD","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9243272","transaction_code":"C","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:11:07.000000Z","updated_at":"2025-03-17T20:11:07.000000Z","inspection_violations":[{"id":8433631,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819146","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201160770","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3939A"},{"id":8433632,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819147","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201160769","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39395A"},{"id":8433633,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819148","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201160769","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3965B"},{"id":8433634,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819149","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"38323A2"},{"id":8433635,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819150","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"201160770","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"39375A3"},{"id":8433636,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_violation_id":"259819151","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201160769","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8798366,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_unit_id":"201160769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M104","insp_unit_license":"1N06726","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y37N011781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"},{"id":8798367,"change_date":"2024-05-30 21:43:00","inspection_id":"81297380","insp_unit_id":"201160770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"ED26-34","insp_unit_license":"266651E","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UNSD3426NS188088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:49.000000Z","updated_at":"2025-03-17T23:14:49.000000Z"}]},{"id":5340840,"change_date":"2024-03-21 21:41:00","inspection_id":"81165314","dot_number":"2272638","report_state":"TX","report_number":"V241280124","insp_date":"2024-03-18 00:00:00","insp_start_time":"1430","insp_end_time":"1459","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4791 SH 21 W","county_code_state":"TX","county_code":"051","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA TRUCKING","shipping_paper_number":"SBL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9228752","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T20:08:37.000000Z","updated_at":"2025-03-17T20:08:37.000000Z","inspection_violations":[{"id":8241961,"change_date":"2024-03-21 21:41:00","inspection_id":"81165314","insp_violation_id":"258519650","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200030153","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39347E"},{"id":8241962,"change_date":"2024-03-21 21:41:00","inspection_id":"81165314","insp_violation_id":"258519651","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200030153","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39347E"},{"id":8241963,"change_date":"2024-03-21 21:41:00","inspection_id":"81165314","insp_violation_id":"258519652","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200030153","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:53.000000Z","updated_at":"2025-03-17T21:45:53.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8601323,"change_date":"2024-03-21 21:41:00","inspection_id":"81165314","insp_unit_id":"200030153","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"22","insp_unit_license":"RTM8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA18Y33W151921","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:01.000000Z","updated_at":"2025-03-17T23:13:01.000000Z"}]},{"id":3726579,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","dot_number":"2272638","report_state":"TX","report_number":"V231107405","insp_date":"2023-08-09 00:00:00","insp_start_time":"1105","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 190 MP 664","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA","shipping_paper_number":"1588009276","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-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9050686","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"MENDOZAS TRUCKING","insp_carrier_street":"5101 LEONARD RD #12","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:36:29.000000Z","updated_at":"2025-03-17T19:36:29.000000Z","inspection_violations":[{"id":5748285,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615906","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39311"},{"id":5748286,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615907","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39311"},{"id":5748287,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615908","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39311"},{"id":5748288,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615909","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196496050","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39311"},{"id":5748289,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615910","seq_no":"5","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196496050","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"393205C"},{"id":5748290,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615911","seq_no":"6","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"196496050","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"393205C"},{"id":5748291,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615912","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5748292,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615913","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5748293,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615914","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3939A"},{"id":5748294,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615915","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196496050","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3963A1"},{"id":5748295,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_violation_id":"254615916","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196496051","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5992082,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_unit_id":"196496050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M104","insp_unit_license":"1N06726","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y37N011781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"},{"id":5992083,"change_date":"2023-08-11 21:39:00","inspection_id":"79388089","insp_unit_id":"196496051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"2634","insp_unit_license":"266651E","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UNSD3426NS188088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:21.000000Z","updated_at":"2025-03-17T22:50:21.000000Z"}]},{"id":3623986,"change_date":"2023-07-28 21:42:00","inspection_id":"79273248","dot_number":"2272638","report_state":"TX","report_number":"V231094012","insp_date":"2023-07-26 00:00:00","insp_start_time":"1112","insp_end_time":"1153","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 21 MP 642","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9040198","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2023-07-28 21:42:00","snet_input_date":"2023-07-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-28 21:42:00","insp_carrier_name":"MENDOZAS TRUCKING","insp_carrier_street":"5101 LEONARD RD #12","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:34:32.000000Z","updated_at":"2025-03-17T19:34:32.000000Z","inspection_violations":[{"id":5588752,"change_date":"2023-07-28 21:42:00","inspection_id":"79273248","insp_violation_id":"254354415","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"38323A2"},{"id":5588753,"change_date":"2023-07-28 21:42:00","inspection_id":"79273248","insp_violation_id":"254354416","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196260748","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"39360C"},{"id":5588754,"change_date":"2023-07-28 21:42:00","inspection_id":"79273248","insp_violation_id":"254354417","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"196260748","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":5826762,"change_date":"2023-07-28 21:42:00","inspection_id":"79273248","insp_unit_id":"196260748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M24","insp_unit_license":"RCN8130","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y15M020649","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:01.000000Z","updated_at":"2025-03-17T22:49:01.000000Z"}]},{"id":3569537,"change_date":"2023-07-21 21:41:00","inspection_id":"79212181","dot_number":"2272638","report_state":"TX","report_number":"V231087846","insp_date":"2023-07-20 00:00:00","insp_start_time":"0824","insp_end_time":"0849","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6 MP 586","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9034107","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":null,"census_search_date":"2023-07-21 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"MARTIN MENDOZA","insp_carrier_street":"5101 LEONARD RD #12","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77807","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:33:32.000000Z","updated_at":"2025-03-17T19:33:32.000000Z","inspection_violations":[{"id":5504233,"change_date":"2023-07-21 21:41:00","inspection_id":"79212181","insp_violation_id":"254214261","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196136640","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39348A"},{"id":5504234,"change_date":"2023-07-21 21:41:00","inspection_id":"79212181","insp_violation_id":"254214262","seq_no":"2","part_no":"393","part_no_section":"84","insp_viol_unit":"1","insp_unit_id":"196136640","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39384"},{"id":5504235,"change_date":"2023-07-21 21:41:00","inspection_id":"79212181","insp_violation_id":"254214263","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196136640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5739504,"change_date":"2023-07-21 21:41:00","inspection_id":"79212181","insp_unit_id":"196136640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"LRT1806","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"}]},{"id":3378495,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","dot_number":"2272638","report_state":"TX","report_number":"V231030049","insp_date":"2023-06-15 00:00:00","insp_start_time":"0946","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 21 EB AT FAZZINO","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KUDER PIT","shipping_paper_number":"25391","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"11","oos_total":"3","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9015201","transaction_code":"C","transaction_date":"2023-12-14 00:00:00","upload_date":"2023-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2023-12-14 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-27 21:41:00","insp_carrier_name":"MENDOZAS TRUCKING","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:29:48.000000Z","updated_at":"2025-03-17T19:29:48.000000Z","inspection_violations":[{"id":5210381,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897520","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"38323A2"},{"id":5210382,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897521","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39141A"},{"id":5210383,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897522","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"393205C"},{"id":5210384,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897523","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39348A"},{"id":5210385,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897524","seq_no":"5","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39375A1"},{"id":5210386,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897525","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39375A3"},{"id":5210387,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897526","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39375A3"},{"id":5210388,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897527","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939A"},{"id":5210389,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897528","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939A"},{"id":5210390,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897529","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198517196","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3939A"},{"id":5210391,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_violation_id":"256897530","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5431412,"change_date":"2023-12-14 21:43:00","inspection_id":"78997639","insp_unit_id":"198517196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M9","insp_unit_license":"LRT1806","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA13Y0WW085237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:51.000000Z","updated_at":"2025-03-17T22:45:51.000000Z"}]},{"id":2856226,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","dot_number":"2272638","report_state":"TX","report_number":"6KC80XLKGH","insp_date":"2023-04-18 00:00:00","insp_start_time":"0815","insp_end_time":"0907","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0021 IN BRAZOS CO. (633-644","county_code_state":"TX","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"5","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8959589","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:19:19.000000Z","updated_at":"2025-03-17T19:19:19.000000Z","inspection_violations":[{"id":4383597,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_violation_id":"252354408","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"3929A2"},{"id":4383598,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_violation_id":"252354409","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"194507002","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"39345"},{"id":4383599,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_violation_id":"252354410","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194507002","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"3939A"},{"id":4383600,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_violation_id":"252354411","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194507002","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"39395A"},{"id":4383601,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_violation_id":"252354412","seq_no":"5","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4596138,"change_date":"2023-04-20 21:42:00","inspection_id":"78407958","insp_unit_id":"194507002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M06","insp_unit_license":"STG2902","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y94N155891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:15.000000Z","updated_at":"2025-03-17T22:39:15.000000Z"}]},{"id":2720780,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","dot_number":"2272638","report_state":"TX","report_number":"6HLE0KGHA1","insp_date":"2023-01-09 00:00:00","insp_start_time":"1348","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0006 IN BRAZOS CO. (586-610","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BPI","shipping_paper_number":"42218","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8943105","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"MENDOZA BCS TRUCKING LLC","insp_carrier_street":"6343 S STAE HWY 6","insp_carrier_city":"HEARNE","insp_carrier_state":"TX","insp_carrier_zip_code":"77859","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T19:16:55.000000Z","updated_at":"2025-03-17T19:16:55.000000Z","inspection_violations":[{"id":4179173,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018678","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194199605","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39395A"},{"id":4179174,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018679","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194199605","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3939A"},{"id":4179175,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018680","seq_no":"3","part_no":"393","part_no_section":"70(b)","insp_viol_unit":"1","insp_unit_id":"194199605","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39370B"},{"id":4179176,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018681","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194199605","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3939A"},{"id":4179177,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018682","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194199605","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"3939A"},{"id":4179178,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_violation_id":"252018683","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"194199606","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:32.000000Z","updated_at":"2025-03-17T21:26:32.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4379590,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_unit_id":"194199605","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M104","insp_unit_license":"1N06726","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y37N011781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"},{"id":4379591,"change_date":"2023-04-03 21:40:00","inspection_id":"78254821","insp_unit_id":"194199606","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"ED26-34","insp_unit_license":"266651E","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UNSD3426NS188088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:28.000000Z","updated_at":"2025-03-17T22:37:28.000000Z"}]},{"id":1047887,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","dot_number":"2272638","report_state":"TX","report_number":"6DB70XLKOI","insp_date":"2022-08-08 00:00:00","insp_start_time":"0730","insp_end_time":"0809","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0006 IN BRAZOS CO. (586-610","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MENDOZA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"13","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8743328","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":null,"census_search_date":"2022-08-16 21:39:00","snet_input_date":"2022-08-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-16 21:39:00","insp_carrier_name":"MARTIN MENDOZA","insp_carrier_street":"5101 LEONARD RD #12","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77807","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1650584,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747219","seq_no":"13","part_no":"393","part_no_section":"13(c)(2)","insp_viol_unit":"2","insp_unit_id":"190336573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39313C2"},{"id":1650585,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747220","seq_no":"14","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"190336573","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39617C"},{"id":1650586,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747221","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39360D"},{"id":1650587,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747222","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39360C"},{"id":1650588,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747223","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39378"},{"id":1650589,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747224","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3963A1"},{"id":1650590,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747225","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650591,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747226","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650592,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747227","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650593,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747228","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190336572","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650594,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747229","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190336573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3939A"},{"id":1650595,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747230","seq_no":"11","part_no":"393","part_no_section":"13(c)(1)","insp_viol_unit":"2","insp_unit_id":"190336573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39313C1"},{"id":1650596,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_violation_id":"247747231","seq_no":"12","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"190336573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39313C3"}],"inspection_per_units":[{"id":1686165,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_unit_id":"190336572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M102","insp_unit_license":"1N24618","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX04Y68M003579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"},{"id":1686166,"change_date":"2022-08-16 21:39:00","inspection_id":"76333183","insp_unit_id":"190336573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":"M102T","insp_unit_license":"212B912","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5TU2434297S000029","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:38.000000Z","updated_at":"2025-03-17T22:18:38.000000Z"}]},{"id":648983,"change_date":"2022-06-20 21:36:00","inspection_id":"75866366","dot_number":"2272638","report_state":"TX","report_number":"6BN90KGHJW","insp_date":"2022-06-09 00:00:00","insp_start_time":"0927","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0030 IN GRIMES CO. (634-658","county_code_state":"TX","county_code":"185","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8687836","transaction_code":"A","transaction_date":"2022-06-20 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02272638","upload_search_indicator":null,"census_search_date":"2022-06-20 21:36:00","snet_input_date":"2022-06-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-20 21:36:00","insp_carrier_name":"MARTIN MENDOZA","insp_carrier_street":"5101 LEONARD RD #12","insp_carrier_city":"BRYAN","insp_carrier_state":"TX","insp_carrier_zip_code":"77807","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0831977","created_at":"2025-03-17T18:39:10.000000Z","updated_at":"2025-03-17T18:39:10.000000Z","inspection_violations":[{"id":1021650,"change_date":"2022-06-20 21:36:00","inspection_id":"75866366","insp_violation_id":"246590649","seq_no":"1","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"189352382","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39347A"},{"id":1021651,"change_date":"2022-06-20 21:36:00","inspection_id":"75866366","insp_violation_id":"246590650","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189352382","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39395A"},{"id":1021652,"change_date":"2022-06-20 21:36:00","inspection_id":"75866366","insp_violation_id":"246590651","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189352382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1043502,"change_date":"2022-06-20 21:36:00","inspection_id":"75866366","insp_unit_id":"189352382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"M23","insp_unit_license":"MBD5014","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AJ06Y86N005733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:36.000000Z","updated_at":"2025-03-17T22:14:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2272638\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2272638\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2272638\/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\/2272638\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}