Skip to content

Cancelled registrations · 59

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 = 'NM' AND d.registrant_city = 'RIO RANCHO' 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 = 'NM' AND d.registrant_city = 'RIO RANCHO'
  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 = 'NM' AND d.registrant_city = 'RIO RANCHO'
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.

N7220HBeech 58 · S/N TH-1448Cancelled Oct 30, 2024 · Exported to Australia · Built 1984 · Nichols Christian T N64EMCessna T210N · S/N 21063032Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1978 · Odell John G N6777PPiper PA-24-250 · S/N 24-1908Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1960 · Tuberville Charles D N6422YAerostar International RX-7 · S/N RX7-3047Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1986 · Eldridge Stacy D N1184LFantasy Sky Promotions FANTASY EIGHT-90 · S/N 083Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1996 · Gilson Philip D N5681URaven S55A · S/N S55A-508Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Jones Kevin M N21800Firefly Balloons FIREFLY 7-15 · S/N F7-2041Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 2004 · Carpenter Michael J N5237PPiper PA-24 · S/N 24-267Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Adams Clyde N3599MAerostar International RX 8 · S/N RX8-3122Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1991 · Bondarenko Carol A N785TCThunder & Colt Airborne Amer AX-890S1 · S/N 2504USACancelled Aug 14, 2020 · Sale reported, canceled · Built 1993 N6466UMooney M20C · S/N 2213Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Guthrie Howard F N2586CBalloon Works FIREFLY 7-15 · S/N F7-797Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1992 · Walker Jon M N90862Balloon Works FIREFLY 7-B · S/N F7B-303Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Hodges Eric C N3008QCameron Balloons US C-80 · S/N 6043Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1996 · Makin Jessica D N60321Arbc Inc DBA Lindstrand 105A · S/N 5141Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 2000 · Thomas Robert R N53234Galaxy Balloons GALAXY 7 · S/N GLX-1297Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1987 · Curling Harold N5336LGalaxy Balloons GALAXY 9B · S/N GLX-1019BCancelled Feb 15, 2018 · Registration expired, pending cancellation · Braden Morgan N5549BDestiny 2001 · S/N 1C0288Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2001 · Bonham Mark N2190SFirefly Balloons GALAXY 11B · S/N GLX-1311BCancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2003 · Smith David E N15110Firefly Balloons FIREFLY 8 · S/N F8-2002Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2001 · Smith David N433WLLeue Kevin FALCOLN 1 · S/N 32762Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Leue Kevin D N4062CBalloon Works FIREFLY 7 · S/N 7992Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1979 · Smith Ruth C N4031ZAdams Balloon A55 · S/N 155Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1985 · Cabeza De Baca Sam N3010CCameron Balloons US N-105 · S/N 6034Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1996 · Leonard Raymond S DBA N40555Raven S55A · S/N S55A-859Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1981 · Pohlmeyer Connie L N7517YCameron Balloons US N-210 · S/N 5795Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1992 · Braden Kristopher N3598YAerostar International RX 8 · S/N RX8-3010Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1989 · Hensley Ronald E N64263Cessna 172M · S/N 17265136Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1975 · Kary Robin M N904CSBalony Kubicek Spol Sro BB26Z · S/N 514Cancelled Mar 13, 2015 · Exported to Mexico · Built 2007 · Stringfellow Catharine P N4710NAndreas Kenneth P SUPER NOVA 2000 · S/N SN2-110Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1984 · Andreas Kenneth P N7281LRaven Industries RX6 · S/N RX6-121Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1975 · Pallow John L N91LGGettier Leigh Stanley KITFOX MODEL II · S/N 535Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1994 · Gettier Leigh S N63459Aerostar International S-60A · S/N S60A-3156Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1991 · Slaten Mike E N6370CAerostar International RAVEN S71A · S/N S71A-3006Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1992 · Slaten Michael E N3614MAerostar International RX 8 · S/N RX8-3033Cancelled Jul 16, 2013 · Registration expired, pending cancellation · Built 1989 · Santa Fe Decor Inc N5715NRaven S55A · S/N S55A-691Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Mason John S III N30HLLederer John Martin TAYLOR MONOPLANE · S/N TM169HL1JL1Cancelled May 15, 2013 · Registration expired, pending cancellation · Lederer John Martin N9048VAerostar International S-60A · S/N S60A-3178Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1992 · Slaten Mike E N147CBCameron Balloons V-56 · S/N 339Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1978 · Tschida Francis A N3267VBeech 35 · S/N D-715Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1947 · Matatall Thomas J N1881RRaven Industries RX6 · S/N RX6-264Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1978 · Mitchell Kenneth N3SBCameron Balloons O-77 · S/N 130Cancelled Feb 8, 2012 · Sale reported, pending cancellation · Built 1974 N72466Balloon Works FIREFLY 9B-15 · S/N F9B-029Cancelled Oct 7, 2008 · Triennial form not returned · Built 2000 · Smith David E N9027ZAerostar International RAVEN S49A · S/N S49A-3126Cancelled Feb 13, 2008 · Triennial form not returned · Built 1992 · Myklebust Randy N95205Cameron Balloons US O-84 · S/N 5598Cancelled Apr 14, 2006 · Built 1990 · Econopouly John N1985HHead Balloons AX8-88 · S/N 116Cancelled Mar 31, 2006 · Built 1985 · Little Keri L N3989ECameron Balloons US V-90 · S/N 5697Cancelled Nov 2, 2005 · Triennial form not returned · Built 1991 · Garner Ruth A N33PLMckee PL-2 · S/N 182Cancelled Apr 7, 2003 · Triennial form not returned · Built 1976 · Raupp Twuana N N7027WPiper PA-28-180 · S/N 28-711Cancelled Jan 16, 2003 · Built 1962 · Coffey Alan S N5228YGalaxy Balloons GALAXY 7 · S/N GLX-1567Cancelled Dec 20, 2001 · Triennial form not returned · Lindig Robert C

Back to Rio Rancho, NM