Skip to content

Cancelled registrations · 142

Query with SQL

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 = 'ELMIRA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 = 'ELMIRA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N291MPDJI PHANTOM VISION 2+ · S/N PH645472708Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Elmira Police Dept N91856Schweizer SGS 1-21 · S/N 1Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1947 N1003Astro SISU 1A · S/N 107Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1964 · National Soaring Museum N6450NCessna 210F · S/N 21058801Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1966 · Chen Lu N4023YAvia Stroitel AC-4C · S/N 053Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 2000 · National Soaring Museum N23026Schweizer SGU 1-7 · S/N 2Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1939 · National Soaring Museum N34182Schweizer SGS 1-35 · S/N 32Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1975 · Welles David S N3900Johnson Scott E PITTS S1-C · S/N 333Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Johnson Scott E N36122Schweizer SGS 1-26E · S/N 700Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 1979 · National Soaring Museum Inc N74ZHNord 2000 · S/N 051Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1947 · National Soaring Museum N6BMBerkshire Mfg. CONCEPT 70 · S/N 6Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1972 · National Soaring Museum N451YFranklin Glider PS-2 · S/N 112Cancelled Oct 14, 2014 · Registration expired, pending cancellation · National Soaring Museum Inc N737BSPzl-Swidnik PW-5 · S/N 17.05.009Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1996 · National Soaring Museum N10VVSchweizer SGS 2-8 · S/N 2Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1939 N16923Sport-Flugzeugbau GOPPINGEN 3 MINIMOA · S/N 56Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1936 N4NDNelson BB-1 · S/N 504Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1946 N2767ZSchweizer SGS 2-32 · S/N 11Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1965 · National Soaring Museum Inc N8600RSchweizer SGS 2-32 · S/N 1Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1962 · National Soaring Museum N37671Snyder Wayne R MONERAI · S/N 197Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1981 · Snyder Wayne R N4718GCamacho HP-10 · S/N AC-1Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1964 N91899Schweizer SGS 1-23D · S/N 36Cancelled Mar 25, 2013 · Sale reported, canceled N91888Schweizer SGS 1-24 · S/N 1Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1953 N79TRoss-Johnson RJK · S/N RJK-5Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1950 N260EGlasflugel H 301 LIBELLE · S/N 51Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1966 · National Soaring Museum N68583Nelson PG-185-B · S/N 83Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1955 N61279Schweizer TG3A · S/N 43Cancelled Feb 11, 2013 · Sale reported, canceled N63PHall IBEX · S/N SAH-8Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1967 N5346GPratt Read PR-G1 · S/N 31561Cancelled Dec 18, 2012 · Sale reported, canceled · Built 1942 N491VSchleicher AS-W12 · S/N 12013Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1970 N3223AElmira Air Sports QUICKSILVER MX II · S/N 1017Cancelled Dec 7, 2012 · Sale reported, pending cancellation N4777GSchreder HP-11A · S/N 7Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1966 N3898ASchweizer 1-29 · S/N 1Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1958 N31635Champaign Public Schools GOEPPINGEN WOLF I · S/N CPS1Cancelled Sep 6, 2012 · Sale reported, canceled · Built 1945 N19CCleve EPB-1C · S/N 1Cancelled Aug 6, 2012 · Sale reported, canceled · Built 1963 N91833Schweizer SGU 2-22 · S/N 5Cancelled Aug 1, 2012 · Registration pending, canceled · Built 1946 N17900Schweizer SGS 1-35 · S/N 1Cancelled Jul 30, 2012 · Sale reported, canceled · Built 1973 N1658Shoemaker CHEROKEE II RM · S/N CS-1Cancelled Jul 19, 2012 · Sale reported, canceled · Built 1973 N91889Schweizer SGS 1-26 · S/N 1Cancelled Jun 4, 2012 · Registration pending, canceled · Built 1954 N12HLLuenger BETA 1 · S/N 1Cancelled Apr 14, 2011 · Sale reported, pending cancellation · Built 1972 N497MHSchempp-Hirth NIMBUS 4 · S/N 10Cancelled Jun 21, 2005 · Exported to Germany · Built 1998 · M & H Research And Development Inc N828DKSchweizer 269C-1 · S/N 0148Cancelled Aug 11, 2003 · Exported to United Kingdom · Schweizer Aircraft Corporation N330TTSchweizer 269D · S/N S1246TCancelled Aug 5, 2000 · Triennial form not returned · Schweizer Aircraft Corporation N2120VSchweizer 269D-UAV · S/N UAV-0001Cancelled Feb 22, 2000 · Schweizer Aircraft Corp N6150QSchweizer 269D · S/N 0025Cancelled Oct 9, 1998 · Exported to Panama · Schweizer Aircraft Corp N58STStachyra-Randy QUICKIE · S/N 58Cancelled Oct 16, 1996 · Triennial form not returned · Sutton Thomas C N61440Schweizer 269C-1 · S/N 0020Cancelled Apr 19, 1996 · Exported to Japan · Schweizer Aircraft Corp N61460Schweizer 269C-1 · S/N S1691Cancelled Apr 4, 1996 · Schweizer Aircraft Corp N50SZSchweizer SGP1-1 · S/N 1Cancelled Jul 27, 1995 · Triennial form not returned · Schweizer Aircraft Corporation N60638Schweizer 269C · S/N S1653Cancelled Apr 25, 1995 · Exported to Paraguay · Schweizer Aircraft Corp N7510USchweizer SA 2-37A · S/N 9Cancelled Jul 28, 1994 · Exported to Mexico · Schweizer Aircraft Corp

Back to Elmira, NY