OpenAirDocs.org
Gettysburg, PA

Cancelled registrations · 44

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

N668HABell 212 · S/N 31187Cancelled Oct 24, 2025 · Exported to Canada · Built 1981 · Helicopter Applicators IncN9238EAeronca 11AC · S/N 11AC-872Cancelled Apr 22, 2024 · Revoked, canceled · Built 1946 · Simons Robert CN6912QBeech A23-19 · S/N MB-276Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Wilhelm Michael JN139RDBell OH-58C · S/N 71-20396Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1971 · Helicopter Applicators IncN3647SCessna 172E · S/N 17250847Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Built 1963 · Trostle Walter MN1806BSolo Wings AQUILLA WINDLASS · S/N 3985592Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1998 · Brown Gary MN1834BSabre SABRE 503 · S/N M5171483Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Brown Gary MN595FLPiper PA-28-140 · S/N 28-7125462Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1971 · Omalley Charles LN2719TAirborne 2003 CLASSIC · S/N 582-662Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 2003 · Brown Gary MN48181Bell TH-13T · S/N 3813Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1967 · East Coast Helicopter IncN420MCBell 47G-4 · S/N 3366Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1965 · Helicopter Applicators IncN125CDBell 47G-3B-1 · S/N 3762Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1968 · Helicopter Applicators IncN7796CBell 47G-2A · S/N 1486-HS1Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1967 · East Coast Helicopter IncN672CPWhidden Criss QUICKIE 2 · S/N 04700Cancelled Oct 23, 2017 · Registration expired, pending cancellation · Built 1988 · Selmer Paul FN663HABell OH-58C · S/N 70-15417Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1971 · Helicopter Applicators IncN717WWQuad City Ultralight Acft CHALLENGER II · S/N CH2-1204-2559Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2006 · Wellborn Billy D JrN5775VBeech A23-19 · S/N MB-49Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1966 · Schulteis H AN555JCHughes Helicopters HUGHES 369D · S/N 180256DCancelled Feb 16, 2017 · Built 1977 · Haverfield International IncN8074HBeech C18S · S/N 42-56707Cancelled Feb 4, 2017 · Revoked, canceled · Johnson Walter JN652HABell 47G-2A · S/N 52Cancelled Jun 3, 2015 · Built 1947 · Helicopter Applicators IncN122CDBell 47G-2A-1 · S/N 3736Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1968 · Helicopter Applicators IncN369AWHughes Helicopters HUGHES 369D · S/N 470117DCancelled Mar 10, 2014 · Built 1977 · Haverfield International IncN98KRBell Helicopter Textron 206L-1 · S/N 45683Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1981 · Helicopter Applicators IncN62335Hiller UH-12E · S/N 1287Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1962 · Miller Ag Craft LtdN3483JCessna 150G · S/N 15066183Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1967N663HABell OH-58C · S/N 70-15159Cancelled Jun 21, 2011 · First renewal notice · Built 1971 · Helicopter Applicators IncN94WFBell 206B-III · S/N 2622Cancelled May 14, 2011 · Second renewal notice · Built 1979 · Helicopter Applicators IncN73257Bell 47G-2A · S/N 2723Cancelled Apr 13, 2011 · First renewal notice · Built 1962 · Helicopter Applicators IncN302MGBell 206B-III · S/N 2956Cancelled Mar 3, 2011 · First renewal notice · Built 1980 · Helicopter Applicators IncN64PDBell OH-58C · S/N 68-16948Cancelled Mar 2, 2011 · First renewal notice · Helicopter Applicators IncN522PDMcdonnell Douglas Helicopter 369E · S/N 0373ECancelled Nov 21, 2007 · Exported to Sweden · Built 1989 · Helicopter Applicators IncN2183PBell 206B · S/N 4335Cancelled Mar 20, 2003 · Exported to India · Built 1995 · Agrotors IncN52AGBell UH-1H · S/N 70-15746Cancelled Jan 22, 2001 · Triennial form not returned · Agrotors IncN847MCBell UH-1B · S/N 638694Cancelled Sep 9, 1998 · Exported to Chile · Agrotors IncN846MCBell UH-1B · S/N 603567Cancelled Mar 21, 1997 · Triennial form not returned · Agrotors IncN72501Bell 47G-2A · S/N 2661Cancelled Jul 5, 1994 · Triennial form not returned · Ag Rotors IncN67204Bell TH-13T · S/N 3662Cancelled Jun 4, 1992 · Triennial form not returned · Agrotors IncN840MCBell UH-1B · S/N 603619Cancelled Aug 22, 1991 · Triennial form not returned · Agrotors IncN8056WPiper PA-28-180 · S/N 28-2132Cancelled Jan 28, 1974 · Manahan Calvin D JrN9837EAeronca 11AC · S/N 11AC-1492Cancelled Oct 17, 1955 · Samuel S SmithN1931CCessna 170B · S/N 26076Cancelled Aug 11, 1955 · Gettysburg Motors IncN3787EAeronca 11AC · S/N 11AC-S-13Cancelled Jun 30, 1955 · Boulevard Airport IncN1990American Eagle 101 · S/N 68Cancelled Sep 3, 1940 · Built 1929 · Cunningham Arthur S Jr/Cunningham Joseph HN662VCurtiss Wright JR CW1 · S/N 1044Cancelled Apr 23, 1931 · Grove James F
Back to Gettysburg, PA