Cancelled registrations · 34

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

N50080Grumman G-164 · S/N 60Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Alaska Air Service LLC N911GTMooney M20L · S/N 26-0038Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Lyell Hintz N62MEEllis CHRIS-TENA · S/N MC106Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1974 · Port Of Tillamook Bay N465MKKurosaka Momo SPORT 1 · S/N 291Cancelled May 14, 2015 · Registration expired, pending cancellation · Built 2004 · Polman Kees N31066Baggarley Raymond W GLASAIR II FT · S/N 1001Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1996 · Baggarley Raymond W N7122QBalloon Works FIREFLY 8B · S/N F8B-155Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Grant Dawn N240ALAerolift 240 · S/N 001Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1984 · Aerolift Inc N754CBBell Charles E ROTORWAY EXEC162FKIT · S/N 6957Cancelled Apr 9, 2014 · Built 2010 · Dunk Shawn Franklin N99903Engineering & Research ERCOUPE 415-C · S/N 2526Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1946 N214DLRaven S55A · S/N S55A-1027Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1983 · Lucich Glen S N2715Ranger 2ND · S/N 2Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1967 N94331Ercoupe 415-C · S/N 1554Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1946 N927SRErcoupe 415-C · S/N 2884Cancelled Feb 21, 2013 · Sale reported, canceled N345AGGlines Alan PROSTAR PT2B · S/N 1188Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1992 N1817YCessna 172C · S/N 17249417Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1962 N6209BAero Commander 500 · S/N 500-645-8Cancelled Jun 21, 2012 · Registration pending, canceled · Built 1958 N4949Curtiss Wright TRAVEL AIR 4000 · S/N 447Cancelled Jul 15, 2010 · Exported to Canada · Built 1928 · Stoffel Larry L N1942AStinson VULTEE V-77 · S/N 77-156Cancelled Oct 23, 2008 · Exported to French Polynesia · Built 1942 · Stoffel Larry L N5588LLarson Donald J QUICKIE · S/N DL1Cancelled Jul 24, 2008 · Triennial form not returned · Built 1980 · Port Of Tillamook Bay N49GDGlen Linscheid SMITH MINI PLANE · S/N RS-10Cancelled Jan 12, 2007 · Triennial form not returned · Lincheid Glen A N430RSSpittles Robert G STARDUSTER II SA300 · S/N SA300-430Cancelled Sep 11, 2003 · Exported to Canada · Built 1990 · Spittles Charles V N97NSPullar Larry H L 40 · S/N 001Cancelled Jan 17, 2003 · Triennial form undeliverable · Built 1999 · Pullar Larry N99TWThompson James 28 · S/N 01Cancelled Nov 6, 2001 · Port Of Tillamook Bay N4778JBeech A23-19 · S/N MB-223Cancelled Nov 18, 1983 · Perry Henry N9144EMaule M-5-235C · S/N 7113CCancelled Aug 23, 1979 · Exported to Canada · Seable Donald G N3304Stits Playmate SA-11-A · S/N 92Cancelled Feb 14, 1975 · Built 1973 · Mullan Ted R / Mullan Ivy L N67577Cessna AT-17 · S/N 2985Cancelled Jan 8, 1958 · Arlington Aeronautical School N49343Consolidated Vultee BT-15 · S/N 7191Cancelled May 21, 1956 · Arlington Aeronautical School Inc N58611Ryan Aeronautical ST3KR · S/N 1485Cancelled Mar 8, 1956 · Coastways School Of Aeronautics N66761Cessna T-50 · S/N 6152Cancelled Oct 13, 1955 · Arlington Aeronautical School Inc N49369Cessna T-50 · S/N 2452Cancelled Oct 11, 1955 · Built 1942 · Arlington Aeronautical School Inc N57117Cessna T-50 · S/N 5729Cancelled Oct 11, 1955 · Arlington School Of Areonautics N58699Cessna T-50 · S/N 5442Cancelled Oct 11, 1955 · Arlington Aeronautical School Inc N58851Cessna T-50 · S/N 5485Cancelled Oct 11, 1955 · Arlington Aeronautical School Inc

Back to Tillamook, OR