Skip to content

Cancelled registrations · 123

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 = 'ALBANY' 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 = 'ALBANY'
  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 = 'ALBANY'
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.

N221SKCzech Aircraft Works Spol Sro MERMAID · S/N 05MM0003Cancelled Apr 24, 2013 · Mclagan William D N57997Kaman HH-43B · S/N 60-252ACancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1960 · Fisher Ronald G N3153RAerospatiale SA316B ALOUETTE III · S/N 1484Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1967 · Roberts Aircraft Company N67159Hiller-Miller UH-12E · S/N 1716Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1965 N601RAHiller-Roberts OH23D · S/N 959Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1957 N541HEnstrom F-28C · S/N 333Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1976 N546FHFairchild Hiller FH-1100 · S/N 46Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1967 N4966S N I A S SA 318C ALOUETTE AST · S/N 2227Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1971 · Fisher Ronald G N4451TStroup John R QUICKSILVER MX II · S/N 1517Cancelled Dec 11, 2012 · Sale reported, pending cancellation · Built 1983 N4685S N I A S SA 318C ALOUETTE AST · S/N 2235Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1971 · Fisher Ronald G N83GLLarsen Gerald C MONI · S/N 00083Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1983 · Larsen Gerald C N8453S N I A S SA 318C ALOUETTE AST · S/N 2224Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1971 · Fisher Ronald G N369FHFairchild Hiller FH-1100 · S/N 118Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1968 · Mountain Air Helicopters Inc N27CHHess-Charles VARI-EZE · S/N 966Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1978 · Hess Charles A N4327GMcculloch J-2 · S/N 037Cancelled Sep 18, 2012 · Revoked, canceled · Built 1971 · Albany Airways Inc N4173FCessna 172 · S/N 46073Cancelled Aug 1, 2012 · Sale reported, pending cancellation · Built 1958 N5331QCessna 150L · S/N 15073231Cancelled Jun 14, 2012 · Registration pending, canceled · Built 1972 N44501Naylor Galen Scott III KITFOX · S/N 1098Cancelled Nov 14, 2011 · Exported to Canada · Built 2006 · Omara Brendan J N8108PPiper PA-24 · S/N 24-3358Cancelled Aug 25, 2011 · Exported to Canada · Built 1962 · Propst Bruce M Trustee N10042Brantly B-2 · S/N 151Cancelled Jun 8, 2011 · Sale reported, canceled · Built 1961 N2641HSix Chuter LEGEND · S/N 3006Cancelled Jul 6, 2010 · Exported to Canada · Built 2005 · Omara Brendan J N2979LMooney M20F · S/N 670338Cancelled Jul 27, 2009 · Registration revoked · Built 1967 · Albany Airways Inc N94347Ercoupe 415-C · S/N 1570Cancelled Jul 21, 2009 · Triennial form not returned · Built 1946 · Smith Vernon W N8100LCessna 172H · S/N 17256300Cancelled Jun 3, 2008 · Triennial form not returned · Built 1967 · Kizer Frank R N28901Cessna 414 · S/N 414-0353Cancelled Jan 25, 2007 · Triennial form not returned · Casey Industrial Inc N9096KStinson 108-1 · S/N 108-2096Cancelled Jul 27, 2002 · Triennial form not returned · Built 1947 · Stevens Ron C N9005EAerospatiale SA315B · S/N 2538Cancelled Jul 16, 1999 · Exported to Canada · Roberts Aircraft Company N348RAAerospatiale SA315B · S/N 2569Cancelled Apr 12, 1999 · Exported to Costa Rica · Roberts Aircraft Company N345RAAerospatiale SA315B · S/N 2591Cancelled Oct 15, 1998 · Exported to Costa Rica · Roberts Aircraft Company N180USAerospatiale SA315B · S/N 2631Cancelled Apr 29, 1998 · Exported to Bolivia · Roberts Aircraft Company N27387Aerospatiale SA315B · S/N 2625Cancelled Apr 14, 1998 · Exported to Germany · Roberts Aircraft Company N529RAAerospatiale SA316B ALOUETTE III · S/N 1529Cancelled Jan 27, 1998 · Exported to Bolivia · Roberts Aircraft Company N499RAAerospatiale SA316B ALOUETTE III · S/N 1499Cancelled Sep 2, 1997 · Exported to Venezuela · Roberts Aircraft Company N6227MAerospatiale SA315B · S/N 2612Cancelled Dec 5, 1996 · Exported to Ecuador · Roberts Aircraft Co N31675Aerospatiale SA315B · S/N 2611Cancelled Jul 18, 1996 · Exported to Hong Kong · Roberts Aircraft Company N7722AAerospatiale AS350B · S/N 2294Cancelled Feb 28, 1996 · Exported to Canada · Roberts Aircraft Co N71439Gullwing Ultralite T E A M HI MAX · S/N 1Cancelled Oct 3, 1995 · Triennial form not returned · Gullwing Ultralite Corp N1878RRaven Industries RX6 · S/N RX6261Cancelled Aug 12, 1995 · Triennial form not returned · Purdum Ronald L N30511Piper PA-32RT-300T · S/N 32R7887280Cancelled May 12, 1995 · Triennial form not returned · Rose Ken R DBA N89PFCessna 182L · S/N 18258792Cancelled Apr 26, 1995 · Allish Timothy N315DYAerospatiale SA315B · S/N 2622Cancelled Feb 28, 1995 · Exported to Argentina · Roberts Aircraft Inc N70283Aerospatiale SA315B · S/N 2596Cancelled Aug 25, 1988 · Exported to Switzerland · Fisher Ronald G N5276YPiper PA-23-250 · S/N 272340Cancelled Mar 12, 1985 · Lowry Terry W & Lowrybetty M N1280QCessna 150L · S/N 15072580Cancelled Jun 25, 1983 · Administratively canceled · Ropp Jess N678KGBell 206B · S/N 968Cancelled May 19, 1983 · Guthrie Kenneth G N4521HPiper PA-15 · S/N 15-295Cancelled Oct 20, 1981 · Built 1949 · Woods David H N9822MMaule M-4T · S/N 1TCancelled May 22, 1979 · Exported to Canada · Built 1966 · Bakefelt Sarah T N9127LChampion 7GCBC · S/N 313-71Cancelled Apr 13, 1979 · Exported to Canada · Justin Lloyd & Binns Leroy N1381UCessna 172 · S/N 17267052Cancelled Jul 14, 1977 · Built 1976 · Kasper Jack W N5748South Albany Avn. PIETENPOL S.A.M. · S/N GK-5Cancelled Jul 12, 1977 · South Albany Aviation Club Inc

Back to Albany, OR