Skip to content

Cancelled registrations · 25

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 = 'UT' AND d.registrant_city = 'MOAB' 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 = 'UT' AND d.registrant_city = 'MOAB'
  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 = 'UT' AND d.registrant_city = 'MOAB'
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.

N561WHHawley William VELOCITY XL RG · S/N 3RX086Cancelled Nov 3, 2025 · Exported to Canada · Built 2002 · Hawley William N768MMZeff Aaron MURPHY MOOSE · S/N 227SRCancelled Aug 11, 2022 · Exported to Canada · Byrd Benjamin E N8004JCameron Balloons US N-145 · S/N 6260Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2000 · Bartell Louis B N66DNDean Nordsving CCK-1865 · S/N CCK-1865-0038Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 2013 · Carroll Drilling LLC N995BWKirk Brian KITFOX IV SPEEDSTER · S/N JBS-070Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2003 · Marshall Jesse A N23834Taylorcraft BL-65 · S/N 1470Cancelled Apr 12, 2019 · Revoked, canceled · Built 1939 · Williams Howard N772RTQuest KODIAK 100 · S/N 100-0140Cancelled Sep 19, 2018 · Registration expired, pending cancellation · Built 2015 · Lease Air LLC N719TCThunder Balloons AX7-77 · S/N 2484Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1993 · Botjer David A N77516Piper J3C-65 · S/N 22008Cancelled Dec 27, 2016 · Revoked, pending cancellation · Built 1946 · Stilson Lewis N6526ZCessna TU206G · S/N U20606309Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1981 · Mor-Mud Inc N4FNPiper PA-28-140 · S/N 28-7525054Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1974 · Weldon Forrest H N27953Raven Industries RALLY RX7 · S/N RX7-414Cancelled Apr 2, 2013 · Sale reported, canceled N5108MTaylorcraft DC-65 · S/N 10408Cancelled Aug 10, 2012 · Revoked, canceled · Built 1946 · Stocks Donald R N70654Piper J3C-65 · S/N 17672Cancelled Jun 21, 2011 · Revoked, pending cancellation · Built 1946 · Shumway Arthur N72390Cessna 337G · S/N 33701575Cancelled May 12, 2010 · Exported to Australia · Built 1973 · Wynn Michael P N50659Taylorcraft BC12-65 · S/N 6400Cancelled May 29, 2009 · Triennial form not returned · Built 1942 · Lamoureux Nicholas J N2164RCessna 182G · S/N 18255364Cancelled Oct 17, 2007 · Triennial form not returned · Built 1964 · Slickrock Air Guides Inc N8374SCessna 182H · S/N 18256474Cancelled May 23, 2002 · Triennial form not returned · Built 1965 · Boyle Gene J N13MMcclatchy Warren G AIR-BIKE · S/N AB-7Cancelled Jan 12, 2000 · Triennial form not returned · Mcclatchy Warren G N70298Cessna 185F · S/N 18502101Cancelled Jul 20, 1973 · Smith Richard N4110NCessna 140 · S/N 13568Cancelled Jun 7, 1971 · Carter Clifford L N8600TCessna 182C · S/N 52500Cancelled Feb 18, 1971 · Mayberry Paul Md/Alexander James R Md N4120VCessna 170 · S/N 18452Cancelled Dec 29, 1970 · Lyman Burns & Doris N3298BPiper PA-18 · S/N 18-3300Cancelled Jul 23, 1957 · Exported to Mexico · Utex Exploration Co N5809NInterstate S-1B1 · S/N 190Cancelled Aug 13, 1956 · Arlace D Moore

Back to Moab, UT