Skip to content

Cancelled registrations · 64

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 = 'AZ' AND d.registrant_city = 'SEDONA' 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 = 'AZ' AND d.registrant_city = 'SEDONA'
  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 = 'AZ' AND d.registrant_city = 'SEDONA'
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.

N91268Jackson Robert BENSEN COPTER · S/N 2Cancelled Nov 24, 2023 · Revoked, canceled · Built 1965 · Jackson Robert P N349TMDJI PHANTOM 3 ADVANCED · S/N P76DCG16010714Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Melmon Ronald S N2563GCessna 182B · S/N 51863Cancelled Apr 2, 2020 · Revoked, pending cancellation · Built 1959 · Jackson Robert P N91267Robert Jackson BENSEN GLIDER · S/N 1Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1965 · Jackson Robert P N4505DHead Balloons AX7-77 · S/N 158Cancelled Jun 26, 2018 · Registration pending, canceled N3128UCessna 182F · S/N 18254528Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1962 · Crowell Jacie A N1475APiper PA-22 · S/N 22-381Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1952 · Loftin Stephen J N4600QCessna 210K · S/N 21059500Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1971 · Desert Aircraft Leasing Inc N4400LRaven S55A · S/N S55A-1068Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Macaloney Rodney A N2600BAero Commander 520 · S/N 520-112Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1953 · Sedona Oak Creek Airport Authority N3630TAerostar International S-60A · S/N S60A-3131Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Windwalker David N2068UAvian Balloon MAGNUM IX · S/N 208Cancelled Aug 1, 2017 · Northern Light Balloon Expeditions Sedona Balloon N2760FCessna 182J · S/N 18256860Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1966 · Bryant Otis M Trustee N222HGBalloon Works FIREFLY 6B · S/N 10058Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1980 · Mccarrick Doun L N90565Aerostar International RXS-8 · S/N RXS8-3079Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1998 · Windwalker David N9644ZOtto-Hardy BG-12A · S/N OH-1Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1967 · Balsley Philip F N122BBBoydston Bob DRAGONFLY MK II · S/N 723Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 2002 · Boydston Aviation LLC N90144Bell 206B · S/N 1623Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1975 · Parrish Donald A DBA N93DBWilliam M Oprendek PITTS S1S · S/N PITTS S1SS-3Cancelled Jan 5, 2017 · Built 2013 · Oprendek William M N5852PDJI PHANTOM 2 VISION · S/N PH645123207Cancelled Sep 15, 2016 · Pinciaro Dennis N45289Head Balloons AX9 118 · S/N 217Cancelled Oct 5, 2015 · First renewal notice · Built 1993 · Northern Light Balloon Expeditions N133JWCessna 337B · S/N 3370612Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1967 · Canyon Mesa Aviation II LLC N29196Aerostar International S-60A · S/N S60A-3030Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1986 · Sprague Larry N135TCThunder & Colt Airborne Amer COLT 105A · S/N 1831USACancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1991 · Stewart Patricia A N90299Balloon Works FIREFLY 8-24 · S/N F8-300Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Sprague Larry N1612YAvian Balloons TURBO 8 · S/N 148Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Sprague Larry N4113RPiper PA-32-300 · S/N 32-40432Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1968 · Jackson Robert P N7036SCessna 182P · S/N 18265050Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1976 · Rese Darla M N8307CHead Balloons AX9 118 · S/N 229Cancelled Apr 29, 2013 · First renewal notice · Northern Light Balloon Expeditions Sedona N5553DRaven Industries RALLY RX7 · S/N RX7-102Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Lee Christopher T N855BBell 206B · S/N 316Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Parrish Donald A DBA N67QQEbersole Walter J QUICKIE Q-2 · S/N 2067Cancelled Apr 1, 2013 · Sale reported, canceled N7405MBalloon Works FIREFLY 8B · S/N F8B-018Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Begany Raymond A N27661Piper PA-31-350 · S/N 31-7852093Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1978 · Rmg Consultants Corporation N43995Raven Industries S77A · S/N S77A-112Cancelled Aug 22, 2012 · Registration pending, canceled N3592ZAerostar International S-60A · S/N S60A-3104Cancelled Jul 18, 2011 · Registration pending, pending cancellation · Built 1988 N97AZBell 206B · S/N 2693Cancelled Apr 27, 2011 · First renewal notice · Arizona Helicopter Adventures LLC N997KBRobinson Helicopter R44 II · S/N 10695Cancelled Apr 14, 2009 · Exported to Spain · Built 2005 · Strategic Defense Of The Environment Group Inc N601BHHill Burl P Trustee ZODIAC CH-601-HD · S/N 63590Cancelled Dec 11, 2006 · Triennial form not returned · Built 2001 · Hill Buryl P Trustee N222AZCunningham Ronald B RV-4 · S/N 3920Cancelled Mar 24, 2005 · Cunningham Ronald B N2898FCessna 182J · S/N 18256998Cancelled Mar 14, 2005 · Triennial form not returned · Built 1966 · Daniels Roy G N22467Piper PA-32RT-300T · S/N 32R-7887263Cancelled Aug 28, 2004 · Triennial form not returned · Built 1978 · Tbt Wings LLC N56SWWard Terrence E QUICKSILVER GT-500 · S/N 375Cancelled Apr 15, 2004 · Exported to Mexico · Built 2001 · Ward Terrence E N57242Raven S55A · S/N S55A-751Cancelled Jun 11, 2003 · Triennial form undeliverable · Built 1981 · Windwalker David N6657YPiper PA-31-350 · S/N 317852164Cancelled Mar 26, 2003 · Built 1978 · Dakota Territory Tours Inc N5025GAvian Balloon MAGNUM IX · S/N 171Cancelled Feb 11, 2002 · Triennial form not returned · Built 1992 · Nrthrn Lght Balloon Expeditions Inc N5535DCessna 172N · S/N 17272595Cancelled Jul 3, 2000 · Exported to Canada · Fsi LLC DBA N51313Mooney M20M · S/N 27-0219Cancelled May 25, 1999 · Exported to Canada · Air Fast LLC N5023UAvian Balloon MAGNUM IX · S/N 169Cancelled Dec 17, 1998 · Triennial form not returned · Northern Light Balloon Expeditions N369DPWaco YMF · S/N F5007Cancelled Jun 12, 1998 · Dakota Territory Tours Inc

Back to Sedona, AZ