{"current_page":1,"data":[{"id":11864672,"change_date":"2026-05-09 21:35:00","inspection_id":"87801385","dot_number":"2276780","report_state":"NJ","report_number":"SPRBI03092","insp_date":"2026-05-09 00:00:00","insp_start_time":"0940","insp_end_time":"1006","registration_date":null,"region":"ES","ci_status_code":"C","location":"0223","location_desc":"NJ","county_code_state":"NJ","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-09 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3291283","transaction_code":"A","transaction_date":"2026-05-09 00:00:00","upload_date":"2026-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2026-05-09 21:35:00","snet_input_date":"2026-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-09 21:35:00","insp_carrier_name":"EXECUTIVE TRIM CONST","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-12T09:39:35.000000Z","updated_at":"2026-05-20T09:30:35.000000Z","inspection_violations":[{"id":20637232,"change_date":"2026-05-09 21:35:00","inspection_id":"87801385","insp_violation_id":"274150414","seq_no":"2","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-05-12T09:58:49.000000Z","updated_at":"2026-05-20T09:42:16.000000Z","normalized_code":"39141APC"},{"id":20637231,"change_date":"2026-05-09 21:35:00","inspection_id":"87801385","insp_violation_id":"274150413","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-05-12T09:58:49.000000Z","updated_at":"2026-05-20T09:42:16.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20631005,"change_date":"2026-05-09 21:35:00","inspection_id":"87801385","insp_unit_id":"213462431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-12T09:15:51.000000Z","updated_at":"2026-05-20T09:02:24.000000Z"}]},{"id":11629666,"change_date":"2026-04-13 21:37:00","inspection_id":"87558265","dot_number":"2276780","report_state":"NY","report_number":"M005700262","insp_date":"2026-04-09 00:00:00","insp_start_time":"1226","insp_end_time":"1248","registration_date":null,"region":"ED","ci_status_code":"C","location":"80288","location_desc":"FISHKILL NY","county_code_state":"NY","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":"U","pen_cen_match":"I","final_status_date":"2026-04-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3150546","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2026-04-13 21:37:00","snet_input_date":"2026-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-13 21:37:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-24T09:30:36.000000Z","updated_at":"2026-04-24T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20227447,"change_date":"2026-04-13 21:37:00","inspection_id":"87558265","insp_unit_id":"212981371","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:03:01.000000Z","updated_at":"2026-04-24T09:03:01.000000Z"}]},{"id":11382674,"change_date":"2026-03-24 21:39:00","inspection_id":"87296868","dot_number":"2276780","report_state":"NY","report_number":"SPT3141689","insp_date":"2026-03-09 00:00:00","insp_start_time":"1742","insp_end_time":"1804","registration_date":"2026-03-24 00:00:00","region":"ED","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3009418","transaction_code":"C","transaction_date":"2026-03-15 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2026-03-16 21:38:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-16 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-19T09:37:41.000000Z","updated_at":"2026-04-04T09:30:32.000000Z","inspection_violations":[{"id":19337223,"change_date":"2026-03-24 21:39:00","inspection_id":"87296868","insp_violation_id":"272599514","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"212301745","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:09:46.000000Z","updated_at":"2026-04-03T09:53:02.000000Z","normalized_code":"3939ALBL"},{"id":19337222,"change_date":"2026-03-24 21:39:00","inspection_id":"87296868","insp_violation_id":"272599513","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"212301745","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-27T10:09:46.000000Z","updated_at":"2026-04-03T09:53:02.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":19626997,"change_date":"2026-03-24 21:39:00","inspection_id":"87296868","insp_unit_id":"212301745","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-27T09:22:53.000000Z","updated_at":"2026-04-04T09:03:18.000000Z"}]},{"id":10808459,"change_date":"2026-01-20 21:39:00","inspection_id":"86835469","dot_number":"2276780","report_state":"NY","report_number":"0L07001072","insp_date":"2026-01-14 00:00:00","insp_start_time":"1008","insp_end_time":"1025","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","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-01-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2791114","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2026-01-20 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-20 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:12.000000Z","updated_at":"2026-01-31T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18148682,"change_date":"2026-01-20 21:39:00","inspection_id":"86835469","insp_unit_id":"211172291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"51814","insp_unit_license":"62859NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMNXLH873772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:16.000000Z","updated_at":"2026-01-31T10:02:40.000000Z"}]},{"id":10445381,"change_date":"2025-12-16 21:37:00","inspection_id":"86577646","dot_number":"2276780","report_state":"NY","report_number":"SPE3071202","insp_date":"2025-12-09 00:00:00","insp_start_time":"1650","insp_end_time":"1708","registration_date":null,"region":"ES","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES NY","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"EXECUTIVE TRIM CONSTRUCTION","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-12-16 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2662545","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-12-16 21:37:00","snet_input_date":"2025-12-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-16 21:37:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:33.000000Z","updated_at":"2025-12-27T10:30:13.000000Z","inspection_violations":[{"id":17517467,"change_date":"2025-12-16 21:37:00","inspection_id":"86577646","insp_violation_id":"270706005","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"210628052","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-19T10:32:28.000000Z","updated_at":"2025-12-27T10:30:21.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":17474512,"change_date":"2025-12-16 21:37:00","inspection_id":"86577646","insp_unit_id":"210628052","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"NONE","insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:01:54.000000Z","updated_at":"2025-12-27T10:00:18.000000Z"}]},{"id":9447144,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","dot_number":"2276780","report_state":"MD","report_number":"0246C00527","insp_date":"2025-08-18 00:00:00","insp_start_time":"1255","insp_end_time":"1325","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PORT DEPOSIT MD","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2148918","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:22.000000Z","updated_at":"2025-08-23T10:46:22.000000Z","inspection_violations":[{"id":15384379,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","insp_violation_id":"268110867","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":"WARNING","created_at":"2025-08-22T10:44:51.000000Z","updated_at":"2025-08-23T10:47:52.000000Z","normalized_code":"3922SLLTCD"},{"id":15384380,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","insp_violation_id":"268110868","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-08-22T10:44:51.000000Z","updated_at":"2025-08-23T10:47:52.000000Z","normalized_code":"3958A1HOSP"},{"id":15384381,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","insp_violation_id":"268110869","seq_no":"3","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"208465354","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-08-22T10:44:51.000000Z","updated_at":"2025-08-23T10:47:52.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":15384382,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","insp_violation_id":"268110870","seq_no":"4","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":"WARNING","created_at":"2025-08-22T10:44:51.000000Z","updated_at":"2025-08-23T10:47:52.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":15577801,"change_date":"2025-08-19 21:40:00","inspection_id":"85529115","insp_unit_id":"208465354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62825NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1D9RS220286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:37.000000Z","updated_at":"2025-08-23T09:45:32.000000Z"}]},{"id":9026836,"change_date":"2025-09-15 21:39:00","inspection_id":"85086875","dot_number":"2276780","report_state":"NY","report_number":"SPT3071058","insp_date":"2025-06-24 00:00:00","insp_start_time":"0817","insp_end_time":"0832","registration_date":"2025-07-10 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-06-30 21:39: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":"1932697","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-06-30 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-30 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:37.000000Z","updated_at":"2025-09-18T10:00:16.000000Z","inspection_violations":[{"id":15866179,"change_date":"2025-09-15 21:39:00","inspection_id":"85086875","insp_violation_id":"268683675","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208945199","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:20:27.000000Z","updated_at":"2025-09-18T10:20:27.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":16016622,"change_date":"2025-09-15 21:39:00","inspection_id":"85086875","insp_unit_id":"208945199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62825NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1D9RS220286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:23.000000Z","updated_at":"2025-09-18T09:45:23.000000Z"}]},{"id":9037476,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","dot_number":"2276780","report_state":"NY","report_number":"SPD3010944","insp_date":"2025-06-24 00:00:00","insp_start_time":"1143","insp_end_time":"1207","registration_date":"2025-07-08 00:00:00","region":"ED","ci_status_code":"C","location":"05","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":"EXECUTIVE GROUP","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":"33000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1936437","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","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":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:09.000000Z","updated_at":"2025-09-16T10:48:03.000000Z","inspection_violations":[{"id":15835312,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651223","seq_no":"1","part_no":"392","part_no_section":"8-D","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-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"3928D"},{"id":15835313,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651224","seq_no":"2","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"208913110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"39311A1LBL"},{"id":15835314,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651225","seq_no":"3","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"208913110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"39311A1LLPL"},{"id":15835315,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651226","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208913110","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"39375A3TAOL"},{"id":15835316,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651227","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208913110","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D32KH55Z0","created_at":"2025-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"39395A1"},{"id":15835317,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_violation_id":"268651228","seq_no":"6","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208913110","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D32KH563S","created_at":"2025-09-14T11:57:38.000000Z","updated_at":"2025-09-16T10:50:22.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":15984865,"change_date":"2025-09-12 21:49:00","inspection_id":"85098021","insp_unit_id":"208913110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":null,"insp_unit_license":"14100BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMNXLH873772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:52.000000Z","updated_at":"2025-09-16T09:55:29.000000Z"}]},{"id":8908831,"change_date":"2025-06-16 21:39:00","inspection_id":"84962300","dot_number":"2276780","report_state":"NJ","report_number":"SPEJI03220","insp_date":"2025-06-13 00:00:00","insp_start_time":"1220","insp_end_time":"1234","registration_date":null,"region":"ET","ci_status_code":"C","location":"1309","location_desc":"COLTS NECK","county_code_state":"NJ","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1294664","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:22.000000Z","updated_at":"2025-06-20T10:00:21.000000Z","inspection_violations":[{"id":14286341,"change_date":"2025-06-16 21:39:00","inspection_id":"84962300","insp_violation_id":"266864039","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1304W25060473","created_at":"2025-06-19T10:15:31.000000Z","updated_at":"2025-06-20T10:15:41.000000Z","normalized_code":"3922SLLS3"},{"id":14286342,"change_date":"2025-06-16 21:39:00","inspection_id":"84962300","insp_violation_id":"266864040","seq_no":"2","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":"2025-06-19T10:15:31.000000Z","updated_at":"2025-06-20T10:15:41.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14596575,"change_date":"2025-06-16 21:39:00","inspection_id":"84962300","insp_unit_id":"207404193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:20.000000Z","updated_at":"2025-06-20T09:45:27.000000Z"}]},{"id":8324896,"change_date":"2025-04-09 21:40:00","inspection_id":"84345621","dot_number":"2276780","report_state":"NY","report_number":"SPT3070817","insp_date":"2025-04-02 00:00:00","insp_start_time":"0958","insp_end_time":"1014","registration_date":null,"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-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1569829","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-04-09 21:40:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:23:57.000000Z","updated_at":"2025-04-14T10:22:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13502832,"change_date":"2025-04-09 21:40:00","inspection_id":"84345621","insp_unit_id":"206213405","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-12T10:03:24.000000Z","updated_at":"2025-04-13T09:51:28.000000Z"}]},{"id":8315637,"change_date":"2025-04-08 21:39:00","inspection_id":"84336035","dot_number":"2276780","report_state":"NY","report_number":"SPC3030571","insp_date":"2025-04-01 00:00:00","insp_start_time":"1453","insp_end_time":"1507","registration_date":null,"region":"ED","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES NY","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"EXECUTIVE GROUP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20500","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":"1565930","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-04-08 21:39:00","snet_input_date":"2025-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-08 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:53.000000Z","updated_at":"2025-04-12T10:19:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13486205,"change_date":"2025-04-08 21:39:00","inspection_id":"84336035","insp_unit_id":"206195355","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62825NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DC4W1D9RS220286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T09:59:40.000000Z","updated_at":"2025-04-12T09:51:09.000000Z"}]},{"id":7962561,"change_date":"2025-02-26 21:41:00","inspection_id":"83964404","dot_number":"2276780","report_state":"NY","report_number":"SPT3140496","insp_date":"2025-02-19 00:00:00","insp_start_time":"1818","insp_end_time":"1836","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ALBANY NY","county_code_state":"NY","county_code":"001","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-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1400338","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-02-26 21:41:00","snet_input_date":"2025-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-26 21:41:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[{"id":12443065,"change_date":"2025-02-26 21:41:00","inspection_id":"83964404","insp_violation_id":"264703565","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205502358","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"39617CPI"},{"id":12443066,"change_date":"2025-02-26 21:41:00","inspection_id":"83964404","insp_violation_id":"264703566","seq_no":"2","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":"2025-03-17T22:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"3922SLLLR"},{"id":12443067,"change_date":"2025-02-26 21:41:00","inspection_id":"83964404","insp_violation_id":"264703567","seq_no":"3","part_no":"391","part_no_section":"41A","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:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":12854026,"change_date":"2025-02-26 21:41:00","inspection_id":"83964404","insp_unit_id":"205502358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:58.000000Z","updated_at":"2025-03-17T23:56:58.000000Z"}]},{"id":7613839,"change_date":"2025-01-14 21:54:00","inspection_id":"83598378","dot_number":"2276780","report_state":"NY","report_number":"M607300091","insp_date":"2025-01-13 00:00:00","insp_start_time":"1227","insp_end_time":"1253","registration_date":null,"region":"ES","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES NY","county_code_state":"NY","county_code":"111","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-01-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246507","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11902478,"change_date":"2025-01-14 21:54:00","inspection_id":"83598378","insp_violation_id":"263984766","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204819573","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"39021TB2DOT"},{"id":11902479,"change_date":"2025-01-14 21:54:00","inspection_id":"83598378","insp_violation_id":"263984767","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204819573","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":12285367,"change_date":"2025-01-14 21:54:00","inspection_id":"83598378","insp_unit_id":"204819573","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:37.000000Z","updated_at":"2025-03-17T23:50:37.000000Z"}]},{"id":7514686,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","dot_number":"2276780","report_state":"NY","report_number":"D102600734","insp_date":"2024-12-27 00:00:00","insp_start_time":"1021","insp_end_time":"1050","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"TROY NY","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":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-12-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","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":"1201856","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2024-12-30 21:38:00","snet_input_date":"2024-12-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-30 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:43.000000Z","updated_at":"2025-03-17T20:52:43.000000Z","inspection_violations":[{"id":11744714,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","insp_violation_id":"263683857","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204583497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3922SLLIFTA"},{"id":11744715,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","insp_violation_id":"263683858","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"204583497","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"B4PGJV26KG","created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"3939ALTSI"},{"id":11744716,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","insp_violation_id":"263683859","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"204583497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39021TB1MC"},{"id":11744717,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","insp_violation_id":"263683860","seq_no":"4","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204583497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:15.000000Z","updated_at":"2025-03-17T22:03:15.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":12123541,"change_date":"2024-12-30 21:38:00","inspection_id":"83494158","insp_unit_id":"204583497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"62826NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"54DK6S1FXSSA00485","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:50.000000Z","updated_at":"2025-03-17T23:48:50.000000Z"}]},{"id":6204750,"change_date":"2024-07-12 21:39:00","inspection_id":"82102709","dot_number":"2276780","report_state":"NY","report_number":"SPT0560668","insp_date":"2024-07-11 00:00:00","insp_start_time":"0933","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":"12001C","location_desc":"ALBANY (EXIT 24 PLAZA)","county_code_state":"NY","county_code":"001","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-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2936076","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2024-07-12 21:39:00","snet_input_date":"2024-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:45.000000Z","updated_at":"2025-03-17T20:25:45.000000Z","inspection_violations":[{"id":9637264,"change_date":"2024-07-12 21:39:00","inspection_id":"82102709","insp_violation_id":"260609469","seq_no":"1","part_no":"392","part_no_section":"82(a)(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:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":9995783,"change_date":"2024-07-12 21:39:00","inspection_id":"82102709","insp_unit_id":"201855603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"51801","insp_unit_license":"68876MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W168J7K01272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:36.000000Z","updated_at":"2025-03-17T23:26:36.000000Z"}]},{"id":6044922,"change_date":"2024-06-21 21:38:00","inspection_id":"81930899","dot_number":"2276780","report_state":"NY","report_number":"SP2T340019","insp_date":"2024-06-20 00:00:00","insp_start_time":"1045","insp_end_time":"2308","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749A","location_desc":"SAUGERTIES","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2931471","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2024-06-21 21:38:00","snet_input_date":"2024-06-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-21 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:35.000000Z","updated_at":"2025-03-17T20:22:35.000000Z","inspection_violations":[{"id":9376724,"change_date":"2024-06-21 21:38:00","inspection_id":"81930899","insp_violation_id":"260228703","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201522164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9735934,"change_date":"2024-06-21 21:38:00","inspection_id":"81930899","insp_unit_id":"201522164","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30412TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN5LH873775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:53.000000Z","updated_at":"2025-03-17T23:23:53.000000Z"}]},{"id":5753512,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","dot_number":"2276780","report_state":"NC","report_number":"0006647251","insp_date":"2024-05-14 00:00:00","insp_start_time":"0924","insp_end_time":"1014","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION, I-95,","county_code_state":"NC","county_code":"155","insp_level_id":"1","service_center":"SH","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-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2180971","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-15 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[{"id":8904693,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","insp_violation_id":"259514471","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3289279","created_at":"2025-03-17T21:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"38323A2"},{"id":8904694,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","insp_violation_id":"259514472","seq_no":"2","part_no":"392","part_no_section":"2","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:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"3922"},{"id":8904695,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","insp_violation_id":"259514473","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200902159","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"39617C"},{"id":8904696,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","insp_violation_id":"259514474","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200902159","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:06.000000Z","updated_at":"2025-03-17T21:49:06.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":9266824,"change_date":"2024-05-15 21:43:00","inspection_id":"81614912","insp_unit_id":"200902159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"14100BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMNXLH873772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:15.000000Z","updated_at":"2025-03-17T23:19:15.000000Z"}]},{"id":4856720,"change_date":"2024-01-18 21:45:00","inspection_id":"80636459","dot_number":"2276780","report_state":"NY","report_number":"SPT0550202","insp_date":"2024-01-17 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923B","location_desc":"WOODBURY INSPECTION SITE","county_code_state":"NY","county_code":"071","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-01-18 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2900451","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2024-01-18 21:45:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-18 21:45:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:52.000000Z","updated_at":"2025-03-17T19:58:52.000000Z","inspection_violations":[{"id":7486508,"change_date":"2024-01-18 21:45:00","inspection_id":"80636459","insp_violation_id":"257393311","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:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"3922"},{"id":7486509,"change_date":"2024-01-18 21:45:00","inspection_id":"80636459","insp_violation_id":"257393312","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2HM8GNF","created_at":"2025-03-17T21:42:08.000000Z","updated_at":"2025-03-17T21:42:08.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":7813984,"change_date":"2024-01-18 21:45:00","inspection_id":"80636459","insp_unit_id":"199010971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30403TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAN1KH142385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:49.000000Z","updated_at":"2025-03-17T23:05:49.000000Z"}]},{"id":4719605,"change_date":"2023-12-28 21:44:00","inspection_id":"80486720","dot_number":"2276780","report_state":"NY","report_number":"SPT0550117","insp_date":"2023-12-27 00:00:00","insp_start_time":"0902","insp_end_time":"0918","registration_date":null,"region":"ET","ci_status_code":"C","location":"80923B","location_desc":"WOODBURY INSPECTION SITE SOUTH","county_code_state":"NY","county_code":"071","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-28 21:44: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":"2896128","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-12-28 21:44:00","snet_input_date":"2023-12-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-28 21:44:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:14.000000Z","updated_at":"2025-03-17T19:56:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7591210,"change_date":"2023-12-28 21:44:00","inspection_id":"80486720","insp_unit_id":"198701495","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"51810","insp_unit_license":"68991MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W160K7008888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:52.000000Z","updated_at":"2025-03-17T23:03:52.000000Z"}]},{"id":4649430,"change_date":"2023-12-18 21:41:00","inspection_id":"80410041","dot_number":"2276780","report_state":"MD","report_number":"3019003338","insp_date":"2023-12-16 00:00:00","insp_start_time":"1210","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"012","location_desc":"I-95 SOUTHBOUND SCALE FACILITY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"EXECUTIVE TRIM CONSTRUCTION INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2684358","transaction_code":"A","transaction_date":"2023-12-16 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-16 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7477783,"change_date":"2023-12-18 21:41:00","inspection_id":"80410041","insp_unit_id":"198545571","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"51813","insp_unit_license":"30412TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN5LH873775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:52.000000Z","updated_at":"2025-03-17T23:02:52.000000Z"}]},{"id":4029769,"change_date":"2023-09-22 21:38:00","inspection_id":"79725669","dot_number":"2276780","report_state":"NY","report_number":"SPT0482751","insp_date":"2023-09-19 00:00:00","insp_start_time":"0853","insp_end_time":"0908","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","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-09-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2871992","transaction_code":"A","transaction_date":"2023-09-22 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-09-22 21:38:00","snet_input_date":"2023-09-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-22 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:25.000000Z","updated_at":"2025-03-17T19:42:25.000000Z","inspection_violations":[{"id":6237569,"change_date":"2023-09-22 21:38:00","inspection_id":"79725669","insp_violation_id":"255415630","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197179652","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"39395A"},{"id":6237570,"change_date":"2023-09-22 21:38:00","inspection_id":"79725669","insp_violation_id":"255415631","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197179652","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:05.000000Z","updated_at":"2025-03-17T21:36:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6479238,"change_date":"2023-09-22 21:38:00","inspection_id":"79725669","insp_unit_id":"197179652","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"68876MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W168J7K01272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:22.000000Z","updated_at":"2025-03-17T22:54:22.000000Z"}]},{"id":3797515,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","dot_number":"2276780","report_state":"NY","report_number":"SPB0371995","insp_date":"2023-08-16 00:00:00","insp_start_time":"1138","insp_end_time":"1204","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2861047","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-08-22 21:42:00","snet_input_date":"2023-08-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-22 21:42:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:44.000000Z","updated_at":"2025-03-17T19:37:44.000000Z","inspection_violations":[{"id":5858097,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_violation_id":"254791830","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"38323A2"},{"id":5858098,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_violation_id":"254791831","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196653664","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39395A"},{"id":5858099,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_violation_id":"254791832","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196653664","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1H2TL0K","created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3939A"},{"id":5858100,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_violation_id":"254791833","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"196653664","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39355D1"},{"id":5858101,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_violation_id":"254791834","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196653664","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6105800,"change_date":"2023-08-22 21:42:00","inspection_id":"79467011","insp_unit_id":"196653664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30402TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAN3KH145532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:19.000000Z","updated_at":"2025-03-17T22:51:19.000000Z"}]},{"id":3291120,"change_date":"2023-06-15 21:42:00","inspection_id":"78899160","dot_number":"2276780","report_state":"NY","report_number":"SP3T200190","insp_date":"2023-06-14 00:00:00","insp_start_time":"1545","insp_end_time":"1610","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2836376","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"27 LOCUST GROVE RD","insp_carrier_city":"SARATOGA SPRINGS","insp_carrier_state":"NY","insp_carrier_zip_code":"12866","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:09.000000Z","updated_at":"2025-03-17T19:28:09.000000Z","inspection_violations":[{"id":5075614,"change_date":"2023-06-15 21:42:00","inspection_id":"78899160","insp_violation_id":"253520233","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195510678","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:35.000000Z","updated_at":"2025-03-17T21:30:35.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5290997,"change_date":"2023-06-15 21:42:00","inspection_id":"78899160","insp_unit_id":"195510678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"51813","insp_unit_license":"30412TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN5LH873775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:42.000000Z","updated_at":"2025-03-17T22:44:42.000000Z"}]},{"id":2672694,"change_date":"2023-03-28 21:40:00","inspection_id":"78198662","dot_number":"2276780","report_state":"NY","report_number":"SPL0155508","insp_date":"2023-03-22 00:00:00","insp_start_time":"1540","insp_end_time":"1559","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749A","location_desc":"SAUGERTIES","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2810807","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-03-28 21:40:00","snet_input_date":"2023-03-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-28 21:40:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:53.000000Z","updated_at":"2025-03-17T19:15:53.000000Z","inspection_violations":[{"id":4107677,"change_date":"2023-03-28 21:40:00","inspection_id":"78198662","insp_violation_id":"251895392","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194089507","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4303012,"change_date":"2023-03-28 21:40:00","inspection_id":"78198662","insp_unit_id":"194089507","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30412TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN5LH873775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:53.000000Z","updated_at":"2025-03-17T22:36:53.000000Z"}]},{"id":2630882,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","dot_number":"2276780","report_state":"NY","report_number":"SPD0280555","insp_date":"2023-03-21 00:00:00","insp_start_time":"0923","insp_end_time":"0952","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330R","location_desc":"GLEN","county_code_state":"NY","county_code":"057","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EXECUTIVE GROUP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2808619","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-03-22 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:11.000000Z","updated_at":"2025-03-17T19:15:11.000000Z","inspection_violations":[{"id":4044509,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_violation_id":"251794957","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193994604","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39375A3"},{"id":4044510,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_violation_id":"251794958","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193994604","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3922"},{"id":4044511,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_violation_id":"251794959","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193994604","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6GK1P00","created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3939A"},{"id":4044512,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_violation_id":"251794960","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193994604","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"3922"},{"id":4044513,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_violation_id":"251794961","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193994604","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6GK1P75","created_at":"2025-03-17T21:25:58.000000Z","updated_at":"2025-03-17T21:25:58.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":4234905,"change_date":"2023-03-22 21:42:00","inspection_id":"78151534","insp_unit_id":"193994604","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"51801","insp_unit_license":"68876MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W168J7K01272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:22.000000Z","updated_at":"2025-03-17T22:36:22.000000Z"}]},{"id":2321977,"change_date":"2023-02-08 21:39:00","inspection_id":"77799542","dot_number":"2276780","report_state":"NY","report_number":"SPT0376742","insp_date":"2023-02-07 00:00:00","insp_start_time":"1123","insp_end_time":"1143","registration_date":null,"region":"ET","ci_status_code":"C","location":"80698A","location_desc":"SUFFERN (DOUBLE YARD)","county_code_state":"NY","county_code":"087","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":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2796425","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-02-08 21:39:00","snet_input_date":"2023-02-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","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":3736889,"change_date":"2023-02-08 21:39:00","inspection_id":"77799542","insp_unit_id":"193285978","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30403TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAN1KH142385","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":2062959,"change_date":"2023-01-04 21:39:00","inspection_id":"77503731","dot_number":"2276780","report_state":"NY","report_number":"SPT0432726","insp_date":"2023-01-03 00:00:00","insp_start_time":"1113","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES REST AREA (NB)","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-04 21:39: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":"2784706","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2023-01-04 21:39:00","snet_input_date":"2023-01-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-04 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:43.000000Z","updated_at":"2025-03-17T19:04:43.000000Z","inspection_violations":[{"id":3193743,"change_date":"2023-01-04 21:39:00","inspection_id":"77503731","insp_violation_id":"250374329","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192688185","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:06.000000Z","updated_at":"2025-03-17T21:22:06.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3318652,"change_date":"2023-01-04 21:39:00","inspection_id":"77503731","insp_unit_id":"192688185","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"68991MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W160K7008888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:45.000000Z","updated_at":"2025-03-17T22:29:45.000000Z"}]},{"id":736353,"change_date":"2022-07-01 21:38:00","inspection_id":"75969258","dot_number":"2276780","report_state":"NY","report_number":"SPF0137665","insp_date":"2022-06-22 00:00:00","insp_start_time":"1340","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749","location_desc":"SAUGERTIES","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2722461","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[{"id":1159701,"change_date":"2022-07-01 21:38:00","inspection_id":"75969258","insp_violation_id":"246850490","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:23.000000Z","updated_at":"2025-03-17T21:12:23.000000Z","normalized_code":"39141A"},{"id":1159702,"change_date":"2022-07-01 21:38:00","inspection_id":"75969258","insp_violation_id":"246850491","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189568951","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:23.000000Z","updated_at":"2025-03-17T21:12:23.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1183297,"change_date":"2022-07-01 21:38:00","inspection_id":"75969258","insp_unit_id":"189568951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"14100BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMNXLH873772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":736851,"change_date":"2022-07-01 21:38:00","inspection_id":"75969812","dot_number":"2276780","report_state":"NY","report_number":"SPT0432108","insp_date":"2022-06-22 00:00:00","insp_start_time":"1645","insp_end_time":"1703","registration_date":null,"region":"ET","ci_status_code":"C","location":"80749M","location_desc":"SAUGERTIES MM99 REST AREA (NB)","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2722749","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2022-07-01 21:38:00","snet_input_date":"2022-07-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:34.000000Z","updated_at":"2025-03-17T18:40:34.000000Z","inspection_violations":[{"id":1160679,"change_date":"2022-07-01 21:38:00","inspection_id":"75969812","insp_violation_id":"246851736","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189569801","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:27.000000Z","updated_at":"2025-03-17T21:12:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1184026,"change_date":"2022-07-01 21:38:00","inspection_id":"75969812","insp_unit_id":"189569801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30402TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAN3KH145532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:27.000000Z","updated_at":"2025-03-17T22:15:27.000000Z"}]},{"id":635409,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","dot_number":"2276780","report_state":"NY","report_number":"SPH0050302","insp_date":"2022-06-15 00:00:00","insp_start_time":"0806","insp_end_time":"0902","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":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"6","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2717884","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2022-06-17 21:39:00","snet_input_date":"2022-06-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-17 21:39:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:50.000000Z","updated_at":"2025-03-17T18:38:50.000000Z","inspection_violations":[{"id":998989,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543170","seq_no":"1","part_no":"395","part_no_section":"22(h)(3)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39522H3"},{"id":998990,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543171","seq_no":"3","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39522H4"},{"id":998991,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543172","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189314588","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3922"},{"id":998992,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543173","seq_no":"5","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"1","insp_unit_id":"189314588","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39522G"},{"id":998993,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543174","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189314588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3939A"},{"id":998994,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_violation_id":"246543175","seq_no":"2","part_no":"395","part_no_section":"22(h)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39522H2"}],"inspection_per_units":[{"id":1021261,"change_date":"2022-06-17 21:39:00","inspection_id":"75850258","insp_unit_id":"189314588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"51807","insp_unit_license":"30400TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUTAN4KH142638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:28.000000Z","updated_at":"2025-03-17T22:14:28.000000Z"}]},{"id":499145,"change_date":"2022-05-27 21:40:00","inspection_id":"75688184","dot_number":"2276780","report_state":"NY","report_number":"SPB0274298","insp_date":"2022-05-26 00:00:00","insp_start_time":"1146","insp_end_time":"1208","registration_date":null,"region":"ET","ci_status_code":"C","location":"70655A","location_desc":"VALCOUR (NB)","county_code_state":"NY","county_code":"019","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":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-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2711669","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":"02276780","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":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","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":[{"id":792472,"change_date":"2022-05-27 21:40:00","inspection_id":"75688184","insp_violation_id":"246123747","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188953065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"3939A"},{"id":792473,"change_date":"2022-05-27 21:40:00","inspection_id":"75688184","insp_violation_id":"246123748","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188953065","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:46.000000Z","updated_at":"2025-03-17T21:10:46.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":802685,"change_date":"2022-05-27 21:40:00","inspection_id":"75688184","insp_unit_id":"188953065","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"51813","insp_unit_license":"30412TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN5LH873775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:09.000000Z","updated_at":"2025-03-17T22:13:09.000000Z"}]},{"id":316103,"change_date":"2022-05-04 21:40:00","inspection_id":"75470099","dot_number":"2276780","report_state":"NY","report_number":"1L40000029","insp_date":"2022-05-03 00:00:00","insp_start_time":"0828","insp_end_time":"0854","registration_date":null,"region":"ET","ci_status_code":"C","location":"10331","location_desc":"MAALWYCK PARK","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2702721","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02276780","upload_search_indicator":"M","census_search_date":"2022-05-04 21:40:00","snet_input_date":"2022-05-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-04 21:40:00","insp_carrier_name":"EXECUTIVE TRIM CONSTRUCTION INCORPORATED","insp_carrier_street":"50 PARK STREET","insp_carrier_city":"AMSTERDAM","insp_carrier_state":"NY","insp_carrier_zip_code":"12010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:59.000000Z","updated_at":"2025-03-17T18:32:59.000000Z","inspection_violations":[{"id":492800,"change_date":"2022-05-04 21:40:00","inspection_id":"75470099","insp_violation_id":"245561421","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"G822FDP5P5","created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3958A1"},{"id":492801,"change_date":"2022-05-04 21:40:00","inspection_id":"75470099","insp_violation_id":"245561422","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"188493624","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":511087,"change_date":"2022-05-04 21:40:00","inspection_id":"75470099","insp_unit_id":"188493624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"68876MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W168J7K01272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2276780\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2276780\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2276780\/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\/2276780\/inspections","per_page":100,"prev_page_url":null,"to":32,"total":32}