{"current_page":1,"data":[{"id":12310109,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","dot_number":"3143049","report_state":"MN","report_number":"0444000882","insp_date":"2026-06-22 00:00:00","insp_start_time":"1316","insp_end_time":"1429","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MARSHALL MN","county_code_state":"MN","county_code":"083","insp_level_id":"2","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3643074","transaction_code":"A","transaction_date":"2026-06-28 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":"2026-06-29 21:41:00","snet_input_date":"2026-06-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"3408 N NAVAJO TRL","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:29.000000Z","updated_at":"2026-07-10T09:30:45.000000Z","inspection_violations":[{"id":21423106,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","insp_violation_id":"275184193","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"214340605","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-02T09:59:39.000000Z","updated_at":"2026-07-10T09:40:58.000000Z","normalized_code":"3922SLLIRP"},{"id":21423107,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","insp_violation_id":"275184194","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"214340605","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-02T09:59:39.000000Z","updated_at":"2026-07-10T09:40:58.000000Z","normalized_code":"39395A1"},{"id":21423108,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","insp_violation_id":"275184195","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"214340606","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-07-02T09:59:39.000000Z","updated_at":"2026-07-10T09:40:58.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":21381036,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","insp_unit_id":"214340605","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6521","insp_unit_license":"AL27890","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3AKJHHDR3KSKF6521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:23.000000Z","updated_at":"2026-07-10T09:01:52.000000Z"},{"id":21381037,"change_date":"2026-06-29 21:41:00","inspection_id":"88267559","insp_unit_id":"214340606","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAGON ESP","insp_unit_company":"429","insp_unit_license":"STA3946","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1D9SD4239CR661261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:23.000000Z","updated_at":"2026-07-10T09:01:52.000000Z"}]},{"id":11434028,"change_date":"2026-03-22 21:33:00","inspection_id":"87350507","dot_number":"3143049","report_state":"AR","report_number":"8330000351","insp_date":"2026-03-17 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"CD","ci_status_code":"C","location":"404","location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NISSAN","shipping_paper_number":"80173","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":"2026-03-22 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"101320","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":"3035873","transaction_code":"A","transaction_date":"2026-03-21 00:00:00","upload_date":"2026-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":"2026-03-22 21:33:00","snet_input_date":"2026-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-22 21:33:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"3408 N NAVAJO TRL","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-25T09:41:21.000000Z","updated_at":"2026-04-02T09:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19587614,"change_date":"2026-03-22 21:33:00","inspection_id":"87350507","insp_unit_id":"212254202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"5292","insp_unit_license":"AM58572","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1NPXDP9X9GD345292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-25T09:18:14.000000Z","updated_at":"2026-04-02T09:03:35.000000Z"},{"id":19587615,"change_date":"2026-03-22 21:33:00","inspection_id":"87350507","insp_unit_id":"212254203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COTTRELL T","insp_unit_company":"130A","insp_unit_license":"5486119","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AA1445JG019401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-25T09:18:14.000000Z","updated_at":"2026-04-02T09:03:35.000000Z"}]},{"id":9065563,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","dot_number":"3143049","report_state":"MN","report_number":"0450000490","insp_date":"2025-06-28 00:00:00","insp_start_time":"0639","insp_end_time":"0706","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"COSMOS MN","county_code_state":"MN","county_code":"093","insp_level_id":"3","service_center":"MW","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":"U","pen_cen_match":"I","final_status_date":"2025-07-05 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1953105","transaction_code":"A","transaction_date":"2025-07-04 00:00:00","upload_date":"2025-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":"2025-07-05 21:35:00","snet_input_date":"2025-06-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-05 21:35:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"3408 N NAVAJO TRL","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-09T10:00:19.000000Z","updated_at":"2025-07-09T10:00:19.000000Z","inspection_violations":[{"id":14591782,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_violation_id":"267211256","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"207706960","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-08T10:15:31.000000Z","updated_at":"2025-07-09T10:42:55.000000Z","normalized_code":"3922SLLEQP"},{"id":14591783,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_violation_id":"267211257","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207706959","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-08T10:15:31.000000Z","updated_at":"2025-07-09T10:42:55.000000Z","normalized_code":"3922SLLIFTA"},{"id":14591784,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_violation_id":"267211258","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-08T10:15:31.000000Z","updated_at":"2025-07-09T10:42:55.000000Z","normalized_code":"3922SLL"},{"id":14591785,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_violation_id":"267211259","seq_no":"4","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-08T10:15:31.000000Z","updated_at":"2025-07-09T10:42:55.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14874972,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_unit_id":"207706959","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"6521","insp_unit_license":"AL27890","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3AKJHHDR3KSKF6521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-08T09:45:21.000000Z","updated_at":"2025-07-09T09:45:21.000000Z"},{"id":14874973,"change_date":"2025-07-05 21:35:00","inspection_id":"85127611","insp_unit_id":"207706960","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANCO","insp_unit_company":null,"insp_unit_license":"STA3946","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1D9SD4239CR661261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-08T09:45:21.000000Z","updated_at":"2025-07-09T09:45:21.000000Z"}]},{"id":5661209,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","dot_number":"3143049","report_state":"IN","report_number":"8758002163","insp_date":"2024-04-29 00:00:00","insp_start_time":"1115","insp_end_time":"1152","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED ROAD","shipping_paper_number":"77025861","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":"2024-05-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"101600","viol_total":"5","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":"450175","transaction_code":"C","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":"2024-05-03 21:38:00","snet_input_date":"2024-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-03 21:38:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:03.000000Z","updated_at":"2025-03-17T20:15:03.000000Z","inspection_violations":[{"id":8756856,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_violation_id":"259707918","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201065856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3939A"},{"id":8756857,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_violation_id":"259707919","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201065856","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3939A"},{"id":8756858,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_violation_id":"259707920","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201065857","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3939A"},{"id":8756859,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_violation_id":"259707921","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201065857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"3939A"},{"id":8756860,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_violation_id":"259707922","seq_no":"5","part_no":"395","part_no_section":"22(h)(4)","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-03-17T21:48:20.000000Z","updated_at":"2025-03-17T21:48:20.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":9118227,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_unit_id":"201065856","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6638","insp_unit_license":"AL15865","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1NPXD49X6FD276638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:50.000000Z","updated_at":"2025-03-17T23:17:50.000000Z"},{"id":9118228,"change_date":"2024-05-24 21:38:00","inspection_id":"81514597","insp_unit_id":"201065857","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COTTRELL T","insp_unit_company":"T88","insp_unit_license":"5312812","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AA1448JG080306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:50.000000Z","updated_at":"2025-03-17T23:17:50.000000Z"}]},{"id":5122439,"change_date":"2024-02-23 21:41:00","inspection_id":"80927063","dot_number":"3143049","report_state":"AR","report_number":"530C007117","insp_date":"2024-02-22 00:00:00","insp_start_time":"2259","insp_end_time":"2326","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-302","location_desc":"CRAWFORD COUNTY(ALMA WEST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"GENERAL MOTORS","shipping_paper_number":"75865021","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":"N","pen_cen_match":"I","final_status_date":"2024-02-23 21:41: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":"1501257","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-23 00:00:00","source_office":"2ARS001","mcmis_add_date":"2024-02-23 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:10.000000Z","updated_at":"2025-03-17T20:04:10.000000Z","inspection_violations":[{"id":7899291,"change_date":"2024-02-23 21:41:00","inspection_id":"80927063","insp_violation_id":"258007811","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W000616","created_at":"2025-03-17T21:44:08.000000Z","updated_at":"2025-03-17T21:44:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8246874,"change_date":"2024-02-23 21:41:00","inspection_id":"80927063","insp_unit_id":"199572780","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6521","insp_unit_license":"AL27890","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3AKJHHDR3KSKF6521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:45.000000Z","updated_at":"2025-03-17T23:09:45.000000Z"},{"id":8246875,"change_date":"2024-02-23 21:41:00","inspection_id":"80927063","insp_unit_id":"199572781","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"1","insp_unit_license":"32-36253","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"5E0AU17407G174501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:45.000000Z","updated_at":"2025-03-17T23:09:45.000000Z"}]},{"id":7967384,"change_date":"2025-12-19 21:39:00","inspection_id":"83969505","dot_number":"3143049","report_state":"NM","report_number":"1702O0CC8D","insp_date":"2024-01-12 00:00:00","insp_start_time":"0957","insp_end_time":"1021","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ANTHONY PORT OF ENTRY","county_code_state":"NM","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"000000","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":"2025-02-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53250","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":"2163704","transaction_code":"C","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-25 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:38.000000Z","updated_at":"2025-12-30T10:33:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17542408,"change_date":"2025-12-19 21:39:00","inspection_id":"83969505","insp_unit_id":"210721621","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 6521","insp_unit_license":"TEMP","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3AKJHHDR3KSKF6521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:00.000000Z","updated_at":"2025-12-30T10:00:37.000000Z"}]},{"id":4621390,"change_date":"2023-12-13 21:42:00","inspection_id":"80379412","dot_number":"3143049","report_state":"TN","report_number":"TCBT000751","insp_date":"2023-12-12 00:00:00","insp_start_time":"0754","insp_end_time":"0817","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-40 E\/B 252 REST AREA","county_code_state":"TN","county_code":"159","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NISSAN","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1697315","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-13 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:31.000000Z","updated_at":"2025-03-17T19:54:31.000000Z","inspection_violations":[{"id":7144569,"change_date":"2023-12-13 21:42:00","inspection_id":"80379412","insp_violation_id":"256865043","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198487953","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:32.000000Z","updated_at":"2025-03-17T21:40:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7433014,"change_date":"2023-12-13 21:42:00","inspection_id":"80379412","insp_unit_id":"198487952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"001","insp_unit_license":"AL15865","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1NPXD49X6FD276638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:29.000000Z","updated_at":"2025-03-17T23:02:29.000000Z"},{"id":7433015,"change_date":"2023-12-13 21:42:00","inspection_id":"80379412","insp_unit_id":"198487953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"COTT","insp_unit_company":"B03","insp_unit_license":"5312812","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AA1448JG080306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:29.000000Z","updated_at":"2025-03-17T23:02:29.000000Z"}]},{"id":3640042,"change_date":"2023-08-01 21:41:00","inspection_id":"79291217","dot_number":"3143049","report_state":"GA","report_number":"1210006150","insp_date":"2023-07-28 00:00:00","insp_start_time":"1840","insp_end_time":"1910","registration_date":null,"region":"ET","ci_status_code":"C","location":"267","location_desc":"CATOOSA CO I\/S SB","county_code_state":"GA","county_code":"047","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MANHEM","shipping_paper_number":"K157","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":"2023-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1990711","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-31 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:53.000000Z","updated_at":"2025-03-17T19:34:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5852540,"change_date":"2023-08-01 21:41:00","inspection_id":"79291217","insp_unit_id":"196295258","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8302","insp_unit_license":"AJ10513","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9TH6KN208302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:13.000000Z","updated_at":"2025-03-17T22:49:13.000000Z"},{"id":5852541,"change_date":"2023-08-01 21:41:00","inspection_id":"79291217","insp_unit_id":"196295259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"2101","insp_unit_license":"TK4331","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"4E0AU1747JG022101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:13.000000Z","updated_at":"2025-03-17T22:49:13.000000Z"}]},{"id":3434519,"change_date":"2023-07-05 21:42:00","inspection_id":"79060314","dot_number":"3143049","report_state":"MO","report_number":"W200003060","insp_date":"2023-07-03 00:00:00","insp_start_time":"0752","insp_end_time":"0822","registration_date":null,"region":"CT","ci_status_code":"C","location":"C2E","location_desc":"EASTBOUND SCALES ST. CLAIR","county_code_state":"MO","county_code":"071","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MULTIPLE","shipping_paper_number":"MULTIPLE","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":"2023-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"105850","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2081738","transaction_code":"A","transaction_date":"2023-07-03 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-05 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-05 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:58.000000Z","updated_at":"2025-03-17T19:30:58.000000Z","inspection_violations":[{"id":5293582,"change_date":"2023-07-05 21:42:00","inspection_id":"79060314","insp_violation_id":"253868477","seq_no":"1","part_no":"395","part_no_section":"24(d)","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-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"39524D"},{"id":5293583,"change_date":"2023-07-05 21:42:00","inspection_id":"79060314","insp_violation_id":"253868478","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195829094","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5522289,"change_date":"2023-07-05 21:42:00","inspection_id":"79060314","insp_unit_id":"195829093","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8302","insp_unit_license":"AJ10513","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9TH6KN208302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"},{"id":5522290,"change_date":"2023-07-05 21:42:00","inspection_id":"79060314","insp_unit_id":"195829094","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTRL","insp_unit_company":null,"insp_unit_license":"3235725","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AU1748JG016401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:35.000000Z","updated_at":"2025-03-17T22:46:35.000000Z"}]},{"id":3062672,"change_date":"2023-05-17 21:42:00","inspection_id":"78641277","dot_number":"3143049","report_state":"MD","report_number":"3056004754","insp_date":"2023-05-17 00:00:00","insp_start_time":"0510","insp_end_time":"0536","registration_date":null,"region":"ET","ci_status_code":"C","location":"012","location_desc":"I-95 SOUTHBOUND SCALE FACILITY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","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":"N","pen_cen_match":null,"final_status_date":"2023-05-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","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":"2633153","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-17 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-05-17 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:44.000000Z","updated_at":"2025-03-17T19:23:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4927075,"change_date":"2023-05-17 21:42:00","inspection_id":"78641277","insp_unit_id":"194971017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2","insp_unit_license":"AL22626","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH0FN189586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:51.000000Z","updated_at":"2025-03-17T22:41:51.000000Z"},{"id":4927076,"change_date":"2023-05-17 21:42:00","inspection_id":"78641277","insp_unit_id":"194971018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02","insp_unit_license":"TK4035","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS253XK3498158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:51.000000Z","updated_at":"2025-03-17T22:41:51.000000Z"}]},{"id":2829363,"change_date":"2023-04-18 21:42:00","inspection_id":"78377619","dot_number":"3143049","report_state":"AZ","report_number":"0207011227","insp_date":"2023-04-17 00:00:00","insp_start_time":"1420","insp_end_time":"1505","registration_date":null,"region":"MT","ci_status_code":"C","location":"I40","location_desc":"INTERSTATE 40","county_code_state":"AZ","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SG ROCKLINE","shipping_paper_number":"4059720","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":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1807970","transaction_code":"A","transaction_date":"2023-04-17 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-18 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[{"id":4341574,"change_date":"2023-04-18 21:42:00","inspection_id":"78377619","insp_violation_id":"252288666","seq_no":"1","part_no":"395","part_no_section":"24(d)","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-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39524D"},{"id":4341575,"change_date":"2023-04-18 21:42:00","inspection_id":"78377619","insp_violation_id":"252288667","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":4554352,"change_date":"2023-04-18 21:42:00","inspection_id":"78377619","insp_unit_id":"194448857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3885","insp_unit_license":"AK04266","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH5GN953885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4554353,"change_date":"2023-04-18 21:42:00","inspection_id":"78377619","insp_unit_id":"194448858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"8157","insp_unit_license":"TT1327","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS2538K3498157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":2831507,"change_date":"2023-04-24 21:41:00","inspection_id":"78380046","dot_number":"3143049","report_state":"TX","report_number":"6KAI0XNRPF","insp_date":"2023-04-16 00:00:00","insp_start_time":"1735","insp_end_time":"1811","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SS-0408 IN DALLAS CO. (270-274","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ECHO PARK AUTOS","shipping_paper_number":"8155871","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"105350","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":"8957806","transaction_code":"C","transaction_date":"2023-04-24 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":"1051357","created_at":"2025-03-17T19:18:55.000000Z","updated_at":"2025-03-17T19:18:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4558038,"change_date":"2023-04-24 21:41:00","inspection_id":"78380046","insp_unit_id":"194553183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"2101","insp_unit_license":"3235725","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AU1748JG016401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:56.000000Z","updated_at":"2025-03-17T22:38:56.000000Z"},{"id":4558039,"change_date":"2023-04-24 21:41:00","inspection_id":"78380046","insp_unit_id":"194553184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"8302","insp_unit_license":"AJ10513","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9TH6KN208302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:56.000000Z","updated_at":"2025-03-17T22:38:56.000000Z"}]},{"id":2370978,"change_date":"2023-02-14 21:41:00","inspection_id":"77856150","dot_number":"3143049","report_state":"WA","report_number":"W318005875","insp_date":"2023-02-13 00:00:00","insp_start_time":"1115","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"EB I90","county_code_state":"WA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"OBERTO SNACKS INC","shipping_paper_number":"19235429","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":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2552339","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3651187,"change_date":"2023-02-14 21:41:00","inspection_id":"77856150","insp_violation_id":"251136004","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0212684","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3815457,"change_date":"2023-02-14 21:41:00","inspection_id":"77856150","insp_unit_id":"193399077","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"9586","insp_unit_license":"AL22626","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH0FN189586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:20.000000Z","updated_at":"2025-03-17T22:33:20.000000Z"},{"id":3815458,"change_date":"2023-02-14 21:41:00","inspection_id":"77856150","insp_unit_id":"193399078","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"TK4035","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS253XK3498158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:20.000000Z","updated_at":"2025-03-17T22:33:20.000000Z"}]},{"id":1559919,"change_date":"2022-10-20 21:41:00","inspection_id":"76927724","dot_number":"3143049","report_state":"NM","report_number":"5400M84DMF","insp_date":"2022-10-19 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"CLAYTON PORT OF ENTRY","county_code_state":"NM","county_code":"059","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EIGHTH DAY SOUND","shipping_paper_number":"101922","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-10-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"1945495","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":"2022-10-20 21:41:00","snet_input_date":"2022-10-20 00:00:00","source_office":"2NMS001","mcmis_add_date":"2022-10-20 21:41:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7147 E RANCHO VISTA DR B 03","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:16.000000Z","updated_at":"2025-03-17T18:55:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2510028,"change_date":"2022-10-20 21:41:00","inspection_id":"76927724","insp_unit_id":"191545888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"9586","insp_unit_license":"AL22626","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH0FN189586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:13.000000Z","updated_at":"2025-03-17T22:24:13.000000Z"},{"id":2510029,"change_date":"2022-10-20 21:41:00","inspection_id":"76927724","insp_unit_id":"191545889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1010","insp_unit_license":"TK4330","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS2531K3498159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:13.000000Z","updated_at":"2025-03-17T22:24:13.000000Z"}]},{"id":1328304,"change_date":"2022-09-20 21:42:00","inspection_id":"76659560","dot_number":"3143049","report_state":"UT","report_number":"22HK000351","insp_date":"2022-09-20 00:00:00","insp_start_time":"0645","insp_end_time":"0722","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GREEN RIVER (GHOST ROCKS)","county_code_state":"UT","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INCUBUS","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":null,"final_status_date":"2022-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54211","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":"859047","transaction_code":"A","transaction_date":"2022-09-20 00:00:00","upload_date":"2022-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-20 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-09-20 21:42:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7117 E RANCHO VISTA 3007","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:13.000000Z","updated_at":"2025-03-17T18:51:13.000000Z","inspection_violations":[{"id":2101910,"change_date":"2022-09-20 21:42:00","inspection_id":"76659560","insp_violation_id":"248535057","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"191003562","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"39375A"},{"id":2101911,"change_date":"2022-09-20 21:42:00","inspection_id":"76659560","insp_violation_id":"248535058","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191003562","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:39.000000Z","updated_at":"2025-03-17T21:16:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2138516,"change_date":"2022-09-20 21:42:00","inspection_id":"76659560","insp_unit_id":"191003561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3885","insp_unit_license":"AK04266","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH5GN953885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:38.000000Z","updated_at":"2025-03-17T22:21:38.000000Z"},{"id":2138517,"change_date":"2022-09-20 21:42:00","inspection_id":"76659560","insp_unit_id":"191003562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3","insp_unit_license":"TK4331","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1UYVS2538K3498160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:38.000000Z","updated_at":"2025-03-17T22:21:38.000000Z"}]},{"id":1034381,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","dot_number":"3143049","report_state":"TN","report_number":"TFAX001984","insp_date":"2022-08-12 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"GILES COUNTY SCALES","county_code_state":"TN","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"ACERTUS","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":"2022-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"4","oos_total":"3","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1590773","transaction_code":"A","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-15 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7117 E RANCHO VISTA 3007","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:50.000000Z","updated_at":"2025-03-17T18:45:50.000000Z","inspection_violations":[{"id":1629240,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_violation_id":"247705234","seq_no":"1","part_no":"395","part_no_section":"24(d)","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-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39524D"},{"id":1629241,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_violation_id":"247705235","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3958E1"},{"id":1629242,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_violation_id":"247705236","seq_no":"3","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:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"38351A"},{"id":1629243,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_violation_id":"247705237","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190302528","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1664680,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_unit_id":"190302527","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"AL15865","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1NPXD49X6FD276638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"},{"id":1664681,"change_date":"2022-08-15 21:38:00","inspection_id":"76317550","insp_unit_id":"190302528","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T-10","insp_unit_license":"3240439","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5E0AZ1447FG623001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:28.000000Z","updated_at":"2025-03-17T22:18:28.000000Z"}]},{"id":28065,"change_date":"2022-03-23 21:32:00","inspection_id":"75120667","dot_number":"3143049","report_state":"MI","report_number":"KNODM01335","insp_date":"2022-03-22 00:00:00","insp_start_time":"1555","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB AT MM141","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"1068791","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03143049","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"TEQUILA COACH ENTERPRISES LLC","insp_carrier_street":"7117 E RANCHO VISTA 3007","insp_carrier_city":"SCOTTSDALE","insp_carrier_state":"AZ","insp_carrier_zip_code":"85251","insp_colonia":null,"docket_number":"100560","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:05.000000Z","updated_at":"2025-03-17T18:28:05.000000Z","inspection_violations":[{"id":39939,"change_date":"2022-03-23 21:32:00","inspection_id":"75120667","insp_violation_id":"244736306","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:16.000000Z","updated_at":"2025-03-17T21:07:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":45110,"change_date":"2022-03-23 21:32:00","inspection_id":"75120667","insp_unit_id":"187782625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"5361","insp_unit_license":"AJ71551","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"4V4NC9EH4LN215361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"},{"id":45111,"change_date":"2022-03-23 21:32:00","inspection_id":"75120667","insp_unit_id":"187782626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1","insp_unit_license":"TM2402","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1GR1A0623LT153295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3143049\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3143049\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3143049\/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\/3143049\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}