Skip to content

Cancelled registrations · 30

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

N53833Bellanca 8GCBC · S/N 186-75Cancelled Nov 1, 2025 · Sale reported, canceled · Built 1975 N99GGDorey Michael S PAZMANY PL-4A · S/N PL-4A-00-001-MDCancelled Jul 17, 2021 · Sale reported, canceled · Built 2003 N147SVNord STAMPE SV4C · S/N 325Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1972 · Krejchik Daniel J N750DKDaniel J Krejchik ZENITH 750 · S/N 7850Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2016 · Krejchik Daniel J N30305Piper J3L-65 · S/N 4780Cancelled Jun 28, 2019 · Sale reported, canceled · Built 1938 N62419Nord-S.N.C.A.C. NC854 · S/N 11Cancelled May 30, 2018 · Sale reported, canceled · Built 1971 N123BGZahorik James A QUICK SILVER · S/N 100JZCancelled Aug 13, 2013 · Sale reported, canceled · Built 1982 N30569Piper J3L-65 · S/N 4942Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1940 · Coleman William T N9526TCessna 210 · S/N 57326Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1960 · Marks David A N77LGGriffin Lavern H PITTS S-1C · S/N 451-HCancelled May 9, 2013 · Registration expired, pending cancellation · Griffin Laverne H N7325GCessna 172K · S/N 17259025Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1970 · Pal Day Aeroclub Inc N4604SMael BA-42 · S/N 001Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1966 · Mael Aircraft Corp N2425NCessna 120 · S/N 12674Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1947 N12233Mael BURNS BA-42 · S/N 002Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1972 · Mael Aircraft Corp N3326QPiper PA-32R-300 · S/N 32R-7780305Cancelled Aug 2, 2004 · Sale reported · Built 1977 N111HGBalloon Works FIREFLY 7 · S/N 186Cancelled Jul 31, 2002 · Triennial form not returned · Built 1974 · Zoltowski Kathleen L N2086FBalloon Works FIREFLY 6B · S/N 724Cancelled Apr 30, 1991 · Triennial form not returned · Zoltowski Kathleen L N5250BMooney M20A · S/N 1113Cancelled Jul 27, 1971 · Exported to Canada · Built 1947 · Mael Airways N8686DPiper PA-18A 150 · S/N 18-6292Cancelled Feb 14, 1968 · Exported to Canada · Mael Chester N2658DCessna 170B · S/N 20810Cancelled Oct 5, 1965 · Sanderson Thomas Jess N3578CCessna 170B · S/N 26622Cancelled Apr 14, 1965 · Exported to Canada · Mael Airways N63608Consolidated Vultee BT-13A · S/N 5841Cancelled Jun 12, 1961 · Mael Airways-Bob Mael N17403Aeronca C-3 · S/N 716Cancelled Feb 22, 1956 · Radant Gerlad F N5569NConsolidated Vultee BT-13A · S/N 5899Cancelled Feb 16, 1956 · Smith Paul H N33400Piper J5A · S/N 5-490Cancelled Oct 17, 1951 · H Melvin Seibers N1412HAeronca 15AC · S/N 15AC-469Cancelled Jan 2, 1951 · Exported to Mexico · Pettit Martin J N553NCurtiss THRUSH JSPECIAL · S/N 1005Cancelled Feb 26, 1948 · Exported to Mexico · Built 1931 · Smith Paul H N591NMoth 60-GMW · S/N 166Cancelled Oct 7, 1947 · Built 1930 · Smith Paul N5053Standard J-1 · S/N 4532Cancelled Dec 1, 1937 · Built 1918 · Mael Chester N61822Cessna T-50 · S/N 5275Cancellation date not recorded · Mael Chet

Back to Portage, WI