{"current_page":1,"data":[{"id":12094212,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","dot_number":"1289073","report_state":"NY","report_number":"SPG3041279","insp_date":"2026-05-28 00:00:00","insp_start_time":"1513","insp_end_time":"1604","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"191030","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3464252","transaction_code":"A","transaction_date":"2026-06-03 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:47.000000Z","updated_at":"2026-06-11T09:35:38.000000Z","inspection_violations":[{"id":21047308,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_violation_id":"274687680","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:44.000000Z","updated_at":"2026-06-11T09:49:42.000000Z","normalized_code":"3922SLLED"},{"id":21047309,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_violation_id":"274687681","seq_no":"2","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"213907405","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:44.000000Z","updated_at":"2026-06-11T09:49:42.000000Z","normalized_code":"3939ALTSIR"},{"id":21047310,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_violation_id":"274687682","seq_no":"3","part_no":"393","part_no_section":"130B-CHVE","insp_viol_unit":"2","insp_unit_id":"213907406","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-07T10:00:44.000000Z","updated_at":"2026-06-11T09:49:42.000000Z","normalized_code":"393130BCHVE"},{"id":21047311,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_violation_id":"274687683","seq_no":"4","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"213907406","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:44.000000Z","updated_at":"2026-06-11T09:49:42.000000Z","normalized_code":"393104F3C"}],"inspection_per_units":[{"id":21015122,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_unit_id":"213907405","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"47258PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X6SR134145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:51.000000Z","updated_at":"2026-06-11T09:09:06.000000Z"},{"id":21015123,"change_date":"2026-06-04 21:45:00","inspection_id":"88038253","insp_unit_id":"213907406","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"CE95062","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"57JE53307P35A2336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:51.000000Z","updated_at":"2026-06-11T09:09:06.000000Z"}]},{"id":12008145,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","dot_number":"1289073","report_state":"NY","report_number":"SPB4090102","insp_date":"2026-05-19 00:00:00","insp_start_time":"0759","insp_end_time":"0839","registration_date":"2026-05-27 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"INDIAN LAKE NY","county_code_state":"NY","county_code":"041","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-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"191003","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3396304","transaction_code":"C","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2026-05-25 21:34:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-25 21:34:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-28T09:39:20.000000Z","updated_at":"2026-06-07T09:30:09.000000Z","inspection_violations":[{"id":20892956,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_violation_id":"274525071","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"213770361","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:27.000000Z","updated_at":"2026-06-07T09:42:21.000000Z","normalized_code":"3969D2FTF"},{"id":20892955,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_violation_id":"274525070","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"213770361","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-28T09:57:27.000000Z","updated_at":"2026-06-07T09:42:21.000000Z","normalized_code":"3922SLLIFTA"},{"id":20892957,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_violation_id":"274525072","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"213770361","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S260835014","created_at":"2026-05-28T09:57:27.000000Z","updated_at":"2026-06-07T09:42:21.000000Z","normalized_code":"3922SLLEQP"},{"id":20892958,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_violation_id":"274525073","seq_no":"4","part_no":"383","part_no_section":"51A-LCDLRSWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"S260835013","created_at":"2026-05-28T09:57:27.000000Z","updated_at":"2026-06-07T09:42:21.000000Z","normalized_code":"38351ALCDLRSWD"}],"inspection_per_units":[{"id":20873982,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_unit_id":"213770361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"007","insp_unit_license":"51662PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWP4TX0TR218773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:42.000000Z","updated_at":"2026-06-07T09:01:14.000000Z"},{"id":20873983,"change_date":"2026-05-27 21:40:00","inspection_id":"87947037","insp_unit_id":"213770362","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"252","insp_unit_license":"CK38375","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2M5231400G1156276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-28T09:16:42.000000Z","updated_at":"2026-06-07T09:01:14.000000Z"}]},{"id":11602966,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","dot_number":"1289073","report_state":"NY","report_number":"SPB3101089","insp_date":"2026-04-02 00:00:00","insp_start_time":"0948","insp_end_time":"1158","registration_date":"2026-04-15 00:00:00","region":"ED","ci_status_code":"C","location":"10756","location_desc":"SCHROON LAKE NY","county_code_state":"NY","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-09 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"191003","viol_total":"9","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3132826","transaction_code":"C","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2026-04-09 21:54:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-09 21:54:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:30:24.000000Z","updated_at":"2026-04-27T09:30:24.000000Z","inspection_violations":[{"id":20246754,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639805","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213045698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"3939ALLPL"},{"id":20246755,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639806","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213045698","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"39617CPI"},{"id":20246756,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639807","seq_no":"3","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"3922WG"},{"id":20246757,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639808","seq_no":"4","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"3922WG"},{"id":20246758,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639809","seq_no":"5","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"3922WG"},{"id":20246759,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639810","seq_no":"6","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"213045697","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"39360D"},{"id":20246760,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639811","seq_no":"7","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"3922WG"},{"id":20246761,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639812","seq_no":"8","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"213045698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"39343DBIPBS"},{"id":20246762,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_violation_id":"273639813","seq_no":"9","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"213045698","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:43:56.000000Z","updated_at":"2026-04-27T09:43:56.000000Z","normalized_code":"39343DBIPBS"}],"inspection_per_units":[{"id":20279277,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_unit_id":"213045697","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"007","insp_unit_license":"51662PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWP4TX0TR218773","insp_unit_decal":"Y","insp_unit_decal_number":"36371076","created_at":"2026-04-27T09:02:57.000000Z","updated_at":"2026-04-27T09:02:57.000000Z"},{"id":20279278,"change_date":"2026-04-16 21:40:00","inspection_id":"87529905","insp_unit_id":"213045698","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":"252","insp_unit_license":"CK38375","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2M5231400G1156276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:02:57.000000Z","updated_at":"2026-04-27T09:02:57.000000Z"}]},{"id":11421920,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","dot_number":"1289073","report_state":"NY","report_number":"SPB3090969","insp_date":"2026-03-13 00:00:00","insp_start_time":"0902","insp_end_time":"0924","registration_date":"2026-03-26 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SCHROON LAKE 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":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"188045","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":"3027680","transaction_code":"C","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:24.000000Z","updated_at":"2026-04-07T09:30:04.000000Z","inspection_violations":[{"id":19406214,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","insp_violation_id":"272682805","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"212374111","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:19:35.000000Z","updated_at":"2026-04-07T09:46:12.000000Z","normalized_code":"39360D"},{"id":19406215,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","insp_violation_id":"272682806","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212374111","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:19:35.000000Z","updated_at":"2026-04-07T09:46:12.000000Z","normalized_code":"39617CPI"},{"id":19406216,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","insp_violation_id":"272682807","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"212374111","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:19:35.000000Z","updated_at":"2026-04-07T09:46:12.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":19688594,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","insp_unit_id":"212374111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"47258PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X6SR134145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:11.000000Z","updated_at":"2026-04-07T09:06:04.000000Z"},{"id":19688595,"change_date":"2026-03-27 21:39:00","inspection_id":"87337694","insp_unit_id":"212374112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":null,"insp_unit_license":"CH88357","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2M5241469K1178738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:11.000000Z","updated_at":"2026-04-07T09:06:04.000000Z"}]},{"id":11186505,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","dot_number":"1289073","report_state":"NY","report_number":"SPB3090938","insp_date":"2026-02-13 00:00:00","insp_start_time":"0001","insp_end_time":"1028","registration_date":"2026-03-03 00:00:00","region":"ES","ci_status_code":"C","location":"10756","location_desc":"SCHROON LAKE NY","county_code_state":"NY","county_code":"031","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"188165","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2910772","transaction_code":"C","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2026-02-20 21:38:00","snet_input_date":"2026-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-20 21:38:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-23T10:37:49.000000Z","updated_at":"2026-03-15T09:30:04.000000Z","inspection_violations":[{"id":18965200,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","insp_violation_id":"272190598","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"211962190","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-07T10:57:14.000000Z","updated_at":"2026-03-15T09:41:38.000000Z","normalized_code":"39345B2BHTD"},{"id":18965201,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","insp_violation_id":"272190599","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211962189","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-07T10:57:14.000000Z","updated_at":"2026-03-15T09:41:38.000000Z","normalized_code":"39360D"},{"id":18965202,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","insp_violation_id":"272190600","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"211962190","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-07T10:57:14.000000Z","updated_at":"2026-03-15T09:41:38.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":19291762,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","insp_unit_id":"211962189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"47258PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X6SR134145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:37.000000Z","updated_at":"2026-03-15T09:03:13.000000Z"},{"id":19291763,"change_date":"2026-03-04 21:40:00","inspection_id":"87096558","insp_unit_id":"211962190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANAC","insp_unit_company":null,"insp_unit_license":"CH88357","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2M5241469K1178738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:37.000000Z","updated_at":"2026-03-15T09:03:13.000000Z"}]},{"id":9932133,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","dot_number":"1289073","report_state":"NY","report_number":"D103500397","insp_date":"2025-10-07 00:00:00","insp_start_time":"1309","insp_end_time":"1415","registration_date":"2025-10-21 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":"166580","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2405080","transaction_code":"C","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:29.000000Z","updated_at":"2025-10-26T10:00:25.000000Z","inspection_violations":[{"id":16536026,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_violation_id":"269448443","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209597111","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:38.000000Z","normalized_code":"39347E"},{"id":16536027,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_violation_id":"269448444","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"209597111","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:38.000000Z","normalized_code":"39353BB"},{"id":16536028,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_violation_id":"269448445","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209597110","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:38.000000Z","normalized_code":"39360D"},{"id":16536029,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_violation_id":"269448446","seq_no":"4","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:38.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":16614989,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_unit_id":"209597110","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"49334PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWP4EX5RR382882","insp_unit_decal":"Y","insp_unit_decal_number":"35747914","created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:28.000000Z"},{"id":16614990,"change_date":"2025-10-22 21:39:00","inspection_id":"86038107","insp_unit_id":"209597111","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HALL. R.D.","insp_unit_company":null,"insp_unit_license":"3142738","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5MC124818L3197487","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:28.000000Z"}]},{"id":9700594,"change_date":"2025-09-17 21:40:00","inspection_id":"85795146","dot_number":"1289073","report_state":"NY","report_number":"SPG3080306","insp_date":"2025-09-10 00:00:00","insp_start_time":"1350","insp_end_time":"1406","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":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-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","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":"2285354","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:37.000000Z","updated_at":"2025-09-23T10:01:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16059416,"change_date":"2025-09-17 21:40:00","inspection_id":"85795146","insp_unit_id":"208989775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"46627PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWGGGG20J184352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:44.000000Z","updated_at":"2025-09-21T09:45:11.000000Z"},{"id":16059417,"change_date":"2025-09-17 21:40:00","inspection_id":"85795146","insp_unit_id":"208989776","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"3143114","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"13N1482C8D1557099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:44.000000Z","updated_at":"2025-09-21T09:45:11.000000Z"}]},{"id":9455611,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","dot_number":"1289073","report_state":"NY","report_number":"SPB3100668","insp_date":"2025-08-13 00:00:00","insp_start_time":"1058","insp_end_time":"1132","registration_date":"2025-08-26 00:00:00","region":"ED","ci_status_code":"C","location":"10598S","location_desc":"NORTH HUDSON NY","county_code_state":"NY","county_code":"031","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-08-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2150850","transaction_code":"C","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2025-08-20 21:39:00","snet_input_date":"2025-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-20 21:39:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:43.000000Z","updated_at":"2025-09-05T10:46:19.000000Z","inspection_violations":[{"id":15507641,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255241","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"208586884","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39343DBMA"},{"id":15507642,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255242","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208586883","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39395A1"},{"id":15507643,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255243","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208586883","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39395F"},{"id":15507644,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255244","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"208586883","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"3922SLLIFTA"},{"id":15507645,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255245","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"208586883","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"3922SLLUCR"},{"id":15507646,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255246","seq_no":"6","part_no":"393","part_no_section":"70D-CDTSDNS","insp_viol_unit":"2","insp_unit_id":"208586884","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39370DCDTSDNS"},{"id":15507647,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255247","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208586883","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39617CPI"},{"id":15507648,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_violation_id":"268255248","seq_no":"8","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208586884","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:38.000000Z","updated_at":"2025-09-05T10:49:38.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15687327,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_unit_id":"208586883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"26803NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT8W4DT2NED28382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:37.000000Z","updated_at":"2025-09-05T09:45:35.000000Z"},{"id":15687328,"change_date":"2025-08-26 21:40:00","inspection_id":"85538087","insp_unit_id":"208586884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"253386D","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFH302XML009073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:37.000000Z","updated_at":"2025-09-05T09:45:35.000000Z"}]},{"id":9162806,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","dot_number":"1289073","report_state":"NY","report_number":"D103101136","insp_date":"2025-07-15 00:00:00","insp_start_time":"1140","insp_end_time":"1224","registration_date":"2025-07-27 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SARATOGA SPRINGS 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-07-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73750","viol_total":"4","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":"1999785","transaction_code":"C","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2025-07-16 21:40:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-16 21:40:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:31.000000Z","updated_at":"2025-09-16T10:46:22.000000Z","inspection_violations":[{"id":15799131,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","insp_violation_id":"268603648","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208868231","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:56:40.000000Z","updated_at":"2025-09-14T11:56:40.000000Z","normalized_code":"39360D"},{"id":15799132,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","insp_violation_id":"268603649","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208868231","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4218KKCXVW","created_at":"2025-09-14T11:56:40.000000Z","updated_at":"2025-09-14T11:56:40.000000Z","normalized_code":"39021TB2DOT"},{"id":15799133,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","insp_violation_id":"268603650","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"208868231","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4218KKD0NJ","created_at":"2025-09-14T11:56:40.000000Z","updated_at":"2025-09-14T11:56:40.000000Z","normalized_code":"3922SLLEQP"},{"id":15799134,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","insp_violation_id":"268603651","seq_no":"4","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"208868231","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4218KKD0RS","created_at":"2025-09-14T11:56:40.000000Z","updated_at":"2025-09-14T11:56:40.000000Z","normalized_code":"39311A1LCHL"}],"inspection_per_units":[{"id":15943527,"change_date":"2025-09-11 21:41:00","inspection_id":"85230002","insp_unit_id":"208868231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"62339NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWP4TX4SR133725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:31.000000Z","updated_at":"2025-09-15T09:52:45.000000Z"}]},{"id":9036662,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","dot_number":"1289073","report_state":"NY","report_number":"SPB3060955","insp_date":"2025-06-24 00:00:00","insp_start_time":"1426","insp_end_time":"1501","registration_date":"2025-07-06 00:00:00","region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"139200","viol_total":"4","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":"1935614","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","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":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:08.000000Z","updated_at":"2025-09-23T10:02:33.000000Z","inspection_violations":[{"id":15963011,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_violation_id":"268802463","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209042785","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:04.000000Z","updated_at":"2025-09-23T10:15:07.000000Z","normalized_code":"3922SLLIFTA"},{"id":15963012,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_violation_id":"268802464","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"209042785","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:04.000000Z","updated_at":"2025-09-23T10:15:07.000000Z","normalized_code":"39311A1CSLRR"},{"id":15963013,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_violation_id":"268802465","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209042785","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:04.000000Z","updated_at":"2025-09-23T10:15:07.000000Z","normalized_code":"39360D"},{"id":15963014,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_violation_id":"268802466","seq_no":"4","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209042786","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:04.000000Z","updated_at":"2025-09-23T10:15:07.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16101514,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_unit_id":"209042785","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":"002","insp_unit_license":"14739BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWD40X4GR124611","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:46:56.000000Z","updated_at":"2025-09-23T09:45:07.000000Z"},{"id":16101515,"change_date":"2025-09-19 21:38:00","inspection_id":"85097162","insp_unit_id":"209042786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENSON TRU","insp_unit_company":null,"insp_unit_license":"CH88829","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5DMFABTB16T000687","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:46:56.000000Z","updated_at":"2025-09-23T09:45:07.000000Z"}]},{"id":7390098,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","dot_number":"1289073","report_state":"VT","report_number":"50B0001495","insp_date":"2024-12-09 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":"2024-12-27 00:00:00","region":"ET","ci_status_code":"C","location":"1405","location_desc":"BRIDGEWATER \/ KILLINGTON LINE","county_code_state":"VT","county_code":"027","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":"N","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"212452","transaction_code":"C","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":null,"census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"1VTS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:18.000000Z","updated_at":"2025-03-17T20:50:18.000000Z","inspection_violations":[{"id":11545754,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_violation_id":"263691839","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204590485","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39395A1"},{"id":11545755,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_violation_id":"263691840","seq_no":"5","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204590485","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39395F"},{"id":11545756,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_violation_id":"263691841","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39141AMCPC"},{"id":11545757,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_violation_id":"263691842","seq_no":"2","part_no":"390","part_no_section":"19TG","insp_viol_unit":"1","insp_unit_id":"204590485","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39019TG"},{"id":11545758,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_violation_id":"263691843","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"204590485","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":11921394,"change_date":"2024-12-30 21:39:00","inspection_id":"83363325","insp_unit_id":"204590485","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"44682MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FD0W4HT4KEF60450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:38.000000Z","updated_at":"2025-03-17T23:46:38.000000Z"}]},{"id":5973121,"change_date":"2024-06-12 21:42:00","inspection_id":"81853254","dot_number":"1289073","report_state":"NY","report_number":"SPG0251560","insp_date":"2024-06-11 00:00:00","insp_start_time":"1146","insp_end_time":"1203","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":"2024-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"2929046","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":"M","census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:06.000000Z","updated_at":"2025-03-17T20:21:06.000000Z","inspection_violations":[{"id":9266165,"change_date":"2024-06-12 21:42:00","inspection_id":"81853254","insp_violation_id":"260043812","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"201356964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:51.000000Z","updated_at":"2025-03-17T21:50:51.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":9621060,"change_date":"2024-06-12 21:42:00","inspection_id":"81853254","insp_unit_id":"201356964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"62339NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XKWP4TX4SR133725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:45.000000Z","updated_at":"2025-03-17T23:22:45.000000Z"}]},{"id":5894706,"change_date":"2024-06-03 21:42:00","inspection_id":"81767790","dot_number":"1289073","report_state":"NY","report_number":"SPB0362893","insp_date":"2024-05-30 00:00:00","insp_start_time":"1100","insp_end_time":"1124","registration_date":null,"region":"ET","ci_status_code":"C","location":"20483","location_desc":"LONG LAKE","county_code_state":"NY","county_code":"041","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EMERSON EXCAVATING AND TRUCKING 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":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2927410","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01289073","upload_search_indicator":"M","census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"EMERSON EXCAVATING & TRUCKING LLC","insp_carrier_street":"254 HARRIS RD","insp_carrier_city":"CORINTH","insp_carrier_state":"NY","insp_carrier_zip_code":"12822","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[{"id":9139787,"change_date":"2024-06-03 21:42:00","inspection_id":"81767790","insp_violation_id":"259856966","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201195098","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4J3K2JC","created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":9494415,"change_date":"2024-06-03 21:42:00","inspection_id":"81767790","insp_unit_id":"201195098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"45328 NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1NKWXUE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1289073\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1289073\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1289073\/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\/1289073\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}