OpenAirDocs.org
Albany, OR

Cancelled registrations · 123

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 = 'OR' AND d.registrant_city = 'ALBANY'
  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.

N79161Cessna 172K · S/N 17257926Cancelled Feb 18, 1977 · Exported to South Africa · Burris Daniel LN4173UCessna 150D · S/N 15060173Cancelled Jun 2, 1975 · Built 1964 · Smette Merlyn JN55065Boeing A75 · S/N 75238Cancelled Dec 20, 1974 · Smith Gary DaleN5650ACessna 172 · S/N 28250Cancelled Oct 31, 1974 · Exported to Canada · Grainger Loydee SN7276ZPiper PA-25-235 · S/N 25-3213Cancelled Jun 12, 1974 · Albany Ag-Air IncN19990Cessna 172M · S/N 17260916Cancelled May 1, 1974 · Exported to Canada · Flyways IncN8578WPiper PA-28-235 · S/N 28-10090Cancelled Mar 23, 1973 · Exported to Canada · Flyways IncN5805GCessna 150K · S/N 15071305Cancelled May 9, 1972 · Exported to Canada · Flyways IncN75771Sikorsky S-55 · S/N 55434Cancelled Apr 7, 1972 · Exported to Canada · Albany Airways IncN3625JCessna 150G · S/N 15064925Cancelled Jan 7, 1972 · Albany Airways IncN9505VMooney M10 · S/N 69006Cancelled Nov 29, 1971 · Albany Airways IncN612APiper PA-22 · S/N 22-15Cancelled Nov 23, 1970 · Avery Alfred CN7163XCessna 150A · S/N 15059263Cancelled Jun 25, 1970 · Griffith James LN7895VMooney M20E · S/N 602Cancelled Jul 9, 1968 · Built 1965 · Mcwhorter Floyd DN5278HPiper PA-16 · S/N 16-82Cancelled May 23, 1968 · Exported to Canada · Albany Airways IncN6739FCessna 150F · S/N 15063339Cancelled May 23, 1968 · Exported to Canada · Built 1966 · Albany Airways IncN9246MMooney M20C · S/N 3449Cancelled Nov 13, 1967 · Albany Airways IncN1824KLuscombe 8F · S/N 4551Cancelled Dec 13, 1962 · Built 1946 · Blake Allen/Van Hoosen Freddie RobertN67290Cessna T-50 · S/N 4286Cancelled Apr 11, 1962 · Jones A ElmerN8183EMooney M20A · S/N 1454Cancelled Sep 15, 1959 · Built 1959 · Draper JackN9048KStinson 108-1 · S/N 108-2048Cancelled Jun 6, 1955 · Albany Flying ClubN49099Taylorcraft DCO-65 · S/N L-5223Cancelled Feb 13, 1951 · Blodgett Cyrus LN908WStinson SM-8A · S/N 4056Cancelled Jul 7, 1949 · Built 1930 · Burlseson Howard
Back to Albany, OR