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.

N97283Cessna 172P · S/N 17276174Cancelled Aug 29, 2019 · Exported to Mexico · Built 1984 · Rti Aircraft Sales LLCN290MQAirbus Helicopters EC225 LP · S/N 2909Cancelled Aug 20, 2019 · Exported to China · Integrity Aircraft Title Holdings LLCN5173FPioneer Intl FS 21000 · S/N 349Cancelled Jul 25, 2019 · Registration expired, pending cancellation · Built 2007 · Fedorenko Vladimir YN232ZMEurocopter EC120B · S/N 1393Cancelled Jul 24, 2019 · Exported to France · Built 2004 · Integrity Aircraft Title Holdings LLCN988WACessna 208B · S/N 208B1033Cancelled Jul 15, 2019 · Registration expired, pending cancellation · Built 2003 · Vertol Systems Co IncN225XTEurocopter EC 225 LP · S/N 2769Cancelled Jul 9, 2019 · Exported to South Korea · Built 2010 · Integrity Aircraft Title Holdings LLCN159SCougar 1 · S/N 46301Cancelled May 4, 2019 · Revoked, canceled · Built 1966 · Seastrom WilliamN6057XMooney M20A · S/N 1652Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1960 · 1st Natl Lease CorpN225HTAirbus Helicopters EC225 LP · S/N 2804Cancelled Apr 29, 2019 · Exported to China · Built 2011 · Integrity Aircraft Title Holdings LLCN98905Piper PA-12 · S/N 12-264Cancelled Apr 22, 2019 · Revoked, canceled · Built 1946 · Mcclendon B JN606VADJI SPREADINGWINGS S1000 · S/N S100051423Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Aerial Inspection ResourcesN49VBUltramagic T210 · S/N 210/38Cancelled Mar 23, 2019 · Built 2006 · Vista Adventures LLCN54VBUltramagic N-210 · S/N 210/39Cancelled Mar 16, 2019 · Built 2006 · Vista Adventures LLCN135HHAgusta A109S · S/N 22040Cancelled Feb 27, 2019 · Exported to India · Integrity Aircraft Title Holdings LLCN580LS3D Robotics SOLO · S/N S111A5600472Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Skyward Io IncN580NSDJI INSPIRE 1 · S/N W13DBL26020920Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Skyward Io IncN580PCDJI PHANTOM 3 PROFESSION · S/N P76DCF12016929Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Skyward Io IncN624WADronetown FREEFLY SYS CINSTAR8 · S/N DT1003Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Dronetown LLCN39037Luscombe 8A · S/N 1798Cancelled Jan 15, 2019 · Revoked, canceled · Built 1941 · Hopkins Richard CN265LBDronetown FREEFLY SYS CINSTAR8 · S/N DT1002Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Dronetown LLCN581FASylvain Chancel EZ RIG · S/N EZ12345Cancelled Dec 12, 2018 · Registration expired, pending cancellation · Aerial Inspection Resources IncN291MQAirbus Helicopters EC225 LP · S/N 2919Cancelled Nov 15, 2018 · Exported to China · Integrity Aircraft Title Holdings LLCN365HHAerospatiale AS 365 N2 · S/N 6533Cancelled Oct 17, 2018 · Exported to Malaysia · Integrity Aircraft Title Holdings LLCN51PBGlaser-Dirks Flugzeugbau DG-100G · S/N E 151 G 118Cancelled Oct 3, 2018 · Built 1983 · Willamette Valley Soaring Club IncN5374SDJI PHANTOM 2 · S/N PH645292378Cancelled Sep 13, 2018 · Sale reported, pending cancellationN99203Engineering & Research ERCOUPE 415-C · S/N 1826Cancelled Aug 23, 2018 · Revoked, canceled · Built 1946 · Wood W WN544VDDJI S900 · S/N 0380061869Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Dna Studios LLCN16VBUltramagic N-180 · S/N 180/38Cancelled Aug 6, 2018 · Registration expired, pending cancellation · Built 2003 · Vista Adventures LLCN3129CCessna 180 · S/N 30928Cancelled Aug 2, 2018 · Revoked, canceled · Built 1954 · Streeter Earl KN898JSEmbraer EMB-135BJ · S/N 14501071Cancelled Jul 23, 2018 · Exported to Vietnam · Built 2008 · Integrity Aircraft Title Holdings LLCN535UDBrian Dalrymple READY COPTER · S/N RC12345Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Aerial Inspection ResourcesN5384ADJI S-800 SPREADINGWINGS · S/N S800123Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Aerial Inspection ResourcesN130SEAirborne EDGE X · S/N 001Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2001N537FSSkyward Io S1000 · S/N 1000:030A:0000:0001Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Skyward Io IncN6364HDJI PHANTOM 3 PROFESSION · S/N P76DC105017386Cancelled May 31, 2018 · Sale reported, canceledN64405Aerostar International RX-7 · S/N RX7-3072Cancelled May 31, 2018 · Sale reported, canceledN692EBGryphon Dynamics X8 · S/N 001-2015Cancelled May 31, 2018 · Sale reported, canceledN2534KBullock Randolph Burton QUICKSILVER MXIIL · S/N 12927Cancelled May 30, 2018 · Sale reported, canceled · Built 1999N3844VCessna 170A · S/N 18731Cancelled May 30, 2018 · Sale reported, canceled · Built 1949N251CTCirrus Design SR22 · S/N 2510Cancelled May 23, 2018 · Exported to Canada · Built 2007 · Charlie Tango LLCN83586Aeronca 7AC · S/N 7AC-2262Cancelled May 18, 2018 · Revoked, canceled · Built 1946 · Kern Robert LN501VTVT Griffin Svcs Inc/Vt Group U VORTEX900 · S/N VTG 01-001Cancelled May 3, 2018 · Registration expired, pending cancellation · Vt Griffin Services IncN502VTVT Griffin Svcs Inc/Vt Group U VORTEX900 · S/N VTG 01-002Cancelled May 3, 2018 · Registration expired, pending cancellation · Vt Griffin Services IncN531WLVT Griffin Svcs Inc/Vt Group U SCANEAGLE INSIGHT A2 · S/N 06-232Cancelled May 3, 2018 · Registration expired, pending cancellation · Vt Griffin Services IncN531XRVT Griffin Svcs Inc/Vt Group U SCANEAGLE INSIGHT A2 · S/N 06-238Cancelled May 3, 2018 · Registration expired, pending cancellation · Vt Griffin Services IncN531YRVT Griffin Svcs Inc/Vt Group U SCANEAGLE INSIGHT A2 · S/N 06-450Cancelled May 3, 2018 · Registration expired, pending cancellation · Vt Griffin Services IncN93007Gyrocopter MK 1 · S/N 436267Cancelled Apr 6, 2018 · Revoked, canceled · Built 1965 · Matthiesen Richard VN9225DBeech B-60 · S/N P-296Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1974 · Two Five Delta LLCN364RMBeech A36 · S/N E-2957Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Accretion LLCN145GDAirbus Helicopters Deutschland MBB-BK 117 D-2 · S/N 20062Cancelled Mar 16, 2018 · Exported to China · Integrity Aircraft Title Holdings LLC
Back to Portland, OR