{"current_page":1,"data":[{"id":12562277,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","dot_number":"2967697","report_state":"TX","report_number":"V262490547","insp_date":"2026-07-23 00:00:00","insp_start_time":"0622","insp_end_time":"0728","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"494M IH35 SB","county_code_state":"TX","county_code":"097","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"8408 TEXAS ASH DR","shipping_paper_number":"53657","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"10045745","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2026-07-27 21:39:00","snet_input_date":"2026-07-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2026-07-30T09:40:10.000000Z","updated_at":"2026-08-07T09:31:12.000000Z","inspection_violations":[{"id":21873100,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764772","seq_no":"1","part_no":"393","part_no_section":"104F3","insp_viol_unit":"2","insp_unit_id":"214843177","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"393104F3"},{"id":21873101,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764773","seq_no":"2","part_no":"393","part_no_section":"11LR","insp_viol_unit":"2","insp_unit_id":"214843177","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"39311LR"},{"id":21873102,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764774","seq_no":"3","part_no":"393","part_no_section":"110C","insp_viol_unit":"2","insp_unit_id":"214843177","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"393110C"},{"id":21873103,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764775","seq_no":"4","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"214843177","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"393205C"},{"id":21873104,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764776","seq_no":"5","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214843177","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"39345B2UV"},{"id":21873105,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_violation_id":"275764777","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214843176","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:59:10.000000Z","updated_at":"2026-08-07T09:42:26.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":21812936,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_unit_id":"214843177","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2604","insp_unit_license":"FXYV01","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2485GA722604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:44.000000Z","updated_at":"2026-08-07T09:02:56.000000Z"},{"id":21812935,"change_date":"2026-07-27 21:39:00","inspection_id":"88529901","insp_unit_id":"214843176","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"345384","insp_unit_license":"3005056","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDVXMDMS6241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:44.000000Z","updated_at":"2026-08-07T09:02:56.000000Z"}]},{"id":12328084,"change_date":"2026-06-30 21:41:00","inspection_id":"88286369","dot_number":"2967697","report_state":"TX","report_number":"7GEE9DVD35","insp_date":"2026-06-15 00:00:00","insp_start_time":"1415","insp_end_time":"1446","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0121 IN COLLIN CO. (230-264","county_code_state":"TX","county_code":"085","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124740","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":"10011712","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2026-06-30 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-30 21:41:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2026-07-03T09:41:33.000000Z","updated_at":"2026-07-11T09:31:23.000000Z","inspection_violations":[{"id":21455997,"change_date":"2026-06-30 21:41:00","inspection_id":"88286369","insp_violation_id":"275231193","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"214379303","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:03:02.000000Z","updated_at":"2026-07-11T09:42:18.000000Z","normalized_code":"39395A"},{"id":21455998,"change_date":"2026-06-30 21:41:00","inspection_id":"88286369","insp_violation_id":"275231194","seq_no":"2","part_no":"393","part_no_section":"13C2","insp_viol_unit":"2","insp_unit_id":"214379304","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-03T10:03:02.000000Z","updated_at":"2026-07-11T09:42:18.000000Z","normalized_code":"39313C2"}],"inspection_per_units":[{"id":21410434,"change_date":"2026-06-30 21:41:00","inspection_id":"88286369","insp_unit_id":"214379304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"2739","insp_unit_license":"FXLP03","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EH1SN670621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:14.000000Z","updated_at":"2026-07-11T09:02:50.000000Z"},{"id":21410433,"change_date":"2026-06-30 21:41:00","inspection_id":"88286369","insp_unit_id":"214379303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"495533","insp_unit_license":"3765672","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH1SN670621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:14.000000Z","updated_at":"2026-07-11T09:02:50.000000Z"}]},{"id":11979287,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","dot_number":"2967697","report_state":"TX","report_number":"V262357355","insp_date":"2026-05-18 00:00:00","insp_start_time":"0709","insp_end_time":"0808","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH20 EB MM397","county_code_state":"TX","county_code":"367","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA","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":"2026-05-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"20","oos_total":"4","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9963571","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2026-05-20 21:42:00","snet_input_date":"2026-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-20 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2026-05-23T09:43:05.000000Z","updated_at":"2026-06-01T09:31:40.000000Z","inspection_violations":[{"id":20838498,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406716","seq_no":"3","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"213676644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39311TU"},{"id":20838508,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406726","seq_no":"13","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213676644","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39395A"},{"id":20838496,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406714","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39311"},{"id":20838497,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406715","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"213676644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39311TL"},{"id":20838499,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406717","seq_no":"4","part_no":"393","part_no_section":"110C","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"393110C"},{"id":20838500,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406718","seq_no":"5","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39319"},{"id":20838501,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406719","seq_no":"6","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39375GLOAD"},{"id":20838502,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406720","seq_no":"7","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39375GLOAD"},{"id":20838503,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406721","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3939"},{"id":20838504,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406722","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3939"},{"id":20838505,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406723","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3939"},{"id":20838506,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406724","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3939"},{"id":20838507,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406725","seq_no":"12","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3939TS"},{"id":20838509,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406727","seq_no":"14","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213676644","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39395F"},{"id":20838510,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406728","seq_no":"15","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"39617C"},{"id":20838511,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406729","seq_no":"16","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213676645","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3922RG"},{"id":20838512,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406730","seq_no":"17","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-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3922W"},{"id":20838513,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406731","seq_no":"18","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-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3922W"},{"id":20838514,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406732","seq_no":"19","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-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3922W"},{"id":20838515,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_violation_id":"274406733","seq_no":"20","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-23T10:06:32.000000Z","updated_at":"2026-06-01T09:43:02.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":20826752,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_unit_id":"213676644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7833","insp_unit_license":"1M88362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X8JD467833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:47.000000Z","updated_at":"2026-06-01T09:04:18.000000Z"},{"id":20826753,"change_date":"2026-05-20 21:42:00","inspection_id":"87916483","insp_unit_id":"213676645","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"6214","insp_unit_license":"130C431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5JYFB4829FE086214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:47.000000Z","updated_at":"2026-06-01T09:04:18.000000Z"}]},{"id":11466848,"change_date":"2026-03-24 21:40:00","inspection_id":"87385236","dot_number":"2967697","report_state":"TX","report_number":"V262261837","insp_date":"2026-03-23 00:00:00","insp_start_time":"1134","insp_end_time":"1227","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2201 IH35 SB","county_code_state":"TX","county_code":"097","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"FARM","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","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":"9894696","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2026-03-27T09:45:28.000000Z","updated_at":"2026-04-04T09:31:29.000000Z","inspection_violations":[{"id":19352720,"change_date":"2026-03-24 21:40:00","inspection_id":"87385236","insp_violation_id":"272612923","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"212313268","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:21.000000Z","updated_at":"2026-04-03T09:55:22.000000Z","normalized_code":"39311"},{"id":19352721,"change_date":"2026-03-24 21:40:00","inspection_id":"87385236","insp_violation_id":"272612924","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212313268","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:21.000000Z","updated_at":"2026-04-03T09:55:22.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19640411,"change_date":"2026-03-24 21:40:00","inspection_id":"87385236","insp_unit_id":"212313268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5102","insp_unit_license":"FYHP67","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2489SA535102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:05.000000Z","updated_at":"2026-04-04T09:05:10.000000Z"},{"id":19640410,"change_date":"2026-03-24 21:40:00","inspection_id":"87385236","insp_unit_id":"212313267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"495533","insp_unit_license":"3765672","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH1SN670621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:23:05.000000Z","updated_at":"2026-04-04T09:05:10.000000Z"}]},{"id":9999506,"change_date":"2025-10-21 21:39:00","inspection_id":"86109629","dot_number":"2967697","report_state":"TX","report_number":"V252052050","insp_date":"2025-10-15 00:00:00","insp_start_time":"1204","insp_end_time":"1214","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A801","location_desc":"US380 DECATUR SCALE","county_code_state":"TX","county_code":"497","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BUENA VISTA TURF","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-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","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":"9732951","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2025-10-21 21:39:00","snet_input_date":"2025-10-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-10-24T10:01:58.000000Z","updated_at":"2025-10-25T10:01:02.000000Z","inspection_violations":[{"id":16525864,"change_date":"2025-10-21 21:39:00","inspection_id":"86109629","insp_violation_id":"269430817","seq_no":"1","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"209582834","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:05.000000Z","updated_at":"2025-10-25T10:16:31.000000Z","normalized_code":"393205C"},{"id":16525865,"change_date":"2025-10-21 21:39:00","inspection_id":"86109629","insp_violation_id":"269430818","seq_no":"2","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"209582833","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:18:05.000000Z","updated_at":"2025-10-25T10:16:31.000000Z","normalized_code":"39345DLPC"}],"inspection_per_units":[{"id":16606685,"change_date":"2025-10-21 21:39:00","inspection_id":"86109629","insp_unit_id":"209582833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"495528","insp_unit_license":"3766140","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXSN670634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:09.000000Z","updated_at":"2025-10-25T09:46:13.000000Z"},{"id":16606686,"change_date":"2025-10-21 21:39:00","inspection_id":"86109629","insp_unit_id":"209582834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"1211","insp_unit_license":"FZJL10","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7KYFB4823MED31211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:09.000000Z","updated_at":"2025-10-25T09:46:13.000000Z"}]},{"id":9731120,"change_date":"2025-09-19 21:39:00","inspection_id":"85827274","dot_number":"2967697","report_state":"TX","report_number":"V252004947","insp_date":"2025-09-18 00:00:00","insp_start_time":"1104","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"JUSTICE RD","county_code_state":"TX","county_code":"085","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COMPANY FARM","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-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9701216","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2025-09-19 21:39:00","snet_input_date":"2025-09-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-09-23T10:02:46.000000Z","updated_at":"2025-09-23T10:02:46.000000Z","inspection_violations":[{"id":15978140,"change_date":"2025-09-19 21:39:00","inspection_id":"85827274","insp_violation_id":"268811541","seq_no":"1","part_no":"392","part_no_section":"9A","insp_viol_unit":"2","insp_unit_id":"209050956","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-09-22T10:18:33.000000Z","updated_at":"2025-09-23T10:16:44.000000Z","normalized_code":"3929A"},{"id":15978141,"change_date":"2025-09-19 21:39:00","inspection_id":"85827274","insp_violation_id":"268811542","seq_no":"2","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"209050955","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:33.000000Z","updated_at":"2025-09-23T10:16:44.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":16114746,"change_date":"2025-09-19 21:39:00","inspection_id":"85827274","insp_unit_id":"209050955","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"497378","insp_unit_license":"3765674","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH6SN670615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:07.000000Z","updated_at":"2025-09-23T09:46:13.000000Z"},{"id":16114747,"change_date":"2025-09-19 21:39:00","inspection_id":"85827274","insp_unit_id":"209050956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONT","insp_unit_company":"3103","insp_unit_license":"GDSZ33","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N1482C8M1553103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:07.000000Z","updated_at":"2025-09-23T09:46:13.000000Z"}]},{"id":7845553,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","dot_number":"2967697","report_state":"TX","report_number":"72OB9DIE75","insp_date":"2025-02-06 00:00:00","insp_start_time":"1155","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7200  DON GOMEZ DR","county_code_state":"TX","county_code":"113","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9494732","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12260563,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467552","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"205276725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39345B2PC"},{"id":12260564,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467553","seq_no":"2","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"205276725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39355D1"},{"id":12260565,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467554","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205276725","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"3965B"},{"id":12260566,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467555","seq_no":"4","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"205276726","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"393205C"},{"id":12260567,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467556","seq_no":"5","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"205276726","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39375C"},{"id":12260568,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467557","seq_no":"6","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"205276726","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"393100A"},{"id":12260569,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_violation_id":"264467558","seq_no":"7","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"205276726","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:52.000000Z","updated_at":"2025-03-17T22:05:52.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":12662091,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_unit_id":"205276725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331230","insp_unit_license":"R388674","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV2KSKP8255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"},{"id":12662092,"change_date":"2025-02-11 21:40:00","inspection_id":"83841828","insp_unit_id":"205276726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"FYHP66","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF4820262017555","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7630010,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","dot_number":"2967697","report_state":"TX","report_number":"V251754324","insp_date":"2025-01-13 00:00:00","insp_start_time":"1512","insp_end_time":"1612","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR1061 AT TX78","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA TEXAS TURF FARM","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9474136","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:56:32.000000Z","updated_at":"2025-03-17T20:56:32.000000Z","inspection_violations":[{"id":11924111,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_violation_id":"264020625","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204855097","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"39311"},{"id":11924112,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_violation_id":"264020626","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204855098","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"3939"},{"id":11924113,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_violation_id":"264020627","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204855097","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"39395A"},{"id":11924114,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_violation_id":"264020628","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204855097","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:06.000000Z","updated_at":"2025-03-17T22:04:06.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":12311535,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_unit_id":"204855097","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1M88362","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCD79X8JD467833","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"},{"id":12311536,"change_date":"2025-01-15 21:42:00","inspection_id":"83615253","insp_unit_id":"204855098","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"130C431","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5JYFB4829FE086214","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":7441454,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","dot_number":"2967697","report_state":"TX","report_number":"V241725762","insp_date":"2024-12-12 00:00:00","insp_start_time":"1050","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR1554 AT SILO RD","county_code_state":"TX","county_code":"147","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOME FARM","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-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9452879","transaction_code":"C","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-12-17 21:40:00","snet_input_date":"2024-12-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-17 21:40:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:51:30.000000Z","updated_at":"2025-03-17T20:51:30.000000Z","inspection_violations":[{"id":11628853,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556510","seq_no":"1","part_no":"391","part_no_section":"11B5-DNL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39111B5DNL"},{"id":11628854,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556511","seq_no":"2","part_no":"392","part_no_section":"9A","insp_viol_unit":"2","insp_unit_id":"204462616","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"3929A"},{"id":11628855,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556512","seq_no":"3","part_no":"393","part_no_section":"104A","insp_viol_unit":"2","insp_unit_id":"204462616","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"393104A"},{"id":11628856,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556513","seq_no":"4","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204462615","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39311TL"},{"id":11628857,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556514","seq_no":"5","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"204462615","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39345DLPC"},{"id":11628858,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556515","seq_no":"6","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"204462615","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39345DLPC"},{"id":11628859,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_violation_id":"263556516","seq_no":"7","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204462615","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:38.000000Z","updated_at":"2025-03-17T22:02:38.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":12004943,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_unit_id":"204462615","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4925","insp_unit_license":"T99003","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALJGEDV9ESFX4925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:31.000000Z","updated_at":"2025-03-17T23:47:31.000000Z"},{"id":12004944,"change_date":"2024-12-18 21:41:00","inspection_id":"83417289","insp_unit_id":"204462616","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"4075","insp_unit_license":"FXYV08","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UFFS2482GA722608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:31.000000Z","updated_at":"2025-03-17T23:47:31.000000Z"}]},{"id":6924571,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","dot_number":"2967697","report_state":"TX","report_number":"6ZAF9DMPD0","insp_date":"2024-10-07 00:00:00","insp_start_time":"1525","insp_end_time":"1554","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0875 IN ELLIS CO. (572-584)","county_code_state":"TX","county_code":"139","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA TURF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72500","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9397573","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[{"id":10792313,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_violation_id":"262272045","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"203341475","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"393100A"},{"id":10792314,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_violation_id":"262272046","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203341475","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"3939A"},{"id":10792315,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_violation_id":"262272047","seq_no":"3","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"203341474","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"39355C1"},{"id":10792316,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_violation_id":"262272048","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203341474","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"3922"},{"id":10792317,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_violation_id":"262272049","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203341474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11167763,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_unit_id":"203341474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331248","insp_unit_license":"R633796","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV4KSKP8273","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"},{"id":11167764,"change_date":"2024-10-09 21:42:00","inspection_id":"82870616","insp_unit_id":"203341475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"JIMD","insp_unit_company":"NA","insp_unit_license":"GCZV49","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"0TCT44381886901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6432776,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","dot_number":"2967697","report_state":"TX","report_number":"V241494419","insp_date":"2024-08-08 00:00:00","insp_start_time":"0810","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US69","county_code_state":"TX","county_code":"147","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"125500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9346217","transaction_code":"C","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-08-12 21:44:00","snet_input_date":"2024-08-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9989606,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_violation_id":"261145583","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"38351A"},{"id":9989607,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_violation_id":"261145584","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202350485","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39021A"},{"id":9989608,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_violation_id":"261145585","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202350485","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39311"},{"id":9989609,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_violation_id":"261145586","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202350485","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":10367631,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_unit_id":"202350485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331240","insp_unit_license":"R388479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV5KSKP8265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"},{"id":10367632,"change_date":"2024-08-12 21:44:00","inspection_id":"82346921","insp_unit_id":"202350486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"0","insp_unit_license":"FXYV01","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2485GA722604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":6177907,"change_date":"2024-07-09 21:43:00","inspection_id":"82074065","dot_number":"2967697","report_state":"TX","report_number":"6WM79DFYUP","insp_date":"2024-07-03 00:00:00","insp_start_time":"0723","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN DENTON CO. (468-482","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"9320945","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9952363,"change_date":"2024-07-09 21:43:00","inspection_id":"82074065","insp_unit_id":"201801441","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331234","insp_unit_license":"R388724","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDVXKSKP8259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"},{"id":9952364,"change_date":"2024-07-09 21:43:00","inspection_id":"82074065","insp_unit_id":"201801442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":"4122","insp_unit_license":"FYHP72","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AZBR2A16E1014122","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":6120260,"change_date":"2024-07-01 21:44:00","inspection_id":"82011945","dot_number":"2967697","report_state":"TX","report_number":"V241412787","insp_date":"2024-06-27 00:00:00","insp_start_time":"0745","insp_end_time":"0807","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"311 E KILPATRICK ST","county_code_state":"TX","county_code":"499","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA","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-07-01 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"9314352","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-07-01 21:44:00","snet_input_date":"2024-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-01 21:44:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:24:09.000000Z","updated_at":"2025-03-17T20:24:09.000000Z","inspection_violations":[{"id":9502664,"change_date":"2024-07-01 21:44:00","inspection_id":"82011945","insp_violation_id":"260415824","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"201682359","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39311"},{"id":9502665,"change_date":"2024-07-01 21:44:00","inspection_id":"82011945","insp_violation_id":"260415825","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201682359","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:00.000000Z","updated_at":"2025-03-17T21:52:00.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":9858185,"change_date":"2024-07-01 21:44:00","inspection_id":"82011945","insp_unit_id":"201682358","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2948","insp_unit_license":"T52157","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEBG7HSHX2948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"},{"id":9858186,"change_date":"2024-07-01 21:44:00","inspection_id":"82011945","insp_unit_id":"201682359","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"1212","insp_unit_license":"FZJL09","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7KYFB4825MED31212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:08.000000Z","updated_at":"2025-03-17T23:25:08.000000Z"}]},{"id":6177607,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","dot_number":"2967697","report_state":"TX","report_number":"6W969DKJ07","insp_date":"2024-06-20 00:00:00","insp_start_time":"0714","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0380 IN COLLIN CO. (628-656","county_code_state":"TX","county_code":"085","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA TURF FARM LLC","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-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"112500","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9320744","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9592770,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_violation_id":"260546050","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201800843","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39347E"},{"id":9592771,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_violation_id":"260546051","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201800843","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39347E"},{"id":9592772,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_violation_id":"260546052","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201800843","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39347E"},{"id":9592773,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_violation_id":"260546053","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201800843","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39347E"},{"id":9592774,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_violation_id":"260546054","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201800843","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9951893,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_unit_id":"201800842","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331230","insp_unit_license":"R388678","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV7KSKP8266","insp_unit_decal":"Y","insp_unit_decal_number":"33923729","created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"},{"id":9951894,"change_date":"2024-07-09 21:43:00","inspection_id":"82073734","insp_unit_id":"201800843","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTC","insp_unit_company":null,"insp_unit_license":"FYHP74","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AZBR2A14F1016971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":5795564,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","dot_number":"2967697","report_state":"TX","report_number":"V241414017","insp_date":"2024-05-17 00:00:00","insp_start_time":"1720","insp_end_time":"1755","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1417 EB","county_code_state":"TX","county_code":"181","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"STINKY'S","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-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9278013","transaction_code":"C","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-05-20 21:43:00","snet_input_date":"2024-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-20 21:43:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:17:32.000000Z","updated_at":"2025-03-17T20:17:32.000000Z","inspection_violations":[{"id":8976329,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678783","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201041674","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"39311"},{"id":8976330,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678784","seq_no":"2","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"201041674","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"39355C1"},{"id":8976331,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678785","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201041674","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"3939A"},{"id":8976332,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678786","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201041675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"3939A"},{"id":8976333,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678787","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201041675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"3939A"},{"id":8976334,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678788","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"201041674","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"39395A"},{"id":8976335,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_violation_id":"259678789","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"201041675","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:23.000000Z","updated_at":"2025-03-17T21:49:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9334868,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_unit_id":"201041674","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6880","insp_unit_license":"T96377","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEDVXDSFD6880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:53.000000Z","updated_at":"2025-03-17T23:19:53.000000Z"},{"id":9334869,"change_date":"2024-05-22 21:41:00","inspection_id":"81660276","insp_unit_id":"201041675","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"FLCX77","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"CB690033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:53.000000Z","updated_at":"2025-03-17T23:19:53.000000Z"}]},{"id":5419751,"change_date":"2024-04-02 21:43:00","inspection_id":"81251252","dot_number":"2967697","report_state":"TX","report_number":"V241371638","insp_date":"2024-04-01 00:00:00","insp_start_time":"0732","insp_end_time":"0812","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"110 TX205 NB","county_code_state":"TX","county_code":"397","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNLOADED","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-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"131500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9237805","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-04-02 21:43:00","snet_input_date":"2024-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-02 21:43:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T20:09:55.000000Z","updated_at":"2025-03-17T20:09:55.000000Z","inspection_violations":[{"id":8367661,"change_date":"2024-04-02 21:43:00","inspection_id":"81251252","insp_violation_id":"258712722","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:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"38323A2"},{"id":8367662,"change_date":"2024-04-02 21:43:00","inspection_id":"81251252","insp_violation_id":"258712723","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"200203665","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":8729562,"change_date":"2024-04-02 21:43:00","inspection_id":"81251252","insp_unit_id":"200203664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331229","insp_unit_license":"R438083","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV0KSKP8254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:10.000000Z","updated_at":"2025-03-17T23:14:10.000000Z"},{"id":8729563,"change_date":"2024-04-02 21:43:00","inspection_id":"81251252","insp_unit_id":"200203665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5102","insp_unit_license":"FYHP67","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2489SA535102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:10.000000Z","updated_at":"2025-03-17T23:14:10.000000Z"}]},{"id":4767498,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","dot_number":"2967697","report_state":"TX","report_number":"6RJ79DMP6Z","insp_date":"2024-01-02 00:00:00","insp_start_time":"0747","insp_end_time":"0836","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0287 IN ELLIS CO. (484-520)","county_code_state":"TX","county_code":"139","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA FARMS","shipping_paper_number":"PO110779","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-01-04 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9165373","transaction_code":"A","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2024-01-04 21:48:00","snet_input_date":"2024-01-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-04 21:48:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T19:57:15.000000Z","updated_at":"2025-03-17T19:57:15.000000Z","inspection_violations":[{"id":7357019,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195333","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"3922"},{"id":7357020,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195334","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"198822604","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"39021A"},{"id":7357021,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195335","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198822604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"39311"},{"id":7357022,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195336","seq_no":"4","part_no":"393","part_no_section":"110(c)","insp_viol_unit":"2","insp_unit_id":"198822605","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"393110C"},{"id":7357023,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195337","seq_no":"5","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"198822605","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"393100A"},{"id":7357024,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_violation_id":"257195338","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198822605","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:30.000000Z","updated_at":"2025-03-17T21:41:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7669683,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_unit_id":"198822604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"331240","insp_unit_license":"R388479","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHTDV5KSKP8265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:32.000000Z","updated_at":"2025-03-17T23:04:32.000000Z"},{"id":7669684,"change_date":"2024-01-04 21:48:00","inspection_id":"80538926","insp_unit_id":"198822605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2604","insp_unit_license":"FXYV01","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2485GA722604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:32.000000Z","updated_at":"2025-03-17T23:04:32.000000Z"}]},{"id":4521772,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","dot_number":"2967697","report_state":"TX","report_number":"6QCA9DFYQU","insp_date":"2023-11-20 00:00:00","insp_start_time":"1015","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN DENTON CO. (468-482","county_code_state":"TX","county_code":"121","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"METROPLEX GARDEN","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-11-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9135036","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2023-11-29 21:43:00","snet_input_date":"2023-11-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-29 21:43:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T19:52:32.000000Z","updated_at":"2025-03-17T19:52:32.000000Z","inspection_violations":[{"id":6995673,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_violation_id":"256625328","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:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"38323A2"},{"id":6995674,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_violation_id":"256625329","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"198271629","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"393203C"},{"id":6995675,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_violation_id":"256625330","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198271630","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"39617C"},{"id":6995676,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_violation_id":"256625331","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198271630","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:44.000000Z","updated_at":"2025-03-17T21:39:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7272320,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_unit_id":"198271629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2948","insp_unit_license":"T52157","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEBG7HSHX2948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"},{"id":7272321,"change_date":"2023-11-29 21:43:00","inspection_id":"80269853","insp_unit_id":"198271630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"1549","insp_unit_license":"GBZW06","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DTP10Z27WG051549","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"}]},{"id":4264487,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","dot_number":"2967697","report_state":"TX","report_number":"6PDF9DIEL0","insp_date":"2023-10-16 00:00:00","insp_start_time":"1516","insp_end_time":"1632","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7200  DON GOMEZ DR","county_code_state":"TX","county_code":"113","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"12","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9106973","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2023-10-23 21:42:00","snet_input_date":"2023-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T19:47:25.000000Z","updated_at":"2025-03-17T19:47:25.000000Z","inspection_violations":[{"id":6597371,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996740","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"38323A2"},{"id":6597372,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996741","seq_no":"2","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"393100A"},{"id":6597373,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996742","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197704262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3939A"},{"id":6597374,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996743","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197704262","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"39378"},{"id":6597375,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996744","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197704262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3939A"},{"id":6597376,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996745","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197704262","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"39345B2"},{"id":6597377,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996746","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3939A"},{"id":6597378,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996747","seq_no":"9","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"393205C"},{"id":6597379,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996748","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"39347E"},{"id":6597380,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996749","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"39347E"},{"id":6597381,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996750","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197704261","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"39347E"},{"id":6597382,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_violation_id":"255996751","seq_no":"13","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:46.000000Z","updated_at":"2025-03-17T21:37:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6858535,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_unit_id":"197704261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":null,"insp_unit_license":"GVZV48","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"13N1452C9K1545250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"},{"id":6858536,"change_date":"2023-10-23 21:42:00","inspection_id":"79985965","insp_unit_id":"197704262","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T52254","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CKX8LAB4846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:29.000000Z","updated_at":"2025-03-17T22:57:29.000000Z"}]},{"id":3836420,"change_date":"2023-08-25 21:42:00","inspection_id":"79510760","dot_number":"2967697","report_state":"TX","report_number":"V231117478","insp_date":"2023-08-24 00:00:00","insp_start_time":"0740","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4508 SH121 N NB","county_code_state":"TX","county_code":"085","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENO VISTA","shipping_paper_number":"108899","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120600","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":"9061456","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2023-08-25 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-25 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[{"id":5925948,"change_date":"2023-08-25 21:42:00","inspection_id":"79510760","insp_violation_id":"254900525","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196741356","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39345D"},{"id":5925949,"change_date":"2023-08-25 21:42:00","inspection_id":"79510760","insp_violation_id":"254900526","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196741357","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":6168276,"change_date":"2023-08-25 21:42:00","inspection_id":"79510760","insp_unit_id":"196741356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2978","insp_unit_license":"T96381","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGEDV1ESFT2978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"},{"id":6168277,"change_date":"2023-08-25 21:42:00","inspection_id":"79510760","insp_unit_id":"196741357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AZTE","insp_unit_company":"1","insp_unit_license":"FYHP69","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AZBM1A10F1016278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:49.000000Z","updated_at":"2025-03-17T22:51:49.000000Z"}]},{"id":3550327,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","dot_number":"2967697","report_state":"TX","report_number":"6MQ59DGU56","insp_date":"2023-07-13 00:00:00","insp_start_time":"0433","insp_end_time":"0538","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA TURF FARM LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9031912","transaction_code":"A","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2023-07-19 21:44:00","snet_input_date":"2023-07-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-19 21:44:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T19:33:10.000000Z","updated_at":"2025-03-17T19:33:10.000000Z","inspection_violations":[{"id":5474431,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165961","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5474432,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165962","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"196093728","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39395B"},{"id":5474433,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165963","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5474434,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165964","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5474435,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165965","seq_no":"5","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"196093728","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39360E"},{"id":5474436,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165966","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39311"},{"id":5474437,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165967","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196093728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5474438,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165968","seq_no":"8","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"393100A"},{"id":5474439,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165969","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39617C"},{"id":5474440,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_violation_id":"254165970","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196093729","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5708853,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_unit_id":"196093728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRED","insp_unit_company":"7316","insp_unit_license":"T52156","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGEBG2GLGY7316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:02.000000Z","updated_at":"2025-03-17T22:48:02.000000Z"},{"id":5708854,"change_date":"2023-07-19 21:44:00","inspection_id":"79190601","insp_unit_id":"196093729","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"JIMD","insp_unit_company":null,"insp_unit_license":"GCZV49","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"0TCT44381886901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:02.000000Z","updated_at":"2025-03-17T22:48:02.000000Z"}]},{"id":664475,"change_date":"2022-06-21 21:42:00","inspection_id":"75884735","dot_number":"2967697","report_state":"TX","report_number":"6BTA0XKWAA","insp_date":"2022-06-15 00:00:00","insp_start_time":"1018","insp_end_time":"1051","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0078 IN FANNIN CO. (196-232","county_code_state":"TX","county_code":"147","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BUENA VISTA FARMS","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-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"8690895","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0932858","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1068198,"change_date":"2022-06-21 21:42:00","inspection_id":"75884735","insp_unit_id":"189389769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7953","insp_unit_license":"T52252","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CKX8LAC7953","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1068199,"change_date":"2022-06-21 21:42:00","inspection_id":"75884735","insp_unit_id":"189389770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"1211","insp_unit_license":"FZJL10","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7KYFB4823MED31211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":487931,"change_date":"2022-05-26 21:42:00","inspection_id":"75674988","dot_number":"2967697","report_state":"OK","report_number":"B509153329","insp_date":"2022-05-26 00:00:00","insp_start_time":"1055","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"10048","location_desc":"SH 22","county_code_state":"OK","county_code":"013","insp_level_id":"4","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","shipping_paper_number":"1032033300","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"672010","transaction_code":"A","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02967697","upload_search_indicator":"M","census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"BUENA VISTA TURF FARM LLC","insp_carrier_street":"5186 FM 274","insp_carrier_city":"RAVENNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75476","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:19.000000Z","updated_at":"2025-03-17T18:36:19.000000Z","inspection_violations":[{"id":773758,"change_date":"2022-05-26 21:42:00","inspection_id":"75674988","insp_violation_id":"246091118","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:40.000000Z","updated_at":"2025-03-17T21:10:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":784432,"change_date":"2022-05-26 21:42:00","inspection_id":"75674988","insp_unit_id":"188925235","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"002-1C","insp_unit_license":"T96376","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1AKJGEDRXESFK6695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"},{"id":784433,"change_date":"2022-05-26 21:42:00","inspection_id":"75674988","insp_unit_id":"188925236","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHER","insp_unit_company":"002-1C-2","insp_unit_license":"FSLV39","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"LK18155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2967697\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2967697\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2967697\/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\/2967697\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}