Ketchikan, AK

Cancelled registrations · 137

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

N6449XCessna 180D · S/N 18050949Cancelled Mar 5, 1969 · Exported to Canada · Webber Air Service IncN7110DPiper PA-22-150 · S/N 22-4968Cancelled Jan 3, 1966 · Simpson Air Service IncN34245Taylorcraft BCS12-D · S/N 7703Cancelled Oct 7, 1965 · Houtary HarveyN4490EAeronca 11CC · S/N S11CC-227Cancelled Jun 5, 1965 · Gadbaw Edgar RN45862Luscombe 8A · S/N 2389Cancelled May 20, 1965 · Harvey Mortimer DouthitN5657HPiper PA-16 · S/N 16-268Cancelled May 20, 1965 · Edwin V ToddN4759APiper PA-22-150 · S/N 22-3907Cancelled Feb 25, 1964 · R S RichardsonN1312KLuscombe 8E · S/N 4039Cancelled Sep 27, 1963 · Built 1946 · Cousins JackN4100YCessna 185A · S/N 185-0300Cancelled Sep 26, 1962 · Webber Air Service IncN6732KRepublic RC-3 · S/N 1020Cancelled Oct 9, 1961 · Hollenbeak Lester AN45477Luscombe 8A · S/N 2004Cancelled May 25, 1960 · Built 1946 · Ohneck Wilfred CN5014ECessna 180A · S/N 50314Cancelled Dec 29, 1959 · Ellis Air LinesN6288KRepublic RC-3 · S/N 501Cancelled Apr 11, 1958 · Chapman Kenneth HN2330CCessna 180 · S/N 30630Cancelled Oct 9, 1957 · Ellis AirlinesN3116CCessna 180 · S/N 30915Cancelled Sep 13, 1957 · Ellis AirlinesN1446HAeronca 15AC · S/N 15AC-515Cancelled Aug 9, 1956 · Ellis AirlinesN6405KRepublic RC-3 · S/N 649Cancelled Feb 15, 1956 · Ketchikan Air ServiceN6524KRepublic RC-3 · S/N 790Cancelled Feb 15, 1956 · Whipple CharlesN6721KRepublic RC-3 · S/N 1004Cancelled Feb 15, 1956 · Oaksmith Stanley Jr And Hanson Martin RN71805Luscombe 8A · S/N 3232Cancelled Oct 12, 1955 · Cessnun Edwin JN2186KLuscombe 8A · S/N 4913Cancelled Dec 28, 1954 · Mackenzie R MN991WStinson SM-8A · S/N M-4112Cancelled Oct 15, 1953 · Ketchikan Airways IncN6365KRepublic RC-3 · S/N 594Cancelled Jul 29, 1953 · Johnston William LN2269EAeronca 7AC · S/N 7AC-5843Cancelled Nov 5, 1952 · Madsen Floyd And Earland MckinleyN71314Luscombe 8A · S/N 2741Cancelled Nov 19, 1951 · Ross Donald FN36210Taylorcraft BCS12-65 · S/N 3164Cancelled Aug 14, 1951 · Built 1941 · Simpson Russell WN11642Bellanca 31-42 PACEMAKER · S/N 252Cancelled May 7, 1951 · Ellis Air LinesN88138Piper J3C-65 · S/N 15755Cancelled Mar 2, 1951 · Hanson Martin R And Oaksmith StanleyN86590Grumman G-21A · S/N 1028Cancelled Sep 30, 1950 · Ellis Air LinesN1435HAeronca S15AC · S/N 15AC-499Cancelled Sep 11, 1950 · Ellis AirlinesN256MBellanca CH300 PACEMAKER · S/N 158Cancelled Jul 14, 1950 · Built 1929 · Ellis Air TransportN26492Stinson SR-9E · S/N 5261Cancelled Feb 16, 1950 · Ellis Air TransportN79910Consolidated PBY-5A · S/N 500Cancelled May 23, 1949 · Mackenzie R WN27553Taylorcraft BC-65 · S/N 2195Cancelled May 10, 1948 · Ketchikan Air ServiceN195NBellanca CH300 PACEMAKER · S/N 180Cancelled Mar 17, 1948 · Ellis Air TransportN2428Barkley - Grow T8P-1 · S/N 10Cancelled Apr 2, 1947 · Ellis Air TransportN11661Bellanca CH400 SKYROCKET · S/N 625Cancelled Nov 23, 1944 · Built 1931 · Ellis Air Transort Inc
Back to Ketchikan, AK