{"current_page":1,"data":[{"id":12261909,"change_date":"2026-06-23 21:39:00","inspection_id":"88220797","dot_number":"1982719","report_state":"TX","report_number":"V262426976","insp_date":"2026-06-17 00:00:00","insp_start_time":"1053","insp_end_time":"1106","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DISTRIBUTION","shipping_paper_number":"2034413","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"10003404","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2026-06-23 21:39:00","snet_input_date":"2026-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2026-06-26T09:41:00.000000Z","updated_at":"2026-07-04T09:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21292991,"change_date":"2026-06-23 21:39:00","inspection_id":"88220797","insp_unit_id":"214247883","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:01.000000Z"},{"id":21292990,"change_date":"2026-06-23 21:39:00","inspection_id":"88220797","insp_unit_id":"214247882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:32.000000Z","updated_at":"2026-07-05T09:05:01.000000Z"}]},{"id":10601341,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","dot_number":"1982719","report_state":"TX","report_number":"V262145572","insp_date":"2026-01-06 00:00:00","insp_start_time":"1015","insp_end_time":"1059","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A201","location_desc":"IH10 WB SEALY SCALE","county_code_state":"TX","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DISTRIBUTION","shipping_paper_number":"1966820","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-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"98001","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9810187","transaction_code":"A","transaction_date":"2026-01-08 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2026-01-11T10:34:47.000000Z","updated_at":"2026-01-19T10:30:54.000000Z","inspection_violations":[{"id":17823063,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_violation_id":"271092724","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:28.000000Z","updated_at":"2026-01-19T10:31:46.000000Z","normalized_code":"38323A2"},{"id":17823064,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_violation_id":"271092725","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"210982109","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-01-11T10:39:28.000000Z","updated_at":"2026-01-19T10:31:46.000000Z","normalized_code":"3929A2C"},{"id":17823065,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_violation_id":"271092726","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"210982109","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:28.000000Z","updated_at":"2026-01-19T10:31:46.000000Z","normalized_code":"39347E"},{"id":17823066,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_violation_id":"271092727","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210982108","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:28.000000Z","updated_at":"2026-01-19T10:31:46.000000Z","normalized_code":"3939"},{"id":17823067,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_violation_id":"271092728","seq_no":"5","part_no":"396","part_no_section":"5B-HLOW","insp_viol_unit":"2","insp_unit_id":"210982109","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:28.000000Z","updated_at":"2026-01-19T10:31:46.000000Z","normalized_code":"3965BHLOW"}],"inspection_per_units":[{"id":17773028,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_unit_id":"210982108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1M74729","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV5GSGR9917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:15.000000Z","updated_at":"2026-01-19T10:01:05.000000Z"},{"id":17773029,"change_date":"2026-01-08 21:40:00","inspection_id":"86740721","insp_unit_id":"210982109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"08","insp_unit_license":"190B685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25373P121801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:15.000000Z","updated_at":"2026-01-19T10:01:05.000000Z"}]},{"id":10000140,"change_date":"2025-10-21 21:39:00","inspection_id":"86110291","dot_number":"1982719","report_state":"TX","report_number":"V252067889","insp_date":"2025-10-20 00:00:00","insp_start_time":"0701","insp_end_time":"0723","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A303","location_desc":"US59 SB EL TORO SCALE","county_code_state":"TX","county_code":"239","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DISTRIBUTION","shipping_paper_number":"1932100-IN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9733493","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2025-10-21 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-10-24T10:01:59.000000Z","updated_at":"2025-10-25T10:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16607792,"change_date":"2025-10-21 21:39:00","inspection_id":"86110291","insp_unit_id":"209584199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:10.000000Z","updated_at":"2025-10-25T09:46:18.000000Z"},{"id":16607793,"change_date":"2025-10-21 21:39:00","inspection_id":"86110291","insp_unit_id":"209584200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"105","insp_unit_license":"259C617","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2537EM955202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:10.000000Z","updated_at":"2025-10-25T09:46:18.000000Z"}]},{"id":9646904,"change_date":"2025-09-10 21:41:00","inspection_id":"85738881","dot_number":"1982719","report_state":"TX","report_number":"V252015294","insp_date":"2025-09-08 00:00:00","insp_start_time":"1743","insp_end_time":"1814","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ENVISION COLD","shipping_paper_number":"60868","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9692707","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2025-09-10 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-10 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-09-13T10:47:41.000000Z","updated_at":"2025-09-13T10:47:41.000000Z","inspection_violations":[{"id":15792360,"change_date":"2025-09-10 21:41:00","inspection_id":"85738881","insp_violation_id":"268591881","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208857942","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:51.000000Z","updated_at":"2025-09-14T11:56:31.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":15939361,"change_date":"2025-09-10 21:41:00","inspection_id":"85738881","insp_unit_id":"208857942","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:27.000000Z","updated_at":"2025-09-13T10:00:27.000000Z"},{"id":15939362,"change_date":"2025-09-10 21:41:00","inspection_id":"85738881","insp_unit_id":"208857943","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"101","insp_unit_license":"230C473","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV482B9KL147613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:27.000000Z","updated_at":"2025-09-13T10:00:27.000000Z"}]},{"id":9687175,"change_date":"2025-09-15 21:41:00","inspection_id":"85781286","dot_number":"1982719","report_state":"TX","report_number":"V251992910","insp_date":"2025-09-08 00:00:00","insp_start_time":"1510","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13318 IH45 SB SVC RD","county_code_state":"TX","county_code":"349","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":"UNK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9696325","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16033748,"change_date":"2025-09-15 21:41:00","inspection_id":"85781286","insp_unit_id":"208963572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"},{"id":16033749,"change_date":"2025-09-15 21:41:00","inspection_id":"85781286","insp_unit_id":"208963573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":7719539,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","dot_number":"1982719","report_state":"TX","report_number":"V251738725","insp_date":"2025-01-24 00:00:00","insp_start_time":"2052","insp_end_time":"2154","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNKNOWN","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9483736","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2025-01-27 21:40:00","snet_input_date":"2025-01-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-27 21:40:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:58:21.000000Z","updated_at":"2025-03-17T20:58:21.000000Z","inspection_violations":[{"id":12061508,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198757","seq_no":"1","part_no":"392","part_no_section":"9A2","insp_viol_unit":"2","insp_unit_id":"205027816","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3929A2"},{"id":12061509,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198758","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"205027816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39348A"},{"id":12061510,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198759","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"205027816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"39353B"},{"id":12061511,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198760","seq_no":"4","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"2","insp_unit_id":"205027816","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3963A1B"},{"id":12061512,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198761","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205027815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3963A1"},{"id":12061513,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198762","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205027815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3963A1"},{"id":12061514,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198763","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"205027816","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3963A1BOS"},{"id":12061515,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_violation_id":"264198764","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205027815","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:50.000000Z","updated_at":"2025-03-17T22:04:50.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":12457389,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_unit_id":"205027815","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"},{"id":12457390,"change_date":"2025-01-27 21:40:00","inspection_id":"83709205","insp_unit_id":"205027816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:27.000000Z","updated_at":"2025-03-17T23:52:27.000000Z"}]},{"id":7704067,"change_date":"2025-01-24 21:40:00","inspection_id":"83692978","dot_number":"1982719","report_state":"TX","report_number":"V251758424","insp_date":"2025-01-22 00:00:00","insp_start_time":"1735","insp_end_time":"1757","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALCON TRANSPORTATION","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9482538","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:58:16.000000Z","updated_at":"2025-03-17T20:58:16.000000Z","inspection_violations":[{"id":12037016,"change_date":"2025-01-24 21:40:00","inspection_id":"83692978","insp_violation_id":"264166841","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204997360","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12431835,"change_date":"2025-01-24 21:40:00","inspection_id":"83692978","insp_unit_id":"204997360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"},{"id":12431836,"change_date":"2025-01-24 21:40:00","inspection_id":"83692978","insp_unit_id":"204997361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:12.000000Z","updated_at":"2025-03-17T23:52:12.000000Z"}]},{"id":7195967,"change_date":"2024-11-14 21:41:00","inspection_id":"83158551","dot_number":"1982719","report_state":"TX","report_number":"70B79DAZTU","insp_date":"2024-11-13 00:00:00","insp_start_time":"0711","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EXCEL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9427775","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:46:03.000000Z","updated_at":"2025-03-17T20:46:03.000000Z","inspection_violations":[{"id":11246098,"change_date":"2024-11-14 21:41:00","inspection_id":"83158551","insp_violation_id":"262901833","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"1","insp_unit_id":"203885841","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":11607225,"change_date":"2024-11-14 21:41:00","inspection_id":"83158551","insp_unit_id":"203885841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"},{"id":11607226,"change_date":"2024-11-14 21:41:00","inspection_id":"83158551","insp_unit_id":"203885842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":6392792,"change_date":"2024-08-05 21:43:00","inspection_id":"82304154","dot_number":"1982719","report_state":"TX","report_number":"V241497259","insp_date":"2024-07-31 00:00:00","insp_start_time":"1422","insp_end_time":"1512","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A101","location_desc":"IH45 NB WILMER SCALE","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DISTRIBUTION LLC","shipping_paper_number":"1744835-IN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9341142","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-08-05 21:43:00","snet_input_date":"2024-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-05 21:43:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:29:31.000000Z","updated_at":"2025-03-17T20:29:31.000000Z","inspection_violations":[{"id":9924299,"change_date":"2024-08-05 21:43:00","inspection_id":"82304154","insp_violation_id":"261019875","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202240327","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39311"},{"id":9924300,"change_date":"2024-08-05 21:43:00","inspection_id":"82304154","insp_violation_id":"261019876","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202240328","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:54:00.000000Z","updated_at":"2025-03-17T21:54:00.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10302685,"change_date":"2024-08-05 21:43:00","inspection_id":"82304154","insp_unit_id":"202240327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1M74729","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV5GSGR9917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"},{"id":10302686,"change_date":"2024-08-05 21:43:00","inspection_id":"82304154","insp_unit_id":"202240328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"08","insp_unit_license":"190B685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25373P121801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:45.000000Z","updated_at":"2025-03-17T23:29:45.000000Z"}]},{"id":6169940,"change_date":"2024-07-11 21:41:00","inspection_id":"82065364","dot_number":"1982719","report_state":"TX","report_number":"V241479878","insp_date":"2024-07-06 00:00:00","insp_start_time":"1933","insp_end_time":"2021","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARILU PAPAYA LLC","shipping_paper_number":"1351","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9320368","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-07-08 21:43:00","snet_input_date":"2024-07-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:25:00.000000Z","updated_at":"2025-03-17T20:25:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9939374,"change_date":"2024-07-11 21:41:00","inspection_id":"82065364","insp_unit_id":"201846367","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M73019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV9FLGM6471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"},{"id":9939375,"change_date":"2024-07-11 21:41:00","inspection_id":"82065364","insp_unit_id":"201846368","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"}]},{"id":5952821,"change_date":"2024-06-10 21:44:00","inspection_id":"81831208","dot_number":"1982719","report_state":"TX","report_number":"V241445481","insp_date":"2024-06-06 00:00:00","insp_start_time":"2000","insp_end_time":"2034","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9296534","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-06-10 21:44:00","snet_input_date":"2024-06-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-10 21:44:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:20:41.000000Z","updated_at":"2025-03-17T20:20:41.000000Z","inspection_violations":[{"id":9235528,"change_date":"2024-06-10 21:44:00","inspection_id":"81831208","insp_violation_id":"260000463","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"201316470","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:38.000000Z","updated_at":"2025-03-17T21:50:38.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":9588536,"change_date":"2024-06-10 21:44:00","inspection_id":"81831208","insp_unit_id":"201316469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:25.000000Z","updated_at":"2025-03-17T23:22:25.000000Z"},{"id":9588537,"change_date":"2024-06-10 21:44:00","inspection_id":"81831208","insp_unit_id":"201316470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:25.000000Z","updated_at":"2025-03-17T23:22:25.000000Z"}]},{"id":5400912,"change_date":"2024-03-29 21:38:00","inspection_id":"81230466","dot_number":"1982719","report_state":"TX","report_number":"V241324307","insp_date":"2024-03-25 00:00:00","insp_start_time":"1938","insp_end_time":"1956","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LINEAGE LOGISTICS","shipping_paper_number":"0118437","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9235156","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[{"id":8335177,"change_date":"2024-03-29 21:38:00","inspection_id":"81230466","insp_violation_id":"258661115","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200159489","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8698602,"change_date":"2024-03-29 21:38:00","inspection_id":"81230466","insp_unit_id":"200159488","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"},{"id":8698603,"change_date":"2024-03-29 21:38:00","inspection_id":"81230466","insp_unit_id":"200159489","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5227876,"change_date":"2024-03-06 21:40:00","inspection_id":"81041738","dot_number":"1982719","report_state":"TX","report_number":"V241349340","insp_date":"2024-03-04 00:00:00","insp_start_time":"1735","insp_end_time":"1818","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PROFRESH","shipping_paper_number":"30652","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-06 21:40: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":"9216854","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[{"id":8060574,"change_date":"2024-03-06 21:40:00","inspection_id":"81041738","insp_violation_id":"258246979","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":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8418687,"change_date":"2024-03-06 21:40:00","inspection_id":"81041738","insp_unit_id":"199791414","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"},{"id":8418688,"change_date":"2024-03-06 21:40:00","inspection_id":"81041738","insp_unit_id":"199791415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:16.000000Z","updated_at":"2025-03-17T23:11:16.000000Z"}]},{"id":4376868,"change_date":"2023-11-07 21:41:00","inspection_id":"80110427","dot_number":"1982719","report_state":"TX","report_number":"V231214375","insp_date":"2023-11-02 00:00:00","insp_start_time":"1425","insp_end_time":"1451","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:27   10' 57.3N","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EXCEL DISTRIBUTION LLC","shipping_paper_number":"1632687-IN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9119969","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2023-11-07 21:41:00","snet_input_date":"2023-11-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-07 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0771143","created_at":"2025-03-17T19:49:34.000000Z","updated_at":"2025-03-17T19:49:34.000000Z","inspection_violations":[{"id":6771399,"change_date":"2023-11-07 21:41:00","inspection_id":"80110427","insp_violation_id":"256274537","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197955447","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":7039476,"change_date":"2023-11-07 21:41:00","inspection_id":"80110427","insp_unit_id":"197955446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:04.000000Z","updated_at":"2025-03-17T22:59:04.000000Z"},{"id":7039477,"change_date":"2023-11-07 21:41:00","inspection_id":"80110427","insp_unit_id":"197955447","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:04.000000Z","updated_at":"2025-03-17T22:59:04.000000Z"}]},{"id":4230021,"change_date":"2023-10-18 21:42:00","inspection_id":"79947731","dot_number":"1982719","report_state":"TX","report_number":"V231202098","insp_date":"2023-10-17 00:00:00","insp_start_time":"1215","insp_end_time":"1234","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A201","location_desc":"IH 10 WESTBOUND SEALY","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DIST.","shipping_paper_number":"1625915","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9104787","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2023-10-18 21:42:00","snet_input_date":"2023-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-18 21:42:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0771143","created_at":"2025-03-17T19:46:38.000000Z","updated_at":"2025-03-17T19:46:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6802918,"change_date":"2023-10-18 21:42:00","inspection_id":"79947731","insp_unit_id":"197629684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M73019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV9FLGM6471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:01.000000Z","updated_at":"2025-03-17T22:57:01.000000Z"},{"id":6802919,"change_date":"2023-10-18 21:42:00","inspection_id":"79947731","insp_unit_id":"197629685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"29","insp_unit_license":"177C916","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532V4CL724351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:01.000000Z","updated_at":"2025-03-17T22:57:01.000000Z"}]},{"id":3904285,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","dot_number":"1982719","report_state":"TX","report_number":"V231104582","insp_date":"2023-08-29 00:00:00","insp_start_time":"1705","insp_end_time":"1738","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH 10 EASTBOUND KINGSBURY","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALCON TRANSPORTATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9067035","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2023-09-05 21:41:00","snet_input_date":"2023-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0771143","created_at":"2025-03-17T19:40:04.000000Z","updated_at":"2025-03-17T19:40:04.000000Z","inspection_violations":[{"id":6033861,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_violation_id":"255086703","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196901049","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39345B2"},{"id":6033862,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_violation_id":"255086704","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196901048","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39347E"},{"id":6033863,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_violation_id":"255086705","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196901048","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39353B"},{"id":6033864,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_violation_id":"255086706","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"196901048","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:12.000000Z","updated_at":"2025-03-17T21:35:12.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":6277726,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_unit_id":"196901048","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M73019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDV9FLGM6471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"},{"id":6277727,"change_date":"2023-09-05 21:41:00","inspection_id":"79586544","insp_unit_id":"196901049","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"29","insp_unit_license":"177C916","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532V4CL724351","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:44.000000Z","updated_at":"2025-03-17T22:52:44.000000Z"}]},{"id":2946881,"change_date":"2023-05-02 21:41:00","inspection_id":"78510561","dot_number":"1982719","report_state":"TX","report_number":"6KMA0XCNJC","insp_date":"2023-04-28 00:00:00","insp_start_time":"0957","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US 77 RIVIERA","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RIO VALLEY CANNING CO.","shipping_paper_number":"359740","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-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8968649","transaction_code":"A","transaction_date":"2023-05-02 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-04-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[{"id":4524961,"change_date":"2023-05-02 21:41:00","inspection_id":"78510561","insp_violation_id":"252578574","seq_no":"1","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"194709853","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39347B"},{"id":4524962,"change_date":"2023-05-02 21:41:00","inspection_id":"78510561","insp_violation_id":"252578575","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194709853","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":4741780,"change_date":"2023-05-02 21:41:00","inspection_id":"78510561","insp_unit_id":"194709853","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"},{"id":4741781,"change_date":"2023-05-02 21:41:00","inspection_id":"78510561","insp_unit_id":"194709854","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2372181,"change_date":"2023-02-14 21:41:00","inspection_id":"77857499","dot_number":"1982719","report_state":"TX","report_number":"6IGM0XCG7O","insp_date":"2023-02-09 00:00:00","insp_start_time":"2140","insp_end_time":"2215","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C399","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRUTCAMPO","shipping_paper_number":"4239","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-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8904549","transaction_code":"A","transaction_date":"2023-02-14 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T19:10:21.000000Z","updated_at":"2025-03-17T19:10:21.000000Z","inspection_violations":[{"id":3654007,"change_date":"2023-02-14 21:41:00","inspection_id":"77857499","insp_violation_id":"251140245","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":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3922"},{"id":3654008,"change_date":"2023-02-14 21:41:00","inspection_id":"77857499","insp_violation_id":"251140246","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3817469,"change_date":"2023-02-14 21:41:00","inspection_id":"77857499","insp_unit_id":"193401789","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","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":3817470,"change_date":"2023-02-14 21:41:00","inspection_id":"77857499","insp_unit_id":"193401790","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","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":851922,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","dot_number":"1982719","report_state":"TX","report_number":"6CLH0XTW7G","insp_date":"2022-07-13 00:00:00","insp_start_time":"1706","insp_end_time":"1733","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A101","location_desc":"IH 45 NORTHBOUND","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"EXCEL DISTRIBUTION LLC","shipping_paper_number":"1418469-IN","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-07-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8717624","transaction_code":"A","transaction_date":"2022-07-19 00:00:00","upload_date":"2022-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2022-07-19 21:40:00","snet_input_date":"2022-07-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-19 21:40:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T18:42:41.000000Z","updated_at":"2025-03-17T18:42:41.000000Z","inspection_violations":[{"id":1342608,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","insp_violation_id":"247194115","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189864651","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:21.000000Z","updated_at":"2025-03-17T21:13:21.000000Z","normalized_code":"3939A"},{"id":1342609,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","insp_violation_id":"247194116","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189864651","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:21.000000Z","updated_at":"2025-03-17T21:13:21.000000Z","normalized_code":"39311"},{"id":1342610,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","insp_violation_id":"247194117","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189864651","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:21.000000Z","updated_at":"2025-03-17T21:13:21.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":1371456,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","insp_unit_id":"189864651","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1M74729","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV5GSGR9917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:37.000000Z","updated_at":"2025-03-17T22:16:37.000000Z"},{"id":1371457,"change_date":"2022-07-19 21:40:00","inspection_id":"76104237","insp_unit_id":"189864652","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"08","insp_unit_license":"190B685","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25373P121801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:37.000000Z","updated_at":"2025-03-17T22:16:37.000000Z"}]},{"id":506414,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","dot_number":"1982719","report_state":"TX","report_number":"6B3C0XBXAT","insp_date":"2022-05-20 00:00:00","insp_start_time":"1200","insp_end_time":"1240","registration_date":"2022-07-18 00:00:00","region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US 77 RIVIERA","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8670107","transaction_code":"C","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2022-05-27 21:41:00","snet_input_date":"2022-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-27 21:41:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T18:36:40.000000Z","updated_at":"2025-03-17T18:36:40.000000Z","inspection_violations":[{"id":805686,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_violation_id":"247163824","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189837723","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"3939A"},{"id":805687,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_violation_id":"247163825","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189837723","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"39311"},{"id":805688,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_violation_id":"247163826","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189837723","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"39395A"},{"id":805689,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_violation_id":"247163827","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189837723","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"3963A1"},{"id":805690,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_violation_id":"247163828","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"189837723","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":814522,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_unit_id":"189837723","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1M74729","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV5GSGR9917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:13.000000Z","updated_at":"2025-03-17T22:13:13.000000Z"},{"id":814523,"change_date":"2022-07-18 21:43:00","inspection_id":"75697045","insp_unit_id":"189837724","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:13.000000Z","updated_at":"2025-03-17T22:13:13.000000Z"}]},{"id":208103,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","dot_number":"1982719","report_state":"TX","report_number":"6A490XLGN3","insp_date":"2022-04-15 00:00:00","insp_start_time":"0902","insp_end_time":"0924","registration_date":"2022-05-25 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-069E IN CAMERON CO. (1-37)","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RIO VALLEY CANNING CO","shipping_paper_number":"5500013351","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-04-19 21:45: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":"8628717","transaction_code":"C","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2022-04-19 21:45:00","snet_input_date":"2022-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-19 21:45:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T18:31:13.000000Z","updated_at":"2025-03-17T18:31:13.000000Z","inspection_violations":[{"id":319218,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","insp_violation_id":"246082872","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188918647","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:29.000000Z","updated_at":"2025-03-17T21:08:29.000000Z","normalized_code":"3939A"},{"id":319219,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","insp_violation_id":"246082873","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"188918647","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:29.000000Z","updated_at":"2025-03-17T21:08:29.000000Z","normalized_code":"39311"},{"id":319220,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","insp_violation_id":"246082874","seq_no":"3","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"188918647","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:29.000000Z","updated_at":"2025-03-17T21:08:29.000000Z","normalized_code":"39328"}],"inspection_per_units":[{"id":337588,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","insp_unit_id":"188918647","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"1M35264","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLDR6ELFK5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:13.000000Z","updated_at":"2025-03-17T22:10:13.000000Z"},{"id":337589,"change_date":"2022-05-25 21:42:00","inspection_id":"75341208","insp_unit_id":"188918648","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"20","insp_unit_license":"139B815","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XAU284702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:13.000000Z","updated_at":"2025-03-17T22:10:13.000000Z"}]},{"id":161058,"change_date":"2022-04-14 21:42:00","inspection_id":"75284824","dot_number":"1982719","report_state":"TX","report_number":"69TI0AGLR2","insp_date":"2022-04-04 00:00:00","insp_start_time":"1722","insp_end_time":"1818","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C399","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AVOCADO OIL DE MEXICO INC","shipping_paper_number":"VP158","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-04-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8618070","transaction_code":"C","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01982719","upload_search_indicator":"M","census_search_date":"2022-04-12 21:43:00","snet_input_date":"2022-04-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-12 21:43:00","insp_carrier_name":"ALCON TRANSPORTATION SERVICES INC","insp_carrier_street":"7311 CYPRESS BREEZE CT","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0771143","created_at":"2025-03-17T18:30:27.000000Z","updated_at":"2025-03-17T18:30:27.000000Z","inspection_violations":[{"id":241495,"change_date":"2022-04-14 21:42:00","inspection_id":"75284824","insp_violation_id":"245165725","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":null,"created_at":"2025-03-17T21:08:11.000000Z","updated_at":"2025-03-17T21:08:11.000000Z","normalized_code":"3922"},{"id":241496,"change_date":"2022-04-14 21:42:00","inspection_id":"75284824","insp_violation_id":"245165726","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:11.000000Z","updated_at":"2025-03-17T21:08:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":261119,"change_date":"2022-04-14 21:42:00","inspection_id":"75284824","insp_unit_id":"188161811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"1M78537","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV4ESFU9615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:47.000000Z","updated_at":"2025-03-17T22:09:47.000000Z"},{"id":261120,"change_date":"2022-04-14 21:42:00","inspection_id":"75284824","insp_unit_id":"188161812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"26","insp_unit_license":"159B508","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536AM980103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:47.000000Z","updated_at":"2025-03-17T22:09:47.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1982719\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1982719\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1982719\/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\/1982719\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}