OpenAirDocs.org
Jamestown, NY

Cancelled registrations · 37

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 = 'NY' AND d.registrant_city = 'JAMESTOWN'
  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.

N2000KLuscombe 8A · S/N 4727Cancelled Jun 4, 2022 · Expired dealer · Luscombe Aircraft CorpN71742Luscombe 8A · S/N 3169Cancelled Jun 4, 2022 · Expired dealer · Built 1946 · Luscombe Aircraft CorpN791GAGrumman American Avn. GA-7 · S/N GA7-0080Cancelled Apr 23, 2021 · Cougar Air Jv LLCN739CUniversal Stinson 108-3 · S/N 108-3739Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Dallas Murray AN71206Cessna 182M · S/N 18259532Cancelled Dec 2, 2014 · Revoked, canceled · Built 1969 · Chautauqua Flight IncN76274Cessna 120 · S/N 10682Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1946 · Miller Steven TN8123DPiper PA-22-160 · S/N 22-5614Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1957 · Rossell Jonathon DN77TAPiper PA-23-235 · S/N 27-549Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1963 · Air Parts And Salvage IncN41367Raven Industries RALLY RX7 · S/N RX7-345Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1984N90803Hiller UH-12B · S/N 482Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1952 · Kosinski Thomas JN135SMMiller Steven T PIETENPOL · S/N 1350Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Built 1986 · Miller Steven TN262PTCessna 182Q · S/N 18267005Cancelled Jan 4, 2012 · Exported to Russia · Built 1979 · Whitney Robert WN883HCessna 172E · S/N 17251129Cancelled Mar 29, 2011 · Expired dealer · Built 1964 · Citco Enterprises IncN295DSchempp-Hirth K G VENTUS A · S/N 143Cancelled Feb 4, 2010 · Exported to Brazil · Built 1983 · Christner Kevin JN193PKKeverline Paul O REVOLUTION-MINI 500 · S/N 0193Cancelled Jun 1, 2005 · Built 1998 · Lucile M Wright Air MuseumN3117VFairchild SA227-AC · S/N AC604Cancelled Jun 12, 1995 · Exported to Canada · Chautauqua Airlines IncN714BQCessna 150M · S/N 15079053Cancelled Dec 21, 1984 · Cva Aviation LtdN641MACessna 150E · S/N 15061291Cancelled Aug 30, 1983 · Johnson Harry SN2360QBeech 23 · S/N M-437Cancelled Jul 23, 1974 · J H W Aerospace CorpN3449ZPiper PA-22-160 · S/N 22-7368Cancelled Aug 11, 1972 · Exported to Canada · Vanstrom DonaldN89659Cessna 140 · S/N 8707Cancelled Jul 16, 1971 · Chautauqua Flight IncN99ZHeath Parasol SUPER PARASOL · S/N 101Cancelled Mar 1, 1971 · Falejczyk Francis JohnN9022ACessna 170A · S/N 18777Cancelled Sep 25, 1970 · Jamestown Aviation CoN1630GChampion 7ECA · S/N 635Cancelled Sep 18, 1970 · Proudman Lee JN3527PPiper PA-22-150 · S/N 22-3282Cancelled Apr 6, 1970 · Exported to Canada · Chautauqua Flight IncN4153MPiper PA-12 · S/N 12-3052Cancelled Jul 17, 1961 · Exported to Germany · Built 1947 · Sandquist Richard AN2105MPiper J3C-65 · S/N 20887Cancelled Jun 20, 1955 · Exported to Canada · Jamestown Aviation CoN19802Taylorcraft A · S/N 309Cancelled Oct 26, 1953 · Built 1937 · Savage Frederic JN6085MStinson 108-3 · S/N 108-4085Cancelled Jul 25, 1949 · Built 1947 · Jamestown Aviation CompanyN20811Piper J-3 · S/N 2111Cancelled Aug 24, 1948 · Girts Harold MN26300Aeronca 60-TF · S/N F-1010TCancelled Jul 9, 1948 · Built 1940 · Wright'S Motion Pictures IncN19533Taylor J-2 · S/N 1733Cancelled May 21, 1939 · Built 1937 · Jamestown Airways IncN1162Waco GXE · S/N 787Cancelled Dec 1, 1936 · Newton A EN3110Curtiss JN-4 (CANADIAN) · S/N 1005Cancelled May 7, 1930 · Seaburg Louis WN5513International F-17 · S/N 39Cancelled Jan 2, 1930 · Great Lakes Airways IncN2563Standard J-1 · S/N 500Cancelled Aug 20, 1929 · Young Clarence MN2164Swallow Airplane Mfg SWALLOW LAND PLANE · S/N UNKNOWNCancelled Sep 15, 1927 · Built 1923 · Jamestown Flying Service
Back to Jamestown, NY