OpenAirDocs.org
Portland, OR

Cancelled registrations · 944

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

N4126WPiper PA-32-300 · S/N 32-40191Cancelled Oct 23, 1974 · Aero Flite Center IncN51639Maule M-5-210C · S/N 6046CCancelled Sep 27, 1974 · Exported to Canada · Vancouver Flying ServiceN6629XCessna 210A · S/N 21057629Cancelled Sep 27, 1974 · Exported to Canada · Wyatt Roy TN6111NBeech B23 · S/N M-1196Cancelled Sep 11, 1974 · Exported to Canada · Flightcraft IncN3888BBeech F35 · S/N D-4164Cancelled Aug 29, 1974 · Exported to Paraguay · Friesen SusanaN9269QBeech 58 · S/N TH232Cancelled Aug 21, 1974 · Pacific Saw And Knife CoN4010CUniversal Stinson 108-3 · S/N 108-5010Cancelled Aug 7, 1974 · Exported to Canada · Built 1958 · Mehrer Wilbert LN9077FHughes 369HE · S/N 1090204ECancelled Jul 1, 1974 · Exported to Canada · Wagner HaroldN7908VAero Commander CALLAIR A-9B · S/N 1556Cancelled May 13, 1974 · Barr ClayN72603Cessna 140 · S/N 9775Cancelled May 8, 1974 · Executive Aircraft Sales IncN5301HPiper PA-16 · S/N 16106Cancelled Apr 24, 1974 · Exported to Canada · White Charles & JanetN4714FCessna P206B · S/N P2060314Cancelled Apr 2, 1974 · Exported to Canada · Stahl Robert A And Stahl Marie RN58661Cessna 182 · S/N 182-62215Cancelled Mar 1, 1974 · Cason West And Seales Const CoN8977FHughes 269C · S/N 230188Cancelled Oct 3, 1973 · Exported to New Zealand · Built 1973 · Wagner Harold AN2730PPiper PA-22 · S/N 22-3036Cancelled Sep 13, 1973 · Fleetwood LloydN74114Vancraft 2 · S/N CAV-5462Cancelled Aug 16, 1973 · Built 1964 · Saunders Don RN9508ACessna 170A · S/N 19378Cancelled Jun 28, 1973 · Veldhuizen C AN1208TPiper PA-32-300 · S/N 32-7240108Cancelled Jun 26, 1973 · Built 1972 · Trans Pac Leasing IncN138JHoward DGA-15P · S/N 983Cancelled Jun 26, 1973 · White H AN11PKShockley-Bush POWER KITE A · S/N 0000001Cancelled Jun 5, 1973 · Shockley Donald PN74064Gyrocopter Z3-65M · S/N 3Cancelled Jun 4, 1973 · Built 1965 · Bond John SN7498MCessna 175 · S/N 55798Cancelled Jun 4, 1973 · Built 1959 · S T F Flying ClubN79230Cessna 172K · S/N 17257982Cancelled May 7, 1973 · Groce Robert AN673BBeech A35 · S/N D-1674Cancelled Dec 1, 1972 · Exported to Nicaragua · Herndon & OfeltN96698Taylorcraft BC12-D · S/N 8998Cancelled Nov 20, 1972 · West Coast Aerial Adversing CoN9733Beech UC-45J · S/N 89491Cancelled Nov 15, 1972 · Portland Community CollegeN704GPBeech G18S · S/N BA-501Cancelled Oct 3, 1972 · Exported to Canada · Georgia-Pacific CorporationN77650Beech UC-45J · S/N 29664Cancelled Sep 27, 1972 · Portland Community CollegeN5893RCessna 172G · S/N 17253562Cancelled Sep 7, 1972 · Rothell Garnet AN609FFConsolidated Vultee PBY-5A · S/N 369Cancelled Aug 25, 1972 · Exported to Australia · Built 1943 · Firefly IncN23WBeech 65-A90 · S/N LJ-168Cancelled Jul 7, 1972 · Exported to Mexico · Flightcraft IncN3084ZPiper PA-18A 150 · S/N 18-7139Cancelled Jun 7, 1972 · Exported to Canada · Built 1959 · Whitehead Ernest GN8368HStinson L-5E · S/N 44-17466Cancelled May 5, 1972 · Civil Air PatrolN3692QBeech A23A · S/N M1060Cancelled Mar 30, 1972 · Built 1967 · Oregon Airmotive IncN2116GCessna 182A · S/N 51416Cancelled Mar 14, 1972 · Exported to Canada · Tragis John VN610FFConsolidated Vultee PBY-5A · S/N 399Cancelled Jan 18, 1972 · Firefly IncN3912YCessna 210D · S/N 210-58412Cancelled Jan 12, 1972 · American-Federal Lease CorpN6067EBeech K35 · S/N D-6012Cancelled Jan 2, 1972 · Klones Harold And Bob BergereN58833Consolidated Vultee BT-13A · S/N 7572Cancelled Dec 7, 1971 · C BettingerN151GBeech E18S · S/N BA-401Cancelled Dec 1, 1971 · Georgia Pacific CorpN9220JPiper PA-28-180 · S/N 28-3290Cancelled Aug 26, 1971 · Poschwatta Carl LN9473FHughes 269B · S/N 0270Cancelled Aug 9, 1971 · Exported to China · Wagner Harold AN74131Semco Balloon 30-AL · S/N SEM-1Cancelled Jul 26, 1971 · Johnson Robert FN7345DPiper PA-22-150 · S/N 22-5134Cancelled Jul 4, 1971 · Jacobson Bruce EN3682YCessna 210C · S/N 21058182Cancelled Jun 16, 1971 · Rogers John VN7689NBeech 65-B80 · S/N LD-389Cancelled May 5, 1971 · Exported to Colombia · Flightcraft IncN7831LBeech 65-B80 · S/N LD382Cancelled May 4, 1971 · Exported to Colombia · Flightcraft IncN1301ZBeech B95A · S/N TD-461Cancelled Apr 22, 1971 · Flightcraft IncN729CStinson 108-3 · S/N 108-3729Cancelled Apr 8, 1971 · Harris Donevan CN7835LBeech 65-B80 · S/N LD-348Cancelled Apr 2, 1971 · Exported to Peru · Built 1967 · Flightcraft Inc
Back to Portland, OR