Skip to content

Cancelled registrations · 176

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 = 'WI' AND d.registrant_city = 'MADISON' 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 = 'WI' AND d.registrant_city = 'MADISON'
  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 = 'WI' AND d.registrant_city = 'MADISON'
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.

N37185Balloon Works FIREFLY 7 · S/N F7-268Cancelled May 6, 2013 · Registration expired, pending cancellation · Shockley Communications Corp DBA N59EDTodd-Ed T-SPECIAL · S/N 1Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Todd Edward T N39874Lancaster Homer L QUICKSILVER MX II · S/N 1305Cancelled Apr 1, 2013 · Sale reported, canceled N2324QBeech 23 · S/N M-388Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1963 N523RHHuntington Robert Howard GLASAIR SH-2 · S/N 257Cancelled Feb 25, 2013 · Sale reported, canceled N712HEMettel KINGFISHER EA-66 · S/N EHM-1Cancelled Feb 20, 2013 · Sale reported, canceled N47677Piper PA-28-181 · S/N 28-7890114Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1977 · Eaglestar Aviation Inc N40527Balloon Works FIREFLY 6B · S/N 10080Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1982 · Harris Dale D N35682Piper J5A · S/N 5-726Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1941 · Steele Thomas J N8018XMay Christopher H MITCHELL WING · S/N 209Cancelled Nov 7, 2012 · Sale reported, pending cancellation · Built 1980 N4463ERedmond Gordon E QUICKSILVER MX II · S/N 1460Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1983 · Koenig Robin A N62987Piper PA-31-325 · S/N 31-7712007Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1976 N5522VHall CHEROKEE II · S/N SAH-8Cancelled Aug 23, 2012 · Revoked, canceled · Built 1958 · Van Airsdale Clemens M N2489SCessna 337C · S/N 337-0789Cancelled Jan 23, 2012 · First renewal notice · Built 1967 · State Of Wisconsin/Doa N27TJJacobs Thomas COZY MK IV(MODIFIED) · S/N 688Cancelled Jul 28, 2011 · First renewal notice · Built 2008 · Jacobs Thomas B N1095ZHughes Helicopters HUGHES 369D · S/N 700755DCancelled Jul 19, 2011 · Sale reported, canceled N1395XHenley Frank COOT A · S/N 1FHCancelled May 17, 2011 · Exported to Canada · Steeves Richard A N14ZBeyersdorf EAA BIPLANE P-2 · S/N 1130-MBCancelled Apr 18, 2011 · Sale reported, pending cancellation · Built 1975 N95874Taylorcraft BC12-D · S/N 8174Cancelled Sep 18, 2009 · Registration revoked · Built 1946 · Higgins Frank E N24037Briegleb BG-12C · S/N 12062Cancelled Jul 14, 2009 · Registration revoked · Built 1967 · Bachowski Mark M N1228XMooney M20D · S/N 199Cancelled Jun 25, 2009 · Registration revoked · Built 1963 · November 1228 X Ray Inc N321MHHumphreys Matthew W CHALLENGER · S/N CHCW 0292-151Cancelled Sep 14, 2007 · Triennial form not returned · Built 1994 · Humphreys Matthew W N1009UMooney M20M · S/N 27-0003Cancelled Aug 14, 2007 · Exported to Belgium · Carlson Leasing Ltd N5360FPiper PA-28-181 · S/N 28-7790099Cancelled Mar 12, 2007 · Triennial form not returned · Built 1976 · Wisconsin Aviation Four Lakes Inc N7373PPiper PA-24 · S/N 24-2554Cancelled Jan 5, 2007 · Exported to Canada · Built 1961 · Caldararu Andrei H N105FSCessna 172R · S/N 17280797Cancelled Sep 27, 2005 · Triennial form not returned · Built 1999 · Wisconsin Aviation-Four Lakes Inc N3018MPiper PA-12 · S/N 12-1715Cancelled May 27, 2005 · Exported to Canada · Built 1947 · Woodford John E N4174YBellanca 8GCBC · S/N 240-77Cancelled Dec 23, 2003 · Exported to Canada · Built 1977 · State Of Wisconsin N81RHHetzler Ronald L EASY EAGLE · S/N 001Cancelled Sep 24, 2003 · Triennial form not returned · Built 2001 · Hetzler Ronald L N92PDRebholz Thomas RANS S10 · S/N 0290086Cancelled Apr 9, 2003 · Triennial form not returned · Built 1995 · Rebholz Thomas J N6950VMooney M20F · S/N 22-1323Cancelled Mar 28, 2003 · Registration pending · Built 1975 N2052XCameron Balloons U S CAN 90 · S/N 5411Cancelled Dec 2, 2002 · Second triennial mailing, no response · Built 1988 · Sky Aces Inc N1016RRaven Industries RX6 · S/N RX6-175Cancelled Apr 23, 2002 · Second triennial mailing, no response · Built 1975 · Fontaine Michael A N29233Cessna T210L · S/N 21059837Cancelled Jun 5, 2001 · Triennial form not returned · Jensen Norman M N7522LCameron Balloons U S CAN 90 · S/N 5821Cancelled Mar 6, 2001 · Triennial form not returned · Rayovac Corporation N93XCLord Bruce A KITFOX IV SPEEDSTER · S/N CCS111Cancelled Nov 30, 2000 · Triennial form not returned · Blyseth Robert S N1916THughes James Paul EASY EAGLE I · S/N 6256Cancelled Nov 3, 2000 · Hughes James P N9506RCameron Balloons US POLARBEAR 90 · S/N 2185Cancelled Oct 3, 2000 · Triennial form not returned · Central Storage And Warehouse Co N3015TCameron Balloons US SHOE 90 · S/N 3801Cancelled Dec 9, 1999 · Triennial form not returned · Sky Aces Inc N20CSShafer Richard SONERAI-I · S/N 329Cancelled Jun 21, 1999 · Kalishek Christopher James N1790Cassutt III M SPORT · S/N 1002Cancelled Dec 17, 1998 · Triennial form not returned · Rolfsmeyer John A DBA N36799Balloon Works FIREFLY 7 · S/N F7066Cancelled Jun 9, 1997 · Triennial form not returned · Fitzsimmons Christian S N4549SCameron Balloons US SHOE 90 · S/N 3138Cancelled May 15, 1997 · Triennial form not returned · Sky Aces Inc N4146ABeech A36 · S/N E204Cancelled Sep 6, 1996 · Triennial form not returned · Air Lec Industries Inc N2239BGehrmann Michael C FISHER FP 303 · S/N 3159Cancelled Feb 14, 1994 · Triennial form not returned · Gehrmann Michael C N3590ZPiper PA-31-350 · S/N 318052104Cancelled Aug 4, 1993 · Triennial form not returned · Wisconsin Dot Aeronautics N8MECessna 177RG · S/N 177RG0630Cancelled Nov 16, 1992 · Triennial form not returned · Armstrong Avn Inc N2461SCessna 337C · S/N 3370761Cancelled Aug 20, 1992 · Triennial form not returned · State Of Wisconsin N75912Cessna 172N · S/N 17268036Cancelled Jan 14, 1992 · Triennial form not returned · Howell Hugh B N54133Piper PA-23-250 · S/N 277405441Cancelled Nov 19, 1991 · Triennial form not returned · Mid West Management Inc

Back to Madison, WI