Skip to content

Cancelled registrations · 308

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

N907VWWraith Lane WA SPORTSMAN 2+2 · S/N 534Cancelled Sep 29, 2026 · Built 2023 · Wraith Lane T N6256HPiper J3C-65 · S/N 19436Cancelled Sep 5, 2026 · Sale reported, canceled N2167FCessna U206 · S/N U206-0367Cancelled Jul 11, 2026 · Sale reported, canceled · Built 1965 N7605KCessna 180J · S/N 18052687Cancelled Jul 4, 2026 · Registration pending, canceled N8655EPiper PA-18-150 · S/N 18-4984Cancelled Jul 4, 2026 · Registration pending, canceled N70717Piper J3C-65 · S/N 17734Cancelled May 26, 2026 · Registration pending, pending cancellation N8190HCessna 180B · S/N 50459Cancelled May 26, 2026 · Registration pending, pending cancellation N4569UCessna 150D · S/N 15060569Cancelled Apr 18, 2026 · Registration pending, canceled · Built 1964 N8240ACessna 170B · S/N 25092Cancelled Jul 7, 2025 · Registration pending, canceled · Built 1952 N4495SBeech A36 · S/N E-712Cancelled Dec 28, 2024 · Sale reported, canceled · Built 1975 N8787TCessna 182C · S/N 52687Cancelled Dec 28, 2024 · Registration pending, canceled · Built 1960 N7367XCessna 150B · S/N 15059467Cancelled Aug 10, 2024 · Sale reported, canceled · Built 1961 N1364HAeronca 15AC · S/N 15AC-412Cancelled Jun 1, 2024 · Registration pending, canceled N2886MPiper PA-12 · S/N 12-1432Cancelled Jun 1, 2024 · Registration pending, canceled · Built 1946 N567NAEurocopter AS 350 B2 · S/N 2753Cancelled May 9, 2024 · Exported to Canada · Built 1993 · Jc Aircraft Leasing LLC N39975Taylorcraft BC12-D · S/N 6634Cancelled Oct 7, 2023 · Sale reported, canceled · Built 1946 N2142NCessna 140 · S/N 12378Cancelled Aug 1, 2023 · Built 1947 · Carleton Jeffrey S N1311FCessna 172G · S/N 17254806Cancelled Jun 28, 2023 · Built 1966 · Dudley Benjamin H N99640Piper PA-18-135 · S/N 54-2642Cancelled Jun 17, 2023 · Sale reported, canceled N413MBHughes Helicopters HUGHES 369D · S/N 190451DCancelled Jun 1, 2023 · Exported to Canada · Jc Aircraft Leasing LLC N8671VBellanca 7GCBC · S/N 825-75Cancelled May 10, 2023 · Registration pending, canceled · Built 1975 N1946APiper PA-18AS-125 · S/N 18-1783Cancelled Apr 8, 2023 · Registration expired, pending cancellation · Built 1952 · Smith Richard W N2005LLake LA-4 · S/N 338Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1966 · Higgins Michael D N797TTDJI INSPIRE 1 · S/N W13DBL17010112Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Alaska Aerial Survey LLC N1401HAeronca 15AC · S/N 15AC-452Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Walters Lance C N9666JPiper PA-28-180 · S/N 28-3835Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Ehrler Charles David N4551APiper PA-22-150 · S/N 22-3861Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1956 · Snyder Logan J N740XRDJI PHANTOM 2 · S/N PH645117896Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Olson Tyler W N740YTDJI FLAMEWHEEL F550 · S/N 12210047Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Olson Tyler W N775AKRobinson Helicopter R44 · S/N 1875Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 2008 · Rotors LLC N1380HAeronca 15AC · S/N 15AC-466Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Eaddy Ned M N6716BPiper PA-22-150 · S/N 22-4049Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1956 · Adams Frank J N8520DPiper PA-20 · S/N 22-5748Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Donelson Patrick N7883MMike Rolston X2 CUB · S/N 1616Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 2019 · Rolston Mike N1098APiper PA-18 · S/N 18-686Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Lofstrom David J N150LTPiper PA-18A 150 · S/N 18-7718Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Morrison Shelly N530AMCessna 150K · S/N 15071968Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1970 · Cooley Dennis A DBA N8741KStinson 108-1 · S/N 108-1741Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1947 · Curry Paul M N473LRJason Collins SKY RAIDER · S/N 47321Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2011 · Brewer Samuel T N3178EAeronca 11AC · S/N 11AC-1518Cancelled Mar 29, 2022 · Sale reported, canceled · Built 1946 N18UPSweeney James P PRECEPTOR ULTRA PUP · S/N 1Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Wilson Sherry R N9959QPiper PA-18-135 · S/N 54-2543Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1955 · Okonek Timothy J N3438YCessna 180H · S/N 18051938Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1968 · Yundt Robert D N8501CPiper PA-20 · S/N 20-988Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1953 · Watters Denis O N53JEJohnny Evans JE-12 · S/N JE12-001Cancelled Jan 7, 2022 · Built 2013 · Redick Donald K N61421Schweizer 269C-1 · S/N 0028Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1996 · Bash Dennis W Jr N4823APiper PA-22-150 · S/N 22-3976Cancelled Nov 6, 2021 · Sale reported, canceled N3934DCessna 182A · S/N 34634Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1957 · Price Jeremy D N88283Piper J3C-65 · S/N 15901Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Straight Gary D N9784KPiper PA-28-181 · S/N 28-7890179Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Myers Cecilia C

Back to Wasilla, AK