OpenAirDocs.org
Burlington, VT

Cancelled registrations · 61

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

N199VTBeech A200CT(C-12D) · S/N BP-037Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Burlington Tech - Burlington SchoolN383BTDJI PHANTOM 3 ADVANCED · S/N 03Z0089844Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Wires Jordan DN356TEVickers/Supermarine SPITFIRE MARK XVI · S/N TE356Cancelled Nov 12, 2019 · Exported to United Kingdom · P40s LLCN75296Curtiss Wright C-46A · S/N 32699Cancelled Jul 19, 2018 · Revoked, canceled · Built 1944 · Webair IncN98044Piper PA-28-140 · S/N 28-26007Cancelled Jun 11, 2018 · Exported to Canada · Built 1969 · Winrock David JN12MSCessna 310I · S/N 310I0126Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1964 · Ace Aviation LLCN8683Bell H-13E · S/N 51-14114Cancelled Feb 14, 2017 · Revoked, canceled · Built 1951 · Burlington Public School SystemN788RTExtra Flugzeugbau EA 300/L · S/N 158Cancelled Mar 28, 2014 · Exported to Chile · Loopty Loop Corp LLCN5234MBeech C23 · S/N M-2015Cancelled May 10, 2013 · Sale reported, canceled · Built 1978N9223SBeech C23 · S/N M-1719Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1975N811PCessna 172L · S/N 17260298Cancelled Apr 18, 2012 · Built 1971 · Champlain Island Hoppers IncN5560ZPiper PA-22-108 · S/N 22-9357Cancelled Oct 26, 2007 · Exported to Canada · Built 1962 · Hyde JackN760AQGates Learjet 55 · S/N 017Cancelled Jun 14, 1994 · Exported to Germany · Bombardier Capital IncN407MRGates Learjet 35A · S/N 407Cancelled May 6, 1994 · Exported to Canada · Bombardier Capital IncN801AWDehavilland DHC-8-102 · S/N 067Cancelled Nov 2, 1993 · Exported to Australia · Bombardier Capital IncN4199TRaven S55A · S/N S55A963Cancelled Aug 18, 1992 · Triennial form not returned · Merchants BankN31JDLake LA-4-200 · S/N 1097Cancelled Mar 15, 1991 · Exported to Canada · Super Toy StoreN8227MCessna T210K · S/N 21059227Cancelled Aug 20, 1984 · Administratively canceled · Cardinal Flight ServiceN54071Piper PA-23-250 (6PCLM) · S/N 27-7405381Cancelled Jun 12, 1979 · Exported to Canada · Ana Limited DBA Northern AirwaysN60006Aeronca 0-58B · S/N 12303Cancelled Nov 9, 1976 · Exported to Canada · Vogel Robert WN45295Cessna 150M · S/N 15076829Cancelled Apr 23, 1976 · Exported to Canada · Built 1975 · Montair Flight Service IncN6154FCessna A150L · S/N A1500431Cancelled Jul 3, 1975 · Montair Flight Service IncN2011VCessna 140 · S/N 14366Cancelled Jul 16, 1973 · Exported to Canada · Built 1950 · Cleland WilliamN3124TCessna 177 · S/N 17700424Cancelled Jul 6, 1972 · Exported to Canada · Champlain Marine Co IncN25NAPiper PA-28-140 · S/N 28-26905Cancelled May 26, 1972 · Exported to Canada · Northern Airways/Division Of S T Groswold & Co IncN28NAPiper PA-28-140 · S/N 28-26209Cancelled May 26, 1972 · Exported to Canada · Northern Airways A Division Of S T Griswold & CoN9786KUniversal Stinson 108-2 · S/N 108-2786Cancelled Jun 16, 1971 · Exported to Canada · Vermont Mach Busters Assn IncN24NAPiper PA-28-140 · S/N 28-24305Cancelled Apr 27, 1971 · Exported to Canada · Built 1968 · Northern Airways IncN1126LLake LA-4 · S/N 288Cancelled Mar 4, 1971 · Heisse John W JrN7289YPiper PA-30 · S/N 30-327Cancelled Jan 4, 1971 · Executive Investments CorporationN1233VFairchild M-62A-3 · S/N FT-765Cancelled Nov 30, 1970 · Mccarvelle Edward JamesN6242FCessna 337A · S/N 337-0242Cancelled Sep 16, 1970 · University Of VermontN2512DCessna 170B · S/N 20664Cancelled Jul 15, 1970 · Exported to Canada · Built 1952 · Beaudoin Wilfred JN73020Cessna 140 · S/N 10225Cancelled Jul 6, 1967 · Exported to Canada · Federal Airlines IncN6153KRepublic RC-3 · S/N 341Cancelled Oct 5, 1965 · Clark JocelynN83714Aeronca 7AC · S/N 7AC-2392Cancelled Jul 31, 1964 · Vermont Aviation IncN72764Cessna 140 · S/N 9947Cancelled Nov 23, 1955 · Mack Michael JN2511DCessna 170B · S/N 20663Cancelled Aug 4, 1953 · N Duchaine IncN1326VFleet 16B · S/N 547Cancelled May 7, 1951 · University Of Vermont Flying ClubN9096HCessna T-50 · S/N 1125Cancelled Dec 8, 1949 · Built 1941 · Richards S AN1239VCurtiss Wright C-46A · S/N 251Cancelled Oct 24, 1949 · Exported to Venezuela · Richards S AN1240VCurtiss Wright C-46A · S/N 252Cancelled Jul 7, 1949 · Exported to Venezuela · Richards S AN89464Cessna 140 · S/N 8496Cancelled Apr 14, 1949 · Hufnail Daniel BN6710Waco GXE · S/N 1487Cancelled Apr 1, 1948 · Built 1929 · Waterman Stephen JrN1230VLockheed R50-6 · S/N 18-2522Cancelled Mar 19, 1948 · Richards S AN9095HLockheed 18-56 · S/N 2320Cancelled Jan 15, 1948 · Richards S AN14157Stinson SR-5A · S/N 9267-ACancelled Sep 6, 1946 · Built 1934 · Macleon Edward RN960HStar CAVALIER · S/N 111Cancelled Jul 15, 1941 · Pugh Harold WN13417Waco UIC · S/N 3772Cancelled Sep 1, 1940 · Built 1933 · Gillette Morgan & E LloydN931WStinson SM-8A · S/N M-4200Cancelled Aug 15, 1938 · Built 1930 · Pugh Harold W
Back to Burlington, VT