{"current_page":1,"data":[{"id":12371180,"change_date":"2026-07-07 21:40:00","inspection_id":"88333559","dot_number":"1748019","report_state":"NY","report_number":"SPK4120001","insp_date":"2026-06-30 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"POUGHKEEPSIE NY","county_code_state":"NY","county_code":"027","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":"2026-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3695973","transaction_code":"A","transaction_date":"2026-07-06 00:00:00","upload_date":"2026-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-07-07 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-07 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-10T09:40:13.000000Z","updated_at":"2026-07-10T09:40:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21482569,"change_date":"2026-07-07 21:40:00","inspection_id":"88333559","insp_unit_id":"214471932","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-10T09:16:16.000000Z","updated_at":"2026-07-10T09:16:16.000000Z"}]},{"id":12342581,"change_date":"2026-07-02 21:40:00","inspection_id":"88302095","dot_number":"1748019","report_state":"NY","report_number":"SPK3060254","insp_date":"2026-06-25 00:00:00","insp_start_time":"1007","insp_end_time":"1026","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HUDSON NY","county_code_state":"NY","county_code":"021","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":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3669236","transaction_code":"A","transaction_date":"2026-07-01 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:10.000000Z","updated_at":"2026-07-10T09:36:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21434680,"change_date":"2026-07-02 21:40:00","inspection_id":"88302095","insp_unit_id":"214414145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2201","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:39.000000Z","updated_at":"2026-07-10T09:09:39.000000Z"}]},{"id":12230942,"change_date":"2026-06-22 21:39:00","inspection_id":"88188397","dot_number":"1748019","report_state":"NY","report_number":"SPF3051346","insp_date":"2026-06-12 00:00:00","insp_start_time":"1022","insp_end_time":"1038","registration_date":"2026-06-19 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"KINGSTON NY","county_code_state":"NY","county_code":"111","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3578157","transaction_code":"C","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-06-19 21:38:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-19 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-22T09:41:20.000000Z","updated_at":"2026-07-03T09:30:14.000000Z","inspection_violations":[{"id":21288422,"change_date":"2026-06-22 21:39:00","inspection_id":"88188397","insp_violation_id":"275052304","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":"S260952907","created_at":"2026-06-22T10:02:51.000000Z","updated_at":"2026-07-03T09:42:59.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":21241107,"change_date":"2026-06-22 21:39:00","inspection_id":"88188397","insp_unit_id":"214221301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2101","insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-22T09:18:29.000000Z","updated_at":"2026-07-05T09:00:57.000000Z"}]},{"id":11514648,"change_date":"2026-04-09 21:55:00","inspection_id":"87435430","dot_number":"1748019","report_state":"NY","report_number":"D103101565","insp_date":"2026-03-26 00:00:00","insp_start_time":"0924","insp_end_time":"1005","registration_date":"2026-04-07 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","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-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3087001","transaction_code":"C","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-03-30 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-30 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-02T09:46:51.000000Z","updated_at":"2026-04-20T09:32:06.000000Z","inspection_violations":[{"id":19626712,"change_date":"2026-04-09 21:55:00","inspection_id":"87435430","insp_violation_id":"272957279","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"212622631","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:03:58.000000Z","updated_at":"2026-04-19T10:55:21.000000Z","normalized_code":"39355C1B"},{"id":19626713,"change_date":"2026-04-09 21:55:00","inspection_id":"87435430","insp_violation_id":"272957280","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212622631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:03:58.000000Z","updated_at":"2026-04-19T10:55:21.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":19890047,"change_date":"2026-04-09 21:55:00","inspection_id":"87435430","insp_unit_id":"212622631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"28955MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B0KS804998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:25:26.000000Z","updated_at":"2026-04-19T09:05:41.000000Z"}]},{"id":11512577,"change_date":"2026-03-30 21:38:00","inspection_id":"87433226","dot_number":"1748019","report_state":"NY","report_number":"SPG3090832","insp_date":"2026-03-23 00:00:00","insp_start_time":"1432","insp_end_time":"1500","registration_date":"2026-03-25 00:00:00","region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","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-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"3085373","transaction_code":"A","transaction_date":"2026-03-29 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-03-30 21:38:00","snet_input_date":"2026-03-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-30 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-02T09:46:40.000000Z","updated_at":"2026-04-10T09:30:06.000000Z","inspection_violations":[{"id":19443221,"change_date":"2026-03-30 21:38:00","inspection_id":"87433226","insp_violation_id":"272725777","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212414545","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:09:54.000000Z","updated_at":"2026-04-09T09:49:30.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":19722815,"change_date":"2026-03-30 21:38:00","inspection_id":"87433226","insp_unit_id":"212414545","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"2203","insp_unit_license":"27899ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA0RS009741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:34.000000Z","updated_at":"2026-04-10T09:04:12.000000Z"}]},{"id":11393620,"change_date":"2026-03-17 21:39:00","inspection_id":"87308283","dot_number":"1748019","report_state":"NY","report_number":"SPK3040905","insp_date":"2026-03-10 00:00:00","insp_start_time":"1329","insp_end_time":"1344","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RED HOOK NY","county_code_state":"NY","county_code":"027","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":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3014788","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:28.000000Z","updated_at":"2026-03-28T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19512965,"change_date":"2026-03-17 21:39:00","inspection_id":"87308283","insp_unit_id":"212171275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2201","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:20.000000Z","updated_at":"2026-03-28T09:04:21.000000Z"}]},{"id":11293283,"change_date":"2026-03-05 21:39:00","inspection_id":"87208632","dot_number":"1748019","report_state":"NY","report_number":"SPG3041103","insp_date":"2026-02-26 00:00:00","insp_start_time":"1146","insp_end_time":"1159","registration_date":null,"region":"ES","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"203870","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-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2963654","transaction_code":"A","transaction_date":"2026-03-04 00:00:00","upload_date":"2026-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-03-05 21:39:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-05 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-08T09:44:02.000000Z","updated_at":"2026-03-16T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19315974,"change_date":"2026-03-05 21:39:00","inspection_id":"87208632","insp_unit_id":"211977645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":null,"insp_unit_license":"27899ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA0RS009741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-08T09:25:09.000000Z","updated_at":"2026-03-16T09:02:12.000000Z"}]},{"id":11090126,"change_date":"2026-02-10 21:38:00","inspection_id":"87001639","dot_number":"1748019","report_state":"NY","report_number":"SPF3061435","insp_date":"2026-02-03 00:00:00","insp_start_time":"1125","insp_end_time":"1141","registration_date":"2026-02-06 00:00:00","region":"ES","ci_status_code":"C","location":"80479","location_desc":"HIGHLAND NY","county_code_state":"NY","county_code":"111","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2866371","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:48.000000Z","updated_at":"2026-02-21T10:30:17.000000Z","inspection_violations":[{"id":18566774,"change_date":"2026-02-10 21:38:00","inspection_id":"87001639","insp_violation_id":"271694924","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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":"2026-02-13T10:52:01.000000Z","updated_at":"2026-02-21T10:38:38.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18911920,"change_date":"2026-02-10 21:38:00","inspection_id":"87001639","insp_unit_id":"211532071","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2201","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:33.000000Z","updated_at":"2026-02-21T10:02:52.000000Z"}]},{"id":10910376,"change_date":"2026-02-10 21:38:00","inspection_id":"86942158","dot_number":"1748019","report_state":"NY","report_number":"SPF3021768","insp_date":"2026-01-27 00:00:00","insp_start_time":"1014","insp_end_time":"1038","registration_date":"2026-02-10 00:00:00","region":"ES","ci_status_code":"C","location":"80843M","location_desc":"KINGSTON NY","county_code_state":"NY","county_code":"111","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-02-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2838570","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-02-03 21:38:00","snet_input_date":"2026-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-03 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-06T10:35:10.000000Z","updated_at":"2026-02-21T10:30:11.000000Z","inspection_violations":[{"id":18565114,"change_date":"2026-02-10 21:38:00","inspection_id":"86942158","insp_violation_id":"271697809","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-02-13T10:51:57.000000Z","updated_at":"2026-02-21T10:38:27.000000Z","normalized_code":"39141APC"},{"id":18565115,"change_date":"2026-02-10 21:38:00","inspection_id":"86942158","insp_violation_id":"271697810","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211534529","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:57.000000Z","updated_at":"2026-02-21T10:38:27.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":18910424,"change_date":"2026-02-10 21:38:00","inspection_id":"86942158","insp_unit_id":"211534529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:32.000000Z","updated_at":"2026-02-21T10:02:43.000000Z"}]},{"id":10821716,"change_date":"2026-01-21 21:37:00","inspection_id":"86849267","dot_number":"1748019","report_state":"NY","report_number":"SPT3141468","insp_date":"2026-01-14 00:00:00","insp_start_time":"1619","insp_end_time":"1636","registration_date":"2026-01-16 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","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":"2026-01-21 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2793736","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-01-21 21:37:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-21 21:37:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:44.000000Z","updated_at":"2026-02-01T10:30:10.000000Z","inspection_violations":[{"id":18091060,"change_date":"2026-01-21 21:37:00","inspection_id":"86849267","insp_violation_id":"271328658","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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":"2026-01-24T10:42:51.000000Z","updated_at":"2026-02-01T10:36:22.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":18174063,"change_date":"2026-01-21 21:37:00","inspection_id":"86849267","insp_unit_id":"211201993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2401","insp_unit_license":"27659NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D0RS203361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:32.000000Z","updated_at":"2026-02-01T10:02:28.000000Z"}]},{"id":10644769,"change_date":"2026-02-05 21:38:00","inspection_id":"86786330","dot_number":"1748019","report_state":"NY","report_number":"SPF3041319","insp_date":"2026-01-07 00:00:00","insp_start_time":"1224","insp_end_time":"1241","registration_date":"2026-02-04 00:00:00","region":"ES","ci_status_code":"C","location":"80479","location_desc":"HIGHLAND NY","county_code_state":"NY","county_code":"111","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-01-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2761545","transaction_code":"C","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-01-14 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-14 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:17.000000Z","updated_at":"2026-02-16T10:30:05.000000Z","inspection_violations":[{"id":18492545,"change_date":"2026-02-05 21:38:00","inspection_id":"86786330","insp_violation_id":"271615216","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211456573","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-08T10:50:15.000000Z","updated_at":"2026-02-16T10:38:54.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18840088,"change_date":"2026-02-05 21:38:00","inspection_id":"86786330","insp_unit_id":"211456573","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:10.000000Z","updated_at":"2026-02-16T10:04:05.000000Z"}]},{"id":10553236,"change_date":"2026-01-13 21:39:00","inspection_id":"86690229","dot_number":"1748019","report_state":"NY","report_number":"SPF3061355","insp_date":"2025-12-26 00:00:00","insp_start_time":"1217","insp_end_time":"1233","registration_date":"2026-01-13 00:00:00","region":"ES","ci_status_code":"C","location":"80479M","location_desc":"HIGHLAND NY","county_code_state":"NY","county_code":"111","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-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2716104","transaction_code":"C","transaction_date":"2026-01-01 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:31.000000Z","updated_at":"2026-01-24T10:30:10.000000Z","inspection_violations":[{"id":17881067,"change_date":"2026-01-13 21:39:00","inspection_id":"86690229","insp_violation_id":"271161454","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"211046325","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:45.000000Z","updated_at":"2026-01-24T10:30:21.000000Z","normalized_code":"3922SLLEQP"},{"id":17881068,"change_date":"2026-01-13 21:39:00","inspection_id":"86690229","insp_violation_id":"271161455","seq_no":"2","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"211046325","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:41:45.000000Z","updated_at":"2026-01-24T10:30:21.000000Z","normalized_code":"39355C1B"}],"inspection_per_units":[{"id":17829250,"change_date":"2026-01-13 21:39:00","inspection_id":"86690229","insp_unit_id":"211046325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"28955MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B0KS804998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:32.000000Z","updated_at":"2026-01-24T10:01:36.000000Z"}]},{"id":9969110,"change_date":"2025-10-17 21:39:00","inspection_id":"86077642","dot_number":"1748019","report_state":"NY","report_number":"D102601097","insp_date":"2025-10-14 00:00:00","insp_start_time":"1241","insp_end_time":"1314","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CLIFTON PARK NY","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":"U","pen_cen_match":"I","final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2424669","transaction_code":"A","transaction_date":"2025-10-17 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:51.000000Z","updated_at":"2025-10-21T10:00:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16553098,"change_date":"2025-10-17 21:39:00","inspection_id":"86077642","insp_unit_id":"209522853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:03.000000Z","updated_at":"2025-10-21T09:45:44.000000Z"}]},{"id":9933411,"change_date":"2025-10-16 21:39:00","inspection_id":"86039473","dot_number":"1748019","report_state":"NY","report_number":"D102901087","insp_date":"2025-10-08 00:00:00","insp_start_time":"1415","insp_end_time":"1437","registration_date":"2025-10-16 00:00:00","region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","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":"2405751","transaction_code":"C","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:31.000000Z","updated_at":"2025-10-20T10:00:06.000000Z","inspection_violations":[{"id":16436737,"change_date":"2025-10-16 21:39:00","inspection_id":"86039473","insp_violation_id":"269328326","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209494111","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:22.000000Z","updated_at":"2025-10-20T10:15:12.000000Z","normalized_code":"39617CPI"},{"id":16436738,"change_date":"2025-10-16 21:39:00","inspection_id":"86039473","insp_violation_id":"269328327","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209494111","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-19T10:17:22.000000Z","updated_at":"2025-10-20T10:15:12.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16525340,"change_date":"2025-10-16 21:39:00","inspection_id":"86039473","insp_unit_id":"209494111","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:41.000000Z","updated_at":"2025-10-20T09:45:09.000000Z"}]},{"id":9445626,"change_date":"2025-08-19 21:39:00","inspection_id":"85527603","dot_number":"1748019","report_state":"NY","report_number":"1L19005118","insp_date":"2025-08-12 00:00:00","insp_start_time":"0951","insp_end_time":"1013","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CASTLETON-ON-HUDSON NY","county_code_state":"NY","county_code":"083","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":"2025-08-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2146599","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-08-19 21:39:00","snet_input_date":"2025-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:15.000000Z","updated_at":"2025-08-23T10:46:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15573919,"change_date":"2025-08-19 21:39:00","inspection_id":"85527603","insp_unit_id":"208462366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:35.000000Z","updated_at":"2025-08-23T09:45:17.000000Z"}]},{"id":9317350,"change_date":"2025-08-04 21:38:00","inspection_id":"85392624","dot_number":"1748019","report_state":"NY","report_number":"SPG3070313","insp_date":"2025-07-28 00:00:00","insp_start_time":"1406","insp_end_time":"1417","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELLS USED AUTO PARTS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2081039","transaction_code":"A","transaction_date":"2025-08-03 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-07-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:43.000000Z","updated_at":"2025-08-08T10:00:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15344315,"change_date":"2025-08-04 21:38:00","inspection_id":"85392624","insp_unit_id":"208214513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2101","insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:23.000000Z","updated_at":"2025-08-08T09:45:15.000000Z"}]},{"id":9037854,"change_date":"2025-10-07 21:40:00","inspection_id":"85098417","dot_number":"1748019","report_state":"NY","report_number":"SPT3071060","insp_date":"2025-06-24 00:00:00","insp_start_time":"0857","insp_end_time":"0912","registration_date":"2025-07-22 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SAUGERTIES NY","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":"U","pen_cen_match":"I","final_status_date":"2025-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1936076","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-07-01 21:38:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-01 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:10.000000Z","updated_at":"2025-10-11T10:00:05.000000Z","inspection_violations":[{"id":16266941,"change_date":"2025-10-07 21:40:00","inspection_id":"85098417","insp_violation_id":"269144506","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209337723","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:09.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":16375284,"change_date":"2025-10-07 21:40:00","inspection_id":"85098417","insp_unit_id":"209337723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:35.000000Z","updated_at":"2025-10-11T09:45:07.000000Z"}]},{"id":8971505,"change_date":"2025-06-24 21:40:00","inspection_id":"85028921","dot_number":"1748019","report_state":"VT","report_number":"4800001342","insp_date":"2025-06-19 00:00:00","insp_start_time":"1149","insp_end_time":"1216","registration_date":"2025-06-24 00:00:00","region":"ET","ci_status_code":"C","location":"1107SH","location_desc":"FAIR HAVEN SCALE HOUSE","county_code_state":"VT","county_code":"021","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELLS USED","shipping_paper_number":"172279","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":"2025-06-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"218061","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-06-24 21:40:00","snet_input_date":"2025-06-19 00:00:00","source_office":"1VTS001","mcmis_add_date":"2025-06-24 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:50.000000Z","updated_at":"2025-06-28T10:00:50.000000Z","inspection_violations":[{"id":14416302,"change_date":"2025-06-24 21:40:00","inspection_id":"85028921","insp_violation_id":"267012742","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","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":"2025-06-27T10:17:21.000000Z","updated_at":"2025-06-28T10:17:32.000000Z","normalized_code":"39141AMCPC"},{"id":14416303,"change_date":"2025-06-24 21:40:00","inspection_id":"85028921","insp_violation_id":"267012743","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207527317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:21.000000Z","updated_at":"2025-06-28T10:17:32.000000Z","normalized_code":"3939ALHLI"},{"id":14416304,"change_date":"2025-06-24 21:40:00","inspection_id":"85028921","insp_violation_id":"267012744","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"207527317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:21.000000Z","updated_at":"2025-06-28T10:17:32.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":14708456,"change_date":"2025-06-24 21:40:00","inspection_id":"85028921","insp_unit_id":"207527317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"28955MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1B0KS804998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:36.000000Z","updated_at":"2025-06-28T09:45:40.000000Z"}]},{"id":8776595,"change_date":"2025-05-30 21:40:00","inspection_id":"84821976","dot_number":"1748019","report_state":"NY","report_number":"D700201175","insp_date":"2025-05-27 00:00:00","insp_start_time":"1155","insp_end_time":"1212","registration_date":null,"region":"ED","ci_status_code":"C","location":"70655S","location_desc":"PERU NY","county_code_state":"NY","county_code":"019","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-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1800870","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:05.000000Z","updated_at":"2025-06-04T10:01:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14359466,"change_date":"2025-05-30 21:40:00","inspection_id":"84821976","insp_unit_id":"207145266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:20.000000Z","updated_at":"2025-06-03T09:45:30.000000Z"}]},{"id":8173578,"change_date":"2025-03-21 21:39:00","inspection_id":"84186367","dot_number":"1748019","report_state":"NY","report_number":"D103500060","insp_date":"2025-03-14 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"TROY NY","county_code_state":"NY","county_code":"083","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":"2025-03-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1495684","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-03-21 21:39:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:28.000000Z","updated_at":"2025-03-25T10:09:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13210714,"change_date":"2025-03-21 21:39:00","inspection_id":"84186367","insp_unit_id":"205918275","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"27659NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D0RS203361","insp_unit_decal":"Y","insp_unit_decal_number":"34943906","created_at":"2025-03-24T10:08:43.000000Z","updated_at":"2025-03-25T09:49:11.000000Z"}]},{"id":7891355,"change_date":"2025-02-18 21:39:00","inspection_id":"83889872","dot_number":"1748019","report_state":"NY","report_number":"SPF3040448","insp_date":"2025-02-11 00:00:00","insp_start_time":"1120","insp_end_time":"1135","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HIGHLAND NY","county_code_state":"NY","county_code":"111","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1372278","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:00.000000Z","updated_at":"2025-03-17T21:02:00.000000Z","inspection_violations":[{"id":12329963,"change_date":"2025-02-18 21:39:00","inspection_id":"83889872","insp_violation_id":"264557296","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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:06:12.000000Z","updated_at":"2025-03-17T22:06:12.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12737869,"change_date":"2025-02-18 21:39:00","inspection_id":"83889872","insp_unit_id":"205365527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:43.000000Z","updated_at":"2025-03-17T23:55:43.000000Z"}]},{"id":7882845,"change_date":"2025-02-17 21:35:00","inspection_id":"83880933","dot_number":"1748019","report_state":"NY","report_number":"SPT3020738","insp_date":"2025-02-10 00:00:00","insp_start_time":"1046","insp_end_time":"1106","registration_date":null,"region":"ES","ci_status_code":"C","location":"80579M","location_desc":"NEW PALTZ NY","county_code_state":"NY","county_code":"111","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-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","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":"1369139","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":"01748019","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":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","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":[{"id":12319822,"change_date":"2025-02-17 21:35:00","inspection_id":"83880933","insp_violation_id":"264544857","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"205349184","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":12723593,"change_date":"2025-02-17 21:35:00","inspection_id":"83880933","insp_unit_id":"205349184","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"2404","insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","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":7667368,"change_date":"2025-01-21 21:39:00","inspection_id":"83654586","dot_number":"1748019","report_state":"NY","report_number":"SPB3110281","insp_date":"2025-01-14 00:00:00","insp_start_time":"1415","insp_end_time":"1423","registration_date":null,"region":"ES","ci_status_code":"C","location":"70655N","location_desc":"PERU NY","county_code_state":"NY","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELL'S AUTO PARTS","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-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1271792","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12372308,"change_date":"2025-01-21 21:39:00","inspection_id":"83654586","insp_unit_id":"204925909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7634889,"change_date":"2025-01-16 21:40:00","inspection_id":"83620385","dot_number":"1748019","report_state":"NY","report_number":"SPB3020471","insp_date":"2025-01-09 00:00:00","insp_start_time":"1342","insp_end_time":"1357","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LAKE PLACID NY","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":"U","pen_cen_match":"I","final_status_date":"2025-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1253856","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2025-01-16 21:40:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-16 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:34.000000Z","updated_at":"2025-03-17T20:56:34.000000Z","inspection_violations":[{"id":11930834,"change_date":"2025-01-16 21:40:00","inspection_id":"83620385","insp_violation_id":"264028865","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"204864113","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:07.000000Z","updated_at":"2025-03-17T22:04:07.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":12319459,"change_date":"2025-01-16 21:40:00","inspection_id":"83620385","insp_unit_id":"204864113","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:57.000000Z","updated_at":"2025-03-17T23:50:57.000000Z"}]},{"id":7124366,"change_date":"2024-11-13 21:40:00","inspection_id":"83082721","dot_number":"1748019","report_state":"VT","report_number":"50B0001393","insp_date":"2024-10-31 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":"2024-11-13 00:00:00","region":"ET","ci_status_code":"C","location":"0202","location_desc":"BENNINGTON","county_code_state":"VT","county_code":"003","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-11-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"211529","transaction_code":"C","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2024-11-05 21:39:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-11-05 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:38.000000Z","updated_at":"2025-03-17T20:44:38.000000Z","inspection_violations":[{"id":11127092,"change_date":"2024-11-13 21:40:00","inspection_id":"83082721","insp_violation_id":"262871912","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203860236","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:00.000000Z","updated_at":"2025-03-17T22:00:00.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":11490703,"change_date":"2024-11-13 21:40:00","inspection_id":"83082721","insp_unit_id":"203860236","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"61074NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7GZ37TC73RN004937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:04.000000Z","updated_at":"2025-03-17T23:42:04.000000Z"}]},{"id":7077680,"change_date":"2024-10-30 21:40:00","inspection_id":"83033168","dot_number":"1748019","report_state":"NY","report_number":"SPT3020406","insp_date":"2024-10-23 00:00:00","insp_start_time":"1247","insp_end_time":"1303","registration_date":null,"region":"ED","ci_status_code":"C","location":"80579M","location_desc":"NEW PALTZ NY","county_code_state":"NY","county_code":"111","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-10-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1000008","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:29.000000Z","updated_at":"2025-03-17T20:43:29.000000Z","inspection_violations":[{"id":11048965,"change_date":"2024-10-30 21:40:00","inspection_id":"83033168","insp_violation_id":"262627516","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"203649126","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":11414616,"change_date":"2024-10-30 21:40:00","inspection_id":"83033168","insp_unit_id":"203649126","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2201","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:11.000000Z","updated_at":"2025-03-17T23:41:11.000000Z"}]},{"id":6966405,"change_date":"2024-10-16 21:40:00","inspection_id":"82915025","dot_number":"1748019","report_state":"NY","report_number":"D808100171","insp_date":"2024-10-09 00:00:00","insp_start_time":"1449","insp_end_time":"1515","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"949262","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":"01748019","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":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","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":11235851,"change_date":"2024-10-16 21:40:00","inspection_id":"82915025","insp_unit_id":"203426057","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"2201","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"Y","insp_unit_decal_number":"34639741","created_at":"2025-03-17T23:39:20.000000Z","updated_at":"2025-03-17T23:39:20.000000Z"}]},{"id":6240723,"change_date":"2024-07-17 21:41:00","inspection_id":"82141394","dot_number":"1748019","report_state":"NY","report_number":"SPB0302153","insp_date":"2024-07-16 00:00:00","insp_start_time":"0755","insp_end_time":"0823","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","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":"N","pen_cen_match":null,"final_status_date":"2024-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2937520","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":"01748019","upload_search_indicator":"M","census_search_date":"2024-07-17 21:41:00","snet_input_date":"2024-07-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","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":10055130,"change_date":"2024-07-17 21:41:00","inspection_id":"82141394","insp_unit_id":"201929906","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","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":4329998,"change_date":"2023-11-01 21:43:00","inspection_id":"80058316","dot_number":"1748019","report_state":"NY","report_number":"SPD0271662","insp_date":"2023-10-31 00:00:00","insp_start_time":"0737","insp_end_time":"0754","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CORNELLS USED AUTO PARTS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2883210","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:44.000000Z","updated_at":"2025-03-17T19:48:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6963435,"change_date":"2023-11-01 21:43:00","inspection_id":"80058316","insp_unit_id":"197849287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2101","insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:27.000000Z","updated_at":"2025-03-17T22:58:27.000000Z"}]},{"id":4190403,"change_date":"2023-10-13 21:40:00","inspection_id":"79903953","dot_number":"1748019","report_state":"NY","report_number":"M607100003","insp_date":"2023-10-10 00:00:00","insp_start_time":"1223","insp_end_time":"1252","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELL'S AUTO PARTS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"68358","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:51.000000Z","updated_at":"2025-03-17T19:45:51.000000Z","inspection_violations":[{"id":6488174,"change_date":"2023-10-13 21:40:00","inspection_id":"79903953","insp_violation_id":"255818229","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"197540020","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":6738898,"change_date":"2023-10-13 21:40:00","inspection_id":"79903953","insp_unit_id":"197540020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"Y","insp_unit_decal_number":"33401925","created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":3981099,"change_date":"2023-09-15 21:40:00","inspection_id":"79671708","dot_number":"1748019","report_state":"NY","report_number":"1L42000028","insp_date":"2023-09-15 00:00:00","insp_start_time":"1210","insp_end_time":"1240","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-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"2868604","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:35.000000Z","updated_at":"2025-03-17T19:41:35.000000Z","inspection_violations":[{"id":6157027,"change_date":"2023-09-15 21:40:00","inspection_id":"79671708","insp_violation_id":"255289128","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197073163","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":6401372,"change_date":"2023-09-15 21:40:00","inspection_id":"79671708","insp_unit_id":"197073163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:46.000000Z","updated_at":"2025-03-17T22:53:46.000000Z"}]},{"id":3383268,"change_date":"2023-06-28 21:42:00","inspection_id":"79002901","dot_number":"1748019","report_state":"VT","report_number":"50B0000179","insp_date":"2023-06-26 00:00:00","insp_start_time":"1100","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"1112","location_desc":"MT. HOLLY","county_code_state":"VT","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"199268","transaction_code":"A","transaction_date":"2023-06-26 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-26 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:08.000000Z","updated_at":"2025-03-17T19:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5438773,"change_date":"2023-06-28 21:42:00","inspection_id":"79002901","insp_unit_id":"195714206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:54.000000Z","updated_at":"2025-03-17T22:45:54.000000Z"}]},{"id":3361395,"change_date":"2023-06-26 21:40:00","inspection_id":"78978321","dot_number":"1748019","report_state":"NY","report_number":"SPG0194737","insp_date":"2023-06-21 00:00:00","insp_start_time":"0757","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CORNELLS USED PARTS","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2841064","transaction_code":"A","transaction_date":"2023-06-21 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-06-26 21:40:00","snet_input_date":"2023-06-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-26 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:43.000000Z","updated_at":"2025-03-17T19:29:43.000000Z","inspection_violations":[{"id":5184999,"change_date":"2023-06-26 21:40:00","inspection_id":"78978321","insp_violation_id":"253693764","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:05.000000Z","updated_at":"2025-03-17T21:31:05.000000Z","normalized_code":"3922"},{"id":5185000,"change_date":"2023-06-26 21:40:00","inspection_id":"78978321","insp_violation_id":"253693765","seq_no":"2","part_no":"391","part_no_section":"11(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:05.000000Z","updated_at":"2025-03-17T21:31:05.000000Z","normalized_code":"39111B1"}],"inspection_per_units":[{"id":5403350,"change_date":"2023-06-26 21:40:00","inspection_id":"78978321","insp_unit_id":"195666383","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:37.000000Z","updated_at":"2025-03-17T22:45:37.000000Z"}]},{"id":3101432,"change_date":"2023-05-22 21:40:00","inspection_id":"78684900","dot_number":"1748019","report_state":"VT","report_number":"MR87000007","insp_date":"2023-05-18 00:00:00","insp_start_time":"0857","insp_end_time":"0917","registration_date":null,"region":"ET","ci_status_code":"C","location":"1107SH","location_desc":"FAIR HAVEN SCALE HOUSE","county_code_state":"VT","county_code":"021","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELLS","shipping_paper_number":"113881","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-05-20 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"198721","transaction_code":"C","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-05-20 21:30:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-05-20 21:30:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:32.000000Z","updated_at":"2025-03-17T19:24:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4988628,"change_date":"2023-05-22 21:40:00","inspection_id":"78684900","insp_unit_id":"195058710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"Y","insp_unit_decal_number":"32779041","created_at":"2025-03-17T22:42:19.000000Z","updated_at":"2025-03-17T22:42:19.000000Z"}]},{"id":2814398,"change_date":"2023-04-17 21:40:00","inspection_id":"78360586","dot_number":"1748019","report_state":"NY","report_number":"1L31000277","insp_date":"2023-04-14 00:00:00","insp_start_time":"0855","insp_end_time":"0927","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"SCHENECTADY COUNTY AIRPORT","county_code_state":"NY","county_code":"093","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2816484","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-04-17 21:40:00","snet_input_date":"2023-04-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-04-17 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:32.000000Z","updated_at":"2025-03-17T19:18:32.000000Z","inspection_violations":[{"id":4318956,"change_date":"2023-04-17 21:40:00","inspection_id":"78360586","insp_violation_id":"252248871","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194412722","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:10.000000Z","updated_at":"2025-03-17T21:27:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4529591,"change_date":"2023-04-17 21:40:00","inspection_id":"78360586","insp_unit_id":"194412722","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:42.000000Z","updated_at":"2025-03-17T22:38:42.000000Z"}]},{"id":2453493,"change_date":"2023-02-27 21:41:00","inspection_id":"77949841","dot_number":"1748019","report_state":"VT","report_number":"3800003134","insp_date":"2023-02-23 00:00:00","insp_start_time":"1022","insp_end_time":"1041","registration_date":"2023-02-24 00:00:00","region":"ET","ci_status_code":"C","location":"1107SH","location_desc":"FAIR HAVEN SCALE HOUSE","county_code_state":"VT","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CORNELLS USED AUTO PARTS","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-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10050","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"197134","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-02-27 21:41:00","snet_input_date":"2023-02-23 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[{"id":3777321,"change_date":"2023-02-27 21:41:00","inspection_id":"77949841","insp_violation_id":"251346277","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"193587272","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"39355D1"},{"id":3777322,"change_date":"2023-02-27 21:41:00","inspection_id":"77949841","insp_violation_id":"251346278","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193587272","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"3939A"},{"id":3777323,"change_date":"2023-02-27 21:41:00","inspection_id":"77949841","insp_violation_id":"251346279","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193587272","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3948027,"change_date":"2023-02-27 21:41:00","inspection_id":"77949841","insp_unit_id":"193587272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1401","insp_unit_license":"68830MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL0DDA59462","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2322465,"change_date":"2023-02-08 21:39:00","inspection_id":"77800085","dot_number":"1748019","report_state":"VT","report_number":"4100003829","insp_date":"2023-02-02 00:00:00","insp_start_time":"1201","insp_end_time":"1218","registration_date":null,"region":"ET","ci_status_code":"C","location":"1105","location_desc":"CLARENDON\/ SB REST AREA","county_code_state":"VT","county_code":"021","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-02-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"196685","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":null,"census_search_date":"2023-02-08 21:39:00","snet_input_date":"2023-02-02 00:00:00","source_office":"1VTS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:35.000000Z","updated_at":"2025-03-17T19:09:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3737545,"change_date":"2023-02-08 21:39:00","inspection_id":"77800085","insp_unit_id":"193286756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:46.000000Z","updated_at":"2025-03-17T22:32:46.000000Z"}]},{"id":1857079,"change_date":"2022-12-02 21:40:00","inspection_id":"77268425","dot_number":"1748019","report_state":"NY","report_number":"SP3B260013","insp_date":"2022-11-29 00:00:00","insp_start_time":"1039","insp_end_time":"1055","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":"2022-12-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2776038","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2022-12-02 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-02 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:47.000000Z","updated_at":"2025-03-17T19:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2988170,"change_date":"2022-12-02 21:40:00","inspection_id":"77268425","insp_unit_id":"192225277","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:27.000000Z","updated_at":"2025-03-17T22:27:27.000000Z"}]},{"id":1083650,"change_date":"2022-08-19 21:35:00","inspection_id":"76375247","dot_number":"1748019","report_state":"NY","report_number":"1L34000129","insp_date":"2022-08-18 00:00:00","insp_start_time":"1018","insp_end_time":"1049","registration_date":null,"region":"ET","ci_status_code":"C","location":"10071M","location_desc":"1251 NEW SCOTLAND RD","county_code_state":"NY","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-19 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2741457","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2022-08-19 21:35:00","snet_input_date":"2022-08-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-19 21:35:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:52.000000Z","updated_at":"2025-03-17T18:46:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1742820,"change_date":"2022-08-19 21:35:00","inspection_id":"76375247","insp_unit_id":"190419283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2101","insp_unit_license":"81112NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D6MS207519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:00.000000Z","updated_at":"2025-03-17T22:19:00.000000Z"}]},{"id":498774,"change_date":"2022-05-27 21:40:00","inspection_id":"75687767","dot_number":"1748019","report_state":"NY","report_number":"0121004514","insp_date":"2022-05-26 00:00:00","insp_start_time":"1130","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"10242","location_desc":"DUANESBURG PARK&RIDE","county_code_state":"NY","county_code":"093","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2712010","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2022-05-27 21:40:00","snet_input_date":"2022-05-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-27 21:40:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:23.000000Z","updated_at":"2025-03-17T18:36:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":802157,"change_date":"2022-05-27 21:40:00","inspection_id":"75687767","insp_unit_id":"188952454","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"80584NB","insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"Y","insp_unit_decal_number":"31444656","created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"}]},{"id":334630,"change_date":"2022-05-06 21:38:00","inspection_id":"75492143","dot_number":"1748019","report_state":"NY","report_number":"SPWB030648","insp_date":"2022-05-05 00:00:00","insp_start_time":"1440","insp_end_time":"1459","registration_date":null,"region":"ET","ci_status_code":"C","location":"10598A","location_desc":"T\/NORTH HUDSON","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":"2022-05-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2703641","transaction_code":"A","transaction_date":"2022-05-06 00:00:00","upload_date":"2022-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2022-05-06 21:38:00","snet_input_date":"2022-05-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-06 21:38:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:21.000000Z","updated_at":"2025-03-17T18:33:21.000000Z","inspection_violations":[{"id":524993,"change_date":"2022-05-06 21:38:00","inspection_id":"75492143","insp_violation_id":"245621372","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:31.000000Z","updated_at":"2025-03-17T21:09:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":541236,"change_date":"2022-05-06 21:38:00","inspection_id":"75492143","insp_unit_id":"188542433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"80584NB","insp_unit_license":"80584NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DCDW1D3MS202097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:32.000000Z","updated_at":"2025-03-17T22:11:32.000000Z"}]},{"id":171259,"change_date":"2022-04-14 21:41:00","inspection_id":"75297143","dot_number":"1748019","report_state":"NY","report_number":"0117009254","insp_date":"2022-04-11 00:00:00","insp_start_time":"1202","insp_end_time":"1222","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":"2","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2695215","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":"01748019","upload_search_indicator":"M","census_search_date":"2022-04-14 21:41:00","snet_input_date":"2022-04-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-14 21:41:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","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":277520,"change_date":"2022-04-14 21:41:00","inspection_id":"75297143","insp_unit_id":"188143184","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"35983MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1BXHS802586","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":126166,"change_date":"2022-04-07 21:39:00","inspection_id":"75243165","dot_number":"1748019","report_state":"NY","report_number":"SPG0173879","insp_date":"2022-04-01 00:00:00","insp_start_time":"2301","insp_end_time":"2316","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2692855","transaction_code":"A","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01748019","upload_search_indicator":"M","census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"CORNELLS USED AUTO PARTS LLC","insp_carrier_street":"62 SOUTH GREENFIELD RD","insp_carrier_city":"GREENFIELD CENTER","insp_carrier_state":"NY","insp_carrier_zip_code":"12833","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:48.000000Z","updated_at":"2025-03-17T18:29:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":204189,"change_date":"2022-04-07 21:39:00","inspection_id":"75243165","insp_unit_id":"188033643","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1702","insp_unit_license":"61820NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACWDT4GHHK3601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:26.000000Z","updated_at":"2025-03-17T22:09:26.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1748019\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1748019\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1748019\/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\/1748019\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}