{"current_page":1,"data":[{"id":11580339,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","dot_number":"1526132","report_state":"NY","report_number":"5L52000152","insp_date":"2026-04-06 00:00:00","insp_start_time":"0939","insp_end_time":"1013","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","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":"U","pen_cen_match":"I","final_status_date":"2026-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"8","oos_total":"5","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3122722","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":null,"census_search_date":"2026-04-07 21:38:00","snet_input_date":"2026-04-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-07 21:38:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-10T09:43:06.000000Z","updated_at":"2026-04-17T09:48:18.000000Z","inspection_violations":[{"id":19583913,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905514","seq_no":"6","part_no":"383","part_no_section":"91A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"7244LHN4CG","created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"38391ALCDL"},{"id":19583908,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905509","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"212572513","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":19583910,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905511","seq_no":"3","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"3922SLLTCD"},{"id":19583911,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905512","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"212572514","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"3963A1BOS"},{"id":19583912,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905513","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212572513","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"3922SLLIFTA"},{"id":19583914,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905515","seq_no":"7","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"212572514","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"7015LHN4CT","created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"39343DB"},{"id":19583915,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905516","seq_no":"8","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"212572514","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"393100BC"},{"id":19583909,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_violation_id":"272905510","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-09T10:16:29.000000Z","updated_at":"2026-04-18T10:41:31.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":19848871,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_unit_id":"212572513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"13575MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GYXKDA12916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:19.000000Z","updated_at":"2026-04-18T09:27:43.000000Z"},{"id":19848872,"change_date":"2026-04-07 21:38:00","inspection_id":"87504751","insp_unit_id":"212572514","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"BLACK","insp_unit_license":"CG77939","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW2U1622G1143221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-10T09:22:19.000000Z","updated_at":"2026-04-18T09:27:43.000000Z"}]},{"id":8955733,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","dot_number":"1526132","report_state":"NY","report_number":"5L44000604","insp_date":"2025-06-18 00:00:00","insp_start_time":"0918","insp_end_time":"1012","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DEPEW NY","county_code_state":"NY","county_code":"029","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":"U","pen_cen_match":"I","final_status_date":"2025-06-23 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"34500","viol_total":"10","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1900760","transaction_code":"C","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":null,"census_search_date":"2025-06-23 21:40:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-23 21:40:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:25.000000Z","updated_at":"2025-11-26T10:31:13.000000Z","inspection_violations":[{"id":17146083,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193851","seq_no":"1","part_no":"383","part_no_section":"91A-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"DP61KGHF0","created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"38391ALCDL"},{"id":17146084,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193852","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"3922SLLEQP"},{"id":17146085,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193853","seq_no":"3","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":17146086,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193854","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"3922SLLIFTA"},{"id":17146087,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193855","seq_no":"5","part_no":"392","part_no_section":"2-SLLILC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DP61KGR7G","created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"3922SLLILC"},{"id":17146088,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193856","seq_no":"6","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DP61KGR3N","created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"393100BC"},{"id":17146089,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193857","seq_no":"7","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210200565","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DP61KGR62","created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"39375A3TAOL"},{"id":17146090,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193858","seq_no":"8","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"39395A1"},{"id":17146091,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193859","seq_no":"9","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"3969D2FTF"},{"id":17146092,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_violation_id":"270193860","seq_no":"10","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210200564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:36.000000Z","updated_at":"2025-11-26T10:36:53.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":17130752,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_unit_id":"210200564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"67209ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GY1JEB92778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:30.000000Z","updated_at":"2025-11-26T10:01:32.000000Z"},{"id":17130753,"change_date":"2025-11-22 21:49:00","inspection_id":"85012058","insp_unit_id":"210200565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CE13874","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"7RA1D2028NS003581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:30.000000Z","updated_at":"2025-11-26T10:01:32.000000Z"}]},{"id":7143314,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","dot_number":"1526132","report_state":"NY","report_number":"D507101021","insp_date":"2024-11-01 00:00:00","insp_start_time":"0857","insp_end_time":"0935","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WEST SENECA NY","county_code_state":"NY","county_code":"029","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":"U","pen_cen_match":"I","final_status_date":"2024-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1030661","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-11-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:05.000000Z","updated_at":"2025-03-17T20:45:05.000000Z","inspection_violations":[{"id":11158981,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779203","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WS24JN2V7P","created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"38323A2LCDLN"},{"id":11158982,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779204","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WS24JN2VS1","created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"39141A"},{"id":11158983,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779205","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"203779632","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WS24JN2W3N","created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"3922SLLIFTA"},{"id":11158984,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779206","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"203779633","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"39617CPI"},{"id":11158985,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779207","seq_no":"5","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"203779633","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"3939ALLPL"},{"id":11158986,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779208","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203779632","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"3922SLLSR"},{"id":11158987,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_violation_id":"262779209","seq_no":"7","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"203779632","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:07.000000Z","updated_at":"2025-03-17T22:00:07.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":11521365,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_unit_id":"203779632","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"57804NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GN9PDA16582","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T23:42:23.000000Z","updated_at":"2025-03-17T23:42:23.000000Z"},{"id":11521366,"change_date":"2024-11-07 21:40:00","inspection_id":"83102777","insp_unit_id":"203779633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"BH86329","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1621F1120765","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T23:42:23.000000Z","updated_at":"2025-03-17T23:42:23.000000Z"}]},{"id":6655291,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","dot_number":"1526132","report_state":"NY","report_number":"SPA0360662","insp_date":"2024-09-04 00:00:00","insp_start_time":"0814","insp_end_time":"0851","registration_date":null,"region":"ET","ci_status_code":"C","location":"50481B","location_desc":"LOCKPORT 2","county_code_state":"NY","county_code":"063","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PICKET FENCE AND EXTERIORS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"5","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2948860","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":"M","census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-09-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:53.000000Z","updated_at":"2025-03-17T20:34:53.000000Z","inspection_violations":[{"id":10357134,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_violation_id":"261632302","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"400628374","created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39216A"},{"id":10357135,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_violation_id":"261632303","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39141A"},{"id":10357136,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_violation_id":"261632304","seq_no":"3","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"39216B"},{"id":10357137,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_violation_id":"261632305","seq_no":"4","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"1","insp_unit_id":"202774830","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"393104F3"},{"id":10357138,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_violation_id":"261632306","seq_no":"5","part_no":"393","part_no_section":"110","insp_viol_unit":"1","insp_unit_id":"202774830","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:09.000000Z","updated_at":"2025-03-17T21:56:09.000000Z","normalized_code":"393110"}],"inspection_per_units":[{"id":10730160,"change_date":"2024-09-05 21:42:00","inspection_id":"82584053","insp_unit_id":"202774830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"13575MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GYXKDA12916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"}]},{"id":5086126,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","dot_number":"1526132","report_state":"NY","report_number":"SPA0360229","insp_date":"2024-02-16 00:00:00","insp_start_time":"1255","insp_end_time":"1321","registration_date":null,"region":"ET","ci_status_code":"C","location":"50019","location_desc":"AMHERST","county_code_state":"NY","county_code":"029","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PICKET FENCE AND EXTERIORS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2908480","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":null,"census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"PICKET FENCE AND EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:27.000000Z","updated_at":"2025-03-17T20:03:27.000000Z","inspection_violations":[{"id":7840895,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","insp_violation_id":"257918887","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199495306","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"3922"},{"id":7840896,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","insp_violation_id":"257918888","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"199495306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"3969D2"},{"id":7840897,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","insp_violation_id":"257918889","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199495306","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"3922"},{"id":7840898,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","insp_violation_id":"257918890","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199495306","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":8187934,"change_date":"2024-02-20 21:41:00","inspection_id":"80887470","insp_unit_id":"199495306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"67209ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GY1JEB92778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:12.000000Z","updated_at":"2025-03-17T23:09:12.000000Z"}]},{"id":4812808,"change_date":"2024-01-11 21:46:00","inspection_id":"80588550","dot_number":"1526132","report_state":"NY","report_number":"SPWA120921","insp_date":"2024-01-09 00:00:00","insp_start_time":"0930","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"40207","location_desc":"COVINGTON","county_code_state":"NY","county_code":"121","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PICKETT FENCE AND EXTERIOR INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-11 21:46:00","post_acc_ind":"Y","gross_comb_veh_wt":"26500","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":"2898758","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":"M","census_search_date":"2024-01-11 21:46:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:03.000000Z","updated_at":"2025-03-17T19:58:03.000000Z","inspection_violations":[{"id":7423881,"change_date":"2024-01-11 21:46:00","inspection_id":"80588550","insp_violation_id":"257297381","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":7743096,"change_date":"2024-01-11 21:46:00","inspection_id":"80588550","insp_unit_id":"198918766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"97610MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GYOHEB14941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:12.000000Z","updated_at":"2025-03-17T23:05:12.000000Z"},{"id":7743097,"change_date":"2024-01-11 21:46:00","inspection_id":"80588550","insp_unit_id":"198918767","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BR66636","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U16Z1F1116442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:12.000000Z","updated_at":"2025-03-17T23:05:12.000000Z"}]},{"id":3496672,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","dot_number":"1526132","report_state":"NY","report_number":"0519001086","insp_date":"2023-07-12 00:00:00","insp_start_time":"0922","insp_end_time":"0942","registration_date":null,"region":"ET","ci_status_code":"C","location":"52007","location_desc":"BUFFALO","county_code_state":"NY","county_code":"029","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":"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":"N","pen_cen_match":"I","final_status_date":"2023-07-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"10","oos_total":"5","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"6","vehicle_oos_total":"3","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"2846210","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":"M","census_search_date":"2023-07-13 21:41:00","snet_input_date":"2023-07-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-13 21:41:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"PO BOX 757","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:07.000000Z","updated_at":"2025-03-17T19:32:07.000000Z","inspection_violations":[{"id":5392061,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032196","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195972532","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3922"},{"id":5392062,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032197","seq_no":"2","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"195972532","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"177834A"},{"id":5392063,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032198","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"195972532","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39395F"},{"id":5392064,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032199","seq_no":"4","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"195972533","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"393100B"},{"id":5392065,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032200","seq_no":"5","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"195972533","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"393104F3"},{"id":5392066,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032201","seq_no":"6","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"195972533","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39323"},{"id":5392067,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032202","seq_no":"7","part_no":"391","part_no_section":"11(b)(5)","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:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"39111B5"},{"id":5392068,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032203","seq_no":"10","part_no":"392","part_no_section":"8","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:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3928"},{"id":5392069,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032204","seq_no":"8","part_no":"392","part_no_section":"4(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3924A"},{"id":5392070,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_violation_id":"254032205","seq_no":"9","part_no":"392","part_no_section":"9","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:01.000000Z","updated_at":"2025-03-17T21:32:01.000000Z","normalized_code":"3929"}],"inspection_per_units":[{"id":5622271,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_unit_id":"195972532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"20850ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GN4NDA12470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:23.000000Z","updated_at":"2025-03-17T22:47:23.000000Z"},{"id":5622272,"change_date":"2023-07-13 21:41:00","inspection_id":"79130439","insp_unit_id":"195972533","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BH86329","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5JW1U1621F1120765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:23.000000Z","updated_at":"2025-03-17T22:47:23.000000Z"}]},{"id":3508591,"change_date":"2023-07-14 21:40:00","inspection_id":"79143667","dot_number":"1526132","report_state":"NY","report_number":"SPT0356051","insp_date":"2023-07-12 00:00:00","insp_start_time":"0840","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"01525","location_desc":"DEPEW (EXIT 49)","county_code_state":"NY","county_code":"029","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-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2846922","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":null,"census_search_date":"2023-07-14 21:40:00","snet_input_date":"2023-07-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-14 21:40:00","insp_carrier_name":"PICKET FENCE AND EXTERIORS INC","insp_carrier_street":"6695 TRANSIT RD","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[{"id":5409755,"change_date":"2023-07-14 21:40:00","inspection_id":"79143667","insp_violation_id":"254061428","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2GZ3580","created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"39216A"},{"id":5409756,"change_date":"2023-07-14 21:40:00","inspection_id":"79143667","insp_violation_id":"254061429","seq_no":"2","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"39216B"}],"inspection_per_units":[{"id":5641422,"change_date":"2023-07-14 21:40:00","inspection_id":"79143667","insp_unit_id":"196000141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"67209ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GY1JEB92778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:32.000000Z","updated_at":"2025-03-17T22:47:32.000000Z"}]},{"id":2558305,"change_date":"2023-03-13 21:41:00","inspection_id":"78068905","dot_number":"1526132","report_state":"NY","report_number":"5L37000253","insp_date":"2023-03-10 00:00:00","insp_start_time":"0926","insp_end_time":"0936","registration_date":null,"region":"ET","ci_status_code":"C","location":"50830","location_desc":"TONAWANDA 1","county_code_state":"NY","county_code":"029","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-03-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"2806047","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01526132","upload_search_indicator":"M","census_search_date":"2023-03-13 21:41:00","snet_input_date":"2023-03-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-13 21:41:00","insp_carrier_name":"PICKET FENCE & EXTERIORS INC","insp_carrier_street":"PO BOX 757","insp_carrier_city":"EAST AMHERST","insp_carrier_state":"NY","insp_carrier_zip_code":"14051","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:45.000000Z","updated_at":"2025-03-17T19:13:45.000000Z","inspection_violations":[{"id":3935865,"change_date":"2023-03-13 21:41:00","inspection_id":"78068905","insp_violation_id":"251611078","seq_no":"1","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"193825888","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:27.000000Z","updated_at":"2025-03-17T21:25:27.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":4117457,"change_date":"2023-03-13 21:41:00","inspection_id":"78068905","insp_unit_id":"193825888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"20850ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5GN4NDA12470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1526132\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1526132\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1526132\/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\/1526132\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}