Skip to content

Cancelled registrations · 51

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 = 'UT' AND d.registrant_city = 'PARK 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 = 'UT' AND d.registrant_city = 'PARK 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 = 'UT' AND d.registrant_city = 'PARK 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.

N261MDMauro C Dal Canto AR-1 · S/N 0048Cancelled Jun 26, 2023 · Built 2020 · Dal Canto Mauro C N51RLJones Roy L PITTS S1C · S/N 01-1Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Pca Leasing LLC N5600DBeech E18S · S/N BA-296Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Pca Leasing LLC N5276GEmbraer Executive EMB-500 · S/N 50000389Cancelled Jun 27, 2022 · Exported to Australia · Built 2017 · Rsg Aviation LLC N2689KSilvaire LUSCOMBE 8A · S/N 5416Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Hopgood Mark R N89PKAero Commander 680-F · S/N 680F-1192-99Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1963 · Montel Inc N428USSchleicher ASW-20C · S/N 20628Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1983 · Reinecke Eugene J N22HQEmbraer EMB-500 · S/N 50000373Cancelled Jul 19, 2021 · Exported to Pakistan · Soljets LLC N39HQEmbraer EMB-500 · S/N 50000374Cancelled Jul 16, 2021 · Exported to Pakistan · Soljets LLC N5068NAerostar International S-52A · S/N S52A-3020Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1999 · Bauwens Michael G N43398Cameron Balloons THUNDER AX8-105 S2 · S/N 4342Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1998 · Dumkhum Tawin N123SBPiper PA-46-310P · S/N 46-8508023Cancelled Jan 8, 2020 · Second renewal notice · Built 1984 · Park City Aviation LLC N583XPDJI PHANTOM 2 VISION + · S/N PH646039148Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Park City Municipal Corp N108TJCessna 441 · S/N 4410108Cancelled Jun 20, 2018 · Exported to Pakistan · Built 1995 · Pca Leasing LLC N732YQCessna T210M · S/N 21061884Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1977 · Short John H N7117UAerostar International RX 8 · S/N RX8-3226Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1995 · Merino Mariel E N5021KPhillips-Michael WEEDHOPPER · S/N 0010Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Phillips Michael W N357TBBarrow Ted A TWO EASY · S/N 002Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Barrow Ted A N6698RMooney M20E · S/N 441Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1964 · Gasper Gary M N71646Aerostar International S81A · S/N S81A-3003Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1996 · Miles High Inc N52760Aerostar International S81A · S/N S81A-3009Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2000 · Ivers Miles M N8123JHowlett Steven R SNS-8 HIPERLIGHT · S/N SNS-8-142Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1989 · Rawlinson Myron E N78TNRaven S55A · S/N S55A-358Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1977 · Birch Frederick R N90241Aerostar International S-77A · S/N S77A-3019Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1992 · Hunter Jim DBA N664LSRobinson Helicopter R66 · S/N 0619Cancelled Jul 29, 2016 · Exported to Canada · Built 2015 · Den Enterprises LLC N2256JYakovlev YAK 52 · S/N 833709Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1983 · Yak Attack Squadron LLC N7096YAerostar International RX-9 · S/N RX9-3005Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1994 · Brundage Thomas A N2ZLSteorts Lee D MC-15 CRICKET · S/N 202Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1986 · Loeber A Wayne N7107KBalloon Works FIREFLY 8B · S/N F8B-108Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1987 · Logan Rogers P N421GACessna 421C · S/N 421C-0126Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Frisbie James H N5299UAerostar International S81A · S/N S81A-3013Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 2001 · Balloon Adventures Inc N21426Piper PA-44-180 · S/N 44-7995049Cancelled Nov 13, 2013 · Exported to Canada · Built 1978 · Csa Aircraft Leasing LLC N891VFMetz Lowell S CH 701 · S/N 4027Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Built 2003 · Vesely Tom N9096CAerostar International RXS-8 · S/N RXS8-3010Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1993 · Brundage Thomas Alan N7113CBalloon Works FIREFLY 8-24 · S/N F8-113Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1987 N4860LPiper PA-28-180 · S/N 28-4212Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1967 · Denoble Dennis M N9399VMooney M20F · S/N 700021Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1969 · Smart Douglas K N3037LCessna 310J · S/N 310J0037Cancelled Jul 15, 2013 · Registration pending, canceled · Built 1965 N9030SBalloon Works FIREFLY 9 · S/N F9-031Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1989 N37596Balloon Works FIREFLY 8-24 · S/N F8-032Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1984 · Moon Randall K N5123PAerostar International S53A · S/N S53A-3059Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1999 · Bauwens Michael G N7126XBalloon Works FIREFLY 9 · S/N F9-008Cancelled Feb 21, 2013 · Sale reported, canceled N9216Piper J3C-65 · S/N 16572Cancelled Jan 17, 2013 · Highway & Railroad Engineering Inc N200KLBeech 95-A55 · S/N TC-460Cancelled Sep 17, 2012 · Registration pending, canceled · Built 1963 N1540TBalloon Works FIREFLY 7 · S/N 10218Cancelled Jun 27, 2012 · Sale reported, canceled · Built 1980 N210JCessna P210R · S/N P21000865Cancelled Nov 21, 2011 · Exported to Australia · Built 1985 · Brown David P N761TDCessna T210M · S/N 21062497Cancelled Dec 5, 2005 · Exported to Mexico · Built 1978 · Jj Arrow LLC N72CMMassey Calvin L CHRISTEN EAGLE II · S/N MASSEY-0001Cancelled May 13, 2003 · Triennial form not returned · Massey Calvin L Jr N111KHBounsal David SUPER PROSPECTOR · S/N BSP-29N-279Cancelled Aug 9, 2000 · Exported to Canada · Hugus V Kent N5437ZPiper PA-22-108 · S/N 229212Cancelled Jun 4, 1997 · Rawlinson Myron E

Back to Park City, UT