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.

N758DCCessna R172K · S/N R1723004Cancelled Apr 8, 1981 · Exported to Canada · Empire Lumber CoN5275PPiper PA-24-250 · S/N 24-315Cancelled Dec 31, 1980 · Revoked, canceled · Built 1958 · Gilmer William BN276LJStory 6 · S/N 1Cancelled Dec 30, 1980 · Built 1967 · Reese Michael DN7948MBeech 35-C33 · S/N CD1055Cancelled Dec 23, 1980 · C3 Storage IncN5775Van Abkoude BOWERS FLY BABY · S/N 7Cancelled Nov 12, 1980 · Van Abkoude Frederick CN75LBBeers-Baird AMF-S14F · S/N 367Cancelled Nov 12, 1980 · Beers Lionel W & Baird John BN1258WWeatherly 201B · S/N 612Cancelled Oct 10, 1980 · Built 1973 · Ruchert DennisN3468Cutsforth 16 · S/N 8-22Cancelled Sep 22, 1980 · Cutsforth Ainsley MN4930TCessna 411 · S/N 0411-0130Cancelled Aug 4, 1980 · Terminal Ice & Cold Storage CompanyN36465Piper PA-34-200T · S/N 34-7870332Cancelled Jul 31, 1980 · Exported to Canada · Built 1978 · Triangle Land CoN1230WPiper PA-32-260 · S/N 32-7100015Cancelled Jun 30, 1980 · Built 1971 · Hessel Tractor & Equipment CoN4620UCessna TU206G · S/N U20605005Cancelled May 30, 1980 · Exported to Canada · Wilco IncN8954Brockway BOWERS FLYBABY · S/N 5427-2Cancelled Dec 19, 1978 · Buffum Malcolm SN6142BCessna 182A · S/N 34142Cancelled Jun 16, 1978 · Exported to Canada · Warrington Bill And Clayton Ronald DN1886QCessna 177RG · S/N 177RG0286Cancelled Apr 19, 1978 · Exported to Canada · Osmunson Willard EN735MLCessna 182Q · S/N 182-65531Cancelled Mar 9, 1978 · Vandervort Gerald BN117HCPiper PA-31P · S/N 31P-54Cancelled Jan 19, 1978 · Mark 50 Machinery Sales IncN5205XCessna 320 · S/N 3200105Cancelled Jan 6, 1978 · Charlene J Davis DBA Old Westwood CoN2219APiper PA-22-135 · S/N 22-622Cancelled Dec 5, 1977 · Exported to Canada · Morrison William RichardN9578QSmith AEROSTAR 601P · S/N 61P-0368-117Cancelled Nov 30, 1977 · R V Hokanson & Marilyn Hokanson DBA Hokanson FleetN20GYLockheed 18-56 · S/N 2437Cancelled Jul 21, 1977 · Built 1943 · Transalaska Produce CorpN617TBeech K35 · S/N D-5777Cancelled Jul 12, 1977 · Griffith John H CoN103ZCessna 310A · S/N 38149Cancelled Jul 6, 1977 · US Agriculture Dept Forest ServiceN1YDBeech E33 · S/N CD-1173Cancelled Apr 13, 1977 · Donald A Miller DBA Imperial AdvertisingN3MEBeech V35B · S/N D-9619Cancelled Mar 23, 1977 · Built 1974 · Merritt Equipment CoN6843SBeech E-90 · S/N LW-137Cancelled Mar 21, 1977 · Crowley Maritime CorpN9154JPiper PA-28-180 · S/N 28-3211Cancelled Oct 14, 1976 · Jacobsen ClydeN715BPEnstrom 280 · S/N 1029Cancelled Aug 6, 1976 · Parsons Robert VN51149Cessna 150J · S/N 15069797Cancelled Aug 3, 1976 · Byrd Tresa AN9728KStinson 108-2 · S/N 108-2728Cancelled Jul 28, 1976 · Pearson Kenneth FN7288PPiper PA-24-250 · S/N 24-2466Cancelled Jul 23, 1976 · Umiak IncN18810Christen MH-1 GYROPLANE · S/N 0053Cancelled Jun 24, 1976 · Sale reportedN1234UCessna 337C · S/N 3370916Cancelled Jun 23, 1976 · Central East Investment CoN4526SBeech A36 · S/N E-729Cancelled May 26, 1976 · Built 1975 · Woodchuck Trucking CoN1089KLuscombe 8A · S/N 3816Cancelled May 12, 1976 · Built 1946 · Hardy R BrentN7494NBeech D55 · S/N TE-604Cancelled Apr 15, 1976 · Exported to Canada · Built 1968 · Moran LuisN100PWBeech 95-C55 · S/N TE-413Cancelled Jan 22, 1976 · Built 1967 · Winston PerryN5858UPiper PA-28-140 · S/N 28-26689Cancelled Jan 9, 1976 · Scott Glenn DN5918FCessna 210G · S/N 21058918Cancelled Oct 31, 1975 · Exported to Canada · Benedict Thomas MN3566WPiper PA-32-260 · S/N 32-457Cancelled Oct 9, 1975 · Exported to Canada · Malaspina RudyN3633ZPiper PA-22-150 · S/N 22-7528Cancelled Sep 9, 1975 · Exported to Canada · H A White Marine ServiceN2853LCessna 172H · S/N 17256053Cancelled Sep 8, 1975 · Exported to Canada · Built 1967 · Gilbert Ralph Et AlN1009Vancraft GYROCOPTER · S/N 1001Cancelled Jul 21, 1975 · Built 1968 · Okeefe JohnN49911Laister-Kauffman LK-10A · S/N 125Cancelled Jun 9, 1975 · Williamette Valley Soaring ClubN9127FHughes 369HS · S/N 820402SCancelled May 14, 1975 · Exported to Canada · Quasar Aviation IncN45482Luscombe 8A · S/N 2009Cancelled May 9, 1975 · Built 1946 · Johnstone FloydN2243HEngineering & Research 415-C · S/N 2866Cancelled May 7, 1975 · Monson Dean DN6714PPiper PA-24 · S/N 24-1840Cancelled May 7, 1975 · Hendrickson Del RN1159USikorsky S-58ET · S/N 58601Cancelled Nov 25, 1974 · Exported to Singapore · Jelco IncN7034JBell 212 · S/N 30570Cancelled Nov 14, 1974 · Exported to Canada · Jelco Inc
Back to Portland, OR