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

N8582DDJI PHANTOM 4 PRO · S/N OAXDDCLOB30093Cancelled Jun 1, 2024 · Sale reported, canceled N754XZDJI INSPIRE 1 · S/N W13DCF19040445Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Z2 Marketing Ltd N3643KPiper J3C-65 · S/N 22334Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1946 · Cryer Samuel K N587MCMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7086Cancelled Dec 4, 2020 · Exported to Canada · Milwaukee Regional Medical Center Inc N201CFMooney M20J · S/N 24-0032Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1976 · Kieffer John N7504JLindstrand Balloons 90A · S/N 5248Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Winddancer Balloon Promotions LLC N5526HCessna 152 · S/N 15284115Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1979 · Heberer Jon D N900GSPiper PA-34-200T · S/N 34-7870232Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1978 · Spring City Aviation Inc N69773Taylorcraft BC12-65 · S/N 2621Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Gygax Lawrence S N330LBLindstrand Balloons 105A · S/N 5069Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1998 · Walter Kenneth S Jr N794TBeech F35 · S/N D-4280Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1955 · Hoffman Robert A N701WTLarson G/Larson A STOL CH 701 · S/N 74548Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2003 · Larson Arvin L N3563B.K.W. Farms SCORPION HELICOPTER · S/N C5A-747Cancelled Nov 18, 2017 · Revoked, canceled · Kurth Bernard H N7116UMooney M20E · S/N 358Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1964 · Rinka Jeffrey N N8295XPiper PA-28-161 · S/N 28-8116083Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1980 · Rtje Bach Enterprises LLC N6536KRepublic RC-3 · S/N 802Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Firnhaber Miles N408DMPiper PA-32R-301 · S/N 32R-8113012Cancelled Jun 15, 2015 · Registration expired · Built 1981 · Rfg LLC N3009TLindstrand Balloons 77A · S/N 5074Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1998 · Van Wyngeeren Rodney F N7969UCessna 172F · S/N 17251969Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1964 · Schuning Richard E N7EJGates Lear Jet 24E · S/N 343Cancelled May 11, 2015 · Sale reported, canceled · Built 1976 N231EP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 17.82.0688Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1984 · Ritchey David L N6580PPiper PA-24 · S/N 24-1702Cancelled Nov 7, 2013 · Second renewal notice · Built 1960 · Sixty Six Whiskey Corp N2352QBeech 23 · S/N M-420Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1963 · Bethke Paul N303YYasecko Joseph S LONG-EZE · S/N 1206Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1983 · Krueger Joseph R N80167Cessna 172M · S/N 17266415Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1975 · Bruckner Brian N385PBeech A36 · S/N E-1788Cancelled Aug 13, 2013 · Exported to Canada · Built 1981 · Gorilla Air LLC N7098ACessna 172 · S/N 29198Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1956 · Nen Allen L N259WPPerrigo William R SR QUICKIE Q-2 · S/N 2596Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1987 · Perrigraphics Inc N2744RKolb FIRESTAR II · S/N K0212Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1994 · Corso Thomas N4435ARobinson Helicopter R44 II · S/N 12614Cancelled Dec 16, 2011 · Exported to Turkey · Built 2009 · Helipix Corporation N50298Cessna 150H · S/N 15069207Cancelled Oct 21, 2011 · Exported to Brazil · Spring City Aviation Inc N74012Cameron Balloons N-77 · S/N 5106Cancelled Jun 16, 2011 · Triennial form not returned · Walter Kenneth S Jr N133BHPiper PA-23-250 · S/N 27-3198Cancelled Jan 26, 2007 · Triennial form not returned · Built 1966 · Spring City Aviation Inc N800GDLockheed 1329 731 JETSTAR · S/N 5100Cancelled May 5, 2006 · Triennial form not returned · Built 1967 · Call Plane Solutions Inc N955PACessna 208B · S/N 208B0687Cancelled Aug 17, 2000 · Exported to South Africa · Cleo Wisconsin Inc N35ALLarson Arvin SONERAI-II · S/N 53Cancelled Aug 4, 1997 · Triennial form not returned · Larson Arvin L N3949DCessna 182A · S/N 34649Cancelled Apr 25, 1997 · Triennial form not returned · Gross Vernon L N5308NCessna 182Q · S/N 18267637Cancelled May 11, 1995 · Exported to Germany · Waukesha Flying Services Inc N5281KCessna 172P · S/N 17274041Cancelled Feb 24, 1995 · Exported to Germany · Waukesha Flying Services Inc N72EZSchuning Richard E VARI E Z · S/N 910Cancelled Jul 7, 1994 · Schuning Richard E N55356Cessna 172P · S/N 17275167Cancelled Dec 8, 1992 · Exported to Turkey · Hoefgen Leo F N9578VCessna 172M · S/N 17264380Cancelled Mar 27, 1991 · Triennial form not returned · Meeusen Richard A N9690YBeech P35 · S/N D-7109Cancelled Oct 16, 1981 · Greenwaldt Robert W N7631JPiper PA-28R-180 · S/N 28R31026Cancelled Oct 15, 1981 · Holzgrafe Robert E Md & Kohler Elaine Md N7000NBeech V35 · S/N D-8191Cancelled Nov 19, 1980 · Spring City Flying Service Inc N3416VCessna 150M · S/N 15076494Cancelled Nov 14, 1979 · Whitman Aviation Inc N3911YCessna 210D · S/N 21058411Cancelled Nov 11, 1976 · Schetter Richard N7604KPiper PA-20 · S/N 20-419Cancelled Sep 17, 1976 · Hill Carl E N55531Piper PA-28-180 · S/N 287305408Cancelled Jul 22, 1974 · Spring City Flying Service Inc N6472ACessna 182 · S/N 33272Cancelled Jun 26, 1973 · Wisconsin Sky Divers Parachute Club Inc

Back to Waukesha, WI