Juneau, AK

Cancelled registrations · 184

Query with SQL
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 = 'JUNEAU'
  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.

N1747DCessna 170A · S/N 20190Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1951 · Smith Todd W AN5730GCessna 150K · S/N 15071230Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1969 · Southeast Scientific Research Assoc DBAN42250Cessna 180J · S/N 18052331Cancelled Jun 22, 2015 · First renewal notice · Built 1973 · Ward Kenneth RN5232XChampion 7KCAB · S/N 210Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1969 · Hargraves Coe BN1250KLuscombe 8A · S/N 3977Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1946 · Blanchfield Gregory LN3539FCessna A185E · S/N 185-1439Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1968 · Northstar Aviation LLCN29722Taylorcraft BC12-65 · S/N 2569Cancelled Dec 22, 2014 · Registration pending, canceled · Built 1941N5569CCessna 170A · S/N 19622Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1950 · Hewitt Steven JN7947WPiper PA-28-180 · S/N 28-1991Cancelled Dec 16, 2014 · Registration pending, canceled · Built 1964N2229RTaylorcraft BF-65 · S/N 3100Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Sorensen Allen LN9350XCessna 182E · S/N 18253750Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1962 · Andrews Brian CN95795Taylorcraft BC12-D · S/N 8095Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Lingle Gary JN6332NChampion 7ECA · S/N 299Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Grant Warren EN5624MTaylorcraft BC12-D · S/N 12024Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1948 · Barber Jeffrey AN653RBBreffeilh Robert A EXEC 162F · S/N 6290Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Breffeilh Robert AN4346BCessna 170B · S/N 26690Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1955 · Walker Ernest RN88BJRockwell International 690C · S/N 11627Cancelled Mar 26, 2014 · Exported to Canada · Built 1980 · Irwin Management LLCN1901ZCessna 150C · S/N 15059701Cancelled Nov 1, 2013 · Built 1962 · Alaska Flight Center IncN45830Luscombe 8A · S/N 2357Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1946 · Shelley Robert RN467SRCessna 150H · S/N 15069050Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1968 · Warren Roy AN2584GCessna 182B · S/N 51884Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1959 · Teel PhilN97342Stinson 108 · S/N 108-342Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Gucker Jack BN5563FPiper PA-34-200T · S/N 34-7770023Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1976N1541APiper PA-20S · S/N 20-736Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1952 · Whitehead Paul EN327XMaule M-5-210C · S/N 6148CCancelled Aug 5, 2013 · Sale reported, canceled · Built 1975N2592APiper PA-22 · S/N 22-873Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1952N441BBeech K35 · S/N D-5943Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1959 · Colvin John KirkN9RSSwansen Roger D RV-4 · S/N 7Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1986 · Killian April BN4448PCessna 180 · S/N 31950Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1955 · Carhart Jane PN1092VCessna R172K · S/N R1722115Cancelled Jun 5, 2013 · Sale reported, canceled · Built 1976N35742Piper J5A · S/N 5-744Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1941 · Brown FrankaN9276Enstrom F-28A · S/N 250Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1974 · Blanchfield Gregory LN9331GCessna 182P · S/N 18260871Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1971 · Love Lewis CN9101EMaule M-5-235C · S/N 7096CCancelled May 17, 2013 · Registration expired, pending cancellation · Built 1977 · Crass Thomas SN8173QCessna U206F · S/N U20603101Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1975 · Intraco CorpN7025BPiper PA-22-150 · S/N 22-4276Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1956 · Graves Kenneth DN776AXDornier DO 27 B1 · S/N 103Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1956 · Blanchfield Gregory LN12SZPiper PA-12 · S/N 12-2154Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Sztuk Konkey SN89998Piper PA-18-150 · S/N 18-8117Cancelled Mar 26, 2013 · Exported to Canada · Belflower Estol Royal TrusteeN998CUniversal Stinson 108-3 · S/N 108-3998Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1947N57875Consolidat/US Hist Acft Museum OA-10 · S/N 4433954Cancelled Mar 6, 2013 · Sale reported, pending cancellationN6500MStinson 108-3 · S/N 108-4500Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1948N59186Cessna U206F · S/N U20602630Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1974N41355Piper J5A · S/N 5-1342Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1941 · Gonder Carl M JrN3897MPiper PA-12 · S/N 12-2797Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1947 · Caldwell Raymond LN85070Aeronca 7AC · S/N 7AC-3797Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1946N6320MStinson 108-3 · S/N 108-4320Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1948N5633YMaule M-5-235C · S/N 7272CCancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1979N87458Republic RC-3 · S/N 8Cancelled Sep 18, 2012 · Revoked, canceled · Built 1946 · Burns William LN243AAPiper PA-32-260 · S/N 32-774Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1966
Back to Juneau, AK