{"current_page":1,"data":[{"id":11741504,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","dot_number":"3620453","report_state":"NJ","report_number":"SPSVI00090","insp_date":"2026-04-21 00:00:00","insp_start_time":"1032","insp_end_time":"1116","registration_date":null,"region":"ED","ci_status_code":"C","location":"2004","location_desc":"NJ","county_code_state":"NJ","county_code":"039","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"10","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3208543","transaction_code":"A","transaction_date":"2026-04-24 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2026-04-24 21:40:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-24 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:25.000000Z","updated_at":"2026-05-05T09:31:08.000000Z","inspection_violations":[{"id":20414663,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830193","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39021TB1MC"},{"id":20414662,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830192","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39021TB2DOT"},{"id":20414661,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830191","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213201619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"3939ALLPL"},{"id":20414664,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830194","seq_no":"4","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"3922SLLTL"},{"id":20414665,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830195","seq_no":"5","part_no":"396","part_no_section":"3A1E-PNCNB","insp_viol_unit":"2","insp_unit_id":"213201619","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"3963A1EPNCNB"},{"id":20414666,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830196","seq_no":"6","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213201619","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39343DB"},{"id":20414667,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830197","seq_no":"7","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-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39141APC"},{"id":20414668,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830198","seq_no":"8","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39395A1"},{"id":20414669,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830199","seq_no":"9","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"39395F"},{"id":20414670,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_violation_id":"273830200","seq_no":"10","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"213201618","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:06:01.000000Z","updated_at":"2026-05-05T09:43:50.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":20429532,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_unit_id":"213201618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"XRFC91","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL3HG684465","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:23.000000Z","updated_at":"2026-05-05T09:03:59.000000Z"},{"id":20429533,"change_date":"2026-04-24 21:40:00","inspection_id":"87670233","insp_unit_id":"213201619","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"Y30TBH","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD162XRB055056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:23.000000Z","updated_at":"2026-05-05T09:03:59.000000Z"}]},{"id":11741332,"change_date":"2026-04-24 21:40:00","inspection_id":"87670052","dot_number":"3620453","report_state":"NJ","report_number":"SPRNI03362","insp_date":"2026-04-18 00:00:00","insp_start_time":"0725","insp_end_time":"0755","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NJ","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-24 21:40: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":"3208286","transaction_code":"A","transaction_date":"2026-04-24 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2026-04-24 21:40:00","snet_input_date":"2026-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-24 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:25.000000Z","updated_at":"2026-05-05T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20429320,"change_date":"2026-04-24 21:40:00","inspection_id":"87670052","insp_unit_id":"213201386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"XRFC93","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL8MG673424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:21.000000Z","updated_at":"2026-05-05T09:03:55.000000Z"},{"id":20429321,"change_date":"2026-04-24 21:40:00","inspection_id":"87670052","insp_unit_id":"213201387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"Y53TCC","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1625SB069162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:21:21.000000Z","updated_at":"2026-05-05T09:03:55.000000Z"}]},{"id":11680306,"change_date":"2026-04-17 21:41:00","inspection_id":"87605636","dot_number":"3620453","report_state":"NJ","report_number":"SPRNI03349","insp_date":"2026-04-15 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NJ","county_code_state":"NJ","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-17 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":"3173819","transaction_code":"A","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2026-04-17 21:41:00","snet_input_date":"2026-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-17 21:41:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:33:17.000000Z","updated_at":"2026-04-28T09:30:48.000000Z","inspection_violations":[{"id":20282805,"change_date":"2026-04-17 21:41:00","inspection_id":"87605636","insp_violation_id":"273671266","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"213072520","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0335E26000491","created_at":"2026-04-27T09:47:18.000000Z","updated_at":"2026-04-28T09:41:12.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":20309853,"change_date":"2026-04-17 21:41:00","inspection_id":"87605636","insp_unit_id":"213072520","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"XRFC93","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL8MG673424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:06.000000Z","updated_at":"2026-04-28T09:03:41.000000Z"},{"id":20309854,"change_date":"2026-04-17 21:41:00","inspection_id":"87605636","insp_unit_id":"213072521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"TZM66B","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1627PB042391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:06.000000Z","updated_at":"2026-04-28T09:03:41.000000Z"}]},{"id":11605715,"change_date":"2026-04-09 21:55:00","inspection_id":"87532890","dot_number":"3620453","report_state":"NJ","report_number":"SPRNI03322","insp_date":"2026-04-04 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NJ","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-09 21:55: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":"3135326","transaction_code":"A","transaction_date":"2026-04-09 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2026-04-09 21:55:00","snet_input_date":"2026-04-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-09 21:55:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-12T09:45:26.000000Z","updated_at":"2026-04-20T09:31:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19893395,"change_date":"2026-04-09 21:55:00","inspection_id":"87532890","insp_unit_id":"212624935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"XRFC93","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL8MG673424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:25:29.000000Z","updated_at":"2026-04-19T09:06:59.000000Z"},{"id":19893396,"change_date":"2026-04-09 21:55:00","inspection_id":"87532890","insp_unit_id":"212624936","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"P66TAV","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1626RB055054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:25:29.000000Z","updated_at":"2026-04-19T09:06:59.000000Z"}]},{"id":11449534,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","dot_number":"3620453","report_state":"NJ","report_number":"SPQWI04296","insp_date":"2026-03-12 00:00:00","insp_start_time":"0710","insp_end_time":"0735","registration_date":null,"region":"ED","ci_status_code":"C","location":"0304","location_desc":"NJ","county_code_state":"NJ","county_code":"005","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":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3053951","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2026-03-23 21:51:00","snet_input_date":"2026-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"NJ","created_at":"2026-03-26T09:41:34.000000Z","updated_at":"2026-04-03T09:32:27.000000Z","inspection_violations":[{"id":19319335,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571281","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212278635","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39617CPI"},{"id":19319336,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571282","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212278635","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"3939ALIL"},{"id":19319337,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571283","seq_no":"3","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"212278635","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"3929A2C"},{"id":19319338,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571284","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39617CPI"},{"id":19319339,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571285","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"3922SLLSR"},{"id":19319340,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571286","seq_no":"6","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39348ABIHE"},{"id":19319341,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571287","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39348ABIHE"},{"id":19319342,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571288","seq_no":"8","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39348ABIHE"},{"id":19319343,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571289","seq_no":"9","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"39348ABIHE"},{"id":19319344,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_violation_id":"272571290","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"212278636","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-26T10:01:56.000000Z","updated_at":"2026-04-03T09:50:11.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":19610928,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_unit_id":"212278636","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":"28","insp_unit_license":"Y60TCC","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1624SB069167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:44.000000Z","updated_at":"2026-04-03T09:05:54.000000Z"},{"id":19610927,"change_date":"2026-03-23 21:51:00","inspection_id":"87366924","insp_unit_id":"212278635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"14","insp_unit_license":"XRFC93","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL8MG673424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:44.000000Z","updated_at":"2026-04-03T09:05:53.000000Z"}]},{"id":10494257,"change_date":"2025-12-22 21:38:00","inspection_id":"86628849","dot_number":"3620453","report_state":"NJ","report_number":"SPRH002851","insp_date":"2025-12-20 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"295 NB MP 51","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1330039","transaction_code":"A","transaction_date":"2025-12-20 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-20 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:40.000000Z","updated_at":"2026-01-02T10:30:34.000000Z","inspection_violations":[{"id":17614528,"change_date":"2025-12-22 21:38:00","inspection_id":"86628849","insp_violation_id":"270838188","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210749740","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:39.000000Z","updated_at":"2026-01-02T10:31:06.000000Z","normalized_code":"39021TB1MC"},{"id":17614529,"change_date":"2025-12-22 21:38:00","inspection_id":"86628849","insp_violation_id":"270838189","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"210749740","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:39.000000Z","updated_at":"2026-01-02T10:31:06.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":17571887,"change_date":"2025-12-22 21:38:00","inspection_id":"86628849","insp_unit_id":"210749740","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XFRC92","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL7JG363020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:39.000000Z","updated_at":"2026-01-02T10:00:37.000000Z"}]},{"id":10007046,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","dot_number":"3620453","report_state":"NJ","report_number":"SPSBI00849","insp_date":"2025-10-21 00:00:00","insp_start_time":"0851","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"0334","location_desc":"SPRINGFIELD RA","county_code_state":"NJ","county_code":"005","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":"N","pen_cen_match":null,"final_status_date":"2025-10-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1320855","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-10-22 21:39:00","snet_input_date":"2025-10-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-10-22 21:39:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-25T10:01:39.000000Z","updated_at":"2025-10-26T10:00:54.000000Z","inspection_violations":[{"id":16544302,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_violation_id":"269448991","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209597387","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:23.000000Z","updated_at":"2025-10-26T10:16:26.000000Z","normalized_code":"39395A1"},{"id":16544303,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_violation_id":"269448992","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209597388","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:23.000000Z","updated_at":"2025-10-26T10:16:26.000000Z","normalized_code":"3922SLLSR"},{"id":16544304,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_violation_id":"269448993","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209597387","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:23.000000Z","updated_at":"2025-10-26T10:16:26.000000Z","normalized_code":"3939ALIL"},{"id":16544305,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_violation_id":"269448994","seq_no":"4","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"209597387","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-25T10:17:23.000000Z","updated_at":"2025-10-26T10:16:26.000000Z","normalized_code":"3929A2C"}],"inspection_per_units":[{"id":16622100,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_unit_id":"209597387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"9","insp_unit_license":"XPCM64","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C63RRAL5DG564879","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:45.000000Z","updated_at":"2025-10-26T09:46:07.000000Z"},{"id":16622101,"change_date":"2025-10-22 21:39:00","inspection_id":"86117531","insp_unit_id":"209597388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":"20","insp_unit_license":"P66TAV","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1626RB055054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:45.000000Z","updated_at":"2025-10-26T09:46:07.000000Z"}]},{"id":9448884,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","dot_number":"3620453","report_state":"NJ","report_number":"SPSHI00066","insp_date":"2025-08-18 00:00:00","insp_start_time":"1228","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":"1204","location_desc":"NJTP 8N SA","county_code_state":"NJ","county_code":"023","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":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1310059","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-08-19 21:40:00","snet_input_date":"2025-08-18 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:28.000000Z","updated_at":"2025-08-23T10:46:28.000000Z","inspection_violations":[{"id":15387876,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115458","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39021TB2DOT"},{"id":15387877,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115459","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39395A1"},{"id":15387878,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115460","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39395F"},{"id":15387879,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115461","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39617CPI"},{"id":15387880,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115462","seq_no":"5","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"3929A2C"},{"id":15387881,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115463","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"208468689","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15387882,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_violation_id":"268115464","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208468690","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-22T10:44:57.000000Z","updated_at":"2025-08-23T10:48:11.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15580552,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_unit_id":"208468689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XRFC93","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL8MG673424","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:40.000000Z","updated_at":"2025-08-23T09:45:45.000000Z"},{"id":15580553,"change_date":"2025-08-19 21:40:00","inspection_id":"85530953","insp_unit_id":"208468690","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":null,"insp_unit_license":"TYW32N","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"5JW1D1627L4276349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:40.000000Z","updated_at":"2025-08-23T09:45:45.000000Z"}]},{"id":8959443,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","dot_number":"3620453","report_state":"NJ","report_number":"SPOWI02950","insp_date":"2025-06-21 00:00:00","insp_start_time":"1300","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"1713","location_desc":"CARNEYS POINT","county_code_state":"NJ","county_code":"033","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:40: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":"1296559","transaction_code":"A","transaction_date":"2025-06-21 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:30.000000Z","updated_at":"2025-06-28T10:00:30.000000Z","inspection_violations":[{"id":14390541,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_violation_id":"266983826","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1713-W25-062725","created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:33.000000Z","normalized_code":"3922SLL"},{"id":14390542,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_violation_id":"266983827","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207503614","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:33.000000Z","normalized_code":"39021TB2DOT"},{"id":14390543,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_violation_id":"266983828","seq_no":"3","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"207503614","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:33.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":14390544,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_violation_id":"266983829","seq_no":"4","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"207503614","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-26T10:15:52.000000Z","updated_at":"2025-06-27T10:17:33.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":14686478,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_unit_id":"207503614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"---","insp_unit_license":"XRFC92","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL7JG363020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:33.000000Z","updated_at":"2025-06-27T09:45:43.000000Z"},{"id":14686479,"change_date":"2025-06-23 21:40:00","inspection_id":"85016101","insp_unit_id":"207503615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":"---","insp_unit_license":"P67TAV","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1624RB055053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:33.000000Z","updated_at":"2025-06-27T09:45:43.000000Z"}]},{"id":8429142,"change_date":"2025-04-21 21:40:00","inspection_id":"84455666","dot_number":"3620453","report_state":"NJ","report_number":"SPRH002610","insp_date":"2025-04-19 00:00:00","insp_start_time":"0721","insp_end_time":"0736","registration_date":null,"region":"ET","ci_status_code":"C","location":"0412","location_desc":"@I-295 SB MP 33.4 CHERRY HILL","county_code_state":"NJ","county_code":"007","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-04-21 21:40: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":"1280049","transaction_code":"A","transaction_date":"2025-04-19 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-19 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:03:02.000000Z","updated_at":"2025-04-26T10:24:11.000000Z","inspection_violations":[{"id":13306921,"change_date":"2025-04-21 21:40:00","inspection_id":"84455666","insp_violation_id":"265739038","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0412W25042320","created_at":"2025-04-24T10:25:55.000000Z","updated_at":"2025-04-25T10:40:22.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":13687837,"change_date":"2025-04-21 21:40:00","inspection_id":"84455666","insp_unit_id":"206413981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XNJX99","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3D6WZ4EL5BG593101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:55:01.000000Z","updated_at":"2025-04-25T09:58:29.000000Z"},{"id":13687838,"change_date":"2025-04-21 21:40:00","inspection_id":"84455666","insp_unit_id":"206413982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":null,"insp_unit_license":"P68TAV","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1622RB055052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:55:01.000000Z","updated_at":"2025-04-25T09:58:29.000000Z"}]},{"id":7905732,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","dot_number":"3620453","report_state":"NJ","report_number":"SPRH002519","insp_date":"2025-02-15 00:00:00","insp_start_time":"0925","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"0334","location_desc":"SPRINGFIELD REST AREA N\/B","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1266084","transaction_code":"C","transaction_date":"2025-02-15 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-15 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:21.000000Z","updated_at":"2025-03-24T10:25:19.000000Z","inspection_violations":[{"id":12793109,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","insp_violation_id":"265158138","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205904983","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:06:24.000000Z","updated_at":"2025-03-23T11:37:19.000000Z","normalized_code":"39021TB1MC"},{"id":12793110,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","insp_violation_id":"265158139","seq_no":"2","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"205904984","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:06:24.000000Z","updated_at":"2025-03-23T11:37:19.000000Z","normalized_code":"3939ALSLI"},{"id":12793111,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","insp_violation_id":"265158140","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"205904984","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-22T11:06:24.000000Z","updated_at":"2025-03-23T11:37:19.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":13198110,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","insp_unit_id":"205904983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"XRFC92","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WTRAL7JG363020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:13:56.000000Z","updated_at":"2025-03-24T10:00:23.000000Z"},{"id":13198111,"change_date":"2025-03-20 21:42:00","inspection_id":"83904883","insp_unit_id":"205904984","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"TZM70B","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1629PB042392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:13:56.000000Z","updated_at":"2025-03-24T10:00:23.000000Z"}]},{"id":7833467,"change_date":"2025-02-10 21:40:00","inspection_id":"83829156","dot_number":"3620453","report_state":"PA","report_number":"XL00072135","insp_date":"2025-02-08 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"US422 E MEASURING 2311 FEET NO","county_code_state":"PA","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-10 21:40: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":"2496343","transaction_code":"A","transaction_date":"2025-02-08 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2025-02-10 21:40:00","snet_input_date":"2025-02-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"HAMILTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:47.000000Z","updated_at":"2025-03-17T21:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12642540,"change_date":"2025-02-10 21:40:00","inspection_id":"83829156","insp_unit_id":"205253353","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"XKGR13","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL3KG604959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"},{"id":12642541,"change_date":"2025-02-10 21:40:00","inspection_id":"83829156","insp_unit_id":"205253354","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"TEXP","insp_unit_company":null,"insp_unit_license":"Y30TBH","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD162XRB0550","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]},{"id":7217429,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","dot_number":"3620453","report_state":"NJ","report_number":"SPRH002312","insp_date":"2024-11-16 00:00:00","insp_start_time":"0955","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"0334","location_desc":"SPRINGFIELD REST AREA S\/B","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246624","transaction_code":"A","transaction_date":"2024-11-16 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-16 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:29.000000Z","updated_at":"2025-03-17T20:46:29.000000Z","inspection_violations":[{"id":11280697,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","insp_violation_id":"262949104","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"203928098","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39617CPI"},{"id":11280698,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","insp_violation_id":"262949105","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"203928099","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39617CPI"},{"id":11280699,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","insp_violation_id":"262949106","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"203928099","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":11641495,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","insp_unit_id":"203928098","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XKGR13","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRTAL3KG604959","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"},{"id":11641496,"change_date":"2024-11-18 21:40:00","inspection_id":"83181319","insp_unit_id":"203928099","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"P68TAV","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1622RB055052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"}]},{"id":5572567,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","dot_number":"3620453","report_state":"DE","report_number":"0398000448","insp_date":"2024-04-22 00:00:00","insp_start_time":"1039","insp_end_time":"1052","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WILMINGTON DE","county_code_state":"DE","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"EXECUTIVE ROOFING SOLUTIONS","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"23000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"420498","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2024-04-23 21:40:00","snet_input_date":"2024-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-23 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610-4838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:09.000000Z","updated_at":"2025-03-17T20:13:09.000000Z","inspection_violations":[{"id":8612483,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","insp_violation_id":"259073547","seq_no":"1","part_no":"393","part_no_section":"75(a)(2)","insp_viol_unit":"2","insp_unit_id":"200522737","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39375A2"},{"id":8612484,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","insp_violation_id":"259073548","seq_no":"2","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"200522736","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39021TB2"},{"id":8612485,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","insp_violation_id":"259073549","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"200522737","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":8976279,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","insp_unit_id":"200522736","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"XNJX99","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3D6WZ4EL5BG593101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:32.000000Z","updated_at":"2025-03-17T23:16:32.000000Z"},{"id":8976280,"change_date":"2024-04-23 21:40:00","inspection_id":"81418068","insp_unit_id":"200522737","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"FAB \/ BRA","insp_unit_license":"TYF45S","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1B90630D86Z624730","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:32.000000Z","updated_at":"2025-03-17T23:16:32.000000Z"}]},{"id":5458528,"change_date":"2024-04-08 21:43:00","inspection_id":"81293504","dot_number":"3620453","report_state":"NJ","report_number":"SPPNI01741","insp_date":"2024-04-06 00:00:00","insp_start_time":"0646","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":"0335","location_desc":"SPRINGFIELD REST AREA","county_code_state":"NJ","county_code":"005","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":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"1204503","transaction_code":"A","transaction_date":"2024-04-06 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2024-04-08 21:43:00","snet_input_date":"2024-04-06 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-04-08 21:43:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:44.000000Z","updated_at":"2025-03-17T20:10:44.000000Z","inspection_violations":[{"id":8425855,"change_date":"2024-04-08 21:43:00","inspection_id":"81293504","insp_violation_id":"258799114","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200285302","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:48.000000Z","updated_at":"2025-03-17T21:46:48.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":8792457,"change_date":"2024-04-08 21:43:00","inspection_id":"81293504","insp_unit_id":"200285302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"XPCM64","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C63RRAL5DG564879","insp_unit_decal":"Y","insp_unit_decal_number":"34050249","created_at":"2025-03-17T23:14:47.000000Z","updated_at":"2025-03-17T23:14:47.000000Z"},{"id":8792458,"change_date":"2024-04-08 21:43:00","inspection_id":"81293504","insp_unit_id":"200285303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":null,"insp_unit_license":"K48TAU","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"5JW1D1423M430326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:47.000000Z","updated_at":"2025-03-17T23:14:47.000000Z"}]},{"id":4489763,"change_date":"2023-11-27 21:41:00","inspection_id":"80234580","dot_number":"3620453","report_state":"NJ","report_number":"SPRH001390","insp_date":"2023-11-22 00:00:00","insp_start_time":"1127","insp_end_time":"1142","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"295 SB OVERLOOK","county_code_state":"NJ","county_code":"021","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-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","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":"1180896","transaction_code":"A","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:49.000000Z","updated_at":"2025-03-17T19:51:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7220553,"change_date":"2023-11-27 21:41:00","inspection_id":"80234580","insp_unit_id":"198202824","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XNJX99","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3D6WZ4EL5BG593101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"},{"id":7220554,"change_date":"2023-11-27 21:41:00","inspection_id":"80234580","insp_unit_id":"198202825","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEX","insp_unit_company":null,"insp_unit_license":"TZM69B","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1625PB042390","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:40.000000Z","updated_at":"2025-03-17T23:00:40.000000Z"}]},{"id":4321078,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","dot_number":"3620453","report_state":"NJ","report_number":"SPPSI02872","insp_date":"2023-10-28 00:00:00","insp_start_time":"0725","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"0335","location_desc":"SPRINGFIELD REST AREA","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25000","viol_total":"11","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1177121","transaction_code":"A","transaction_date":"2023-10-28 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2023-10-31 21:39:00","snet_input_date":"2023-10-28 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-10-31 21:39:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:41.000000Z","updated_at":"2025-03-17T19:48:41.000000Z","inspection_violations":[{"id":6683507,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134453","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39141A1"},{"id":6683508,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134454","seq_no":"2","part_no":"392","part_no_section":"7(a)","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:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"3927A"},{"id":6683509,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134455","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39021TB"},{"id":6683510,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134456","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39617C"},{"id":6683511,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134457","seq_no":"5","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39395F"},{"id":6683512,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134458","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"3939A"},{"id":6683513,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134459","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39311"},{"id":6683514,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134460","seq_no":"8","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39355B"},{"id":6683515,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134461","seq_no":"9","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39375B"},{"id":6683516,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134462","seq_no":"10","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"197830546","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39341"},{"id":6683517,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_violation_id":"256134463","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197830547","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6949484,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_unit_id":"197830546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XNJX99","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3D6WZ4EL5BG593101","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"},{"id":6949485,"change_date":"2023-10-31 21:39:00","inspection_id":"80048454","insp_unit_id":"197830547","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXAS","insp_unit_company":"13","insp_unit_license":"TZP43S","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"7HCGD1629PB042389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"}]},{"id":4094094,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","dot_number":"3620453","report_state":"PA","report_number":"M197000407","insp_date":"2023-09-28 00:00:00","insp_start_time":"1034","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"46110","location_desc":"RT 611\/I-276","county_code_state":"PA","county_code":"091","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":"Y","pen_cen_match":"I","final_status_date":"2023-09-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"9","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2384853","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2023-09-29 21:40:00","snet_input_date":"2023-09-28 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-09-29 21:40:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610-4838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:39.000000Z","updated_at":"2025-03-17T19:43:39.000000Z","inspection_violations":[{"id":6335441,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577401","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:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39141A1"},{"id":6335442,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577402","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197325152","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"3939A"},{"id":6335443,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577403","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197325152","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39617C"},{"id":6335444,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577404","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197325153","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39617C"},{"id":6335445,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577405","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197325152","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39395A"},{"id":6335446,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577406","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197325152","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39395F"},{"id":6335447,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577407","seq_no":"7","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"197325152","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39324A"},{"id":6335448,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577408","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197325153","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"39311"},{"id":6335449,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_violation_id":"255577409","seq_no":"9","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":"E0017196-4","created_at":"2025-03-17T21:36:33.000000Z","updated_at":"2025-03-17T21:36:33.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":6582141,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_unit_id":"197325152","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"XKGR13","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRNEL0KG638024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:14.000000Z","updated_at":"2025-03-17T22:55:14.000000Z"},{"id":6582142,"change_date":"2023-09-29 21:40:00","inspection_id":"79797531","insp_unit_id":"197325153","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":null,"insp_unit_license":"TXU29Z","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"5JW1D1620E2087699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:14.000000Z","updated_at":"2025-03-17T22:55:14.000000Z"}]},{"id":2641558,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","dot_number":"3620453","report_state":"NJ","report_number":"SPRH000914","insp_date":"2023-03-22 00:00:00","insp_start_time":"1510","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"206 N MP 18.5","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148841","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2023-03-23 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-03-23 21:42:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:29.000000Z","updated_at":"2025-03-17T19:15:29.000000Z","inspection_violations":[{"id":4060519,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","insp_violation_id":"251821051","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:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39141A1"},{"id":4060520,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","insp_violation_id":"251821052","seq_no":"2","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":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"38323A2"},{"id":4060521,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","insp_violation_id":"251821053","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"194019080","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":4252362,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","insp_unit_id":"194019079","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"XLRH84","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C63RRHL5NG113698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"},{"id":4252363,"change_date":"2023-03-23 21:42:00","inspection_id":"78163558","insp_unit_id":"194019080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":null,"insp_unit_license":"TZW67J","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"5JW1D1627L4276349","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"}]},{"id":2641562,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","dot_number":"3620453","report_state":"NJ","report_number":"SPRH000915","insp_date":"2023-03-22 00:00:00","insp_start_time":"1542","insp_end_time":"1602","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"206 N 18.5 SUTHAMPTON","county_code_state":"NJ","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","viol_total":"10","oos_total":"8","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149012","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03620453","upload_search_indicator":null,"census_search_date":"2023-03-23 21:42:00","snet_input_date":"2023-03-22 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-03-23 21:42:00","insp_carrier_name":"EXECUTIVE ROOFING SOLUTIONS LLC","insp_carrier_street":"437 NEWKIRK AVE","insp_carrier_city":"TRENTON","insp_carrier_state":"NJ","insp_carrier_zip_code":"08610","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:29.000000Z","updated_at":"2025-03-17T19:15:29.000000Z","inspection_violations":[{"id":4060528,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821080","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194019092","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39021TB"},{"id":4060529,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821081","seq_no":"2","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":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"38323A2"},{"id":4060530,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821082","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194019092","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"3922"},{"id":4060531,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821083","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060532,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821084","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060533,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821085","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060534,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821086","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060535,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821087","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060536,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821088","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194019093","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"39348A"},{"id":4060537,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_violation_id":"251821089","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194019092","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:03.000000Z","updated_at":"2025-03-17T21:26:03.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4252368,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_unit_id":"194019092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"XKGR13","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"3C7WRNELOKG638024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"},{"id":4252369,"change_date":"2023-03-23 21:42:00","inspection_id":"78163564","insp_unit_id":"194019093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"APPL","insp_unit_company":null,"insp_unit_license":"TZW67J","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"541GC4339LM000491","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3620453\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3620453\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3620453\/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\/3620453\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}