{"current_page":1,"data":[{"id":12074176,"change_date":"2026-06-18 21:42:00","inspection_id":"88016529","dot_number":"464680","report_state":"NY","report_number":"SPG3090943","insp_date":"2026-05-26 00:00:00","insp_start_time":"1153","insp_end_time":"1205","registration_date":"2026-06-16 00:00:00","region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3445888","transaction_code":"C","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-05-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:21.000000Z","updated_at":"2026-06-29T09:30:03.000000Z","inspection_violations":[{"id":21010117,"change_date":"2026-06-18 21:42:00","inspection_id":"88016529","insp_violation_id":"274998783","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214177533","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T09:59:50.000000Z","updated_at":"2026-06-29T09:43:17.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":20982986,"change_date":"2026-06-18 21:42:00","inspection_id":"88016529","insp_unit_id":"214177533","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"62698NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMLXTS228413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:11.000000Z","updated_at":"2026-06-29T09:00:49.000000Z"}]},{"id":11932281,"change_date":"2026-05-15 21:45:00","inspection_id":"87866950","dot_number":"464680","report_state":"NY","report_number":"D103101643","insp_date":"2026-05-15 00:00:00","insp_start_time":"0826","insp_end_time":"0845","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3333570","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2026-05-15 21:45:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:45:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:39.000000Z","updated_at":"2026-05-26T09:32:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20750360,"change_date":"2026-05-15 21:45:00","inspection_id":"87866950","insp_unit_id":"213586189","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"62698NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMLXTS228413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:55.000000Z","updated_at":"2026-05-26T09:04:34.000000Z"}]},{"id":10607193,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","dot_number":"464680","report_state":"NY","report_number":"D103500567","insp_date":"2026-01-08 00:00:00","insp_start_time":"1050","insp_end_time":"1112","registration_date":"2026-03-10 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SCHENECTADY NY","county_code_state":"NY","county_code":"093","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2743566","transaction_code":"C","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:41.000000Z","updated_at":"2026-03-21T09:30:07.000000Z","inspection_violations":[{"id":19068848,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","insp_violation_id":"272297382","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"212052519","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:34.000000Z","updated_at":"2026-03-21T09:47:21.000000Z","normalized_code":"3939ALSML"},{"id":19068849,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","insp_violation_id":"272297383","seq_no":"2","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"212052519","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:34.000000Z","updated_at":"2026-03-21T09:47:21.000000Z","normalized_code":"39311A1LLPL"},{"id":19068850,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","insp_violation_id":"272297384","seq_no":"3","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"212052519","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9457L68NXC","created_at":"2026-03-13T10:04:34.000000Z","updated_at":"2026-03-21T09:47:21.000000Z","normalized_code":"3929A2C"},{"id":19068851,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","insp_violation_id":"272297385","seq_no":"4","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:34.000000Z","updated_at":"2026-03-21T09:47:21.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":19384175,"change_date":"2026-03-10 21:38:00","inspection_id":"86746859","insp_unit_id":"212052519","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"40353NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC9KDKD8858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:13.000000Z","updated_at":"2026-03-21T09:11:15.000000Z"}]},{"id":10445598,"change_date":"2026-01-06 21:38:00","inspection_id":"86577873","dot_number":"464680","report_state":"NY","report_number":"SPB3031241","insp_date":"2025-12-09 00:00:00","insp_start_time":"0952","insp_end_time":"1018","registration_date":"2026-01-05 00:00:00","region":"ES","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MARCELLA'S APPLIANCE CENTER","shipping_paper_number":"C00016725","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":"17999","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":"2662810","transaction_code":"C","transaction_date":"2025-12-15 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","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":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:33.000000Z","updated_at":"2026-01-17T10:30:09.000000Z","inspection_violations":[{"id":17762037,"change_date":"2026-01-06 21:38:00","inspection_id":"86577873","insp_violation_id":"271024304","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:15.000000Z","updated_at":"2026-01-17T10:30:17.000000Z","normalized_code":"39141APC"},{"id":17762038,"change_date":"2026-01-06 21:38:00","inspection_id":"86577873","insp_violation_id":"271024305","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210920749","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8B11L32JLR","created_at":"2026-01-09T10:38:15.000000Z","updated_at":"2026-01-17T10:30:17.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":17715903,"change_date":"2026-01-06 21:38:00","inspection_id":"86577873","insp_unit_id":"210920749","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"667479","insp_unit_license":"32378MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJXHH693448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:48.000000Z","updated_at":"2026-01-17T10:00:14.000000Z"}]},{"id":9037852,"change_date":"2025-07-01 21:38:00","inspection_id":"85098415","dot_number":"464680","report_state":"NY","report_number":"SPB3030821","insp_date":"2025-06-24 00:00:00","insp_start_time":"0939","insp_end_time":"0948","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MARCELLA'S APPLIANCE CENTER","shipping_paper_number":"199120","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":"25500","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":"1936082","transaction_code":"A","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","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":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:10.000000Z","updated_at":"2025-07-07T10:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14826074,"change_date":"2025-07-01 21:38:00","inspection_id":"85098415","insp_unit_id":"207652547","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"684213","insp_unit_license":"47868MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML7JH579690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-04T09:46:27.000000Z","updated_at":"2025-07-05T09:45:22.000000Z"}]},{"id":8734915,"change_date":"2025-05-26 21:33:00","inspection_id":"84777893","dot_number":"464680","report_state":"NY","report_number":"SPG3070192","insp_date":"2025-05-19 00:00:00","insp_start_time":"1425","insp_end_time":"1452","registration_date":null,"region":"ED","ci_status_code":"C","location":"10753M","location_desc":"SCHODACK LANDING NY","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"JOHN D MARCELLA & SON APPLIANCES INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","viol_total":"2","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":"1780290","transaction_code":"A","transaction_date":"2025-05-26 00:00:00","upload_date":"2025-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2025-05-26 21:33:00","snet_input_date":"2025-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-26 21:33:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-29T10:00:24.000000Z","updated_at":"2025-05-30T10:00:06.000000Z","inspection_violations":[{"id":13938431,"change_date":"2025-05-26 21:33:00","inspection_id":"84777893","insp_violation_id":"266468865","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-29T10:15:29.000000Z","updated_at":"2025-05-30T10:15:07.000000Z","normalized_code":"39141APC"},{"id":13938432,"change_date":"2025-05-26 21:33:00","inspection_id":"84777893","insp_violation_id":"266468866","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"207061283","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-29T10:15:29.000000Z","updated_at":"2025-05-30T10:15:07.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":14280663,"change_date":"2025-05-26 21:33:00","inspection_id":"84777893","insp_unit_id":"207061283","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"667479","insp_unit_license":"32378MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJXHH693448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-29T09:45:31.000000Z","updated_at":"2025-05-30T09:45:07.000000Z"}]},{"id":8324898,"change_date":"2025-04-09 21:40:00","inspection_id":"84345623","dot_number":"464680","report_state":"NY","report_number":"SPB3010657","insp_date":"2025-04-02 00:00:00","insp_start_time":"0845","insp_end_time":"0901","registration_date":null,"region":"ED","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"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":"1569827","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":"00464680","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":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","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":[{"id":13103674,"change_date":"2025-04-09 21:40:00","inspection_id":"84345623","insp_violation_id":"265509325","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206213408","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:45:51.000000Z","updated_at":"2025-04-12T10:35:06.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13502835,"change_date":"2025-04-09 21:40:00","inspection_id":"84345623","insp_unit_id":"206213408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"761853","insp_unit_license":"97342ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W165J7007573","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":6861310,"change_date":"2024-10-01 21:42:00","inspection_id":"82803339","dot_number":"464680","report_state":"NY","report_number":"SPG0216044","insp_date":"2024-09-06 00:00:00","insp_start_time":"0915","insp_end_time":"0930","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MARCELLA","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-10-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2953021","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2024-10-01 21:42:00","snet_input_date":"2024-10-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:22.000000Z","updated_at":"2025-03-17T20:39:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11064724,"change_date":"2024-10-01 21:42:00","inspection_id":"82803339","insp_unit_id":"203211499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"32378MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJXHH693448","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:34.000000Z","updated_at":"2025-03-17T23:37:34.000000Z"}]},{"id":6195251,"change_date":"2024-07-11 21:41:00","inspection_id":"82092517","dot_number":"464680","report_state":"NY","report_number":"SPG0207066","insp_date":"2024-07-10 00:00:00","insp_start_time":"1328","insp_end_time":"1347","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN D MARCELLA","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-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2936040","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:25.000000Z","updated_at":"2025-03-17T20:25:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9980244,"change_date":"2024-07-11 21:41:00","inspection_id":"82092517","insp_unit_id":"201836063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"78312MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJ7HH442628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:27.000000Z","updated_at":"2025-03-17T23:26:27.000000Z"}]},{"id":5619743,"change_date":"2024-04-29 21:43:00","inspection_id":"81469568","dot_number":"464680","report_state":"NY","report_number":"SPG0261382","insp_date":"2024-04-19 00:00:00","insp_start_time":"1238","insp_end_time":"1253","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2920349","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:56.000000Z","updated_at":"2025-03-17T20:13:56.000000Z","inspection_violations":[{"id":8692564,"change_date":"2024-04-29 21:43:00","inspection_id":"81469568","insp_violation_id":"259198014","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:03.000000Z","updated_at":"2025-03-17T21:48:03.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":9052322,"change_date":"2024-04-29 21:43:00","inspection_id":"81469568","insp_unit_id":"200622217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"78312MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJ7HH442628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:14.000000Z","updated_at":"2025-03-17T23:17:14.000000Z"}]},{"id":5315089,"change_date":"2024-03-19 21:44:00","inspection_id":"81137189","dot_number":"464680","report_state":"NY","report_number":"D808600250","insp_date":"2024-03-11 00:00:00","insp_start_time":"1038","insp_end_time":"1059","registration_date":null,"region":"ED","ci_status_code":"C","location":"80579M","location_desc":"NEW PALTZ NY","county_code_state":"NY","county_code":"111","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"329458","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2024-03-19 21:44:00","snet_input_date":"2024-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-19 21:44:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:55.000000Z","updated_at":"2025-03-17T20:07:55.000000Z","inspection_violations":[{"id":8200719,"change_date":"2024-03-19 21:44:00","inspection_id":"81137189","insp_violation_id":"258455659","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"199975686","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939ALCL"},{"id":8200720,"change_date":"2024-03-19 21:44:00","inspection_id":"81137189","insp_violation_id":"258455660","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"199975686","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":8560196,"change_date":"2024-03-19 21:44:00","inspection_id":"81137189","insp_unit_id":"199975686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"684214","insp_unit_license":"46800MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML9JH579691","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:36.000000Z","updated_at":"2025-03-17T23:12:36.000000Z"}]},{"id":4479380,"change_date":"2023-11-22 21:38:00","inspection_id":"80223176","dot_number":"464680","report_state":"NY","report_number":"SPG0261215","insp_date":"2023-11-14 00:00:00","insp_start_time":"1230","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2889085","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2023-11-22 21:38:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-22 21:38:00","insp_carrier_name":"JOHN D MARCELLA AND SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:28.000000Z","updated_at":"2025-03-17T19:51:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7203786,"change_date":"2023-11-22 21:38:00","inspection_id":"80223176","insp_unit_id":"198179624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"34182MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJ0HH478564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:30.000000Z","updated_at":"2025-03-17T23:00:30.000000Z"}]},{"id":4157233,"change_date":"2023-10-11 21:40:00","inspection_id":"79867358","dot_number":"464680","report_state":"NY","report_number":"M606400002","insp_date":"2023-10-10 00:00:00","insp_start_time":"0911","insp_end_time":"1003","registration_date":null,"region":"ED","ci_status_code":"C","location":"10174M","location_desc":"CLIFTON PARK NY","county_code_state":"NY","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MARYBETH MURPHY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"66056","transaction_code":"C","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:59.000000Z","updated_at":"2025-03-17T19:44:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6684602,"change_date":"2023-10-11 21:40:00","inspection_id":"79867358","insp_unit_id":"197490494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"46800MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML9JH579691","insp_unit_decal":"Y","insp_unit_decal_number":"33399141","created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"}]},{"id":4131242,"change_date":"2023-10-05 21:39:00","inspection_id":"79838619","dot_number":"464680","report_state":"NY","report_number":"SPT0540913","insp_date":"2023-10-04 00:00:00","insp_start_time":"1017","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330","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":"JOHN D MARCELLA APPLIANCES","shipping_paper_number":"181453","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2875703","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2023-10-05 21:39:00","snet_input_date":"2023-10-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-05 21:39:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:28.000000Z","updated_at":"2025-03-17T19:44:28.000000Z","inspection_violations":[{"id":6394466,"change_date":"2023-10-05 21:39:00","inspection_id":"79838619","insp_violation_id":"255671429","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197409234","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3H826MW","created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"3939A"},{"id":6394467,"change_date":"2023-10-05 21:39:00","inspection_id":"79838619","insp_violation_id":"255671430","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197409234","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"39345B2"},{"id":6394468,"change_date":"2023-10-05 21:39:00","inspection_id":"79838619","insp_violation_id":"255671431","seq_no":"3","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"197409234","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:48.000000Z","updated_at":"2025-03-17T21:36:48.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":6642314,"change_date":"2023-10-05 21:39:00","inspection_id":"79838619","insp_unit_id":"197409234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"78312MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJ7HH442628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:43.000000Z","updated_at":"2025-03-17T22:55:43.000000Z"}]},{"id":3809156,"change_date":"2023-08-23 21:39:00","inspection_id":"79480108","dot_number":"464680","report_state":"NY","report_number":"SPT0482641","insp_date":"2023-08-22 00:00:00","insp_start_time":"0934","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":"10697A","location_desc":"QUEENSBURY (NB)","county_code_state":"NY","county_code":"113","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"2861386","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2023-08-23 21:39:00","snet_input_date":"2023-08-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-23 21:39:00","insp_carrier_name":"JOHN D MARCELLA AND SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:04.000000Z","updated_at":"2025-03-17T19:38:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6124522,"change_date":"2023-08-23 21:39:00","inspection_id":"79480108","insp_unit_id":"196678753","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"47851MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML0JH579689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"}]},{"id":3682480,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","dot_number":"464680","report_state":"NY","report_number":"SPG0261048","insp_date":"2023-07-31 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2855731","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":null,"census_search_date":"2023-08-07 21:41:00","snet_input_date":"2023-08-07 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-07 21:41:00","insp_carrier_name":"JOHN D MARCELLA AND SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:39.000000Z","updated_at":"2025-03-17T19:35:39.000000Z","inspection_violations":[{"id":5678432,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498580","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39141A1"},{"id":5678433,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498581","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196390245","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"3922"},{"id":5678434,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498582","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196390245","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"3922"},{"id":5678435,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498583","seq_no":"4","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"196390245","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39324A"},{"id":5678436,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498584","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196390245","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39395F"},{"id":5678437,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_violation_id":"254498585","seq_no":"6","part_no":"393","part_no_section":"86(b)(1)","insp_viol_unit":"1","insp_unit_id":"196390245","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:17.000000Z","updated_at":"2025-03-17T21:33:17.000000Z","normalized_code":"39386B1"}],"inspection_per_units":[{"id":5920418,"change_date":"2023-08-07 21:41:00","inspection_id":"79338923","insp_unit_id":"196390245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"797564","insp_unit_license":"14447NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC9KDKD8858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:47.000000Z","updated_at":"2025-03-17T22:49:47.000000Z"}]},{"id":3475595,"change_date":"2023-07-11 21:41:00","inspection_id":"79106797","dot_number":"464680","report_state":"NY","report_number":"SPT0482501","insp_date":"2023-07-10 00:00:00","insp_start_time":"1313","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":"80579A","location_desc":"NEW PALTZ (EXIT 18)","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2845271","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2023-07-11 21:41:00","snet_input_date":"2023-07-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-11 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[{"id":5358639,"change_date":"2023-07-11 21:41:00","inspection_id":"79106797","insp_violation_id":"253977209","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"195925160","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"39355D1"},{"id":5358640,"change_date":"2023-07-11 21:41:00","inspection_id":"79106797","insp_violation_id":"253977210","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195925160","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5588580,"change_date":"2023-07-11 21:41:00","inspection_id":"79106797","insp_unit_id":"195925160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"14447NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWFC9KDKD8858","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:07.000000Z","updated_at":"2025-03-17T22:47:07.000000Z"}]},{"id":2150318,"change_date":"2023-01-17 21:41:00","inspection_id":"77603912","dot_number":"464680","report_state":"NY","report_number":"SPK0109911","insp_date":"2023-01-11 00:00:00","insp_start_time":"1024","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"K80346","location_desc":"GREENPORT","county_code_state":"NY","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2789150","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2023-01-17 21:41:00","snet_input_date":"2023-01-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-17 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:15.000000Z","updated_at":"2025-03-17T19:06:15.000000Z","inspection_violations":[{"id":3325409,"change_date":"2023-01-17 21:41:00","inspection_id":"77603912","insp_violation_id":"250589588","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"39115A"}],"inspection_per_units":[{"id":3459907,"change_date":"2023-01-17 21:41:00","inspection_id":"77603912","insp_unit_id":"192887329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"34182MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMMJ0HH478564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:47.000000Z","updated_at":"2025-03-17T22:30:47.000000Z"}]},{"id":1992957,"change_date":"2022-12-21 21:39:00","inspection_id":"77424021","dot_number":"464680","report_state":"NY","report_number":"SPWG050795","insp_date":"2022-12-20 00:00:00","insp_start_time":"0949","insp_end_time":"1019","registration_date":null,"region":"ET","ci_status_code":"C","location":"10174A","location_desc":"CLIFTON PARK (NB)","county_code_state":"NY","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LORRAINE KNAPIK","shipping_paper_number":"136633","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2782174","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3206051,"change_date":"2022-12-21 21:39:00","inspection_id":"77424021","insp_unit_id":"192530127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"684212","insp_unit_license":"47851MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML0JH579689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:57.000000Z","updated_at":"2025-03-17T22:28:57.000000Z"}]},{"id":1980551,"change_date":"2022-12-20 21:40:00","inspection_id":"77409830","dot_number":"464680","report_state":"NY","report_number":"SPG0250907","insp_date":"2022-12-19 00:00:00","insp_start_time":"1433","insp_end_time":"1458","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753A","location_desc":"SCHODACK (WB)","county_code_state":"NY","county_code":"083","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"2781772","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-12-20 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:16.000000Z","updated_at":"2025-03-17T19:03:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3186323,"change_date":"2022-12-20 21:40:00","inspection_id":"77409830","insp_unit_id":"192500841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"47868MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML7JH579690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"}]},{"id":1622073,"change_date":"2022-10-28 21:39:00","inspection_id":"76999109","dot_number":"464680","report_state":"NY","report_number":"SPT0432544","insp_date":"2022-10-27 00:00:00","insp_start_time":"1454","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":"12001","location_desc":"ALBANY (EXIT 24 PLAZA)","county_code_state":"NY","county_code":"001","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2763930","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-10-28 21:39:00","snet_input_date":"2022-10-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-28 21:39:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:38.000000Z","updated_at":"2025-03-17T18:56:38.000000Z","inspection_violations":[{"id":2546901,"change_date":"2022-10-28 21:39:00","inspection_id":"76999109","insp_violation_id":"249304362","seq_no":"1","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:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"3922"},{"id":2546902,"change_date":"2022-10-28 21:39:00","inspection_id":"76999109","insp_violation_id":"249304363","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"191689836","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:00.000000Z","updated_at":"2025-03-17T21:19:00.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":2609451,"change_date":"2022-10-28 21:39:00","inspection_id":"76999109","insp_unit_id":"191689836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"684212","insp_unit_license":"47851MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML0JH579689","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:52.000000Z","updated_at":"2025-03-17T22:24:52.000000Z"}]},{"id":962129,"change_date":"2022-08-04 21:42:00","inspection_id":"76233369","dot_number":"464680","report_state":"NY","report_number":"SPT0432270","insp_date":"2022-08-03 00:00:00","insp_start_time":"1010","insp_end_time":"1028","registration_date":null,"region":"ET","ci_status_code":"C","location":"20330M","location_desc":"GLEN REST AREA (WB)","county_code_state":"NY","county_code":"057","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"JOHN D MARCELLA APPLIANCES","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"2735289","transaction_code":"A","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-08-04 21:42:00","snet_input_date":"2022-08-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-04 21:42:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:44.000000Z","updated_at":"2025-03-17T18:44:44.000000Z","inspection_violations":[{"id":1516831,"change_date":"2022-08-04 21:42:00","inspection_id":"76233369","insp_violation_id":"247509725","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190129972","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:09.000000Z","updated_at":"2025-03-17T21:14:09.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1547945,"change_date":"2022-08-04 21:42:00","inspection_id":"76233369","insp_unit_id":"190129972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"47868MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML7JH579690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:44.000000Z","updated_at":"2025-03-17T22:17:44.000000Z"}]},{"id":440718,"change_date":"2022-05-20 21:40:00","inspection_id":"75618390","dot_number":"464680","report_state":"NY","report_number":"SPT0530045","insp_date":"2022-05-19 00:00:00","insp_start_time":"0118","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"10753M","location_desc":"SCHODACK REST AREA (WB)","county_code_state":"NY","county_code":"083","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2709318","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-05-20 21:40:00","snet_input_date":"2022-05-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-20 21:40:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":710357,"change_date":"2022-05-20 21:40:00","inspection_id":"75618390","insp_unit_id":"188808055","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"46800MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMMML9JH579691","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:34.000000Z","updated_at":"2025-03-17T22:12:34.000000Z"}]},{"id":325697,"change_date":"2022-05-05 21:41:00","inspection_id":"75481413","dot_number":"464680","report_state":"NY","report_number":"1L28000421","insp_date":"2022-05-04 00:00:00","insp_start_time":"0830","insp_end_time":"0848","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"756 STATE ST","county_code_state":"NY","county_code":"093","insp_level_id":"3","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-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2703024","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00464680","upload_search_indicator":"M","census_search_date":"2022-05-05 21:41:00","snet_input_date":"2022-05-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-05 21:41:00","insp_carrier_name":"JOHN D MARCELLA & SON APPLIANCES INC","insp_carrier_street":"560 BROADWAY","insp_carrier_city":"SCHENECTADY","insp_carrier_state":"NY","insp_carrier_zip_code":"12305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:18.000000Z","updated_at":"2025-03-17T18:33:18.000000Z","inspection_violations":[{"id":508715,"change_date":"2022-05-05 21:41:00","inspection_id":"75481413","insp_violation_id":"245590818","seq_no":"1","part_no":"376","part_no_section":"11(d)(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:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":526712,"change_date":"2022-05-05 21:41:00","inspection_id":"75481413","insp_unit_id":"188518122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"357146","insp_unit_license":"83625MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACWDT6GDGX4780","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:26.000000Z","updated_at":"2025-03-17T22:11:26.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/464680\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/464680\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/464680\/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\/464680\/inspections","per_page":100,"prev_page_url":null,"to":24,"total":24}