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.

N76799Cessna 140 · S/N 11231Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Moran Marvin TN1390HAgusta AB139 · S/N 31052Cancelled Feb 3, 2017 · Exported to Myanmar · Integrity Aircraft Title Holdings LLCN575DJCirrus Design SR22 · S/N 3943Cancelled Oct 7, 2016 · Exported to Japan · Tas Aircraft Sales LLCN911TVBell 206B · S/N 895Cancelled Sep 8, 2016 · Exported to Canada · Built 1993 · Coulson Aviation (USA) IncN501GPBackovich George C G P-5 · S/N 001Cancelled Aug 9, 2016 · First renewal notice · Built 2001 · Lancair Northwest LLCN4ZWentworth STEPHENS-AKRO · S/N 1-02Cancelled Feb 2, 2016 · Exported to Italy · N51e IncN494VAAerospatiale AS 365 N2 DAUPHIN · S/N 6386Cancelled Jan 14, 2016 · Exported to Myanmar · Integrity Aircraft Title Holdings LLCN113TFVans RV-12 · S/N 120798Cancelled Oct 14, 2015 · Exported to Australia · Built 2015 · Airway Science For Kids IncN597JRRobinson Helicopter R66 · S/N 0620Cancelled Oct 7, 2015 · Exported to Indonesia · Integrity Aircraft Title Holdings LLCN320TCirrus Design SR20 · S/N 1160Cancelled Oct 6, 2015 · Exported to South Korea · Tas Aircraft Sales LLCN582XSCirrus Design SR20 · S/N 1152Cancelled Jul 28, 2015 · Exported to South Korea · Built 2001 · Tas Aircraft Sales LLCN41255Robinson Helicopter R44 · S/N 1800Cancelled Jun 3, 2015 · Exported to Malaysia · Built 2007 · Solaire Helicopter Group LLCN1430CCirrus Design SR20 · S/N 1326Cancelled May 29, 2015 · Exported to South Korea · Built 2003 · Tas Aircraft Sales LLCN908ACUrmston Currie Wot SE5A · S/N 1591Cancelled May 29, 2015 · Exported to United Kingdom · Built 1965 · Garrison Patrick LN8032FHess Helmut MONERAI-S · S/N 0074Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1981 · Nelson Jack RN3354HErcoupe 415-C · S/N 3979Cancelled May 20, 2015 · Registration pending, canceled · Built 1947N47WGKarl Joseph Steven EXEC 90 · S/N 001Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1998 · Karl Joseph StevenN48761Cessna 152 · S/N 15283368Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1979 · Spring AviationN602MCAero Vodochody L39CT · S/N 135234Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1996 · Mac Flightlease IncN761PWCessna T210M · S/N 21062419Cancelled May 19, 2015 · Registration expired, pending cancellation · Provonsha GaryN978MCMay William H CHRISTEN EAGLE II · S/N MAY-0001Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1980 · Simonsen Bent PN3503GSixchuter SPIRIT XL · S/N SPIRIT XL 2859Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 2002 · Muller Theodore AN8500NHughes 369HS · S/N 1000263SCancelled May 11, 2015 · Registration expired, pending cancellation · Built 1970 · Mbk IncN228TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2096USACancelled May 6, 2015 · Registration expired, pending cancellation · Built 1991 · Locatell Christopher DN859KDCirrus Design SR22 · S/N 3434Cancelled May 6, 2015 · Exported to Germany · Built 2009 · Tas Aircraft Sales LLCN9767SRockwell International 695 · S/N 95014Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1980 · 3md CharterN9632NHytek HURRICANE · S/N 011Cancelled Apr 27, 2015 · Registration expired, pending cancellation · Built 1993 · O'Shannon Leonard LN234JCirrus Design SR20 · S/N 1035Cancelled Mar 3, 2015 · Exported to South Korea · Built 2000 · Tas Aircraft Sales LLCN45VHNew Piper PA-32-301XTC · S/N 3255050Cancelled Jan 27, 2015 · Exported to Bolivia · Built 2006 · Tas Aircraft Sales LLCN186CHKawasaki Vertol KV107-11 · S/N 4005Cancelled Jan 14, 2015 · Built 1963 · Columbia Helicopters Leasing IncN112HWCirrus Design SR20 · S/N 1128Cancelled Dec 22, 2014 · Exported to South Korea · Built 2001 · Tas Aircraft Sales LLCN9705EBellanca 17-31A · S/N 77-32-168Cancelled Dec 22, 2014 · Registration pending, canceled · Built 1977N38284Piper J4E · S/N 41572Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1941N9774QSmith AEROSTAR 601P · S/N 61P-0402-140Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Coronet Leasing CorpN13848Stinson SR-5A · S/N 9223ACancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1934 · Paulson Jeffery EN96293Taylorcraft BC12-D · S/N 8593Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Richardson David LN80362Cessna 172M · S/N 17266550Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Paull Michael BN7004PPiper PA-24 · S/N 24-2155Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1960 · Coulsey Gerald HN6511FCessna 150F · S/N 15063111Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1966 · Schubel William GN5783QMooney M20E · S/N 750Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1965 · Cowley Thomas WN6143RCessna T210F · S/N T210-0043Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1966 · Buss Donald JN6RVChard VAN RV-6 · S/N AC-1Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1977 · Battjes Carl RN5244CBeech B35 · S/N D-2636Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1950 · Spencer David S JrN500WAConvair 240 · S/N 166Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1950 · Inter Pacific Development CorpN5045UCessna 206 · S/N 206-0045Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1964 · Kelley Albert LN650JSRaytheon HAWKER 800XP · S/N 258537Cancelled Oct 8, 2014 · Exported to Mexico · Built 2001 · Jst LLCN4042BDehavilland DH104 DOVE 6A · S/N 4329Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1951 · Barr Ferrin CN3595YCessna 182F · S/N 18254495Cancelled Oct 3, 2014 · Registration expired, pending cancellation · Built 1962 · Evans John FN3351MPiper PA-12 · S/N 12-2210Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1947 · 51 Mike LLCN3550APiper PA-22-135 · S/N 22-1824Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1953 · Rix Robert A
Back to Portland, OR