Skip to content

Bloomington, MN

Cancelled registrations · 48

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 = 'MN' AND d.registrant_city = 'BLOOMINGTON' 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 = 'MN' AND d.registrant_city = 'BLOOMINGTON'
  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 = 'MN' AND d.registrant_city = 'BLOOMINGTON'
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.

N232SHoyt Ron KOLB MARK III CLSC · S/N M1121Cancelled May 18, 2023 · Built 2002 · Hoyt Ron N3266QBeech A36 · S/N E-2966Cancelled Oct 3, 2022 · Built 1995 · Wagner Scott DBA N4015JPiper PA-28-181 · S/N 28-8090034Cancelled Sep 19, 2022 · Registration expired · Built 1966 · Metro Aircraft Co N3764Freiberger CASSUTT-III M · S/N RF-1Cancelled Feb 19, 2022 · Built 1975 · Heitzman Paul R N4901DDJI PHANTOM 2 VISION + · S/N PH645502874Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Feldmann Imports N2197KPiper PA-44-180 · S/N 44-7995206Cancelled Oct 29, 2019 · First renewal notice · Built 1978 · Metro Aircraft Co N2208VPiper PA-28-161 · S/N 28-7916327Cancelled Nov 5, 2018 · Built 1979 · Thunderbird Aircraft Co N9237DPiper PA-22 · S/N 22-6297Cancelled Mar 23, 2018 · Revoked, canceled · Built 1958 · Trebelhorn Roger E N327PMorse Gary L CHALLENGER II · S/N CH2-0399-1862Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1999 · Morse Gary L N4386GPiper PA-46-310P · S/N 46-8508037Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1985 · Jensen Stephen D N125DFKolb MARK II · S/N 1104766Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1994 · Parker Jeffrey G N2693NCessna 120 · S/N 12951Cancelled Jan 3, 2018 · Registration expired, pending cancellation · David Daniel B N1641HPiper PA-28R-201 · S/N 28R-7737006Cancelled Sep 1, 2016 · Built 1977 · Thunderbird Aircraft Co N294ASBoeing 727-290 · S/N 22146Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1980 · Grand Holdings Inc DBA N85324Aeronca 7AC · S/N 7AC-4063Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Ludwig Tim B N4611YYounggren Darell SONERAI II · S/N 01408Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1990 · Younggren Darell W N201HFMooney M20J · S/N 24-0152Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1977 · Sierra Bravo Corp N5705NRaven S55A · S/N S55A-633Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1979 · Southern Minnesota Balloon Club Inc N95126Taylorcraft BC12-D · S/N 9526Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Lee Richard D N78032Globe GC-1B · S/N 2032Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1946 · Skunberg Donald L N7544DPiper PA-22-150 · S/N 22-5275Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1957 · Nelson Mark E N53850Bellanca 8KCAB · S/N 223-76Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1975 · Decathlon 53850 Associates N25JDDebay James D DRAGONFLY MARK II · S/N 1Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Felling Mark E N6228UMooney M20C · S/N 2146Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1962 N7585QCessna 310Q · S/N 310Q0780Cancelled Feb 18, 2011 · Triennial form not returned · Built 1973 · Baldwin William H N744JCBombardier CL-600-2B16 · S/N 5744Cancelled Jan 14, 2009 · Exported to United Kingdom · Built 2008 · Jetcoast 6051 LLC N2548MPiper PA-28-161 · S/N 28-7816291Cancelled Oct 3, 2008 · Exported to South Africa · Built 1977 · Thunderbird Aircraft Co N682CABoeing 727-2S7 · S/N 22019Cancelled Sep 11, 2008 · Built 1980 · Grand Holdings Inc DBA N688CABoeing 727-2S7 · S/N 22344Cancelled Sep 3, 2008 · Triennial form not returned · Built 1980 · Grand Holdings Inc N215LYRans S-4 COYOTE I · S/N 00299Cancelled Mar 17, 2008 · Exported to Canada · Built 2007 · Barker James W N649JABombardier CL-600-2B16 · S/N 5649Cancelled Feb 5, 2007 · Exported to Aruba · Built 2006 · Jetcoast 60420 LLC N651JCBombardier CL-600-2B16 · S/N 5651Cancelled Jan 5, 2007 · Exported to Switzerland · Built 2006 · Jetcoast 60421 LLC N75986Cessna 172N · S/N 17268087Cancelled Nov 6, 2006 · Exported to Canada · Built 1976 · Story Paul A N604GDBombardier CL-600-2B16 · S/N 5624Cancelled Jun 15, 2006 · Exported to Denmark · Built 2005 · Jetcoast 60415 LLC N8680RSchweizer SGS 1-26A · S/N 202Cancelled Jan 20, 2005 · Triennial form not returned · Built 1963 · Hedberg Jeffrey L N853DCPiper PA-28R-201 · S/N 28R-7837043Cancelled Sep 15, 2004 · Thunderbird Aircraft Co N9381MMooney M20F · S/N 670005Cancelled Mar 20, 2003 · Second triennial mailing, no response · Built 1966 · Donegan Kevin S N98936Cessna 172P · S/N 17276382Cancelled Mar 7, 2003 · Exported to Canada · Built 1985 · Bulwicz Steven N4DUCessna P337H · S/N P3370311Cancelled Jan 21, 2003 · Exported to Canada · Guardian Eagle Co N5165MGray David M QUICKIE · S/N 460Cancelled Sep 8, 1998 · Triennial form not returned · Gray David M N2906ZPiper PA-22-160 · S/N 226877Cancelled Feb 11, 1994 · Triennial form not returned · Napier Christopher D N8289Folkestad SCORPION TOO · S/N 044S72Cancelled Oct 13, 1981 · Folkstad Harold O N5558PPiper PA-24 · S/N 24622Cancelled Jan 30, 1981 · Exported to Canada · Kloster Morris O N95066Piper PA-28-140 · S/N 28-25796Cancelled Aug 12, 1977 · Exported to Canada · Van Dusen Acceptance Corp N8548UCessna 172F · S/N 17252448Cancelled Sep 25, 1973 · Exported to Canada · Luedtke Dean L N3824VCessna 170 · S/N 18682Cancelled Jun 22, 1973 · Dickey Alfred E N23371Cessna 150H · S/N 15068910Cancelled Jul 17, 1972 · Exported to Canada · Parish M A N1822CCessna 170B · S/N 25966Cancelled Dec 11, 1970 · Exported to Canada · Built 1953 · Williams George R

Back to Bloomington, MN