Skip to content

Cancelled registrations · 944

Query with SQL

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N37118Porter VANCRAFT · S/N 9255Cancelled Mar 16, 2018 · Revoked, canceled · Porter James R N912FLund David SKYSTAR/KITFOX/4 · S/N 1462Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1998 · Anderson Douglas R N914FMMorse Frank L REBEL · S/N 0147RCancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1996 · Kj Enterprises N826GGGeiger James E EUROPA XS · S/N A254Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 2004 · Geneft Corp N52037Rhoads Warren AVENTURE II · S/N AP2A0024Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1997 · Geneft Corp N2508JCessna 150E · S/N 15061008Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1964 · Foss Wallace L N8734BCessna 172 · S/N 36234Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1958 · Stutsman Eli D N912ACUrmston CURRIE WOT · S/N 1594Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Garrison Patrick L N34GGBritish Aerospace HS 125-700A · S/N 257034Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1978 · Hawker 700 LLC N424DMcdaniel D A/Mcdaniel L RV-6-CH · S/N AC-3Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1996 · Carter Timothy D N177DSCessna 177B · S/N 17701834Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1972 · Geneft Corp N1590GSlingsby Sailplanes CURRIE WOT · S/N 1590Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Garrison Patrick L N1595GSlingsby Sailplanes CURRIE WOT · S/N 1595Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Garrison Patrick L N918CRNorth Wing Design APACHE · S/N 322046Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2003 · Rothenberger Gary B N7364SCessna 182P · S/N 18265155Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1976 · Lorenz S Kay N569CUniversal Stinson 108-3 · S/N 108-3569Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1947 · Smith Scott Patrick N57188Ryan Aeronautical ST3KR · S/N 2057Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1944 · Seastrom William W N48AHHarless Ronald L JR VANS RV8A · S/N 81351Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2001 · Zuro Gregory N541TWZivko Aeronautics EDGE 540 · S/N 0017Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1997 · Wade Thomas N7240TCessna 172A · S/N 46840Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1960 · Benjaminson Eric D N42BKKennedy William E C II LANCAIR 320 · S/N 791-320-633QBCancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2004 · Kennedy William E C III N397RHHarkness Richard LONG-EZE · S/N 397Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1994 · Rogers Eowyn K N4022UCessna 150E · S/N 15061422Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1965 · Foster Merton A Jr N144LLanham Kenneth LANCAIR IV · S/N 138Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1997 · Unitan David N7984DBeech H35 · S/N D-5254Cancelled Nov 22, 2017 · Revoked, canceled · Built 1957 · Park Loading Co N6853KPiper PA-16 · S/N 16-688Cancelled Nov 21, 2017 · Revoked, canceled · Built 1949 · Geis Karl F Jr Co Ow N89565Cessna 140 · S/N 8608Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Pulliam George E N9395CCessna 180 · S/N 31793Cancelled Nov 21, 2017 · Revoked, canceled · Built 1955 · St Johns Motor Express Co N99797Engineering & Research ERCOUPE 415-C · S/N 2420Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Fike Gilbert O N382HHHughes 369HS · S/N 760832SCancelled Oct 31, 2017 · Registration expired, pending cancellation · Vertol Systems Co Inc N16888Fairchild 24 G · S/N 2962Cancelled Oct 28, 2017 · Revoked, canceled · Built 1937 · Cole A O N1728APiper PA-22 · S/N 22-476Cancelled Oct 28, 2017 · Revoked, canceled · Built 1952 · Mcginnis Raymond E N17314Douglas DC3 · S/N 1924Cancelled Oct 28, 2017 · Revoked, canceled · Built 1937 · General Airways Inc N2106Ballard BENSEN B-8M · S/N BRI-7267Cancelled Oct 28, 2017 · Revoked, canceled · Ballard Ronald S N4433FKettner P OSPREY-2 · S/N 578Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1985 · Geneft Corporation N815TBBryan Conway ZENAIR CH701 · S/N 7-4819Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2011 · Conway Bryan H N6029EBeech K35 · S/N D-5948Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1959 · Two Nine Echo LLC N164CHHay Carl M VANS ACFT RV6 · S/N 20444Cancelled Sep 18, 2017 · Exported to Canada · Built 1994 · Hay Carl M N260SHSIAI Marchetti F.260C · S/N 303Cancelled Jul 20, 2017 · Third renewal notice · Blackstone Michael E N7190KRobinson Helicopter R22 BETA · S/N 3115Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2000 · Morgan Gerald N986GCHughes 269A · S/N 105-0402Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1965 · Portland Community College Foundation N1565Stits SA3B · S/N P449Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1970 · Anderson Douglas R N5040WWells Wayne W J 3 KITTEN · S/N 1Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Wells Wayne W N3283XCessna 310L · S/N 310L-0133Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1967 · Calvert Richard H N111YDHudson Michael D AIRHOG 618 · S/N 001Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1998 · Hudson Michael D N66KLRobinson Helicopter R66 · S/N 0375Cancelled Apr 6, 2017 · Exported to Malaysia · Integrity Aircraft Title Holdings LLC N2158BLuscombe T-8F · S/N 6585Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1949 · Meade Richard A N98683Cessna 421C · S/N 421C0209Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1976 · Mcdonald John D N72RRReinseth CASSUTT IIM · S/N 1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1971 · Reinseth Robert E N7520SSmith AEROSTAR 601 · S/N 61-0152-081Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Umphrey William G

Back to Portland, OR