Skip to content

Cancelled registrations · 38

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 = 'STILLWATER' 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 = 'STILLWATER'
  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 = 'STILLWATER'
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.

N6692VBellanca 17-30 · S/N 30045Cancelled May 13, 2023 · Sale reported, canceled · Built 1967 N63377Aerostar International RX 8 · S/N RX8-3116Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Harp Joshua R DBA N119JPPipistrel Lsa S R L ALPHA TRAINER · S/N 478 AT 912 LSACancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2012 · St Croix Lightplanes LLC N1491WDJI PHANTOM 3 PROFESSION · S/N P76DCI21A20248Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Washington County Sheriffs Office N3537VCessna 140 · S/N 14809Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1948 · Tschida Gregg M N3602ZAerostar International RX 8 · S/N RX8-3020Cancelled Feb 1, 2018 · Second renewal notice · Built 1989 · Aamodt'S Hot Air Balloon Rides Inc N1027JAero Commander 112 · S/N 128Cancelled May 14, 2014 · Exported to Bolivia · Built 1974 · Hoch Richard W N1606NFunk B85C · S/N 386Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1946 N55631Raven S55A · S/N S55A-557Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1979 · Apple Express Ltd N7516LCameron Balloons US A-250 · S/N 5814Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1992 · Cool Richard N6585CAerostar International S-66A · S/N S66A-3022Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Apple Express Ltd N752AACessna 152 · S/N 15279644Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1977 · Citation Aviation Inc N54703Raven S55A · S/N S55A-197Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1974 · Turrentine Howard R N5716PRaven S55A · S/N S55A-704Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1980 N6122PCameron Balloons US A-210 · S/N 5518Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1989 · Cool Richard N3300HEngineering & Research 415-C · S/N 3925Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1946 N233JFBeech 95-B55 (T42A) · S/N TC-862Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1965 · Gull Flyte N12PTBeech E18S · S/N BA-71Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1955 N666AFPiper PA-23-250 · S/N 27-3692Cancelled Dec 30, 2011 · Exported to Mexico · Built 1967 · N666 Inc N8522LRaven S55A · S/N S55A-220Cancelled Nov 15, 2011 · Second renewal notice · Built 1976 · Aamodts Hot Air Balloon Rides Inc N611DHHoffman Dennis BUSHBY MUSTANG M-1 · S/N 1726Cancelled Sep 23, 2011 · Exported to United Kingdom · Built 1998 · Hoffman Dennis P N920FACessna 172R · S/N 17280243Cancelled May 22, 2007 · Exported to India · Built 1997 · Tailwind Aviaton LLC N62997Cessna T-50 · S/N 5380Cancelled Jul 17, 2006 · Exported to Canada · Built 1943 · Anderson James J N12640Cessna 172M · S/N 17262135Cancelled Dec 20, 2002 · Built 1973 · Kirkman Mark A N73032Cessna 172M · S/N 17267243Cancelled Jun 15, 2001 · Triennial form not returned · Parcheta Daniel Lee N251SLLund James W AVID MK IV · S/N 1530D-L1Cancelled Jun 24, 1999 · Triennial form not returned · Lund James W N7224HBischoff Paul Steven TITAN TORNADO · S/N T95503COHK0133Cancelled Aug 19, 1998 · Bischoff Paul S N1997PCameron Balloons US N-105 · S/N 5332Cancelled Feb 18, 1997 · Triennial form not returned · Apple Express Ltd N90BFCessna 182B · S/N 52147Cancelled Apr 8, 1993 · Johnson Allan E N15837Piper PA-28R-200 · S/N 28R7335097Cancelled Oct 20, 1992 · Triennial form not returned · Tailwinds Flying Club Inc N96146Taylorcraft BC12D-85 · S/N 8446Cancelled Jul 22, 1983 · Administratively canceled · Jakubowski Stanley F N2678LCessna 172H · S/N 17255878Cancelled Jun 1, 1983 · Built 1967 · Johnson Stanley R N9509YBeech 35-B33 · S/N CD-545Cancelled Mar 22, 1974 · Dupre Norman J Jr N7300KPiper PA-20 · S/N 20-208Cancelled Sep 26, 1972 · Exported to Canada · Kuckler Courtney O N50693Cessna 150J · S/N 15069488Cancelled Dec 31, 1970 · Smith Jr Allan G Etal N3163MPiper PA-12 · S/N 12-1844Cancelled Aug 7, 1968 · Exported to Canada · Built 1947 · Myers Rex W N70001Fairchild M-62A · S/N 241Cancelled May 20, 1965 · Madsen Eigel H N23427Piper J3L-65 · S/N 3210Cancelled Oct 6, 1955 · Built 1939 · Nelson Jr Wm E

Back to Stillwater, MN