OpenAirDocs.org
Burlington, WI

Cancelled registrations · 51

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

N7284QCessna 172L · S/N 17260584Cancelled Mar 28, 2025 · Exported to Canada · Built 1972 · Spring City Aviation IncN553PKTextron 560XL · S/N 560-6333Cancelled Jul 3, 2024 · Exported to Slovenia · Built 2022 · Meisner Aircraft IncN201CHBeech 200 · S/N BB-103Cancelled Mar 9, 2023 · Exported to Canada · Meisner Aircraft IncN4144BCirrus Design SR22 · S/N 0131Cancelled Aug 27, 2022 · Registration expired, pending cancellation · Built 2001 · Onstad Brian A TrusteeN40089Schwochert Douglas L SCHWOCHERT HELICYCLE · S/N 029Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Schwochert Douglas LN67PNAerotek PITTS S-2A · S/N 2219Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Hall Dennis DN11472Cessna 150L · S/N 15075445Cancelled May 23, 2020 · Sale reported, canceled · Built 1973N5246HPiper PA-16 · S/N 16-50Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1949 · Larkin Meghan EN87878Bombardier CL-600-2B16 · S/N 5709Cancelled Jun 26, 2018 · Exported to Canada · Built 2007 · Meisner Aircraft IncN610SFCessna 525A · S/N 525A-0015Cancelled Jun 11, 2018 · Exported to Germany · Built 2001 · Safe Flight LLCN9XAMetropolitan Sales POBER SPORT P-12 · S/N 12Cancelled Mar 16, 2018 · Revoked, canceled · Metropolitan Sales IncN31TMMathes Tom H GN-1 AIRCAMPER · S/N 932Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Luke Daniel JN3879ATL TL1 · S/N 001752Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Lesch Timothy FN565GGLearjet 35A · S/N 501Cancelled May 8, 2017 · Exported to Germany · Built 1983 · Meisner Aircraft IncN9019USchwochert Douglas L SCHWOCHERT A/W 95 · S/N 001Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 2000 · Schwochert Douglas LN300SCGates Learjet 35A · S/N 440Cancelled May 31, 2016 · Exported to Germany · Built 1981 · Mesiner Aircraft IncN620MJLearjet 35A · S/N 676Cancelled May 27, 2016 · Exported to Germany · Built 1993 · Meisner Aircraft IncN955NCGates Learjet 55 · S/N 087Cancelled Apr 11, 2016 · Exported to Germany · Built 1983 · Meisner Aircraft IncN6891SAero Commander 680 · S/N 680-417-92Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1956 · Mehlhaff Jerry K DBAN826JAAshworth James K ZENITH CH-200 · S/N 324Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Ashworth James KN96KTTridle Keith ACRO SPORT 1 · S/N 20110Cancelled Oct 7, 2014 · Built 1996 · Tridle Keith DN350EFGates Learjet 35A · S/N 385Cancelled Feb 19, 2014 · Exported to Germany · Built 1981 · Meisner Aircraft IncN683EFLearjet 35A · S/N 35A-614Cancelled Feb 19, 2014 · Exported to Germany · Built 1987 · Meisner Aircraft IncN60004Beech D18S · S/N A-293Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1946 · Burlington Airways IncN7097ZAerostar International RXS-8 · S/N RXS8-3050Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1994 · Trione John CN411MMIsrael Aircraft Industries ASTRA SPX · S/N 080Cancelled Nov 30, 2012 · Exported to Canada · Meisner Aircraft IncN90196Schwochert Douglas L SCHWOCHERT A/W 95 T · S/N 002Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 2000 · Schwochert Douglas LN57972Hiller UH-12E · S/N 1345Cancelled Jun 21, 2012 · Registration pending, canceled · Built 1962N73912Cessna 172N · S/N 17267743Cancelled Apr 6, 2010 · Exported to Philippines · Built 1976 · Rowley Stephen AN3799SCessna 172E · S/N 17250999Cancelled Mar 19, 2007 · Triennial form not returned · Built 1963 · D & S Aviation IncN703HCPiper PA-24-260 · S/N 244923Cancelled Sep 20, 2004 · Exported to Australia · Meisner Aircraft IncN352GFBeech 35 · S/N D-625Cancelled Nov 17, 2003 · Triennial form not returned · Built 1947 · Hughes William JN8833Meester HP-14 · S/N 75Cancelled Mar 25, 2002 · Built 1970 · Osbakken Patricia LN462FTPiper PA-28-161 · S/N 288216221Cancelled May 9, 1996 · Welch FernN99724Ercoupe 415-C · S/N 2347Cancelled Jun 27, 1994 · Triennial form not returned · Gadeikis John TN4274DBeech G35 · S/N D-4502Cancelled Apr 27, 1981 · Exported to Canada · Carbonite Metal Co IncN826JAAshworth CUBY SPORT TRAINER · S/N 349Cancelled Nov 25, 1980 · Ashworth James KN2905CPiper PA-28-161 · S/N 28-7916530Cancelled Nov 17, 1980 · Exported to Australia · Built 1979 · Fra Enterprises IncN2937LPiper PA-28-161 · S/N 28-7916558Cancelled Aug 7, 1980 · Exported to Australia · Fra Enterprises IncN1234GBeech E18S · S/N BA21Cancelled Feb 1, 1980 · Buhl Air Freight IncN33118Piper J3F-65 · S/N 5836Cancelled Feb 13, 1978 · Built 1940 · Soucy John EN9929ZBeech C-45H · S/N AF-868Cancelled Jul 25, 1977 · Burlington Airways IncN4536FPiper PA-32R-300 · S/N 32R-7680457Cancelled Mar 15, 1977 · Built 1976 · Centaur Forge LtdN386Beech E18S · S/N BA-95Cancelled May 20, 1976 · Burlington Airways IncN402FWBeech E18S · S/N BA-136Cancelled Dec 10, 1975 · Burlington Airways IncN921JLAeronca 7AC · S/N 7AC-5023Cancelled Nov 22, 1974 · Built 1946 · Bergquist Ronald LN6765TCessna 310D · S/N 39065Cancelled Jan 15, 1971 · Burlington Airways IncN3598FCessna 182J · S/N 18257598Cancelled Sep 1, 1970 · Erhard PreissN21685Piper J3C-65 · S/N 2571Cancelled May 19, 1965 · Bero Delmer ON8960KStinson 108-1 · S/N 108-1960Cancelled Nov 16, 1949 · Warren Philip H
Back to Burlington, WI