Skip to content

Cancelled registrations · 62

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

N3URCessna 310R · S/N 310R0061Cancelled Jun 15, 2023 · Built 1974 · Moroney Aviation LLC N57551Piper PA-18-150 · S/N 18-7809092Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Hale Mitchell D N7267ACessna 172 · S/N 29367Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1956 · R&R Aircraft LLC N320GCessna 310 · S/N 35350Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1956 · Kallenberg Robert C N357WEWendell Kirk Ellis PTUNDRADACTYL · S/N 001Cancelled Feb 13, 2020 · Built 2019 · Ellis Wendell K N2503MPiper PA-12 · S/N 12-1001Cancelled Jul 11, 2019 · Revoked, canceled · Built 1946 · Jackson Charles S N12792Cessna 175 · S/N 55542Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Powell Stephen W N8088ACessna 182 · S/N 33339Cancelled Nov 6, 2018 · Registration pending, canceled N43619Taylorcraft BC12-D · S/N 7278Cancelled Sep 7, 2018 · Registration expired, pending cancellation · Built 1946 · Cloud Roger Allen N11091Champion 7GCBC · S/N 18Cancelled Aug 9, 2018 · Registration expired, pending cancellation · Built 1966 · Archuleta James L N6812DHearnke Don RAVEN · S/N 128Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1996 · Brewer Samuel T N3744JCessna 150G · S/N 15065044Cancelled May 30, 2018 · Sale reported, canceled · Built 1966 N4433NAeronca 15AC · S/N 15AC-322Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1949 · Swartz David D N95165Taylorcraft BC12-D · S/N 9565Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1946 · Cloud Roger A N2195UBrantly B-2B · S/N 406Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1964 · Kallenberg Robert C N1184APiper PA-18-125 · S/N 18-789Cancelled Sep 26, 2016 · Third renewal notice · Built 1951 · Fassler Herbert F N2669GCessna 182B · S/N 51969Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1959 · Booher Mary F N190SStinson 108-2 · S/N 108-2371Cancelled May 2, 2014 · Built 1947 · Simpson John Soren Judson N32224Cessna A185E · S/N 185-1538Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1969 · Wehr Larry E N6630MWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF20900893Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1990 · Vrem Kelly L N94547Cessna 152 · S/N 15285714Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1983 · Ferguson Gordon DBA N9704NMaule M-5-210C · S/N 6030CCancelled Aug 23, 2013 · Sale reported, canceled N6178UPiper PA-18 · S/N 18-5458Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1957 · Boreis Leo G N2389MPiper PA-12 · S/N 12-1511Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1946 · Rosenbach Jay A N29WSSmith William M V 1 · S/N 1-001Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1990 N9510DPiper PA-22-160 · S/N 22-6425Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1958 N5585AWilliams Dale A WILLBIRD NO. 3 · S/N 01Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1980 · Williams Dale A N8675Fairchild Hiller FH-1100 · S/N 89Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1968 · Doyle Ralph N33XBSeal John B RV6 · S/N 21237Cancelled May 3, 2013 · Exported to Canada · Built 1999 · Hart Thomas N625QCessna U206 · S/N U206-0354Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1965 · Walker Scott F N23223Cessna 150H · S/N 15068805Cancelled Feb 11, 2013 · Registration expired, pending cancellation · Built 1968 · Doyle Ralph DBA N29RLAeronca KC · S/N KC-29Cancelled Dec 13, 2012 · Sale reported, pending cancellation N3552TTaylorcraft F19 · S/N F-011Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1974 · Taylor William P Jr N2048UMaule M-4-220C · S/N 2042CCancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1970 · Herning Benjamin N N36110Taylorcraft BC-65 · S/N 3077Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1941 · Parks Walter G N671XNix Kenneth E AVID FLYER · S/N 67Cancelled Aug 23, 2012 · Registration pending, canceled N9654SChampion 7GCBC · S/N 52Cancelled Aug 22, 2012 · Registration pending, canceled · Built 1966 N1560CCessna 180 · S/N 30260Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1953 · Kowalski Ronald W N183CStinson 108-2 · S/N 108-3183Cancelled Aug 1, 2012 · Sale reported, canceled · Built 1947 N4601ACessna 180 · S/N 32199Cancelled Mar 2, 2011 · First renewal notice · Built 1956 · Beam Douglas Jade N5049ACessna 172 · S/N 28049Cancelled Oct 16, 2007 · Built 1955 · Smoke William A N4488BCessna 170B · S/N 26832Cancelled Apr 11, 2007 · Triennial form not returned · Built 1955 · Erb Wes S N543BPBrackett And Peltz KIT FOX III · S/N 877Cancelled Mar 12, 2007 · Triennial form not returned · Thomson James D N60859Cessna A185F · S/N 18504064Cancelled Dec 31, 2001 · Triennial form not returned · Built 1980 · Shuman Cecil R N7MTJennings Melvin T SUPER S · S/N F 232-1Cancelled Jul 20, 2001 · Triennial form not returned · Jennings Melvin T N8115UCessna 150M · S/N 15077888Cancelled Oct 30, 1999 · Triennial form not returned · Howe Scott E N7472MCessna 175 · S/N 55772Cancelled May 5, 1999 · Triennial form not returned · Bailey Klondys M N97901Stinson 108 · S/N 108901Cancelled Apr 3, 1998 · Shannon Parker J N4017RPiper PA-32-300 · S/N 3240313Cancelled Aug 16, 1993 · Erbey Roland N1139APiper PA-18 · S/N 18739Cancelled Jun 18, 1991 · Triennial form not returned · Kachline Dale

Back to Chugiak, AK