Skip to content

Cancelled registrations · 25

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

N37918Zuczuski FCW-4 · S/N 41004Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1978 · Zuczuski Raymond F N648LPSix Chuter SKYE RYDER SR7 · S/N 98-1842-2Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1997 · Piacente Louis F N69VZVanzwoll Dean C VIKING · S/N 1Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1990 · Aubrey Leeann N27851Piper J4A · S/N 41072Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1940 · Plummer Frank H N3251MAubrey Robert William AUBREY SPECIAL · S/N 44Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Aubrey Robert William N525PZTextron 525C · S/N 525C0196Cancelled Mar 7, 2017 · Built 2015 · Zeliff Aviation LLC N525DPiper PA-23-250 · S/N 27-3355Cancelled May 19, 2015 · Registration expired, pending cancellation · Johnson Air Inc N6878DDehavilland VAMPIRE MK-3 · S/N 17072Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1947 · Wings Of Flight Inc N683VCurtiss Wright JR CW1 · S/N 1065Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1931 · Gooshaw Ralph N9087UMarquette Darrell VARIEZE · S/N 492Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1995 N25042Cessna 152 · S/N 15280513Cancelled Jun 10, 2005 · Exported to Poland · Built 1977 · Great Lakes Aviation Inc N912WDDominiak William P KITFOX VIXEN · S/N ICV018Cancelled Jan 24, 2002 · Built 1997 · Upson Hollis D N88222Hartrick/Tarkington AMERICAN EAGLET · S/N 377Cancelled Jun 30, 2000 · Tarkington Dean N2832Strong Mitchell S Q 200 · S/N 2835Cancelled Sep 30, 1997 · Triennial form not returned · Strong Mitchell S N3805Allen BALLOON #1 · S/N A-128Cancelled Aug 28, 1975 · Built 1974 · Allen Edward B N45758Luscombe 8A · S/N 2285Cancelled Jun 24, 1970 · Gerald E Claflin N7647HPiper PA-12 · S/N 12-526Cancelled Feb 18, 1970 · Exported to Canada · Taggert Elmer N23250Piper J4 · S/N 4-563Cancelled Dec 13, 1960 · Exported to Canada · Taggert Elmer N2771MPiper PA-12 · S/N 12-1150Cancelled May 25, 1960 · Built 1947 · Taggert Elmer N2259MPiper J3C-65 · S/N 21054Cancelled May 21, 1960 · Built 1946 · Batavia Aviation N9273HFairchild M-62A-3 · S/N FV-395Cancelled May 21, 1960 · Sands E N60253Boeing A75N1 · S/N 75-1644Cancelled Sep 23, 1955 · Exported to El Salvador · Harloff Leona M N51669Fairchild M-62A · S/N T41-1037Cancelled Jan 6, 1955 · Rase Jack F N2379VCessna 140 · S/N 14616Cancelled Jun 13, 1952 · Locke William Jr N16308Piper J-2 · S/N 541Cancelled Apr 28, 1948 · Taggert Elmer A Etal

Back to Batavia, NY