OpenAirDocs.org
Butler, PA

Cancelled registrations · 49

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'PA' AND d.registrant_city = 'BUTLER'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N5689SPiper PA-23-150 · S/N 23-216Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1955 · Rastelli Stephen LN2747WSeruset Jeffrey G CHALLENGER II · S/N CH2-0606-2747Cancelled Aug 17, 2020 · Third renewal notice · Seruset Jeffrey GN9934YChampion 402 · S/N 40215Cancelled Nov 21, 2017 · Revoked, canceled · Built 1963 · Butler Avn CoN5667ZPiper PA-22-108 · S/N 22-9490Cancelled May 24, 2016 · Built 1962 · Listisen John SN8266NPiper PA-28-140 · S/N 28-25479Cancelled Feb 19, 2016 · Built 1969 · Mcpherson Richard R JrN86064Aeronca 11AC · S/N 11AC-487Cancelled May 11, 2015 · Sale reported, canceled · Built 1946N20462Brei William H QUICKIE Q-2 · S/N 2018Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1995 · Hazen Floyd NN707PTCessna 172M · S/N 17261563Cancelled May 8, 2013 · Exported to Canada · Built 1973 · Thompson Glenn HN8860CPiper PA-22-135 · S/N 22-1492Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1953N34DPPauls SCORPION II 76-140 · S/N 38140Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1980 · Skelly RandyN3694XAero Commander 100 · S/N 332Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1969N58702Cessna T-50 · S/N 5832Cancelled Aug 30, 2012 · Revoked, canceled · Built 1944 · Greenawalt Robert PN388NHSix Chuter SR7 · S/N PTRTTDE-2861Cancelled Aug 23, 2012 · Registration pending, canceled · Built 2002N2998RPiper PA-28R-200 · S/N 28R-35390Cancelled Feb 8, 2012 · Exported to Brazil · Built 1969 · Chick James PN8377UCessna 172F · S/N 17252277Cancelled Sep 21, 2009 · Exported to Ecuador · Built 1964 · Moraine Flying Club IncN7545VCessna 177RG · S/N 177RG0842Cancelled Aug 11, 2005 · Triennial form not returned · Built 1976 · Burtner Duane WN18128Cessna 150L · S/N 15073806Cancelled Jul 14, 2003 · Triennial form not returned · Built 1972 · Barkus Robert RN36082Aerostar International RAVEN S57-A · S/N S57A-3079Cancelled Oct 22, 2001 · Triennial form not returned · Built 1989 · Lachendro Stephen JN4029JBellis Aaron EAGLE 1 · S/N 001Cancelled May 23, 1997 · Triennial form not returned · Bellis AaronN736XKCessna R172K · S/N R1722868Cancelled Mar 22, 1996 · Exported to Germany · Tack Janet MN7360HPiper J-3 · S/N 20620Cancelled Apr 19, 1982 · Palm John NN2644Cessna 195 · S/N 7155Cancelled Mar 31, 1982 · Built 1948 · Roe Thomas WN7142FCessna 150F · S/N 15063742Cancelled Oct 15, 1971 · B & B Aviation IncN98831Piper J3C-65 · S/N 19080Cancelled Jun 26, 1970 · Built 1946 · B & B Aviation IncN7063LCessna 310K · S/N 310K0163Cancelled Sep 29, 1967 · Exported to India · Harsco Corporation/Heckett Engineering CoN3056ZPiper PA-22 · S/N 22-7011Cancelled May 25, 1965 · Exported to Germany · Scholter Aviation Co IncN5801DPiper PA-22-150 · S/N 22-4476Cancelled May 24, 1965 · Exported to Germany · Scholter Aviation Co IncN35373Piper J5A · S/N 5623Cancelled May 20, 1965 · Ledonne Herman MN7037WPiper PA-28-180 · S/N 28-720Cancelled May 4, 1964 · Exported to Germany · Built 1962 · Scholter Aviation Company IncN5081WPiper PA-28 · S/N 28-90Cancelled Apr 2, 1964 · Exported to Germany · Scholter Aviation Co IncN5316WPiper PA-28-160 · S/N 28-372Cancelled Sep 13, 1962 · Exported to Germany · Scholter Aviation Co IncN8703DPiper PA-22-160 · S/N 22-5884Cancelled Jan 2, 1962 · Exported to Germany · Scholter Aviation Co IncN2819ZPiper PA-22-160 · S/N 22-6812Cancelled Dec 15, 1961 · Exported to Germany · Scholter Aviation Co IncN5565HPiper PA-11 · S/N 11-1087Cancelled Sep 20, 1961 · Exported to Canada · Built 1949 · Sholter Aviation Co IncN8051DPiper PA-22-150 · S/N 22-5575Cancelled Jul 5, 1961 · Patterson John RN25837Piper J3L · S/N 3790Cancelled Feb 24, 1959 · Built 1939 · Geibel J FN24841Piper J3F-50 · S/N 3482Cancelled May 13, 1955 · Scott C AndrewsN96893Taylorcraft BC12-D · S/N 9193Cancelled Oct 25, 1951 · Exported to Canada · Built 1946 · Heilman R BN652YAeronca C-2 · S/N A-94Cancelled Apr 5, 1949 · Forsythe William AN10784Piper E-2 · S/N 13Cancelled Oct 3, 1947 · Lang Pete Et AlN87966Piper J3C-65 · S/N 15584Cancelled Jul 10, 1947 · Werling HarveyN41559Piper J3L-65 · S/N 9048Cancelled Dec 19, 1944 · Graham Aviation Flying Schools IncN29367Waco UPF-7 · S/N 5394Cancelled Nov 18, 1943 · Built 1940 · Graham Aviation Flying Schools IncN24834Piper J3F-50 · S/N 3478Cancelled Nov 9, 1943 · Penn Flyers ClubN39705Waco UPF-7 · S/N 5837Cancelled Oct 12, 1943 · Graham Aviation Flying Schools IncN39719Waco UPF-7 · S/N 5852Cancelled Oct 12, 1940 · Graham Aviation Flying Schools IncN13539Harper LOW WING A-1 · S/N 1Cancelled Jun 30, 1935 · Built 1934 · Dutton Howard EN12692New Era B · S/N 101Cancelled Dec 15, 1932 · Built 1932 · New Era Aircraft CorpN10778New Era A · S/N 100Cancelled Apr 22, 1932 · Built 1931 · New Era Aircraft Corp
Back to Butler, PA