Skip to content

Cancelled registrations · 26

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

N25962Miles BARRETT BG5 · S/N 1Cancelled Jun 30, 2025 · Revoked, canceled · Built 1976 · Miles Franklin R N551KPDassault FALCON 7X · S/N 139Cancelled Dec 17, 2024 · Exported to Canada · Built 2012 · Central Business Jets Inc N8545EPiper PA-28-151 · S/N 28-7615139Cancelled Sep 24, 2018 · Built 1976 · Mcdonald Donald C N3935HMooney M20J · S/N 24-0982Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1980 · Wb Incorporated N707DHBoeing 727-22 · S/N 18321Cancelled May 21, 2015 · Sale reported, canceled · Built 1965 N705DHBoeing 727-22C · S/N 19191Cancelled May 14, 2015 · Sale reported, canceled · Built 1967 N2360WBeech A23A · S/N M-957Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1966 · Carlson David J N8524ABombardier CL-600-2B19 · S/N 7524Cancelled Apr 11, 2014 · Sale reported · Built 2001 N3679ABalloon Works FIREFLY 8-24 · S/N F8-015Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1983 · Lind Herb N117LBellanca 17-30A · S/N 30391Cancelled Jul 16, 2013 · Revoked, canceled · Built 1971 · Stratton Richard E N16PWWilcox Paul R LAMBDA COOT · S/N Q-11Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Wilcox Paul R N378SNNelson Stephen COMP AIR 6 · S/N 97142Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1998 · Nelson Business Services LLC N9424VMooney M20E · S/N 700026Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · Hurinenko Douglas Steven N52762Cessna 177RG · S/N 177RG1266Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1977 · Airlake Aero Inc N5290MTaylorcraft BC12D-85 · S/N 10590Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1948 · Bartells Norman J Jr N86113Aeronca 11AC · S/N 11AC-541Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946 N4819Wagner WHITT V · S/N 13-ACancelled Nov 27, 2012 · Sale reported, canceled · Built 1974 N5KCCall BD-5 · S/N 1314Cancelled Aug 10, 2012 · Revoked, canceled · Built 1973 · Call Kayland E N731WLLockheed 1329 · S/N 5070Cancelled Jan 26, 2005 · Built 1965 · Central Business Jets Inc N57030Raven S55A · S/N S55A612Cancelled Jan 13, 1993 N9692MMooney M20C · S/N 670028Cancelled Jun 21, 1991 · Triennial form not returned · Herrick Vince N3117LCessna 310J · S/N 310J0117Cancelled Oct 1, 1982 · Berlin John & Mcmilland Steven DBA N7487JPiper PA-28R-180 · S/N 28R30847Cancelled Oct 15, 1981 · Macbertle Leasing N8029MCessna 150L · S/N 73029Cancelled Jul 21, 1977 · Graham David M N6934GCessna 150L · S/N 15072434Cancelled Jul 12, 1977 · Graham David A N83TCessna 310D · S/N 39259Cancelled Aug 15, 1972 · Trident Air Inc

Back to Burnsville, MN