Skip to content

Cancelled registrations · 67

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

N15135Stinson SR-6B · S/N 9637Cancelled Jan 3, 2023 · Revoked, canceled · Built 1935 · Shanahan Paul H Co Ow N15016Bellanca 31-42 PACEMAKER · S/N 810Cancelled Jan 24, 2022 · Revoked, canceled · Built 1935 · White Thomas A N5409HPiper PA-14 · S/N 14-521Cancelled Jan 31, 2020 · Revoked, canceled · Built 1949 · Jackson Gene C N22231Taylorcraft BF · S/N 1177Cancelled Oct 4, 2019 · Revoked, canceled · Built 1939 · Oines Donald A N21806Piper J3C-65 · S/N 2595Cancelled Aug 29, 2019 · Revoked, canceled · Built 1938 · Parsons Charles C N7127HPiper J3C-65 · S/N 20380Cancelled Jul 8, 2019 · Revoked, canceled · Built 1946 · Neely James F N97043Stinson 108-2 · S/N 1081043Cancelled Jul 26, 2018 · Revoked, canceled · Built 1946 · Droege R E N1366HAeronca 15AC · S/N 15AC414Cancelled Jul 19, 2018 · Revoked, canceled · Built 1949 · Walker Gene R N3551APiper PA-22-135 · S/N 22-1825Cancelled Mar 16, 2018 · Revoked, canceled · Built 1953 · Powell Maurice E N57XFinholt GYROPLANE · S/N 101-ACancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Lance Joe E N70963Piper J3C-65 · S/N 17988Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Johnson Jim E N75916Consolidated Vultee BT-13A · S/N 1942Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Donnelly Edward E N8563DPiper PA-18-150 · S/N 18-6213Cancelled Nov 21, 2017 · Revoked, canceled · Built 1958 · Bontrager Allen N96933Taylorcraft BF · S/N 9233Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Engle Robert H N3740MPiper PA-12 · S/N 12-2677Cancelled Nov 18, 2017 · Revoked, canceled · Built 1947 · Sieber Robert V N274BColonial C-2 · S/N 132Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Fairchild B H N7497DPiper PA-18-150 · S/N 18-5836Cancelled Feb 4, 2017 · Revoked, canceled · Built 1957 · Alaska Farm Suppl8 N76739Cessna 140 · S/N 11171Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Thomas Carol B N7675HPiper PA-12 · S/N 12-555Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Colberg James William N7747ACessna 180 · S/N 32644Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Alaska Aeronautical Industries N1023LLake LA-4 · S/N 266Cancelled Sep 9, 2016 · Revoked, canceled · Built 1961 · Mcculloch C W N1359EAeronca 7AC · S/N 7AC-4920Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1946 · Pettijohn Elbert T N90103Cessna 140 · S/N 9164Cancelled May 5, 2015 · Revoked, pending cancellation · Built 1946 · Lagneaux Irving J N7429BChampion 7EC · S/N 7EC-467Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1956 · Pettijohn Elbert T N95586Taylorcraft BF · S/N 7886Cancelled Feb 26, 2013 · Revoked, canceled · Built 1946 · Gernand M E N4033HPiper PA-12 · S/N 12-3463Cancelled Nov 29, 2012 · Revoked, canceled · Built 1947 · Bratton Thomas E N61688Cessna T-50 · S/N 6700Cancelled Aug 30, 2012 · Revoked, canceled · Built 1944 · Stevenson R J N64700Cessna T-50 · S/N 6556Cancelled Mar 7, 2011 · Registration pending, pending cancellation · Built 1943 N7151Piper PA-20 · S/N 20-800Cancelled Aug 11, 1980 · Snell Donald C N6416CBeech C18S · S/N 501Cancelled May 9, 1975 · Crow Richard E Or Crow Charlene A N1032HAeronca 15AC · S/N 15AC-35Cancelled Nov 2, 1973 · Brookman Gerald N63097Stinson L-5 · S/N 76-186Cancelled Sep 4, 1973 · Long J Robert N4177YCessna 185A · S/N 185-0377Cancelled Jun 22, 1973 · Alaska Air Guider Inc N981DStinson 108-2 · S/N 108-2981Cancelled Dec 18, 1972 · Thompson Roberta L N7692ACessna 180 · S/N 32589Cancelled Jun 14, 1972 · Laveulette Richardowen N4968FCessna U206B · S/N U206-0668Cancelled Jun 2, 1972 · Jacobson Gordon N232TPiper PA-18 105 · S/N 18-2346Cancelled Aug 24, 1971 · Tiedje Gary L Etal N2782SCessna 150G · S/N 15066682Cancelled Mar 19, 1971 · Dodson Warren A N8571CPiper PA-18 · S/N 18-2724Cancelled Feb 16, 1971 · Penney Robert C N6772BPiper PA-18A 150 · S/N 18-5005Cancelled Jan 4, 1971 · Lockwood Fred A N2758ABoeing YL-15 · S/N 47-423Cancelled Sep 17, 1970 · Clement Dick & Baker John N1570APiper PA-20 · S/N 20-781Cancelled Sep 15, 1970 · Victor L Fondy N88061Piper J3C-65 · S/N 15677Cancelled Jun 29, 1970 · Roy Edward Siefker N6854BPiper PA-24-260 · S/N 224155Cancelled Jun 23, 1970 · Built 1956 · Rhett Harold E N4203EAeronca S11CC · S/N 11CC-99Cancelled Jun 8, 1970 · Aurbo Flying Club Inc N2003XCessna Wren 182H 460 · S/N 18256103Cancelled Nov 9, 1965 · Gonzales Joe DBA Anchorage Roofing Co Inc N8805KStinson 108-1 · S/N 108-1805Cancelled May 26, 1965 · Wm J Phelps N1262HAeronca 15AC · S/N 15AC-274Cancelled May 25, 1965 · George W Roland N9673BCessna 180 · S/N 32970Cancelled May 21, 1965 · Stevenson Excavating Co N98126Piper J3C-65 · S/N 18280Cancelled May 21, 1965 · Steve Hatch

Back to Spenard, AK