{"current_page":1,"data":[{"id":12012677,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","dot_number":"3147012","report_state":"NY","report_number":"SPA3061345","insp_date":"2026-05-19 00:00:00","insp_start_time":"1103","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":"50464M","location_desc":"LEWISTON NY","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AURORA DOOR & WINDOW LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23600","viol_total":"10","oos_total":"6","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"7","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3398936","transaction_code":"A","transaction_date":"2026-05-25 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03147012","upload_search_indicator":null,"census_search_date":"2026-05-26 21:39:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-26 21:39:00","insp_carrier_name":"AURORA DOOR & WINDOW LLC","insp_carrier_street":"1158 DAVIS ROAD","insp_carrier_city":"WEST FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-29T09:39:50.000000Z","updated_at":"2026-06-06T09:31:07.000000Z","inspection_violations":[{"id":20901065,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488365","seq_no":"2","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39343DB"},{"id":20901066,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488366","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213742082","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39395F"},{"id":20901067,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488367","seq_no":"4","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"3963A1HCM"},{"id":20901068,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488368","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39617CPI"},{"id":20901069,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488369","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"3939ALLPL"},{"id":20901070,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488370","seq_no":"7","part_no":"392","part_no_section":"2SLSCR","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":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"3922SLSCR"},{"id":20901071,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488371","seq_no":"8","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39375A3TAOL"},{"id":20901072,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488372","seq_no":"9","part_no":"391","part_no_section":"11B4-CLHA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39111B4CLHA"},{"id":20901073,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488373","seq_no":"10","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"39141APC"},{"id":20901064,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_violation_id":"274488364","seq_no":"1","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"213742083","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-29T09:58:51.000000Z","updated_at":"2026-06-06T09:42:20.000000Z","normalized_code":"3963A1HCM"}],"inspection_per_units":[{"id":20881615,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_unit_id":"213742082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"85350NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCZGGF79S1227667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:12.000000Z","updated_at":"2026-06-06T09:02:34.000000Z"},{"id":20881616,"change_date":"2026-05-26 21:39:00","inspection_id":"87951810","insp_unit_id":"213742083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CE40025","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JWGT2221NN568150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:12.000000Z","updated_at":"2026-06-06T09:02:34.000000Z"}]},{"id":9149448,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","dot_number":"3147012","report_state":"NY","report_number":"SPE3020689","insp_date":"2025-07-08 00:00:00","insp_start_time":"1100","insp_end_time":"1154","registration_date":"2025-08-08 00:00:00","region":"ED","ci_status_code":"C","location":"40055M","location_desc":"BATAVIA NY","county_code_state":"NY","county_code":"037","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"18350","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1991943","transaction_code":"C","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03147012","upload_search_indicator":null,"census_search_date":"2025-07-15 21:39:00","snet_input_date":"2025-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-15 21:39:00","insp_carrier_name":"AURORA DOOR & WINDOW LLC","insp_carrier_street":"1158 DAVIS ROAD","insp_carrier_city":"WEST FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:54.000000Z","updated_at":"2025-09-06T10:42:01.000000Z","inspection_violations":[{"id":15548269,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308102","seq_no":"1","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"208630025","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39348ABIHE"},{"id":15548270,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308103","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39141APC"},{"id":15548271,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308104","seq_no":"3","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"208630024","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39341BNPB"},{"id":15548272,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308105","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208630025","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"3963A1BOS"},{"id":15548273,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308106","seq_no":"5","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208630024","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8E24KJMZCX","created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"3939ALHLI"},{"id":15548274,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308107","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208630025","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39617CPI"},{"id":15548275,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308108","seq_no":"7","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":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"3922SLL"},{"id":15548276,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308109","seq_no":"8","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208630024","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8E24KJMZ6L","created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39395F"},{"id":15548277,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_violation_id":"268308110","seq_no":"9","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208630024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:45:17.000000Z","updated_at":"2025-09-06T10:45:17.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":15722782,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_unit_id":"208630024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"30659NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"WD0PE745985245416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:26.000000Z","updated_at":"2025-09-09T09:46:26.000000Z"},{"id":15722783,"change_date":"2025-08-28 21:40:00","inspection_id":"85216041","insp_unit_id":"208630025","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CJ59729","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5NHUCC021HN083476","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:26.000000Z","updated_at":"2025-09-09T09:46:26.000000Z"}]},{"id":2071951,"change_date":"2023-01-05 21:39:00","inspection_id":"77513973","dot_number":"3147012","report_state":"NY","report_number":"0515007785","insp_date":"2023-01-04 00:00:00","insp_start_time":"0928","insp_end_time":"0943","registration_date":null,"region":"ET","ci_status_code":"C","location":"40616","location_desc":"ORANGEVILLE","county_code_state":"NY","county_code":"121","insp_level_id":"2","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-01-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"2785131","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03147012","upload_search_indicator":"M","census_search_date":"2023-01-05 21:39:00","snet_input_date":"2023-01-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-05 21:39:00","insp_carrier_name":"AURORA DOOR & WINDOW LLC","insp_carrier_street":"1158 DAVIS ROAD","insp_carrier_city":"WEST FALLS","insp_carrier_state":"NY","insp_carrier_zip_code":"14170","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:46.000000Z","updated_at":"2025-03-17T19:04:46.000000Z","inspection_violations":[{"id":3208061,"change_date":"2023-01-05 21:39:00","inspection_id":"77513973","insp_violation_id":"250398628","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:22:12.000000Z","updated_at":"2025-03-17T21:22:12.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":3333277,"change_date":"2023-01-05 21:39:00","inspection_id":"77513973","insp_unit_id":"192709027","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"16361ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FL8BDB10073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3147012\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3147012\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3147012\/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\/3147012\/inspections","per_page":100,"prev_page_url":null,"to":3,"total":3}