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.

N6111SCameron Balloons US 0-105 · S/N 5463Cancelled Aug 6, 2012 · Sale reported, canceled · Built 1988 N14RBLet BLANIK L-13 · S/N 025314Cancelled Jul 30, 2012 · Registration pending, pending cancellation · Built 1972 N106PPolen SPECIAL · S/N 101Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Built 1965 · Hanna Kirk D N52874Auster-Bullock MARK 6 · S/N TAY-371-WCancelled Jun 28, 2012 · First renewal notice · Built 1947 · Bullock Harold E N44JBBond RX-B2 · S/N B2Cancelled Jun 27, 2012 · Revoked, canceled · Built 1973 · Bond John S N1437MSchweizer TG3A · S/N 113Cancelled Jun 21, 2012 · Sale reported, canceled · Built 1957 N4279Gaudry VANCRAFT 3 · S/N 1805-56Cancelled Jun 14, 2012 · Revoked, canceled · Gaudry Leo A N418TBeech 35-A33 · S/N CD-289Cancelled Jun 7, 2012 · Revoked, canceled · Built 1961 · Abd Partnership N104WBeech B50 · S/N CH-49Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1954 · Brown Jimmy N N747CHEurocopter AS 350 B2 · S/N 3794Cancelled May 2, 2012 · Built 2004 · Sovereign Intl Equities LLC N7321QCessna 182P · S/N 18260961Cancelled Mar 16, 2012 · Exported to New Zealand · Built 1972 · Johnson Charles Bruce N475ERCessna 172R · S/N 17280670Cancelled Feb 2, 2012 · Built 1998 · Curtis Gene N761SQCessna T210M · S/N 21062484Cancelled Jan 23, 2012 · Exported to Mexico · Built 1978 · Hernandez Claudio N6024MAir Tractor AT-401 · S/N 401-0949Cancelled Dec 16, 2011 · Third renewal notice · Built 1994 · U S Bancorp Equipment Finance Inc N359JACessna 208B · S/N 208B2010Cancelled Nov 16, 2011 · Exported to Bolivia · Built 2008 · Lopez Air LLC N2104QCessna 182K · S/N 18257860Cancelled Sep 26, 2011 · Exported to Canada · Built 1966 · Orwash Flight LLC N232BDMooney M20M · S/N 27-0354Cancelled Sep 22, 2011 · Exported to Canada · Built 2005 · Wings Nw LLC N95635Taylorcraft BF · S/N 7935Cancelled Aug 2, 2011 · Revoked, pending cancellation · Built 1946 · Goodrich W L N7888Griffin 3B · S/N 007Cancelled Jun 28, 2011 · Revoked, pending cancellation · Built 1972 · Griffin Edward J N5886WPiper PA-28-150 · S/N 28-2614Cancelled Jun 16, 2011 · Registration pending, pending cancellation · Built 1965 N20433Cessna 177B · S/N 17702672Cancelled Jun 10, 2011 · Exported to Argentina · Built 1977 · Trillia Roy N20BHHiscoe EAA BIPLANE · S/N 1930Cancelled Jun 3, 2011 · Sale reported, pending cancellation · Built 1975 N431SRCirrus Design SR20 · S/N 1754Cancelled Apr 28, 2011 · Built 2006 · Russell Thomas G N701JPMikelson James H ZENITH CH 701 · S/N 7-5743Cancelled Feb 17, 2011 · Exported to Canada · Built 2005 · Mikelson James H N57RJFaber Maria J C KITFOX III · S/N 865Cancelled Feb 15, 2011 · Triennial form not returned · Faber J Job N808MEMcdonnell Douglas DC-9-82(MD-82) · S/N 48070Cancelled Jan 28, 2011 · Triennial form not returned · Built 1981 · US Bancorp Equipment Finance Inc N1165PPiper PA-23-150 · S/N 23-179Cancelled Jan 12, 2011 · Sale reported, pending cancellation · Built 1955 N2736YBeech 95 · S/N TD-101Cancelled Dec 13, 2010 · Exported to South Korea · Built 1958 · Mcgaughey Gary T N178DKRaytheon 58 · S/N TH-1918Cancelled Nov 3, 2010 · Exported to Brazil · Built 1999 · Psi Management LLC N18391Beech A36 · S/N E-1113Cancelled Aug 13, 2010 · Exported to Canada · Built 1977 · Theda James A N528RMCessna 501 · S/N 501-0205Cancelled Jul 6, 2010 · Exported to Australia · Built 1981 · Kinnaird Air Oregon Inc N207NDDiamond Aircraft Ind DA20-C1 · S/N C0021Cancelled Apr 28, 2010 · Exported to Germany · Built 1998 · Spring Aviation N7633ACessna 180 · S/N 32530Cancelled Apr 2, 2010 · Exported to Canada · Built 1956 · Northwest Christian Community Foundation N66139Cessna T182T · S/N T18208367Cancelled Dec 2, 2009 · Exported to Denmark · Built 2005 · Sun River Partners LLC N12TRPiasecki HUP-2 · S/N 130029Cancelled Oct 9, 2009 · Registration revoked · Built 1953 · Trans Pac Leasing Inc N20210Piper J3C-65 · S/N 2010Cancelled Oct 9, 2009 · Registration revoked · Built 1937 · Simmons Ronald N34591Cessna 177B · S/N 17701888Cancelled Oct 9, 2009 · Registration revoked · Built 1973 · Missionerys To America Inc N3760GDarling Bud C LARSON SPECIAL 100 · S/N 100Cancelled Sep 18, 2009 · Registration revoked · Built 1962 · Struthers Robert A N9746MMooney M20C · S/N 670040Cancelled Sep 18, 2009 · Registration revoked · Built 1967 · Selegey Thomas J N98621Cessna 340A · S/N 340A0062Cancelled Sep 18, 2009 · Registration revoked · Duffell John W III N6SAPiasecki HUP-2 · S/N 128593Cancelled Sep 15, 2009 · Registration revoked · Trans Pac Leasing Inc N105PSPzl-Swidnik PW-5 · S/N 17 11 018Cancelled Aug 18, 2009 · Triennial form not returned · Built 1998 · Oleary George P N2803HRaven S-60A · S/N S60A-391Cancelled Aug 6, 2009 · Triennial form not returned · Smith James D N25014Semco Balloon T · S/N SEM71Cancelled Jul 15, 2009 · Registration revoked · Built 1972 · Burke Donald E N2070Dyer VANCRAFT 6663245 · S/N 30M4DADCancelled Jul 13, 2009 · Registration revoked · Built 1970 · Dyer Larry E N22056Luscombe 8 · S/N 882Cancelled Jul 13, 2009 · Registration revoked · Built 1939 · Niemeyer E C N1964RRaven S-50A · S/N S50A-176Cancelled Jul 10, 2009 · Registration revoked · Built 1972 · Lesniak Lawrence W N1882QCessna 177RG · S/N 177RG0282Cancelled Jul 9, 2009 · Registration revoked · Built 1972 · Switzer David M N5547FPiper PA-28-140 · S/N 28-24810Cancelled Jul 8, 2009 · Triennial form not returned · Built 1968 · K & J Capital LLC N1531TCessna 402B · S/N 402B0306Cancelled Jun 30, 2009 · Registration revoked · Built 1972 · F & S Flying Service

Back to Portland, OR