{"current_page":1,"data":[{"id":7393070,"change_date":"2024-12-13 21:41:00","inspection_id":"83366452","dot_number":"4053531","report_state":"TX","report_number":"70WB9DFVJG","insp_date":"2024-12-04 00:00:00","insp_start_time":"1141","insp_end_time":"1207","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10600  FM 1472 RD","county_code_state":"TX","county_code":"479","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"BOBTAIL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9444839","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[{"id":11550092,"change_date":"2024-12-13 21:41:00","inspection_id":"83366452","insp_violation_id":"263452697","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204375478","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39360C"},{"id":11550093,"change_date":"2024-12-13 21:41:00","inspection_id":"83366452","insp_violation_id":"263452698","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204375478","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":11926243,"change_date":"2024-12-13 21:41:00","inspection_id":"83366452","insp_unit_id":"204375478","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AE016","insp_unit_license":"R734001","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR7HN674598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7111327,"change_date":"2024-11-04 21:40:00","inspection_id":"83069044","dot_number":"4053531","report_state":"SC","report_number":"0284004538","insp_date":"2024-10-30 00:00:00","insp_start_time":"1549","insp_end_time":"1612","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DUNCAN SC","county_code_state":"SC","county_code":"083","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"FIRST QUALITY TISSUE","shipping_paper_number":"611389223","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":"2024-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1018399","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:17.000000Z","updated_at":"2025-03-17T20:44:17.000000Z","inspection_violations":[{"id":11105529,"change_date":"2024-11-04 21:40:00","inspection_id":"83069044","insp_violation_id":"262704473","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922SLLLR"},{"id":11105530,"change_date":"2024-11-04 21:40:00","inspection_id":"83069044","insp_violation_id":"262704474","seq_no":"2","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":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":11469610,"change_date":"2024-11-04 21:40:00","inspection_id":"83069044","insp_unit_id":"203715863","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE015","insp_unit_license":"R734000","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR3HN722372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:48.000000Z","updated_at":"2025-03-17T23:41:48.000000Z"},{"id":11469611,"change_date":"2024-11-04 21:40:00","inspection_id":"83069044","insp_unit_id":"203715864","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"1819","insp_unit_license":"AX7412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1DW1A532X8S071731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:48.000000Z","updated_at":"2025-03-17T23:41:48.000000Z"}]},{"id":6869874,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","dot_number":"4053531","report_state":"TN","report_number":"I034BP0448","insp_date":"2024-09-30 00:00:00","insp_start_time":"1029","insp_end_time":"1120","registration_date":null,"region":"CD","ci_status_code":"C","location":"HAYWDW","location_desc":"STANTON TN","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PDC","shipping_paper_number":"2002557320","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-10-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"6","oos_total":"3","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"905233","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-10-02 21:40:00","snet_input_date":"2024-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-02 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:25.000000Z","updated_at":"2025-03-17T20:39:25.000000Z","inspection_violations":[{"id":10701413,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142317","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203229053","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"3965B"},{"id":10701414,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142318","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39111B4"},{"id":10701415,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142319","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"203229053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39347A"},{"id":10701416,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142320","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203229053","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39347E"},{"id":10701417,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142321","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203229053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39353B"},{"id":10701418,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_violation_id":"262142322","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203229053","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11079120,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_unit_id":"203229053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE015","insp_unit_license":"R734000","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR3HN722372","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:43.000000Z","updated_at":"2025-03-17T23:37:43.000000Z"},{"id":11079121,"change_date":"2024-10-02 21:40:00","inspection_id":"82812439","insp_unit_id":"203229054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"135492","insp_unit_license":"CW6453","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2536GP697949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:43.000000Z","updated_at":"2025-03-17T23:37:43.000000Z"}]},{"id":6851647,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","dot_number":"4053531","report_state":"OK","report_number":"PE21001008","insp_date":"2024-09-29 00:00:00","insp_start_time":"1200","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"43035","location_desc":"LOVE COUNTY POE","county_code_state":"OK","county_code":"085","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SUNSET","shipping_paper_number":"SO01182161","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-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"762888","transaction_code":"A","transaction_date":"2024-09-29 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-29 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[{"id":10672407,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_violation_id":"262102042","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203192041","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"OCCC","created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"},{"id":10672408,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_violation_id":"262102043","seq_no":"2","part_no":"390","part_no_section":"403(a)","insp_viol_unit":"1","insp_unit_id":"203192041","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"390403A"},{"id":10672409,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_violation_id":"262102044","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203192041","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"39617C"},{"id":10672410,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_violation_id":"262102045","seq_no":"4","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":"OCCC","created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11049250,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_unit_id":"203192041","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE2016","insp_unit_license":"R658407","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD68FSGD2019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:24.000000Z","updated_at":"2025-03-17T23:37:24.000000Z"},{"id":11049251,"change_date":"2024-09-30 21:41:00","inspection_id":"82793107","insp_unit_id":"203192042","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1382","insp_unit_license":"5152331","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B0PL317803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:24.000000Z","updated_at":"2025-03-17T23:37:24.000000Z"}]},{"id":6595833,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","dot_number":"4053531","report_state":"LA","report_number":"LALN007960","insp_date":"2024-08-28 00:00:00","insp_start_time":"1136","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"013","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1217266","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045-8115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[{"id":10257451,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_violation_id":"261493019","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3958E1"},{"id":10257452,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_violation_id":"261493020","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202652844","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"3939A"},{"id":10257453,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_violation_id":"261493021","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202652844","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"39375A3"},{"id":10257454,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_violation_id":"261493022","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202652845","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:37.000000Z","updated_at":"2025-03-17T21:55:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10633529,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_unit_id":"202652844","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"003","insp_unit_license":"R743000","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLDR0HSHV0986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"},{"id":10633530,"change_date":"2024-08-29 21:42:00","inspection_id":"82520831","insp_unit_id":"202652845","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"135492","insp_unit_license":"CW6453","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2536GP697949","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6573839,"change_date":"2024-08-27 21:42:00","inspection_id":"82497244","dot_number":"4053531","report_state":"NC","report_number":"0006679198","insp_date":"2024-08-22 00:00:00","insp_start_time":"1520","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"OLDCASTLE APG","shipping_paper_number":"36796139","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2212509","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045-8115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:12.000000Z","updated_at":"2025-03-17T20:33:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10597978,"change_date":"2024-08-27 21:42:00","inspection_id":"82497244","insp_unit_id":"202606347","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AE027","insp_unit_license":"R717318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSNR9GN058683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"},{"id":10597979,"change_date":"2024-08-27 21:42:00","inspection_id":"82497244","insp_unit_id":"202606348","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"53197","insp_unit_license":"CW6252","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA0627KJ128197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:47.000000Z","updated_at":"2025-03-17T23:32:47.000000Z"}]},{"id":6516790,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","dot_number":"4053531","report_state":"PA","report_number":"L209423239","insp_date":"2024-08-19 00:00:00","insp_start_time":"1651","insp_end_time":"1830","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"6.0 I78 E","county_code_state":"PA","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BAY VALLEY FOODS LLC","shipping_paper_number":"178930350","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-08-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"13","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2462490","transaction_code":"A","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-08-20 21:43:00","snet_input_date":"2024-08-19 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-08-20 21:43:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"153655","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10121668,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299060","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202491193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3922"},{"id":10121669,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299061","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA0871964-2","created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3922"},{"id":10121670,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299062","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39378"},{"id":10121671,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299063","seq_no":"4","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39355B"},{"id":10121672,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299064","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39617C"},{"id":10121673,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299065","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3939A"},{"id":10121674,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299066","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39345D"},{"id":10121675,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299067","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39347E"},{"id":10121676,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299068","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202491193","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39617C"},{"id":10121677,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299069","seq_no":"10","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"2","insp_unit_id":"202491193","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"387303B4"},{"id":10121678,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299070","seq_no":"11","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"202491193","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"393207F"},{"id":10121679,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299071","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3963A1"},{"id":10121680,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_violation_id":"261299072","seq_no":"13","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202491192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":10505458,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_unit_id":"202491192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"AE019","insp_unit_license":"R717058","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X1GD263930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"},{"id":10505459,"change_date":"2024-08-20 21:43:00","inspection_id":"82436544","insp_unit_id":"202491193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"214003","insp_unit_license":"CW6452","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA0627EB705034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"}]},{"id":6454766,"change_date":"2024-08-13 21:42:00","inspection_id":"82370408","dot_number":"4053531","report_state":"NJ","report_number":"SPRWI00546","insp_date":"2024-08-12 00:00:00","insp_start_time":"2112","insp_end_time":"2129","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GREENWICH SCALES EASTBOUND","county_code_state":"NJ","county_code":"041","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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-13 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":"1228949","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-08-13 21:42:00","snet_input_date":"2024-08-12 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-08-13 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:43.000000Z","updated_at":"2025-03-17T20:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10403896,"change_date":"2024-08-13 21:42:00","inspection_id":"82370408","insp_unit_id":"202365445","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R72559","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK07LX10437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"},{"id":10403897,"change_date":"2024-08-13 21:42:00","inspection_id":"82370408","insp_unit_id":"202365446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"244B070","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A5325BS236835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:48.000000Z","updated_at":"2025-03-17T23:30:48.000000Z"}]},{"id":6437732,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","dot_number":"4053531","report_state":"IN","report_number":"8283008387","insp_date":"2024-08-09 00:00:00","insp_start_time":"1323","insp_end_time":"1457","registration_date":null,"region":"ED","ci_status_code":"C","location":"5370E","location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DIAMOND PET FOODS","shipping_paper_number":"300643","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-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"735159","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:20.000000Z","updated_at":"2025-03-17T20:30:20.000000Z","inspection_violations":[{"id":9997595,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124786","seq_no":"3","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"393207A"},{"id":9997596,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124787","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39345B2"},{"id":9997597,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124788","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39617C"},{"id":9997598,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124789","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202331166","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39617C"},{"id":9997599,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124790","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000195580890","created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"},{"id":9997600,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124791","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3939A"},{"id":9997601,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_violation_id":"261124792","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202331165","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10375731,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_unit_id":"202331165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"AE017","insp_unit_license":"R725599","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK07LX10437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:33.000000Z","updated_at":"2025-03-17T23:30:33.000000Z"},{"id":10375732,"change_date":"2024-08-12 21:42:00","inspection_id":"82352180","insp_unit_id":"202331166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"5311035","insp_unit_license":"244B070","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A5325BS236835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:33.000000Z","updated_at":"2025-03-17T23:30:33.000000Z"}]},{"id":6271703,"change_date":"2024-07-23 21:42:00","inspection_id":"82174687","dot_number":"4053531","report_state":"AL","report_number":"E125000144","insp_date":"2024-07-21 00:00:00","insp_start_time":"1625","insp_end_time":"1721","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I459S-MM10","county_code_state":"AL","county_code":"073","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SONOCO PRODUCTS COMPANY","shipping_paper_number":"B35890620","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-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1014869","transaction_code":"C","transaction_date":"2024-07-21 00:00:00","upload_date":"2024-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-07-22 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-07-22 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"153655","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:01.000000Z","updated_at":"2025-03-17T20:27:01.000000Z","inspection_violations":[{"id":9742745,"change_date":"2024-07-23 21:42:00","inspection_id":"82174687","insp_violation_id":"260791675","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202020523","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"39378"},{"id":9742746,"change_date":"2024-07-23 21:42:00","inspection_id":"82174687","insp_violation_id":"260791676","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:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10104874,"change_date":"2024-07-23 21:42:00","inspection_id":"82174687","insp_unit_id":"202020523","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE022","insp_unit_license":"R734125","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK66LX03075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:41.000000Z","updated_at":"2025-03-17T23:27:41.000000Z"},{"id":10104875,"change_date":"2024-07-23 21:42:00","inspection_id":"82174687","insp_unit_id":"202020524","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"5311025","insp_unit_license":"244B070","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DW1A5325BS236835","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:41.000000Z","updated_at":"2025-03-17T23:27:41.000000Z"}]},{"id":6303232,"change_date":"2024-07-25 21:42:00","inspection_id":"82208269","dot_number":"4053531","report_state":"TN","report_number":"I3A0831008","insp_date":"2024-07-19 00:00:00","insp_start_time":"0838","insp_end_time":"0910","registration_date":null,"region":"ED","ci_status_code":"C","location":"GRENS","location_desc":"MOHAWK TN","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"ECOPAX","shipping_paper_number":"42650","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-07-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"683887","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-07-25 21:42:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-25 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:49.000000Z","updated_at":"2025-03-17T20:27:49.000000Z","inspection_violations":[{"id":9788115,"change_date":"2024-07-25 21:42:00","inspection_id":"82208269","insp_violation_id":"260828306","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202057253","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"39375A3"},{"id":9788116,"change_date":"2024-07-25 21:42:00","inspection_id":"82208269","insp_violation_id":"260828307","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:21.000000Z","updated_at":"2025-03-17T21:53:21.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10156257,"change_date":"2024-07-25 21:42:00","inspection_id":"82208269","insp_unit_id":"202057252","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"AE012","insp_unit_license":"R658350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD55GLGU2497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"},{"id":10156258,"change_date":"2024-07-25 21:42:00","inspection_id":"82208269","insp_unit_id":"202057253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"CX3188","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"5V8VA53257M700156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"}]},{"id":6134430,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","dot_number":"4053531","report_state":"TX","report_number":"V241465773","insp_date":"2024-07-01 00:00:00","insp_start_time":"0814","insp_end_time":"0933","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A102","location_desc":"IH10 WB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NITTO INC","shipping_paper_number":"SID876433","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9316663","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-07-02 21:42:00","snet_input_date":"2024-07-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-02 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:24:14.000000Z","updated_at":"2025-03-17T20:24:14.000000Z","inspection_violations":[{"id":9523968,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447003","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201711555","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"39378"},{"id":9523969,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447004","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201711556","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"39617C"},{"id":9523970,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447005","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201711555","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"3963A1"},{"id":9523971,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447006","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201711555","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"3963A1"},{"id":9523972,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447007","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201711555","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"3963A1"},{"id":9523973,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_violation_id":"260447008","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201711555","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:06.000000Z","updated_at":"2025-03-17T21:52:06.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":9881218,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_unit_id":"201711555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE012","insp_unit_license":"R658350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD55GLGU2497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:25.000000Z","updated_at":"2025-03-17T23:25:25.000000Z"},{"id":9881219,"change_date":"2024-07-02 21:42:00","inspection_id":"82027214","insp_unit_id":"201711556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"229130","insp_unit_license":"BX3336","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D0FL845972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:25.000000Z","updated_at":"2025-03-17T23:25:25.000000Z"}]},{"id":6169063,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","dot_number":"4053531","report_state":"TX","report_number":"V241472858","insp_date":"2024-07-01 00:00:00","insp_start_time":"1740","insp_end_time":"1820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH35 SB 503","county_code_state":"TX","county_code":"097","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"OKC","shipping_paper_number":"36342297","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9318140","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-07-08 21:43:00","snet_input_date":"2024-07-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:25:00.000000Z","updated_at":"2025-03-17T20:25:00.000000Z","inspection_violations":[{"id":9578439,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_violation_id":"260521432","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"201780357","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"393205C"},{"id":9578440,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_violation_id":"260521433","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201780358","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39345B2"},{"id":9578441,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_violation_id":"260521434","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"201780357","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39345D"},{"id":9578442,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_violation_id":"260521435","seq_no":"4","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"201780357","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39381"},{"id":9578443,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_violation_id":"260521436","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"201780357","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:20.000000Z","updated_at":"2025-03-17T21:52:20.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":9937872,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_unit_id":"201780357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"AE028","insp_unit_license":"R725520","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJSNR3JN538757","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"},{"id":9937873,"change_date":"2024-07-08 21:43:00","inspection_id":"82064440","insp_unit_id":"201780358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"214003","insp_unit_license":"CW6452","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA0627EB705034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:59.000000Z","updated_at":"2025-03-17T23:25:59.000000Z"}]},{"id":6063190,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","dot_number":"4053531","report_state":"TX","report_number":"V241451222","insp_date":"2024-06-18 00:00:00","insp_start_time":"0730","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LOGYTRADE","shipping_paper_number":"80751920","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"12","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9305558","transaction_code":"A","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-06-24 21:42:00","snet_input_date":"2024-06-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:22:57.000000Z","updated_at":"2025-03-17T20:22:57.000000Z","inspection_violations":[{"id":9407447,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277265","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"201562489","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39311"},{"id":9407448,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277266","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201562488","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39311"},{"id":9407449,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277267","seq_no":"3","part_no":"393","part_no_section":"28","insp_viol_unit":"2","insp_unit_id":"201562489","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39328"},{"id":9407450,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277268","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201562489","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39345B2"},{"id":9407451,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277269","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201562488","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39378"},{"id":9407452,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277270","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201562488","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"3939A"},{"id":9407453,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277271","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201562488","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"3939A"},{"id":9407454,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277272","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201562489","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"3939A"},{"id":9407455,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277273","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201562489","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"3939A"},{"id":9407456,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277274","seq_no":"10","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:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39522G"},{"id":9407457,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277275","seq_no":"11","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:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39522H4"},{"id":9407458,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_violation_id":"260277276","seq_no":"12","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201562488","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:32.000000Z","updated_at":"2025-03-17T21:51:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9765710,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_unit_id":"201562488","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AE016","insp_unit_license":"R734001","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR7HN674598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:10.000000Z","updated_at":"2025-03-17T23:24:10.000000Z"},{"id":9765711,"change_date":"2024-06-24 21:42:00","inspection_id":"81950699","insp_unit_id":"201562489","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"040","insp_unit_license":"BY9339","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D1CL653035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:10.000000Z","updated_at":"2025-03-17T23:24:10.000000Z"}]},{"id":5949701,"change_date":"2024-06-10 21:43:00","inspection_id":"81827823","dot_number":"4053531","report_state":"NC","report_number":"0006655811","insp_date":"2024-06-08 00:00:00","insp_start_time":"0740","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"US29 S","location_desc":"US29 SB NEAR NC150","county_code_state":"NC","county_code":"081","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ABBOTT NUTRITION","shipping_paper_number":"007007401005832","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-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2189381","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-06-10 21:43:00","snet_input_date":"2024-06-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045-8115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:40.000000Z","updated_at":"2025-03-17T20:20:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9583115,"change_date":"2024-06-10 21:43:00","inspection_id":"81827823","insp_unit_id":"201309156","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE012","insp_unit_license":"R658350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD55GLGU2497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:22.000000Z","updated_at":"2025-03-17T23:22:22.000000Z"},{"id":9583116,"change_date":"2024-06-10 21:43:00","inspection_id":"81827823","insp_unit_id":"201309157","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIT","insp_unit_company":null,"insp_unit_license":"AZ2596","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2537GG770536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:22.000000Z","updated_at":"2025-03-17T23:22:22.000000Z"}]},{"id":5948992,"change_date":"2024-06-10 21:43:00","inspection_id":"81827072","dot_number":"4053531","report_state":"NC","report_number":"0006654979","insp_date":"2024-06-05 00:00:00","insp_start_time":"1343","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"2189196","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-06-10 21:43:00","snet_input_date":"2024-06-07 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045-8115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:40.000000Z","updated_at":"2025-03-17T20:20:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9582050,"change_date":"2024-06-10 21:43:00","inspection_id":"81827072","insp_unit_id":"201307968","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE2019","insp_unit_license":"R658407","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD68FSGD2019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:22.000000Z","updated_at":"2025-03-17T23:22:22.000000Z"},{"id":9582051,"change_date":"2024-06-10 21:43:00","inspection_id":"81827072","insp_unit_id":"201307969","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"117029","insp_unit_license":"156B207","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C74T097290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:22.000000Z","updated_at":"2025-03-17T23:22:22.000000Z"}]},{"id":5919388,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","dot_number":"4053531","report_state":"SC","report_number":"K387000086","insp_date":"2024-06-04 00:00:00","insp_start_time":"2056","insp_end_time":"2320","registration_date":"2024-08-05 00:00:00","region":"ET","ci_status_code":"C","location":"002","location_desc":"I-85 NB ANDERSON COUNTY","county_code_state":"SC","county_code":"007","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"FLEX DIST.","shipping_paper_number":"7605585","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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"11","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147502","transaction_code":"C","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-06-05 21:42:00","snet_input_date":"2024-06-04 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-06-05 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[{"id":9178826,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010448","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":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3922"},{"id":9178827,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010449","seq_no":"2","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39355D3"},{"id":9178828,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010450","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20242421006033","created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39617C"},{"id":9178829,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010451","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39395A"},{"id":9178830,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010452","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39378"},{"id":9178831,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010453","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9178832,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010454","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202234120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3963A1"},{"id":9178833,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010455","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202234121","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39617C"},{"id":9178834,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010456","seq_no":"9","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"202234121","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39345"},{"id":9178835,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010457","seq_no":"10","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"202234121","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39345"},{"id":9178836,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_violation_id":"261010458","seq_no":"11","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"202234121","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":9534117,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_unit_id":"202234120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE025","insp_unit_license":"R72551","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"24030144513084248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"},{"id":9534118,"change_date":"2024-08-05 21:42:00","inspection_id":"81794881","insp_unit_id":"202234121","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"214003","insp_unit_license":"CW6452","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA0627EB705034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"}]},{"id":5944520,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","dot_number":"4053531","report_state":"GA","report_number":"0098000362","insp_date":"2024-06-04 00:00:00","insp_start_time":"0916","insp_end_time":"0941","registration_date":null,"region":"ED","ci_status_code":"C","location":"267","location_desc":"RINGGOLD GA","county_code_state":"GA","county_code":"047","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"YS PRECISION STAMPING INC.","shipping_paper_number":"CO2024060302","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-06-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"553858","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-06-10 21:42:00","snet_input_date":"2024-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-10 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:38.000000Z","updated_at":"2025-03-17T20:20:38.000000Z","inspection_violations":[{"id":9223107,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_violation_id":"259981173","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201298590","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:37.000000Z","updated_at":"2025-03-17T21:50:37.000000Z","normalized_code":"3939A"},{"id":9223108,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_violation_id":"259981174","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201298590","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:37.000000Z","updated_at":"2025-03-17T21:50:37.000000Z","normalized_code":"39617C"},{"id":9223109,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_violation_id":"259981175","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201298591","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:37.000000Z","updated_at":"2025-03-17T21:50:37.000000Z","normalized_code":"39617C"},{"id":9223110,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_violation_id":"259981176","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"201298591","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:37.000000Z","updated_at":"2025-03-17T21:50:37.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":9575057,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_unit_id":"201298590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE016","insp_unit_license":"R734001","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR7HN674598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:19.000000Z","updated_at":"2025-03-17T23:22:19.000000Z"},{"id":9575058,"change_date":"2024-06-10 21:42:00","inspection_id":"81822122","insp_unit_id":"201298591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFKIN TRA","insp_unit_company":"53102","insp_unit_license":"BX4054","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1L01A532361159322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:19.000000Z","updated_at":"2025-03-17T23:22:19.000000Z"}]},{"id":5910627,"change_date":"2024-06-04 21:42:00","inspection_id":"81785302","dot_number":"4053531","report_state":"IL","report_number":"4248070043","insp_date":"2024-05-27 00:00:00","insp_start_time":"1945","insp_end_time":"2017","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"U.S. 34 AT FREEMONT STREET","county_code_state":"IL","county_code":"095","insp_level_id":"3","service_center":"MW","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":"2024-06-04 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":"2328970","transaction_code":"A","transaction_date":"2024-05-27 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-06-04 21:42:00","snet_input_date":"2024-05-27 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-06-04 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"153655","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:50.000000Z","updated_at":"2025-03-17T20:19:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9520027,"change_date":"2024-06-04 21:42:00","inspection_id":"81785302","insp_unit_id":"201228517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9050","insp_unit_license":"R717061","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLBG9GSHT9050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:46.000000Z","updated_at":"2025-03-17T23:21:46.000000Z"},{"id":9520028,"change_date":"2024-06-04 21:42:00","inspection_id":"81785302","insp_unit_id":"201228518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"1056","insp_unit_license":"146B067","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"527SR5327LM019367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:46.000000Z","updated_at":"2025-03-17T23:21:46.000000Z"}]},{"id":5826467,"change_date":"2024-05-23 21:41:00","inspection_id":"81694130","dot_number":"4053531","report_state":"NJ","report_number":"SPBOI01621","insp_date":"2024-05-22 00:00:00","insp_start_time":"0945","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH SCALE","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","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-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1214407","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:15.000000Z","updated_at":"2025-03-17T20:18:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9383572,"change_date":"2024-05-23 21:41:00","inspection_id":"81694130","insp_unit_id":"201051951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE012","insp_unit_license":"R658350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD55GLGU2497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:24.000000Z","updated_at":"2025-03-17T23:20:24.000000Z"},{"id":9383573,"change_date":"2024-05-23 21:41:00","inspection_id":"81694130","insp_unit_id":"201051952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"156B207","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3H3V532C74T097290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:24.000000Z","updated_at":"2025-03-17T23:20:24.000000Z"}]},{"id":5723943,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","dot_number":"4053531","report_state":"TN","report_number":"I033AG0474","insp_date":"2024-05-06 00:00:00","insp_start_time":"1157","insp_end_time":"1226","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"COOPERSTANDARD","shipping_paper_number":"1374668","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-05-12 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"472635","transaction_code":"A","transaction_date":"2024-05-12 00:00:00","upload_date":"2024-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-05-12 21:32:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-12 21:32:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:16.000000Z","updated_at":"2025-03-17T20:16:16.000000Z","inspection_violations":[{"id":8857336,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","insp_violation_id":"259447377","seq_no":"1","part_no":"393","part_no_section":"11(b)","insp_viol_unit":"2","insp_unit_id":"200843025","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"39311B"},{"id":8857337,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","insp_violation_id":"259447378","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200843024","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"3939A"},{"id":8857338,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","insp_violation_id":"259447379","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"200843024","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:50.000000Z","updated_at":"2025-03-17T21:48:50.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":9219468,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","insp_unit_id":"200843024","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"R636404","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD53GSHC0145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:47.000000Z","updated_at":"2025-03-17T23:18:47.000000Z"},{"id":9219469,"change_date":"2024-05-12 21:32:00","inspection_id":"81582811","insp_unit_id":"200843025","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"BY9339","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1JJV532D1CL653035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:47.000000Z","updated_at":"2025-03-17T23:18:47.000000Z"}]},{"id":5694244,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","dot_number":"4053531","report_state":"TN","report_number":"I01R100351","insp_date":"2024-05-02 00:00:00","insp_start_time":"1740","insp_end_time":"1905","registration_date":null,"region":"CT","ci_status_code":"C","location":"UNK","location_desc":"HAYWOOD COUNTY","county_code_state":"TN","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"16424890001","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-05-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115200","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1734170","transaction_code":"C","transaction_date":"2024-05-10 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-05-08 21:41:00","snet_input_date":"2024-05-02 00:00:00","source_office":"2TNS001","mcmis_add_date":"2024-05-08 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:30.000000Z","updated_at":"2025-05-11T10:10:42.000000Z","inspection_violations":[{"id":13579009,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","insp_violation_id":"266062075","seq_no":"1","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":"N","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-05-09T11:06:40.000000Z","updated_at":"2025-05-10T11:16:52.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":13579010,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","insp_violation_id":"266062076","seq_no":"2","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:06:40.000000Z","updated_at":"2025-05-10T11:16:52.000000Z","normalized_code":"39111B2Q"},{"id":13579011,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","insp_violation_id":"266062077","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206689237","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-09T11:06:40.000000Z","updated_at":"2025-05-10T11:16:52.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":13932840,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","insp_unit_id":"206689237","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"024","insp_unit_license":"R717327","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3HSDZAPR9LN143873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:10:54.000000Z","updated_at":"2025-05-11T02:46:06.000000Z"},{"id":13932841,"change_date":"2025-05-07 21:43:00","inspection_id":"81550563","insp_unit_id":"206689238","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"9325237","insp_unit_license":"244B227","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3H3V532C7HT701099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:10:54.000000Z","updated_at":"2025-05-11T02:46:06.000000Z"}]},{"id":5632183,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","dot_number":"4053531","report_state":"OK","report_number":"PB10153905","insp_date":"2024-04-30 00:00:00","insp_start_time":"1315","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"43035","location_desc":"BRYAN COUNTY POE","county_code_state":"OK","county_code":"013","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"FE EXPRESS LLC","shipping_paper_number":"C2368100","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-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"745460","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-04-30 21:41:00","snet_input_date":"2024-04-30 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-04-30 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8707904,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222815","seq_no":"2","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:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3958"},{"id":8707905,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222816","seq_no":"3","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39524D"},{"id":8707906,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222817","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200649061","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39395A"},{"id":8707907,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222818","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200649061","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3939A"},{"id":8707908,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222819","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200649061","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3939A"},{"id":8707909,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222820","seq_no":"7","part_no":"396","part_no_section":"5(a)","insp_viol_unit":"1","insp_unit_id":"200649061","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3965A"},{"id":8707910,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222821","seq_no":"8","part_no":"393","part_no_section":"83(e)","insp_viol_unit":"1","insp_unit_id":"200649061","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39383E"},{"id":8707911,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222822","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200649062","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3939A"},{"id":8707912,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222823","seq_no":"10","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200649062","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"39355E"},{"id":8707913,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_violation_id":"259222824","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:08.000000Z","updated_at":"2025-03-17T21:48:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9072167,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_unit_id":"200649061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"AE010","insp_unit_license":"R704579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X1HJ133800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"},{"id":9072168,"change_date":"2024-04-30 21:41:00","inspection_id":"81483112","insp_unit_id":"200649062","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5378","insp_unit_license":"96LA8E","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"1JJV532W48L121822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"}]},{"id":5652338,"change_date":"2024-05-02 21:42:00","inspection_id":"81504963","dot_number":"4053531","report_state":"AR","report_number":"5280000033","insp_date":"2024-04-30 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"CD","ci_status_code":"C","location":"403","location_desc":"HOPE EAST WEIGH STATION","county_code_state":"AR","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"DANA","shipping_paper_number":"C2368462","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":"2024-05-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126957","viol_total":"1","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":"449025","transaction_code":"A","transaction_date":"2024-05-02 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-05-02 21:42:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-02 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:43.000000Z","updated_at":"2025-03-17T20:14:43.000000Z","inspection_violations":[{"id":8742626,"change_date":"2024-05-02 21:42:00","inspection_id":"81504963","insp_violation_id":"259272508","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":null,"created_at":"2025-03-17T21:48:19.000000Z","updated_at":"2025-03-17T21:48:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9104189,"change_date":"2024-05-02 21:42:00","inspection_id":"81504963","insp_unit_id":"200690303","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"AF012","insp_unit_license":"R658350","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLD55GLGU2497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:42.000000Z","updated_at":"2025-03-17T23:17:42.000000Z"},{"id":9104190,"change_date":"2024-05-02 21:42:00","inspection_id":"81504963","insp_unit_id":"200690304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ATRO REMOL","insp_unit_company":"101","insp_unit_license":"BQ9609","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3ELA6RX20NG002813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:42.000000Z","updated_at":"2025-03-17T23:17:42.000000Z"}]},{"id":5609209,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","dot_number":"4053531","report_state":"TX","report_number":"V241388323","insp_date":"2024-04-25 00:00:00","insp_start_time":"0815","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"S & K MFG","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","viol_total":"11","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9258928","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-04-26 21:40:00","snet_input_date":"2024-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-26 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:13:53.000000Z","updated_at":"2025-03-17T20:13:53.000000Z","inspection_violations":[{"id":8672821,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171883","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39311"},{"id":8672822,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171884","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"2","insp_unit_id":"200601786","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39345"},{"id":8672823,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171885","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39345"},{"id":8672824,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171886","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"200601786","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39345B2"},{"id":8672825,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171887","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"200601786","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39375A3"},{"id":8672826,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171888","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39378"},{"id":8672827,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171889","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"3939A"},{"id":8672828,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171890","seq_no":"9","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39395A"},{"id":8672829,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171891","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"3963A1"},{"id":8672830,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171892","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"3963A1"},{"id":8672831,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_violation_id":"259171893","seq_no":"7","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"200601785","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:59.000000Z","updated_at":"2025-03-17T21:47:59.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":9035393,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_unit_id":"200601785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"025","insp_unit_license":"R725519","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUGGLBG2GLGY8979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:05.000000Z","updated_at":"2025-03-17T23:17:05.000000Z"},{"id":9035394,"change_date":"2024-04-26 21:40:00","inspection_id":"81458080","insp_unit_id":"200601786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"1819","insp_unit_license":"AX7412","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1DW1A532X8S071731","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:05.000000Z","updated_at":"2025-03-17T23:17:05.000000Z"}]},{"id":5493190,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","dot_number":"4053531","report_state":"TX","report_number":"V241386318","insp_date":"2024-04-07 00:00:00","insp_start_time":"1350","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-35 MILE MARKER 59","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VECTRALIS","shipping_paper_number":"H2J0050577","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9246209","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:11:33.000000Z","updated_at":"2025-03-17T20:11:33.000000Z","inspection_violations":[{"id":8485732,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","insp_violation_id":"258890698","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200360899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8485733,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","insp_violation_id":"258890699","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200360899","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"},{"id":8485734,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","insp_violation_id":"258890700","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200360900","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8848665,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","insp_unit_id":"200360899","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"AE006","insp_unit_license":"R586377","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X8EJ407683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"},{"id":8848666,"change_date":"2024-04-11 21:41:00","inspection_id":"81331715","insp_unit_id":"200360900","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"27722","insp_unit_license":"AX7247","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAP0625DJ639554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5448651,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","dot_number":"4053531","report_state":"TX","report_number":"6U389DNA22","insp_date":"2024-04-03 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  KATY FT BEND R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9240541","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[{"id":8410276,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","insp_violation_id":"258777722","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200265288","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39395A"},{"id":8410277,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","insp_violation_id":"258777723","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200265288","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39395F"},{"id":8410278,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","insp_violation_id":"258777724","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200265288","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"39617C"},{"id":8410279,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","insp_violation_id":"258777725","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200265288","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:42.000000Z","updated_at":"2025-03-17T21:46:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8776446,"change_date":"2024-04-05 21:40:00","inspection_id":"81282719","insp_unit_id":"200265288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE003","insp_unit_license":"87V376V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09LAE1524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":5229687,"change_date":"2024-03-21 21:40:00","inspection_id":"81043637","dot_number":"4053531","report_state":"VA","report_number":"8028000163","insp_date":"2024-03-06 00:00:00","insp_start_time":"0935","insp_end_time":"0959","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ROANOKE VA","county_code_state":"VA","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SYLVAMO NORTH AMERICA LLC","shipping_paper_number":"036863700034728","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","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":"298557","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2024-03-07 21:38:00","snet_input_date":"2024-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-07 21:38:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:13.000000Z","updated_at":"2025-03-17T20:06:13.000000Z","inspection_violations":[{"id":8063323,"change_date":"2024-03-21 21:40:00","inspection_id":"81043637","insp_violation_id":"258503269","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:59.000000Z","updated_at":"2025-03-17T21:44:59.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":8421307,"change_date":"2024-03-21 21:40:00","inspection_id":"81043637","insp_unit_id":"200015643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"54062","insp_unit_license":"BX4491","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2538DP614811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"},{"id":8421308,"change_date":"2024-03-21 21:40:00","inspection_id":"81043637","insp_unit_id":"200015644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE014","insp_unit_license":"R704631","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR3KN128784","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:19.000000Z","updated_at":"2025-03-17T23:11:19.000000Z"}]},{"id":5125630,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","dot_number":"4053531","report_state":"TX","report_number":"V241328314","insp_date":"2024-02-17 00:00:00","insp_start_time":"1356","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:28  19'27.05\"N L","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ANDRADE EXPEDITED","shipping_paper_number":"TTX1323249","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9206204","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-02-23 21:41:00","snet_input_date":"2024-02-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-23 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:04:11.000000Z","updated_at":"2025-03-17T20:04:11.000000Z","inspection_violations":[{"id":7904046,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","insp_violation_id":"258015612","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"38323A2"},{"id":7904047,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","insp_violation_id":"258015613","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199580043","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"39311"},{"id":7904048,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","insp_violation_id":"258015614","seq_no":"3","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:44:12.000000Z","updated_at":"2025-03-17T21:44:12.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":8252253,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","insp_unit_id":"199580043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE9050","insp_unit_license":"R717061","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLBG9GSHT9050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:47.000000Z","updated_at":"2025-03-17T23:09:47.000000Z"},{"id":8252254,"change_date":"2024-02-23 21:41:00","inspection_id":"80930637","insp_unit_id":"199580044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"BB11","insp_unit_license":"AZ2596","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2537GG770536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:47.000000Z","updated_at":"2025-03-17T23:09:47.000000Z"}]},{"id":4999883,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","dot_number":"4053531","report_state":"TX","report_number":"V241321574","insp_date":"2024-02-06 00:00:00","insp_start_time":"1035","insp_end_time":"1129","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 NORTH BOUND RE","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MACROHUB LAREDO","shipping_paper_number":"19572","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9191208","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2024-02-07 21:41:00","snet_input_date":"2024-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"9807 MINES RD SUITE 21","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T20:01:41.000000Z","updated_at":"2025-03-17T20:01:41.000000Z","inspection_violations":[{"id":7702658,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719253","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199316794","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39311"},{"id":7702659,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719254","seq_no":"2","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"199316794","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39375A2"},{"id":7702660,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719255","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199316794","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39375A3"},{"id":7702661,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719256","seq_no":"5","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"199316793","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39395B"},{"id":7702662,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719257","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199316793","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"3963A1"},{"id":7702663,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_violation_id":"257719258","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199316793","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:14.000000Z","updated_at":"2025-03-17T21:43:14.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":8047586,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_unit_id":"199316793","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"009","insp_unit_license":"R704561","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X9GJ485702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"},{"id":8047587,"change_date":"2024-02-07 21:41:00","inspection_id":"80793269","insp_unit_id":"199316794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"27722","insp_unit_license":"AX7247","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAP0625DJ639554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:56.000000Z","updated_at":"2025-03-17T23:07:56.000000Z"}]},{"id":4734974,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","dot_number":"4053531","report_state":"TX","report_number":"V231262897","insp_date":"2023-12-26 00:00:00","insp_start_time":"1120","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 SB MP 101","county_code_state":"TX","county_code":"163","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ANDRADE EXPEDITED","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9161778","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2023-12-29 21:40:00","snet_input_date":"2023-12-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-29 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045-8115","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T19:56:34.000000Z","updated_at":"2025-03-17T19:56:34.000000Z","inspection_violations":[{"id":7311482,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","insp_violation_id":"263342231","seq_no":"1","part_no":"393","part_no_section":"75A","insp_viol_unit":"2","insp_unit_id":"204278878","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"39375A"},{"id":7311483,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","insp_violation_id":"263342232","seq_no":"2","part_no":"395","part_no_section":"22H1","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:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"39522H1"},{"id":7311484,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","insp_violation_id":"263342233","seq_no":"3","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":"2025-03-17T21:41:18.000000Z","updated_at":"2025-03-17T21:41:18.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":7616319,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","insp_unit_id":"204278877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AE007","insp_unit_license":"R659733","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR4FN696667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"},{"id":7616320,"change_date":"2024-12-09 21:42:00","inspection_id":"80503434","insp_unit_id":"204278878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"53197","insp_unit_license":"CW6252","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA0627KJ128197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:06.000000Z","updated_at":"2025-03-17T23:04:06.000000Z"}]},{"id":4575905,"change_date":"2023-12-07 21:40:00","inspection_id":"80329317","dot_number":"4053531","report_state":"MO","report_number":"W114001066","insp_date":"2023-12-07 00:00:00","insp_start_time":"1007","insp_end_time":"1043","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"STEELE MO","county_code_state":"MO","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAYMA GROUP","shipping_paper_number":"45224","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":"2023-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"121945","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2023-12-07 21:40:00","snet_input_date":"2023-12-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-07 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:26.000000Z","updated_at":"2025-03-17T19:53:26.000000Z","inspection_violations":[{"id":7078172,"change_date":"2023-12-07 21:40:00","inspection_id":"80329317","insp_violation_id":"256759392","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"198388690","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:10.000000Z","updated_at":"2025-03-17T21:40:10.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":7359734,"change_date":"2023-12-07 21:40:00","inspection_id":"80329317","insp_unit_id":"198388690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE017","insp_unit_license":"R704555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZTZR3KN649352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:50.000000Z","updated_at":"2025-03-17T23:01:50.000000Z"},{"id":7359735,"change_date":"2023-12-07 21:40:00","inspection_id":"80329317","insp_unit_id":"198388691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"BB11","insp_unit_license":"AZ2596","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2537GG770536","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:50.000000Z","updated_at":"2025-03-17T23:01:50.000000Z"}]},{"id":4518380,"change_date":"2023-11-29 21:42:00","inspection_id":"80266018","dot_number":"4053531","report_state":"NC","report_number":"0006599301","insp_date":"2023-11-29 00:00:00","insp_start_time":"0729","insp_end_time":"0817","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION, I-95,","county_code_state":"NC","county_code":"155","insp_level_id":"2","service_center":"SH","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":"2023-11-29 21:42: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":"2132537","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2023-11-29 21:42:00","snet_input_date":"2023-11-29 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-11-29 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:15.000000Z","updated_at":"2025-03-17T19:52:15.000000Z","inspection_violations":[{"id":6990967,"change_date":"2023-11-29 21:42:00","inspection_id":"80266018","insp_violation_id":"256617209","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3231408","created_at":"2025-03-17T21:39:43.000000Z","updated_at":"2025-03-17T21:39:43.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":7266620,"change_date":"2023-11-29 21:42:00","inspection_id":"80266018","insp_unit_id":"198263725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R664137","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09LAE1524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:02.000000Z","updated_at":"2025-03-17T23:01:02.000000Z"},{"id":7266621,"change_date":"2023-11-29 21:42:00","inspection_id":"80266018","insp_unit_id":"198263726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"BX4491","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2538DP614811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:02.000000Z","updated_at":"2025-03-17T23:01:02.000000Z"}]},{"id":4534436,"change_date":"2023-12-01 21:42:00","inspection_id":"80283744","dot_number":"4053531","report_state":"IN","report_number":"5422005502","insp_date":"2023-11-29 00:00:00","insp_start_time":"1542","insp_end_time":"1620","registration_date":null,"region":"ES","ci_status_code":"C","location":"5370E","location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CABOT","shipping_paper_number":"5764267","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":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"114781","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:36.000000Z","updated_at":"2025-03-17T19:52:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7292904,"change_date":"2023-12-01 21:42:00","inspection_id":"80283744","insp_unit_id":"198297810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"AE008","insp_unit_license":"R704419","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDJAPR8HN506937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"},{"id":7292905,"change_date":"2023-12-01 21:42:00","inspection_id":"80283744","insp_unit_id":"198297811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"9325237","insp_unit_license":"AD4778","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C7HT701099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"}]},{"id":4386406,"change_date":"2023-11-09 21:41:00","inspection_id":"80120944","dot_number":"4053531","report_state":"TX","report_number":"V231223118","insp_date":"2023-11-06 00:00:00","insp_start_time":"1619","insp_end_time":"1708","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH 35 NORTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ANSA-MTY-CEDIS","shipping_paper_number":"22404160","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9121126","transaction_code":"C","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":"M","census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1062472","created_at":"2025-03-17T19:49:51.000000Z","updated_at":"2025-03-17T19:49:51.000000Z","inspection_violations":[{"id":6787105,"change_date":"2023-11-09 21:41:00","inspection_id":"80120944","insp_violation_id":"256322125","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197994475","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7054569,"change_date":"2023-11-09 21:41:00","inspection_id":"80120944","insp_unit_id":"197994475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE003","insp_unit_license":"R664137","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK09LAE1524","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"},{"id":7054570,"change_date":"2023-11-09 21:41:00","inspection_id":"80120944","insp_unit_id":"197994476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"54062","insp_unit_license":"BX4491","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UYVS2538DP614811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":3353012,"change_date":"2023-06-23 21:40:00","inspection_id":"78969050","dot_number":"4053531","report_state":"TN","report_number":"TFEH000113","insp_date":"2023-06-22 00:00:00","insp_start_time":"1917","insp_end_time":"1950","registration_date":null,"region":"CT","ci_status_code":"C","location":"38","location_desc":"I-40 WEST","county_code_state":"TN","county_code":"075","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"AUSTIN, IN PBC FLEET","shipping_paper_number":"2737Q0498967","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-06-23 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":"1655314","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04053531","upload_search_indicator":null,"census_search_date":"2023-06-23 21:40:00","snet_input_date":"2023-06-23 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-06-23 21:40:00","insp_carrier_name":"ANDRADE EXPEDITED LLC","insp_carrier_street":"117 STARLING CREEK LOOP","insp_carrier_city":"LAREDO","insp_carrier_state":"TX","insp_carrier_zip_code":"78045","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:22.000000Z","updated_at":"2025-03-17T19:29:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5390111,"change_date":"2023-06-23 21:40:00","inspection_id":"78969050","insp_unit_id":"195647756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"AE001","insp_unit_license":"R673623","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGLBG8CSBS5196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"},{"id":5390112,"change_date":"2023-06-23 21:40:00","inspection_id":"78969050","insp_unit_id":"195647757","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"977144","insp_unit_license":"185796T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1JJV532D5HL977144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:32.000000Z","updated_at":"2025-03-17T22:45:32.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4053531\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4053531\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4053531\/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\/4053531\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}