{"current_page":1,"data":[{"id":7521660,"change_date":"2024-12-30 21:39:00","inspection_id":"83501481","dot_number":"3510402","report_state":"CA","report_number":"UCQO003154","insp_date":"2024-12-28 00:00:00","insp_start_time":"0341","insp_end_time":"0351","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"073","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":"2024-12-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15644368","transaction_code":"A","transaction_date":"2024-12-28 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11757443,"change_date":"2024-12-30 21:39:00","inspection_id":"83501481","insp_violation_id":"263702125","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"1","insp_unit_id":"204597990","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922SLLSOA"}],"inspection_per_units":[{"id":12134800,"change_date":"2024-12-30 21:39:00","inspection_id":"83501481","insp_unit_id":"204597990","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"},{"id":12134801,"change_date":"2024-12-30 21:39:00","inspection_id":"83501481","insp_unit_id":"204597991","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":null,"insp_unit_license":"4KJ8074","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT01JAH516002770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":7128012,"change_date":"2024-11-05 21:39:00","inspection_id":"83086555","dot_number":"3510402","report_state":"CA","report_number":"UCQ0002611","insp_date":"2024-11-03 00:00:00","insp_start_time":"2108","insp_end_time":"2124","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","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":"2024-11-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15583447","transaction_code":"A","transaction_date":"2024-11-03 00:00:00","upload_date":"2024-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2024-11-05 21:39:00","snet_input_date":"2024-11-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-05 21:39:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"574325","created_at":"2025-03-17T20:44:40.000000Z","updated_at":"2025-03-17T20:44:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11496624,"change_date":"2024-11-05 21:39:00","inspection_id":"83086555","insp_unit_id":"203749798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03\/ WHT","insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"},{"id":11496625,"change_date":"2024-11-05 21:39:00","inspection_id":"83086555","insp_unit_id":"203749799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"02\/ BERG","insp_unit_license":"4KJ8074","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1PT01JAH516002770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:07.000000Z","updated_at":"2025-03-17T23:42:07.000000Z"}]},{"id":6907148,"change_date":"2024-10-07 21:41:00","inspection_id":"82852104","dot_number":"3510402","report_state":"CA","report_number":"UF09000569","insp_date":"2024-10-05 00:00:00","insp_start_time":"2056","insp_end_time":"2106","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OPPENHEIMER","shipping_paper_number":"682842025567960","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":"2024-10-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15547503","transaction_code":"A","transaction_date":"2024-10-05 00:00:00","upload_date":"2024-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2024-10-07 21:41:00","snet_input_date":"2024-10-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-07 21:41:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"574325","created_at":"2025-03-17T20:40:13.000000Z","updated_at":"2025-03-17T20:40:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11139600,"change_date":"2024-10-07 21:41:00","inspection_id":"82852104","insp_unit_id":"203306501","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"A003-WHI","insp_unit_license":"4KE7601","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS25323U016410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"},{"id":11139601,"change_date":"2024-10-07 21:41:00","inspection_id":"82852104","insp_unit_id":"203306502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03-WHI","insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:21.000000Z","updated_at":"2025-03-17T23:38:21.000000Z"}]},{"id":5841374,"change_date":"2024-05-26 21:32:00","inspection_id":"81710153","dot_number":"3510402","report_state":"AZ","report_number":"6389000071","insp_date":"2024-05-08 00:00:00","insp_start_time":"0746","insp_end_time":"0815","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZMCGS","location_desc":"SEDONA AZ","county_code_state":"AZ","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","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-26 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"477720","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2024-05-26 21:32:00","snet_input_date":"2024-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-26 21:32:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:37.000000Z","updated_at":"2025-03-17T20:18:37.000000Z","inspection_violations":[{"id":9051905,"change_date":"2024-05-26 21:32:00","inspection_id":"81710153","insp_violation_id":"259725527","seq_no":"1","part_no":"395","part_no_section":"8(a)","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:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":9407541,"change_date":"2024-05-26 21:32:00","inspection_id":"81710153","insp_unit_id":"201082086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"03","insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"},{"id":9407542,"change_date":"2024-05-26 21:32:00","inspection_id":"81710153","insp_unit_id":"201082087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"320736","insp_unit_license":"P698216","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C0KR048216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"}]},{"id":4842773,"change_date":"2024-01-16 21:45:00","inspection_id":"80621284","dot_number":"3510402","report_state":"CA","report_number":"NB6F005094","insp_date":"2024-01-11 00:00:00","insp_start_time":"0916","insp_end_time":"0929","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","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":"2024-01-16 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15199391","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2024-01-16 21:45:00","snet_input_date":"2024-01-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-16 21:45:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"574325","created_at":"2025-03-17T19:58:48.000000Z","updated_at":"2025-03-17T19:58:48.000000Z","inspection_violations":[{"id":7468091,"change_date":"2024-01-16 21:45:00","inspection_id":"80621284","insp_violation_id":"257364387","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"198981656","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA 541061","created_at":"2025-03-17T21:42:02.000000Z","updated_at":"2025-03-17T21:42:02.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":7791771,"change_date":"2024-01-16 21:45:00","inspection_id":"80621284","insp_unit_id":"198981656","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"Y","insp_unit_decal_number":"33566063","created_at":"2025-03-17T23:05:39.000000Z","updated_at":"2025-03-17T23:05:39.000000Z"}]},{"id":4210879,"change_date":"2023-10-16 21:43:00","inspection_id":"79926629","dot_number":"3510402","report_state":"CA","report_number":"UEHJ004129","insp_date":"2023-10-13 00:00:00","insp_start_time":"2359","insp_end_time":"0017","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALTMAN PLANTS","shipping_paper_number":"N\/A","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-10-16 21:43: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":"15097686","transaction_code":"A","transaction_date":"2023-10-14 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"574325","created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6771818,"change_date":"2023-10-16 21:43:00","inspection_id":"79926629","insp_unit_id":"197585921","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"YP81523","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKAD49X6EJ320266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"},{"id":6771819,"change_date":"2023-10-16 21:43:00","inspection_id":"79926629","insp_unit_id":"197585922","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"190857","insp_unit_license":"CC3456","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3H3V532C3KR113057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":652111,"change_date":"2022-06-20 21:36:00","inspection_id":"75869951","dot_number":"3510402","report_state":"CA","report_number":"UCQO001381","insp_date":"2022-06-15 00:00:00","insp_start_time":"2320","insp_end_time":"2340","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-20 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14475972","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2022-06-20 21:36:00","snet_input_date":"2022-06-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-20 21:36:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:11.000000Z","updated_at":"2025-03-17T18:39:11.000000Z","inspection_violations":[{"id":1027830,"change_date":"2022-06-20 21:36:00","inspection_id":"75869951","insp_violation_id":"246600704","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189359506","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JW55303","created_at":"2025-03-17T21:11:49.000000Z","updated_at":"2025-03-17T21:11:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1048401,"change_date":"2022-06-20 21:36:00","inspection_id":"75869951","insp_unit_id":"189359505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BLUE","insp_unit_license":"YP36091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9ALAP1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:38.000000Z","updated_at":"2025-03-17T22:14:38.000000Z"},{"id":1048402,"change_date":"2022-06-20 21:36:00","inspection_id":"75869951","insp_unit_id":"189359506","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"WHT","insp_unit_license":"4PN8531","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0620AW702883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:38.000000Z","updated_at":"2025-03-17T22:14:38.000000Z"}]},{"id":610763,"change_date":"2022-06-14 21:43:00","inspection_id":"75820988","dot_number":"3510402","report_state":"CA","report_number":"NAFA004374","insp_date":"2022-06-10 00:00:00","insp_start_time":"1910","insp_end_time":"1931","registration_date":null,"region":"PT","ci_status_code":"C","location":"686","location_desc":"RAINBOW IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","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":"2022-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"115200","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":"14467161","transaction_code":"A","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03510402","upload_search_indicator":null,"census_search_date":"2022-06-14 21:43:00","snet_input_date":"2022-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"ANDRADE AND SONS INC","insp_carrier_street":"1298 E MISSION RD","insp_carrier_city":"FALLBROOK","insp_carrier_state":"CA","insp_carrier_zip_code":"92028","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:27.000000Z","updated_at":"2025-03-17T18:38:27.000000Z","inspection_violations":[{"id":960992,"change_date":"2022-06-14 21:43:00","inspection_id":"75820988","insp_violation_id":"246469125","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189252178","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW598616","created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":982480,"change_date":"2022-06-14 21:43:00","inspection_id":"75820988","insp_unit_id":"189252178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02-BLU","insp_unit_license":"YP36091","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9ALAP1896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"},{"id":982481,"change_date":"2022-06-14 21:43:00","inspection_id":"75820988","insp_unit_id":"189252179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREA","insp_unit_company":"10-WHI","insp_unit_license":"4PN8531","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0620AW702883","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:14.000000Z","updated_at":"2025-03-17T22:14:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3510402\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3510402\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3510402\/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\/3510402\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}