OpenAirDocs.org
South Burlington, VT

Cancelled registrations · 27

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 = 'VT' AND d.registrant_city = 'SOUTH BURLINGTON'
  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.

N36DKEnstrom 280FX · S/N 2003Cancelled Oct 17, 2023 · Built 1985 · Beta Air LLCN802UTBeta Technologies AVA-XC · S/N B06-1Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2018 · Beta Air LLC DBAN280DMEnstrom Helicopter 280C · S/N 1192Cancelled Feb 21, 2020 · Sale reported, canceledN4950WRockwell International 114 · S/N 14272Cancelled Apr 1, 2019 · First renewal notice · Aerodyme CorpN925UMarcel J Franche LANCAIR-ES · S/N ES-052Cancelled Jul 13, 2018 · Built 1997 · Beta TechnologiesN192PFDehavilland DHC-8-301 · S/N 192Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Champlain Enterprises IncN83NDFpna A-22 VALOR · S/N 276Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 2009 · Carlaccini James AN213DMMikoyan Gurevich MIG 21 PF · S/N 1603Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Warplanes IncN292RVPiper PA-23-250 · S/N 27-3942Cancelled Jul 18, 2017 · Exported to Russia · Built 1968 · Vermont Flight AcademyN3093RRaven S55A · S/N S55A-465Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1979 · Super Toy Store LtdN909DMFouga CM 170 MAGISTER · S/N 273Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Warplanes IncN29HYYawney Harry W BOREDOM FIGHTER · S/N 029Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 2003 · Yawney Harry WN89434Cessna 152 · S/N 15282744Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1978 · Aviation Management Services IncN90506Aerostar International S53A · S/N S53A-3037Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1997 · Thrifty Car RentalN80927Kawasaki BK117A-4 · S/N 1023Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Mansfield Heliflight IncN704TGCessna 150M · S/N 15078856Cancelled Feb 24, 2012 · First renewal notice · Built 1976 · Aviation Management Services IncN9734YCessna T210N · S/N 21064583Cancelled Apr 18, 2011 · First renewal notice · Built 1981 · Moe Transportation IncN989TVCessna 550 · S/N 550-0285Cancelled Jul 13, 2005 · Exported to Canada · Citation Ventures LLCN2183XBell Helicopter Textron 206L-1 · S/N 45262Cancelled Nov 26, 1996 · Exported to Australia · Mansfield Heliflight IncN4208SRobinson Helicopter R22 BETA · S/N 1751Cancelled Mar 13, 1996 · Exported to New Zealand · Mansfield Heliflight IncN319DMFouga CM 170 MAGISTER · S/N 576Cancelled Nov 28, 1995 · Triennial form not returned · Warplanes IncN73CECessna P210N · S/N P21000369Cancelled Mar 3, 1994 · Yankee Sooner Charters IncN502DMDehavilland DH 112 SEA VENOM · S/N J1799Cancelled Nov 18, 1992 · Exported to New ZealandN63827Piper PA-23-250 (6PCLM) · S/N 27-7754145Cancelled Nov 4, 1980 · Exported to Canada · Reilly Tire CorpN6334FCessna 182P · S/N 18264163Cancelled Apr 2, 1980 · Exported to Canada · Brewster Thomas SN3551LCessna 150 · S/N 15062351Cancelled May 20, 1976 · Montair Flight Service IncN51CSBeech E18S · S/N BA211Cancelled Dec 14, 1971 · Air North Inc
Back to South Burlington, VT