Lewiston, ID

Cancelled registrations · 127

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 = 'ID' AND d.registrant_city = 'LEWISTON'
  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.

N7411WPiper PA-28-180 · S/N 28-1298Cancelled Jul 15, 1968 · Exported to Canada · Spencer VadeN2876BBell 47G-2 · S/N 1971Cancelled Aug 14, 1967 · Exported to India · Hillcrest Aircraft Co IncN4132DHelio H-391B · S/N 079Cancelled Oct 28, 1965 · Martin ClydeN4158ACurtiss Wright C-46A · S/N 347011Cancelled Feb 23, 1962 · Exported to Panama · Rensink Ralph WN9635BCessna 180A · S/N 32932Cancelled Jan 2, 1962 · Exported to Australia · Hillcrest Aircraft CoN3192PPiper PA-23 · S/N 23-1130Cancelled Dec 27, 1960 · Built 1957 · Walker MadelineN3350VBeech 35 · S/N D 814Cancelled Aug 4, 1958 · Johansson Arthur NN15910Piper E-2 · S/N 356Cancelled Jan 7, 1957 · Zimmerly Albert L DBA Zimmerly Air TransportN63572Fairchild M-62A-3 · S/N FC-207Cancelled Oct 12, 1955 · Alexander Sam JN76858Cessna 140 · S/N 11292Cancelled Apr 1, 1955 · Crary Robert EN69537Cessna T-50 · S/N 2257Cancelled Jan 25, 1955 · Hillcresrt Aircraft CoN2009HEngineering & Research 415-C · S/N 2632Cancelled Sep 21, 1953 · Built 1946 · Zirbel D BN49339Consolidated Vultee BT-13B (SNV-2) · S/N 79814Cancelled Feb 27, 1951 · Zimmerly Albert LN6404MStinson 108-3 · S/N 108-4404Cancelled Jan 26, 1951 · Rosencranz JoeN31624Howard DGA-18 · S/N 624Cancelled Mar 7, 1950 · Built 1941 · Young Richard AN2534EAeronca 7AC · S/N 7AC-6116Cancelled Aug 30, 1949 · Hillcrest AircraftN49417Fairchild M-62A · S/N T41-763Cancelled Jul 29, 1949 · Hillcrest Aircraft CoN93454Ercoupe 415-C · S/N 777Cancelled Jul 26, 1949 · Melena C Leonard& Gustin A ClarenceN2681EAeronca 7AC · S/N 7AC-6261Cancelled Jun 6, 1949 · Hillcrest Aircraft CompanyN2268EAeronca 7AC · S/N 7AC-5842Cancelled Feb 8, 1949 · Hillcrest AircraftN49338Consolidated Vultee BT-15 · S/N 9595Cancelled Dec 29, 1948 · Montague Dorothy MN77387Cessna 140 · S/N 11828Cancelled Sep 9, 1948 · Built 1946 · Zimmerly Albert L/DBA Zimmerly AirN3010VBeech 35 · S/N D-412Cancelled Jun 8, 1948 · Smith Keith SN3003EAeronca 7AC · S/N 7AC-6589Cancelled May 11, 1948 · Hillcrest Aircraft CoN13310Boeing 247D · S/N 1691Cancelled Apr 9, 1948 · Built 1933 · Empire Airlines IncN243MKreutzer K-5 · S/N 110Cancelled Jul 6, 1940 · Built 1929 · Lewiston Air Service IncN12713Heath V · S/N 1Cancelled Oct 14, 1932 · Built 1931 · Gregory E J & Gallaugher H H
Back to Lewiston, ID