{"current_page":1,"data":[{"id":11478726,"change_date":"2026-04-09 22:21:00","inspection_id":"87397760","dot_number":"4126448","report_state":"TX","report_number":"V262277947","insp_date":"2026-03-18 00:00:00","insp_start_time":"2104","insp_end_time":"2129","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B101","location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9895195","transaction_code":"C","transaction_date":"2026-03-25 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2026-03-25 21:40:00","snet_input_date":"2026-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2026-03-28T09:44:51.000000Z","updated_at":"2026-04-20T10:12:55.000000Z","inspection_violations":[{"id":20136479,"change_date":"2026-04-09 22:21:00","inspection_id":"87397760","insp_violation_id":"273496391","seq_no":"1","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"212932636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:01.000000Z","updated_at":"2026-04-19T14:06:31.000000Z","normalized_code":"39348A"},{"id":20136480,"change_date":"2026-04-09 22:21:00","inspection_id":"87397760","insp_violation_id":"273496392","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212932636","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:01.000000Z","updated_at":"2026-04-19T14:06:31.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":20189740,"change_date":"2026-04-09 22:21:00","inspection_id":"87397760","insp_unit_id":"212932636","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:45.000000Z","updated_at":"2026-04-19T10:36:33.000000Z"}]},{"id":10373715,"change_date":"2025-12-08 21:38:00","inspection_id":"86502725","dot_number":"4126448","report_state":"US","report_number":"0965002467","insp_date":"2025-12-08 00:00:00","insp_start_time":"0101","insp_end_time":"0135","registration_date":null,"region":"CS","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS","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":"U","pen_cen_match":"I","final_status_date":"2025-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2629352","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":null,"census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-12-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"2114 S 8TH ST","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:27.000000Z","updated_at":"2025-12-12T10:30:21.000000Z","inspection_violations":[{"id":17372806,"change_date":"2025-12-08 21:38:00","inspection_id":"86502725","insp_violation_id":"270518660","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-11T10:30:35.000000Z","updated_at":"2025-12-12T10:30:41.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":17340682,"change_date":"2025-12-08 21:38:00","inspection_id":"86502725","insp_unit_id":"210465381","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MOTOR COAC","insp_unit_company":"6296","insp_unit_license":"D319652","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JM8AXDW066296","insp_unit_decal":"Y","insp_unit_decal_number":"35797664","created_at":"2025-12-11T10:00:26.000000Z","updated_at":"2025-12-12T10:00:22.000000Z"}]},{"id":10282154,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","dot_number":"4126448","report_state":"TX","report_number":"V252124440","insp_date":"2025-11-19 00:00:00","insp_start_time":"2013","insp_end_time":"2041","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  IH35 NB","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS PASSENGERS","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-11-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9767591","transaction_code":"A","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-11-24 21:40:00","snet_input_date":"2025-11-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-24 21:40:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-11-27T10:30:53.000000Z","updated_at":"2025-11-28T10:31:25.000000Z","inspection_violations":[{"id":17188880,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274646","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"210246459","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"39345B2UV"},{"id":17188881,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274647","seq_no":"2","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"210246459","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"39345DLUV"},{"id":17188882,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274648","seq_no":"3","part_no":"395","part_no_section":"22H1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"39522H1"},{"id":17188883,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274649","seq_no":"4","part_no":"395","part_no_section":"22H2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"39522H2"},{"id":17188884,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274650","seq_no":"5","part_no":"395","part_no_section":"22H4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"39522H4"},{"id":17188885,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_violation_id":"270274651","seq_no":"6","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210246459","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:14.000000Z","updated_at":"2025-11-28T10:32:24.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":17163113,"change_date":"2025-11-24 21:40:00","inspection_id":"86406901","insp_unit_id":"210246459","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREO","insp_unit_company":"0107","insp_unit_license":"D319480","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2PCH3349051010107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:45.000000Z","updated_at":"2025-11-28T10:01:27.000000Z"}]},{"id":9596159,"change_date":"2026-04-09 22:15:00","inspection_id":"85685772","dot_number":"4126448","report_state":"TX","report_number":"V252011515","insp_date":"2025-09-03 00:00:00","insp_start_time":"2115","insp_end_time":"2133","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B101","location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VARIOUS","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9687514","transaction_code":"C","transaction_date":"2025-09-04 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-09-04 21:41:00","snet_input_date":"2025-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-04 21:41:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-09-10T10:45:33.000000Z","updated_at":"2026-04-20T10:04:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20127312,"change_date":"2026-04-09 22:15:00","inspection_id":"85685772","insp_unit_id":"212862134","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"Y","insp_unit_decal_number":"35384893","created_at":"2026-04-12T09:28:53.000000Z","updated_at":"2026-04-19T10:19:18.000000Z"}]},{"id":9426227,"change_date":"2026-04-09 22:14:00","inspection_id":"85507064","dot_number":"4126448","report_state":"TX","report_number":"V251966723","insp_date":"2025-08-13 00:00:00","insp_start_time":"2020","insp_end_time":"2055","registration_date":"2025-09-24 00:00:00","region":"CT","ci_status_code":"C","location":"3B101","location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9667086","transaction_code":"C","transaction_date":"2025-08-15 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-08-20T10:44:41.000000Z","updated_at":"2026-04-20T10:02:30.000000Z","inspection_violations":[{"id":19990307,"change_date":"2026-04-09 22:14:00","inspection_id":"85507064","insp_violation_id":"273333802","seq_no":"1","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"212853167","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-11T10:18:07.000000Z","updated_at":"2026-04-19T13:17:24.000000Z","normalized_code":"39347A"},{"id":19990308,"change_date":"2026-04-09 22:14:00","inspection_id":"85507064","insp_violation_id":"273333803","seq_no":"2","part_no":"396","part_no_section":"3A1-TRDL","insp_viol_unit":"1","insp_unit_id":"212853167","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-11T10:18:07.000000Z","updated_at":"2026-04-19T13:17:24.000000Z","normalized_code":"3963A1TRDL"}],"inspection_per_units":[{"id":20114089,"change_date":"2026-04-09 22:14:00","inspection_id":"85507064","insp_unit_id":"212853167","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:28:41.000000Z","updated_at":"2026-04-19T10:18:17.000000Z"}]},{"id":9173483,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","dot_number":"4126448","report_state":"US","report_number":"0965002000","insp_date":"2025-07-17 00:00:00","insp_start_time":"0106","insp_end_time":"0147","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS","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":"U","pen_cen_match":"I","final_status_date":"2025-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"4","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":"2004748","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":null,"census_search_date":"2025-07-17 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-17 21:41:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"2114 S 8TH ST","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:08.000000Z","updated_at":"2025-07-21T10:43:08.000000Z","inspection_violations":[{"id":14812167,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","insp_violation_id":"267463740","seq_no":"1","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"207920326","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"39355D1B"},{"id":14812168,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","insp_violation_id":"267463741","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207920326","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"39395F"},{"id":14812169,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","insp_violation_id":"267463742","seq_no":"3","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"207920326","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"39395B"},{"id":14812170,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","insp_violation_id":"267463743","seq_no":"4","part_no":"392","part_no_section":"8-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:30.000000Z","updated_at":"2025-07-21T10:45:30.000000Z","normalized_code":"3928D"}],"inspection_per_units":[{"id":15072813,"change_date":"2025-07-17 21:41:00","inspection_id":"85241190","insp_unit_id":"207920326","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"PREVOST","insp_unit_company":"0107","insp_unit_license":"D319480","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2PCH3349051010107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:26.000000Z","updated_at":"2025-07-21T09:45:37.000000Z"}]},{"id":8911742,"change_date":"2026-04-09 22:13:00","inspection_id":"84965363","dot_number":"4126448","report_state":"TX","report_number":"V251905490","insp_date":"2025-06-04 00:00:00","insp_start_time":"2100","insp_end_time":"2128","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HACIENDA TOURS","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-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"9608466","transaction_code":"C","transaction_date":"2025-06-17 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-06-19T10:00:25.000000Z","updated_at":"2026-04-20T10:00:50.000000Z","inspection_violations":[{"id":19967085,"change_date":"2026-04-09 22:13:00","inspection_id":"84965363","insp_violation_id":"273304227","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"212837208","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:17:12.000000Z","updated_at":"2026-04-19T13:05:01.000000Z","normalized_code":"3965B"},{"id":19967086,"change_date":"2026-04-09 22:13:00","inspection_id":"84965363","insp_violation_id":"273304228","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"212837208","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:17:12.000000Z","updated_at":"2026-04-19T13:05:01.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":20104938,"change_date":"2026-04-09 22:13:00","inspection_id":"84965363","insp_unit_id":"212837208","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:28:33.000000Z","updated_at":"2026-04-19T10:15:45.000000Z"}]},{"id":8574400,"change_date":"2025-05-08 21:40:00","inspection_id":"84608541","dot_number":"4126448","report_state":"US","report_number":"1628001423","insp_date":"2025-05-08 00:00:00","insp_start_time":"0018","insp_end_time":"0050","registration_date":null,"region":"CD","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS 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":"U","pen_cen_match":"I","final_status_date":"2025-05-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"38500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1697200","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:20:53.000000Z","updated_at":"2025-05-12T10:02:00.000000Z","inspection_violations":[{"id":13617759,"change_date":"2025-05-08 21:40:00","inspection_id":"84608541","insp_violation_id":"266097528","seq_no":"1","part_no":"393","part_no_section":"209D-STBSP","insp_viol_unit":"1","insp_unit_id":"206748341","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-05-10T11:30:46.000000Z","updated_at":"2025-05-12T10:19:28.000000Z","normalized_code":"393209DSTBSP"}],"inspection_per_units":[{"id":13994416,"change_date":"2025-05-08 21:40:00","inspection_id":"84608541","insp_unit_id":"206748341","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"PREVOST","insp_unit_company":"3493","insp_unit_license":"D319567","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2PCH33497Y1013493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:51:14.000000Z","updated_at":"2025-05-12T09:48:36.000000Z"}]},{"id":8229063,"change_date":"2026-04-09 22:10:00","inspection_id":"84244831","dot_number":"4126448","report_state":"TX","report_number":"V251809896","insp_date":"2025-03-26 00:00:00","insp_start_time":"2113","insp_end_time":"2147","registration_date":null,"region":"CT","ci_status_code":"C","location":"3B101","location_desc":"LINCOLN JUAREZ POE","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS LLC","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-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9535428","transaction_code":"C","transaction_date":"2025-03-27 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-03-30T10:38:47.000000Z","updated_at":"2026-04-20T09:55:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20062671,"change_date":"2026-04-09 22:10:00","inspection_id":"84244831","insp_unit_id":"212811475","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"Y","insp_unit_decal_number":"03480010","created_at":"2026-04-12T09:27:57.000000Z","updated_at":"2026-04-19T10:08:00.000000Z"}]},{"id":8043008,"change_date":"2025-03-06 21:39:00","inspection_id":"84048969","dot_number":"4126448","report_state":"US","report_number":"1674001084","insp_date":"2025-03-05 00:00:00","insp_start_time":"2020","insp_end_time":"2110","registration_date":null,"region":"CS","ci_status_code":"C","location":"USTX17","location_desc":"LAREDO TX","county_code_state":"TX","county_code":"479","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HACIENDA TOURS LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1437481","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:22.000000Z","updated_at":"2025-03-17T21:05:22.000000Z","inspection_violations":[{"id":12570038,"change_date":"2025-03-06 21:39:00","inspection_id":"84048969","insp_violation_id":"264866553","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205657387","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"39345B2BAIR"},{"id":12570039,"change_date":"2025-03-06 21:39:00","inspection_id":"84048969","insp_violation_id":"264866554","seq_no":"2","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"205657387","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3963A1TAOCV"},{"id":12570040,"change_date":"2025-03-06 21:39:00","inspection_id":"84048969","insp_violation_id":"264866555","seq_no":"3","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":12985206,"change_date":"2025-03-06 21:39:00","inspection_id":"84048969","insp_unit_id":"205657387","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:28.000000Z","updated_at":"2025-03-17T23:58:28.000000Z"}]},{"id":7567225,"change_date":"2025-01-08 21:39:00","inspection_id":"83549398","dot_number":"4126448","report_state":"TX","report_number":"V251726679","insp_date":"2025-01-06 00:00:00","insp_start_time":"0747","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARROW COACH LINES INC","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-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9468028","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1084879","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[{"id":11830004,"change_date":"2025-01-08 21:39:00","inspection_id":"83549398","insp_violation_id":"263821817","seq_no":"1","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204710382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939TS"},{"id":11830005,"change_date":"2025-01-08 21:39:00","inspection_id":"83549398","insp_violation_id":"263821818","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204710382","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":12209604,"change_date":"2025-01-08 21:39:00","inspection_id":"83549398","insp_unit_id":"204710382","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"PREO","insp_unit_company":"23","insp_unit_license":"D319567","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2PCH33497Y1013493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":4918250,"change_date":"2024-01-29 21:39:00","inspection_id":"80703741","dot_number":"4126448","report_state":"AR","report_number":"X502004702","insp_date":"2024-01-29 00:00:00","insp_start_time":"1115","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"04","location_desc":"AHP SPRINGDALE NB STATION","county_code_state":"AR","county_code":"007","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1497110","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04126448","upload_search_indicator":"M","census_search_date":"2024-01-29 21:39:00","snet_input_date":"2024-01-29 00:00:00","source_office":"2ARS001","mcmis_add_date":"2024-01-29 21:39:00","insp_carrier_name":"HACIENDA TOURS LLC","insp_carrier_street":"1912 S 11TH PL","insp_carrier_city":"ROGERS","insp_carrier_state":"AR","insp_carrier_zip_code":"72758","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:05.000000Z","updated_at":"2025-03-17T20:00:05.000000Z","inspection_violations":[{"id":7577303,"change_date":"2024-01-29 21:39:00","inspection_id":"80703741","insp_violation_id":"257532805","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199143577","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:33.000000Z","updated_at":"2025-03-17T21:42:33.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7914262,"change_date":"2024-01-29 21:39:00","inspection_id":"80703741","insp_unit_id":"199143577","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"6027","insp_unit_license":"D319437","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"2MG3JMBA6CW066027","insp_unit_decal":"Y","insp_unit_decal_number":"33752739","created_at":"2025-03-17T23:06:44.000000Z","updated_at":"2025-03-17T23:06:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4126448\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4126448\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4126448\/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\/4126448\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}