Skip to content

Cancelled registrations · 49

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

N13610Cessna 172M · S/N 17262882Cancelled Aug 19, 2026 · Wahl Donald M N6325YPiper PA-23-250 · S/N 27-3583Cancelled Aug 19, 2026 · Wahl Donald M N3622JCessna 150G · S/N 15064922Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1966 · Coulson Michael D N25310Bellanca 14-9 · S/N 1032Cancelled Aug 2, 2020 · Sale reported, canceled · Built 1939 N611LTDJI PHANTOM 2 VISION + · S/N PH645490663Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Thomas Jason T N15WWiggins MEADOWLARK WM-1 · S/N 1Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1964 · Young Franklin L N38246Piper J5A · S/N 5-918Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1941 · Sterling Gary G N14294Piper PA-23-250 · S/N 27-4855Cancelled Sep 14, 2016 · Exported to Canada · Built 1972 · Rojewski Thomas E Md N5575MSims Eugene H BENSEN B-8M · S/N 8F-204-100Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1980 · Sims Eugene H N7999UCessna 172F · S/N 17251999Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Thomas Greg P N8888KStinson 108-1 · S/N 108-1888Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1947 · Wahl Donald M N57781Cessna T-50 · S/N 5394Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1943 · Jasper Dennis L N454TTOrmsbe-Cassutt R-1 · S/N R0-2Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1967 · Thompson Terry N2863HErcoupe 415-C · S/N 3488Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1946 · Knight Charles A N99670Piper J3F-65 · S/N 5184Cancelled Feb 27, 2013 · Sale reported, pending cancellation N3035Davis EVANS VP-1 · S/N LS-4Cancelled Feb 21, 2013 · Sale reported, pending cancellation · Built 1971 N758EWaco GXE · S/N 2010Cancelled Aug 6, 2009 · Triennial form not returned · Morozowsky Anthony M N660YWaco CRG · S/N 3350Cancelled Jul 24, 2009 · Triennial form not returned · Morozowsky Anthony M II N5673Cessna 182 · S/N 33673Cancelled May 20, 2002 · Triennial form not returned · Morozowsky Anthony M N45795Brooks BABY LAKES · S/N 12846Cancelled Oct 15, 1992 N9877CCessna R182 · S/N R18200478Cancelled Jul 1, 1991 · Triennial form not returned · Snyder Phillip C N7118FCessna 150F · S/N 15063718Cancelled Mar 1, 1991 · Triennial form not returned · Southeastern Ohio Air Service Inc N609XSteinbach Flybaby 1-A · S/N KFS-7-1Cancelled Nov 27, 1984 · Allbright Roylee N31596Stinson 10A · S/N 7845Cancelled Jun 23, 1983 · Exported to Canada · Workman Paul E N736AWCessna R182 · S/N R18200713Cancelled Jun 30, 1981 · Exported to South Africa · Southeastern Ohio Air Service Inc N5529YCessna T210 · S/N 21064238Cancelled Apr 10, 1981 · Exported to South Africa · Southeastern Ohio Air Service Inc N4727YCessna T210N · S/N 21063995Cancelled Jan 22, 1981 · Exported to South Africa · Built 1980 · Southeaster Ohio Air Services Inc N4740VCessna 172RG · S/N 172RG0373Cancelled Jan 22, 1981 · Exported to South Africa · Built 1980 · Southeastern Ohio Air Services Inc N4971YCessna T210N · S/N 210-64061Cancelled Jan 22, 1981 · Exported to South Africa · Southeastern Ohio Air Services Inc N6444CCessna T210N · S/N 21063890Cancelled Jan 22, 1981 · Exported to South Africa · Southeastern Ohio Air Services Inc N77886Luscombe 8A · S/N 3613Cancelled Jul 21, 1977 · Workman James E N8737PPiper PA-24-260 · S/N 24-4187Cancelled Apr 25, 1976 · Hupp Daniel P DBA Dp Hupp Aircraft Sales N2207UBrantly 305 · S/N 1009Cancelled Jun 29, 1970 · Built 1965 · Scott John O N6168SAir & Space America 18A · S/N 18-76Cancelled Jun 26, 1970 · John O Scott N1725PPiper PA-22-150 · S/N 22-2515Cancelled Nov 14, 1967 · Pagath Emil M N1735NCessna 120 · S/N 11979Cancelled May 25, 1965 · Riverside Airport Corp N75508Consolidated Vultee BT-13A · S/N 7387Cancelled May 25, 1965 · Riverside Airport Corp N69955Consolidated Vultee BT-15 · S/N 7456Cancelled Feb 20, 1956 · Rittenhouse H S N61590Schweizer TG3A · S/N 82Cancelled Oct 12, 1955 · Southeastern Ohio Air Service Inc N61622Cessna T-50 · S/N 4943Cancelled Oct 12, 1955 · Southeastern Ohio Air Service Inc N19852Taylorcraft A · S/N 357Cancelled Mar 18, 1955 · W Eugene Hale N5205MTaylorcraft BC12-D · S/N 10505Cancelled Oct 27, 1949 · Built 1947 · Zane Flying Service N27514Taylorcraft BL · S/N 2156Cancelled Jul 25, 1949 · Briggs Edna B N4735HPiper PA-11 · S/N 11-580Cancelled Jun 16, 1949 · Zane Flying Service N5203MTaylorcraft BC12-D · S/N 10503Cancelled May 25, 1949 · Built 1947 · Southeastern Ohio Air Service Inc N1843American Eagle A-1 · S/N 60Cancelled Jun 15, 1940 · Martenia Howard N697VCurtiss Wright JR CW1 · S/N 1079Cancelled Jan 26, 1938 · Kirkendall Harvey N N1709Waco 9 · S/N 201ACancelled Feb 6, 1929 · Charles Leona M N69931Cessna UC-78 · S/N 2633Cancellation date not recorded · Cole Eugene A

Back to Zanesville, OH