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.

N4369VPiper PA-46-310P · S/N 468408076Cancelled Sep 3, 1991 · Triennial form not returned · Hoffart Lawrence JN207WACessna 207 · S/N 20700344Cancelled Aug 21, 1991 · Exported to Venezuela · H And H Trucking CoN45944Luscombe 8A · S/N 2471Cancelled Aug 14, 1991 · Triennial form not returned · Dickman Laura RN1862RRaven Industries RX6 · S/N RX6248Cancelled Aug 10, 1991 · Triennial form not returned · Columbia Bookkeeping Service IncN77PWChristen Industries PITTS S-2B · S/N 5181Cancelled Aug 10, 1991 · Registration expired, pending cancellation · Built 1990 · Stanley Edwin M DBAN8246JPiper AEROSTAR 601P · S/N 61P06507963300Cancelled Jul 23, 1991 · Exported to Colombia · Investek Financial CorporationN1724UCessna T207 · S/N 20700324Cancelled Jun 11, 1991 · Triennial form not returned · Selliken Joseph H JrN378MFBeech 300 · S/N FA105Cancelled Apr 11, 1991 · Exported to Colombia · Ash Organization IncN355BPAerospatiale AS 355 F ECUREUIL · S/N 5144Cancelled Feb 14, 1991 · Exported to Singapore · 800bp CorporationN8646PPiper PA-24-260 · S/N 244089Cancelled Feb 11, 1991 · Triennial form not returned · A & F Transportation CoN188CHVertol 107-II · S/N 107Cancelled Feb 7, 1991 · Exported to Papua New Guinea · Columbia Helicopter Leasing IncN333HDPiper PA-31P · S/N 31P65Cancelled Feb 5, 1991 · Hembree Earlene VN76156Cessna 140 · S/N 10553Cancelled Jun 30, 1986 · Exported to Iceland · Norm Jones Aircraft Sales IncN75827Cessna 172N · S/N 17267984Cancelled Feb 26, 1985 · Rove Olaf IN53916Cessna 172 · S/N 17274553Cancelled Oct 16, 1984 · Exported to Japan · Flightcraft IncN275WDStory WD-6 · S/N 2Cancelled Jul 3, 1984 · Administratively canceled · Miller C E PtnrN4821JBeech 95-C55 · S/N TE-251Cancelled Dec 9, 1983 · Built 1966 · Johnson Warren DN714QACessna 150M · S/N 15079340Cancelled Dec 8, 1983 · 4qa AssociationN6025LAmerican AA-5 · S/N AA5-0125Cancelled Dec 5, 1983 · Exported to Canada · Benedict Lambert LN24809Cessna 152 · S/N 15280392Cancelled Jul 22, 1983 · Administratively canceled · 809 AssociationN8666ZCessna P206C · S/N P206-0466Cancelled Jun 29, 1983 · Administratively canceled · Bailey Wm BonerN99481Ercoupe 415-C · S/N 2104Cancelled Jun 22, 1983 · Administratively canceled · Bousha Byron ON5590DBeech H35 · S/N D5120Cancelled May 18, 1983 · Ennes John PN9560ACessna 170A · S/N 19395Cancelled May 14, 1983 · Administratively canceled · Voss Larry JN3764UBell 205A-1 · S/N 30005Cancelled May 5, 1983 · Exported to Canada · Built 1968 · Aero Planning International IncN8127MCessna 310I · S/N 310I0127Cancelled May 5, 1983 · Administratively canceled · Turel Gary JN27859Piper PA-31 · S/N 31-7912026Cancelled Feb 22, 1983 · Built 1978 · Gentry George HN81974Vanlandingham CASSUTT III M · S/N 172Cancelled Feb 20, 1983 · Administratively canceled · Berney Jack RN2340ECessna 172N · S/N 17271243Cancelled Jan 15, 1983 · Built 1978 · Woolley Douglas R & Niswanger Lonnie BN121CAConvair 440 · S/N 342Cancelled Dec 18, 1982 · Administratively canceled · Command Aviation IncN39691Piper PA-32RT-300T · S/N 32R-7887146Cancelled Dec 6, 1982 · Sale reported · Built 1978N65640Lake LA-4-200 · S/N 579Cancelled Dec 1, 1982 · Turner Dale SN9069EMaule M-5-235C · S/N 7079CCancelled Oct 24, 1982 · Administratively canceled · J S J Pipe IncN4077BGyrocopter MH-1 · S/N 00002Cancelled Oct 5, 1982 · Grigsby Todd WN1229LConsolidated Aeronautics LAKE LA-4-200 · S/N 730Cancelled Sep 16, 1982 · Administratively canceled · Lehne Michael DN1565RGrumman American Avn. AA-5B · S/N AA5B-0065Cancelled Aug 12, 1982 · Administratively canceled · Lexer Kenneth DN631SRBeech 200 · S/N BB-244Cancelled Apr 2, 1982 · Puget Sound Tug & Barge CoN2042QCessna 177RG · S/N 177RG0442Cancelled Mar 26, 1982 · Built 1973 · Woolley Douglas RN555BTEnstrom Helicopter 280C · S/N 1086Cancelled Mar 12, 1982 · First Farwest Corp DBA First Farwest Leasing IncN4801SPiper PA-32-260 · S/N 32-1186Cancelled Mar 1, 1982 · Nickerson Fleet ManagementN7904ZCessna 150C · S/N 15060004Cancelled Jan 5, 1982 · Fortman JamesN9102EAeronca 11AC · S/N 11AC-734Cancelled Jan 5, 1982 · Voss LarryN3340HErcoupe 415-C · S/N 3965Cancelled Dec 23, 1981 · Built 1947 · Larson David HN51651Enstrom Helicopter 280C · S/N 1096Cancelled Dec 23, 1981 · First Farwest Corp DBA First Farwest LeasingN7368PPiper PA-24-250 · S/N 24-2546Cancelled Dec 17, 1981 · R E Sachleining IncN908CMBeech E-90 · S/N LW233Cancelled Oct 19, 1981 · Crowley Maritime CorpN89509Cessna 140 · S/N 8545Cancelled Oct 15, 1981 · Chapman Robert EN264CPAero Commander 680FL · S/N 1433-73Cancelled May 22, 1981 · Exported to Cayman Islands · Built 1964 · Nickerson Fleet Management CorpN6951Kromminga FLY BABY 2 · S/N 6820Cancelled May 11, 1981 · Corneliusen Albert CN501GPCessna 500 · S/N 5000026Cancelled May 7, 1981 · Georgia Pacific Corp
Back to Portland, OR