{"current_page":1,"data":[{"id":12479974,"change_date":"2026-07-17 21:42:00","inspection_id":"88441398","dot_number":"1474478","report_state":"NY","report_number":"SPD3021977","insp_date":"2026-07-10 00:00:00","insp_start_time":"1102","insp_end_time":"1118","registration_date":"2026-07-15 00:00:00","region":"ED","ci_status_code":"C","location":"20457E","location_desc":"CANASTOTA NY","county_code_state":"NY","county_code":"053","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING & SAWING INC","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":"2026-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3774079","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-07-17 21:42:00","snet_input_date":"2026-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:45.000000Z","updated_at":"2026-07-28T09:31:12.000000Z","inspection_violations":[{"id":21726795,"change_date":"2026-07-17 21:42:00","inspection_id":"88441398","insp_violation_id":"275573649","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:23.000000Z","updated_at":"2026-07-28T09:43:15.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":21675593,"change_date":"2026-07-17 21:42:00","inspection_id":"88441398","insp_unit_id":"214672737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"64422NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NPLHD6HX7M671448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:21:16.000000Z","updated_at":"2026-07-28T09:02:38.000000Z"}]},{"id":12035410,"change_date":"2026-05-28 21:41:00","inspection_id":"87975714","dot_number":"1474478","report_state":"NY","report_number":"SPC3061282","insp_date":"2026-05-21 00:00:00","insp_start_time":"0837","insp_end_time":"0902","registration_date":"2026-05-27 00:00:00","region":"ED","ci_status_code":"C","location":"70618M","location_desc":"LA FARGEVILLE NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JPW ERECTORS","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":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"3415188","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-05-28 21:41:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:39:50.000000Z","updated_at":"2026-06-08T09:30:35.000000Z","inspection_violations":[{"id":20943722,"change_date":"2026-05-28 21:41:00","inspection_id":"87975714","insp_violation_id":"274546559","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"213788146","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-01T09:59:01.000000Z","updated_at":"2026-06-08T09:42:05.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":20919120,"change_date":"2026-05-28 21:41:00","inspection_id":"87975714","insp_unit_id":"213788146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:16:59.000000Z","updated_at":"2026-06-08T09:01:59.000000Z"}]},{"id":11994625,"change_date":"2026-05-22 21:38:00","inspection_id":"87932745","dot_number":"1474478","report_state":"NY","report_number":"D305401587","insp_date":"2026-05-21 00:00:00","insp_start_time":"0835","insp_end_time":"0853","registration_date":null,"region":"ED","ci_status_code":"C","location":"70618M","location_desc":"LA FARGEVILLE NY","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING & SAWING INC","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":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"3384262","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:14.000000Z","updated_at":"2026-06-02T09:32:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20851653,"change_date":"2026-05-22 21:38:00","inspection_id":"87932745","insp_unit_id":"213706609","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:19.000000Z","updated_at":"2026-06-02T09:05:22.000000Z"},{"id":20851654,"change_date":"2026-05-22 21:38:00","inspection_id":"87932745","insp_unit_id":"213706610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":"6022","insp_unit_license":"BN19274","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4LF2E4826R3559576","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:19.000000Z","updated_at":"2026-06-02T09:05:22.000000Z"}]},{"id":12007645,"change_date":"2026-05-25 21:34:00","inspection_id":"87946512","dot_number":"1474478","report_state":"NY","report_number":"SPD3021853","insp_date":"2026-05-18 00:00:00","insp_start_time":"1251","insp_end_time":"1259","registration_date":null,"region":"ED","ci_status_code":"C","location":"20832S","location_desc":"REMSEN NY","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING & SAWING INC","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":"2026-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3395700","transaction_code":"A","transaction_date":"2026-05-24 00:00:00","upload_date":"2026-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-05-25 21:34:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-25 21:34:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-28T09:39:19.000000Z","updated_at":"2026-06-06T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20873115,"change_date":"2026-05-25 21:34:00","inspection_id":"87946512","insp_unit_id":"213732280","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"90","insp_unit_license":"23752BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXX4EX3RD681096","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:41.000000Z","updated_at":"2026-06-06T09:01:04.000000Z"}]},{"id":11818031,"change_date":"2026-05-04 21:39:00","inspection_id":"87752362","dot_number":"1474478","report_state":"NY","report_number":"SPT3091584","insp_date":"2026-04-27 00:00:00","insp_start_time":"1245","insp_end_time":"1303","registration_date":null,"region":"ED","ci_status_code":"C","location":"30223A","location_desc":"EAST SYRACUSE NY","county_code_state":"NY","county_code":"067","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":"U","pen_cen_match":"I","final_status_date":"2026-05-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"167320","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":"3253835","transaction_code":"A","transaction_date":"2026-05-03 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-05-04 21:39:00","snet_input_date":"2026-04-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-04 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:38:59.000000Z","updated_at":"2026-05-14T12:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20555360,"change_date":"2026-05-04 21:39:00","inspection_id":"87752362","insp_unit_id":"213363762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"26","insp_unit_license":"CK61768","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3632TC087056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:35.000000Z","updated_at":"2026-05-14T11:48:38.000000Z"},{"id":20555359,"change_date":"2026-05-04 21:39:00","inspection_id":"87752362","insp_unit_id":"213363761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"69","insp_unit_license":"21708BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPED40X1SD698644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:35.000000Z","updated_at":"2026-05-14T11:48:38.000000Z"}]},{"id":11754145,"change_date":"2026-04-27 21:38:00","inspection_id":"87684118","dot_number":"1474478","report_state":"NY","report_number":"D305401516","insp_date":"2026-04-23 00:00:00","insp_start_time":"0801","insp_end_time":"0849","registration_date":null,"region":"ED","ci_status_code":"C","location":"30762W","location_desc":"OSWEGO NY","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYRACUSE SAND & GRAVEL LLC","shipping_paper_number":"1282665","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"167320","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":"3216462","transaction_code":"A","transaction_date":"2026-04-26 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-04-27 21:38:00","snet_input_date":"2026-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-27 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-30T09:39:28.000000Z","updated_at":"2026-05-08T09:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20450480,"change_date":"2026-04-27 21:38:00","inspection_id":"87684118","insp_unit_id":"213236591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"TRL-1","insp_unit_license":"CG42111","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3632RC073490","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:12.000000Z","updated_at":"2026-05-08T09:02:14.000000Z"},{"id":20450481,"change_date":"2026-04-27 21:38:00","inspection_id":"87684118","insp_unit_id":"213236592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"84","insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:12.000000Z","updated_at":"2026-05-08T09:02:14.000000Z"}]},{"id":11704681,"change_date":"2026-04-21 21:38:00","inspection_id":"87631267","dot_number":"1474478","report_state":"NY","report_number":"SPC3011871","insp_date":"2026-04-14 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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":"2026-04-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3186815","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:37:14.000000Z","updated_at":"2026-05-02T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20369081,"change_date":"2026-04-21 21:38:00","inspection_id":"87631267","insp_unit_id":"213128655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"71","insp_unit_license":"71183ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXX4EX1JD460729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:12.000000Z","updated_at":"2026-05-02T09:02:19.000000Z"}]},{"id":11660379,"change_date":"2026-04-16 21:40:00","inspection_id":"87590368","dot_number":"1474478","report_state":"NY","report_number":"SPT3081561","insp_date":"2026-04-09 00:00:00","insp_start_time":"1139","insp_end_time":"1228","registration_date":"2026-04-10 00:00:00","region":"ED","ci_status_code":"C","location":"30100M","location_desc":"WEEDSPORT NY","county_code_state":"NY","county_code":"011","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":"2026-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"146320","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":"3163697","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-04-16 21:40:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-16 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"142 USYK DRIVE","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:49.000000Z","updated_at":"2026-04-27T09:30:49.000000Z","inspection_violations":[{"id":20251246,"change_date":"2026-04-16 21:40:00","inspection_id":"87590368","insp_violation_id":"273635422","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213042632","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:27.000000Z","updated_at":"2026-04-27T09:43:27.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":20283292,"change_date":"2026-04-16 21:40:00","inspection_id":"87590368","insp_unit_id":"213042632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"89","insp_unit_license":"21708BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPED40X1SD698644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:03:31.000000Z","updated_at":"2026-04-27T09:03:31.000000Z"},{"id":20283293,"change_date":"2026-04-16 21:40:00","inspection_id":"87590368","insp_unit_id":"213042633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"TRL24","insp_unit_license":"CF27845","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124816P3217791","insp_unit_decal":"Y","insp_unit_decal_number":"36371616","created_at":"2026-04-27T09:03:31.000000Z","updated_at":"2026-04-27T09:03:31.000000Z"}]},{"id":11320847,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","dot_number":"1474478","report_state":"NY","report_number":"D305502844","insp_date":"2026-03-06 00:00:00","insp_start_time":"0734","insp_end_time":"1020","registration_date":"2026-04-02 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"PARISH NY","county_code_state":"NY","county_code":"075","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2026-03-08 21:33:00","post_acc_ind":"Y","gross_comb_veh_wt":"188000","viol_total":"16","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":"2979849","transaction_code":"C","transaction_date":"2026-03-08 00:00:00","upload_date":"2026-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:23.000000Z","updated_at":"2026-04-14T09:31:07.000000Z","inspection_violations":[{"id":19545155,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853457","seq_no":"1","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:09.000000Z","normalized_code":"39311A1LFTSM"},{"id":19545156,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853458","seq_no":"2","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:09.000000Z","normalized_code":"39311A1LHLM"},{"id":19545157,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853459","seq_no":"3","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:09.000000Z","normalized_code":"39311A1LSML"},{"id":19545158,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853460","seq_no":"4","part_no":"393","part_no_section":"201A-FRBFC","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"393201AFRBFC"},{"id":19545159,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853461","seq_no":"5","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"393203CCBP"},{"id":19545160,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853462","seq_no":"6","part_no":"393","part_no_section":"205A-WRDC","insp_viol_unit":"2","insp_unit_id":"212528279","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"393205AWRDC"},{"id":19545161,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853463","seq_no":"7","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"393207ASTCB"},{"id":19545162,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853464","seq_no":"8","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39360C"},{"id":19545164,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853466","seq_no":"10","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"393207ASUBL"},{"id":19545166,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853468","seq_no":"12","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39345DBAAL"},{"id":19545167,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853469","seq_no":"13","part_no":"393","part_no_section":"70B1I-CDFWC-MT20","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39370B1ICDFWCMT20"},{"id":19545168,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853470","seq_no":"14","part_no":"393","part_no_section":"75A3-TAOLTIS","insp_viol_unit":"2","insp_unit_id":"212528279","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39375A3TAOLTIS"},{"id":19545169,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853471","seq_no":"15","part_no":"396","part_no_section":"3A1-DLDSCBBP","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"3963A1DLDSCBBP"},{"id":19545170,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853472","seq_no":"16","part_no":"396","part_no_section":"3A1-F","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"3963A1F"},{"id":19545165,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853467","seq_no":"11","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39345DBAAL"},{"id":19545163,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_violation_id":"272853465","seq_no":"9","part_no":"393","part_no_section":"83E","insp_viol_unit":"1","insp_unit_id":"212528278","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:09.000000Z","updated_at":"2026-04-13T10:11:10.000000Z","normalized_code":"39383E"}],"inspection_per_units":[{"id":19817325,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_unit_id":"212528278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"73","insp_unit_license":"27361TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBTXXYN532627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:25.000000Z","updated_at":"2026-04-14T09:02:26.000000Z"},{"id":19817326,"change_date":"2026-04-03 21:37:00","inspection_id":"87237502","insp_unit_id":"212528279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"18","insp_unit_license":"CA43526","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3631MC059945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:25.000000Z","updated_at":"2026-04-14T09:02:26.000000Z"}]},{"id":11351916,"change_date":"2026-03-12 21:39:00","inspection_id":"87270089","dot_number":"1474478","report_state":"NY","report_number":"SPD3061593","insp_date":"2026-03-05 00:00:00","insp_start_time":"1151","insp_end_time":"1213","registration_date":"2026-03-06 00:00:00","region":"ES","ci_status_code":"C","location":"22058M","location_desc":"UTICA NY","county_code_state":"NY","county_code":"065","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":"2026-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"146320","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":"2994399","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-03-12 21:39:00","snet_input_date":"2026-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-12 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-15T09:39:52.000000Z","updated_at":"2026-03-23T09:31:01.000000Z","inspection_violations":[{"id":19123647,"change_date":"2026-03-12 21:39:00","inspection_id":"87270089","insp_violation_id":"272357667","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"212098649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-15T10:03:16.000000Z","updated_at":"2026-03-23T09:47:30.000000Z","normalized_code":"39355C1B"}],"inspection_per_units":[{"id":19427793,"change_date":"2026-03-12 21:39:00","inspection_id":"87270089","insp_unit_id":"212098650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"19","insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:36.000000Z","updated_at":"2026-03-23T09:08:46.000000Z"},{"id":19427792,"change_date":"2026-03-12 21:39:00","inspection_id":"87270089","insp_unit_id":"212098649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:36.000000Z","updated_at":"2026-03-23T09:08:46.000000Z"}]},{"id":11462502,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","dot_number":"1474478","report_state":"VT","report_number":"4200002407","insp_date":"2026-01-02 00:00:00","insp_start_time":"1007","insp_end_time":"1029","registration_date":null,"region":"ES","ci_status_code":"C","location":"1005NB","location_desc":"VT","county_code_state":"VT","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MILTON CAT","shipping_paper_number":"2026860","cargo_tank":null,"hazmat_placard_req":"N","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3058911","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-01-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:22.000000Z","updated_at":"2026-04-04T09:30:48.000000Z","inspection_violations":[{"id":19345066,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","insp_violation_id":"272602008","seq_no":"1","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"212304166","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-27T10:10:04.000000Z","updated_at":"2026-04-03T09:54:14.000000Z","normalized_code":"393130CCHVE"},{"id":19345067,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","insp_violation_id":"272602009","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212304165","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:10:04.000000Z","updated_at":"2026-04-03T09:54:14.000000Z","normalized_code":"39395A4EEUS"},{"id":19345068,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","insp_violation_id":"272602010","seq_no":"3","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"212304166","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-27T10:10:04.000000Z","updated_at":"2026-04-03T09:54:14.000000Z","normalized_code":"39343DBMA"}],"inspection_per_units":[{"id":19633469,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","insp_unit_id":"212304165","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":null,"insp_unit_license":"60098NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FTRF3BT7REF21568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:58.000000Z","updated_at":"2026-04-04T09:04:13.000000Z"},{"id":19633470,"change_date":"2026-03-24 21:40:00","inspection_id":"87380584","insp_unit_id":"212304166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"CH74501","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4P51C3026S1414983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:58.000000Z","updated_at":"2026-04-04T09:04:13.000000Z"}]},{"id":10396621,"change_date":"2025-12-10 21:38:00","inspection_id":"86526674","dot_number":"1474478","report_state":"NY","report_number":"SPA3021272","insp_date":"2025-12-03 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"ES","ci_status_code":"C","location":"40218R","location_desc":"DARIEN CENTER NY","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CRANESVILLE BLOCK","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":"U","pen_cen_match":"I","final_status_date":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2635803","transaction_code":"A","transaction_date":"2025-12-09 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:35.000000Z","updated_at":"2025-12-14T10:30:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17383371,"change_date":"2025-12-10 21:38:00","inspection_id":"86526674","insp_unit_id":"210520387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"84","insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:47.000000Z","updated_at":"2025-12-14T10:00:49.000000Z"},{"id":17383372,"change_date":"2025-12-10 21:38:00","inspection_id":"86526674","insp_unit_id":"210520388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"TRL 22","insp_unit_license":"CF27745","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TTE482C4K3128053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:47.000000Z","updated_at":"2025-12-14T10:00:49.000000Z"}]},{"id":9860717,"change_date":"2025-10-06 21:39:00","inspection_id":"85963140","dot_number":"1474478","report_state":"NY","report_number":"SPT3100974","insp_date":"2025-09-29 00:00:00","insp_start_time":"1240","insp_end_time":"1244","registration_date":null,"region":"ED","ci_status_code":"C","location":"20330R","location_desc":"FULTONVILLE NY","county_code_state":"NY","county_code":"057","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":"U","pen_cen_match":"I","final_status_date":"2025-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"77500","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":"2369531","transaction_code":"A","transaction_date":"2025-10-05 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-10-06 21:39:00","snet_input_date":"2025-09-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-06 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:28.000000Z","updated_at":"2025-10-10T10:00:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16353592,"change_date":"2025-10-06 21:39:00","inspection_id":"85963140","insp_unit_id":"209308348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"78","insp_unit_license":"65780ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBEX75N853030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:34.000000Z","updated_at":"2025-10-10T09:45:21.000000Z"}]},{"id":9220149,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","dot_number":"1474478","report_state":"NY","report_number":"SPE3000167","insp_date":"2025-07-16 00:00:00","insp_start_time":"1308","insp_end_time":"1331","registration_date":"2025-07-23 00:00:00","region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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":"2025-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","viol_total":"3","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":"2028339","transaction_code":"C","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-07-23 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-23 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:24.000000Z","updated_at":"2025-09-10T10:45:16.000000Z","inspection_violations":[{"id":15663334,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","insp_violation_id":"268455903","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208744391","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:23.000000Z","normalized_code":"39378AWS"},{"id":15663335,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","insp_violation_id":"268455904","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"1","insp_unit_id":"208744391","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:23.000000Z","normalized_code":"39355EB"},{"id":15663336,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","insp_violation_id":"268455905","seq_no":"3","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208744391","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:23.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":15827770,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","insp_unit_id":"208744391","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:04.000000Z"},{"id":15827771,"change_date":"2025-09-04 21:40:00","inspection_id":"85290201","insp_unit_id":"208744392","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"19","insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:04.000000Z"}]},{"id":9212359,"change_date":"2025-09-04 21:40:00","inspection_id":"85282093","dot_number":"1474478","report_state":"NY","report_number":"SPT3041068","insp_date":"2025-07-16 00:00:00","insp_start_time":"0743","insp_end_time":"0810","registration_date":"2025-07-23 00:00:00","region":"ED","ci_status_code":"C","location":"40354S","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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":"2025-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"146823","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":"2024875","transaction_code":"C","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-07-22 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:46.000000Z","updated_at":"2025-09-10T10:45:16.000000Z","inspection_violations":[{"id":15663315,"change_date":"2025-09-04 21:40:00","inspection_id":"85282093","insp_violation_id":"268455671","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"208744263","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:22.000000Z","normalized_code":"39355C1B"},{"id":15663316,"change_date":"2025-09-04 21:40:00","inspection_id":"85282093","insp_violation_id":"268455672","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"208744264","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:42:39.000000Z","updated_at":"2025-09-10T10:46:22.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":15827759,"change_date":"2025-09-04 21:40:00","inspection_id":"85282093","insp_unit_id":"208744263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:04.000000Z"},{"id":15827760,"change_date":"2025-09-04 21:40:00","inspection_id":"85282093","insp_unit_id":"208744264","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"TLR14","insp_unit_license":"BU34674","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XL3193375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-10T09:45:04.000000Z"}]},{"id":8791719,"change_date":"2025-06-02 21:39:00","inspection_id":"84837942","dot_number":"1474478","report_state":"NY","report_number":"SPD3050786","insp_date":"2025-05-27 00:00:00","insp_start_time":"0740","insp_end_time":"0808","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FRANKFORT NY","county_code_state":"NY","county_code":"043","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":"U","pen_cen_match":"I","final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1810122","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-06-02 21:39:00","snet_input_date":"2025-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:24.000000Z","updated_at":"2025-06-06T10:00:16.000000Z","inspection_violations":[{"id":14058669,"change_date":"2025-06-02 21:39:00","inspection_id":"84837942","insp_violation_id":"266603154","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207174524","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-05T10:15:33.000000Z","updated_at":"2025-06-06T10:15:28.000000Z","normalized_code":"39375A3TAOL"},{"id":14058670,"change_date":"2025-06-02 21:39:00","inspection_id":"84837942","insp_violation_id":"266603155","seq_no":"2","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"1","insp_unit_id":"207174524","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:33.000000Z","updated_at":"2025-06-06T10:15:28.000000Z","normalized_code":"39311A1LSML"},{"id":14058671,"change_date":"2025-06-02 21:39:00","inspection_id":"84837942","insp_violation_id":"266603156","seq_no":"3","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"207174524","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:33.000000Z","updated_at":"2025-06-06T10:15:28.000000Z","normalized_code":"39355D1B"}],"inspection_per_units":[{"id":14386769,"change_date":"2025-06-02 21:39:00","inspection_id":"84837942","insp_unit_id":"207174524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"75","insp_unit_license":"12915MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"FLA68480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:23.000000Z","updated_at":"2025-06-06T09:45:19.000000Z"}]},{"id":8800565,"change_date":"2025-06-03 21:40:00","inspection_id":"84847178","dot_number":"1474478","report_state":"NY","report_number":"SPD3050792","insp_date":"2025-05-27 00:00:00","insp_start_time":"1355","insp_end_time":"1424","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FRANKFORT NY","county_code_state":"NY","county_code":"043","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":"U","pen_cen_match":"I","final_status_date":"2025-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","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":"1812934","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:02.000000Z","updated_at":"2025-06-07T10:00:15.000000Z","inspection_violations":[{"id":14076850,"change_date":"2025-06-03 21:40:00","inspection_id":"84847178","insp_violation_id":"266622096","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207192246","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:29.000000Z","updated_at":"2025-06-07T10:16:55.000000Z","normalized_code":"39021TB2DOT"},{"id":14076851,"change_date":"2025-06-03 21:40:00","inspection_id":"84847178","insp_violation_id":"266622097","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"207192246","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:29.000000Z","updated_at":"2025-06-07T10:16:55.000000Z","normalized_code":"39360D"},{"id":14076852,"change_date":"2025-06-03 21:40:00","inspection_id":"84847178","insp_violation_id":"266622098","seq_no":"3","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"207192246","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:29.000000Z","updated_at":"2025-06-07T10:16:55.000000Z","normalized_code":"39355D1B"}],"inspection_per_units":[{"id":14404356,"change_date":"2025-06-03 21:40:00","inspection_id":"84847178","insp_unit_id":"207192246","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"88","insp_unit_license":"75898NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXGGGGX0D458037","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:41.000000Z","updated_at":"2025-06-07T09:45:16.000000Z"}]},{"id":8695949,"change_date":"2025-05-21 21:41:00","inspection_id":"84736502","dot_number":"1474478","report_state":"NY","report_number":"SPC3030760","insp_date":"2025-05-14 00:00:00","insp_start_time":"1609","insp_end_time":"1625","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"ALDRICH TRUCKING AND SAWING INC","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-05-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72500","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":"1758805","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-05-21 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-21 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:03:41.000000Z","updated_at":"2025-05-25T10:04:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14208993,"change_date":"2025-05-21 21:41:00","inspection_id":"84736502","insp_unit_id":"206980271","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"85","insp_unit_license":"71149ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NPXX4EX4KD228255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:27.000000Z","updated_at":"2025-05-25T09:49:16.000000Z"}]},{"id":8206899,"change_date":"2025-03-26 21:40:00","inspection_id":"84222058","dot_number":"1474478","report_state":"NY","report_number":"SPT3030997","insp_date":"2025-03-19 00:00:00","insp_start_time":"0925","insp_end_time":"0946","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854W","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"FREEMAN JAY BYLER","shipping_paper_number":"0031","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-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"1513478","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-03-26 21:40:00","snet_input_date":"2025-03-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-26 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-29T10:20:58.000000Z","updated_at":"2025-03-30T10:34:15.000000Z","inspection_violations":[{"id":12872048,"change_date":"2025-03-26 21:40:00","inspection_id":"84222058","insp_violation_id":"265246389","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205983211","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:52:28.000000Z","updated_at":"2025-03-29T10:31:00.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":13270718,"change_date":"2025-03-26 21:40:00","inspection_id":"84222058","insp_unit_id":"205983211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:02.000000Z","updated_at":"2025-03-30T09:55:27.000000Z"},{"id":13270719,"change_date":"2025-03-26 21:40:00","inspection_id":"84222058","insp_unit_id":"205983212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-29T10:02:02.000000Z","updated_at":"2025-03-30T09:55:27.000000Z"}]},{"id":8076730,"change_date":"2025-03-11 21:40:00","inspection_id":"84084485","dot_number":"1474478","report_state":"NY","report_number":"SPC3060182","insp_date":"2025-03-04 00:00:00","insp_start_time":"0904","insp_end_time":"0930","registration_date":null,"region":"ES","ci_status_code":"C","location":"9077W","location_desc":"UNADILLA NY","county_code_state":"NY","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING","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":"U","pen_cen_match":"I","final_status_date":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"167320","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":"1454092","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[{"id":12622262,"change_date":"2025-03-11 21:40:00","inspection_id":"84084485","insp_violation_id":"264932699","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"205721781","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:49.000000Z","updated_at":"2025-03-17T22:07:49.000000Z","normalized_code":"39355D2B"},{"id":12622263,"change_date":"2025-03-11 21:40:00","inspection_id":"84084485","insp_violation_id":"264932700","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"1","insp_unit_id":"205721781","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:49.000000Z","updated_at":"2025-03-17T22:07:49.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":13040472,"change_date":"2025-03-11 21:40:00","inspection_id":"84084485","insp_unit_id":"205721781","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"77","insp_unit_license":"30265TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9MD749304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:10.000000Z","updated_at":"2025-03-17T23:59:10.000000Z"},{"id":13040473,"change_date":"2025-03-11 21:40:00","inspection_id":"84084485","insp_unit_id":"205721782","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"8","insp_unit_license":"BL96170","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3639JC041723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:10.000000Z","updated_at":"2025-03-17T23:59:10.000000Z"}]},{"id":8066636,"change_date":"2025-03-10 21:38:00","inspection_id":"84073889","dot_number":"1474478","report_state":"NY","report_number":"SPB4000023","insp_date":"2025-03-03 00:00:00","insp_start_time":"1304","insp_end_time":"1320","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GOUVERNEUR NY","county_code_state":"NY","county_code":null,"insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NATIONAL GRID","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-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"91500","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":"1450141","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-03-10 21:38:00","snet_input_date":"2025-03-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-10 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:50.000000Z","updated_at":"2025-03-17T21:05:50.000000Z","inspection_violations":[{"id":12607407,"change_date":"2025-03-10 21:38:00","inspection_id":"84073889","insp_violation_id":"264913654","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","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:07:42.000000Z","updated_at":"2025-03-17T22:07:42.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":13024623,"change_date":"2025-03-10 21:38:00","inspection_id":"84073889","insp_unit_id":"205703289","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:54.000000Z","updated_at":"2025-03-17T23:58:54.000000Z"},{"id":13024624,"change_date":"2025-03-10 21:38:00","inspection_id":"84073889","insp_unit_id":"205703290","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":null,"insp_unit_license":"BU22086","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAPA4828GA037738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:54.000000Z","updated_at":"2025-03-17T23:58:54.000000Z"}]},{"id":7882143,"change_date":"2025-02-17 21:35:00","inspection_id":"83880188","dot_number":"1474478","report_state":"NY","report_number":"SPB3050280","insp_date":"2025-02-10 00:00:00","insp_start_time":"0930","insp_end_time":"0953","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"NORTH LAWRENCE NY","county_code_state":"NY","county_code":null,"insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING","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-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"1368236","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:57.000000Z","updated_at":"2025-03-17T21:01:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12722445,"change_date":"2025-02-17 21:35:00","inspection_id":"83880188","insp_unit_id":"205347944","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"},{"id":12722446,"change_date":"2025-02-17 21:35:00","inspection_id":"83880188","insp_unit_id":"205347945","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"19","insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"}]},{"id":7680875,"change_date":"2025-01-22 21:39:00","inspection_id":"83668689","dot_number":"1474478","report_state":"NY","report_number":"SPD3070362","insp_date":"2025-01-15 00:00:00","insp_start_time":"1046","insp_end_time":"1109","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING & SAWING INC","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-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1275485","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12394130,"change_date":"2025-01-22 21:39:00","inspection_id":"83668689","insp_unit_id":"204951067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:46.000000Z","updated_at":"2025-03-17T23:51:46.000000Z"},{"id":12394131,"change_date":"2025-01-22 21:39:00","inspection_id":"83668689","insp_unit_id":"204951068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"16","insp_unit_license":"BU22086","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAPA4828GA037738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:46.000000Z","updated_at":"2025-03-17T23:51:46.000000Z"}]},{"id":7553159,"change_date":"2025-01-06 21:39:00","inspection_id":"83534573","dot_number":"1474478","report_state":"NY","report_number":"SPD3010422","insp_date":"2024-12-31 00:00:00","insp_start_time":"0838","insp_end_time":"0853","registration_date":null,"region":"ES","ci_status_code":"C","location":"20457E","location_desc":"CANASTOTA NY","county_code_state":"NY","county_code":"053","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"RYAN ALDRICH TRUCKING & SAWING INC","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-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"221600","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":"1218689","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2024-12-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12186938,"change_date":"2025-01-06 21:39:00","inspection_id":"83534573","insp_unit_id":"204660935","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"80","insp_unit_license":"31357TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EXXLD715905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"},{"id":12186939,"change_date":"2025-01-06 21:39:00","inspection_id":"83534573","insp_unit_id":"204660936","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALBERT MF","insp_unit_company":"23","insp_unit_license":"CF27801","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5334N1042062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7182380,"change_date":"2024-11-13 21:39:00","inspection_id":"83144186","dot_number":"1474478","report_state":"NY","report_number":"SPB3100060","insp_date":"2024-11-07 00:00:00","insp_start_time":"0839","insp_end_time":"0858","registration_date":null,"region":"ES","ci_status_code":"C","location":"71494R","location_desc":"TUPPER LAKE NY","county_code_state":"NY","county_code":"033","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-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"221306","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":"1047264","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-11-13 21:39:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-13 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:59.000000Z","updated_at":"2025-03-17T20:45:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11584916,"change_date":"2024-11-13 21:39:00","inspection_id":"83144186","insp_unit_id":"203856906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"80","insp_unit_license":"31357TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EXXLD715905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"},{"id":11584917,"change_date":"2024-11-13 21:39:00","inspection_id":"83144186","insp_unit_id":"203856907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALBERT MF","insp_unit_company":"23","insp_unit_license":"CF27801","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5334N1042062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"}]},{"id":6976802,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","dot_number":"1474478","report_state":"NY","report_number":"SPB3110057","insp_date":"2024-10-10 00:00:00","insp_start_time":"1217","insp_end_time":"1258","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHATEAUGAY NY","county_code_state":"NY","county_code":"033","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140920","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"953668","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-10-17 21:41:00","snet_input_date":"2024-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-17 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:27.000000Z","updated_at":"2025-03-17T20:41:27.000000Z","inspection_violations":[{"id":10880792,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","insp_violation_id":"262394173","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39216D"},{"id":10880793,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","insp_violation_id":"262394174","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"203447399","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8B10JKQW7B","created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39375A3TAOL"},{"id":10880794,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","insp_violation_id":"262394175","seq_no":"3","part_no":"393","part_no_section":"55D3-B","insp_viol_unit":"1","insp_unit_id":"203447399","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39355D3B"}],"inspection_per_units":[{"id":11252988,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","insp_unit_id":"203447399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"},{"id":11252989,"change_date":"2024-10-17 21:41:00","inspection_id":"82926087","insp_unit_id":"203447400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"16","insp_unit_license":"BU22086","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAPA4828GA037738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:28.000000Z","updated_at":"2025-03-17T23:39:28.000000Z"}]},{"id":6966739,"change_date":"2024-10-16 21:40:00","inspection_id":"82915380","dot_number":"1474478","report_state":"NY","report_number":"SPD3030100","insp_date":"2024-10-09 00:00:00","insp_start_time":"1040","insp_end_time":"1055","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MUNNSVILLE NY","county_code_state":"NY","county_code":"053","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":"U","pen_cen_match":"I","final_status_date":"2024-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"949414","transaction_code":"A","transaction_date":"2024-10-16 00:00:00","upload_date":"2024-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-10-16 21:40:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-16 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:24.000000Z","updated_at":"2025-03-17T20:41:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11236418,"change_date":"2024-10-16 21:40:00","inspection_id":"82915380","insp_unit_id":"203426666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"65780ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBEX75N853030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:20.000000Z","updated_at":"2025-03-17T23:39:20.000000Z"}]},{"id":6869060,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","dot_number":"1474478","report_state":"NY","report_number":"SPD3030038","insp_date":"2024-09-25 00:00:00","insp_start_time":"1152","insp_end_time":"1218","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"FRANKFORT NY","county_code_state":"NY","county_code":"043","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":"U","pen_cen_match":"I","final_status_date":"2024-10-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"904325","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-10-02 21:40:00","snet_input_date":"2024-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-02 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:25.000000Z","updated_at":"2025-03-17T20:39:25.000000Z","inspection_violations":[{"id":10699860,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140544","seq_no":"1","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"203227588","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"39021TB1"},{"id":10699861,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140545","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203227588","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"3922"},{"id":10699862,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140546","seq_no":"3","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"203227589","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"39343D"},{"id":10699863,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140547","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203227588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"3939A"},{"id":10699864,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140548","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"39141A"},{"id":10699865,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_violation_id":"262140549","seq_no":"6","part_no":"391","part_no_section":"11(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:47.000000Z","updated_at":"2025-03-17T21:57:47.000000Z","normalized_code":"39111A"}],"inspection_per_units":[{"id":11077779,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_unit_id":"203227588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"41127MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF4HT9HEB30715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:43.000000Z","updated_at":"2025-03-17T23:37:43.000000Z"},{"id":11077780,"change_date":"2024-10-02 21:40:00","inspection_id":"82811574","insp_unit_id":"203227589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJTR","insp_unit_company":null,"insp_unit_license":"CH75401","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"4P51C3026S1414983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:43.000000Z","updated_at":"2025-03-17T23:37:43.000000Z"}]},{"id":6742644,"change_date":"2024-09-17 21:43:00","inspection_id":"82676804","dot_number":"1474478","report_state":"NY","report_number":"SPB3060014","insp_date":"2024-09-10 00:00:00","insp_start_time":"1550","insp_end_time":"1616","registration_date":null,"region":"ED","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","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-09-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"140321","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":"853526","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-09-17 21:43:00","snet_input_date":"2024-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-17 21:43:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:53.000000Z","updated_at":"2025-03-17T20:36:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10872474,"change_date":"2024-09-17 21:43:00","inspection_id":"82676804","insp_unit_id":"202957957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"},{"id":10872475,"change_date":"2024-09-17 21:43:00","inspection_id":"82676804","insp_unit_id":"202957958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"3","insp_unit_license":"BL27416","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124815G3157020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:37.000000Z","updated_at":"2025-03-17T23:35:37.000000Z"}]},{"id":6672377,"change_date":"2024-09-08 21:32:00","inspection_id":"82602256","dot_number":"1474478","report_state":"NY","report_number":"D305801146","insp_date":"2024-09-05 00:00:00","insp_start_time":"1308","insp_end_time":"1326","registration_date":null,"region":"ED","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SYRACUSE SAND & GRAVEL LLC","shipping_paper_number":"1226990","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-08 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"167321","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":"824757","transaction_code":"A","transaction_date":"2024-09-08 00:00:00","upload_date":"2024-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-09-08 21:32:00","snet_input_date":"2024-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-08 21:32:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:15.000000Z","updated_at":"2025-03-17T20:35:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10758091,"change_date":"2024-09-08 21:32:00","inspection_id":"82602256","insp_unit_id":"202811393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:23.000000Z","updated_at":"2025-03-17T23:34:23.000000Z"},{"id":10758092,"change_date":"2024-09-08 21:32:00","inspection_id":"82602256","insp_unit_id":"202811394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"18","insp_unit_license":"CA43526","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3631MC059945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:23.000000Z","updated_at":"2025-03-17T23:34:23.000000Z"}]},{"id":6678076,"change_date":"2024-09-09 21:40:00","inspection_id":"82608367","dot_number":"1474478","report_state":"NY","report_number":"SPD0310007","insp_date":"2024-09-03 00:00:00","insp_start_time":"1225","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2949619","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:17.000000Z","updated_at":"2025-03-17T20:35:17.000000Z","inspection_violations":[{"id":10393446,"change_date":"2024-09-09 21:40:00","inspection_id":"82608367","insp_violation_id":"261685450","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202822083","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10767108,"change_date":"2024-09-09 21:40:00","inspection_id":"82608367","insp_unit_id":"202822083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"},{"id":10767109,"change_date":"2024-09-09 21:40:00","inspection_id":"82608367","insp_unit_id":"202822084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"}]},{"id":6595132,"change_date":"2024-08-29 21:42:00","inspection_id":"82519854","dot_number":"1474478","report_state":"NY","report_number":"SPT0570404","insp_date":"2024-08-28 00:00:00","insp_start_time":"1445","insp_end_time":"1501","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854A","location_desc":"VERONA","county_code_state":"NY","county_code":"065","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2947763","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10632413,"change_date":"2024-08-29 21:42:00","inspection_id":"82519854","insp_unit_id":"202650374","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"80","insp_unit_license":"31357TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EXXLD715905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6408382,"change_date":"2024-08-07 21:40:00","inspection_id":"82320814","dot_number":"1474478","report_state":"NY","report_number":"D305801036","insp_date":"2024-08-02 00:00:00","insp_start_time":"0948","insp_end_time":"1019","registration_date":null,"region":"ED","ci_status_code":"C","location":"30223A","location_desc":"EAST SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"B&B LUMBER CO.","shipping_paper_number":"31032","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"173200","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":"723514","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-08-07 21:40:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-07 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:53.000000Z","updated_at":"2025-03-17T20:29:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10327765,"change_date":"2024-08-07 21:40:00","inspection_id":"82320814","insp_unit_id":"202271517","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":"TRL-4","insp_unit_license":"CG42307","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAMN5031RW077554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:01.000000Z","updated_at":"2025-03-17T23:30:01.000000Z"},{"id":10327766,"change_date":"2024-08-07 21:40:00","inspection_id":"82320814","insp_unit_id":"202271518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:01.000000Z","updated_at":"2025-03-17T23:30:01.000000Z"}]},{"id":6240866,"change_date":"2024-07-17 21:41:00","inspection_id":"82141544","dot_number":"1474478","report_state":"NY","report_number":"SPT0580262","insp_date":"2024-07-16 00:00:00","insp_start_time":"1024","insp_end_time":"1039","registration_date":null,"region":"ET","ci_status_code":"C","location":"21069R","location_desc":"CANAJOHARIE INTERCHANGE","county_code_state":"NY","county_code":"057","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"146320","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":"2937625","transaction_code":"A","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:34.000000Z","updated_at":"2025-03-17T20:26:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10055352,"change_date":"2024-07-17 21:41:00","inspection_id":"82141544","insp_unit_id":"201930146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETR","insp_unit_company":"77","insp_unit_license":"30265TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"RYAN ALDRICH TRUC","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:11.000000Z","updated_at":"2025-03-17T23:27:11.000000Z"},{"id":10055353,"change_date":"2024-07-17 21:41:00","inspection_id":"82141544","insp_unit_id":"201930147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"TRL24","insp_unit_license":"CF27845","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124816P3217791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:11.000000Z","updated_at":"2025-03-17T23:27:11.000000Z"}]},{"id":6092212,"change_date":"2024-06-27 21:40:00","inspection_id":"81981850","dot_number":"1474478","report_state":"NY","report_number":"SPC0270273","insp_date":"2024-06-25 00:00:00","insp_start_time":"1023","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","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":"2024-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2933105","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:23.000000Z","updated_at":"2025-03-17T20:23:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9812431,"change_date":"2024-06-27 21:40:00","inspection_id":"81981850","insp_unit_id":"201623017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:39.000000Z","updated_at":"2025-03-17T23:24:39.000000Z"},{"id":9812432,"change_date":"2024-06-27 21:40:00","inspection_id":"81981850","insp_unit_id":"201623018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"TRL 10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:39.000000Z","updated_at":"2025-03-17T23:24:39.000000Z"}]},{"id":5805217,"change_date":"2024-05-21 21:46:00","inspection_id":"81670790","dot_number":"1474478","report_state":"NY","report_number":"SPD0281620","insp_date":"2024-05-20 00:00:00","insp_start_time":"1105","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"20854","location_desc":"VERONA","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-21 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"77500","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":"2925190","transaction_code":"A","transaction_date":"2024-05-21 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-21 21:46:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:51.000000Z","updated_at":"2025-03-17T20:17:51.000000Z","inspection_violations":[{"id":8992260,"change_date":"2024-05-21 21:46:00","inspection_id":"81670790","insp_violation_id":"259637724","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201007181","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6J2H3L9","created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"39360D"},{"id":8992261,"change_date":"2024-05-21 21:46:00","inspection_id":"81670790","insp_violation_id":"259637725","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201007181","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:28.000000Z","updated_at":"2025-03-17T21:49:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9349581,"change_date":"2024-05-21 21:46:00","inspection_id":"81670790","insp_unit_id":"201007181","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"78","insp_unit_license":"65780ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBEX75N853030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:02.000000Z","updated_at":"2025-03-17T23:20:02.000000Z"}]},{"id":5817600,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","dot_number":"1474478","report_state":"NY","report_number":"SPG0206922","insp_date":"2024-05-16 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BASELINE CONST","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2925597","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-05-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[{"id":9012827,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_violation_id":"259668775","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201033211","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39360D"},{"id":9012828,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_violation_id":"259668776","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"201033211","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39355D1"},{"id":9012829,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_violation_id":"259668777","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201033211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39311"},{"id":9012830,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_violation_id":"259668778","seq_no":"4","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"201033212","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":9369369,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_unit_id":"201033211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"},{"id":9369370,"change_date":"2024-05-22 21:40:00","inspection_id":"81684480","insp_unit_id":"201033212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"CF27745","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TTE482C4K3128053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"}]},{"id":5563164,"change_date":"2024-04-22 21:40:00","inspection_id":"81407852","dot_number":"1474478","report_state":"NY","report_number":"SPT0541569","insp_date":"2024-04-19 00:00:00","insp_start_time":"0616","insp_end_time":"0640","registration_date":null,"region":"ET","ci_status_code":"C","location":"20802","location_desc":"HERKIMER (EXIT 30)","county_code_state":"NY","county_code":"043","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":"2024-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2918717","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-04-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-22 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:06.000000Z","updated_at":"2025-03-17T20:13:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8961188,"change_date":"2024-04-22 21:40:00","inspection_id":"81407852","insp_unit_id":"200504463","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:23.000000Z","updated_at":"2025-03-17T23:16:23.000000Z"},{"id":8961189,"change_date":"2024-04-22 21:40:00","inspection_id":"81407852","insp_unit_id":"200504464","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:23.000000Z","updated_at":"2025-03-17T23:16:23.000000Z"}]},{"id":5379603,"change_date":"2024-03-27 21:42:00","inspection_id":"81207274","dot_number":"1474478","report_state":"NY","report_number":"SPWB021005","insp_date":"2024-03-26 00:00:00","insp_start_time":"0916","insp_end_time":"0931","registration_date":null,"region":"ET","ci_status_code":"C","location":"10598A","location_desc":"HIGH PEAKS (SB)","county_code_state":"NY","county_code":"031","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"129062","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":"2913145","transaction_code":"A","transaction_date":"2024-03-26 00:00:00","upload_date":"2024-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2024-03-27 21:42:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-27 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:07.000000Z","updated_at":"2025-03-17T20:09:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8663754,"change_date":"2024-03-27 21:42:00","inspection_id":"81207274","insp_unit_id":"200110738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"},{"id":8663755,"change_date":"2024-03-27 21:42:00","inspection_id":"81207274","insp_unit_id":"200110739","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"14","insp_unit_license":"BU34674","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XL3193375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:34.000000Z","updated_at":"2025-03-17T23:13:34.000000Z"}]},{"id":5388612,"change_date":"2024-03-28 21:40:00","inspection_id":"81217022","dot_number":"1474478","report_state":"NY","report_number":"SPBB870033","insp_date":"2024-03-26 00:00:00","insp_start_time":"0912","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":"10598B","location_desc":"NORTH HUDSON (SB)","county_code_state":"NY","county_code":"031","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":"N","pen_cen_match":null,"final_status_date":"2024-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2913455","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-28 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:27.000000Z","updated_at":"2025-03-17T20:09:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8678513,"change_date":"2024-03-28 21:40:00","inspection_id":"81217022","insp_unit_id":"200132740","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:42.000000Z","updated_at":"2025-03-17T23:13:42.000000Z"},{"id":8678514,"change_date":"2024-03-28 21:40:00","inspection_id":"81217022","insp_unit_id":"200132741","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"TRL10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:42.000000Z","updated_at":"2025-03-17T23:13:42.000000Z"}]},{"id":4835823,"change_date":"2024-01-16 21:44:00","inspection_id":"80613763","dot_number":"1474478","report_state":"NY","report_number":"SPD0225743","insp_date":"2024-01-11 00:00:00","insp_start_time":"0936","insp_end_time":"0957","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"VIKING MAT COMPANY","shipping_paper_number":"51641","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-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"2899534","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[{"id":7456538,"change_date":"2024-01-16 21:44:00","inspection_id":"80613763","insp_violation_id":"257345674","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"198965642","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4HLLWGV","created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39355C1"}],"inspection_per_units":[{"id":7780080,"change_date":"2024-01-16 21:44:00","inspection_id":"80613763","insp_unit_id":"198965642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"80","insp_unit_license":"31357TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EXXLD715905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"},{"id":7780081,"change_date":"2024-01-16 21:44:00","inspection_id":"80613763","insp_unit_id":"198965643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"}]},{"id":4545803,"change_date":"2023-12-08 21:40:00","inspection_id":"80296318","dot_number":"1474478","report_state":"NY","report_number":"SPG0215200","insp_date":"2023-11-30 00:00:00","insp_start_time":"1420","insp_end_time":"1439","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","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-12-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"2891004","transaction_code":"C","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-12-04 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-04 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:58.000000Z","updated_at":"2025-03-17T19:52:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7310890,"change_date":"2023-12-08 21:40:00","inspection_id":"80296318","insp_unit_id":"198414175","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"},{"id":7310891,"change_date":"2023-12-08 21:40:00","inspection_id":"80296318","insp_unit_id":"198414176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5V8FY48A0NM014744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"}]},{"id":4398564,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","dot_number":"1474478","report_state":"NY","report_number":"SPG0224925","insp_date":"2023-11-09 00:00:00","insp_start_time":"0817","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753A","location_desc":"SCHODACK (WB)","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"56013","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-10 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"146320","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2885810","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-11-10 21:33:00","snet_input_date":"2023-11-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-10 21:33:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:55.000000Z","updated_at":"2025-03-17T19:49:55.000000Z","inspection_violations":[{"id":6806734,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_violation_id":"256328071","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198001014","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1HCW5RF","created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"39617C"},{"id":6806735,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_violation_id":"256328072","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"198001015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"3963A1"},{"id":6806736,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_violation_id":"256328073","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"198001014","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"39355D3"},{"id":6806737,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_violation_id":"256328074","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"198001014","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:46.000000Z","updated_at":"2025-03-17T21:38:46.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":7073725,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_unit_id":"198001014","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:22.000000Z","updated_at":"2025-03-17T22:59:22.000000Z"},{"id":7073726,"change_date":"2023-11-10 21:33:00","inspection_id":"80134262","insp_unit_id":"198001015","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:22.000000Z","updated_at":"2025-03-17T22:59:22.000000Z"}]},{"id":4358809,"change_date":"2023-11-08 21:40:00","inspection_id":"80089965","dot_number":"1474478","report_state":"NY","report_number":"SPC0179332","insp_date":"2023-10-31 00:00:00","insp_start_time":"1623","insp_end_time":"1638","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749A","location_desc":"SAUGERTIES","county_code_state":"NY","county_code":"111","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-11-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"2884563","transaction_code":"C","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-11-06 21:41:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-06 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:10.000000Z","updated_at":"2025-03-17T19:49:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7010067,"change_date":"2023-11-08 21:40:00","inspection_id":"80089965","insp_unit_id":"197963305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"78","insp_unit_license":"65780ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBEX75N853030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:51.000000Z","updated_at":"2025-03-17T22:58:51.000000Z"}]},{"id":4233689,"change_date":"2023-10-19 21:40:00","inspection_id":"79951665","dot_number":"1474478","report_state":"NY","report_number":"SPWG080861","insp_date":"2023-10-18 00:00:00","insp_start_time":"1252","insp_end_time":"1307","registration_date":null,"region":"ET","ci_status_code":"C","location":"10249","location_desc":"I-90 EAST","county_code_state":"NY","county_code":"083","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":"2023-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"2880630","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":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-19 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:39.000000Z","updated_at":"2025-03-17T19:46:39.000000Z","inspection_violations":[{"id":6555292,"change_date":"2023-10-19 21:40:00","inspection_id":"79951665","insp_violation_id":"255927894","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:37:34.000000Z","updated_at":"2025-03-17T21:37:34.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6808706,"change_date":"2023-10-19 21:40:00","inspection_id":"79951665","insp_unit_id":"197637126","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"54","insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"},{"id":6808707,"change_date":"2023-10-19 21:40:00","inspection_id":"79951665","insp_unit_id":"197637127","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:04.000000Z","updated_at":"2025-03-17T22:57:04.000000Z"}]},{"id":4141172,"change_date":"2023-10-06 21:40:00","inspection_id":"79849645","dot_number":"1474478","report_state":"NY","report_number":"SPD0291337","insp_date":"2023-10-03 00:00:00","insp_start_time":"0848","insp_end_time":"0925","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":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BINGHAMTON PRECAST AND SUPPLY CORP","shipping_paper_number":"85520","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-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121137","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":"2876267","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[{"id":6410393,"change_date":"2023-10-06 21:40:00","inspection_id":"79849645","insp_violation_id":"255695707","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197430725","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39311"},{"id":6410394,"change_date":"2023-10-06 21:40:00","inspection_id":"79849645","insp_violation_id":"255695708","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197430725","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6658537,"change_date":"2023-10-06 21:40:00","inspection_id":"79849645","insp_unit_id":"197430724","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"},{"id":6658538,"change_date":"2023-10-06 21:40:00","inspection_id":"79849645","insp_unit_id":"197430725","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":"9","insp_unit_license":"BN92264","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1LH855WJ6F1C21737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":4053957,"change_date":"2023-09-26 21:42:00","inspection_id":"79752603","dot_number":"1474478","report_state":"NY","report_number":"0325002509","insp_date":"2023-09-25 00:00:00","insp_start_time":"1010","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445M","location_desc":"LAFAYETTE REST AREA (SB)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","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":"I","final_status_date":"2023-09-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"169000","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":"2873012","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-26 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:49.000000Z","updated_at":"2025-03-17T19:42:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6518330,"change_date":"2023-09-26 21:42:00","inspection_id":"79752603","insp_unit_id":"197232878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"},{"id":6518331,"change_date":"2023-09-26 21:42:00","inspection_id":"79752603","insp_unit_id":"197232879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"18","insp_unit_license":"CA43526","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3631MC059945","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:42.000000Z","updated_at":"2025-03-17T22:54:42.000000Z"}]},{"id":3797555,"change_date":"2023-08-22 21:42:00","inspection_id":"79467053","dot_number":"1474478","report_state":"NY","report_number":"0117010140","insp_date":"2023-08-21 00:00:00","insp_start_time":"1251","insp_end_time":"1313","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK REST AREA (NB)","county_code_state":"NY","county_code":"091","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2860849","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-22 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:44.000000Z","updated_at":"2025-03-17T19:37:44.000000Z","inspection_violations":[{"id":5858174,"change_date":"2023-08-22 21:42:00","inspection_id":"79467053","insp_violation_id":"254791929","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39141A1"},{"id":5858175,"change_date":"2023-08-22 21:42:00","inspection_id":"79467053","insp_violation_id":"254791930","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196653715","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":6105846,"change_date":"2023-08-22 21:42:00","inspection_id":"79467053","insp_unit_id":"196653715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"88656MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD9X4HT6KED03746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:19.000000Z","updated_at":"2025-03-17T22:51:19.000000Z"}]},{"id":3720777,"change_date":"2023-08-11 21:38:00","inspection_id":"79381570","dot_number":"1474478","report_state":"NY","report_number":"SPC0216754","insp_date":"2023-08-09 00:00:00","insp_start_time":"0827","insp_end_time":"0847","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (NB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALDRICH TRUCKING AND SAWING","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-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2857269","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-08-11 21:38:00","snet_input_date":"2023-08-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-11 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:27.000000Z","updated_at":"2025-03-17T19:36:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5982435,"change_date":"2023-08-11 21:38:00","inspection_id":"79381570","insp_unit_id":"196482236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"73","insp_unit_license":"27361TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBTXXYN532627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:16.000000Z","updated_at":"2025-03-17T22:50:16.000000Z"},{"id":5982436,"change_date":"2023-08-11 21:38:00","inspection_id":"79381570","insp_unit_id":"196482237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"TRL21","insp_unit_license":"CD66390","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5339N1041862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:16.000000Z","updated_at":"2025-03-17T22:50:16.000000Z"}]},{"id":3628242,"change_date":"2023-07-31 21:40:00","inspection_id":"79277916","dot_number":"1474478","report_state":"NY","report_number":"0321005713","insp_date":"2023-07-28 00:00:00","insp_start_time":"1105","insp_end_time":"1149","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058M","location_desc":"UTICA EXIT 31 TANDEM LOT","county_code_state":"NY","county_code":"065","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SUPREME INDUSTRIES","shipping_paper_number":"42088","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-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"146320","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":"2853315","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-31 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:33.000000Z","updated_at":"2025-03-17T19:34:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5833361,"change_date":"2023-07-31 21:40:00","inspection_id":"79277916","insp_unit_id":"196269249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84","insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"Y","insp_unit_decal_number":"33073344","created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"},{"id":5833362,"change_date":"2023-07-31 21:40:00","inspection_id":"79277916","insp_unit_id":"196269250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TRL-19","insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124818P3217792","insp_unit_decal":"Y","insp_unit_decal_number":"33073345","created_at":"2025-03-17T22:49:03.000000Z","updated_at":"2025-03-17T22:49:03.000000Z"}]},{"id":3605972,"change_date":"2023-07-27 21:40:00","inspection_id":"79252939","dot_number":"1474478","report_state":"NY","report_number":"0321005702","insp_date":"2023-07-26 00:00:00","insp_start_time":"1230","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382M","location_desc":"HASTINGS REST AREA (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","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-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122305","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":"2851742","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5797682,"change_date":"2023-07-27 21:40:00","inspection_id":"79252939","insp_unit_id":"196219972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"83","insp_unit_license":"19026PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD49X5LD731190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"},{"id":5797683,"change_date":"2023-07-27 21:40:00","inspection_id":"79252939","insp_unit_id":"196219973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"4232","insp_unit_license":"BK58394","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1E9T80923GE007144","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3573350,"change_date":"2023-07-24 21:41:00","inspection_id":"79216433","dot_number":"1474478","report_state":"NY","report_number":"SPA0340287","insp_date":"2023-07-19 00:00:00","insp_start_time":"1200","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"50931A","location_desc":"YORKSHIRE","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LEWIS TREE SERVICE","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"198280","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2849745","transaction_code":"A","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-07-24 21:41:00","snet_input_date":"2023-07-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-24 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORD","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:34.000000Z","updated_at":"2025-03-17T19:33:34.000000Z","inspection_violations":[{"id":5510219,"change_date":"2023-07-24 21:41:00","inspection_id":"79216433","insp_violation_id":"254223041","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:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3958F1"},{"id":5510220,"change_date":"2023-07-24 21:41:00","inspection_id":"79216433","insp_violation_id":"254223042","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196144285","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5745267,"change_date":"2023-07-24 21:41:00","inspection_id":"79216433","insp_unit_id":"196144284","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"41710TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X2KN282930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:21.000000Z","updated_at":"2025-03-17T22:48:21.000000Z"},{"id":5745268,"change_date":"2023-07-24 21:41:00","inspection_id":"79216433","insp_unit_id":"196144285","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BP51300","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5637J1037038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:21.000000Z","updated_at":"2025-03-17T22:48:21.000000Z"}]},{"id":3553104,"change_date":"2023-07-20 21:40:00","inspection_id":"79193591","dot_number":"1474478","report_state":"NY","report_number":"SPT0334101","insp_date":"2023-07-13 00:00:00","insp_start_time":"1320","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SUPREME INDUSTRIES","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-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2849059","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-20 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:11.000000Z","updated_at":"2025-03-17T19:33:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5713101,"change_date":"2023-07-20 21:40:00","inspection_id":"79193591","insp_unit_id":"196098602","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"},{"id":5713102,"change_date":"2023-07-20 21:40:00","inspection_id":"79193591","insp_unit_id":"196098603","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"16","insp_unit_license":"BU22086","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAPA4828GA037738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:05.000000Z","updated_at":"2025-03-17T22:48:05.000000Z"}]},{"id":3393887,"change_date":"2023-06-29 21:41:00","inspection_id":"79014799","dot_number":"1474478","report_state":"NY","report_number":"0321005612","insp_date":"2023-06-28 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"20832M","location_desc":"TRENTON REST AREA (SB)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"NORTHERN CLEARING INC.","shipping_paper_number":"14274","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-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"161000","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":"2842289","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-29 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:11.000000Z","updated_at":"2025-03-17T19:30:11.000000Z","inspection_violations":[{"id":5233150,"change_date":"2023-06-29 21:41:00","inspection_id":"79014799","insp_violation_id":"253770170","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195738474","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D36GWLD6L","created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"3939A"},{"id":5233151,"change_date":"2023-06-29 21:41:00","inspection_id":"79014799","insp_violation_id":"253770171","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195738475","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D36GWLDLG","created_at":"2025-03-17T21:31:17.000000Z","updated_at":"2025-03-17T21:31:17.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":5456209,"change_date":"2023-06-29 21:41:00","inspection_id":"79014799","insp_unit_id":"195738474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"73","insp_unit_license":"27631TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBTXXYN532627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"},{"id":5456210,"change_date":"2023-06-29 21:41:00","inspection_id":"79014799","insp_unit_id":"195738475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":"TRL-22","insp_unit_license":"CF27745","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1TTE482C4K3128053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:03.000000Z","updated_at":"2025-03-17T22:46:03.000000Z"}]},{"id":3208357,"change_date":"2023-06-05 21:42:00","inspection_id":"78805686","dot_number":"1474478","report_state":"NY","report_number":"SPT0540576","insp_date":"2023-06-02 00:00:00","insp_start_time":"1139","insp_end_time":"1159","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895","location_desc":"WESTMORELAND (EXIT 32)","county_code_state":"NY","county_code":"065","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-06-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77500","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":"2831597","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-06-05 21:42:00","snet_input_date":"2023-06-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-05 21:42:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","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":[],"inspection_per_units":[{"id":5159792,"change_date":"2023-06-05 21:42:00","inspection_id":"78805686","insp_unit_id":"195306574","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"65780ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5LBEX75N853030","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":3028798,"change_date":"2023-05-12 21:41:00","inspection_id":"78603271","dot_number":"1474478","report_state":"NY","report_number":"MC74000517","insp_date":"2023-05-11 00:00:00","insp_start_time":"0958","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"NORTHERN CLEARING","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-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"2824657","transaction_code":"A","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-12 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:00.000000Z","updated_at":"2025-03-17T19:23:00.000000Z","inspection_violations":[{"id":4651951,"change_date":"2023-05-12 21:41:00","inspection_id":"78603271","insp_violation_id":"252788055","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194892891","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:40.000000Z","updated_at":"2025-03-17T21:28:40.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4872595,"change_date":"2023-05-12 21:41:00","inspection_id":"78603271","insp_unit_id":"194892890","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"69","insp_unit_license":"41710TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X2KN282930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:24.000000Z","updated_at":"2025-03-17T22:41:24.000000Z"},{"id":4872596,"change_date":"2023-05-12 21:41:00","inspection_id":"78603271","insp_unit_id":"194892891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"TRL-19","insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5V8FY48A0NM014744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:24.000000Z","updated_at":"2025-03-17T22:41:24.000000Z"}]},{"id":2915584,"change_date":"2023-04-28 21:38:00","inspection_id":"78475356","dot_number":"1474478","report_state":"NY","report_number":"SPWB040577","insp_date":"2023-04-27 00:00:00","insp_start_time":"1330","insp_end_time":"1354","registration_date":null,"region":"ET","ci_status_code":"C","location":"10598A","location_desc":"HIGH PEAKS (NB)","county_code_state":"NY","county_code":"031","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":"2023-04-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"96608","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":"2820009","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":null,"census_search_date":"2023-04-28 21:38:00","snet_input_date":"2023-04-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-28 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING AND SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:28.000000Z","updated_at":"2025-03-17T19:20:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4690657,"change_date":"2023-04-28 21:38:00","inspection_id":"78475356","insp_unit_id":"194638912","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"BL27416","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124815G3157020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"},{"id":4690658,"change_date":"2023-04-28 21:38:00","inspection_id":"78475356","insp_unit_id":"194638913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"BL27416","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124815G3157020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:59.000000Z","updated_at":"2025-03-17T22:39:59.000000Z"}]},{"id":2723553,"change_date":"2023-04-04 21:41:00","inspection_id":"78257888","dot_number":"1474478","report_state":"NY","report_number":"SPD0234691","insp_date":"2023-04-03 00:00:00","insp_start_time":"0134","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"20832A","location_desc":"TRENTON (NB)","county_code_state":"NY","county_code":"065","insp_level_id":"2","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-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2812639","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-04 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4383866,"change_date":"2023-04-04 21:41:00","inspection_id":"78257888","insp_unit_id":"194204831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84","insp_unit_license":"13719BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X9PD862982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"},{"id":4383867,"change_date":"2023-04-04 21:41:00","inspection_id":"78257888","insp_unit_id":"194204832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"3","insp_unit_license":"BL27416","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC124815G3157020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2723569,"change_date":"2023-04-04 21:41:00","inspection_id":"78257905","dot_number":"1474478","report_state":"NY","report_number":"SPD0280597","insp_date":"2023-04-03 00:00:00","insp_start_time":"0122","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"20832A","location_desc":"TRENTON (NB)","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2812444","transaction_code":"A","transaction_date":"2023-04-04 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-04 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4383891,"change_date":"2023-04-04 21:41:00","inspection_id":"78257905","insp_unit_id":"194204858","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"},{"id":4383892,"change_date":"2023-04-04 21:41:00","inspection_id":"78257905","insp_unit_id":"194204859","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2692699,"change_date":"2023-03-30 21:40:00","inspection_id":"78222412","dot_number":"1474478","report_state":"NY","report_number":"SPT0462206","insp_date":"2023-03-28 00:00:00","insp_start_time":"1319","insp_end_time":"1334","registration_date":null,"region":"ET","ci_status_code":"C","location":"22058A","location_desc":"UTICA (EXIT 31)","county_code_state":"NY","county_code":"065","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NATIONAL GRID","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-03-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140321","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":"2811394","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-30 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:14.000000Z","updated_at":"2025-03-17T19:16:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4334642,"change_date":"2023-03-30 21:40:00","inspection_id":"78222412","insp_unit_id":"194136308","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"},{"id":4334643,"change_date":"2023-03-30 21:40:00","inspection_id":"78222412","insp_unit_id":"194136309","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BU34674","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XL3193375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:07.000000Z","updated_at":"2025-03-17T22:37:07.000000Z"}]},{"id":2598624,"change_date":"2023-03-17 21:41:00","inspection_id":"78115265","dot_number":"1474478","report_state":"NY","report_number":"SPB0401474","insp_date":"2023-03-15 00:00:00","insp_start_time":"0935","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"70225","location_desc":"DEKALB ROADSIDE","county_code_state":"NY","county_code":"089","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"2807212","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-17 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:31.000000Z","updated_at":"2025-03-17T19:14:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4182671,"change_date":"2023-03-17 21:41:00","inspection_id":"78115265","insp_unit_id":"193923159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"},{"id":4182672,"change_date":"2023-03-17 21:41:00","inspection_id":"78115265","insp_unit_id":"193923160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:59.000000Z","updated_at":"2025-03-17T22:35:59.000000Z"}]},{"id":2188984,"change_date":"2023-01-20 21:40:00","inspection_id":"77648242","dot_number":"1474478","report_state":"NY","report_number":"SPD0224634","insp_date":"2023-01-18 00:00:00","insp_start_time":"1045","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"167320","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":"2790954","transaction_code":"A","transaction_date":"2023-01-20 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-20 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:57.000000Z","updated_at":"2025-03-17T19:06:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3523259,"change_date":"2023-01-20 21:40:00","inspection_id":"77648242","insp_unit_id":"192974334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"},{"id":3523260,"change_date":"2023-01-20 21:40:00","inspection_id":"77648242","insp_unit_id":"192974335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"13","insp_unit_license":"BT65443","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3636LC052326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:16.000000Z","updated_at":"2025-03-17T22:31:16.000000Z"}]},{"id":1768392,"change_date":"2022-11-18 21:38:00","inspection_id":"77166824","dot_number":"1474478","report_state":"NY","report_number":"SPC0158570","insp_date":"2022-11-16 00:00:00","insp_start_time":"1359","insp_end_time":"1421","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHERN CLEARING","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-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2771700","transaction_code":"A","transaction_date":"2022-11-18 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-18 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:17.000000Z","updated_at":"2025-03-17T18:59:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2844819,"change_date":"2022-11-18 21:38:00","inspection_id":"77166824","insp_unit_id":"192021204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5V8FY48A0NM014744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:26.000000Z","updated_at":"2025-03-17T22:26:26.000000Z"},{"id":2844820,"change_date":"2022-11-18 21:38:00","inspection_id":"77166824","insp_unit_id":"192021205","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:26.000000Z","updated_at":"2025-03-17T22:26:26.000000Z"}]},{"id":1547676,"change_date":"2022-10-19 21:40:00","inspection_id":"76913401","dot_number":"1474478","report_state":"NY","report_number":"SPD0280170","insp_date":"2022-10-18 00:00:00","insp_start_time":"1527","insp_end_time":"1542","registration_date":null,"region":"ET","ci_status_code":"C","location":"21329","location_desc":"MUNNSVILLE","county_code_state":"NY","county_code":"053","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-10-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"2760537","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-19 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:12.000000Z","updated_at":"2025-03-17T18:55:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2490421,"change_date":"2022-10-19 21:40:00","inspection_id":"76913401","insp_unit_id":"191513957","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"75","insp_unit_license":"12915MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"FLA68480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:05.000000Z","updated_at":"2025-03-17T22:24:05.000000Z"}]},{"id":1431675,"change_date":"2022-10-04 21:40:00","inspection_id":"76779327","dot_number":"1474478","report_state":"NY","report_number":"SPB0361202","insp_date":"2022-10-03 00:00:00","insp_start_time":"1105","insp_end_time":"1133","registration_date":null,"region":"ET","ci_status_code":"C","location":"10594","location_desc":"NORTH ELBA","county_code_state":"NY","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","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":"2755697","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:04.000000Z","updated_at":"2025-03-17T18:53:04.000000Z","inspection_violations":[{"id":2253889,"change_date":"2022-10-04 21:40:00","inspection_id":"76779327","insp_violation_id":"248806426","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"191246999","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"39355D3"},{"id":2253890,"change_date":"2022-10-04 21:40:00","inspection_id":"76779327","insp_violation_id":"248806427","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191246999","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:20.000000Z","updated_at":"2025-03-17T21:17:20.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2304415,"change_date":"2022-10-04 21:40:00","inspection_id":"76779327","insp_unit_id":"191246998","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"79","insp_unit_license":"30431TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPXD40X5LM663223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"},{"id":2304416,"change_date":"2022-10-04 21:40:00","inspection_id":"76779327","insp_unit_id":"191246999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"14","insp_unit_license":"BU34674","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XL3193375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"}]},{"id":1482993,"change_date":"2022-10-11 21:41:00","inspection_id":"76838919","dot_number":"1474478","report_state":"NY","report_number":"SPB0371052","insp_date":"2022-10-03 00:00:00","insp_start_time":"1109","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":"10594","location_desc":"NORTH ELBA (HAYSTACK MOUNTAIN)","county_code_state":"NY","county_code":"031","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-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"161000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2757023","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:06.000000Z","updated_at":"2025-03-17T18:54:06.000000Z","inspection_violations":[{"id":2334104,"change_date":"2022-10-11 21:41:00","inspection_id":"76838919","insp_violation_id":"248939888","seq_no":"1","part_no":"383","part_no_section":"91(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:41.000000Z","updated_at":"2025-03-17T21:17:41.000000Z","normalized_code":"38391A"},{"id":2334105,"change_date":"2022-10-11 21:41:00","inspection_id":"76838919","insp_violation_id":"248939889","seq_no":"2","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"191364111","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:41.000000Z","updated_at":"2025-03-17T21:17:41.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":2386293,"change_date":"2022-10-11 21:41:00","inspection_id":"76838919","insp_unit_id":"191364111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"27361TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NP5XBTXXYN532627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"},{"id":2386294,"change_date":"2022-10-11 21:41:00","inspection_id":"76838919","insp_unit_id":"191364112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5V8FY48A0NM014744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:21.000000Z","updated_at":"2025-03-17T22:23:21.000000Z"}]},{"id":1431901,"change_date":"2022-10-04 21:40:00","inspection_id":"76779578","dot_number":"1474478","report_state":"NY","report_number":"SPB0361198","insp_date":"2022-09-30 00:00:00","insp_start_time":"1115","insp_end_time":"1131","registration_date":null,"region":"ET","ci_status_code":"C","location":"70661","location_desc":"STATE ROUTE 3 PIERCFIELD","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH","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-10-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2755732","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-04 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:04.000000Z","updated_at":"2025-03-17T18:53:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2304747,"change_date":"2022-10-04 21:40:00","inspection_id":"76779578","insp_unit_id":"191247386","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"},{"id":2304748,"change_date":"2022-10-04 21:40:00","inspection_id":"76779578","insp_unit_id":"191247387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"TRL 16","insp_unit_license":"BU22086","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MAPA4828GA037738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:46.000000Z","updated_at":"2025-03-17T22:22:46.000000Z"}]},{"id":1310722,"change_date":"2022-09-19 21:39:00","inspection_id":"76639055","dot_number":"1474478","report_state":"NY","report_number":"0326000427","insp_date":"2022-09-16 00:00:00","insp_start_time":"0925","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":"32021","location_desc":"ITHACA CEMETARY","county_code_state":"NY","county_code":"109","insp_level_id":"2","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-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2750229","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:51.000000Z","updated_at":"2025-03-17T18:50:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2109904,"change_date":"2022-09-19 21:39:00","inspection_id":"76639055","insp_unit_id":"190961953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"},{"id":2109905,"change_date":"2022-09-19 21:39:00","inspection_id":"76639055","insp_unit_id":"190961954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"TRL-10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:27.000000Z","updated_at":"2025-03-17T22:21:27.000000Z"}]},{"id":1074444,"change_date":"2022-08-18 21:39:00","inspection_id":"76364279","dot_number":"1474478","report_state":"NY","report_number":"MC70000820","insp_date":"2022-08-17 00:00:00","insp_start_time":"0903","insp_end_time":"0932","registration_date":null,"region":"ET","ci_status_code":"C","location":"20895M","location_desc":"WESTMORELAND EXIT 32 TNDM LOT","county_code_state":"NY","county_code":"065","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SUIT-KOTE","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"131780","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":"2740754","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-18 21:39:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:33.000000Z","updated_at":"2025-03-17T18:46:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1727745,"change_date":"2022-08-18 21:39:00","inspection_id":"76364279","insp_unit_id":"190397663","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:54.000000Z","updated_at":"2025-03-17T22:18:54.000000Z"},{"id":1727746,"change_date":"2022-08-18 21:39:00","inspection_id":"76364279","insp_unit_id":"190397664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIM","insp_unit_company":"4212","insp_unit_license":"AA15524","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1PTGZ3VJXA4000741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:54.000000Z","updated_at":"2025-03-17T22:18:54.000000Z"}]},{"id":910795,"change_date":"2022-07-28 21:40:00","inspection_id":"76172687","dot_number":"1474478","report_state":"NY","report_number":"MC74000396","insp_date":"2022-07-27 00:00:00","insp_start_time":"1336","insp_end_time":"1406","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877M","location_desc":"WATERTOWN REST AREA (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"SUIT-KOTE","shipping_paper_number":"2627247","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-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"131780","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":"2732426","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:43.000000Z","updated_at":"2025-03-17T18:43:43.000000Z","inspection_violations":[{"id":1436634,"change_date":"2022-07-28 21:40:00","inspection_id":"76172687","insp_violation_id":"247363721","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190006467","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:46.000000Z","updated_at":"2025-03-17T21:13:46.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":1465829,"change_date":"2022-07-28 21:40:00","inspection_id":"76172687","insp_unit_id":"190006467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:13.000000Z","updated_at":"2025-03-17T22:17:13.000000Z"},{"id":1465830,"change_date":"2022-07-28 21:40:00","inspection_id":"76172687","insp_unit_id":"190006468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"4212","insp_unit_license":"AA15524","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1PTGZ3VJXA4000741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:13.000000Z","updated_at":"2025-03-17T22:17:13.000000Z"}]},{"id":735789,"change_date":"2022-07-01 21:38:00","inspection_id":"75968637","dot_number":"1474478","report_state":"NY","report_number":"SPB0370797","insp_date":"2022-06-24 00:00:00","insp_start_time":"1012","insp_end_time":"1031","registration_date":null,"region":"ET","ci_status_code":"C","location":"70188","location_desc":"COLTON (ROADSIDE)","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"ALDRICH","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":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2723168","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":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","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":[{"id":1158822,"change_date":"2022-07-01 21:38:00","inspection_id":"75968637","insp_violation_id":"246849439","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"189567931","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:23.000000Z","updated_at":"2025-03-17T21:12:23.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":1182397,"change_date":"2022-07-01 21:38:00","inspection_id":"75968637","insp_unit_id":"189567931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","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":1182398,"change_date":"2022-07-01 21:38:00","inspection_id":"75968637","insp_unit_id":"189567932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":"10","insp_unit_license":"BN83242","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MC12481XJ3172782","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":479207,"change_date":"2022-05-25 21:41:00","inspection_id":"75664450","dot_number":"1474478","report_state":"NY","report_number":"SPD0233999","insp_date":"2022-05-24 00:00:00","insp_start_time":"0833","insp_end_time":"0852","registration_date":null,"region":"ET","ci_status_code":"C","location":"20325","location_desc":"GERMAN FLATTS","county_code_state":"NY","county_code":"043","insp_level_id":"2","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":"2022-05-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"144230","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":"2710984","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-25 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:01.000000Z","updated_at":"2025-03-17T18:36:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":770647,"change_date":"2022-05-25 21:41:00","inspection_id":"75664450","insp_unit_id":"188901451","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"80","insp_unit_license":"31357TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXP4EXXLD715905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:56.000000Z","updated_at":"2025-03-17T22:12:56.000000Z"},{"id":770648,"change_date":"2022-05-25 21:41:00","inspection_id":"75664450","insp_unit_id":"188901452","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"TRL21","insp_unit_license":"CD68390","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"40FSK5339N1041862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:56.000000Z","updated_at":"2025-03-17T22:12:56.000000Z"}]},{"id":171191,"change_date":"2022-04-14 21:41:00","inspection_id":"75297067","dot_number":"1474478","report_state":"NY","report_number":"SPT0460993","insp_date":"2022-04-13 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"20802","location_desc":"HERKIMER EXIT 30","county_code_state":"NY","county_code":"043","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"RYAN ALDRICH TRUCKING AND SAWING INC","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"140320","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":"2695204","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-14 21:41:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:30.000000Z","updated_at":"2025-03-17T18:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":277422,"change_date":"2022-04-14 21:41:00","inspection_id":"75297067","insp_unit_id":"188143066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"81","insp_unit_license":"10811BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X0MD749305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"},{"id":277423,"change_date":"2022-04-14 21:41:00","inspection_id":"75297067","insp_unit_id":"188143067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"CC91002","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5V8FY48A0NM014744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"}]},{"id":33086,"change_date":"2022-03-24 21:31:00","inspection_id":"75127773","dot_number":"1474478","report_state":"NY","report_number":"SPC0177816","insp_date":"2022-03-23 00:00:00","insp_start_time":"0628","insp_end_time":"0651","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":"CARGILL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"167300","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":"2688568","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01474478","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"RYAN ALDRICH TRUCKING & SAWING INC","insp_carrier_street":"685 MOWERS RD","insp_carrier_city":"FRANKFORT","insp_carrier_state":"NY","insp_carrier_zip_code":"13340","insp_colonia":null,"docket_number":"902295","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:07.000000Z","updated_at":"2025-03-17T18:28:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":53139,"change_date":"2022-03-24 21:31:00","inspection_id":"75127773","insp_unit_id":"187797164","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"70","insp_unit_license":"13676BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40X1ND785022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"},{"id":53140,"change_date":"2022-03-24 21:31:00","inspection_id":"75127773","insp_unit_id":"187797165","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"TRL-1","insp_unit_license":"BH88834","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA363XGC036751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1474478\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1474478\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1474478\/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\/1474478\/inspections","per_page":100,"prev_page_url":null,"to":74,"total":74}