Skip to content

Cancelled registrations · 229

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 = 'OH' AND d.registrant_city = 'AKRON' 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 = 'OH' AND d.registrant_city = 'AKRON'
  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 = 'OH' AND d.registrant_city = 'AKRON'
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.

N33604Lockheed 18 · S/N 2170Cancelled Jan 21, 2026 · Revoked, canceled · Built 1942 · B & H Industries Inc N1925UCessna T210N · S/N 21064750Cancelled Aug 29, 2023 · Built 1982 · Donahue Robert J N331UANicholas G Garafolo 3X18M · S/N 0002Cancelled Nov 25, 2022 · Registration pending, canceled N330UANicholas G Garafolo 8X48FT · S/N 0001Cancelled Jun 4, 2022 · Registration expired, pending cancellation · University Of Akron N737CJJohnson Karl W SAVANNAH S · S/N 15-07-54-0406Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 2019 · Johnson Karl W N811SKPiper PA-46-310P · S/N 46-8508046Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1985 · Akron Aerostar LLC N2718ETailwind W-8 · S/N 1001Cancelled Jun 12, 2020 · Revoked, canceled · Built 1962 · Choi George Y H N747RFDJI PHANTOM 2 · S/N PH645183787 V1.0Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Murphy Elizabeth Corbin N912TTVerroi Timothy A DOMINATOR · S/N 120790Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 2008 · Woods Raymond E N2356KLuscombe 8A · S/N 5083Cancelled Sep 26, 2019 · Revoked, pending cancellation · Built 1947 · Hoover George H N28497Luscombe 8A · S/N 1364Cancelled Sep 20, 2019 · Revoked, canceled · Built 1940 · Boyce William H N2088HEngineering & Research ERCOUPE 415-C · S/N 2711Cancelled Feb 8, 2019 · Revoked, pending cancellation · Built 1946 · Baker Kyle A N5625ADJI S-800 SPREADINGWINGS · S/N 0M0133430Cancelled Dec 7, 2018 · Registration expired, pending cancellation · University Of Akron N2511CCessna 170B · S/N 26155Cancelled Sep 20, 2018 · Revoked, pending cancellation · Built 1954 · A M Flying Club N747GAGrumman American Avn. GA-7 · S/N GA7-0037Cancelled May 31, 2018 · Sale reported, canceled · Built 1978 N7361VBellanca 17-30 · S/N 30220Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1969 · Emerson Family Limited Partnership N8967NPiper PA-32-300 · S/N 32-40777Cancelled Mar 16, 2018 · Revoked, canceled · Built 1969 · Mathews Richard A N9072HGoodyear 813 · S/N P-2Cancelled Mar 16, 2018 · Revoked, canceled · Built 1952 · Contos James N7705WPiper PA-28-180 · S/N 28-1703Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1964 · Savick Walter H N51AVAvian Balloon FALCON II · S/N 51Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1979 · Burton Michael L N517ZVallish Gregory VARI/EZE · S/N 437-1Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1996 · Vallish Gregory A N969BSocata TB-20 TRINIDAD · S/N 1037Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Merriman Aviation LLC N3170PPiper PA-23 · S/N 23-1105Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1957 · Ne Ohio Flyers LLC N47162Fairchild M-62A · S/N T41530Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Hunt Donald R N4281MPadelt Albert F 3 · S/N PW421Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1991 · Ray Gregory F N14KSRaven S55A · S/N S55A-203Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1974 · Yost Dale E N801XSOxley Stephen DEONEIRA · S/N 001Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Oxley Stephen D N998CABeech B-60 · S/N P-503Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1979 · Mag Management Corp N680DBBastion David C DRAGONFLY · S/N 688Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1992 · Ryba Christopher J N60868Consolidated Vultee BT-13A · S/N 3283Cancelled Feb 4, 2017 · Revoked, canceled · Built 1942 · Tinley Frank C N3157VSuter William A BLUEBIRD · S/N 001Cancelled Jul 13, 2016 · Built 2005 · Suter William A N31374Goodyear S-94 · S/N P-4Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1956 · Balloon Flyers Of Akron N1410LBeech A23 · S/N M-799Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1965 · Perry Rudolph Jr Trustee N3093CZwick Robert L BENSON B-8M · S/N 01Cancelled May 6, 2015 · Registration expired, pending cancellation · Zwick Robert L N9149RMooney M20R · S/N 29-0004Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1994 · 2201 Inc N2746AGoodyear Spherical Balloon 35000 CU. FT. · S/N WLTA-101Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1956 · Lighter Than Air Society N4ALoral GZ22 · S/N 4120Cancelled Feb 17, 2015 · First renewal notice · Built 1987 · Goodyear Tire And Rubber Co N32184Piper PA-28-151 · S/N 28-7515089Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Goodwin Steven N1AGoodyear GZ-20A · S/N 4116Cancelled Jun 19, 2014 · Built 1971 · Goodyear Tire & Rubber Co N2949Grumman G-73 · S/N J-12Cancelled Nov 14, 2013 · Registration expired, pending cancellation · Miller Malcolm A N422EZDesimone John M ZODIAC CH 601-HDS · S/N 6-3171Cancelled Sep 28, 2013 · Registration expired, pending cancellation · Built 1996 · Desimone John Martin N214WAConstrucciones Aeronauticas C-212-CB · S/N 154Cancelled Sep 27, 2013 · Exported to Democratic Republic of the Congo · Williams Aviation Fbo LLC N3290YCessna 182E · S/N 18254290Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1962 · J 5 Flying Club Of Akron N678APiper PA-22 · S/N 22-80Cancelled Sep 26, 2013 · Revoked, canceled · Built 1951 · Story Herbert N76BCJones BABY GREAT LAKES · S/N 7215K-453-BCancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1975 · Powell Edgar L N318DCMaule MX-7-180C · S/N 28022CCancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 2005 · Colopy Daniel N625Nardi FN-333 · S/N 007Cancelled Aug 5, 2013 · Revoked, canceled · Built 1963 · Strohl Perry A Jr N29600Goodyear Spherical Balloon 35000 CU. FT. · S/N S-122Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1940 N2749AGoodyear 813 · S/N WLTA-102Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1943 · Balloon Flyers Of Akron N2615KGeneral Balloon AX-6 · S/N 524Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1982 · Balloon Flyers Of Akron

Back to Akron, OH