{"current_page":1,"data":[{"id":8447909,"change_date":"2025-04-23 21:41:00","inspection_id":"84475383","dot_number":"1228603","report_state":"NY","report_number":"D306001233","insp_date":"2025-04-22 00:00:00","insp_start_time":"1042","insp_end_time":"1117","registration_date":null,"region":"ED","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1633976","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:22.000000Z","updated_at":"2025-04-27T10:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13721754,"change_date":"2025-04-23 21:41:00","inspection_id":"84475383","insp_unit_id":"206450221","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5507","insp_unit_license":"71244NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA6RS012188","insp_unit_decal":"Y","insp_unit_decal_number":"35216747","created_at":"2025-04-26T10:11:03.000000Z","updated_at":"2025-04-27T09:57:53.000000Z"}]},{"id":7698741,"change_date":"2025-01-24 21:39:00","inspection_id":"83687364","dot_number":"1228603","report_state":"NY","report_number":"SPC4020032","insp_date":"2025-01-17 00:00:00","insp_start_time":"0935","insp_end_time":"1013","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CHENANGO NY","county_code_state":"NY","county_code":"007","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1282398","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2025-01-24 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:57.000000Z","updated_at":"2025-03-17T20:57:57.000000Z","inspection_violations":[{"id":12028953,"change_date":"2025-01-24 21:39:00","inspection_id":"83687364","insp_violation_id":"264155000","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLS3"},{"id":12028954,"change_date":"2025-01-24 21:39:00","inspection_id":"83687364","insp_violation_id":"264155001","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204986393","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S250035287","created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":12423206,"change_date":"2025-01-24 21:39:00","inspection_id":"83687364","insp_unit_id":"204986393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5507","insp_unit_license":"71244NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA6RS012188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":6259379,"change_date":"2024-07-19 21:37:00","inspection_id":"82161282","dot_number":"1228603","report_state":"NY","report_number":"D306100255","insp_date":"2024-07-16 00:00:00","insp_start_time":"1259","insp_end_time":"1345","registration_date":null,"region":"ED","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"668716","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10085034,"change_date":"2024-07-19 21:37:00","inspection_id":"82161282","insp_unit_id":"201967319","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5507","insp_unit_license":"71244NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA6RS012188","insp_unit_decal":"Y","insp_unit_decal_number":"34335815","created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":5894868,"change_date":"2024-06-03 21:42:00","inspection_id":"81767967","dot_number":"1228603","report_state":"NY","report_number":"SPE0243506","insp_date":"2024-05-22 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504A","location_desc":"MANCHESTER","county_code_state":"NY","county_code":"069","insp_level_id":"3","service_center":"EA","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-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2927679","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9494660,"change_date":"2024-06-03 21:42:00","inspection_id":"81767967","insp_unit_id":"201195372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":5780032,"change_date":"2024-05-17 21:40:00","inspection_id":"81643555","dot_number":"1228603","report_state":"PA","report_number":"R419413760","insp_date":"2024-05-16 00:00:00","insp_start_time":"0841","insp_end_time":"0919","registration_date":null,"region":"ET","ci_status_code":"C","location":"315","location_desc":"I380 NB MM 14.9 COVINGTON TWP","county_code_state":"PA","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2443424","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:27.000000Z","updated_at":"2025-03-17T20:17:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9309628,"change_date":"2024-05-17 21:40:00","inspection_id":"81643555","insp_unit_id":"200957474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":5686796,"change_date":"2024-05-07 21:42:00","inspection_id":"81542404","dot_number":"1228603","report_state":"NJ","report_number":"SPSCI00814","insp_date":"2024-05-06 00:00:00","insp_start_time":"0902","insp_end_time":"0922","registration_date":null,"region":"ET","ci_status_code":"C","location":"1710","location_desc":"CARNEYS POINT SCALE","county_code_state":"NJ","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"-","shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1210720","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-05-07 21:42:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-05-07 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:28.000000Z","updated_at":"2025-03-17T20:15:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9159479,"change_date":"2024-05-07 21:42:00","inspection_id":"81542404","insp_unit_id":"200763086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"-","insp_unit_license":"71244","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA6RS012188","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:13.000000Z","updated_at":"2025-03-17T23:18:13.000000Z"}]},{"id":5382511,"change_date":"2024-05-01 21:43:00","inspection_id":"81210479","dot_number":"1228603","report_state":"PA","report_number":"N618408708","insp_date":"2024-03-27 00:00:00","insp_start_time":"0428","insp_end_time":"0453","registration_date":"2024-05-01 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I80 E MM 294.2","county_code_state":"PA","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWO","shipping_paper_number":"P241002","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2429243","transaction_code":"C","transaction_date":"2024-03-27 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:25.000000Z","updated_at":"2025-03-17T20:09:25.000000Z","inspection_violations":[{"id":8307578,"change_date":"2024-05-01 21:43:00","inspection_id":"81210479","insp_violation_id":"259259809","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":"TA0458556-0","created_at":"2025-03-17T21:46:12.000000Z","updated_at":"2025-03-17T21:46:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8668650,"change_date":"2024-05-01 21:43:00","inspection_id":"81210479","insp_unit_id":"200679754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:37.000000Z","updated_at":"2025-03-17T23:13:37.000000Z"}]},{"id":5346701,"change_date":"2024-03-22 21:39:00","inspection_id":"81171513","dot_number":"1228603","report_state":"NY","report_number":"D103000396","insp_date":"2024-03-22 00:00:00","insp_start_time":"0952","insp_end_time":"1015","registration_date":null,"region":"ED","ci_status_code":"C","location":"90368","location_desc":"EAST BRANCH NY","county_code_state":"NY","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"SYRA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"337946","transaction_code":"A","transaction_date":"2024-03-22 00:00:00","upload_date":"2024-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-03-22 21:39:00","snet_input_date":"2024-03-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-22 21:39:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:39.000000Z","updated_at":"2025-03-17T20:08:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8610486,"change_date":"2024-03-22 21:39:00","inspection_id":"81171513","insp_unit_id":"200040590","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:06.000000Z","updated_at":"2025-03-17T23:13:06.000000Z"}]},{"id":5337310,"change_date":"2024-03-21 21:40:00","inspection_id":"81161384","dot_number":"1228603","report_state":"NY","report_number":"SPC0270075","insp_date":"2024-03-15 00:00:00","insp_start_time":"1115","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE REST AREA","county_code_state":"NY","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ONE SOURCE MILLWORK","shipping_paper_number":"231039","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:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2912707","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:19.000000Z","updated_at":"2025-03-17T20:08:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8595368,"change_date":"2024-03-21 21:40:00","inspection_id":"81161384","insp_unit_id":"200022146","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5255078,"change_date":"2024-03-11 21:43:00","inspection_id":"81071651","dot_number":"1228603","report_state":"NJ","report_number":"SPRJI00794","insp_date":"2024-03-07 00:00:00","insp_start_time":"0955","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH SCALE WB","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1199074","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-03-11 21:43:00","snet_input_date":"2024-03-07 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-03-11 21:43:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:42.000000Z","updated_at":"2025-03-17T20:06:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8461914,"change_date":"2024-03-11 21:43:00","inspection_id":"81071651","insp_unit_id":"199845406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:41.000000Z","updated_at":"2025-03-17T23:11:41.000000Z"}]},{"id":4855576,"change_date":"2024-01-18 21:45:00","inspection_id":"80635243","dot_number":"1228603","report_state":"NY","report_number":"D103100123","insp_date":"2024-01-16 00:00:00","insp_start_time":"1150","insp_end_time":"1235","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"182804","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:52.000000Z","updated_at":"2025-03-17T19:58:52.000000Z","inspection_violations":[{"id":7484938,"change_date":"2024-01-18 21:45:00","inspection_id":"80635243","insp_violation_id":"257390820","seq_no":"1","part_no":"390","part_no_section":"21TB3-OPERBY","insp_viol_unit":"1","insp_unit_id":"199008838","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39021TB3OPERBY"}],"inspection_per_units":[{"id":7812385,"change_date":"2024-01-18 21:45:00","inspection_id":"80635243","insp_unit_id":"199008838","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:49.000000Z","updated_at":"2025-03-17T23:05:49.000000Z"}]},{"id":4770520,"change_date":"2024-01-05 21:45:00","inspection_id":"80542201","dot_number":"1228603","report_state":"NY","report_number":"D103000157","insp_date":"2024-01-04 00:00:00","insp_start_time":"1145","insp_end_time":"1205","registration_date":null,"region":"ES","ci_status_code":"C","location":"90442N","location_desc":"KIRKWOOD NY","county_code_state":"NY","county_code":"007","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-05 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"159713","transaction_code":"A","transaction_date":"2024-01-05 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2024-01-05 21:45:00","snet_input_date":"2024-01-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-05 21:45:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:16.000000Z","updated_at":"2025-03-17T19:57:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7674367,"change_date":"2024-01-05 21:45:00","inspection_id":"80542201","insp_unit_id":"198828277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:35.000000Z","updated_at":"2025-03-17T23:04:35.000000Z"}]},{"id":4557036,"change_date":"2023-12-18 21:41:00","inspection_id":"80308608","dot_number":"1228603","report_state":"NJ","report_number":"SPRCI01341","insp_date":"2023-12-04 00:00:00","insp_start_time":"0800","insp_end_time":"0846","registration_date":"2023-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"1217","location_desc":"PISCATAWAY SCALE","county_code_state":"NJ","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1182207","transaction_code":"C","transaction_date":"2023-12-04 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-12-05 21:42:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-12-05 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:02.000000Z","updated_at":"2025-03-17T19:53:02.000000Z","inspection_violations":[{"id":7048791,"change_date":"2023-12-18 21:41:00","inspection_id":"80308608","insp_violation_id":"256930478","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"198546106","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:01.000000Z","updated_at":"2025-03-17T21:40:01.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":7329056,"change_date":"2023-12-18 21:41:00","inspection_id":"80308608","insp_unit_id":"198546106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:34.000000Z","updated_at":"2025-03-17T23:01:34.000000Z"}]},{"id":4279767,"change_date":"2023-10-25 21:41:00","inspection_id":"80002730","dot_number":"1228603","report_state":"NJ","report_number":"SPSDI00324","insp_date":"2023-10-23 00:00:00","insp_start_time":"0844","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GREENWICH WB SCALE","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1176060","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-10-25 21:41:00","snet_input_date":"2023-10-23 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-10-25 21:41:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:30.000000Z","updated_at":"2025-03-17T19:47:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6882949,"change_date":"2023-10-25 21:41:00","inspection_id":"80002730","insp_unit_id":"197735815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4590","insp_unit_license":"30995MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JVXK4S72014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:42.000000Z","updated_at":"2025-03-17T22:57:42.000000Z"}]},{"id":4232217,"change_date":"2023-10-19 21:40:00","inspection_id":"79950072","dot_number":"1228603","report_state":"US","report_number":"1323000045","insp_date":"2023-10-13 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":"78","location_desc":"BLOOMSBURY NJ","county_code_state":"NJ","county_code":"019","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"71962","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-10-19 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-19 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:38.000000Z","updated_at":"2025-03-17T19:46:38.000000Z","inspection_violations":[{"id":6552855,"change_date":"2023-10-19 21:40:00","inspection_id":"79950072","insp_violation_id":"255923875","seq_no":"1","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"197634037","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"3963A1OAL"}],"inspection_per_units":[{"id":6806534,"change_date":"2023-10-19 21:40:00","inspection_id":"79950072","insp_unit_id":"197634037","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:03.000000Z","updated_at":"2025-03-17T22:57:03.000000Z"}]},{"id":3875348,"change_date":"2023-08-31 21:42:00","inspection_id":"79554063","dot_number":"1228603","report_state":"NY","report_number":"0321005772","insp_date":"2023-08-30 00:00:00","insp_start_time":"1135","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690M","location_desc":"PREBLE REST AREA (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2864271","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2023-08-31 21:42:00","snet_input_date":"2023-08-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:24.000000Z","updated_at":"2025-03-17T19:39:24.000000Z","inspection_violations":[{"id":5989075,"change_date":"2023-08-31 21:42:00","inspection_id":"79554063","insp_violation_id":"255010655","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196833915","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3963A1"},{"id":5989076,"change_date":"2023-08-31 21:42:00","inspection_id":"79554063","insp_violation_id":"255010656","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196833915","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":6230265,"change_date":"2023-08-31 21:42:00","inspection_id":"79554063","insp_unit_id":"196833915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:21.000000Z","updated_at":"2025-03-17T22:52:21.000000Z"}]},{"id":3819702,"change_date":"2023-08-24 21:40:00","inspection_id":"79491784","dot_number":"1228603","report_state":"NY","report_number":"SPC0242179","insp_date":"2023-08-23 00:00:00","insp_start_time":"1245","insp_end_time":"1308","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2861856","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-08-24 21:40:00","snet_input_date":"2023-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-24 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY AND MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:07.000000Z","updated_at":"2025-03-17T19:38:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6141272,"change_date":"2023-08-24 21:40:00","inspection_id":"79491784","insp_unit_id":"196702395","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:36.000000Z","updated_at":"2025-03-17T22:51:36.000000Z"}]},{"id":3830068,"change_date":"2023-08-25 21:40:00","inspection_id":"79503468","dot_number":"1228603","report_state":"NY","report_number":"SPC0179140","insp_date":"2023-08-22 00:00:00","insp_start_time":"1307","insp_end_time":"1323","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2862449","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-08-25 21:40:00","snet_input_date":"2023-08-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-25 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY AND MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6157827,"change_date":"2023-08-25 21:40:00","inspection_id":"79503468","insp_unit_id":"196725267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"}]},{"id":3537424,"change_date":"2023-07-18 21:43:00","inspection_id":"79176130","dot_number":"1228603","report_state":"PA","report_number":"C050011178","insp_date":"2023-07-14 00:00:00","insp_start_time":"0935","insp_end_time":"1018","registration_date":"2023-07-17 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"PITTSTON","county_code_state":"PA","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CLEARWOOD","shipping_paper_number":"P-21-1096","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-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2365171","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-07-18 21:43:00","snet_input_date":"2023-07-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:51.000000Z","updated_at":"2025-03-17T19:32:51.000000Z","inspection_violations":[{"id":5453619,"change_date":"2023-07-18 21:43:00","inspection_id":"79176130","insp_violation_id":"254133062","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"3958F1"},{"id":5453620,"change_date":"2023-07-18 21:43:00","inspection_id":"79176130","insp_violation_id":"254133063","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"3958"},{"id":5453621,"change_date":"2023-07-18 21:43:00","inspection_id":"79176130","insp_violation_id":"254133064","seq_no":"3","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":5688004,"change_date":"2023-07-18 21:43:00","inspection_id":"79176130","insp_unit_id":"196065482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4590","insp_unit_license":"30995MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JVXK4S72014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:53.000000Z","updated_at":"2025-03-17T22:47:53.000000Z"}]},{"id":3484881,"change_date":"2023-07-12 21:40:00","inspection_id":"79117297","dot_number":"1228603","report_state":"NY","report_number":"SPD0234975","insp_date":"2023-07-11 00:00:00","insp_start_time":"1122","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445A","location_desc":"LAFAYETTE (NB)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2846059","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-07-12 21:40:00","snet_input_date":"2023-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY AND MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:03.000000Z","updated_at":"2025-03-17T19:32:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5603658,"change_date":"2023-07-12 21:40:00","inspection_id":"79117297","insp_unit_id":"195947732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4590","insp_unit_license":"30995MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JVXK4S72014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:13.000000Z","updated_at":"2025-03-17T22:47:13.000000Z"}]},{"id":3245927,"change_date":"2023-06-09 21:40:00","inspection_id":"78847998","dot_number":"1228603","report_state":"NJ","report_number":"SPRPI00242","insp_date":"2023-06-07 00:00:00","insp_start_time":"1152","insp_end_time":"1212","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARNEYS POINT SCALE","county_code_state":"NJ","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1159539","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-06-09 21:40:00","snet_input_date":"2023-06-07 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:19.000000Z","updated_at":"2025-03-17T19:27:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5220438,"change_date":"2023-06-09 21:40:00","inspection_id":"78847998","insp_unit_id":"195410565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"}]},{"id":3207183,"change_date":"2023-07-03 21:38:00","inspection_id":"78804413","dot_number":"1228603","report_state":"NJ","report_number":"SPSCI00008","insp_date":"2023-06-02 00:00:00","insp_start_time":"0834","insp_end_time":"0907","registration_date":"2023-06-05 00:00:00","region":"ET","ci_status_code":"C","location":"1710","location_desc":"CARNEYS POINT SCALE","county_code_state":"NJ","county_code":"033","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1158852","transaction_code":"C","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":null,"census_search_date":"2023-06-05 21:42:00","snet_input_date":"2023-06-02 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:28.000000Z","updated_at":"2025-03-17T19:26:28.000000Z","inspection_violations":[{"id":4941474,"change_date":"2023-07-03 21:38:00","inspection_id":"78804413","insp_violation_id":"253834920","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"1","insp_unit_id":"195797038","insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":5158143,"change_date":"2023-07-03 21:38:00","inspection_id":"78804413","insp_unit_id":"195797038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"}]},{"id":1992948,"change_date":"2022-12-21 21:39:00","inspection_id":"77424008","dot_number":"1228603","report_state":"NY","report_number":"SPD0280260","insp_date":"2022-12-19 00:00:00","insp_start_time":"0640","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854A","location_desc":"VERONA (EXIT 33)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CLEARWOOD CUSTOM CARPENTRY AND MILLWORK LLC","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-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2781973","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3206042,"change_date":"2022-12-21 21:39:00","inspection_id":"77424008","insp_unit_id":"192530112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:57.000000Z","updated_at":"2025-03-17T22:28:57.000000Z"}]},{"id":1674117,"change_date":"2022-11-04 21:37:00","inspection_id":"77058759","dot_number":"1228603","report_state":"NY","report_number":"SPC0241361","insp_date":"2022-11-03 00:00:00","insp_start_time":"1233","insp_end_time":"1249","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","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":"2022-11-04 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2766231","transaction_code":"A","transaction_date":"2022-11-04 00:00:00","upload_date":"2022-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-11-04 21:37:00","snet_input_date":"2022-11-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-04 21:37:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:27.000000Z","updated_at":"2025-03-17T18:57:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2692987,"change_date":"2022-11-04 21:37:00","inspection_id":"77058759","insp_unit_id":"191808043","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"}]},{"id":970209,"change_date":"2022-08-05 21:40:00","inspection_id":"76242901","dot_number":"1228603","report_state":"NY","report_number":"MC63001007","insp_date":"2022-08-04 00:00:00","insp_start_time":"1135","insp_end_time":"1144","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690M","location_desc":"PREBLE REST AREA (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-08-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2735488","transaction_code":"A","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-08-05 21:40:00","snet_input_date":"2022-08-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-05 21:40:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:46.000000Z","updated_at":"2025-03-17T18:44:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1561077,"change_date":"2022-08-05 21:40:00","inspection_id":"76242901","insp_unit_id":"190150947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5103","insp_unit_license":"63574MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV7G4S62418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:50.000000Z","updated_at":"2025-03-17T22:17:50.000000Z"}]},{"id":961860,"change_date":"2022-08-04 21:42:00","inspection_id":"76233066","dot_number":"1228603","report_state":"NY","report_number":"SPC0241106","insp_date":"2022-08-03 00:00:00","insp_start_time":"1337","insp_end_time":"1353","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"3","service_center":"EA","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":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2735268","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-08-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:43.000000Z","updated_at":"2025-03-17T18:44:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1547571,"change_date":"2022-08-04 21:42:00","inspection_id":"76233066","insp_unit_id":"190129535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5103","insp_unit_license":"63574MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV7G4S62418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:44.000000Z","updated_at":"2025-03-17T22:17:44.000000Z"}]},{"id":961987,"change_date":"2022-08-04 21:42:00","inspection_id":"76233208","dot_number":"1228603","report_state":"NY","report_number":"0518000512","insp_date":"2022-08-03 00:00:00","insp_start_time":"1012","insp_end_time":"1051","registration_date":null,"region":"ET","ci_status_code":"C","location":"40857R","location_desc":"VICTOR","county_code_state":"NY","county_code":"069","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2735098","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-08-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:43.000000Z","updated_at":"2025-03-17T18:44:43.000000Z","inspection_violations":[{"id":1516532,"change_date":"2022-08-04 21:42:00","inspection_id":"76233208","insp_violation_id":"247509338","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190129746","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1547751,"change_date":"2022-08-04 21:42:00","inspection_id":"76233208","insp_unit_id":"190129746","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"4620","insp_unit_license":"85449MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV9K4S71968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:44.000000Z","updated_at":"2025-03-17T22:17:44.000000Z"}]},{"id":736406,"change_date":"2022-07-01 21:38:00","inspection_id":"75969318","dot_number":"1228603","report_state":"NY","report_number":"SPF0144020","insp_date":"2022-06-22 00:00:00","insp_start_time":"1108","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","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":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"2723267","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1183389,"change_date":"2022-07-01 21:38:00","inspection_id":"75969318","insp_unit_id":"189569055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5103","insp_unit_license":"63574MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNJ8JV7G4S62418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":191269,"change_date":"2022-04-18 21:39:00","inspection_id":"75321059","dot_number":"1228603","report_state":"NY","report_number":"SPWD111180","insp_date":"2022-04-15 00:00:00","insp_start_time":"1145","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"30611","location_desc":"I-81 T\/ONONDAGA","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","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":"2022-04-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2696277","transaction_code":"A","transaction_date":"2022-04-18 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01228603","upload_search_indicator":"M","census_search_date":"2022-04-18 21:39:00","snet_input_date":"2022-04-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-18 21:39:00","insp_carrier_name":"CLEARWOOD CUSTOM CARPENTRY & MILLWORK LLC","insp_carrier_street":"617 W MANLIUS STREET","insp_carrier_city":"E SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13057","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:52.000000Z","updated_at":"2025-03-17T18:30:52.000000Z","inspection_violations":[{"id":292435,"change_date":"2022-04-18 21:39:00","inspection_id":"75321059","insp_violation_id":"245202334","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:23.000000Z","updated_at":"2025-03-17T21:08:23.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":309632,"change_date":"2022-04-18 21:39:00","inspection_id":"75321059","insp_unit_id":"188190528","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4631","insp_unit_license":"96039NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA9NS001891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:03.000000Z","updated_at":"2025-03-17T22:10:03.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1228603\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1228603\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1228603\/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\/1228603\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}