Skip to content

Cancelled registrations · 92

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

N79RRQuest KODIAK 100 · S/N 100-0096Cancelled May 18, 2026 · Exported to Canada · Built 2013 · Stallings Ted W N20PFBell 212 · S/N 35023Cancelled Oct 31, 2025 · Exported to Canada · Built 1990 · Aero Tech LLC N85PPBell 212 · S/N 31266Cancelled Oct 31, 2025 · Exported to Canada · Built 1985 · Aero Tech LLC N83292Aeronca 7AC · S/N 7AC-1958Cancelled May 27, 2023 · Revoked, canceled · Built 1946 · Wiggins Jack N3984YCessna 210D · S/N 21058484Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1964 · Brian Zarikta Dds Pa N9197FAir Tractor AT-802A · S/N 802A-0009Cancelled Aug 12, 2022 · Built 1994 · Aero Tech Inc N627JPAir Tractor AT-802 · S/N 802-0238Cancelled Apr 27, 2022 · Exported to Australia · Built 2006 · Aeronautical Technologies Inc N3214PPiper PA-24-250 · S/N 24-292Cancelled Jan 18, 2022 · Third renewal notice · Built 1958 · Reed Aviation LLC N3531XMooney M20F · S/N 670068Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1966 · Grube Michael E N7785DPiper PA-18A 150 · S/N 18-5983Cancelled May 6, 2019 · Revoked, canceled · Built 1957 · Lockney Farm Chemical N71796Luscombe 8 · S/N 3223Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1946 N7091FRobinson Helicopter R44 II · S/N 13910Cancelled Feb 6, 2019 · First renewal notice · Built 2015 · Don Oppliger Trucking Inc N223RVKraus Michael D VANS RV-4 · S/N 2036Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 2002 · Roseveare Nathaniel J N4926VBellanca 17-30 · S/N 30152Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1968 · Love Robert N726JBCessna 421B · S/N 421B0020Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1970 · Bostwick James L N1433GBeech 95-A55 · S/N TC-242Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1962 · Davis Kenneth W N7983TCessna 175A · S/N 56683Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1960 · Harner Everett N29406Cessna 177 · S/N 17700866Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1968 · Williamson Dorman N7830DPiper PA-22-150 · S/N 22-5476Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1957 · Grube Michael E N4389WPiper PA-46-310P · S/N 46-8508050Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Southwest Whey Inc N174CDRobinson Helicopter R44 II · S/N 13863Cancelled Feb 19, 2016 · Exported to South Africa · Built 2015 · Over & Out Inc N6384RPiper PA-28-140 · S/N 28-21559Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1966 · Robinson Michael E N77553Piper J3C-65 · S/N 22044Cancelled May 6, 2015 · Registration expired, pending cancellation · Scott Montie N174CDRobinson Helicopter R44 II · S/N 13304Cancelled Mar 24, 2015 · First renewal notice · Built 2012 · Over & Out Inc N8516RBellanca 14-19-3 · S/N 4278Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1966 · Jones Larry C N3254ZPiper PA-22-150 · S/N 22-7202Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1959 · Wilkening Patrick E N9145RCessna TR182 · S/N R18200664Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1978 · Robinson Michael DBA N77733Funk B85C · S/N 363Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1946 N890CPAero Commander 500-B · S/N 500B-875-2Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Prina Zeff C N6948MStinson 108-3 · S/N 108-4948Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1948 · Robinson Michael E N732QPCessna T210M · S/N 21061692Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1976 · Pule Connor N9438Gross TAYLOR TITCH · S/N RITP10Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1978 · Gross Darryl F N7493QCessna 182P · S/N 18261133Cancelled May 10, 2013 · Sale reported, canceled · Built 1972 N2369NAir Tractor AT-400 · S/N 400-0416Cancelled Mar 18, 2013 · Third renewal notice · Built 1981 · Stallings Ted W N6326DBrooks R.B. SPECIAL · S/N 1Cancelled Feb 15, 2013 · Sale reported, canceled · Built 1960 N6591ZPiper PA-25-235 · S/N 25-2145Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1962 N180WMCessna 180J · S/N 18052738Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1976 N7005ZPiper PA-25-235 · S/N 25-2757Cancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1964 N3464NMooney M20F · S/N 680062Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1967 · Kasprick Gerald L N2816UPiper PA-28-181 · S/N 28-7990454Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Clovis Aviation Inc N5501Friend BENSEN B-8M · S/N 1Cancelled Sep 21, 2012 · Sale reported, pending cancellation · Built 1972 N2657RPiper PA-28R-200 · S/N 28R-35241Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Built 1969 · Frost Chris N3316FCessna 182J · S/N 18257316Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1966 N75473Cessna T-50 · S/N 3292Cancelled Sep 6, 2012 · Revoked, canceled · Built 1942 · Vandiver R H N8392ZCessna 210-5(205) · S/N 205-0392Cancelled Jun 11, 2009 · Exported to Mexico · Built 1963 · Hobbs Vehicle Inc N8627SAir Tractor AT-301 · S/N 301-0166Cancelled Sep 22, 2008 · Exported to Mexico · United Aero Inc N61353Air Tractor AT-502B · S/N 502B-0366Cancelled Jan 24, 2006 · Triennial form not returned · Built 1996 · Tate Spraying Service Inc N714HCCessna 150M · S/N 15079180Cancelled May 6, 2005 · Triennial form not returned · Built 1977 · United Aero Inc N81TRWilley Douglas J TEAM ROCKET F-1 · S/N 049Cancelled Mar 9, 2005 · Savage James P N64312Cessna 172M · S/N 17265162Cancelled May 16, 2003 · Triennial form not returned · Built 1975 · United Aero Inc

Back to Clovis, NM