{"current_page":1,"data":[{"id":12744820,"change_date":"2026-08-17 21:40:00","inspection_id":"88715761","dot_number":"1839175","report_state":"CA","report_number":"NF6O001724","insp_date":"2026-08-16 00:00:00","insp_start_time":"1605","insp_end_time":"1656","registration_date":null,"region":"PD","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GLOBAL BEST PRODUCE, INC.","shipping_paper_number":"SQ12805","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3998819","transaction_code":"A","transaction_date":"2026-08-17 00:00:00","upload_date":"2026-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-08-17 21:40:00","snet_input_date":"2026-08-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-17 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-22T09:38:58.000000Z","updated_at":"2026-08-28T09:30:27.000000Z","inspection_violations":[{"id":22186320,"change_date":"2026-08-17 21:40:00","inspection_id":"88715761","insp_violation_id":"276161835","seq_no":"1","part_no":"393","part_no_section":"11A1-LTSM","insp_viol_unit":"2","insp_unit_id":"215184425","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-08-20T09:54:35.000000Z","updated_at":"2026-08-28T09:39:49.000000Z","normalized_code":"39311A1LTSM"},{"id":22186321,"change_date":"2026-08-17 21:40:00","inspection_id":"88715761","insp_violation_id":"276161836","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"215184425","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-08-20T09:54:35.000000Z","updated_at":"2026-08-28T09:39:49.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":22123223,"change_date":"2026-08-17 21:40:00","inspection_id":"88715761","insp_unit_id":"215184425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"T1119\/WHT","insp_unit_license":"236C413","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0624KW146854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-20T09:14:12.000000Z","updated_at":"2026-08-28T09:01:42.000000Z"},{"id":22123222,"change_date":"2026-08-17 21:40:00","inspection_id":"88715761","insp_unit_id":"215184424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"007\/YELLO","insp_unit_license":"R775278","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1KD264844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-20T09:14:12.000000Z","updated_at":"2026-08-28T09:01:42.000000Z"}]},{"id":12589591,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","dot_number":"1839175","report_state":"CA","report_number":"NBED008178","insp_date":"2026-07-29 00:00:00","insp_start_time":"0230","insp_end_time":"0419","registration_date":null,"region":"PD","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N09","shipping_paper_number":"42503661","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3868634","transaction_code":"A","transaction_date":"2026-07-30 00:00:00","upload_date":"2026-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-07-30 21:42:00","snet_input_date":"2026-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-30 21:42:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-02T09:41:14.000000Z","updated_at":"2026-08-11T09:30:46.000000Z","inspection_violations":[{"id":21919436,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_violation_id":"275824207","seq_no":"1","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-02T10:02:14.000000Z","updated_at":"2026-08-10T09:42:19.000000Z","normalized_code":"39522H1ELDNUM"},{"id":21919437,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_violation_id":"275824208","seq_no":"2","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"214895259","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-02T10:02:14.000000Z","updated_at":"2026-08-10T09:42:19.000000Z","normalized_code":"39311A1LCHL"},{"id":21919438,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_violation_id":"275824209","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214895259","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-02T10:02:14.000000Z","updated_at":"2026-08-10T09:42:19.000000Z","normalized_code":"3922SLLEQP"},{"id":21919439,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_violation_id":"275824210","seq_no":"4","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"214895259","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2026-08-02T10:02:14.000000Z","updated_at":"2026-08-10T09:42:19.000000Z","normalized_code":"39345B2BHTD"},{"id":21919440,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_violation_id":"275824211","seq_no":"5","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"2","insp_unit_id":"214895260","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-02T10:02:14.000000Z","updated_at":"2026-08-10T09:42:19.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":21858243,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_unit_id":"214895260","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"737 WHT","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:20:23.000000Z","updated_at":"2026-08-10T09:02:01.000000Z"},{"id":21858242,"change_date":"2026-07-30 21:42:00","inspection_id":"88558610","insp_unit_id":"214895259","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003 WHT","insp_unit_license":"R810227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X1KD494644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:20:23.000000Z","updated_at":"2026-08-10T09:02:01.000000Z"}]},{"id":12536174,"change_date":"2026-07-23 21:42:00","inspection_id":"88502490","dot_number":"1839175","report_state":"TX","report_number":"V262492737","insp_date":"2026-07-21 00:00:00","insp_start_time":"1102","insp_end_time":"1159","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"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-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10042249","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-23 21:42:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2026-07-26T09:42:33.000000Z","updated_at":"2026-08-03T09:31:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21769461,"change_date":"2026-07-23 21:42:00","inspection_id":"88502490","insp_unit_id":"214793554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003","insp_unit_license":"R810227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X1KD494644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:41.000000Z","updated_at":"2026-08-03T09:06:34.000000Z"},{"id":21769462,"change_date":"2026-07-23 21:42:00","inspection_id":"88502490","insp_unit_id":"214793555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T-737","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:41.000000Z","updated_at":"2026-08-03T09:06:34.000000Z"}]},{"id":12350450,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","dot_number":"1839175","report_state":"TX","report_number":"V262436382","insp_date":"2026-06-29 00:00:00","insp_start_time":"1404","insp_end_time":"1503","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"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-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10015056","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-02 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2026-07-05T09:42:27.000000Z","updated_at":"2026-07-14T09:31:44.000000Z","inspection_violations":[{"id":21496304,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","insp_violation_id":"275286450","seq_no":"1","part_no":"393","part_no_section":"55D3","insp_viol_unit":"2","insp_unit_id":"214432151","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:06:18.000000Z","updated_at":"2026-07-14T09:44:06.000000Z","normalized_code":"39355D3"},{"id":21496306,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","insp_violation_id":"275286452","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"214432151","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-05T10:06:18.000000Z","updated_at":"2026-07-14T09:44:06.000000Z","normalized_code":"39617C"},{"id":21496305,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","insp_violation_id":"275286451","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"214432151","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-05T10:06:18.000000Z","updated_at":"2026-07-14T09:44:06.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":21447742,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","insp_unit_id":"214432150","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"005","insp_unit_license":"R775280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6NJ142390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:57.000000Z","updated_at":"2026-07-14T09:03:30.000000Z"},{"id":21447743,"change_date":"2026-07-02 21:41:00","inspection_id":"88311496","insp_unit_id":"214432151","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5306","insp_unit_license":"CZ6921","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A0627LW209348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:57.000000Z","updated_at":"2026-07-14T09:03:30.000000Z"}]},{"id":12312744,"change_date":"2026-06-29 21:41:00","inspection_id":"88270342","dot_number":"1839175","report_state":"NM","report_number":"4396Q4X89F","insp_date":"2026-06-26 00:00:00","insp_start_time":"0129","insp_end_time":"0200","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"NM","county_code_state":"NM","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YEARROUND ENTERPRISES INX","shipping_paper_number":"1482598278","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3642400","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-06-29 21:41:00","snet_input_date":"2026-06-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:34.000000Z","updated_at":"2026-07-10T09:31:08.000000Z","inspection_violations":[{"id":21427732,"change_date":"2026-06-29 21:41:00","inspection_id":"88270342","insp_violation_id":"275189686","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":"1158926","created_at":"2026-07-02T09:59:51.000000Z","updated_at":"2026-07-10T09:41:37.000000Z","normalized_code":"3922SLLS2"},{"id":21427733,"change_date":"2026-06-29 21:41:00","inspection_id":"88270342","insp_violation_id":"275189687","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1158927","created_at":"2026-07-02T09:59:51.000000Z","updated_at":"2026-07-10T09:41:37.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":21385335,"change_date":"2026-06-29 21:41:00","inspection_id":"88270342","insp_unit_id":"214345281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"UNIT5306","insp_unit_license":"CZ6921","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A0627LW209348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:32.000000Z","updated_at":"2026-07-10T09:02:25.000000Z"},{"id":21385334,"change_date":"2026-06-29 21:41:00","inspection_id":"88270342","insp_unit_id":"214345280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"UNIT003","insp_unit_license":"R810227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X1KD494644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:32.000000Z","updated_at":"2026-07-10T09:02:25.000000Z"}]},{"id":12103834,"change_date":"2026-06-05 21:37:00","inspection_id":"88048266","dot_number":"1839175","report_state":"CA","report_number":"NC0Q004787","insp_date":"2026-06-03 00:00:00","insp_start_time":"0453","insp_end_time":"0534","registration_date":null,"region":"PS","ci_status_code":"C","location":"830","location_desc":"CA","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"POSITIVE FEED","shipping_paper_number":"0225307","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3471088","transaction_code":"A","transaction_date":"2026-06-05 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-06-05 21:37:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-05 21:37:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-08T09:40:57.000000Z","updated_at":"2026-06-16T09:32:40.000000Z","inspection_violations":[{"id":21063899,"change_date":"2026-06-05 21:37:00","inspection_id":"88048266","insp_violation_id":"274709418","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213925698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-08T10:01:04.000000Z","updated_at":"2026-06-16T09:47:52.000000Z","normalized_code":"39353BB"},{"id":21063898,"change_date":"2026-06-05 21:37:00","inspection_id":"88048266","insp_violation_id":"274709417","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213925698","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-08T10:01:04.000000Z","updated_at":"2026-06-16T09:47:52.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":21030543,"change_date":"2026-06-05 21:37:00","inspection_id":"88048266","insp_unit_id":"213925698","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004\/RED","insp_unit_license":"R809121","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:05.000000Z","updated_at":"2026-06-16T09:05:00.000000Z"},{"id":21030544,"change_date":"2026-06-05 21:37:00","inspection_id":"88048266","insp_unit_id":"213925699","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107\/REF","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:05.000000Z","updated_at":"2026-06-16T09:05:00.000000Z"}]},{"id":11931807,"change_date":"2026-05-15 21:45:00","inspection_id":"87866462","dot_number":"1839175","report_state":"CA","report_number":"UDO7001568","insp_date":"2026-05-12 00:00:00","insp_start_time":"0833","insp_end_time":"0906","registration_date":null,"region":"PS","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LA TIENDONA PRODUCE INC","shipping_paper_number":"10952","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3338949","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-05-15 21:45:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:45:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:38.000000Z","updated_at":"2026-05-26T09:32:01.000000Z","inspection_violations":[{"id":20753678,"change_date":"2026-05-15 21:45:00","inspection_id":"87866462","insp_violation_id":"274295334","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213585252","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:15.000000Z","updated_at":"2026-05-26T09:45:27.000000Z","normalized_code":"39360C"},{"id":20753679,"change_date":"2026-05-15 21:45:00","inspection_id":"87866462","insp_violation_id":"274295335","seq_no":"2","part_no":"392","part_no_section":"60A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:15.000000Z","updated_at":"2026-05-26T09:45:27.000000Z","normalized_code":"39260AD"}],"inspection_per_units":[{"id":20749634,"change_date":"2026-05-15 21:45:00","inspection_id":"87866462","insp_unit_id":"213585253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107\/WHT","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:54.000000Z","updated_at":"2026-05-26T09:04:30.000000Z"},{"id":20749633,"change_date":"2026-05-15 21:45:00","inspection_id":"87866462","insp_unit_id":"213585252","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004\/RED","insp_unit_license":"R809121","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:54.000000Z","updated_at":"2026-05-26T09:04:26.000000Z"}]},{"id":11924087,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","dot_number":"1839175","report_state":"CA","report_number":"NBDH006524","insp_date":"2026-05-08 00:00:00","insp_start_time":"0818","insp_end_time":"0904","registration_date":null,"region":"PS","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NAFTA DISTRIBUTORS","shipping_paper_number":"CA#18 NAFTA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"5","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3330866","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:27.000000Z","updated_at":"2026-05-26T09:30:53.000000Z","inspection_violations":[{"id":20741830,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280845","seq_no":"5","part_no":"395","part_no_section":"3A3I-HOSPDIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"3953A3IHOSPDIT"},{"id":20741826,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280841","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"213571292","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"3929A2C"},{"id":20741831,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280846","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":20741827,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280842","seq_no":"2","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"213571292","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"39345B2BHTD"},{"id":20741828,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280843","seq_no":"3","part_no":"393","part_no_section":"40A-B","insp_viol_unit":"2","insp_unit_id":"213571292","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"39340AB"},{"id":20741829,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_violation_id":"274280844","seq_no":"4","part_no":"395","part_no_section":"3A2-HOSPRNC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"3953A2HOSPRNC"}],"inspection_per_units":[{"id":20737356,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_unit_id":"213571291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"005\/BLUE","insp_unit_license":"R775280","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6NJ142390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:36.000000Z","updated_at":"2026-05-26T09:02:57.000000Z"},{"id":20737357,"change_date":"2026-05-15 21:44:00","inspection_id":"87858392","insp_unit_id":"213571292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5.33104\/WHT","insp_unit_license":"207B192","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA062XHW705204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:36.000000Z","updated_at":"2026-05-26T09:02:57.000000Z"}]},{"id":11543776,"change_date":"2026-04-01 21:40:00","inspection_id":"87466301","dot_number":"1839175","report_state":"TX","report_number":"V262254693","insp_date":"2026-03-24 00:00:00","insp_start_time":"1034","insp_end_time":"1047","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DONJUAN TRUCKING LLC","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-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9903718","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2026-04-04T09:43:32.000000Z","updated_at":"2026-04-12T09:32:34.000000Z","inspection_violations":[{"id":19501882,"change_date":"2026-04-01 21:40:00","inspection_id":"87466301","insp_violation_id":"272797862","seq_no":"1","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"212482664","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:13:22.000000Z","updated_at":"2026-04-11T09:48:22.000000Z","normalized_code":"39345B2PC"}],"inspection_per_units":[{"id":19780506,"change_date":"2026-04-01 21:40:00","inspection_id":"87466301","insp_unit_id":"212482664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6","insp_unit_license":"R715240","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1GJ499545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:47.000000Z","updated_at":"2026-04-12T09:11:27.000000Z"},{"id":19780507,"change_date":"2026-04-01 21:40:00","inspection_id":"87466301","insp_unit_id":"212482665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:47.000000Z","updated_at":"2026-04-12T09:11:27.000000Z"}]},{"id":11389464,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","dot_number":"1839175","report_state":"TX","report_number":"V262265146","insp_date":"2026-03-09 00:00:00","insp_start_time":"1015","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6240  US77","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DON JUAN TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9885620","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-16 21:39:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2026-03-19T09:37:56.000000Z","updated_at":"2026-03-27T09:31:45.000000Z","inspection_violations":[{"id":19196876,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_violation_id":"272433684","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212163788","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-19T09:52:04.000000Z","updated_at":"2026-03-27T09:48:06.000000Z","normalized_code":"39378"},{"id":19196877,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_violation_id":"272433685","seq_no":"2","part_no":"395","part_no_section":"24D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-19T09:52:04.000000Z","updated_at":"2026-03-27T09:48:06.000000Z","normalized_code":"39524D"},{"id":19196878,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_violation_id":"272433686","seq_no":"3","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-19T09:52:04.000000Z","updated_at":"2026-03-27T09:48:06.000000Z","normalized_code":"3958E"},{"id":19196879,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_violation_id":"272433687","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"212163789","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-19T09:52:04.000000Z","updated_at":"2026-03-27T09:48:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":19504339,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_unit_id":"212163788","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"R775279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X6LJ400860","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:46.000000Z","updated_at":"2026-03-27T09:05:56.000000Z"},{"id":19504340,"change_date":"2026-03-16 21:39:00","inspection_id":"87303958","insp_unit_id":"212163789","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"12","insp_unit_license":"139C618","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2533N8451734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-19T09:12:46.000000Z","updated_at":"2026-03-27T09:05:56.000000Z"}]},{"id":11313277,"change_date":"2026-03-06 21:43:00","inspection_id":"87229531","dot_number":"1839175","report_state":"CA","report_number":"ND3G007271","insp_date":"2026-03-05 00:00:00","insp_start_time":"1815","insp_end_time":"1847","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MEDRANO PRODUCE","shipping_paper_number":"56594","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16197797","transaction_code":"A","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-06 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:52.000000Z","updated_at":"2026-03-17T09:31:31.000000Z","inspection_violations":[{"id":19040586,"change_date":"2026-03-06 21:43:00","inspection_id":"87229531","insp_violation_id":"272265741","seq_no":"1","part_no":"395","part_no_section":"8E1-HOSPVIDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"01Q200010","created_at":"2026-03-09T10:09:06.000000Z","updated_at":"2026-03-17T09:41:42.000000Z","normalized_code":"3958E1HOSPVIDOOS"}],"inspection_per_units":[{"id":19356658,"change_date":"2026-03-06 21:43:00","inspection_id":"87229531","insp_unit_id":"212022976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004\/RED","insp_unit_license":"R809121","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:30.000000Z","updated_at":"2026-03-17T09:04:07.000000Z"},{"id":19356659,"change_date":"2026-03-06 21:43:00","inspection_id":"87229531","insp_unit_id":"212022977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107\/WHITE","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:30.000000Z","updated_at":"2026-03-17T09:04:07.000000Z"}]},{"id":11311378,"change_date":"2026-03-06 21:42:00","inspection_id":"87227583","dot_number":"1839175","report_state":"TX","report_number":"V262239954","insp_date":"2026-03-04 00:00:00","insp_start_time":"0736","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MEDRANO PRODUCE","shipping_paper_number":"56594","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-03-06 21:42: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":"9876489","transaction_code":"A","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2026-03-09T09:42:41.000000Z","updated_at":"2026-03-17T09:31:16.000000Z","inspection_violations":[{"id":19033099,"change_date":"2026-03-06 21:42:00","inspection_id":"87227583","insp_violation_id":"272260075","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212019329","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:50.000000Z","updated_at":"2026-03-17T09:40:44.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":19352817,"change_date":"2026-03-06 21:42:00","inspection_id":"87227583","insp_unit_id":"212019329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004","insp_unit_license":"R809121","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:27.000000Z","updated_at":"2026-03-17T09:03:45.000000Z"},{"id":19352818,"change_date":"2026-03-06 21:42:00","inspection_id":"87227583","insp_unit_id":"212019330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:27.000000Z","updated_at":"2026-03-17T09:03:45.000000Z"}]},{"id":10909823,"change_date":"2026-02-02 21:39:00","inspection_id":"86941606","dot_number":"1839175","report_state":"CA","report_number":"UGWL001115","insp_date":"2026-01-30 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"PT","ci_status_code":"C","location":"770","location_desc":"N\/B US-101 AT LYNN","county_code_state":"CA","county_code":"111","insp_level_id":"3","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":"N","pen_cen_match":null,"final_status_date":"2026-02-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16153160","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-02 21:39:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-05T10:35:48.000000Z","updated_at":"2026-02-13T10:31:03.000000Z","inspection_violations":[{"id":18272570,"change_date":"2026-02-02 21:39:00","inspection_id":"86941606","insp_violation_id":"271558752","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-02-05T10:45:36.000000Z","updated_at":"2026-02-13T10:39:52.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":18345108,"change_date":"2026-02-02 21:39:00","inspection_id":"86941606","insp_unit_id":"211405760","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004","insp_unit_license":"R809121","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:45.000000Z","updated_at":"2026-02-13T10:05:53.000000Z"},{"id":18345109,"change_date":"2026-02-02 21:39:00","inspection_id":"86941606","insp_unit_id":"211405761","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-05T10:08:45.000000Z","updated_at":"2026-02-13T10:05:53.000000Z"}]},{"id":10365410,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","dot_number":"1839175","report_state":"TX","report_number":"V252045181","insp_date":"2025-12-03 00:00:00","insp_start_time":"0838","insp_end_time":"0923","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WONDERFUL CITRUS","shipping_paper_number":"CTX12882442","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9777607","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2025-12-08T10:32:07.000000Z","updated_at":"2025-12-09T10:31:29.000000Z","inspection_violations":[{"id":17356740,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","insp_violation_id":"270501342","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210449458","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:33:03.000000Z","updated_at":"2025-12-09T10:32:27.000000Z","normalized_code":"3939"},{"id":17356741,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","insp_violation_id":"270501343","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"210449457","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:33:03.000000Z","updated_at":"2025-12-09T10:32:27.000000Z","normalized_code":"39395A"},{"id":17356742,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","insp_violation_id":"270501344","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"210449458","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:33:03.000000Z","updated_at":"2025-12-09T10:32:27.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":17325475,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","insp_unit_id":"210449457","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"003","insp_unit_license":"R810227","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X1KD494644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:11.000000Z","updated_at":"2025-12-09T10:01:45.000000Z"},{"id":17325476,"change_date":"2025-12-05 21:43:00","inspection_id":"86494016","insp_unit_id":"210449458","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T737","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:11.000000Z","updated_at":"2025-12-09T10:01:45.000000Z"}]},{"id":9551866,"change_date":"2025-08-30 21:34:00","inspection_id":"85639634","dot_number":"1839175","report_state":"AZ","report_number":"5564000834","insp_date":"2025-08-28 00:00:00","insp_start_time":"1303","insp_end_time":"1340","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"CASA GRANDE AZ","county_code_state":"AZ","county_code":"021","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BONIPAK","shipping_paper_number":"0601280","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-30 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2200107","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2025-08-30 21:34:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-30 21:34:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:39.000000Z","updated_at":"2025-09-06T10:42:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15765764,"change_date":"2025-08-30 21:34:00","inspection_id":"85639634","insp_unit_id":"208670297","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"006","insp_unit_license":"R715240","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1GJ499545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:58.000000Z","updated_at":"2025-09-09T09:46:58.000000Z"},{"id":15765765,"change_date":"2025-08-30 21:34:00","inspection_id":"85639634","insp_unit_id":"208670298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"107","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:58.000000Z","updated_at":"2025-09-09T09:46:58.000000Z"}]},{"id":9418855,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","dot_number":"1839175","report_state":"AZ","report_number":"1012401216","insp_date":"2025-08-13 00:00:00","insp_start_time":"0829","insp_end_time":"0950","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"QUARTZSITE AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DOLE","shipping_paper_number":"8039352","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2131557","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2025-08-15 21:38:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-15 21:38:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:31.000000Z","updated_at":"2025-08-20T10:44:31.000000Z","inspection_violations":[{"id":15323599,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_violation_id":"268044106","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:44:45.000000Z","updated_at":"2025-08-19T10:43:48.000000Z","normalized_code":"3958A1HOSP"},{"id":15323600,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_violation_id":"268044107","seq_no":"2","part_no":"392","part_no_section":"2-SLLCP","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-08-18T10:44:45.000000Z","updated_at":"2025-08-19T10:43:48.000000Z","normalized_code":"3922SLLCP"},{"id":15323601,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_violation_id":"268044108","seq_no":"3","part_no":"393","part_no_section":"93A-SBA","insp_viol_unit":"1","insp_unit_id":"208410511","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:44:45.000000Z","updated_at":"2025-08-19T10:43:48.000000Z","normalized_code":"39393ASBA"},{"id":15323602,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_violation_id":"268044109","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208410511","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-18T10:44:45.000000Z","updated_at":"2025-08-19T10:43:48.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":15526143,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_unit_id":"208410510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"T737","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:25.000000Z","updated_at":"2025-08-19T09:45:11.000000Z"},{"id":15526144,"change_date":"2025-08-15 21:38:00","inspection_id":"85499248","insp_unit_id":"208410511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"003","insp_unit_license":"R715241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:25.000000Z","updated_at":"2025-08-19T09:45:11.000000Z"}]},{"id":9367336,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","dot_number":"1839175","report_state":"CA","report_number":"UF0O000795","insp_date":"2025-08-08 00:00:00","insp_start_time":"1255","insp_end_time":"1326","registration_date":null,"region":"PT","ci_status_code":"C","location":"760","location_desc":"S\/B US-101 AT EL CAPITAN RCH","county_code_state":"CA","county_code":"083","insp_level_id":"3","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":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15930852","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-08 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:17.000000Z","updated_at":"2025-08-12T10:44:17.000000Z","inspection_violations":[{"id":15218492,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","insp_violation_id":"267925891","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SD 07660","created_at":"2025-08-11T10:45:38.000000Z","updated_at":"2025-08-12T10:45:57.000000Z","normalized_code":"3922SLLS3"},{"id":15218493,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","insp_violation_id":"267925892","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:38.000000Z","updated_at":"2025-08-12T10:45:57.000000Z","normalized_code":"3953A1HOSPD"},{"id":15218494,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","insp_violation_id":"267925893","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208310981","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:38.000000Z","updated_at":"2025-08-12T10:45:57.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":15433096,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","insp_unit_id":"208310981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"R775278","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1KD264844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:15.000000Z"},{"id":15433097,"change_date":"2025-08-08 21:40:00","inspection_id":"85445088","insp_unit_id":"208310982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"236C413","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GRAA0624KW146854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:28.000000Z","updated_at":"2025-08-12T09:46:15.000000Z"}]},{"id":9054440,"change_date":"2025-07-02 21:40:00","inspection_id":"85115998","dot_number":"1839175","report_state":"CA","report_number":"NFDY000524","insp_date":"2025-07-01 00:00:00","insp_start_time":"2251","insp_end_time":"2338","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DOLE","shipping_paper_number":"3326308","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"115350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15883585","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:26.000000Z","updated_at":"2025-07-07T10:07:26.000000Z","inspection_violations":[{"id":14567908,"change_date":"2025-07-02 21:40:00","inspection_id":"85115998","insp_violation_id":"267184391","seq_no":"1","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"207685590","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-05T10:16:50.000000Z","updated_at":"2025-07-06T10:18:08.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":14855144,"change_date":"2025-07-02 21:40:00","inspection_id":"85115998","insp_unit_id":"207685589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"007\/YELL","insp_unit_license":"R775278","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1KD264844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:13.000000Z","updated_at":"2025-07-06T09:46:12.000000Z"},{"id":14855145,"change_date":"2025-07-02 21:40:00","inspection_id":"85115998","insp_unit_id":"207685590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107WHT","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:13.000000Z","updated_at":"2025-07-06T09:46:12.000000Z"}]},{"id":8883582,"change_date":"2025-06-12 21:41:00","inspection_id":"84935279","dot_number":"1839175","report_state":"NM","report_number":"6286P4I5M3","insp_date":"2025-06-11 00:00:00","insp_start_time":"0440","insp_end_time":"0505","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON I-10 3066 FT W OF I10 E BOU","county_code_state":"NM","county_code":"023","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BONITA PACKING COMPANY INC","shipping_paper_number":"0597065","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2195933","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2025-06-12 21:41:00","snet_input_date":"2025-06-12 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-06-12 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-15T10:01:10.000000Z","updated_at":"2025-06-16T10:00:38.000000Z","inspection_violations":[{"id":14240035,"change_date":"2025-06-12 21:41:00","inspection_id":"84935279","insp_violation_id":"266810598","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9911816","created_at":"2025-06-17T10:17:14.000000Z","updated_at":"2025-06-17T10:19:20.000000Z","normalized_code":"3922SLLS1"},{"id":14240036,"change_date":"2025-06-12 21:41:00","inspection_id":"84935279","insp_violation_id":"266810599","seq_no":"2","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-17T10:17:14.000000Z","updated_at":"2025-06-17T10:19:20.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":14552484,"change_date":"2025-06-12 21:41:00","inspection_id":"84935279","insp_unit_id":"207355521","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT003","insp_unit_license":"R715241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:30.000000Z","updated_at":"2025-06-16T09:45:55.000000Z"},{"id":14552485,"change_date":"2025-06-12 21:41:00","inspection_id":"84935279","insp_unit_id":"207355522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UNIT003","insp_unit_license":"179B415","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XGU539812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:30.000000Z","updated_at":"2025-06-16T09:45:55.000000Z"}]},{"id":8573353,"change_date":"2025-05-07 21:47:00","inspection_id":"84607474","dot_number":"1839175","report_state":"CA","report_number":"UE2I008799","insp_date":"2025-05-07 00:00:00","insp_start_time":"0740","insp_end_time":"0804","registration_date":null,"region":"PT","ci_status_code":"C","location":"834","location_desc":"NEEDLES AREA (VIDAL JUNCTION)","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SOPUS","shipping_paper_number":"519162626","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-07 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15810859","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-07 21:47:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T11:03:32.000000Z","updated_at":"2025-05-11T10:22:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13991993,"change_date":"2025-05-07 21:47:00","inspection_id":"84607474","insp_unit_id":"206746509","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"006\/BLU","insp_unit_license":"R715240","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X1GJ499545","insp_unit_decal":"Y","insp_unit_decal_number":"35101549","created_at":"2025-05-11T03:49:14.000000Z","updated_at":"2025-05-11T04:03:16.000000Z"},{"id":13991994,"change_date":"2025-05-07 21:47:00","inspection_id":"84607474","insp_unit_id":"206746510","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"01\/WHT","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:49:14.000000Z","updated_at":"2025-05-11T04:03:16.000000Z"}]},{"id":8561671,"change_date":"2025-05-06 21:40:00","inspection_id":"84595225","dot_number":"1839175","report_state":"CA","report_number":"NECL003111","insp_date":"2025-05-06 00:00:00","insp_start_time":"0722","insp_end_time":"0751","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15808499","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:26:18.000000Z","updated_at":"2025-05-10T10:52:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13925898,"change_date":"2025-05-06 21:40:00","inspection_id":"84595225","insp_unit_id":"206671060","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLU3X","insp_unit_license":"R775279","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X6LJ400860","insp_unit_decal":"Y","insp_unit_decal_number":"35075225","created_at":"2025-05-09T10:17:44.000000Z","updated_at":"2025-05-10T10:07:32.000000Z"},{"id":13925899,"change_date":"2025-05-06 21:40:00","inspection_id":"84595225","insp_unit_id":"206671061","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT2X","insp_unit_license":"CZ6921","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A0627LW209348","insp_unit_decal":"Y","insp_unit_decal_number":"35075226","created_at":"2025-05-09T10:17:44.000000Z","updated_at":"2025-05-10T10:07:32.000000Z"}]},{"id":8039101,"change_date":"2025-03-05 21:40:00","inspection_id":"84044830","dot_number":"1839175","report_state":"CA","report_number":"UF0G003190","insp_date":"2025-03-05 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"BLACKROCK PLATFORM SCALES","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNITED STATES COLD STORAGE","shipping_paper_number":"46552","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"15728474","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:00.000000Z","updated_at":"2025-03-17T21:05:00.000000Z","inspection_violations":[{"id":12563903,"change_date":"2025-03-05 21:40:00","inspection_id":"84044830","insp_violation_id":"264859229","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205649960","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12978581,"change_date":"2025-03-05 21:40:00","inspection_id":"84044830","insp_unit_id":"205649960","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLU 005","insp_unit_license":"R654679","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6NJ142390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"},{"id":12978582,"change_date":"2025-03-05 21:40:00","inspection_id":"84044830","insp_unit_id":"205649961","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 01","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:22.000000Z","updated_at":"2025-03-17T23:58:22.000000Z"}]},{"id":7084439,"change_date":"2024-10-30 21:41:00","inspection_id":"83040400","dot_number":"1839175","report_state":"TX","report_number":"V241656375","insp_date":"2024-10-21 00:00:00","insp_start_time":"1316","insp_end_time":"1353","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"COTULLA REST AREA IH","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNITED STATES COLD STORAGE","shipping_paper_number":"92701","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-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9415132","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-30 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2025-03-17T20:43:50.000000Z","updated_at":"2025-03-17T20:43:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11425708,"change_date":"2024-10-30 21:41:00","inspection_id":"83040400","insp_unit_id":"203663417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003","insp_unit_license":"R715241","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:19.000000Z","updated_at":"2025-03-17T23:41:19.000000Z"},{"id":11425709,"change_date":"2024-10-30 21:41:00","inspection_id":"83040400","insp_unit_id":"203663418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"01","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:19.000000Z","updated_at":"2025-03-17T23:41:19.000000Z"}]},{"id":6580698,"change_date":"2024-08-28 21:42:00","inspection_id":"82504479","dot_number":"1839175","report_state":"AZ","report_number":"7475000346","insp_date":"2024-08-21 00:00:00","insp_start_time":"1059","insp_end_time":"1130","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"EHRENBERG AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BOSKOVICH FARMS","shipping_paper_number":"679377","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"790427","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:36.000000Z","updated_at":"2025-03-17T20:33:36.000000Z","inspection_violations":[{"id":10230521,"change_date":"2024-08-28 21:42:00","inspection_id":"82504479","insp_violation_id":"261453147","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202620113","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39378A"},{"id":10230522,"change_date":"2024-08-28 21:42:00","inspection_id":"82504479","insp_violation_id":"261453148","seq_no":"2","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":10609038,"change_date":"2024-08-28 21:42:00","inspection_id":"82504479","insp_unit_id":"202620113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"R586564","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X1PJ258620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"},{"id":10609039,"change_date":"2024-08-28 21:42:00","inspection_id":"82504479","insp_unit_id":"202620114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"12","insp_unit_license":"139C618","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2533N8451734","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:53.000000Z","updated_at":"2025-03-17T23:32:53.000000Z"}]},{"id":6418981,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","dot_number":"1839175","report_state":"AZ","report_number":"XC32770266","insp_date":"2024-08-02 00:00:00","insp_start_time":"0955","insp_end_time":"1108","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZEREB","location_desc":"EHRENBERG AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SIMPLY FRESH","shipping_paper_number":"0578279_SO","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"728382","transaction_code":"A","transaction_date":"2024-08-08 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2024-08-08 21:41:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-08 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:56.000000Z","updated_at":"2025-03-17T20:29:56.000000Z","inspection_violations":[{"id":9967052,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_violation_id":"261080813","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202292775","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39617C"},{"id":9967053,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_violation_id":"261080814","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3958E1"},{"id":9967054,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_violation_id":"261080815","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3958E1"},{"id":9967055,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_violation_id":"261080816","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"3958E1"},{"id":9967056,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_violation_id":"261080817","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202292774","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:13.000000Z","updated_at":"2025-03-17T21:54:13.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10345200,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_unit_id":"202292774","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"004","insp_unit_license":"R637224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"},{"id":10345201,"change_date":"2024-08-08 21:41:00","inspection_id":"82332181","insp_unit_id":"202292775","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"107","insp_unit_license":"CZ7346","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:13.000000Z","updated_at":"2025-03-17T23:30:13.000000Z"}]},{"id":6379728,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","dot_number":"1839175","report_state":"CA","report_number":"UF2W000722","insp_date":"2024-08-01 00:00:00","insp_start_time":"1505","insp_end_time":"1545","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15468780","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-02 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:09.000000Z","updated_at":"2025-03-17T20:29:09.000000Z","inspection_violations":[{"id":9902701,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","insp_violation_id":"260989755","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3958"},{"id":9902702,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","insp_violation_id":"260989756","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3958E1"},{"id":9902703,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","insp_violation_id":"260989757","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:55.000000Z","updated_at":"2025-03-17T21:53:55.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10280939,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","insp_unit_id":"202213791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLU 005","insp_unit_license":"R654679","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X6NJ142390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:30.000000Z","updated_at":"2025-03-17T23:29:30.000000Z"},{"id":10280940,"change_date":"2024-08-02 21:40:00","inspection_id":"82290113","insp_unit_id":"202213792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT 01","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:30.000000Z","updated_at":"2025-03-17T23:29:30.000000Z"}]},{"id":5349668,"change_date":"2024-03-22 21:39:00","inspection_id":"81174784","dot_number":"1839175","report_state":"NM","report_number":"4304O29FX1","insp_date":"2024-03-21 00:00:00","insp_start_time":"1250","insp_end_time":"1305","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VANGUARD DIRECT","shipping_paper_number":"108086","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2081360","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2024-03-22 21:39:00","snet_input_date":"2024-03-22 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-03-22 21:39:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:40.000000Z","updated_at":"2025-03-17T20:08:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8615071,"change_date":"2024-03-22 21:39:00","inspection_id":"81174784","insp_unit_id":"200046907","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT001","insp_unit_license":"R639389","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X1PJ258620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:09.000000Z","updated_at":"2025-03-17T23:13:09.000000Z"},{"id":8615072,"change_date":"2024-03-22 21:39:00","inspection_id":"81174784","insp_unit_id":"200046908","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"UNITT1119","insp_unit_license":"CZ6921","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GR1A0627LW209348","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:09.000000Z","updated_at":"2025-03-17T23:13:09.000000Z"}]},{"id":4825280,"change_date":"2024-01-12 21:43:00","inspection_id":"80602128","dot_number":"1839175","report_state":"NM","report_number":"4004O0B95R","insp_date":"2024-01-11 00:00:00","insp_start_time":"0809","insp_end_time":"0830","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"AT INTERSECTION OF E MOTEL DR","county_code_state":"NM","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LIMONEIRA COMPANY","shipping_paper_number":"S071659","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2063533","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2024-01-12 21:43:00","snet_input_date":"2024-01-11 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:25.000000Z","updated_at":"2025-03-17T19:58:25.000000Z","inspection_violations":[{"id":7440117,"change_date":"2024-01-12 21:43:00","inspection_id":"80602128","insp_violation_id":"257321995","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9624996","created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7763283,"change_date":"2024-01-12 21:43:00","inspection_id":"80602128","insp_unit_id":"198944659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT 002","insp_unit_license":"R449033","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2ER412556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:23.000000Z","updated_at":"2025-03-17T23:05:23.000000Z"},{"id":7763284,"change_date":"2024-01-12 21:43:00","inspection_id":"80602128","insp_unit_id":"198944660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"UNIT 002","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF482S4J3073209","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:23.000000Z","updated_at":"2025-03-17T23:05:23.000000Z"}]},{"id":4501640,"change_date":"2023-11-27 21:43:00","inspection_id":"80247619","dot_number":"1839175","report_state":"CA","report_number":"UETI000479","insp_date":"2023-11-24 00:00:00","insp_start_time":"1156","insp_end_time":"1235","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNKIST","shipping_paper_number":"417500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15145783","transaction_code":"A","transaction_date":"2023-11-24 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-27 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:09.000000Z","updated_at":"2025-03-17T19:52:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7240203,"change_date":"2023-11-27 21:43:00","inspection_id":"80247619","insp_unit_id":"198229355","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"R449033","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2ER412556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"},{"id":7240204,"change_date":"2023-11-27 21:43:00","inspection_id":"80247619","insp_unit_id":"198229356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"003","insp_unit_license":"179B415","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XGU539812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:50.000000Z","updated_at":"2025-03-17T23:00:50.000000Z"}]},{"id":4017741,"change_date":"2023-09-20 21:40:00","inspection_id":"79712355","dot_number":"1839175","report_state":"CA","report_number":"UDB7007865","insp_date":"2023-09-19 00:00:00","insp_start_time":"1608","insp_end_time":"1619","registration_date":null,"region":"PT","ci_status_code":"C","location":"9525","location_desc":"GLENDORA","county_code_state":"CA","county_code":"037","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15067996","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-20 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:04.000000Z","updated_at":"2025-03-17T19:42:04.000000Z","inspection_violations":[{"id":6218305,"change_date":"2023-09-20 21:40:00","inspection_id":"79712355","insp_violation_id":"255386270","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00Q00096","created_at":"2025-03-17T21:35:59.000000Z","updated_at":"2025-03-17T21:35:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6460184,"change_date":"2023-09-20 21:40:00","inspection_id":"79712355","insp_unit_id":"197153878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"R639389","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X1PJ258620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:14.000000Z","updated_at":"2025-03-17T22:54:14.000000Z"},{"id":6460185,"change_date":"2023-09-20 21:40:00","inspection_id":"79712355","insp_unit_id":"197153879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"12","insp_unit_license":"139C618","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"0","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:14.000000Z","updated_at":"2025-03-17T22:54:14.000000Z"}]},{"id":3760224,"change_date":"2023-08-16 21:39:00","inspection_id":"79425329","dot_number":"1839175","report_state":"CA","report_number":"UE2I006173","insp_date":"2023-08-16 00:00:00","insp_start_time":"0855","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"834","location_desc":"NEEDLES AREA (VIDAL JUNCTION)","county_code_state":"CA","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"POSITIVE FEED","shipping_paper_number":"0210388","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15024694","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:14.000000Z","updated_at":"2025-03-17T19:37:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6046291,"change_date":"2023-08-16 21:39:00","inspection_id":"79425329","insp_unit_id":"196569716","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004\/RED","insp_unit_license":"R637224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"},{"id":6046292,"change_date":"2023-08-16 21:39:00","inspection_id":"79425329","insp_unit_id":"196569717","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107\/WHT","insp_unit_license":"4RL2426","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:50.000000Z","updated_at":"2025-03-17T22:50:50.000000Z"}]},{"id":3707156,"change_date":"2023-08-09 21:43:00","inspection_id":"79366516","dot_number":"1839175","report_state":"AZ","report_number":"0448000412","insp_date":"2023-08-08 00:00:00","insp_start_time":"1222","insp_end_time":"1239","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"AZ","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"2350082","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1829013","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-09 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5716298,"change_date":"2023-08-09 21:43:00","inspection_id":"79366516","insp_violation_id":"254560577","seq_no":"2","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":5960603,"change_date":"2023-08-09 21:43:00","inspection_id":"79366516","insp_unit_id":"196448341","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004","insp_unit_license":"R637224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5960604,"change_date":"2023-08-09 21:43:00","inspection_id":"79366516","insp_unit_id":"196448342","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107","insp_unit_license":"4RL2426","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3007528,"change_date":"2023-05-09 21:43:00","inspection_id":"78579091","dot_number":"1839175","report_state":"CA","report_number":"UEBH002459","insp_date":"2023-05-09 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"BLYTHE AREA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14894237","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:37.000000Z","updated_at":"2025-03-17T19:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4839173,"change_date":"2023-05-09 21:43:00","inspection_id":"78579091","insp_unit_id":"194845350","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"003\/ GRY","insp_unit_license":"R383047","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"Y","insp_unit_decal_number":"32539467","created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"},{"id":4839174,"change_date":"2023-05-09 21:43:00","inspection_id":"78579091","insp_unit_id":"194845351","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"107\/ WHT","insp_unit_license":"4RL2426","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:07.000000Z","updated_at":"2025-03-17T22:41:07.000000Z"}]},{"id":2374522,"change_date":"2023-02-14 21:42:00","inspection_id":"77860068","dot_number":"1839175","report_state":"CA","report_number":"NBED004425","insp_date":"2023-02-13 00:00:00","insp_start_time":"1136","insp_end_time":"1214","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LINEAGE LOGISTICS","shipping_paper_number":"4-353373","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14783143","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-14 21:42:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:22.000000Z","updated_at":"2025-03-17T19:10:22.000000Z","inspection_violations":[{"id":3657774,"change_date":"2023-02-14 21:42:00","inspection_id":"77860068","insp_violation_id":"251144908","seq_no":"1","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:14.000000Z","updated_at":"2025-03-17T21:24:14.000000Z","normalized_code":"3958"},{"id":3657775,"change_date":"2023-02-14 21:42:00","inspection_id":"77860068","insp_violation_id":"251144909","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:14.000000Z","updated_at":"2025-03-17T21:24:14.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":3821159,"change_date":"2023-02-14 21:42:00","inspection_id":"77860068","insp_unit_id":"193406035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"004 RED","insp_unit_license":"R637224","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1ND782389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:22.000000Z","updated_at":"2025-03-17T22:33:22.000000Z"},{"id":3821160,"change_date":"2023-02-14 21:42:00","inspection_id":"77860068","insp_unit_id":"193406036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"737 WHT","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:22.000000Z","updated_at":"2025-03-17T22:33:22.000000Z"}]},{"id":2064670,"change_date":"2023-01-04 21:39:00","inspection_id":"77505729","dot_number":"1839175","report_state":"NM","report_number":"0940N03B6P","insp_date":"2023-01-03 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ANTHONY PORT OF ENTRY","county_code_state":"NM","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LGC US ASSET HOLDINGS LLC","shipping_paper_number":"HOUS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1968105","transaction_code":"A","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-04 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-01-04 21:39:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:43.000000Z","updated_at":"2025-03-17T19:04:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3321416,"change_date":"2023-01-04 21:39:00","inspection_id":"77505729","insp_unit_id":"192692479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT001","insp_unit_license":"R639389","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X1PJ258620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:47.000000Z","updated_at":"2025-03-17T22:29:47.000000Z"},{"id":3321417,"change_date":"2023-01-04 21:39:00","inspection_id":"77505729","insp_unit_id":"192692480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"UNIT01","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:47.000000Z","updated_at":"2025-03-17T22:29:47.000000Z"}]},{"id":1679790,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","dot_number":"1839175","report_state":"TX","report_number":"6FJE0ZCMJC","insp_date":"2022-10-27 00:00:00","insp_start_time":"1440","insp_end_time":"1507","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0377 IN KIMBLE CO. (526-568","county_code_state":"TX","county_code":"267","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUN PACIFIC MARKETING","shipping_paper_number":"363880","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8818880","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-04 21:38:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2025-03-17T18:57:28.000000Z","updated_at":"2025-03-17T18:57:28.000000Z","inspection_violations":[{"id":2634828,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_violation_id":"249451990","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191822220","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39345D"},{"id":2634829,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_violation_id":"249451991","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191822220","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39347E"},{"id":2634830,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_violation_id":"249451992","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191822220","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39353B"},{"id":2634831,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_violation_id":"249451993","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191822221","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2702639,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_unit_id":"191822220","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"007","insp_unit_license":"R234334","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X9AJ274653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:31.000000Z","updated_at":"2025-03-17T22:25:31.000000Z"},{"id":2702640,"change_date":"2022-11-04 21:38:00","inspection_id":"77065347","insp_unit_id":"191822221","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T737","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:31.000000Z","updated_at":"2025-03-17T22:25:31.000000Z"}]},{"id":1011944,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","dot_number":"1839175","report_state":"CA","report_number":"NC2K004916","insp_date":"2022-08-10 00:00:00","insp_start_time":"0659","insp_end_time":"0736","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"POSTIVE FEED","shipping_paper_number":"0205477","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14543464","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-10 21:40:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:27.000000Z","updated_at":"2025-03-17T18:45:27.000000Z","inspection_violations":[{"id":1594163,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644656","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"190248644","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39524D"},{"id":1594164,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644657","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190248644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3939A"},{"id":1594165,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644658","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190248644","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3963A1"},{"id":1594166,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644659","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190248644","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39347E"},{"id":1594167,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644660","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"190248645","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3965B"},{"id":1594168,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644661","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190248645","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA136215","created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3963A1"},{"id":1594169,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644662","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190248645","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3963A1"},{"id":1594170,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644663","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190248645","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3963A1"},{"id":1594171,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_violation_id":"247644664","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190248645","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1628125,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_unit_id":"190248644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"007\/GLD","insp_unit_license":"R234334","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X9AJ274653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"},{"id":1628126,"change_date":"2022-08-10 21:40:00","inspection_id":"76291377","insp_unit_id":"190248645","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T737\/WHT","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:15.000000Z","updated_at":"2025-03-17T22:18:15.000000Z"}]},{"id":622094,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","dot_number":"1839175","report_state":"CA","report_number":"NE5Z001145","insp_date":"2022-06-14 00:00:00","insp_start_time":"2130","insp_end_time":"2240","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"POSTIVE FEED LTD","shipping_paper_number":"0204428","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"5","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14469848","transaction_code":"A","transaction_date":"2022-06-14 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:46.000000Z","updated_at":"2025-03-17T18:38:46.000000Z","inspection_violations":[{"id":977316,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_violation_id":"246501792","seq_no":"1","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39522H2"},{"id":977317,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_violation_id":"246501793","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3958E1"},{"id":977318,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_violation_id":"246501794","seq_no":"3","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3958"},{"id":977319,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_violation_id":"246501795","seq_no":"4","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"39532B"},{"id":977320,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_violation_id":"246501796","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189281239","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1000436,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_unit_id":"189281239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"GRY\/002","insp_unit_license":"R449033","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X2ER412556","insp_unit_decal":"Y","insp_unit_decal_number":"31156209","created_at":"2025-03-17T22:14:21.000000Z","updated_at":"2025-03-17T22:14:21.000000Z"},{"id":1000437,"change_date":"2022-06-15 21:41:00","inspection_id":"75834391","insp_unit_id":"189281240","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/107","insp_unit_license":"4RL2426","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2534J2324705","insp_unit_decal":"Y","insp_unit_decal_number":"31156210","created_at":"2025-03-17T22:14:21.000000Z","updated_at":"2025-03-17T22:14:21.000000Z"}]},{"id":592159,"change_date":"2022-06-13 21:41:00","inspection_id":"75798371","dot_number":"1839175","report_state":"NM","report_number":"0940M4J9GC","insp_date":"2022-06-12 00:00:00","insp_start_time":"0835","insp_end_time":"0852","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ANTHONY PORT OF ENTRY","county_code_state":"NM","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOGISTICS PASSION FOR EXCELLENCE","shipping_paper_number":"NAD1308951","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1912435","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-13 00:00:00","source_office":"2NMS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:06.000000Z","updated_at":"2025-03-17T18:38:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":951497,"change_date":"2022-06-13 21:41:00","inspection_id":"75798371","insp_unit_id":"189201091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"001","insp_unit_license":"R603113","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X4PR245889","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"},{"id":951498,"change_date":"2022-06-13 21:41:00","inspection_id":"75798371","insp_unit_id":"189201092","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"01","insp_unit_license":"140C092","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3UTVS2536K8639904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:04.000000Z","updated_at":"2025-03-17T22:14:04.000000Z"}]},{"id":295601,"change_date":"2022-04-30 21:30:00","inspection_id":"75445747","dot_number":"1839175","report_state":"NM","report_number":"4793M3BDF2","insp_date":"2022-04-29 00:00:00","insp_start_time":"1100","insp_end_time":"1130","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"AT INTERSECTION OF I-10 AND I","county_code_state":"NM","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GIUMARRA","shipping_paper_number":"550","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-30 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1902286","transaction_code":"A","transaction_date":"2022-04-30 00:00:00","upload_date":"2022-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":"2022-04-30 21:30:00","snet_input_date":"2022-04-30 00:00:00","source_office":"2NMS001","mcmis_add_date":"2022-04-30 21:30:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:37.000000Z","updated_at":"2025-03-17T18:32:37.000000Z","inspection_violations":[{"id":460210,"change_date":"2022-04-30 21:30:00","inspection_id":"75445747","insp_violation_id":"245497639","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9180889","created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"3922"},{"id":460211,"change_date":"2022-04-30 21:30:00","inspection_id":"75445747","insp_violation_id":"245497640","seq_no":"2","part_no":"390","part_no_section":"21(c)","insp_viol_unit":"1","insp_unit_id":"188441926","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:15.000000Z","updated_at":"2025-03-17T21:09:15.000000Z","normalized_code":"39021C"}],"inspection_per_units":[{"id":478314,"change_date":"2022-04-30 21:30:00","inspection_id":"75445747","insp_unit_id":"188441926","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"R383047","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:08.000000Z","updated_at":"2025-03-17T22:11:08.000000Z"},{"id":478315,"change_date":"2022-04-30 21:30:00","inspection_id":"75445747","insp_unit_id":"188441927","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3","insp_unit_license":"179B415","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XGU539812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:08.000000Z","updated_at":"2025-03-17T22:11:08.000000Z"}]},{"id":149412,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","dot_number":"1839175","report_state":"TX","report_number":"69TK0WKJ7P","insp_date":"2022-04-04 00:00:00","insp_start_time":"2001","insp_end_time":"2042","registration_date":"2022-05-02 00:00:00","region":"CT","ci_status_code":"C","location":"3C299","location_desc":"US-0281 IN BROOKS CO. (708-742","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TABAFRESH FARMS","shipping_paper_number":"112056","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8616167","transaction_code":"C","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":"0251602","created_at":"2025-03-17T18:30:09.000000Z","updated_at":"2025-03-17T18:30:09.000000Z","inspection_violations":[{"id":222147,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_violation_id":"245547915","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188483933","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3939A"},{"id":222148,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_violation_id":"245547916","seq_no":"2","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"188483933","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39355D2"},{"id":222149,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_violation_id":"245547917","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188483933","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39617C"},{"id":222150,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_violation_id":"245547918","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188483934","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":242255,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_unit_id":"188483933","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"007","insp_unit_license":"R234334","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X9AJ274653","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"},{"id":242256,"change_date":"2022-05-03 21:39:00","inspection_id":"75271224","insp_unit_id":"188483934","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"T737","insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS2536CU304513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"}]},{"id":186552,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","dot_number":"1839175","report_state":"AZ","report_number":"0272M2GHL9","insp_date":"2022-03-29 00:00:00","insp_start_time":"1330","insp_end_time":"1405","registration_date":null,"region":"MS","ci_status_code":"C","location":"I10","location_desc":"INTERSTATE 10","county_code_state":"AZ","county_code":"012","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINGS RIVER PACKING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1744861","transaction_code":"A","transaction_date":"2022-04-12 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-12 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":284701,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_violation_id":"245189049","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"3922"},{"id":284702,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_violation_id":"245189050","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"3922"},{"id":284703,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_violation_id":"245189051","seq_no":"3","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39522H4"},{"id":284704,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_violation_id":"245189052","seq_no":"5","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39522H2"},{"id":284705,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_violation_id":"245189053","seq_no":"6","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":302204,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_unit_id":"188179511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KEN","insp_unit_company":null,"insp_unit_license":"R234334","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X9AJ274653","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:01.000000Z","updated_at":"2025-03-17T22:10:01.000000Z"},{"id":302205,"change_date":"2022-04-15 21:37:00","inspection_id":"75315614","insp_unit_id":"188179512","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"124B998","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:01.000000Z","updated_at":"2025-03-17T22:10:01.000000Z"}]},{"id":32548,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","dot_number":"1839175","report_state":"CA","report_number":"NDT8002620","insp_date":"2022-03-22 00:00:00","insp_start_time":"2111","insp_end_time":"2149","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC C.V.E.F.","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14355288","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01839175","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-23 21:33:00","insp_carrier_name":"DONJUAN TRUCKING LLC","insp_carrier_street":"11803 SHADY MEADOW ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77039","insp_colonia":null,"docket_number":"666600","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:07.000000Z","updated_at":"2025-03-17T18:28:07.000000Z","inspection_violations":[{"id":46534,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_violation_id":"244752586","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"187795909","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"3965B"},{"id":46535,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_violation_id":"244752587","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"187795909","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA206474","created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"39345"},{"id":46536,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_violation_id":"244752588","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"187795910","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"39347E"},{"id":46537,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_violation_id":"244752589","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"187795910","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":52385,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_unit_id":"187795909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLK 3X","insp_unit_license":"R383047","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD49X5EJ320064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"},{"id":52386,"change_date":"2022-03-23 21:33:00","inspection_id":"75127099","insp_unit_id":"187795910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT RFR","insp_unit_license":"179B415","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS253XGU539812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1839175\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1839175\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1839175\/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\/1839175\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}