Skip to content

Cancelled registrations · 56

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

N898ARJames A Roman RANS S-20 RAVEN · S/N 05150043Cancelled Aug 29, 2026 · Registration pending, canceled · Built 2016 N110DPiper PA-18A · S/N 18-4827Cancelled Feb 22, 2025 · Sale reported, canceled N9129VAerostar International RAVEN S52A · S/N S52A-3008Cancelled Sep 16, 2023 · Registration pending, canceled · Built 1993 N105PSSwanstrom Peter M JETEXEC · S/N 6507Cancelled Jul 22, 2023 · Sale reported, canceled · Built 2014 N57031Buckeye DREAM MACHINE · S/N 4858Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 2000 · Brooksby Wayne J N75323Buckeye DREAM MACHINE · S/N 4754Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1999 · Brooksby Wayne J N121AKDehavilland DHC-2 · S/N 121Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1951 · Rainbow River Lodge LLC N111LGHuggins Greig WHITE LIGHTNING · S/N 92Cancelled May 8, 2021 · Registration expired, pending cancellation · L & G Inc N9173TMarley Thomas Jay KOLB FIRESTAR II · S/N FS-512Cancelled Feb 27, 2020 · Third renewal notice · Built 1997 · Imig Kurt N6696PPiper PA-24-250 · S/N 24-1821Cancelled Jan 10, 2020 · Built 1960 · Rocco Phillip W N663NADJI INSPIRE 1 · S/N W13DCHI4040990Cancelled Jul 2, 2019 · Registration expired, pending cancellation · Aerial Graphics Of Utah LLC N39094Luscombe 8C · S/N 1855Cancelled Jan 15, 2019 · Revoked, canceled · Built 1941 · Mudd Dwight E N58008Quicksilver MX SUPER · S/N 1005Cancelled May 30, 2018 · Sale reported, canceled · Built 1984 N109SSBauer Robert J GENESIS · S/N GE07-001Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 2008 · Sorbonne Robert L N4ZXLawton VARI-EZE · S/N 312Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1985 · Byerley Dana J N8387ACessna 170B · S/N 25239Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1952 · Weaver Craig N8776BCessna 172 · S/N 36476Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1957 · Hansen Chris G N7342Anderson BIPLANE-WDII · S/N 1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1973 · Anderson John R N24WNNicholson William L THORP T18CWS · S/N 1424Cancelled May 6, 2015 · Registration expired, pending cancellation · Nicholson William L N374AMSchempp-Hirth NIMBUS-3DM · S/N 9Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1989 · Vayda Thomas P N3222NNorcutt David RALLY 3 · S/N 64772Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1982 · Norcutt David N8533AShane James R SCORPION-133 · S/N 3034Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Shane James R N235MAero Commander 200 · S/N 296Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1966 · Zakraisek Donald S DBA N1147YCessna 150B · S/N 15059547Cancelled Aug 28, 2014 · Registration expired, pending cancellation · Built 1962 · Smith Dennis R N4608QHooker Roger D RAF 2000 GTX SE FI · S/N H2-04-15-622Cancelled Aug 22, 2013 · Sale reported, canceled · Built 2004 N870GGoodwin L G/Goodwin O G Q-200 · S/N 2870Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Goodwin Lenny G N7966ECessna 150 · S/N 17766Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Keddington Robert M N2239QCessna 421A · S/N 421A0039Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1969 N949APiper PA-22 · S/N 22-257Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1951 · Nichols Robert K N5972WPiper PA-28-160 · S/N 28-4023Cancelled Apr 30, 2013 · Registration expired · Built 1967 · Hill Ronald C N53QBPorbeck John M SLIPSTREAM GENESIS · S/N JMP-01Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 2003 · Sorbonne Robert L N2HSchumacher Joe SWEARINGEN SX-300 · S/N SA29-66Cancelled Aug 1, 2012 · Third renewal notice · Built 1988 · Stevens Larry P N1571PPiper PA-22-150 · S/N 22-2574Cancelled Jul 9, 2012 · Sale reported, canceled · Built 1955 N36VQuestair VENTURE · S/N 16Cancelled Mar 15, 2012 · Exported to Canada · Built 2003 · Questair Ventures LLC N732RQCessna T210M · S/N 21061717Cancelled Oct 12, 2011 · Exported to Mexico · Built 1977 · Robinson Michael S N2626SCessna T337C · S/N 337-0926Cancelled Jul 20, 2011 · Registration pending, canceled · Built 1968 N8374ZCessna 210-5(205) · S/N 205-0374Cancelled May 21, 2010 · Exported to Mexico · Built 1963 · Shupe Jared P N80318Cessna 172M · S/N 17266515Cancelled Oct 5, 2009 · Exported to Canada · Built 1975 · Smith Michael L N1215QCessna 150L · S/N 15072515Cancelled Jun 25, 2009 · Registration revoked · Built 1971 · Keddington Robert M N8549FPiper PA-28-151 · S/N 28-7715280Cancelled Sep 23, 2008 · Triennial form not returned · Built 1976 · Chailei Sales And Leasing N846BBSwearingen SA-26AT · S/N T26-149ECancelled Jul 29, 2008 · Exported to Mexico · Built 1969 · Merlin Wings LLC N78AAPiper PA-34-200T · S/N 34-7670192Cancelled Aug 30, 2006 · Exported to Bahamas · Built 1976 · Clark William H N8015UDouglas DC-8-21 · S/N 45589Cancelled Jul 19, 2002 · Triennial form not returned · Built 1959 · Chk Partnership N735JPCessna TU206G · S/N U20604928Cancelled Nov 19, 1998 · Exported to Mexico · Robert H Horne Md Pc N31WDGlines Weldon R ACRO DUSTER II SA750 · S/N 001WRGCancelled Jan 22, 1997 · Triennial form not returned · Glines Weldon R N5247PCessna 152 · S/N 15284900Cancelled Jun 15, 1995 · Exported to New Zealand · Corporate Wings Inc N5251QCessna 152 · S/N 15285093Cancelled Jun 15, 1995 · Exported to New Zealand · Corporate Wings Inc N5543LCessna 152 · S/N 15284346Cancelled Jun 15, 1995 · Exported to New Zealand · Corporate Wings Inc N136CHCessna 411 · S/N 4110116Cancelled Apr 1, 1994 · Jump West Inc N3182PPiper PA-23 · S/N 231119Cancelled Jul 24, 1992 · Triennial form not returned · Wyler Charles H

Back to Sandy, UT