{"current_page":1,"data":[{"id":12198209,"change_date":"2026-06-16 21:39:00","inspection_id":"88154830","dot_number":"229857","report_state":"OR","report_number":"AS38810207","insp_date":"2026-06-15 00:00:00","insp_start_time":"1327","insp_end_time":"1421","registration_date":null,"region":"PD","ci_status_code":"C","location":"06-03","location_desc":"MYRTLE POINT OR","county_code_state":"OR","county_code":"011","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"200898","viol_total":"7","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3551711","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:36.000000Z","updated_at":"2026-06-27T09:30:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":11663363,"change_date":"2026-04-16 21:40:00","inspection_id":"87593592","dot_number":"229857","report_state":"OR","report_number":"AW41700333","insp_date":"2026-04-15 00:00:00","insp_start_time":"1555","insp_end_time":"1615","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"COOS BAY OR","county_code_state":"OR","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","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":"U","pen_cen_match":"I","final_status_date":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116500","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3167621","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:13.000000Z","updated_at":"2026-04-27T09:31:13.000000Z","inspection_violations":[{"id":20732637,"change_date":null,"inspection_id":"87593592","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39311A1CSURR"},{"id":20732638,"change_date":null,"inspection_id":"87593592","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39311BCSLRR"},{"id":20732639,"change_date":null,"inspection_id":"87593592","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3939ALSLIWR"},{"id":20732640,"change_date":null,"inspection_id":"87593592","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3969D2FTF"},{"id":21385376,"change_date":null,"inspection_id":"87593592","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"39111B4CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-06-29T03:31:08.000000Z","updated_at":"2026-06-29T03:31:08.000000Z","normalized_code":"39111B4CLHA"}],"inspection_per_units":[{"id":20726485,"change_date":null,"inspection_id":"87593592","insp_unit_id":"sms-backfill-788342328-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YCDA879","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZDP9X2HJ164462","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20729504,"change_date":null,"inspection_id":"87593592","insp_unit_id":"sms-backfill-788342328-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BEALL INC","insp_unit_company":null,"insp_unit_license":"HV73592","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1BN2P4028XN009435","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":11649940,"change_date":"2026-04-15 21:38:00","inspection_id":"87579478","dot_number":"229857","report_state":"OR","report_number":"AW43150361","insp_date":"2026-04-14 00:00:00","insp_start_time":"1539","insp_end_time":"1614","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"COOS BAY OR","county_code_state":"OR","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EMPTY","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116500","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3156720","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2026-04-15 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-15 21:38:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-26T09:30:17.000000Z","updated_at":"2026-04-26T09:30:17.000000Z","inspection_violations":[{"id":20732266,"change_date":null,"inspection_id":"87579478","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39311A1CSURR"},{"id":20732267,"change_date":null,"inspection_id":"87579478","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"13D2-CSLRR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"39313D2CSLRR"},{"id":20732268,"change_date":null,"inspection_id":"87579478","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-05-18T03:19:25.000000Z","updated_at":"2026-05-18T03:19:25.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":20726243,"change_date":null,"inspection_id":"87579478","insp_unit_id":"sms-backfill-788215302-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YCDA879","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZDP9X2HJ164462","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"},{"id":20729231,"change_date":null,"inspection_id":"87579478","insp_unit_id":"sms-backfill-788215302-2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BEALL INC","insp_unit_company":null,"insp_unit_license":"HV73592","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"IDBN2P408XN009435","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-05-18T03:15:48.000000Z","updated_at":"2026-05-18T03:15:48.000000Z"}]},{"id":9120999,"change_date":"2025-07-11 21:39:00","inspection_id":"85186208","dot_number":"229857","report_state":"OR","report_number":"AP43450453","insp_date":"2025-07-09 00:00:00","insp_start_time":"0909","insp_end_time":"0934","registration_date":null,"region":"PD","ci_status_code":"C","location":"06-02","location_desc":"BANDON OR","county_code_state":"OR","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":"MANIFEST","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1978907","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:01.000000Z","updated_at":"2025-07-16T10:44:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18658416,"change_date":null,"inspection_id":"85186208","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YCDI777","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2NKHHJ7X3LM409734","insp_unit_decal":null,"insp_unit_decal_number":"35492530","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7613771,"change_date":"2025-01-14 21:54:00","inspection_id":"83598306","dot_number":"229857","report_state":"OR","report_number":"AP43230202","insp_date":"2025-01-13 00:00:00","insp_start_time":"1440","insp_end_time":"1518","registration_date":null,"region":"PS","ci_status_code":"C","location":"20-06","location_desc":"NOTI OR","county_code_state":"OR","county_code":"039","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"147000","viol_total":"7","oos_total":"6","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"6","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246477","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":18434568,"change_date":null,"inspection_id":"83598306","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"3","insp_unit_id":"3","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"},{"id":18434569,"change_date":null,"inspection_id":"83598306","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":18638606,"change_date":null,"inspection_id":"83598306","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YCDG984","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZD49X1PJ262234","insp_unit_decal":null,"insp_unit_decal_number":"34956156","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18797937,"change_date":null,"inspection_id":"83598306","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":null,"insp_unit_license":"HV30063","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"UNKNOWN","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6641483,"change_date":"2024-09-04 21:41:00","inspection_id":"82569388","dot_number":"229857","report_state":"OR","report_number":"AW07330020","insp_date":"2024-09-04 00:00:00","insp_start_time":"1330","insp_end_time":"1455","registration_date":null,"region":"PD","ci_status_code":"C","location":"16-04","location_desc":"JUNIPER BUTTE OR","county_code_state":"OR","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRUE ORGANIC PRODUCTS, INC","shipping_paper_number":"BOR 17469","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-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86500","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"814873","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-09-04 21:41:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-04 21:41:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:48.000000Z","updated_at":"2025-03-17T20:34:48.000000Z","inspection_violations":[{"id":18418061,"change_date":null,"inspection_id":"82569388","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":18702888,"change_date":null,"inspection_id":"82569388","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YAGN376","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPGDB9X66D898862","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18783342,"change_date":null,"inspection_id":"82569388","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"HS59885","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2D9HBFZ39R1016063","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6687388,"change_date":"2024-09-10 21:39:00","inspection_id":"82618208","dot_number":"229857","report_state":"OR","report_number":"AP42920161","insp_date":"2024-09-04 00:00:00","insp_start_time":"1325","insp_end_time":"1355","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"COQUILLE OR","county_code_state":"OR","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","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-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"832064","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18625848,"change_date":null,"inspection_id":"82618208","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YCDG918","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZD49XXPJ251930","insp_unit_decal":null,"insp_unit_decal_number":"34339467","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6687398,"change_date":"2024-09-10 21:39:00","inspection_id":"82618218","dot_number":"229857","report_state":"OR","report_number":"AP42920160","insp_date":"2024-09-04 00:00:00","insp_start_time":"1255","insp_end_time":"1325","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"COQUILLE OR","county_code_state":"OR","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","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-09-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56600","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":"832065","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-09-10 21:39:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-10 21:39:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:39.000000Z","updated_at":"2025-03-17T20:35:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18625849,"change_date":null,"inspection_id":"82618218","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YAJA921","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZP49XXKJ305419","insp_unit_decal":null,"insp_unit_decal_number":"34339466","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5361041,"change_date":"2024-03-25 21:41:00","inspection_id":"81187251","dot_number":"229857","report_state":"NV","report_number":"7143020739","insp_date":"2024-03-25 00:00:00","insp_start_time":"0809","insp_end_time":"0847","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"US395 BORDERTOWN N\/B CHECKSITE","county_code_state":"NV","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"50016171","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760213","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":"M","census_search_date":"2024-03-25 21:41:00","snet_input_date":"2024-03-25 00:00:00","source_office":"4NVS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":18392689,"change_date":null,"inspection_id":"81187251","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3II"},{"id":18392690,"change_date":null,"inspection_id":"81187251","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3A3-PROPN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3PROPN"}],"inspection_per_units":[{"id":18607252,"change_date":null,"inspection_id":"81187251","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YAJR375","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKDD49X8AJ267674","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18763850,"change_date":null,"inspection_id":"81187251","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":null,"insp_unit_license":"HV73592","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1BN2P4028XN009435","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5331970,"change_date":"2024-03-21 21:41:00","inspection_id":"81155560","dot_number":"229857","report_state":"NV","report_number":"7116021793","insp_date":"2024-03-20 00:00:00","insp_start_time":"1010","insp_end_time":"1105","registration_date":"2024-03-21 00:00:00","region":"PT","ci_status_code":"C","location":"2","location_desc":"US395\/ BORDERTOWN","county_code_state":"NV","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"759819","transaction_code":"C","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":"M","census_search_date":"2024-03-20 21:43:00","snet_input_date":"2024-03-20 00:00:00","source_office":"4NVS001","mcmis_add_date":"2024-03-20 21:43:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:18.000000Z","updated_at":"2025-03-17T20:08:18.000000Z","inspection_violations":[{"id":18392165,"change_date":null,"inspection_id":"81155560","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":18606829,"change_date":null,"inspection_id":"81155560","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YAIA178","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3WKDD49X3GF101818","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18763394,"change_date":null,"inspection_id":"81155560","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MIDL","insp_unit_company":null,"insp_unit_license":"HU27584","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MFB2S4C01R001699","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5343061,"change_date":"2024-03-21 21:41:00","inspection_id":"81167656","dot_number":"229857","report_state":"CA","report_number":"UC5H004429","insp_date":"2024-03-19 00:00:00","insp_start_time":"0955","insp_end_time":"1018","registration_date":null,"region":"PT","ci_status_code":"C","location":"9101","location_desc":"NB AGRICULTURAL INSPECTION","county_code_state":"CA","county_code":"035","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"15287429","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-03-21 21:41:00","snet_input_date":"2024-03-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:38.000000Z","updated_at":"2025-03-17T20:08:38.000000Z","inspection_violations":[{"id":18392363,"change_date":null,"inspection_id":"81167656","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18684678,"change_date":null,"inspection_id":"81167656","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YAIA178","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3WKDD49X3GF101818","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18763555,"change_date":null,"inspection_id":"81167656","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"MIDL","insp_unit_company":null,"insp_unit_license":"HU27584","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2MFB2S4C01R001699","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5190193,"change_date":"2024-03-01 21:40:00","inspection_id":"81000636","dot_number":"229857","report_state":"OR","report_number":"AADU003495","insp_date":"2024-02-29 00:00:00","insp_start_time":"1433","insp_end_time":"1454","registration_date":"2024-03-01 00:00:00","region":"PT","ci_status_code":"C","location":"0606","location_desc":"HAUSER - 6 MI N COOS BY BRIDGE","county_code_state":"OR","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"PHILLIPS 66","shipping_paper_number":"0000851191","cargo_tank":"406","hazmat_placard_req":"Y","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-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1243475","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-03-01 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T20:05:22.000000Z","updated_at":"2025-03-17T20:05:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18682493,"change_date":null,"inspection_id":"81000636","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENS","insp_unit_company":null,"insp_unit_license":"YCDF345","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZD49X8MJ459722","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4815905,"change_date":"2024-01-18 21:45:00","inspection_id":"80591967","dot_number":"229857","report_state":"OR","report_number":"AASC010894","insp_date":"2024-01-10 00:00:00","insp_start_time":"0947","insp_end_time":"1022","registration_date":"2024-01-18 00:00:00","region":"PT","ci_status_code":"C","location":"2005","location_desc":"LOWELL - 4 MI E LOWELL JCT","county_code_state":"OR","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MARATHON PETROLEUM CO LP","shipping_paper_number":"03830002","cargo_tank":"406","hazmat_placard_req":"Y","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-01-11 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1240659","transaction_code":"C","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2024-01-11 21:46:00","snet_input_date":"2024-01-11 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T19:58:04.000000Z","updated_at":"2025-03-17T19:58:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18599303,"change_date":null,"inspection_id":"80591967","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YCDG984","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKZD49X1PJ262234","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4424562,"change_date":"2023-11-28 21:42:00","inspection_id":"80163019","dot_number":"229857","report_state":"OR","report_number":"AASM001740","insp_date":"2023-11-13 00:00:00","insp_start_time":"1511","insp_end_time":"1559","registration_date":"2023-11-28 00:00:00","region":"PT","ci_status_code":"C","location":"2006","location_desc":"NOTI - 1.2 MI E NOTI","county_code_state":"OR","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":"406","hazmat_placard_req":"Y","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-11-14 21:42: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":"1","hazmat_oos_total":"1","snet_sequence_id":"1237390","transaction_code":"C","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-14 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4147044,"change_date":"2023-10-06 21:41:00","inspection_id":"79856258","dot_number":"229857","report_state":"WA","report_number":"W743000348","insp_date":"2023-10-05 00:00:00","insp_start_time":"1551","insp_end_time":"1731","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC33","location_desc":"SC33   BOW HILL (POE)","county_code_state":"WA","county_code":"057","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29501","viol_total":"15","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2596410","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"RONALD CHARLES LAFRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:55.000000Z","updated_at":"2025-03-17T19:44:55.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4014511,"change_date":"2023-09-21 21:41:00","inspection_id":"79708868","dot_number":"229857","report_state":"NV","report_number":"R107242767","insp_date":"2023-09-20 00:00:00","insp_start_time":"0903","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"2","location_desc":"US395SB\/BORDERTOWN","county_code_state":"NV","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-09-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"746525","transaction_code":"C","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":"M","census_search_date":"2023-09-20 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-09-20 21:40:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:03.000000Z","updated_at":"2025-03-17T19:42:03.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3675709,"change_date":"2023-08-07 21:42:00","inspection_id":"79331492","dot_number":"229857","report_state":"OR","report_number":"AASM001713","insp_date":"2023-08-03 00:00:00","insp_start_time":"1350","insp_end_time":"1413","registration_date":null,"region":"PT","ci_status_code":"C","location":"2006","location_desc":"NOTI - 1.2 MI E NOTI","county_code_state":"OR","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1230347","transaction_code":"C","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-04 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3513090,"change_date":"2023-07-18 21:43:00","inspection_id":"79148831","dot_number":"229857","report_state":"OR","report_number":"AASZ008725","insp_date":"2023-07-13 00:00:00","insp_start_time":"1340","insp_end_time":"1405","registration_date":"2023-07-18 00:00:00","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":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MARATHON PETROLEUM COMPANY LP","shipping_paper_number":"0001504470","cargo_tank":"406","hazmat_placard_req":"Y","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-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"162500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1228968","transaction_code":"C","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"RONALD CHARLES LA FRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2995413,"change_date":"2023-05-08 21:43:00","inspection_id":"78565484","dot_number":"229857","report_state":"CA","report_number":"ND7X004251","insp_date":"2023-05-03 00:00:00","insp_start_time":"1607","insp_end_time":"1626","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD CVEF","county_code_state":"CA","county_code":"103","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-05-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14889468","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2023-05-08 21:43:00","snet_input_date":"2023-05-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-08 21:43:00","insp_carrier_name":"RONALD CHARLES LAFRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:18.000000Z","updated_at":"2025-03-17T19:22:18.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2900777,"change_date":"2023-05-04 21:41:00","inspection_id":"78458658","dot_number":"229857","report_state":"NV","report_number":"7133020814","insp_date":"2023-04-25 00:00:00","insp_start_time":"0922","insp_end_time":"1017","registration_date":"2023-05-04 00:00:00","region":"PT","ci_status_code":"C","location":"2","location_desc":"IR580 @ BOWERS","county_code_state":"NV","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734931","transaction_code":"C","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":"M","census_search_date":"2023-04-26 21:42:00","snet_input_date":"2023-04-25 00:00:00","source_office":"4NVS001","mcmis_add_date":"2023-04-26 21:42:00","insp_carrier_name":"RONALD CHARLES LAFRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:23.000000Z","updated_at":"2025-03-17T19:20:23.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":1966541,"change_date":"2022-12-16 21:40:00","inspection_id":"77393944","dot_number":"229857","report_state":"CA","report_number":"NEKW000201","insp_date":"2022-12-14 00:00:00","insp_start_time":"2026","insp_end_time":"2102","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RITCHIE BROS.","shipping_paper_number":"23829","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-12-16 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":"14711093","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2022-12-16 21:40:00","snet_input_date":"2022-12-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-16 21:40:00","insp_carrier_name":"RONALD CHARLES LAFRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":29895,"change_date":"2022-03-23 21:32:00","inspection_id":"75122967","dot_number":"229857","report_state":"OR","report_number":"AABC003345","insp_date":"2022-03-22 00:00:00","insp_start_time":"0932","insp_end_time":"0948","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":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MARATHON PETROLEUM COMPANY LP","shipping_paper_number":"1365204","cargo_tank":"406","hazmat_placard_req":"Y","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-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1200004","transaction_code":"A","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00229857","upload_search_indicator":null,"census_search_date":"2022-03-23 21:32:00","snet_input_date":"2022-03-23 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"RONALD CHARLES LAFRANCHI","insp_carrier_street":"580 NORTH CENTRAL STREET","insp_carrier_city":"COQUILLE","insp_carrier_state":"OR","insp_carrier_zip_code":"97423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"167892","created_at":"2025-03-17T18:28:06.000000Z","updated_at":"2025-03-17T18:28:06.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/229857\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/229857\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/229857\/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\/229857\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}