{"current_page":1,"data":[{"id":10174672,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","dot_number":"1159418","report_state":"NY","report_number":"0L73001637","insp_date":"2025-11-06 00:00:00","insp_start_time":"0906","insp_end_time":"1027","registration_date":null,"region":"ES","ci_status_code":"C","location":"00411P","location_desc":"MELVILLE NY","county_code_state":"NY","county_code":"103","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76000","viol_total":"5","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":"2531130","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:34.000000Z","updated_at":"2025-11-16T10:30:28.000000Z","inspection_violations":[{"id":16895947,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_violation_id":"269881316","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209966708","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA24KZJWKV","created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"3922SLLSR"},{"id":16895948,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_violation_id":"269881317","seq_no":"2","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA24KZJXTN","created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"3922WG"},{"id":16895949,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_violation_id":"269881318","seq_no":"3","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA24KZJZ2M","created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"3922WG"},{"id":16895950,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_violation_id":"269881319","seq_no":"4","part_no":"392","part_no_section":"2WG","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA24KZJZ92","created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"3922WG"},{"id":16895951,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_violation_id":"269881320","seq_no":"5","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209966708","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:51.000000Z","updated_at":"2025-11-16T10:30:54.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":16943728,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_unit_id":"209966708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"27035TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X56N632392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:30.000000Z","updated_at":"2025-11-16T10:00:32.000000Z"},{"id":16943729,"change_date":"2025-11-12 21:40:00","inspection_id":"86294174","insp_unit_id":"209966709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"CF64548","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042RC073584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:30.000000Z","updated_at":"2025-11-16T10:00:32.000000Z"}]},{"id":9855482,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","dot_number":"1159418","report_state":"NY","report_number":"0L92000500","insp_date":"2025-09-27 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"ED","ci_status_code":"C","location":"00421W","location_desc":"HAUPPAUGE NY","county_code_state":"NY","county_code":"103","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-10-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"178000","viol_total":"6","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":"2365481","transaction_code":"A","transaction_date":"2025-10-04 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2025-10-04 21:33:00","snet_input_date":"2025-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-04 21:33:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-08T10:01:25.000000Z","updated_at":"2025-10-08T10:01:25.000000Z","inspection_violations":[{"id":16232452,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097248","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"209298537","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"39378AWS"},{"id":16232453,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097249","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209298537","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"HA29KT8XFV","created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"3939ALBL"},{"id":16232454,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097250","seq_no":"3","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"2","insp_unit_id":"209298538","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"3939ALBL"},{"id":16232455,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097251","seq_no":"4","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209298537","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":16232456,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097252","seq_no":"5","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"209298538","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"39375A1TEPBM"},{"id":16232457,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_violation_id":"269097253","seq_no":"6","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"209298538","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:31.000000Z","updated_at":"2025-10-08T10:17:31.000000Z","normalized_code":"39375A1TEPBM"}],"inspection_per_units":[{"id":16344627,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_unit_id":"209298537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"27035TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X56N632392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:44.000000Z","updated_at":"2025-10-08T09:46:44.000000Z"},{"id":16344628,"change_date":"2025-10-04 21:33:00","inspection_id":"85957549","insp_unit_id":"209298538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"CF64548","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042RC073584","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:44.000000Z","updated_at":"2025-10-08T09:46:44.000000Z"}]},{"id":8740295,"change_date":"2025-05-27 21:38:00","inspection_id":"84783619","dot_number":"1159418","report_state":"NY","report_number":"0L79000862","insp_date":"2025-05-27 00:00:00","insp_start_time":"1035","insp_end_time":"1048","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"1785796","transaction_code":"A","transaction_date":"2025-05-27 00:00:00","upload_date":"2025-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2025-05-27 21:38:00","snet_input_date":"2025-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-27 21:38:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-30T10:00:24.000000Z","updated_at":"2025-05-31T10:00:20.000000Z","inspection_violations":[{"id":13950068,"change_date":"2025-05-27 21:38:00","inspection_id":"84783619","insp_violation_id":"266481009","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207071132","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:39.000000Z","updated_at":"2025-05-31T10:17:05.000000Z","normalized_code":"3922SLLIFTA"},{"id":13950069,"change_date":"2025-05-27 21:38:00","inspection_id":"84783619","insp_violation_id":"266481010","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"207071132","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-30T10:15:39.000000Z","updated_at":"2025-05-31T10:17:05.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":14290366,"change_date":"2025-05-27 21:38:00","inspection_id":"84783619","insp_unit_id":"207071132","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OSHKOSH MO","insp_unit_company":null,"insp_unit_license":"18564NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"10TAFLGF8JS783925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-30T09:45:28.000000Z","updated_at":"2025-05-31T09:46:54.000000Z"}]},{"id":8102988,"change_date":"2025-03-13 21:43:00","inspection_id":"84112046","dot_number":"1159418","report_state":"NY","report_number":"SPL3060365","insp_date":"2025-03-06 00:00:00","insp_start_time":"1123","insp_end_time":"1138","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"YAPHANK NY","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"176200","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":"1463450","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2025-03-13 21:43:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-13 21:43:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:49.000000Z","updated_at":"2025-03-17T21:06:49.000000Z","inspection_violations":[{"id":12669799,"change_date":"2025-03-13 21:43:00","inspection_id":"84112046","insp_violation_id":"265011014","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"205775561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:02.000000Z","updated_at":"2025-03-17T22:08:02.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":13082914,"change_date":"2025-03-13 21:43:00","inspection_id":"84112046","insp_unit_id":"205775561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"84","insp_unit_license":"31167TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40XXLD648321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:38.000000Z","updated_at":"2025-03-17T23:59:38.000000Z"},{"id":13082915,"change_date":"2025-03-13 21:43:00","inspection_id":"84112046","insp_unit_id":"205775562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK TRAIL","insp_unit_company":null,"insp_unit_license":"CF81897","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042SC073610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:38.000000Z","updated_at":"2025-03-17T23:59:38.000000Z"}]},{"id":6463186,"change_date":"2024-08-14 21:38:00","inspection_id":"82379342","dot_number":"1159418","report_state":"NY","report_number":"0L96000637","insp_date":"2024-08-14 00:00:00","insp_start_time":"1000","insp_end_time":"1127","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"JERICHO NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-14 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"68000","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":"744551","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2024-08-14 21:38:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-14 21:38:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:05.000000Z","updated_at":"2025-03-17T20:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10417547,"change_date":"2024-08-14 21:38:00","inspection_id":"82379342","insp_unit_id":"202383128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TEREX","insp_unit_company":"126","insp_unit_license":"32575ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5DG8AU4T910008559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"}]},{"id":6475462,"change_date":"2024-08-15 21:42:00","inspection_id":"82392376","dot_number":"1159418","report_state":"NY","report_number":"SPWL041824","insp_date":"2024-08-14 00:00:00","insp_start_time":"1731","insp_end_time":"1746","registration_date":null,"region":"ET","ci_status_code":"C","location":"00421R","location_desc":"ISLIP","county_code_state":"NY","county_code":"103","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-08-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"2945153","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2024-08-15 21:42:00","snet_input_date":"2024-08-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-15 21:42:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:09.000000Z","updated_at":"2025-03-17T20:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10437428,"change_date":"2024-08-15 21:42:00","inspection_id":"82392376","insp_unit_id":"202406925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"67102NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GT3CEC62627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:09.000000Z","updated_at":"2025-03-17T23:31:09.000000Z"}]},{"id":6317056,"change_date":"2024-07-26 21:38:00","inspection_id":"82223061","dot_number":"1159418","report_state":"NY","report_number":"0L10100717","insp_date":"2024-07-26 00:00:00","insp_start_time":"0734","insp_end_time":"0825","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ROSLYN HEIGHTS NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-26 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"124000","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":"687944","transaction_code":"A","transaction_date":"2024-07-26 00:00:00","upload_date":"2024-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2024-07-26 21:38:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-26 21:38:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:53.000000Z","updated_at":"2025-03-17T20:27:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10178699,"change_date":"2024-07-26 21:38:00","inspection_id":"82223061","insp_unit_id":"202085089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"19887TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB9X3XN489396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"},{"id":10178700,"change_date":"2024-07-26 21:38:00","inspection_id":"82223061","insp_unit_id":"202085090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":null,"insp_unit_license":"CD53891","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5HTSN4226F7T94891","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:25.000000Z","updated_at":"2025-03-17T23:28:25.000000Z"}]},{"id":5895156,"change_date":"2024-06-03 21:42:00","inspection_id":"81768274","dot_number":"1159418","report_state":"NY","report_number":"SPL0183238","insp_date":"2024-05-30 00:00:00","insp_start_time":"0738","insp_end_time":"0754","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"176200","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":"2927589","transaction_code":"A","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2024-06-03 21:42:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-03 21:42:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9495059,"change_date":"2024-06-03 21:42:00","inspection_id":"81768274","insp_unit_id":"201195828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"31167TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40XXLD648321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"},{"id":9495060,"change_date":"2024-06-03 21:42:00","inspection_id":"81768274","insp_unit_id":"201195829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"CF81897","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3042SC073610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:32.000000Z","updated_at":"2025-03-17T23:21:32.000000Z"}]},{"id":5016796,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","dot_number":"1159418","report_state":"NY","report_number":"SPL0156532","insp_date":"2024-02-08 00:00:00","insp_start_time":"1355","insp_end_time":"1418","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"175000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2905890","transaction_code":"A","transaction_date":"2024-02-09 00:00:00","upload_date":"2024-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2024-02-09 21:41:00","snet_input_date":"2024-02-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-09 21:41:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:04.000000Z","updated_at":"2025-03-17T20:02:04.000000Z","inspection_violations":[{"id":7729342,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757427","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199350774","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9HPM305","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3922"},{"id":7729343,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757428","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"199350774","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39355D1"},{"id":7729344,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757429","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199350774","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3939A"},{"id":7729345,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757430","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199350774","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39378"},{"id":7729346,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757431","seq_no":"5","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"199350775","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39355E"},{"id":7729347,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757432","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"199350775","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39375C"},{"id":7729348,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_violation_id":"257757433","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199350775","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8074439,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_unit_id":"199350774","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"27035TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X56N632392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:09.000000Z","updated_at":"2025-03-17T23:08:09.000000Z"},{"id":8074440,"change_date":"2024-02-09 21:41:00","inspection_id":"80811774","insp_unit_id":"199350775","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BL85387","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3044JC039957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:09.000000Z","updated_at":"2025-03-17T23:08:09.000000Z"}]},{"id":4799957,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","dot_number":"1159418","report_state":"NY","report_number":"D012100259","insp_date":"2024-01-10 00:00:00","insp_start_time":"1001","insp_end_time":"1059","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"174998","viol_total":"7","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":"167373","transaction_code":"A","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2024-01-10 21:43:00","snet_input_date":"2024-01-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:42.000000Z","updated_at":"2025-03-17T19:57:42.000000Z","inspection_violations":[{"id":7404790,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267674","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"198891678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39353BB"},{"id":7404791,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267675","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"198891679","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39353BB"},{"id":7404792,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267676","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198891678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39617CPI"},{"id":7404793,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267677","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198891678","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39347E"},{"id":7404794,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267678","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"198891678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0396HLHVTR","created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39378AWS"},{"id":7404795,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267679","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"198891679","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39347E"},{"id":7404796,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_violation_id":"257267680","seq_no":"7","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"198891679","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":7722599,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_unit_id":"198891678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"27035TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XP5DB0X56N632392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"},{"id":7722600,"change_date":"2024-01-10 21:43:00","inspection_id":"80574382","insp_unit_id":"198891679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"BL85387","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADS3044JC039957","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":3475483,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","dot_number":"1159418","report_state":"NY","report_number":"SPL0182660","insp_date":"2023-07-05 00:00:00","insp_start_time":"1025","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"00411C","location_desc":"DIX HILLS FIRE DEPARTMENT","county_code_state":"NY","county_code":"103","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"52000","viol_total":"11","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2845178","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":"01159418","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":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[{"id":5358381,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976855","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:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"39141A1"},{"id":5358382,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976856","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"28","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":"39395F"},{"id":5358383,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976857","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"195924968","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":5358384,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976858","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"26","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":"39378"},{"id":5358385,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976859","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2GXC176","created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3922"},{"id":5358386,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976860","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2GXC1FV","created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3922"},{"id":5358387,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976861","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"47","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"},{"id":5358388,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976862","seq_no":"8","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2GXC1L4","created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"39375G"},{"id":5358389,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976863","seq_no":"9","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"39375G"},{"id":5358390,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976864","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"14","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"},{"id":5358391,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_violation_id":"253976865","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195924968","insp_violation_category_id":"47","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":5588422,"change_date":"2023-07-11 21:41:00","inspection_id":"79106671","insp_unit_id":"195924968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OSHK","insp_unit_company":null,"insp_unit_license":"62887MC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"10TFAAC2X5S084099","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":2980849,"change_date":"2023-05-08 21:41:00","inspection_id":"78549046","dot_number":"1159418","report_state":"NY","report_number":"0L92000034","insp_date":"2023-05-04 00:00:00","insp_start_time":"1210","insp_end_time":"1324","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCPD HQ 30 YAPHANK AVE","county_code_state":"NY","county_code":"103","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":"2023-05-06 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"179200","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":"2822615","transaction_code":"C","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":null,"census_search_date":"2023-05-06 21:31:00","snet_input_date":"2023-05-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-06 21:31:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:13.000000Z","updated_at":"2025-03-17T19:22:13.000000Z","inspection_violations":[{"id":4575866,"change_date":"2023-05-08 21:41:00","inspection_id":"78549046","insp_violation_id":"252673085","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194791647","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H922GPQWVP","created_at":"2025-03-17T21:28:19.000000Z","updated_at":"2025-03-17T21:28:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4795867,"change_date":"2023-05-08 21:41:00","inspection_id":"78549046","insp_unit_id":"194791647","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84","insp_unit_license":"31167TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40XXLD648321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:48.000000Z","updated_at":"2025-03-17T22:40:48.000000Z"},{"id":4795868,"change_date":"2023-05-08 21:41:00","inspection_id":"78549046","insp_unit_id":"194791648","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BN63984","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3044JC042425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:48.000000Z","updated_at":"2025-03-17T22:40:48.000000Z"}]},{"id":2150621,"change_date":"2023-01-17 21:41:00","inspection_id":"77604250","dot_number":"1159418","report_state":"NY","report_number":"SPL0134829","insp_date":"2023-01-10 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"179200","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":"2789826","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":"01159418","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":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:16.000000Z","updated_at":"2025-03-17T19:06:16.000000Z","inspection_violations":[{"id":3325898,"change_date":"2023-01-17 21:41:00","inspection_id":"77604250","insp_violation_id":"250590209","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192887769","insp_violation_category_id":"14","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":"3922"}],"inspection_per_units":[{"id":3460275,"change_date":"2023-01-17 21:41:00","inspection_id":"77604250","insp_unit_id":"192887769","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"84","insp_unit_license":"31167TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1XPXD40XXLD648321","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:49.000000Z","updated_at":"2025-03-17T22:30:49.000000Z"},{"id":3460276,"change_date":"2023-01-17 21:41:00","inspection_id":"77604250","insp_unit_id":"192887770","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"BN63984","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5MADA3044JC042425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:49.000000Z","updated_at":"2025-03-17T22:30:49.000000Z"}]},{"id":1703073,"change_date":"2022-11-09 21:40:00","inspection_id":"77091864","dot_number":"1159418","report_state":"NY","report_number":"0L79000210","insp_date":"2022-11-08 00:00:00","insp_start_time":"1414","insp_end_time":"1421","registration_date":null,"region":"ET","ci_status_code":"C","location":"3050","location_desc":"N\/B 135 TO W\/B 495","county_code_state":"NY","county_code":"059","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":"Y","pen_cen_match":"I","final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2766981","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:10.000000Z","updated_at":"2025-03-17T18:58:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2739905,"change_date":"2022-11-09 21:40:00","inspection_id":"77091864","insp_unit_id":"191872774","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ADVE","insp_unit_company":null,"insp_unit_license":"47114MG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1A9TAC4S7X0007811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:44.000000Z","updated_at":"2025-03-17T22:25:44.000000Z"}]},{"id":1588313,"change_date":"2022-10-25 21:40:00","inspection_id":"76960214","dot_number":"1159418","report_state":"NY","report_number":"0L47001615","insp_date":"2022-10-24 00:00:00","insp_start_time":"1005","insp_end_time":"1013","registration_date":null,"region":"ET","ci_status_code":"C","location":"3050","location_desc":"W\/B RT 25, SYOSSET","county_code_state":"NY","county_code":"059","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":"Y","pen_cen_match":"I","final_status_date":"2022-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"2762415","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2022-10-25 21:40:00","snet_input_date":"2022-10-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-25 21:40:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:56.000000Z","updated_at":"2025-03-17T18:55:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2555776,"change_date":"2022-10-25 21:40:00","inspection_id":"76960214","insp_unit_id":"191612433","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OSHK","insp_unit_company":null,"insp_unit_license":"62887MC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"10TFAAC2X5S084099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:32.000000Z","updated_at":"2025-03-17T22:24:32.000000Z"}]},{"id":992828,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","dot_number":"1159418","report_state":"NY","report_number":"1019007368","insp_date":"2022-08-09 00:00:00","insp_start_time":"0957","insp_end_time":"1024","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634M","location_desc":"PLAINVIEW INSPECTION SITE (EB)","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76500","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2736697","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01159418","upload_search_indicator":"M","census_search_date":"2022-08-09 21:40:00","snet_input_date":"2022-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-09 21:40:00","insp_carrier_name":"D & A SAND & GRAVEL INC","insp_carrier_street":"335 SAGAMORE AVE","insp_carrier_city":"MINEOLA","insp_carrier_state":"NY","insp_carrier_zip_code":"11501","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:07.000000Z","updated_at":"2025-03-17T18:45:07.000000Z","inspection_violations":[{"id":1565230,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592853","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3922"},{"id":1565231,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592854","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3922"},{"id":1565232,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592855","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39378"},{"id":1565233,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592856","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"},{"id":1565234,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592857","seq_no":"6","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"39019B2"},{"id":1565235,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_violation_id":"247592858","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190202564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:22.000000Z","updated_at":"2025-03-17T21:14:22.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1597594,"change_date":"2022-08-09 21:40:00","inspection_id":"76269077","insp_unit_id":"190202564","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"TRUC","insp_unit_company":"20","insp_unit_license":"56519ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5DG8AC4TX20008999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:04.000000Z","updated_at":"2025-03-17T22:18:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1159418\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1159418\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1159418\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1159418\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}