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.

N2076NCessna 140 · S/N 12312Cancelled May 18, 2000 · Krinitsyn Ilia NN5558KRaven Industries RALLY RX7 · S/N RX7-138Cancelled Nov 15, 1999 · Triennial form not returned · Sky Sculptures IncN3209HBell 206B · S/N 4212Cancelled Aug 2, 1999 · Exported to India · US Dept Of EnergyN593HPBeech B-60 · S/N P-593Cancelled Jun 23, 1999 · Exported to Germany · Milne Le RoyN700LFBeech 58P · S/N TJ-123Cancelled Jun 15, 1999 · Eastern Oregon Fast Freight IncN24683Beech B19 · S/N MB573Cancelled Dec 21, 1998 · Premier Jets IncN2609XCessna P206 · S/N P2060109Cancelled Nov 10, 1998 · Exported to Mexico · Mosley RogerN224GMKaman Aerospace K-1200 · S/N A940022Cancelled Oct 15, 1998 · US Bancorp Leasing & FinancialN8165EMooney M20C · S/N 1976Cancelled Oct 15, 1997 · Triennial form not returned · Dwyre Michael ChipN23QTEllis Melvin L QUICKIE Q-2 · S/N 0023Cancelled Sep 13, 1997 · Triennial form not returned · Metzger Paul LN9612FHughes 269C · S/N 700019Cancelled Aug 20, 1997 · Exported to Costa Rica · Kootenay HelicopterN6788XCessna 310F · S/N 3100088Cancelled Aug 12, 1997 · Triennial form not returned · Niendorf John RN90BEBeech E-90 · S/N LW333Cancelled Jun 10, 1997 · Exported to Mexico · Randsburg CorpN8047Bell H13G · S/N 527988Cancelled May 29, 1997 · Triennial form not returned · Portland Community College DistN8046Bell H13G · S/N 527877Cancelled Apr 30, 1997 · Triennial form not returned · Portland Community College DistN8049Bell H13G · S/N 527989Cancelled Apr 30, 1997 · Triennial form not returned · Portland Community College DistN234CHBoeing-Vertol 234LR · S/N MJ001Cancelled Mar 13, 1997 · Exported to Canada · Columbia Helicopters Leasing IncN6544CAerostar International S-60A · S/N S60A3072Cancelled Feb 19, 1997 · Triennial form not returned · Shields Jeff DN9321UCessna 150M · S/N 15078271Cancelled Jan 7, 1997 · Exported to Philippines · Bp Leasing AssociationN96248Taylorcraft BC12-D · S/N 8548Cancelled Sep 25, 1996 · Triennial form not returned · Wold Harlan NN9920SRockwell International 700 · S/N 70020Cancelled Sep 6, 1996 · Triennial form not returned · Hessel John CN6621KRepublic RC-3 · S/N 894Cancelled Sep 4, 1996 · Exported to Cyprus · Hanschka Mark RN4109VWille Chad C VANCRAFT · S/N 009Cancelled Apr 29, 1996 · Vanek CharlesN4MFFredette M R/Fredette S R RV-4 · S/N 3805Cancelled Mar 20, 1996 · Fredette Michael RN17LFFreeman Larry & Shirley VARI-EZE · S/N 1395Cancelled Oct 12, 1995 · Triennial form not returned · Freeman Larry JN32238Stinson 10A · S/N 7886Cancelled May 20, 1995 · Triennial form not returned · Snell Roy EN191WBCessna 210C · S/N 21062168Cancelled Apr 24, 1995 · Triennial form not returned · Frank R J JrN9327Ruedi SCORPION TOO · S/N 4905Cancelled Mar 28, 1995 · Triennial form not returned · Ruedi Paul AN731DKCessna P210N · S/N P21000444Cancelled Mar 6, 1995 · Exported to Mexico · Karcher Benjamin RN4941BBeech J35 · S/N D 5545Cancelled Feb 1, 1995 · Ballard Robert JN1404XAerofab LAKE LA-250 · S/N 44Cancelled Nov 7, 1994 · Triennial form not returned · Moore Stuart WN2844BBeech B36TC · S/N EA470Cancelled Aug 15, 1994 · Exported to Germany · Timacon IncN8266RBellanca 17-31A · S/N 3277Cancelled Aug 9, 1994 · Triennial form not returned · Bash Gail SN65664Rockwell International 695 · S/N 95044Cancelled May 13, 1994 · Exported to Japan · Flightcraft International LtdN193CHBoeing Vertol V-107-II-14 · S/N 402Cancelled Apr 19, 1994 · Exported to Canada · Built 1963 · Columbia Helicopters IncN204PCMesserschmitt-Boelkow-Blohm BO-105S · S/N S783Cancelled Mar 1, 1994 · Triennial form not returned · Pacificorp Trans IncN8129ABeech B200 · S/N BB1405Cancelled Jan 19, 1994 · Exported to Philippines · Flightcraft IncN8472CPiper PA-34-220T · S/N 348233043Cancelled Jan 18, 1994 · Triennial form not returned · River City Flying Service IncN5673SRaven Industries RX6 · S/N RX6308Cancelled Dec 7, 1993 · Triennial form not returned · Columbia Bookkeeping Service IncN2830Hawker Siddeley HS.125 SERIES 700A · S/N NA0323Cancelled Jul 29, 1993 · Exported to India · Mar Flite Ltd CorporationN1415BRoot Byron L BR270 · S/N 01Cancelled Jun 9, 1993 · Triennial form not returned · Root Byron LN584PMBeech C90 · S/N LJ848Cancelled Jan 26, 1993 · Exported to Canada · Flightcraft IncN9000EAerospatiale SA341G GAZELLE · S/N 1471Cancelled Dec 28, 1992 · Triennial form not returned · Teufel Nursery IncN101EDDruckman Elihu I DRUCKMAN 101 · S/N 1004Cancelled Aug 13, 1992 · Chapman Don LN20EQSocata TB21 · S/N 620Cancelled May 20, 1992 · Exported to Canada · Lai FrankN3660WPiper PA-32-260 · S/N 32567Cancelled Apr 2, 1992 · Triennial form not returned · Nepple J GaryN850MAero Commander 500-B · S/N 1376135Cancelled Dec 24, 1991 · Exported to Canada · Warren Robert CN140AKHawker Siddeley DH-125 · S/N 25104Cancelled Dec 11, 1991 · Exported to Canada · Richter Ray LN5162WCessna P210N · S/N P21000647Cancelled Nov 26, 1991 · Triennial form not returned · Hawley BoydN756VQCessna TU206G · S/N U20604394Cancelled Nov 1, 1991 · Exported to Mexico · Padrick Kevin D
Back to Portland, OR