{"current_page":1,"data":[{"id":7206823,"change_date":"2024-11-18 21:41:00","inspection_id":"83170066","dot_number":"3897112","report_state":"TX","report_number":"70BG9DGO3Y","insp_date":"2024-11-13 00:00:00","insp_start_time":"1530","insp_end_time":"1643","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  BOTHAM JEAN BL","county_code_state":"TX","county_code":"113","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK AND PULL","shipping_paper_number":"10220241113SC23","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-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9428531","transaction_code":"C","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-15 21:43:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"5570 W MISSION BLVD","insp_carrier_city":"ONTARIO","insp_carrier_state":"CA","insp_carrier_zip_code":"91762","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1082513","created_at":"2025-03-17T20:46:26.000000Z","updated_at":"2025-03-17T20:46:26.000000Z","inspection_violations":[{"id":11263131,"change_date":"2024-11-18 21:41:00","inspection_id":"83170066","insp_violation_id":"262958470","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"203937241","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:00:42.000000Z","updated_at":"2025-03-17T22:00:42.000000Z","normalized_code":"39375A3"},{"id":11263132,"change_date":"2024-11-18 21:41:00","inspection_id":"83170066","insp_violation_id":"262958471","seq_no":"2","part_no":"392","part_no_section":"71A","insp_viol_unit":"1","insp_unit_id":"203937240","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:42.000000Z","updated_at":"2025-03-17T22:00:42.000000Z","normalized_code":"39271A"}],"inspection_per_units":[{"id":11624517,"change_date":"2024-11-18 21:41:00","inspection_id":"83170066","insp_unit_id":"203937240","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"},{"id":11624518,"change_date":"2024-11-18 21:41:00","inspection_id":"83170066","insp_unit_id":"203937241","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANA","insp_unit_company":"5321","insp_unit_license":"4UL9361","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532W84L898448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:26.000000Z","updated_at":"2025-03-17T23:43:26.000000Z"}]},{"id":6725451,"change_date":"2024-09-14 21:32:00","inspection_id":"82658623","dot_number":"3897112","report_state":"AZ","report_number":"7656000181","insp_date":"2024-09-07 00:00:00","insp_start_time":"1210","insp_end_time":"1249","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"TUCSON AZ","county_code_state":"AZ","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TOPSVILLE LLC","shipping_paper_number":"019032201080881","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-09-14 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"845092","transaction_code":"A","transaction_date":"2024-09-14 00:00:00","upload_date":"2024-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2024-09-14 21:32:00","snet_input_date":"2024-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-14 21:32:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"5129 HARVARD ST","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:30.000000Z","updated_at":"2025-03-17T20:36:30.000000Z","inspection_violations":[{"id":10471111,"change_date":"2024-09-14 21:32:00","inspection_id":"82658623","insp_violation_id":"261800043","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202921892","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39617C"},{"id":10471112,"change_date":"2024-09-14 21:32:00","inspection_id":"82658623","insp_violation_id":"261800044","seq_no":"2","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:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10844554,"change_date":"2024-09-14 21:32:00","inspection_id":"82658623","insp_unit_id":"202921892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"001","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"},{"id":10844555,"change_date":"2024-09-14 21:32:00","inspection_id":"82658623","insp_unit_id":"202921893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"LTS18D","insp_unit_license":"4VA4784","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1DW1A53214B704210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"}]},{"id":6534541,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","dot_number":"3897112","report_state":"ID","report_number":"2790016087","insp_date":"2024-08-20 00:00:00","insp_start_time":"1625","insp_end_time":"1705","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"DECLO ID","county_code_state":"ID","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAGICTALC","shipping_paper_number":"S171947","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"772304","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"5129 HARVARD ST","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:23.000000Z","updated_at":"2025-03-17T20:32:23.000000Z","inspection_violations":[{"id":10152237,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_violation_id":"261341435","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:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3922"},{"id":10152238,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_violation_id":"261341436","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202526517","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39375A3"},{"id":10152239,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_violation_id":"261341437","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"202526517","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39375C"},{"id":10152240,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_violation_id":"261341438","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202526518","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":10534264,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_unit_id":"202526517","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"002","insp_unit_license":"YP94842","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLD51FSGK1410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:05.000000Z","updated_at":"2025-03-17T23:32:05.000000Z"},{"id":10534265,"change_date":"2024-08-22 21:42:00","inspection_id":"82455367","insp_unit_id":"202526518","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5389","insp_unit_license":"4RT8187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L981284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:05.000000Z","updated_at":"2025-03-17T23:32:05.000000Z"}]},{"id":6249490,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","dot_number":"3897112","report_state":"SC","report_number":"T392000469","insp_date":"2024-07-17 00:00:00","insp_start_time":"2116","insp_end_time":"2235","registration_date":null,"region":"ET","ci_status_code":"C","location":"108","location_desc":"I-85 SB ROADSIDE","county_code_state":"SC","county_code":"007","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"NH KELMAN","shipping_paper_number":"2700238-1","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1155307","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"2SCS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"5129 HARVARD ST","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[{"id":9709104,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713636","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201948972","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3939A"},{"id":9709105,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713637","seq_no":"2","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"201948972","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"393203"},{"id":9709106,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713638","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201948973","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3939A"},{"id":9709107,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713639","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201948973","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3939A"},{"id":9709108,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713640","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201948973","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3939A"},{"id":9709109,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_violation_id":"260713641","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201948973","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10069480,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_unit_id":"201948972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:18.000000Z","updated_at":"2025-03-17T23:27:18.000000Z"},{"id":10069481,"change_date":"2024-07-18 21:40:00","inspection_id":"82150907","insp_unit_id":"201948973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"5389","insp_unit_license":"4RT8187","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532WX6L981284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:18.000000Z","updated_at":"2025-03-17T23:27:18.000000Z"}]},{"id":3431219,"change_date":"2023-07-05 21:41:00","inspection_id":"79056530","dot_number":"3897112","report_state":"NC","report_number":"0006553099","insp_date":"2023-07-05 00:00:00","insp_start_time":"0720","insp_end_time":"0754","registration_date":null,"region":"ET","ci_status_code":"C","location":"ASHEVI","location_desc":"ASHEVILLE WEIGH STATION, I-40,","county_code_state":"NC","county_code":"021","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MULTIPLE","shipping_paper_number":"8626","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-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2086974","transaction_code":"A","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":"M","census_search_date":"2023-07-05 21:41:00","snet_input_date":"2023-07-05 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-05 21:41:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"4361 MISSION BLVD SPC #174","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763-2427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:57.000000Z","updated_at":"2025-03-17T19:30:57.000000Z","inspection_violations":[{"id":5289799,"change_date":"2023-07-05 21:41:00","inspection_id":"79056530","insp_violation_id":"253862107","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195821519","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:34.000000Z","updated_at":"2025-03-17T21:31:34.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":5516647,"change_date":"2023-07-05 21:41:00","inspection_id":"79056530","insp_unit_id":"195821519","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:33.000000Z","updated_at":"2025-03-17T22:46:33.000000Z"},{"id":5516648,"change_date":"2023-07-05 21:41:00","inspection_id":"79056530","insp_unit_id":"195821520","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":null,"insp_unit_license":"4PC2708","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXGT099068","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:33.000000Z","updated_at":"2025-03-17T22:46:33.000000Z"}]},{"id":3308671,"change_date":"2023-06-16 21:41:00","inspection_id":"78919280","dot_number":"3897112","report_state":"CA","report_number":"UG3J000468","insp_date":"2023-06-16 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"BLACK ROCK PLATFORM SCALE","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"14947776","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2023-06-16 21:41:00","snet_input_date":"2023-06-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-16 21:41:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"275 JURUPA AVE","insp_carrier_city":"BLOOMINGTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92316","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:31.000000Z","updated_at":"2025-03-17T19:28:31.000000Z","inspection_violations":[{"id":5104182,"change_date":"2023-06-16 21:41:00","inspection_id":"78919280","insp_violation_id":"253567273","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195551075","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"3939A"},{"id":5104183,"change_date":"2023-06-16 21:41:00","inspection_id":"78919280","insp_violation_id":"253567274","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195551075","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA462615","created_at":"2025-03-17T21:30:44.000000Z","updated_at":"2025-03-17T21:30:44.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5319331,"change_date":"2023-06-16 21:41:00","inspection_id":"78919280","insp_unit_id":"195551075","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHI 001","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:57.000000Z","updated_at":"2025-03-17T22:44:57.000000Z"}]},{"id":3191743,"change_date":"2023-06-01 21:42:00","inspection_id":"78787005","dot_number":"3897112","report_state":"NM","report_number":"9520N465M5","insp_date":"2023-05-30 00:00:00","insp_start_time":"0401","insp_end_time":"0453","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UHAUL BOXES","shipping_paper_number":"23261292","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-06-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2008371","transaction_code":"A","transaction_date":"2023-05-30 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"4361 MISSION BLVD SPC #174","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"917632427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[{"id":4916745,"change_date":"2023-06-01 21:42:00","inspection_id":"78787005","insp_violation_id":"253209673","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195255805","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5133572,"change_date":"2023-06-01 21:42:00","inspection_id":"78787005","insp_unit_id":"195255804","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"UNIT01","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:27.000000Z","updated_at":"2025-03-17T22:43:27.000000Z"},{"id":5133573,"change_date":"2023-06-01 21:42:00","inspection_id":"78787005","insp_unit_id":"195255805","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT1404","insp_unit_license":"4MY8135","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C7ET180039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:27.000000Z","updated_at":"2025-03-17T22:43:27.000000Z"}]},{"id":3021459,"change_date":"2023-05-11 21:41:00","inspection_id":"78594913","dot_number":"3897112","report_state":"NM","report_number":"7927N3LBL3","insp_date":"2023-05-09 00:00:00","insp_start_time":"0930","insp_end_time":"0955","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CELESTRON","shipping_paper_number":"1254909","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-11 21:41: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":"2003201","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2023-05-11 21:41:00","snet_input_date":"2023-05-11 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-05-11 21:41:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"4361 MISSION BLVD SPC #174","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"917632427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4860709,"change_date":"2023-05-11 21:41:00","inspection_id":"78594913","insp_unit_id":"194876332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"TTT01","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"},{"id":4860710,"change_date":"2023-05-11 21:41:00","inspection_id":"78594913","insp_unit_id":"194876333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"STT98290","insp_unit_license":"453931Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3H3V532KXNS602141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2893163,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","dot_number":"3897112","report_state":"VA","report_number":"7155002672","insp_date":"2023-04-26 00:00:00","insp_start_time":"1210","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":"165","location_desc":"NB I-81 AT 262 MM","county_code_state":"VA","county_code":"165","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"STOP AND SHOP","shipping_paper_number":"2285","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"862037","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":"M","census_search_date":"2023-04-26 21:41:00","snet_input_date":"2023-04-26 00:00:00","source_office":"1VAS001","mcmis_add_date":"2023-04-26 21:41:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"4361 MISSION BLVD SPC #174","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763-2427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:05.000000Z","updated_at":"2025-03-17T19:20:05.000000Z","inspection_violations":[{"id":4440746,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_violation_id":"252443308","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194586993","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"39375C"},{"id":4440747,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_violation_id":"252443309","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"194586993","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"39375C"},{"id":4440748,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_violation_id":"252443310","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3958E1"},{"id":4440749,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_violation_id":"252443311","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"C","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:27:44.000000Z","updated_at":"2025-03-17T21:27:44.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":4654735,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_unit_id":"194586993","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"},{"id":4654736,"change_date":"2023-04-26 21:41:00","inspection_id":"78449736","insp_unit_id":"194586994","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"4DZ4217","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25344P187112","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"}]},{"id":2733327,"change_date":"2023-04-04 21:42:00","inspection_id":"78268948","dot_number":"3897112","report_state":"CA","report_number":"UBZU002544","insp_date":"2023-03-30 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","county_code_state":"CA","county_code":"095","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"14841031","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2023-04-04 21:42:00","snet_input_date":"2023-03-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"275 JURUPA AVE","insp_carrier_city":"BLOOMINGTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92316","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:00.000000Z","updated_at":"2025-03-17T19:17:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4399885,"change_date":"2023-04-04 21:42:00","inspection_id":"78268948","insp_unit_id":"194227300","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"},{"id":4399886,"change_date":"2023-04-04 21:42:00","inspection_id":"78268948","insp_unit_id":"194227301","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"437378Z","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D9LL189976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"}]},{"id":2601388,"change_date":"2023-03-22 21:42:00","inspection_id":"78118418","dot_number":"3897112","report_state":"OK","report_number":"PE13175539","insp_date":"2023-03-13 00:00:00","insp_start_time":"0829","insp_end_time":"0940","registration_date":"2023-03-21 00:00:00","region":"CT","ci_status_code":"C","location":"05040","location_desc":"BECKHAM POE","county_code_state":"OK","county_code":"009","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SUNSETY PACIFIC LOGISTICS","shipping_paper_number":"383977","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-03-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"702762","transaction_code":"C","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":"M","census_search_date":"2023-03-17 21:42:00","snet_input_date":"2023-03-13 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"275 JURUPA AVE","insp_carrier_city":"BLOOMINGTON","insp_carrier_state":"CA","insp_carrier_zip_code":"92316","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:48.000000Z","updated_at":"2025-03-17T19:14:48.000000Z","inspection_violations":[{"id":4001456,"change_date":"2023-03-22 21:42:00","inspection_id":"78118418","insp_violation_id":"251800360","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194000777","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3963A1"},{"id":4001457,"change_date":"2023-03-22 21:42:00","inspection_id":"78118418","insp_violation_id":"251800361","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194000777","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4187173,"change_date":"2023-03-22 21:42:00","inspection_id":"78118418","insp_unit_id":"194000777","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"001","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"},{"id":4187174,"change_date":"2023-03-22 21:42:00","inspection_id":"78118418","insp_unit_id":"194000778","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1508","insp_unit_license":"4NK1882","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C6FT134042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"}]},{"id":1928904,"change_date":"2022-12-12 21:44:00","inspection_id":"77350952","dot_number":"3897112","report_state":"OR","report_number":"AAAV003808","insp_date":"2022-12-09 00:00:00","insp_start_time":"1527","insp_end_time":"1554","registration_date":null,"region":"PT","ci_status_code":"C","location":"1007","location_desc":"BOOTH RANCH SB-2 M N MYRTLE CR","county_code_state":"OR","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"STIMSON LUMBER","shipping_paper_number":"46800","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":"2022-12-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1215174","transaction_code":"A","transaction_date":"2022-12-09 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03897112","upload_search_indicator":null,"census_search_date":"2022-12-12 21:44:00","snet_input_date":"2022-12-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-12-12 21:44:00","insp_carrier_name":"ANDRADE TRANSPORTATION COMPANY LLC","insp_carrier_street":"4361 MISSION BLVD SPC #174","insp_carrier_city":"MONTCLAIR","insp_carrier_state":"CA","insp_carrier_zip_code":"91763-2427","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"015233","created_at":"2025-03-17T19:02:13.000000Z","updated_at":"2025-03-17T19:02:13.000000Z","inspection_violations":[{"id":2997580,"change_date":"2022-12-12 21:44:00","inspection_id":"77350952","insp_violation_id":"250057398","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":"CE462974","created_at":"2025-03-17T21:21:13.000000Z","updated_at":"2025-03-17T21:21:13.000000Z","normalized_code":"3958A1"},{"id":2997581,"change_date":"2022-12-12 21:44:00","inspection_id":"77350952","insp_violation_id":"250057399","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192387609","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CE462975","created_at":"2025-03-17T21:21:13.000000Z","updated_at":"2025-03-17T21:21:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3103982,"change_date":"2022-12-12 21:44:00","inspection_id":"77350952","insp_unit_id":"192387609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"YP67519","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH0FN920243","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:15.000000Z","updated_at":"2025-03-17T22:28:15.000000Z"},{"id":3103983,"change_date":"2022-12-12 21:44:00","inspection_id":"77350952","insp_unit_id":"192387610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"53109","insp_unit_license":"4SP7799","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:15.000000Z","updated_at":"2025-03-17T22:28:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3897112\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3897112\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3897112\/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\/3897112\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}