Skip to content

Traverse City, MI

Cancelled registrations · 64

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 = 'MI' AND d.registrant_city = 'TRAVERSE CITY' 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 = 'MI' AND d.registrant_city = 'TRAVERSE CITY'
  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 = 'MI' AND d.registrant_city = 'TRAVERSE CITY'
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.

N371PHFairchild SA227-AC · S/N AC-576Cancelled Oct 15, 2026 · Exported to Canada · Gas/Wilson Inc N387PHSwearingen SA227-AC · S/N AC-531Cancelled Oct 15, 2026 · Exported to Canada · Built 1982 · Gas/Wilson Inc N697AXFairchild SA227-AC · S/N AC-697Cancelled Jan 22, 2025 · Built 1987 · Gas/Wilson Inc N680AXFairchild SA227-AC · S/N AC-680Cancelled Oct 16, 2024 · Exported to Canada · Built 1987 · Gas/Wilson Inc N114NWUav Factory PENGUIN B · S/N PNB0024Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Northwestern Michigan College N61LSRolladen-Schneider LS 4A · S/N 4338Cancelled Aug 13, 2020 · Exported to Argentina · Saxon Erik E N7585NDJI INSPIRE 1 PRO · S/N W21ACJ26011514Cancelled May 29, 2020 · Registration expired, pending cancellation · Phantom Aerial LLC N7587PDJI PHANTOM 1 · S/N AE081444172450Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Phantom Aerial LLC N132NW3D Robotics IRIS+ · S/N IRS1502200103Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Northwestern Michigan College N357BLDJI PHANTOM 3 PROFESSION · S/N P76DCH31A26637Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Bluelava Media LLC N589UQ3D Robotics X8 MULTI-COPTER · S/N R435535058Cancelled Sep 6, 2019 · Sale reported, canceled N709UNDJI SPREADINGWINGS S1000 · S/N 02Q0021604Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Thomas Pierce Ashton N725HNDJI INSPIRE 1 PRO · S/N W21ACL040200735Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Northern Michigan Drone LLC N725QWDJI INSPIRE 1 · S/N W13DCG10040747Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Rca LLC N663DP3D Robotics IRIS+ · S/N IRS1434600180Cancelled Jul 2, 2019 · Registration expired, pending cancellation · Thomas Pierce Ashton N644XADJI PHANTOM 2 · S/N 00100037767Cancelled May 6, 2019 · Registration expired, pending cancellation · Agl Analytics LLC N646FNDJI PHANTOM 3 PROFESSION · S/N P76DCF29016624Cancelled May 6, 2019 · Registration expired, pending cancellation · Northern Michigan Drone LLC N116NWAeryon Labs SKY RANGER · S/N SKR-000001-00 US9001076Cancelled May 4, 2019 · Registration expired, pending cancellation · Northwestern Michigan College N281GTDJI PHANTOM 2 VISION + · S/N PH645243939Cancelled May 4, 2019 · Registration expired, pending cancellation · Grand Traverse County Sheriff'S Office N122NWSensefly EBEE · S/N EB-03-14891Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Northwestern Michigan College N126NWSensefly EBEE AG · S/N EB-03-02569Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Northwestern Michigan College N118NWNorthwestern Michigan College MUGIN · S/N TS001Cancelled Mar 11, 2019 · Registration expired, pending cancellation · Northwestern Michigan College N2937FPiper PA-28-161 · S/N 28-7916557Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1979 · Up North Flight LLC N395PTDJI INSPIRE 1 · S/N W13DCD25030453Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Pierce Ashton Thomas N584BD3D Robotics IRIS+ · S/N IRS1500500039Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Dreer Robert B N577YGDJI PHANTOM 2 VISION PLU · S/N PH645419280Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Gourdie-Fraser N627BS3D Robotics X8+ · S/N R174982901Cancelled Oct 25, 2018 · Sale reported, canceled N40387Balloon Works FIREFLY 7 · S/N 7818Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1978 · Isles Robert A N44351Taylorcraft BC12-D1 · S/N 10151Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1946 · Grissom George M N5EZZook BJ-1B DUSTER · S/N 194Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1977 · Wielenga Phillip E N4459DBeech G35 · S/N D-4547Cancelled Oct 28, 2014 · First renewal notice · Built 1956 · Hepner Leo R N90221Balloon Works FIREFLY 9 · S/N F9-011Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Jeff Geiger DBA N74358Bellanca 14-13-2 · S/N 1471Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1947 · Paupore Robert N96158Cessna A185F · S/N 18503115Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1976 N3477UCessna 182F · S/N 18254877Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1963 N57998Bonomo B-8M · S/N 1Cancelled Aug 27, 2012 · Revoked, canceled · Built 1974 · Bonomo Ronald J N18366Leone Giovanni T PITTS S1 · S/N 60Cancelled Aug 21, 2012 · Registration pending, canceled N101JVVeld John C JR HI MAX · S/N 101Cancelled Aug 6, 2012 · Sale reported, canceled N2595QCessna 182K · S/N 18257795Cancelled Apr 13, 2011 · Expired dealer · Built 1966 · Double Tee Aviation N757LECessna 152 · S/N 15279818Cancelled Oct 17, 2007 · Triennial form not returned · Built 1977 · Northwestern Michigan College N98523Cessna 172P · S/N 17276305Cancelled Jun 26, 2007 · Exported to United Kingdom · Built 1985 · Northwestern Michigan College N115PKKauffman BEDE IV · S/N 115Cancelled Jun 12, 2006 · Triennial form not returned · Built 1985 · Kauffmam Paul Edwin N515KHMaster Donald C BD5B · S/N 474Cancelled Feb 18, 2004 · Wood Christopher N7106SBalloon Works FIREFLY 7 · S/N F7-389Cancelled Feb 19, 2003 · Built 1987 · Niebel Michael D N9085VBalloon Works FIREFLY 8 · S/N F8-375Cancelled May 9, 2001 · Triennial form not returned · Geiger Jeffrey Joseph N9TDBell 206B · S/N 2488Cancelled Oct 18, 2000 · Watchill LLC N8255NPiper PA-28-140 · S/N 28-25466Cancelled Oct 28, 1999 · Triennial form not returned · Cherry Capital Aviation Inc N50592Cessna 150J · S/N 15069420Cancelled Aug 24, 1999 · Triennial form not returned · Cherry Capital Flight Inc N4858VBeech C18S · S/N 7911Cancelled Apr 30, 1999 · Exported to Canada · Schmerheim Randall G N855RLLewis Robert I RFI RF-170 · S/N 2Cancelled Jan 25, 1999 · Lewis Robert F

Back to Traverse City, MI