{"current_page":1,"data":[{"id":9829599,"change_date":"2025-10-01 21:40:00","inspection_id":"85930372","dot_number":"2938049","report_state":"TX","report_number":"V252035372","insp_date":"2025-09-29 00:00:00","insp_start_time":"1030","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600  TX56","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MCCRAW SAND","shipping_paper_number":"581040","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9712235","transaction_code":"A","transaction_date":"2025-10-01 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2025-10-01 21:40:00","snet_input_date":"2025-09-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-01 21:40:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-10-04T10:01:47.000000Z","updated_at":"2025-10-05T10:01:19.000000Z","inspection_violations":[{"id":16180935,"change_date":"2025-10-01 21:40:00","inspection_id":"85930372","insp_violation_id":"269038099","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209246190","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:02.000000Z","updated_at":"2025-10-05T10:17:01.000000Z","normalized_code":"39360C"},{"id":16180936,"change_date":"2025-10-01 21:40:00","inspection_id":"85930372","insp_violation_id":"269038100","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209246190","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:18:02.000000Z","updated_at":"2025-10-05T10:17:01.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":16296494,"change_date":"2025-10-01 21:40:00","inspection_id":"85930372","insp_unit_id":"209246190","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1","insp_unit_license":"1N13942","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:47:09.000000Z","updated_at":"2025-10-05T09:46:37.000000Z"},{"id":16296495,"change_date":"2025-10-01 21:40:00","inspection_id":"85930372","insp_unit_id":"209246191","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":"1","insp_unit_license":"Y63344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NUDT28N7WMAS0258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:47:09.000000Z","updated_at":"2025-10-05T09:46:37.000000Z"}]},{"id":8441970,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","dot_number":"2938049","report_state":"TX","report_number":"V251838104","insp_date":"2025-04-16 00:00:00","insp_start_time":"0938","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:33\u00bf\u00bf36'26.59\"N","county_code_state":"TX","county_code":"147","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HERMANOS ORTEGA TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9556752","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-04-26T10:27:29.000000Z","updated_at":"2025-04-26T10:27:29.000000Z","inspection_violations":[{"id":13334535,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771016","seq_no":"5","part_no":"393","part_no_section":"70","insp_viol_unit":"1","insp_unit_id":"206439346","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"39370"},{"id":13334536,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771017","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206439346","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"3939"},{"id":13334537,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771018","seq_no":"7","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206439346","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"3939TS"},{"id":13334538,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771019","seq_no":"8","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206439346","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"3939TS"},{"id":13334531,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771012","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:55:48.000000Z","updated_at":"2025-04-25T11:07:38.000000Z","normalized_code":"39347E"},{"id":13334532,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771013","seq_no":"2","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:55:48.000000Z","updated_at":"2025-04-25T11:07:38.000000Z","normalized_code":"39348A"},{"id":13334533,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771014","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:55:48.000000Z","updated_at":"2025-04-25T11:07:38.000000Z","normalized_code":"39353B"},{"id":13334534,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771015","seq_no":"4","part_no":"393","part_no_section":"55D1","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:55:48.000000Z","updated_at":"2025-04-25T11:07:38.000000Z","normalized_code":"39355D1"},{"id":13334539,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771020","seq_no":"9","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"3963A1B"},{"id":13334540,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_violation_id":"265771021","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"206439347","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-04-25T10:56:12.000000Z","updated_at":"2025-04-25T11:08:03.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13710716,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_unit_id":"206439346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"72","insp_unit_license":"1N13942","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:14:13.000000Z","updated_at":"2025-04-26T10:06:51.000000Z"},{"id":13710717,"change_date":"2025-04-22 21:41:00","inspection_id":"84469240","insp_unit_id":"206439347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"391","insp_unit_license":"072C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:14:13.000000Z","updated_at":"2025-04-26T10:06:51.000000Z"}]},{"id":7430135,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","dot_number":"2938049","report_state":"TX","report_number":"V241666664","insp_date":"2024-12-11 00:00:00","insp_start_time":"1245","insp_end_time":"1312","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 273","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MCCRAW SAND","shipping_paper_number":"543643","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-16 21:40: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":"9451636","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-12-16 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-16 21:40:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:51:09.000000Z","updated_at":"2025-03-17T20:51:09.000000Z","inspection_violations":[{"id":11610665,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_violation_id":"263521739","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"204434612","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"39375C"},{"id":11610666,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_violation_id":"263521740","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204434612","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"3939"},{"id":11610667,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_violation_id":"263521741","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204434612","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"3939"},{"id":11610668,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_violation_id":"263521742","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204434612","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:32.000000Z","updated_at":"2025-03-17T22:02:32.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11986928,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_unit_id":"204434611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1","insp_unit_license":"92M881M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:21.000000Z","updated_at":"2025-03-17T23:47:21.000000Z"},{"id":11986929,"change_date":"2024-12-17 21:39:00","inspection_id":"83405441","insp_unit_id":"204434612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"391","insp_unit_license":"072C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:21.000000Z","updated_at":"2025-03-17T23:47:21.000000Z"}]},{"id":6506059,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","dot_number":"2938049","report_state":"TX","report_number":"V241460369","insp_date":"2024-08-16 00:00:00","insp_start_time":"1155","insp_end_time":"1243","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 273","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MCCRAW","shipping_paper_number":"548888","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9354853","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-08-19 21:43:00","snet_input_date":"2024-08-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-19 21:43:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:31:57.000000Z","updated_at":"2025-03-17T20:31:57.000000Z","inspection_violations":[{"id":10104340,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275558","seq_no":"1","part_no":"393","part_no_section":"47(c)","insp_viol_unit":"2","insp_unit_id":"202469691","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39347C"},{"id":10104341,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275559","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"202469690","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39360C"},{"id":10104342,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275560","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202469691","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"39375C"},{"id":10104343,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275561","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202469691","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10104344,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275562","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202469691","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"},{"id":10104345,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_violation_id":"261275563","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202469690","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:54.000000Z","updated_at":"2025-03-17T21:54:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10487704,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_unit_id":"202469690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"0","insp_unit_license":"62R697M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"},{"id":10487705,"change_date":"2024-08-19 21:43:00","inspection_id":"82425142","insp_unit_id":"202469691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"391","insp_unit_license":"072C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:38.000000Z","updated_at":"2025-03-17T23:31:38.000000Z"}]},{"id":6336779,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","dot_number":"2938049","report_state":"TX","report_number":"6X7E9DLCMM","insp_date":"2024-07-24 00:00:00","insp_start_time":"1337","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0121 IN COLLIN CO. (230-264","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HERMANOS ORTEGA TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9335871","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:28:18.000000Z","updated_at":"2025-03-17T20:28:18.000000Z","inspection_violations":[{"id":9837987,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898247","seq_no":"1","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"2","insp_unit_id":"202126600","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39343A"},{"id":9837988,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898248","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202126599","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3963A1"},{"id":9837989,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898249","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"202126599","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39345"},{"id":9837990,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898250","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202126600","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3922"},{"id":9837991,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898251","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202126600","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3922"},{"id":9837992,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898252","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202126599","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3939A"},{"id":9837993,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898253","seq_no":"7","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202126599","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39021A"},{"id":9837994,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_violation_id":"260898254","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202126599","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10211057,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_unit_id":"202126599","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"32N664M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"},{"id":10211058,"change_date":"2024-07-29 21:42:00","inspection_id":"82244203","insp_unit_id":"202126600","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"072C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"}]},{"id":5437368,"change_date":"2024-04-04 21:42:00","inspection_id":"81270576","dot_number":"2938049","report_state":"TX","report_number":"V241341845","insp_date":"2024-04-01 00:00:00","insp_start_time":"1320","insp_end_time":"1407","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-273","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MCCRAW","shipping_paper_number":"531485","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9239316","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-04-04 21:42:00","snet_input_date":"2024-04-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:10:20.000000Z","updated_at":"2025-03-17T20:10:20.000000Z","inspection_violations":[{"id":8394993,"change_date":"2024-04-04 21:42:00","inspection_id":"81270576","insp_violation_id":"258755345","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200243053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3939A"},{"id":8394994,"change_date":"2024-04-04 21:42:00","inspection_id":"81270576","insp_violation_id":"258755346","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200243053","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8758647,"change_date":"2024-04-04 21:42:00","inspection_id":"81270576","insp_unit_id":"200243052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"724","insp_unit_license":"17M508M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EG2FN914211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:27.000000Z","updated_at":"2025-03-17T23:14:27.000000Z"},{"id":8758648,"change_date":"2024-04-04 21:42:00","inspection_id":"81270576","insp_unit_id":"200243053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"391","insp_unit_license":"072C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:27.000000Z","updated_at":"2025-03-17T23:14:27.000000Z"}]},{"id":5104049,"change_date":"2024-02-22 21:43:00","inspection_id":"80907002","dot_number":"2938049","report_state":"TX","report_number":"V241333792","insp_date":"2024-02-15 00:00:00","insp_start_time":"1040","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-78 BONHAM TX","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"US SAND","shipping_paper_number":"528313","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-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"111200","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":"9202898","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-02-21 21:40:00","snet_input_date":"2024-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-21 21:40:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:03:47.000000Z","updated_at":"2025-03-17T20:03:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8217275,"change_date":"2024-02-22 21:43:00","inspection_id":"80907002","insp_unit_id":"199558718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"R455579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1EJ415415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"},{"id":8217276,"change_date":"2024-02-22 21:43:00","inspection_id":"80907002","insp_unit_id":"199558719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"0","insp_unit_license":"149B879","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C382XP1111423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:28.000000Z","updated_at":"2025-03-17T23:09:28.000000Z"}]},{"id":4990789,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","dot_number":"2938049","report_state":"TX","report_number":"V241319407","insp_date":"2024-02-02 00:00:00","insp_start_time":"0739","insp_end_time":"0819","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 82 WEST OF BONHAM","county_code_state":"TX","county_code":"147","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CUSTOMER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9189814","transaction_code":"C","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-02-06 21:42:00","snet_input_date":"2024-02-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-06 21:42:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T20:01:38.000000Z","updated_at":"2025-03-17T20:01:38.000000Z","inspection_violations":[{"id":7688138,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745810","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"38323A2"},{"id":7688139,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745811","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199341052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39311"},{"id":7688140,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745812","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"199341053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39345B2"},{"id":7688141,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745813","seq_no":"4","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199341052","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39360C"},{"id":7688142,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745814","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199341053","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"39375C"},{"id":7688143,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_violation_id":"257745815","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199341052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:08.000000Z","updated_at":"2025-03-17T21:43:08.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8032686,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_unit_id":"199341052","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TRK-1","insp_unit_license":"R455579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1EJ415415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"},{"id":8032687,"change_date":"2024-02-08 21:43:00","inspection_id":"80783264","insp_unit_id":"199341053","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":"TRL-1","insp_unit_license":"149B879","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C382XP1111423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:48.000000Z","updated_at":"2025-03-17T23:07:48.000000Z"}]},{"id":4786888,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","dot_number":"2938049","report_state":"TX","report_number":"6RLC9DST46","insp_date":"2024-01-04 00:00:00","insp_start_time":"1159","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ORTEGA","shipping_paper_number":"526384","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-01-08 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"10","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9167122","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2024-01-08 21:45:00","snet_input_date":"2024-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-08 21:45:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T19:57:38.000000Z","updated_at":"2025-03-17T19:57:38.000000Z","inspection_violations":[{"id":7385660,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240733","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"198865172","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"39375A"},{"id":7385661,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240734","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3939A"},{"id":7385662,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240735","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3939A"},{"id":7385663,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240736","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"39378"},{"id":7385664,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240737","seq_no":"5","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"39360C"},{"id":7385665,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240738","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3939A"},{"id":7385666,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240739","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3965B"},{"id":7385667,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240740","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3922"},{"id":7385668,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240741","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"3963A1"},{"id":7385669,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_violation_id":"257240742","seq_no":"10","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"198865171","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:40.000000Z","updated_at":"2025-03-17T21:41:40.000000Z","normalized_code":"39343A"}],"inspection_per_units":[{"id":7701252,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_unit_id":"198865171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"04","insp_unit_license":"R455579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1EJ415415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:51.000000Z","updated_at":"2025-03-17T23:04:51.000000Z"},{"id":7701253,"change_date":"2024-01-08 21:45:00","inspection_id":"80560176","insp_unit_id":"198865172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"391","insp_unit_license":"071C746","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1T91F3721W1247391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:51.000000Z","updated_at":"2025-03-17T23:04:51.000000Z"}]},{"id":4425829,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","dot_number":"2938049","report_state":"TX","report_number":"6Q0F9DST20","insp_date":"2023-11-08 00:00:00","insp_start_time":"1458","insp_end_time":"1609","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN COLLIN CO. (226-256","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9124987","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T19:50:42.000000Z","updated_at":"2025-03-17T19:50:42.000000Z","inspection_violations":[{"id":6849414,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398116","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198063083","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3965B"},{"id":6849415,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398117","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"198063083","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"393205C"},{"id":6849416,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398118","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198063083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3939A"},{"id":6849417,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398119","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198063083","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39378"},{"id":6849418,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398120","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198063083","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6849419,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_violation_id":"256398121","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7117734,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_unit_id":"198063083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"75T337M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4ND1JH4YN248999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"},{"id":7117735,"change_date":"2023-11-14 21:42:00","inspection_id":"80164415","insp_unit_id":"198063084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"149B879","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C382XP1111423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"}]},{"id":3524720,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","dot_number":"2938049","report_state":"TX","report_number":"6MQ89DNE7X","insp_date":"2023-07-13 00:00:00","insp_start_time":"0835","insp_end_time":"0919","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-SRT IN DENTON CO. (2155-246","county_code_state":"TX","county_code":"121","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","viol_total":"9","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9029904","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T19:32:47.000000Z","updated_at":"2025-03-17T19:32:47.000000Z","inspection_violations":[{"id":5435828,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104385","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196037705","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"39345B2"},{"id":5435829,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104386","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196037705","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"3965B"},{"id":5435830,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104387","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"3922"},{"id":5435831,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104388","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"39345B2"},{"id":5435832,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104389","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"39345B2"},{"id":5435833,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104390","seq_no":"6","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"39347A"},{"id":5435834,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104391","seq_no":"7","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"393207A"},{"id":5435835,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104392","seq_no":"8","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"393207A"},{"id":5435836,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_violation_id":"254104393","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196037706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:13.000000Z","updated_at":"2025-03-17T21:32:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5667695,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_unit_id":"196037705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"23","insp_unit_license":"73N179M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4ND1JH4YN248999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:43.000000Z","updated_at":"2025-03-17T22:47:43.000000Z"},{"id":5667696,"change_date":"2023-07-17 21:41:00","inspection_id":"79161830","insp_unit_id":"196037706","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"121C016","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C3823S1115774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:43.000000Z","updated_at":"2025-03-17T22:47:43.000000Z"}]},{"id":2947052,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","dot_number":"2938049","report_state":"TX","report_number":"6KI79DNE4S","insp_date":"2023-04-24 00:00:00","insp_start_time":"0755","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TW-PGBT IN DALLAS CO. (895-165","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110250","viol_total":"16","oos_total":"2","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8968125","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":"02938049","upload_search_indicator":"M","census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[{"id":4525232,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578946","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"20","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":"3939A"},{"id":4525233,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578947","seq_no":"16","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","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":"3922"},{"id":4525234,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578948","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","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":"3922"},{"id":4525235,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578949","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","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":"3922"},{"id":4525236,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578950","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","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":"3922"},{"id":4525237,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578951","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","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":"3922"},{"id":4525238,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578952","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194710233","insp_violation_category_id":"16","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":"39345B2"},{"id":4525239,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578953","seq_no":"6","part_no":"393","part_no_section":"70(b)","insp_viol_unit":"1","insp_unit_id":"194710233","insp_violation_category_id":"17","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":"39370B"},{"id":4525240,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578954","seq_no":"7","part_no":"393","part_no_section":"70(b)(1)(i)","insp_viol_unit":"1","insp_unit_id":"194710233","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39370B1I"},{"id":4525241,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578955","seq_no":"8","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194710233","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39375A3"},{"id":4525242,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578956","seq_no":"9","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"194710233","insp_violation_category_id":"30","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":"3965B"},{"id":4525243,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578957","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"29","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":"39617C"},{"id":4525244,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578958","seq_no":"11","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"16","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":"39347A"},{"id":4525245,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578959","seq_no":"12","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"22","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":"393207A"},{"id":4525246,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578960","seq_no":"13","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"23","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":"39375C"},{"id":4525247,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_violation_id":"252578961","seq_no":"14","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"194710234","insp_violation_category_id":"23","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":"39375C"}],"inspection_per_units":[{"id":4742091,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_unit_id":"194710233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1","insp_unit_license":"19U084M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4ND1JH4YN248999","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":4742092,"change_date":"2023-05-02 21:41:00","inspection_id":"78510749","insp_unit_id":"194710234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"121C016","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C3823S1115774","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":2536658,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","dot_number":"2938049","report_state":"TX","report_number":"6J699DLDAF","insp_date":"2023-03-07 00:00:00","insp_start_time":"0820","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0121 IN COLLIN CO. (230-264","county_code_state":"TX","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ORTEGA TRUCKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"110350","viol_total":"11","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8924815","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02938049","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"CONSUELO ORTEGA","insp_carrier_street":"721 ALDER DR","insp_carrier_city":"ANNA","insp_carrier_state":"TX","insp_carrier_zip_code":"75409","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0922730","created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[{"id":3902309,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555966","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39345B2"},{"id":3902310,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555967","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39345B2"},{"id":3902311,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555968","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193777470","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39345B2"},{"id":3902312,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555969","seq_no":"4","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"193777470","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39343A"},{"id":3902313,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555970","seq_no":"5","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"193777470","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"393203C"},{"id":3902314,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555971","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3963A1"},{"id":3902315,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555972","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193777470","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39617C"},{"id":3902316,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555973","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"39617C"},{"id":3902317,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555974","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193777470","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3922"},{"id":3902318,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555975","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3922"},{"id":3902319,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_violation_id":"251555976","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193777471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:20.000000Z","updated_at":"2025-03-17T21:25:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4083315,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_unit_id":"193777470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"1M00651","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4ND1JH4YN248999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"},{"id":4083316,"change_date":"2023-03-08 21:41:00","inspection_id":"78044380","insp_unit_id":"193777471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFK","insp_unit_company":null,"insp_unit_license":"121C016","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1L01C3823S1115774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2938049\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2938049\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2938049\/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\/2938049\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}