{"current_page":1,"data":[{"id":12684937,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","dot_number":"2434774","report_state":"TX","report_number":"V262495833","insp_date":"2026-08-07 00:00:00","insp_start_time":"0845","insp_end_time":"0924","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9805  US90","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PC ORACLE MOTORS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123350","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":"10064440","transaction_code":"A","transaction_date":"2026-08-10 00:00:00","upload_date":"2026-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-10 21:41:00","insp_carrier_name":"P C ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2026-08-13T09:40:34.000000Z","updated_at":"2026-08-22T09:31:53.000000Z","inspection_violations":[{"id":22084829,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_violation_id":"276041181","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"215078797","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:01:21.000000Z","updated_at":"2026-08-22T09:42:28.000000Z","normalized_code":"3939"},{"id":22084830,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_violation_id":"276041182","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"215078798","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:01:21.000000Z","updated_at":"2026-08-22T09:42:28.000000Z","normalized_code":"3922RG"},{"id":22084827,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_violation_id":"276041179","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"215078797","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:01:21.000000Z","updated_at":"2026-08-22T09:42:28.000000Z","normalized_code":"39345DB"},{"id":22084828,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_violation_id":"276041180","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"215078797","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-13T10:01:21.000000Z","updated_at":"2026-08-22T09:42:28.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":22015963,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_unit_id":"215078797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"7605","insp_unit_license":"20R866N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X7ED210851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:18:20.000000Z","updated_at":"2026-08-21T09:02:56.000000Z"},{"id":22015964,"change_date":"2026-08-10 21:41:00","inspection_id":"88658739","insp_unit_id":"215078798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"925","insp_unit_license":"267C372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2488CA431511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-13T09:18:20.000000Z","updated_at":"2026-08-21T09:02:56.000000Z"}]},{"id":12317088,"change_date":"2026-06-29 21:42:00","inspection_id":"88274886","dot_number":"2434774","report_state":"TX","report_number":"7GNB9DCNFS","insp_date":"2026-06-24 00:00:00","insp_start_time":"1152","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","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":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123350","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":"10008966","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"P C ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2026-07-02T09:40:45.000000Z","updated_at":"2026-07-10T09:31:44.000000Z","inspection_violations":[{"id":21434403,"change_date":"2026-06-29 21:42:00","inspection_id":"88274886","insp_violation_id":"275203736","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"214358168","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:01:06.000000Z","updated_at":"2026-07-10T09:43:32.000000Z","normalized_code":"39021A"},{"id":21434404,"change_date":"2026-06-29 21:42:00","inspection_id":"88274886","insp_violation_id":"275203737","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214358168","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:01:06.000000Z","updated_at":"2026-07-10T09:43:32.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":21392259,"change_date":"2026-06-29 21:42:00","inspection_id":"88274886","insp_unit_id":"214358168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"91P819N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP4D49X7ED210851","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:45.000000Z","updated_at":"2026-07-10T09:03:15.000000Z"},{"id":21392260,"change_date":"2026-06-29 21:42:00","inspection_id":"88274886","insp_unit_id":"214358169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"267C372","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2488CA431511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:45.000000Z","updated_at":"2026-07-10T09:03:15.000000Z"}]},{"id":7874502,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","dot_number":"2434774","report_state":"TX","report_number":"71299DHHZQ","insp_date":"2024-12-10 00:00:00","insp_start_time":"0934","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SL-0281 IN GREGG CO. (710-722)","county_code_state":"TX","county_code":"183","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9498431","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-14 21:40:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T21:01:35.000000Z","updated_at":"2025-03-17T21:01:35.000000Z","inspection_violations":[{"id":12305626,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528117","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205333729","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39347E"},{"id":12305627,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528118","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"205333730","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39347E"},{"id":12305628,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528119","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"205333730","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39347E"},{"id":12305629,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528120","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"205333729","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39353B"},{"id":12305630,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528121","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"205333730","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"39353B"},{"id":12305631,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_violation_id":"264528122","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"205333729","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:06:05.000000Z","updated_at":"2025-03-17T22:06:05.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":12709639,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_unit_id":"205333729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:21.000000Z","updated_at":"2025-03-17T23:55:21.000000Z"},{"id":12709640,"change_date":"2025-02-14 21:40:00","inspection_id":"83872101","insp_unit_id":"205333730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"311","insp_unit_license":"206B713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF5320082021610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:21.000000Z","updated_at":"2025-03-17T23:55:21.000000Z"}]},{"id":5031947,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","dot_number":"2434774","report_state":"TX","report_number":"V241289775","insp_date":"2024-02-05 00:00:00","insp_start_time":"0950","insp_end_time":"1044","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AEP TEXAS","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-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64520","viol_total":"9","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9194348","transaction_code":"A","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-12 21:41:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T20:02:24.000000Z","updated_at":"2025-03-17T20:02:24.000000Z","inspection_violations":[{"id":7754174,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794614","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"199384357","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39345"},{"id":7754175,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794615","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199384357","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39345B2"},{"id":7754176,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794616","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"199384358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39345B2"},{"id":7754177,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794617","seq_no":"4","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"199384358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39347D"},{"id":7754178,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794618","seq_no":"5","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"2","insp_unit_id":"199384358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39347D"},{"id":7754179,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794619","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199384357","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39347E"},{"id":7754180,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794620","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"199384358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39348A"},{"id":7754181,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794621","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199384357","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"39353B"},{"id":7754182,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_violation_id":"257794622","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199384358","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:43:28.000000Z","updated_at":"2025-03-17T21:43:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8099924,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_unit_id":"199384357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"},{"id":8099925,"change_date":"2024-02-12 21:41:00","inspection_id":"80828396","insp_unit_id":"199384358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAN","insp_unit_company":"311","insp_unit_license":"206B713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF5320082021610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:23.000000Z","updated_at":"2025-03-17T23:08:23.000000Z"}]},{"id":4728445,"change_date":"2024-12-06 21:44:00","inspection_id":"80496403","dot_number":"2434774","report_state":"TX","report_number":"V231262810","insp_date":"2023-12-13 00:00:00","insp_start_time":"0615","insp_end_time":"0706","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":"WEYERHAUSER","shipping_paper_number":"260091","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-12-28 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"133220","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":"9161096","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:46:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7606118,"change_date":"2024-12-06 21:44:00","inspection_id":"80496403","insp_unit_id":"204240334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"Y","insp_unit_decal_number":"33292017","created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"},{"id":7606119,"change_date":"2024-12-06 21:44:00","inspection_id":"80496403","insp_unit_id":"204240335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAN","insp_unit_company":"311","insp_unit_license":"206B713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF5320082021610","insp_unit_decal":"Y","insp_unit_decal_number":"33292018","created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"}]},{"id":4511249,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","dot_number":"2434774","report_state":"TX","report_number":"V231241572","insp_date":"2023-11-22 00:00:00","insp_start_time":"1250","insp_end_time":"1338","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 MM 308 \/ US 19","county_code_state":"TX","county_code":"371","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ORUCHE CHIMA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90220","viol_total":"12","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9134047","transaction_code":"C","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-28 21:42:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T19:52:13.000000Z","updated_at":"2025-03-17T19:52:13.000000Z","inspection_violations":[{"id":6981618,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675862","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"38323A2"},{"id":6981619,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675863","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198314183","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39345B2"},{"id":6981620,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675864","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39375C"},{"id":6981621,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675865","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39375C"},{"id":6981622,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675866","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39375C"},{"id":6981623,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675867","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39375C"},{"id":6981624,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675868","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3939A"},{"id":6981625,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675869","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198314183","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3939A"},{"id":6981626,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675870","seq_no":"9","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3958"},{"id":6981627,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675871","seq_no":"10","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3958F1"},{"id":6981628,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675872","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"39617C"},{"id":6981629,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_violation_id":"256675873","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198314184","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7255865,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_unit_id":"198314183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1922","insp_unit_license":"31N327M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD56GSGY0891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"},{"id":7255866,"change_date":"2023-12-01 21:43:00","inspection_id":"80258263","insp_unit_id":"198314184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"003","insp_unit_license":"203C558","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486FA225706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:57.000000Z","updated_at":"2025-03-17T23:00:57.000000Z"}]},{"id":4151391,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","dot_number":"2434774","report_state":"LA","report_number":"LAEO003050","insp_date":"2023-10-06 00:00:00","insp_start_time":"0644","insp_end_time":"0802","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"115","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-09 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1182928","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-09 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-10-09 21:35:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:57.000000Z","updated_at":"2025-03-17T19:44:57.000000Z","inspection_violations":[{"id":6426068,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","insp_violation_id":"255719862","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197452756","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39617C"},{"id":6426069,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","insp_violation_id":"255719863","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197452757","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39617C"},{"id":6426070,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","insp_violation_id":"255719864","seq_no":"3","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":6675082,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","insp_unit_id":"197452756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"Y","insp_unit_decal_number":"33385319","created_at":"2025-03-17T22:55:59.000000Z","updated_at":"2025-03-17T22:55:59.000000Z"},{"id":6675083,"change_date":"2023-10-09 21:35:00","inspection_id":"79861033","insp_unit_id":"197452757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"311","insp_unit_license":"206B713","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF5320082021610","insp_unit_decal":"Y","insp_unit_decal_number":"33385320","created_at":"2025-03-17T22:55:59.000000Z","updated_at":"2025-03-17T22:55:59.000000Z"}]},{"id":2011391,"change_date":"2022-12-27 21:39:00","inspection_id":"77445032","dot_number":"2434774","report_state":"AR","report_number":"D598001991","insp_date":"2022-12-22 00:00:00","insp_start_time":"1515","insp_end_time":"1526","registration_date":null,"region":"CT","ci_status_code":"C","location":"70","location_desc":"UNION COUNTY","county_code_state":"AR","county_code":"139","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"WARREN TIMBERS COMPANY","shipping_paper_number":"8329","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-24 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1437148","transaction_code":"C","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-24 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-24 21:30:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:41.000000Z","updated_at":"2025-03-17T19:03:41.000000Z","inspection_violations":[{"id":3122569,"change_date":"2022-12-27 21:39:00","inspection_id":"77445032","insp_violation_id":"250262827","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W979","created_at":"2025-03-17T21:21:49.000000Z","updated_at":"2025-03-17T21:21:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3235918,"change_date":"2022-12-27 21:39:00","inspection_id":"77445032","insp_unit_id":"192576882","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"},{"id":3235919,"change_date":"2022-12-27 21:39:00","inspection_id":"77445032","insp_unit_id":"192576883","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"005","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:10.000000Z","updated_at":"2025-03-17T22:29:10.000000Z"}]},{"id":1931498,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","dot_number":"2434774","report_state":"TX","report_number":"6GPA0AMXFY","insp_date":"2022-12-08 00:00:00","insp_start_time":"1006","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"STEEL AND PIPE SUPPLY","shipping_paper_number":"3102407","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-12-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"90220","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8848942","transaction_code":"C","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-12 21:44:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T19:02:14.000000Z","updated_at":"2025-03-17T19:02:14.000000Z","inspection_violations":[{"id":3003502,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","insp_violation_id":"250123572","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192449685","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39353B"},{"id":3003503,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","insp_violation_id":"250123573","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192449685","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39347E"},{"id":3003504,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","insp_violation_id":"250123574","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":3108409,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","insp_unit_id":"192449685","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:17.000000Z","updated_at":"2025-03-17T22:28:17.000000Z"},{"id":3108410,"change_date":"2022-12-15 21:39:00","inspection_id":"77353862","insp_unit_id":"192449686","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"005","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:17.000000Z","updated_at":"2025-03-17T22:28:17.000000Z"}]},{"id":1840288,"change_date":"2022-11-30 21:40:00","inspection_id":"77249224","dot_number":"2434774","report_state":"AR","report_number":"732D001195","insp_date":"2022-11-28 00:00:00","insp_start_time":"1605","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":"29-404","location_desc":"HEMPSTEAD CO (HOPE WEST STN)","county_code_state":"AR","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CERTAIN TEED","shipping_paper_number":"3161991","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126220","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1432793","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[{"id":2871620,"change_date":"2022-11-30 21:40:00","inspection_id":"77249224","insp_violation_id":"249845107","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3953A3II"},{"id":2871621,"change_date":"2022-11-30 21:40:00","inspection_id":"77249224","insp_violation_id":"249845108","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192186043","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2960703,"change_date":"2022-11-30 21:40:00","inspection_id":"77249224","insp_unit_id":"192186043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1979","insp_unit_license":"R549964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDV2GSHE4582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:16.000000Z","updated_at":"2025-03-17T22:27:16.000000Z"},{"id":2960704,"change_date":"2022-11-30 21:40:00","inspection_id":"77249224","insp_unit_id":"192186044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"05","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:16.000000Z","updated_at":"2025-03-17T22:27:16.000000Z"}]},{"id":1239161,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","dot_number":"2434774","report_state":"KS","report_number":"HP05090077","insp_date":"2022-09-07 00:00:00","insp_start_time":"1816","insp_end_time":"2010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WB I-70","county_code_state":"KS","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NATIONAL GYPSUM","shipping_paper_number":"6101256024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-08 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"123000","viol_total":"6","oos_total":"3","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1262660","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"ORUCHE CHIMA","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[{"id":1961743,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283111","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"190787769","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"39375A"},{"id":1961744,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283112","seq_no":"2","part_no":"393","part_no_section":"205(a)","insp_viol_unit":"2","insp_unit_id":"190787769","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"393205A"},{"id":1961745,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283113","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3958E1"},{"id":1961746,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283114","seq_no":"4","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3953A2"},{"id":1961747,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283115","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3922"},{"id":1961748,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_violation_id":"248283116","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190787768","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1994084,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_unit_id":"190787768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7603","insp_unit_license":"R628743","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPXDP9X2FD258399","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"},{"id":1994085,"change_date":"2022-09-08 21:38:00","inspection_id":"76555903","insp_unit_id":"190787769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"003","insp_unit_license":"203C558","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486FA225706","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"}]},{"id":683668,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","dot_number":"2434774","report_state":"TX","report_number":"6BYE0AKJH2","insp_date":"2022-06-20 00:00:00","insp_start_time":"1323","insp_end_time":"1435","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":"DO IT BEST CORP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"8693707","transaction_code":"A","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T18:39:48.000000Z","updated_at":"2025-03-17T18:39:48.000000Z","inspection_violations":[{"id":1076248,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_violation_id":"246688727","seq_no":"1","part_no":"393","part_no_section":"50(d)","insp_viol_unit":"1","insp_unit_id":"189436373","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39350D"},{"id":1076249,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_violation_id":"246688728","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"189436373","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39383G"},{"id":1076250,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_violation_id":"246688729","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189436373","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"39345B2"},{"id":1076251,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_violation_id":"246688730","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189436374","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1098741,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_unit_id":"189436373","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7601","insp_unit_license":"R135947","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCNAPR36C213753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"},{"id":1098742,"change_date":"2022-06-23 21:40:00","inspection_id":"75907126","insp_unit_id":"189436374","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"005","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"}]},{"id":663470,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","dot_number":"2434774","report_state":"TX","report_number":"6BQF0XSR8X","insp_date":"2022-06-12 00:00:00","insp_start_time":"1533","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPEC","shipping_paper_number":"310981","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8689861","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1044305,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","insp_violation_id":"246630614","seq_no":"1","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"189387466","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"393110B"},{"id":1044306,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","insp_violation_id":"246630615","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"189387465","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39360C"},{"id":1044307,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","insp_violation_id":"246630616","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189387465","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1066489,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","insp_unit_id":"189387465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7601","insp_unit_license":"R135947","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCNAPR36C213753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1066490,"change_date":"2022-06-21 21:42:00","inspection_id":"75883577","insp_unit_id":"189387466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"005","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":493204,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","dot_number":"2434774","report_state":"TX","report_number":"6B180XRNBI","insp_date":"2022-05-18 00:00:00","insp_start_time":"0800","insp_end_time":"0819","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A401","location_desc":"IH 35 SOUTHBOUND SAN MARCOS","county_code_state":"TX","county_code":"209","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPF","shipping_paper_number":"5287403","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-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"8667688","transaction_code":"A","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T18:36:21.000000Z","updated_at":"2025-03-17T18:36:21.000000Z","inspection_violations":[{"id":783211,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109762","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188940432","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39360C"},{"id":783212,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109763","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"188940432","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39383G"},{"id":783213,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109764","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188940432","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3965B"},{"id":783214,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109765","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188940432","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3939A"},{"id":783215,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109766","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188940433","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"3939A"},{"id":783216,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_violation_id":"246109767","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188940433","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:45.000000Z","updated_at":"2025-03-17T21:10:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":793081,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_unit_id":"188940432","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7601","insp_unit_license":"R135947","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSCNAPR36C213753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:05.000000Z","updated_at":"2025-03-17T22:13:05.000000Z"},{"id":793082,"change_date":"2022-05-26 21:43:00","inspection_id":"75681401","insp_unit_id":"188940433","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"005","insp_unit_license":"178B239","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS2486GA510617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:05.000000Z","updated_at":"2025-03-17T22:13:05.000000Z"}]},{"id":237799,"change_date":"2022-04-22 21:46:00","inspection_id":"75376618","dot_number":"2434774","report_state":"TX","report_number":"6A3N0TXFI8","insp_date":"2022-04-14 00:00:00","insp_start_time":"2318","insp_end_time":"2344","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN PECOS CO. (228-327)","county_code_state":"TX","county_code":"371","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"RE111324","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-22 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"123350","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":"8632403","transaction_code":"A","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02434774","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-22 21:46:00","insp_carrier_name":"PC ORACLE MOTORS","insp_carrier_street":"20224 MORTON RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77449","insp_colonia":null,"docket_number":"839535","insp_interstate":"Y","insp_carrier_state_id":"0867709","created_at":"2025-03-17T18:31:36.000000Z","updated_at":"2025-03-17T18:31:36.000000Z","inspection_violations":[{"id":366487,"change_date":"2022-04-22 21:46:00","inspection_id":"75376618","insp_violation_id":"245331958","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188303251","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":385653,"change_date":"2022-04-22 21:46:00","inspection_id":"75376618","insp_unit_id":"188303250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"7602","insp_unit_license":"R563128","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49XXHD356348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"},{"id":385654,"change_date":"2022-04-22 21:46:00","inspection_id":"75376618","insp_unit_id":"188303251","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"079","insp_unit_license":"179C191","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYFS248XDA619304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:35.000000Z","updated_at":"2025-03-17T22:10:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2434774\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2434774\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2434774\/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\/2434774\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}