Skip to content

Cancelled registrations · 32

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 = 'MO' AND d.registrant_city = 'BRANSON' 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 = 'MO' AND d.registrant_city = 'BRANSON'
  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 = 'MO' AND d.registrant_city = 'BRANSON'
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.

N588DACzech Sport PIPER SPORT · S/N P1001069Cancelled Jan 18, 2025 · Registration pending, canceled · Built 2010 N333CUniversal Stinson 108-2 · S/N 108-3333Cancelled Sep 16, 2023 · Registration pending, canceled · Built 1947 N369SHHughes Aero PREDATOR "C" · S/N PC120753W409Cancelled May 8, 2021 · Registration expired, pending cancellation · Mcqueen Claude W Jr N235FGPiper PA-28-235 · S/N 28-10634Cancelled Nov 12, 2020 · Built 1965 · Morrison Steven R N519YZPowrachute AIRWOLF 912ULS · S/N A209ULSCancelled Jan 6, 2020 · Registration expired, pending cancellation · Morris Zane V N7369WPiper PA-28-180 · S/N 28-1251Cancelled Jan 3, 2020 · Sale reported, canceled · Built 1963 N6304DThomas A Davis DRAGONFIRE · S/N 001Cancelled Mar 15, 2019 · Registration expired, pending cancellation · Built 2015 · Davis Thomas A N75455Shivers George BUCKEYE · S/N 4247Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1998 · Shivers George N6477Rock KR-1 · S/N 031Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1974 · Kelly Kelly J N868SHolmes William E PREDATOR · S/N E068SCancelled Sep 27, 2017 · Registration expired, pending cancellation · Built 2007 · Barnes Hugh G N441VBRobinson Helicopter R44 II · S/N 13611Cancelled Apr 10, 2017 · Exported to Philippines · Built 2014 · Hynes Aviation Industries Inc N5889Cook VOLKSWAGEN · S/N 1Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1974 · Cook Julius G N5251BWilley S/Willey E EXEC 90 · S/N 5251Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1995 N83178Aeronca 7AC · S/N 7AC-1839Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1946 · Niklas William T N73201Bell 47J-2 · S/N 1849Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1961 · Ozark Mountain Helicopters Inc N625TBeech H35 · S/N D-5324Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1957 · Bailey Wymann A N5598HPiper PA-20 · S/N 20-663Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1951 · Michaelson Harlyn N10GECessna 501 · S/N 501-0022Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Target Development & Consulting Inc N4597YBell 47J-2 · S/N 1566Cancelled Aug 7, 2012 · Registration pending, canceled N1146WBell 47J-2A · S/N 3123Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Built 1964 · Ozark Mountain Helicopters Inc N1140RRaven Industries RX6 · S/N RX6-212Cancelled Jun 4, 2012 · Registration expired, pending cancellation · Built 1977 · Williams Rodney L N3911NMooney M20C · S/N 680004Cancelled Oct 12, 2006 · Triennial form not returned · Built 1968 · Kids Across America N5373FPiper PA-32R-300 · S/N 32R7680512Cancelled Dec 6, 1995 · Rhodes Henry J 111 N506WWHughes 369HS · S/N 150699SCancelled Mar 25, 1992 · Triennial form not returned · Steffen Tim DBA N820FBell 47J-2 · S/N 1821Cancelled Apr 24, 1991 · Triennial form not returned · Ozark Mountain Helicopters Inc N17WCBell 47J-2A · S/N 3701Cancelled Jan 22, 1991 · Exported to Australia · Ozark Mountain Helicopters Inc N8579FBell 47J-2A · S/N 3718Cancelled Oct 15, 1981 · Ozark Helicopters Inc N26140Peterson Dale S 8-8M · S/N 1Cancelled May 6, 1981 · Peterson Dales N1192WBell 47J-2A · S/N 3709Cancelled Jul 6, 1977 · Ozark Helicopters Inc N61267Consolidated Vultee BT-13A · S/N 12868Cancelled Feb 15, 1956 · Boswell Dillard P N49616Piper J3F-65 · S/N G-161Cancelled Oct 11, 1955 · Broyles Veon H N15885Porterfield CP-40 · S/N 255Cancelled May 4, 1948 · Coody Shelby G

Back to Branson, MO