Skip to content

Cancelled registrations · 65

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

N2989ZPiper PA-18 · S/N 18-7105Cancelled Oct 10, 2026 · Expired dealer · Utah Cub Pilot LLC N9110Hill HA-S-3 HOBBY · S/N 003Cancelled Jan 27, 2026 · Sale reported, pending cancellation N934JHCessna 152 · S/N 15283001Cancelled Jan 31, 2025 · Built 1978 · Utah State University N211AMAviat A-1B · S/N 2110Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2000 · Swgb Aviation LLC N5046KBensen B-8M · S/N TL-1Cancelled Nov 25, 2019 · Revoked, pending cancellation · Built 1962 · Stewart T Lynn N102MNAggieair Usu MINION · S/N AA102MNCancelled Aug 9, 2018 · Registration expired, pending cancellation · Utah State University N112MNAggieair Usu MINION · S/N AA112MNCancelled Jul 12, 2018 · Registration expired, pending cancellation · Utah State University N115MNAggieair Usu MINION · S/N AA115MNCancelled Jul 12, 2018 · Registration expired, pending cancellation · Utah State University N136MNAggieair Usu MINION · S/N AA136MNCancelled Jul 12, 2018 · Registration expired, pending cancellation · Utah State University N1710EAggieair Usu MINION · S/N AA1710ECancelled Jul 12, 2018 · Registration expired, pending cancellation · Utah State University N116MNAggieair Usu MINION · S/N AA116MNCancelled Jun 8, 2018 · Registration expired, pending cancellation · Utah State University N9933CSilvaire LUSCOMBE 8F · S/N S-37Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1959 · Chidester Clive R N811RBCannon Scott YOUNGSTER · S/N YO91Cancelled Feb 15, 2018 · Sale reported, canceled · Built 2002 N419FPDiamond Aircraft Ind DA40 F · S/N 40.FC019Cancelled Jun 29, 2017 · Built 2006 · Utah State University N15836Piper PA-28R-200 · S/N 28R-7335096Cancelled Jun 15, 2017 · First renewal notice · Built 1972 · Utah State University N7244KPiper PA-18 · S/N 18-136Cancelled Feb 4, 2017 · Revoked, canceled · Built 1950 · Air Oasis Inc N299DHCessna 560 · S/N 560-0645Cancelled May 17, 2016 · Built 2003 · Las Vegas Aviation III LLC N55PVMcshane Paul A PHOENIX VANDETTA · S/N 0052PVCancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1991 · Mcshane Paul A N976DMPilatus PC-7 · S/N 558Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1988 · Harris Air Inc N76057Cessna 140 · S/N 10451Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1946 · Dalton Michael J III N7338MCessna 175 · S/N 55638Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1958 · Leiser David B N6358ZHughes TH-55 · S/N 191083Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Utah State University N23445Cessna 150H · S/N 15068951Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1968 N1436XPiper PA-28-140 · S/N 28-7525312Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1975 · Bergstrom Kenneth N N6095BCessna 182A · S/N 34095Cancelled Jul 16, 2013 · Revoked, canceled · Built 1957 · Valley Airmotive Corp N8589KStinson 108-1 · S/N 108-1589Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1947 · Smith Jeff N103BDDaedalus Research DRX-103B · S/N 85-DA.SR40.1924Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Daedalus Research Inc N6032QMooney M20E · S/N 877Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1965 · Air Service West Inc N52316Taylorcraft DCO-65 · S/N L-4686Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1945 · Widauf David P N8637UCessna 172F · S/N 17252539Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1965 N8065GCessna 177RG · S/N 177RG0065Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1971 N101MXDouglas DC3A · S/N 2102Cancelled Jun 2, 2011 · Sale reported, canceled · Built 1939 N3542VCessna 172S · S/N 172S8906Cancelled May 10, 2011 · Exported to Philippines · Logan Air Services LLC N3449APiper PA-22-135 · S/N 22-1718Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1953 · Wier William W N98CBCameron Balloons V-56 · S/N 308Cancelled Sep 18, 2009 · Registration revoked · Built 1977 · Spence Stanley R N103JHPiper PA-34-200T · S/N 34-7570087Cancelled Aug 6, 2009 · Exported to Bolivia · Built 1975 · Utah State University N1435EAeronca 7AC · S/N 7AC-4998Cancelled Jun 9, 2009 · Registration revoked · Built 1946 · Fackrell Jerry G N152RCCessna 152 · S/N 15282736Cancelled Mar 29, 2004 · Triennial form not returned · Built 1978 · Utah State University N208CFCessna 208 · S/N 20800253Cancelled Apr 24, 2001 · Exported to Canada · Harris Air Inc N50511Cessna 150J · S/N 15069357Cancelled May 5, 2000 · Triennial form not returned · Flying Techs Inc N757PWCessna 152 · S/N 15279905Cancelled Apr 3, 2000 · Triennial form not returned · Utah State University N95654Cessna 152 · S/N 15285952Cancelled Jul 21, 1999 · Exported to Jordan · Saunders Walter L N2923Bell H13G · S/N 1045Cancelled Jul 20, 1998 · Triennial form not returned · Utah State University N7249UBell 407 · S/N 53152Cancelled Feb 12, 1998 · Exported to Brazil · Harris Air Inc N40JSauer Jack EXEC 90 · S/N 1Cancelled Jul 26, 1993 · Integrated Systems Aero Engrg Inc N1452Lockheed T-33A · S/N 51-9271Cancelled Mar 10, 1984 · Administratively canceled · Utah State Univ Of Agriculture & App N47378Piper PA-28-181 · S/N 28-7890058Cancelled Mar 2, 1982 · West Wind Aviation Services Inc N69498Cessna 340 · S/N 340-0336Cancelled Jul 22, 1976 · 681 Ltd N1333QCessna 150L · S/N 15072633Cancelled Aug 18, 1975 · Valley Airmotive Corp N5946JCessna 150L · S/N A1500246Cancelled Jun 26, 1973 · Valley Airmotive Corporation

Back to Logan, UT