Skip to content

Cancelled registrations · 22

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 = 'CA' AND d.registrant_city = 'PARADISE' 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 = 'CA' AND d.registrant_city = 'PARADISE'
  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 = 'CA' AND d.registrant_city = 'PARADISE'
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.

N80008North Wing Design PROTON II · S/N 01212Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 2000 · Shook Brian E N5489GHelio H-295 · S/N 1264Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Soeth Michael R N8182ANystrom Conrad SKY RAIDER II · S/N SR2 049Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2005 · Nystrom Monte D N150FWCessna 150M · S/N 15076551Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1975 · Babcock John H N331ACBurkhart Grob GROB G115C · S/N 82021/CCancelled Dec 6, 2018 · Exported to Canada · Built 1994 · Yoskowitz Leo K Jr N4369VFlores D/White T QUICKSILVER GT 400 · S/N GT 2801502Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1998 · Flores Daniel M N4950JPiper PA-28R-180 · S/N 28R-30696Cancelled Nov 18, 2017 · Revoked, canceled · Built 1968 · Dent Evison Co Ow N2573RRans S-17 · S/N 0601027Cancelled Jun 29, 2017 · Registration expired, pending cancellation · Built 2002 · Peters John W N34733Commonwealth REARWIN 175 · S/N 1546Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1941 · Mccart Michelle A N49787Cessna 152 · S/N 15281317Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1978 · Boyd Delbert L N4980KRyan NAVION · S/N NAV-4-1980Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1949 N93557Engineering & Research ERCOUPE 415-C · S/N 880Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1946 · Fulton Floyd M N56579Boeing A75L3 · S/N 75026Cancelled Jan 31, 2013 · Sale reported, pending cancellation · Built 1936 N2042WBeech V35 · S/N D-7983Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1965 · Pmadd Investments Inc N15267Piper PA-32-300 · S/N 32-7340028Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1972 · Baker Raymond C N90656Harding Jim RV6A · S/N 25661Cancelled Nov 17, 2008 · Triennial form not returned · Built 2001 · Harding Jim N3076HHarding James M AVID FLYER · S/N 990Cancelled Oct 10, 2008 · Triennial form not returned · Built 1992 · Harding James M N182DDCessna 182J · S/N 18257506Cancelled May 11, 2001 · Schlernitzauer James F DBA N9367YBeech 35-A33 · S/N CD262Cancelled Aug 20, 1992 · Desmet Jeffrey G N99921Ercoupe 415-C · S/N 2544Cancelled Oct 20, 1981 · Amy Ivan C N4053JCessna 150G · S/N 10565353Cancelled Jun 22, 1973 · Loraine L Wardman N23021Luscombe 8A · S/N 944Cancelled Sep 4, 1970 · Shelton Frank D

Back to Paradise, CA