Skip to content

Eden Prairie, MN

Cancelled registrations · 78

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

N326SPEdra Aeronautica Ltda SUPER PETREL LS · S/N S0326Cancelled Sep 26, 2026 · Registration pending, canceled · Built 2014 N631TKCessna 152 · S/N 15284669Cancelled Oct 20, 2023 · Built 1980 · R & R Aero Services LLC N517GNQuicksilver GT500 · S/N 0421Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2008 · Notman Derek N H N712CGCessna 560XL · S/N 560-5182Cancelled Jun 15, 2022 · Exported to Canada · Built 2001 · Cardinal Glass Industries Inc N745PJNorth American T-28B · S/N 137745Cancelled Mar 28, 2022 · Exported to Canada · Built 1954 · Pj Aviation Holdings LLC Trustee N195GCCessna 208B · S/N 208B2036Cancelled Aug 16, 2021 · Exported to South Africa · Built 2008 · Investment Aircraft USA N519CGAgusta A109S · S/N 22119Cancelled Mar 10, 2021 · Exported to United Kingdom · Built 2009 · Cardinal Glass Industries Inc N278PHGulfstream Aerospace G-V · S/N 640Cancelled Jul 29, 2020 · Exported to Canada · Built 2001 · Pj Aviation Holding LLC Trustee N150WPDJI PHANTOM 3 PROFESSION · S/N P76DCH23010240Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Westwood Professional Services Inc N331HCDJI INSPIRE 1 · S/N W13DCF19040411Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Hendrix Consulting Group LLC N915FBDassault-Breguet FALCON 10 · S/N 77Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1976 · Global Express Group LLC N149BLDassault-Breguet FALCON 10 · S/N 149Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Global Express Group LLC N8928DPiper PA-22-160 · S/N 22-6086Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1958 · Shaw Kevin L N1105KLuscombe 8A · S/N 3832Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1946 · Shaw Kevin L N35TRAerotek PITTS SPECIAL S-1S · S/N 1-0030Cancelled Feb 5, 2018 · Exported to Italy · Render Thomas R N41WCBeech B90 · S/N LJ-430Cancelled Sep 14, 2017 · First renewal notice · Built 1969 · Beech Transporation Inc N759HKCessna 182Q · S/N 18266005Cancelled May 8, 2017 · Exported to Paraguay · Built 1977 · R&R Aero Services LLC N555DZDassault-Breguet FALCON 10 · S/N 186Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1981 · Global Express Group LLC DBA N299DPDassault-Breguet FALCON 10 · S/N 50Cancelled Oct 14, 2016 · First renewal notice · Built 1977 · Global Express Group LLC N7271KNational Ballooning 858 · S/N 116Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1984 · Overburn Balloons LLC N70040Thrush S2R-T34 · S/N T34-353Cancelled Jan 13, 2015 · Exported to Canada · Built 2011 · Asi Jet Sales LLC N580TRLet BLANIK L-13 · S/N 025904Cancelled Jan 9, 2015 · Third renewal notice · Built 1974 · Render Thomas R N320TRKarki Darshan S PITTS SPECIAL S1C · S/N DK109Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1997 · Render Thomas R N2265PNorth American F-51 · S/N 44-74430ACancelled Nov 25, 2014 · Registration expired, pending cancellation · Florey Loren L N1985XCessna 182H · S/N 18256085Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1965 N7435RPiper PA-28-140 · S/N 28-21970Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1966 · Minneapolis Area Vocational Technical Institute N705QTSchweitzer ED Q200 · S/N 2705Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Schweitzer Ed A N73258Bell 47J-2 · S/N 1868Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1962 · Lake Line Helicopters Inc N6971RBeech B19 · S/N MB-749Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1974 · G & R Aviation Inc N3259SSwanson Douglas A QUICKIE TWO · S/N 2554Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Qute Too Club N4516HPiper PA-15 · S/N 15-289Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1948 · Peterson Sever H N550RKKohl Rex L RAGWIND WOOD STORK · S/N 100550Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Kohl Rex L N4347WBeech B24R · S/N MC-276Cancelled Sep 5, 2012 · Registration pending, canceled · Built 1974 N7628CGrumman F7F-3 · S/N 80412Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1958 N178TPitts SPECIAL · S/N AM-2Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1968 · Magnuson Arden O N63RKHoffmann HK 36R SUPER DIMONA · S/N 36372Cancelled Apr 9, 2012 · First renewal notice · Built 1992 · Koair Corp N283DCDiamond Aircraft Ind DA20-C1 · S/N C0283Cancelled Nov 30, 2010 · Exported to Slovenia · Built 2004 · Modern Aero Inc DBA N2108QCessna 177RG · S/N 177RG0508Cancelled Mar 10, 2010 · Built 1974 · Rangers Flying Club Inc N9309SBeech B19 · S/N MB-766Cancelled Jul 28, 2009 · Triennial form not returned · Built 1975 · Mark Ward Aviation LLC N621PHCirrus Design SR22 · S/N 1481Cancelled Dec 12, 2008 · Triennial form not returned · Built 2005 · Fidelis Equity Group LLC N163PSDiamond Aircraft Ind DA20-C1 · S/N C0326Cancelled Apr 24, 2008 · Exported to Belgium · Built 2005 · Modern Aero Inc DBA N1230YCessna 208 · S/N 20800410Cancelled Feb 13, 2008 · Exported to Australia · Built 2007 · Modern Aero Inc DBA N206XTCessna T206H · S/N T20608063Cancelled Jun 29, 2007 · Exported to Canada · Built 1999 · Flying Gecko LLC N465DSDiamond Aircraft Ind DA 40 · S/N 40065Cancelled Jun 13, 2007 · Exported to Germany · Built 2001 · Modern Aero Inc DBA N214RSBeech B19 · S/N MB848Cancelled Oct 17, 2006 · Built 1977 · Mark Ward Aviation LLC N6418UMooney M20C · S/N 2165Cancelled Jul 24, 2006 · Exported to Canada · Built 1962 · Waterman Douglas J N5121FCessna 172F · S/N 17252818Cancelled Apr 18, 2005 · Triennial form not returned · Built 1965 · Blahnik Vance T N41BEBeech A100 · S/N B-245Cancelled Apr 5, 2004 · Triennial form not returned · Beech Transportation Inc N340GCessna A185F · S/N 18503866Cancelled Jul 15, 2003 · Exported to Canada · Built 1979 · David Aircraft Sales N18901Beech B19 · S/N MB-859Cancelled Apr 11, 2003 · Second triennial mailing, no response · Built 1977 · Flying Cloud Avn Eden Prari

Back to Eden Prairie, MN