OpenAirDocs.org
York, PA

Cancelled registrations · 53

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 = 'YORK'
  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.

N7538PPiper PA-24-250 · S/N 24-2743Cancelled Oct 16, 2025 · Built 1961 · Sadiekatie LLCN9536XCameron Balloons US V-77 · S/N 5581Cancelled Aug 25, 2025 · Sale reported, canceled · Built 1990N60YBEurocopter Deutschland EC 135 T2+ · S/N 0504Cancelled Oct 2, 2024 · Exported to Canada · Built 2006 · York Building Products Co IncN55NKHanson Gerald E HANSON BUCKER 131E · S/N 602Cancelled Mar 15, 2022 · Registration pending, canceledN723NADJI INSPIRE 1 · S/N W13DCG21040877Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Mattey AlexisN95400Cameron Balloons US V-77 · S/N 5555Cancelled Aug 8, 2019 · Registration pending, canceled · Built 1989N9456ECessna 172N · S/N 17272270Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Built 1979 · Nagorny Steven AN215JRWilliams RIDGET MIDGET · S/N 001Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1975 · Mudd Christopher MN18805Aeronca K · S/N K-68Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1937 · York County Heritage TrustN734HLCessna 172N · S/N 17268866Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1977 · Nagorny Steven AN17MTPiper AEROSTAR 600 · S/N 6006417961203Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1979 · Sagel Henry KN8033LFay Robert F RF SPECIAL · S/N 001Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 2010 · Fay Robert FN63056Cessna 150M · S/N 15077069Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1975 · Werner MarkN4503HPiper J3C-65 · S/N 22754Cancelled Sep 8, 2016 · Registration pending, canceled · Built 1947N65895Cessna 172P · S/N 17275915Cancelled Aug 9, 2016 · Built 1983 · Mark BurchfieldN7414PBalloon Works FIREFLY 8B · S/N F8B-074Cancelled May 19, 2015 · Registration expired, pending cancellation · Logan Clifford David JrN9673CPiper PA-28R-201 · S/N 28R-7837215Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1978 · 4621j AviationN21243Cessna 182P · S/N 18261511Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1972 · Newman Bruce GN136ERSocata TB 9 TAMPICO · S/N 1526Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Nagorny Steven AN9108BCessna 172 · S/N 36608Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 1958 · Reed Robert AN168FJJones Fred H MARQUART CHARGER MA5 · S/N FJ1982Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1982 · Jones Fred HN59MBBell 206B · S/N 847Cancelled Mar 21, 2013 · Second renewal notice · Built 1972 · Jones Leslie AN557RWRaytheon A36 · S/N E-3620Cancelled Jan 3, 2011 · Exported to Brazil · Kinard Trucking IncN19485Cessna C-145 · S/N 455Cancelled Oct 9, 2009 · Registration revoked · Built 1938 · Keystone Mapping Co IncN53267Cessna 152 · S/N 15283524Cancelled Nov 13, 2008 · Exported to India · Built 1979 · Air KuftaN9035FAerostar International RAVEN S49A · S/N S49A-3131Cancelled Feb 2, 2005 · Exported to Canada · Built 1992 · Wood Eleanor CN167JBBatson James L BUSHBY MUSTANG M-II · S/N 167Cancelled Nov 29, 2004 · Triennial form not returned · Batson James LN5522RCessna 172F · S/N 17253099Cancelled Feb 25, 1995 · Triennial form not returned · Salkin Jonathan TN3270LSechrist Thomas H MITCHELL U2 ULTLGT · S/N 392Cancelled Jun 1, 1993 · Sechrist Thomas HN83VBVantassel Barry T KR-2 · S/N 6252Cancelled Oct 26, 1992 · Triennial form not returned · Vantassel Barry TN14DRCessna 310I · S/N 310I0045Cancelled Feb 14, 1985 · Administratively canceled · AerophiliaN4377NCessna 195 · S/N 7029Cancelled Jul 1, 1981 · Built 1947 · Haerstown Cash Register CoN8198Gauntt BUSHBY MUSTANG II-BG · S/N 329Cancelled Nov 12, 1980 · Batson James LN3850HEngineering & Research 415-D · S/N 4551Cancelled Apr 23, 1974 · Schaefer Kathleen GN51908Boeing A75N1 · S/N 75-395Cancelled May 20, 1965 · York Continental AirwaysN28930Forney 415-C · S/N 25Cancelled Aug 3, 1962 · Built 1946 · Price Harry EugeneN2310NCessna 120 · S/N 12550Cancelled Nov 14, 1961 · Griest Norman EN4937ACessna 180 · S/N 32334Cancelled Nov 8, 1960 · Exported to Canada · Sternbergh David D DBAN99442Ercoupe 415-C · S/N 2065Cancelled Feb 28, 1956 · Built 1946 · Valley AirwaysN474HStinson SM-2AC · S/N 1109Cancelled Oct 17, 1955 · Love UriahN99516Ercoupe 415-C · S/N 2139Cancelled Oct 13, 1955 · Built 1946 · D & S Agricultural Industries IncN72382Cessna 140 · S/N 9568Cancelled Apr 18, 1955 · Valley Airways IncN5313KRyan NAVION B · S/N NAV-4-2213BCancelled Feb 15, 1955 · S Morgan Smith CoN15WDehavilland DH104 DOVE 2A · S/N 04336Cancelled Nov 25, 1952 · Campbell Chain CoN8614ABeech D18S · S/N A-521Cancelled Nov 12, 1952 · Bowen TrumanN25821Piper J3L-65 · S/N 3771Cancelled Aug 4, 1950 · D&S Agricultural Industries IncN99952Erco 415-C · S/N 2575Cancelled Apr 27, 1950 · D & S Agricultural Industries IncN89340Cessna 140 · S/N 8368Cancelled Jun 2, 1949 · Sternbergh David DoddsN6591Waco GXE · S/N 1688Cancelled Mar 28, 1948 · Dusman G HN821EA V Roe AVRO AVIAN · S/N 259Cancelled Oct 2, 1935 · Golden Arrow Flying Club York Airport
Back to York, PA