Skip to content

Cancelled registrations · 83

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 = 'SAINT PAUL' 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 = 'SAINT PAUL'
  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 = 'SAINT PAUL'
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.

N154ABCompton Edmond M RV-3A · S/N EC10868Cancelled Mar 1, 2025 · Sale reported, canceled · Built 1997 N876NTDJI INSPIRE 2 · S/N 09YDFAL0040904Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Minnesota Department Of Transportation N843ACAmerican Champion 8KCAB · S/N 843-99Cancelled Aug 9, 2022 · Registration expired, pending cancellation · Built 1999 · One Two Kilo Delta Corp N8121PPiper PA-24 · S/N 24-3374Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1963 · James Tedd B N7602YPiper PA-30 · S/N 30-672Cancelled Oct 18, 2021 · Sale reported, canceled · Built 1964 N3012VBeech 35 · S/N D-414Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1947 · Parker Ellen Rose N3037GHiller UH-12A · S/N 231Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1959 · Parker Ellen Rose N4209UCessna 150D · S/N 15060209Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1963 · Parker Ellen Rose N7195XCessna 150A · S/N 15059295Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1961 · Parker Ellen Rose N79167Cessna 172K · S/N 17257930Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1969 · Parker Ellen R N8897FHughes 269A · S/N 83-0274Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1963 · Parker Ellen R N169ZADJI MAVIC PRO · S/N 08QDE4M01200ZXCancelled Oct 31, 2020 · Registration expired, pending cancellation · Johnson Duane N769ZADJI PHANTOM 4 PRO · S/N 0AXCE5G0A30893Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Johnson Duane N746FW3D Robotics IRIS+ · S/N IRSM150840013Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Werden Leland K N505PMCanadair CL-600 CHALLENGER · S/N 1051Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1982 · Challenger Equity LLC N806APiper PA-22 · S/N 22-109Cancelled Apr 25, 2019 · Sale reported, canceled · Built 1951 N611QKDJI PHANTOM 3 PROFESSION · S/N P76DCE21043563Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Welsh Michael N N543QD3D Robotics IRIS · S/N 7666RAD0002Cancelled Jul 16, 2018 · Registration expired, pending cancellation · Ditmer Mark A N647TBeech J35 · S/N D-5608Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1958 N15HQMikoyan Gurevich MIG 15UTI · S/N 1A03506Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Minnesota Air Natl Guard Historical Foundation Inc N11037American Champion 7ECA · S/N 22Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1964 · Swan Craig E N7064NScrabeck Danny A WOODY PUSHER · S/N 01012003Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 2003 · Bailey Cristopher M N642RDMarlatt Roger L 333/2+2 · S/N ADV-97-233Cancelled May 15, 2015 · Registration expired, pending cancellation · Green Tree Financial Servicing Corp N986JCessna 320B · S/N 320B0020Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1963 · Conseco Finance Servicing Corp N646JWPZL Warszawa-Okecie PZL-104M WILGA 2000 · S/N 00010011Cancelled Nov 6, 2014 · Exported to Mexico · Built 2001 · Wakely Terrence J N133LLCessna 208B · S/N 208B2134Cancelled Dec 3, 2013 · Exported to Uganda · Built 2009 · Jc Aviation Services LLC N565KSBell 206B · S/N 56Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1967 · Elmo Air Center Inc DBA N954WSiai-Marchetti S.205/22R · S/N 4-154Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1968 · Devries Arthur C N517DCBeech 95-B55 (T42A) · S/N TC-1029Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1967 · Sullivan Aviation LLC N7XSWalters James A HORNET · S/N 003Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1996 · Carlson Julian A N57277Raven S55A · S/N S55A-789Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1981 · Wiederkehr Matt H N5650ECessna 150 · S/N 17150Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1959 · Halgren Russell R N79PFCessna 208B · S/N 208B2219Cancelled Nov 19, 2012 · Exported to Canada · Jc Aviation Services LLC N2185LBeech V35B · S/N D-9935Cancelled Aug 27, 2012 · Registration expired, pending cancellation · Built 1976 · Vspeed LLC N659MAviat A-1 · S/N 1271Cancelled Jul 13, 2012 · Exported to Canada · Built 1994 · Fox James R N702PCirrus Design SR22 · S/N 1179Cancelled Nov 5, 2010 · Exported to Canada · Built 2004 · H J Roadfeldt Co/Spesco Inc N94105Cessna 152 · S/N 15285598Cancelled Jun 17, 2010 · Exported to Argentina · Built 1982 · Michael Stephen J N35352Piper J3F-65 · S/N 6318Cancelled Nov 9, 2009 · Registration revoked · Built 1941 · Lanoux Donald W N8330Tozer BENSEN B7MC · S/N 1Cancelled Aug 18, 2009 · Triennial form not returned · Built 1973 · Patton George P N705GAGrumman American Avn. GA-7 · S/N GA7-0005Cancelled Jan 28, 2009 · Built 1978 · Cjd Aviation LLC N776SBSaab-Fairchild 340A · S/N 340A-021Cancelled Aug 28, 2008 · Exported to Bahamas · Built 1985 · Aircraft No 21 Company LLC N778SBSaab-Fairchild 340A · S/N 340A-023Cancelled Aug 28, 2008 · Exported to Bahamas · Aircraft No 23 Company LLC N924RWDouglas DC-9-31 · S/N 47185Cancelled Aug 28, 2008 · Triennial form not returned · Built 1968 · Northwest Airlines Inc N620NWMcdonnell Douglas DC-9-32 · S/N 47533Cancelled Jun 17, 2008 · Triennial form not returned · Built 1971 · Northwest Airlines N605NWMcdonnell Douglas DC-9-32 · S/N 47223Cancelled May 5, 2008 · Triennial form not returned · Built 1968 · Northwest Airlines Inc N922RWDouglas DC-9-31 · S/N 47182Cancelled Dec 1, 2007 · Triennial form not returned · Built 1968 · Northwest Airlines Inc.N848SPCessna 172S · S/N 172S8756Cancelled Jul 9, 2007 · Exported to Canada · Sullivan Aviation LLC N133JCDouglas DC-10-40 · S/N 46752Cancelled May 3, 2007 · Triennial form not returned · Built 1972 · Northwest Airlines Inc N24481Cessna 172R · S/N 17280973Cancelled Sep 20, 2006 · Exported to Australia · Wings Inc N306USAirbus Industrie A320-211 · S/N 060Cancelled Aug 3, 2006 · Triennial form not returned · Built 1989 · Northwest Airlines Inc

Back to Saint Paul, MN