Skip to content

Cancelled registrations · 119

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

N85970Aeronca 11AC · S/N 11AC-393Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1946 · Oconnor Michael D N13794Mccourtie A J H.B.-1 · S/N 001Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1982 · Mccourtie Wilfred J N4991VCessna 172 · S/N 28869Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Solo John M N7079BAerostar International RAVEN S57-A · S/N S57A-3159Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1994 · Crownover Realty LLC N48560Cessna 152 · S/N 15280917Cancelled Oct 22, 2020 · Built 1977 · Ag-Dg LLC N1602KLuscombe 8A · S/N 4329Cancelled May 15, 2020 · Revoked, canceled · Built 1946 · Dreano Robert N46772Fairchild M-62A · S/N T423081Cancelled Feb 28, 2020 · Revoked, canceled · Built 1942 · Jennings Frederick T N575HCDJI Innovations S1000 PREMIUM · S/N 0024419Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Consumers Energy Co N98034Piper J3C-65 · S/N 18181Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Ratliff Max N N11788Cessna 150L · S/N 15075632Cancelled Aug 29, 2019 · Sale reported, canceled · Built 1974 N678TBeech F50 · S/N FH-71Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Whitney Michael J N31798Hispano Aviacion HA-200 SAETA · S/N 20/80Cancelled Jul 10, 2018 · Second renewal notice · Built 1967 · Jackson College N18281Bowlus BA-100 · S/N 113Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1939 · Feather Joe I N7915QCessna 401B · S/N 401B0015Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1969 · Mueller Wolfgang N4461KSouthwell Scott V TERATORN TIERRA · S/N S1952Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Hall Gary R N4351WBeech B19 · S/N MB-705Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1974 · Nessing Leopold N N995CStinson 108 · S/N 1083995Cancelled Nov 21, 2017 · Revoked, canceled · Built 1947 · Dreano Robert N51260Fairchild M-62A · S/N T421974Cancelled Nov 18, 2017 · Revoked, canceled · Built 1942 · Brown Harold J N2994SCameron Balloons US V-77 · S/N 5234Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1986 · Adams David N N9545UCameron Balloons US V-77 · S/N 5590Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1990 · Fall Darrin R N41418Cameron Balloons US O-84 · S/N 5723Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1991 · Sherwood Vaughn R N32679Piper PA-28-180 · S/N 28-7505082Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1974 · Jkj Aviation LLC N6126HPiper J3C-65 · S/N 19287Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Brandenburg Eugene N7980CNorth American SNJ-5 · S/N 43938Cancelled Oct 19, 2016 · Built 1943 · Feldvary John K N162KAero Commander 560-F · S/N 960-2Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1961 · Rumler James J N54587Laister-Kauffman LK-10A · S/N 113Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1943 · Feather Joe I N33827Aeronca 65-TC · S/N 9519TCancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · Beebe Michael W N9546ZCameron Balloons US V-77 · S/N 5591Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1990 · Scott Jody K N7401KCameron Balloons US V-77 · S/N 5124Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1985 · Seekell David L Jr N5142Schleicher KA 6 E · S/N 4167Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1968 · Feather Joe I N123YXStorey Nihl C WAIEX · S/N W0123Cancelled Aug 1, 2013 · First renewal notice · Built 2010 · Storey Nihl C N7563UCessna 150M · S/N 15077739Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1975 · Secker Phillip A Jr N1985FHead Balloons AX8-88 · S/N 112Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1985 N7420TCessna 172A · S/N 47020Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1959 N5920XBrantly B-2 · S/N 56Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1960 N4357APiper PA-22 · S/N 22-3713Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1956 N133DGDegraw Richard R 130 · S/N RDX106Cancelled Oct 29, 2012 · Built 2002 · Degraw Richard R Trustee N1554DCessna 190 · S/N 7776Cancelled Oct 3, 2012 · Revoked, canceled · Built 1952 · Gentry H L N34046Cessna 177B · S/N 17701613Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1971 · Keillor Harlan K N2861LCessna 172H · S/N 17256061Cancelled Aug 30, 2012 · Sale reported, canceled · Built 1967 N24772Cessna 172R · S/N 17281085Cancelled Aug 28, 2012 · Exported to Canada · Built 2001 · Jackson Community College N52909Cessna T-50 · S/N 3553Cancelled Aug 14, 2012 · Revoked, canceled · Built 1943 · Myers Irvin W N1816SCameron Balloons O-65 · S/N 474Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1979 · Sherwood Vaughn R Jr N170HPitts S-1C · S/N AC-1Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1967 · Halstead Daniel L N1505KBalloon Works FIREFLY 7 · S/N 11159Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1982 · Midwest Professional Supply N130RDDelebaugh P · S/N 100Cancelled Oct 1, 2009 · Registration revoked · Built 1958 · Chase Ralph P N948SBPiper PA-30 · S/N 30-1817Cancelled Jan 6, 2009 · Triennial form not returned · Built 1969 · Advantage Aviation Services LLC N208BYDix Richard E ACRO SPORT II · S/N RED243Cancelled Oct 19, 2007 · Triennial form not returned · Built 2005 · Dix Richard E N970SSStorey Nihl C STOREY SEAREY · S/N 1DK254CCancelled Jun 27, 2007 · Built 2006 · Storey Nihl C N615MCAero Commander 560-F · S/N 560F-1157-40Cancelled May 3, 2007 · Triennial form not returned · Built 1962 · Rulewicz Dennis G

Back to Jackson, MI