Skip to content

Cancelled registrations · 44

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 = 'AK' AND d.registrant_city = 'SEWARD' 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 = 'AK' AND d.registrant_city = 'SEWARD'
  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 = 'AK' AND d.registrant_city = 'SEWARD'
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.

N1913VCessna 140 · S/N 14106Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1947 · Bassignani Phillip N3087MPiper PA-12 · S/N 12-1776Cancelled Jun 12, 2020 · Revoked, canceled · Built 1957 · Amend Oliver J N6986DPiper PA-18-150 · S/N 18-5510Cancelled Oct 11, 2019 · Revoked, canceled · Built 1957 · Dippel Donald E N6947HPiper J3C-65 · S/N 20182Cancelled May 4, 2019 · Revoked, canceled · Built 1946 · Goodhue George E N9076EMaule M-5-235C · S/N 7084CCancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1977 · Ham Keith W N94905Taylorcraft BF · S/N 9305Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Hamerly William L N2310DCessna 170B · S/N 20462Cancelled Oct 28, 2017 · Revoked, canceled · Built 1952 · Klippel John P N6435CAeronca 7BCM · S/N 7BCM-142Cancelled May 23, 2017 · Sale reported N636CFBeech C-45H · S/N AF-636Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1952 · Mellish John N1363CPiper PA-18 · S/N 18-2614Cancelled Dec 22, 2014 · Revoked, canceled · Built 1953 · Foldager Raymond J N70180Piper J3C-65 · S/N 17165Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1946 · Lohman Russell J N43943Taylorcraft BC12-D · S/N 7602Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1955 · Sorensen Allen L N9753GCessna 180H · S/N 18052253Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1972 N89WMManess William A BABY GREAT LAKES · S/N 8423D-689SBCancelled Jul 3, 2013 · Registration expired, pending cancellation · Maness William A N68596Bellanca 7ACA · S/N 66-72Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1972 · Dunn John M N5236CBeech B35 · S/N D-2581Cancelled Apr 2, 2013 · Registration expired, pending cancellation · Built 1950 · Hutson Roger L N4362CChampion 7EC · S/N 7EC-385Cancelled Feb 18, 2003 · Triennial form not returned · Built 1956 · Sweatt Jess E N70021Cessna A185E · S/N 18501896Cancelled Sep 25, 2001 · Triennial form not returned · Perry Dennis T N6278KRepublic RC-3 · S/N 488Cancelled Nov 22, 1994 · Triennial form not returned · Graham Mack H N6902BPiper PA-22-150 · S/N 224174Cancelled May 12, 1994 · Exported to Canada · Maness Harold F N1660APiper PA-22 · S/N 22429Cancelled Feb 10, 1994 · Triennial form not returned · Bailey Oscar H N1686UCessna 207 · S/N 20700286Cancelled Jul 14, 1993 · Triennial form not returned · Pfleger Ludwig H N5458ZCessna U206G · S/N U20606117Cancelled Jul 20, 1992 · Triennial form not returned · Trail Lake Flg Svc Inc N9985MCessna 207A · S/N 20700775Cancelled Jun 21, 1991 · Built 1984 · Trail Lake Flying Service Inc N7479DPiper PA-18-150 · S/N 185814Cancelled May 1, 1991 · Triennial form not returned · Wassom Jess M N70418Cessna A185F · S/N 185-02161Cancelled Feb 8, 1983 · Seward Marine Services Inc N39CFCessna 180H · S/N 18052270Cancelled May 6, 1981 · Built 1972 · Seward Marine Services Inc N3076ACessna 170B · S/N 25720Cancelled Jul 11, 1977 · Built 1952 · Peed John E N2852EAeronca 7AC · S/N 7AC6435Cancelled Dec 16, 1970 · Holben Melvin H N43605Taylorcraft BC12-D · S/N 7264Cancelled Oct 19, 1970 · Goresen Thomas N2495APiper PA-18A-135 · S/N 18-1973Cancelled Sep 21, 1970 · Billy Kane N4738APiper PA-18-150 · S/N 18-4963Cancelled Jun 29, 1970 · Clarence Labounty N8180DPiper PA-18-150 · S/N 18-6125Cancelled May 21, 1965 · William J Anrig N6855HPiper J3C-65 · S/N 20190Cancelled May 20, 1965 · Joe Stanton N3886PPiper PA-18A 150 · S/N 18-4719Cancelled Nov 29, 1963 · Gilliland Air Service N33418Piper J5A · S/N 5-508Cancelled Jan 9, 1959 · Stanton Joseph D N66889Cessna T-50 · S/N 6451Cancelled Mar 5, 1956 · Martin Robert I N22365Aeronca 50-L · S/N L-3649Cancelled Oct 6, 1955 · Duncan Arthur L N6476KRepublic RC-3 · S/N 731Cancelled Sep 21, 1953 · Trakowski Bernice N6044KRepublic RC-3 · S/N 219Cancelled Oct 28, 1952 · Hall Harry D N4060CStinson 108-3 · S/N 108-5060Cancelled May 21, 1952 · Safeway Airways N91001Cessna T-50 · S/N 5276Cancelled Jan 26, 1949 · Richardson P F N34655Stinson 10A · S/N 7965Cancelled Aug 17, 1948 · Ray G Banister N9135DPiper PA-18A 150 · S/N 18-6519Cancellation date not recorded · La Bounty Clarence

Back to Seward, AK