{"current_page":1,"data":[{"id":12545164,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","dot_number":"2290160","report_state":"TX","report_number":"7HFD9DVC68","insp_date":"2026-07-22 00:00:00","insp_start_time":"1304","insp_end_time":"1419","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"22","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"20","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10042939","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2026-07-24 21:41:00","snet_input_date":"2026-07-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-24 21:41:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2026-07-27T09:41:41.000000Z","updated_at":"2026-08-04T09:31:28.000000Z","inspection_violations":[{"id":21839545,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722468","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39353B"},{"id":21839546,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722469","seq_no":"5","part_no":"392","part_no_section":"9A2","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3929A2"},{"id":21839544,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722467","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39347E"},{"id":21839542,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722465","seq_no":"1","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3963A1BOS"},{"id":21839543,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722466","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39347E"},{"id":21839547,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722470","seq_no":"6","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"38323A2"},{"id":21839548,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722471","seq_no":"7","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39141APC"},{"id":21839549,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722472","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3922RG"},{"id":21839550,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722473","seq_no":"9","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39617C"},{"id":21839551,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722474","seq_no":"10","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39617C"},{"id":21839552,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722475","seq_no":"11","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39355D1"},{"id":21839553,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722476","seq_no":"12","part_no":"393","part_no_section":"55D2","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39355D2"},{"id":21839554,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722477","seq_no":"13","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39355E"},{"id":21839555,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722478","seq_no":"14","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39378"},{"id":21839556,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722479","seq_no":"15","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3939H"},{"id":21839557,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722480","seq_no":"16","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3939H"},{"id":21839558,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722481","seq_no":"17","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39328"},{"id":21839559,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722482","seq_no":"18","part_no":"393","part_no_section":"201A","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"393201A"},{"id":21839560,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722483","seq_no":"19","part_no":"393","part_no_section":"201A","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"393201A"},{"id":21839561,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722484","seq_no":"20","part_no":"393","part_no_section":"201D","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"393201D"},{"id":21839562,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722485","seq_no":"21","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"214810054","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"3939"},{"id":21839563,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_violation_id":"275722486","seq_no":"22","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"214810053","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-27T10:02:23.000000Z","updated_at":"2026-08-04T09:44:26.000000Z","normalized_code":"39383H"}],"inspection_per_units":[{"id":21784153,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_unit_id":"214810053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"83Z410W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6DR9ADAS2596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:03.000000Z","updated_at":"2026-08-04T09:02:58.000000Z"},{"id":21784154,"change_date":"2026-07-24 21:41:00","inspection_id":"88511856","insp_unit_id":"214810054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"57143","insp_unit_license":"106B447","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W07L027905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:20:03.000000Z","updated_at":"2026-08-04T09:02:58.000000Z"}]},{"id":11999346,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","dot_number":"2290160","report_state":"TX","report_number":"7FPD9DVC41","insp_date":"2026-05-21 00:00:00","insp_start_time":"1301","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500  S BATTLEGROUND","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-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"76240","viol_total":"19","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"19","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9966284","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2026-05-25T09:41:20.000000Z","updated_at":"2026-06-02T09:32:54.000000Z","inspection_violations":[{"id":20875877,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456132","seq_no":"1","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939T"},{"id":20875878,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456133","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939TS"},{"id":20875879,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456134","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939"},{"id":20875880,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456135","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39319"},{"id":20875881,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456136","seq_no":"5","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39345DLUV"},{"id":20875882,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456137","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39617C"},{"id":20875883,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456138","seq_no":"7","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39395A"},{"id":20875884,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456139","seq_no":"8","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39355E"},{"id":20875885,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456140","seq_no":"9","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39355D1"},{"id":20875886,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456141","seq_no":"10","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39355D2"},{"id":20875887,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456142","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939"},{"id":20875888,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456143","seq_no":"12","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939"},{"id":20875889,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456144","seq_no":"13","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939"},{"id":20875890,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456145","seq_no":"14","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213715833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3939"},{"id":20875891,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456146","seq_no":"15","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"393201D"},{"id":20875892,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456147","seq_no":"16","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39348A"},{"id":20875893,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456148","seq_no":"17","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"39348A"},{"id":20875894,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456149","seq_no":"18","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3963A1BOS"},{"id":20875895,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_violation_id":"274456150","seq_no":"19","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"213715832","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:11.000000Z","updated_at":"2026-06-02T09:45:22.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":20859334,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_unit_id":"213715832","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"181","insp_unit_license":"1P04627","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EJ49N491101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:34.000000Z","updated_at":"2026-06-02T09:06:21.000000Z"},{"id":20859335,"change_date":"2026-05-22 21:38:00","inspection_id":"87937728","insp_unit_id":"213715833","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":null,"insp_unit_license":"274C080","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S12E95345E501494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:34.000000Z","updated_at":"2026-06-02T09:06:21.000000Z"}]},{"id":12019713,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","dot_number":"2290160","report_state":"TX","report_number":"7FFA9DFP64","insp_date":"2026-05-11 00:00:00","insp_start_time":"1010","insp_end_time":"1104","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7500  FAIRMONT PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ROXANE WATER","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-05-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"18","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"18","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9967405","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2026-05-26 21:40:00","snet_input_date":"2026-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-26 21:40:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2026-05-29T09:40:01.000000Z","updated_at":"2026-06-06T09:32:04.000000Z","inspection_violations":[{"id":20912092,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504443","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3922W"},{"id":20912093,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504444","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39347E"},{"id":20912094,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504445","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39347E"},{"id":20912095,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504446","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39347E"},{"id":20912096,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504447","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39353B"},{"id":20912097,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504448","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3963A1BOS"},{"id":20912098,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504449","seq_no":"7","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3939TS"},{"id":20912099,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504450","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3939"},{"id":20912100,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504451","seq_no":"9","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39319"},{"id":20912101,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504452","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"213756656","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3939"},{"id":20912102,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504453","seq_no":"11","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39360C"},{"id":20912103,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504454","seq_no":"12","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39383G"},{"id":20912104,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504455","seq_no":"13","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3965B"},{"id":20912105,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504456","seq_no":"14","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39345B2UV"},{"id":20912106,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504457","seq_no":"15","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"213756656","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39345B2UV"},{"id":20912107,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504458","seq_no":"16","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213756656","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3922RG"},{"id":20912108,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504459","seq_no":"17","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213756655","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"3922RG"},{"id":20912109,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_violation_id":"274504460","seq_no":"18","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"213756656","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:59:39.000000Z","updated_at":"2026-06-06T09:44:22.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":20892956,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_unit_id":"213756655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"178","insp_unit_license":"19P741N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG22LJ01922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:38.000000Z","updated_at":"2026-06-06T09:04:20.000000Z"},{"id":20892957,"change_date":"2026-05-26 21:40:00","inspection_id":"87959258","insp_unit_id":"213756656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"22614","insp_unit_license":"47U741N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S12E95345E501494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:38.000000Z","updated_at":"2026-06-06T09:04:20.000000Z"}]},{"id":10781212,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","dot_number":"2290160","report_state":"TX","report_number":"7C5A9DCQB1","insp_date":"2026-01-13 00:00:00","insp_start_time":"1029","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  GULFGATE CENTE","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS PRODUCTS","shipping_paper_number":"528759674","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-15 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"117000","viol_total":"31","oos_total":"7","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"31","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9819031","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2026-01-18T10:45:09.000000Z","updated_at":"2026-01-26T10:31:06.000000Z","inspection_violations":[{"id":18014242,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235852","seq_no":"7","part_no":"393","part_no_section":"45D-SGNCNB","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39345DSGNCNB"},{"id":18014247,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235857","seq_no":"13","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39347A"},{"id":18014248,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235858","seq_no":"14","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39347A"},{"id":18014249,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235859","seq_no":"15","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3939"},{"id":18014261,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235871","seq_no":"28","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39348A"},{"id":18014262,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235872","seq_no":"29","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39348A"},{"id":18014263,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235873","seq_no":"30","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39348A"},{"id":18014264,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235874","seq_no":"31","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39353B"},{"id":18014238,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235848","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39395A"},{"id":18014239,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235849","seq_no":"4","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39355D1"},{"id":18014240,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235850","seq_no":"5","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39351"},{"id":18014241,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235851","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39378"},{"id":18014243,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235853","seq_no":"8","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39375A3TAOL"},{"id":18014244,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235854","seq_no":"9","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39375A3TAOL"},{"id":18014245,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235855","seq_no":"11","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3963A1"},{"id":18014246,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235856","seq_no":"12","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39348A"},{"id":18014250,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235860","seq_no":"16","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3939"},{"id":18014251,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235861","seq_no":"17","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39375A3TAOL"},{"id":18014252,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235862","seq_no":"18","part_no":"393","part_no_section":"45A-HJS","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39345AHJS"},{"id":18014253,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235863","seq_no":"19","part_no":"393","part_no_section":"13D2","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39313D2"},{"id":18014254,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235864","seq_no":"20","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3939"},{"id":18014255,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235865","seq_no":"21","part_no":"393","part_no_section":"75A2","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39375A2"},{"id":18014256,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235866","seq_no":"22","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39328"},{"id":18014257,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235867","seq_no":"23","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39355E"},{"id":18014258,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235868","seq_no":"24","part_no":"393","part_no_section":"207A","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"393207A"},{"id":18014259,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235869","seq_no":"26","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3963A1BOS"},{"id":18014260,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235870","seq_no":"27","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39348A"},{"id":18014265,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235875","seq_no":"32","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39353B"},{"id":18014266,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235876","seq_no":"33","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211116007","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39617C"},{"id":18014267,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235877","seq_no":"34","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"39617C"},{"id":18014268,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_violation_id":"271235878","seq_no":"35","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211116008","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18100078,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_unit_id":"211116007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"179","insp_unit_license":"55S551N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSSEB9YLF36616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:41.000000Z","updated_at":"2026-01-26T10:01:17.000000Z"},{"id":18100079,"change_date":"2026-01-15 21:41:00","inspection_id":"86806926","insp_unit_id":"211116008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"22614","insp_unit_license":"218B348","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S12E95345E501494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:41.000000Z","updated_at":"2026-01-26T10:01:17.000000Z"}]},{"id":10838151,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","dot_number":"2290160","report_state":"TX","report_number":"7C4B9DGXBW","insp_date":"2026-01-12 00:00:00","insp_start_time":"1125","insp_end_time":"1204","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS PRODUCTS","shipping_paper_number":"528763045","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"16","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"16","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9825651","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2026-01-22 21:40:00","snet_input_date":"2026-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-22 21:40:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2026-01-25T10:37:05.000000Z","updated_at":"2026-02-02T10:30:56.000000Z","inspection_violations":[{"id":18124413,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372332","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"},{"id":18124414,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372333","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"39311"},{"id":18124415,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372334","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3939"},{"id":18124416,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372335","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3939"},{"id":18124417,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372336","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"},{"id":18124418,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372337","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"},{"id":18124419,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372338","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"},{"id":18124420,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372339","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"},{"id":18124421,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372340","seq_no":"9","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"39617C"},{"id":18124422,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372341","seq_no":"10","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"39360C"},{"id":18124423,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372342","seq_no":"11","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"39375A3TAOL"},{"id":18124424,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372343","seq_no":"12","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"393209E"},{"id":18124425,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372344","seq_no":"13","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3965B"},{"id":18124426,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372345","seq_no":"14","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"211243958","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3963A1"},{"id":18124427,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372346","seq_no":"15","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"39348A"},{"id":18124428,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_violation_id":"271372347","seq_no":"16","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211243957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-25T10:42:53.000000Z","updated_at":"2026-02-02T10:37:33.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18208774,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_unit_id":"211243957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"988","insp_unit_license":"092B812","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYDSEB4TH566898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:23.000000Z","updated_at":"2026-02-02T10:03:30.000000Z"},{"id":18208775,"change_date":"2026-01-22 21:40:00","inspection_id":"86866513","insp_unit_id":"211243958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1041","insp_unit_license":"091C954","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W0XL590422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:23.000000Z","updated_at":"2026-02-02T10:03:30.000000Z"}]},{"id":10084416,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","dot_number":"2290160","report_state":"TX","report_number":"7A0D9DCV5D","insp_date":"2025-10-28 00:00:00","insp_start_time":"1337","insp_end_time":"1424","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  SENS RD","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":"2025-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"9741944","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2025-10-30 21:43:00","snet_input_date":"2025-10-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-30 21:43:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-11-02T11:02:24.000000Z","updated_at":"2025-11-03T11:04:22.000000Z","inspection_violations":[{"id":16701501,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632272","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209754263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"3939"},{"id":16701502,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632273","seq_no":"2","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"209754263","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"39355D1"},{"id":16701503,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632274","seq_no":"3","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"209754263","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"39311TU"},{"id":16701504,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632275","seq_no":"4","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"209754264","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"39328"},{"id":16701505,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632276","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"209754264","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"39311"},{"id":16701506,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632277","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209754263","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"3922RG"},{"id":16701507,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632278","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"209754264","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"3922RG"},{"id":16701508,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_violation_id":"269632279","seq_no":"8","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209754263","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:18:13.000000Z","updated_at":"2025-11-03T11:17:02.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16763814,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_unit_id":"209754263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"181","insp_unit_license":"79X069W","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EJ49N491101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:42.000000Z","updated_at":"2025-11-03T10:46:51.000000Z"},{"id":16763815,"change_date":"2025-10-30 21:43:00","inspection_id":"86199171","insp_unit_id":"209754264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"218B348","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S12E95345E501494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:42.000000Z","updated_at":"2025-11-03T10:46:51.000000Z"}]},{"id":9206185,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","dot_number":"2290160","report_state":"TX","report_number":"775B9DGXZS","insp_date":"2025-07-17 00:00:00","insp_start_time":"1104","insp_end_time":"1146","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","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":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"22","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9643959","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-07-25T10:45:32.000000Z","inspection_violations":[{"id":14880232,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542609","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3922RG"},{"id":14880233,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542610","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3922RG"},{"id":14880234,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542611","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39617C"},{"id":14880235,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542612","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39395A"},{"id":14880236,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542613","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939H"},{"id":14880237,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542614","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939"},{"id":14880238,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542615","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939"},{"id":14880239,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542616","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939"},{"id":14880240,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542617","seq_no":"9","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939TS"},{"id":14880241,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542618","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3939"},{"id":14880242,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542619","seq_no":"11","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39375A1"},{"id":14880243,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542620","seq_no":"12","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3965B"},{"id":14880244,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542621","seq_no":"13","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39311"},{"id":14880245,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542622","seq_no":"14","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39347E"},{"id":14880246,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542623","seq_no":"15","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39347E"},{"id":14880247,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542624","seq_no":"16","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39347E"},{"id":14880248,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542625","seq_no":"17","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39347E"},{"id":14880249,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542626","seq_no":"18","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3963A1B"},{"id":14880250,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542627","seq_no":"19","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39353B"},{"id":14880251,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542628","seq_no":"20","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"207988884","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39353B"},{"id":14880252,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542629","seq_no":"21","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"3963A1BOS"},{"id":14880253,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_violation_id":"267542630","seq_no":"22","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"207988883","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:58.000000Z","updated_at":"2025-07-25T10:46:58.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":15134787,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_unit_id":"207988883","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"78","insp_unit_license":"1L44150","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG22LJ01922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:37.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"},{"id":15134788,"change_date":"2025-07-21 21:41:00","inspection_id":"85275662","insp_unit_id":"207988884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5333","insp_unit_license":"545177ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532W17L063344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:37.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"}]},{"id":9156456,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","dot_number":"2290160","report_state":"TX","report_number":"76WC9DCK5R","insp_date":"2025-07-08 00:00:00","insp_start_time":"1251","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS PRODUCTS","shipping_paper_number":"521411587","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-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"15","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9637443","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-07-18T10:46:06.000000Z","updated_at":"2025-07-19T10:42:13.000000Z","inspection_violations":[{"id":14774628,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423204","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39378"},{"id":14774629,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423205","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"3939"},{"id":14774630,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423206","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39345B2UV"},{"id":14774631,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423207","seq_no":"4","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39345B2UV"},{"id":14774632,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423208","seq_no":"5","part_no":"393","part_no_section":"207B","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"393207B"},{"id":14774633,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423209","seq_no":"6","part_no":"393","part_no_section":"43A","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39343A"},{"id":14774634,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423210","seq_no":"7","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"3965BHWSLIW"},{"id":14774635,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423211","seq_no":"8","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39375A1"},{"id":14774636,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423212","seq_no":"9","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39375C"},{"id":14774637,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423213","seq_no":"10","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39347A"},{"id":14774638,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423214","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"3922RG"},{"id":14774639,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423215","seq_no":"12","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39617C"},{"id":14774640,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423216","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"26","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39378"},{"id":14774641,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423217","seq_no":"14","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"207885811","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"3963A1BL"},{"id":14774642,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_violation_id":"267423218","seq_no":"15","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"2","insp_unit_id":"207885812","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:22.000000Z","updated_at":"2025-07-18T10:48:22.000000Z","normalized_code":"39345DLPC"}],"inspection_per_units":[{"id":15038828,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_unit_id":"207885811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYDSEB4TH566898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:45:58.000000Z"},{"id":15038829,"change_date":"2025-07-15 21:40:00","inspection_id":"85223375","insp_unit_id":"207885812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"22613","insp_unit_license":"047C705","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C61T090181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:41.000000Z","updated_at":"2025-07-19T09:45:58.000000Z"}]},{"id":8922338,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","dot_number":"2290160","report_state":"TX","report_number":"764A9DTK7S","insp_date":"2025-06-10 00:00:00","insp_start_time":"1046","insp_end_time":"1158","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5800  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS PRODUCTS","shipping_paper_number":"520630342","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"26","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"26","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9608674","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":"M","census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"DATAJO TRUCKING LLC","insp_carrier_street":"18062 FM 529 #115","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-06-20T10:00:58.000000Z","updated_at":"2025-06-22T10:00:46.000000Z","inspection_violations":[{"id":14313470,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896334","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922RG"},{"id":14313471,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896335","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922RG"},{"id":14313472,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896336","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922RG"},{"id":14313473,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896337","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39617C"},{"id":14313474,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896338","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39617C"},{"id":14313475,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896339","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922RG"},{"id":14313476,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896340","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922RG"},{"id":14313477,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896341","seq_no":"8","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3922W"},{"id":14313478,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896342","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39311"},{"id":14313479,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896343","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939"},{"id":14313480,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896344","seq_no":"11","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939TS"},{"id":14313481,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896345","seq_no":"12","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39319"},{"id":14313482,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896346","seq_no":"13","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939T"},{"id":14313483,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896347","seq_no":"14","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939"},{"id":14313484,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896348","seq_no":"15","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939"},{"id":14313485,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896349","seq_no":"16","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3965B"},{"id":14313486,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896350","seq_no":"17","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39355D1"},{"id":14313487,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896351","seq_no":"18","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39355C2"},{"id":14313488,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896352","seq_no":"19","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39345DLPC"},{"id":14313489,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896353","seq_no":"20","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39347E"},{"id":14313490,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896354","seq_no":"21","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39347E"},{"id":14313491,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896355","seq_no":"22","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39347E"},{"id":14313492,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896356","seq_no":"23","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39353B"},{"id":14313493,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896357","seq_no":"24","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"39353B"},{"id":14313494,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896358","seq_no":"25","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207431698","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3963A1BOS"},{"id":14313495,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_violation_id":"266896359","seq_no":"26","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207431699","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-20T10:16:44.000000Z","updated_at":"2025-06-21T10:17:55.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14620940,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_unit_id":"207431698","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"181","insp_unit_license":"1M37634","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4V4NC9EJ49N491101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:07.000000Z","updated_at":"2025-06-22T09:46:02.000000Z"},{"id":14620941,"change_date":"2025-06-17 21:41:00","inspection_id":"84976532","insp_unit_id":"207431699","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1041","insp_unit_license":"091C954","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W0XL590422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:07.000000Z","updated_at":"2025-06-22T09:46:02.000000Z"}]},{"id":8493202,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","dot_number":"2290160","report_state":"TX","report_number":"74TD9DAPPX","insp_date":"2025-04-24 00:00:00","insp_start_time":"1346","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CDS CADECO SUGAR","shipping_paper_number":"286548","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-29 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"16","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"14","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9563337","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2025-04-29 21:49:00","snet_input_date":"2025-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-29 21:49:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-05-02T10:27:01.000000Z","updated_at":"2025-05-02T13:50:45.000000Z","inspection_violations":[{"id":13435406,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884962","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3922RG"},{"id":13435407,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884963","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3922RG"},{"id":13435408,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884964","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3922RG"},{"id":13435409,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884965","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3922RG"},{"id":13435410,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884966","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39617C"},{"id":13435411,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884967","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39617C"},{"id":13435412,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884968","seq_no":"7","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39141APC"},{"id":13435413,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884969","seq_no":"8","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39348A"},{"id":13435414,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884970","seq_no":"9","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39348A"},{"id":13435415,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884971","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3963A1BOS"},{"id":13435416,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884972","seq_no":"11","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"206538432","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39383G"},{"id":13435417,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884973","seq_no":"12","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39355C2"},{"id":13435418,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884974","seq_no":"13","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39311"},{"id":13435419,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884975","seq_no":"14","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"39311"},{"id":13435420,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884976","seq_no":"15","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"206538433","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"3922W"},{"id":13435421,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_violation_id":"265884977","seq_no":"16","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:19.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":13803849,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_unit_id":"206538432","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"180","insp_unit_license":"1M06592","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYDSEB4TH566898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:43.000000Z","updated_at":"2025-05-03T10:07:54.000000Z"},{"id":13803850,"change_date":"2025-04-29 21:49:00","inspection_id":"84522978","insp_unit_id":"206538433","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"047C705","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C61T090181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:43.000000Z","updated_at":"2025-05-03T10:07:54.000000Z"}]},{"id":7016248,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","dot_number":"2290160","report_state":"TX","report_number":"6ZEG9DJMS9","insp_date":"2024-10-11 00:00:00","insp_start_time":"1613","insp_end_time":"1634","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  S SAM HOUSTON","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS PRODUCTS","shipping_paper_number":"511772105","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-10-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9407692","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[{"id":10949906,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492546","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3922SLLS2"},{"id":10949907,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492547","seq_no":"2","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39216"},{"id":10949908,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492548","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203529480","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3922RG"},{"id":10949909,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492549","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203529479","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"3922RG"},{"id":10949910,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492550","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203529480","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39617C"},{"id":10949911,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_violation_id":"262492551","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"203529479","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11316614,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_unit_id":"203529479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L44150","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG22LJ01922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:11.000000Z","updated_at":"2025-03-17T23:40:11.000000Z"},{"id":11316615,"change_date":"2024-10-22 21:42:00","inspection_id":"82968089","insp_unit_id":"203529480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"106B447","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W07L027905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:11.000000Z","updated_at":"2025-03-17T23:40:11.000000Z"}]},{"id":5745684,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","dot_number":"2290160","report_state":"TX","report_number":"6V1D9DLEG0","insp_date":"2024-05-07 00:00:00","insp_start_time":"1220","insp_end_time":"1412","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700  SENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2024-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"15","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9272908","transaction_code":"C","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2024-05-14 21:42:00","snet_input_date":"2024-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-14 21:42:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T20:16:40.000000Z","updated_at":"2025-03-17T20:16:40.000000Z","inspection_violations":[{"id":8891653,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526043","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"3963A1"},{"id":8891654,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526044","seq_no":"2","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39347A"},{"id":8891655,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526045","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39347A"},{"id":8891656,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526046","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39347E"},{"id":8891657,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526047","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39353B"},{"id":8891658,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526048","seq_no":"6","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39355D1"},{"id":8891659,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526049","seq_no":"7","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39355D2"},{"id":8891660,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526050","seq_no":"8","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39355E"},{"id":8891661,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526051","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39617C"},{"id":8891662,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526052","seq_no":"11","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39375C"},{"id":8891663,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526053","seq_no":"12","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39375C"},{"id":8891664,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526054","seq_no":"13","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39345B2"},{"id":8891665,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526055","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"3939A"},{"id":8891666,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526056","seq_no":"15","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"200911526","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39328"},{"id":8891667,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_violation_id":"259526057","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200911525","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:02.000000Z","updated_at":"2025-03-17T21:49:02.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9254472,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_unit_id":"200911525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"180","insp_unit_license":"21R546M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6DR9ADAS2596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:07.000000Z","updated_at":"2025-03-17T23:19:07.000000Z"},{"id":9254473,"change_date":"2024-05-15 21:44:00","inspection_id":"81606476","insp_unit_id":"200911526","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1041","insp_unit_license":"091C954","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W0XL590422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:07.000000Z","updated_at":"2025-03-17T23:19:07.000000Z"}]},{"id":5492194,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","dot_number":"2290160","report_state":"TX","report_number":"6U299DCO5V","insp_date":"2024-04-02 00:00:00","insp_start_time":"0910","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1300  GENOA RED BLUF","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":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"15","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9245539","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T20:11:33.000000Z","updated_at":"2025-03-17T20:11:33.000000Z","inspection_violations":[{"id":8482621,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886770","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39395A"},{"id":8482622,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886771","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39395F"},{"id":8482623,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886772","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482624,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886773","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482625,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886774","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482626,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886775","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39319"},{"id":8482627,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886776","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482628,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886777","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3922"},{"id":8482629,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886778","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200358898","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39617C"},{"id":8482630,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886779","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482631,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886780","seq_no":"11","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39355E"},{"id":8482632,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886781","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8482633,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886782","seq_no":"13","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39311"},{"id":8482634,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886783","seq_no":"14","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3922"},{"id":8482635,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_violation_id":"258886784","seq_no":"15","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200358899","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8847017,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_unit_id":"200358898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"177","insp_unit_license":"1M06592","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYDSEB4TH566898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"},{"id":8847018,"change_date":"2024-04-11 21:41:00","inspection_id":"81330674","insp_unit_id":"200358899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"10411","insp_unit_license":"091C954","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W0XL590422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":586057,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","dot_number":"2290160","report_state":"TX","report_number":"6B779DNOJI","insp_date":"2022-05-24 00:00:00","insp_start_time":"0723","insp_end_time":"0812","registration_date":"2022-06-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"300 W THIRTEENTH ST","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2022-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8672420","transaction_code":"C","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2022-06-10 21:41:00","snet_input_date":"2022-05-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-10 21:41:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T18:38:04.000000Z","updated_at":"2025-03-17T18:38:04.000000Z","inspection_violations":[{"id":918364,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524907","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3922"},{"id":918365,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524908","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189302581","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39355E"},{"id":918366,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524909","seq_no":"3","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"189302581","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"393201A"},{"id":918367,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524910","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189302581","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3939A"},{"id":918368,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524911","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189302581","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3939A"},{"id":918369,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524912","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3965B"},{"id":918370,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524913","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39353B"},{"id":918371,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524914","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"3963A1"},{"id":918372,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524915","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39347E"},{"id":918373,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524916","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189302580","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39347E"},{"id":918374,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_violation_id":"246524917","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189302581","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:17.000000Z","updated_at":"2025-03-17T21:11:17.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":941599,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_unit_id":"189302580","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"178","insp_unit_license":"1M37634","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG22LJ01922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:00.000000Z","updated_at":"2025-03-17T22:14:00.000000Z"},{"id":941600,"change_date":"2022-06-16 21:43:00","inspection_id":"75791202","insp_unit_id":"189302581","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1041","insp_unit_license":"091C954","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W0XL590422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:00.000000Z","updated_at":"2025-03-17T22:14:00.000000Z"}]},{"id":493647,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","dot_number":"2290160","report_state":"TX","report_number":"6B269DCR4Y","insp_date":"2022-05-19 00:00:00","insp_start_time":"0651","insp_end_time":"0805","registration_date":"2022-06-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2022-05-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"22","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8667960","transaction_code":"C","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2022-05-26 21:43:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-26 21:43:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T18:36:21.000000Z","updated_at":"2025-03-17T18:36:21.000000Z","inspection_violations":[{"id":784749,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526268","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784750,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526269","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784751,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526270","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784752,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526271","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784753,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526272","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784754,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526273","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39347E"},{"id":784755,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526274","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39353B"},{"id":784756,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526275","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39353B"},{"id":784757,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526276","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3963A1"},{"id":784758,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526277","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39311"},{"id":784759,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526278","seq_no":"11","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39351"},{"id":784760,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526279","seq_no":"12","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3965B"},{"id":784761,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526280","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"},{"id":784762,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526281","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"},{"id":784763,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526282","seq_no":"15","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39355D3"},{"id":784764,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526283","seq_no":"16","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39375C"},{"id":784765,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526284","seq_no":"17","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39375C"},{"id":784766,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526285","seq_no":"18","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3922"},{"id":784767,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526286","seq_no":"19","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3922"},{"id":784768,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526287","seq_no":"20","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39617C"},{"id":784769,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526288","seq_no":"21","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189303183","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39617C"},{"id":784770,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_violation_id":"246526289","seq_no":"22","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189303182","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":793826,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_unit_id":"189303182","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M37634","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG22LJ01922","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":793827,"change_date":"2022-06-16 21:43:00","inspection_id":"75681950","insp_unit_id":"189303183","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"57143","insp_unit_license":"106B447","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532W07L027905","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":130719,"change_date":"2022-04-07 21:39:00","inspection_id":"75248748","dot_number":"2290160","report_state":"TX","report_number":"69VB9DNNDA","insp_date":"2022-04-06 00:00:00","insp_start_time":"1155","insp_end_time":"1234","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VEE EXPRESS","shipping_paper_number":"21217-1OT","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":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8614210","transaction_code":"A","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02290160","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"JOSE SALINAS","insp_carrier_street":"19935 CRESTED HILL LN","insp_carrier_city":"CYPRESS","insp_carrier_state":"TX","insp_carrier_zip_code":"77433","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0812390","created_at":"2025-03-17T18:29:50.000000Z","updated_at":"2025-03-17T18:29:50.000000Z","inspection_violations":[{"id":193676,"change_date":"2022-04-07 21:39:00","inspection_id":"75248748","insp_violation_id":"245032051","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188046013","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":211880,"change_date":"2022-04-07 21:39:00","inspection_id":"75248748","insp_unit_id":"188046013","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"179","insp_unit_license":"862361F","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSSEB9YLF36616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"},{"id":211881,"change_date":"2022-04-07 21:39:00","inspection_id":"75248748","insp_unit_id":"188046014","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"22613","insp_unit_license":"047C705","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C61T090181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:29.000000Z","updated_at":"2025-03-17T22:09:29.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2290160\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2290160\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2290160\/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\/2290160\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}