Skip to content

Cancelled registrations · 68

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

N6617FCessna 150F · S/N 15063217Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1966 · Mclemore Cecil E N9836KUniversal Stinson 108-2 · S/N 108-2836Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1947 · Coddington Thomas J N45307Naval Aircraft Factory N3N-3 · S/N 2974Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1941 · Schmauderer Edward C N3365APiper PA-22 · S/N 22-1664Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Derock Gerald D N9312ZNaval Aircraft Factory N3N-3 · S/N 4482Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1960 · Medlock Dusters N3279RRaven S55A · S/N S55A-475Cancelled Apr 2, 2015 · Registration expired, pending cancellation · Built 1979 · Wallis John A N9317ZNaval Aircraft Factory N3N-3 · S/N 2948Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1960 · Medlock Dusters N45125Naval Aircraft Factory N3N-3 · S/N 4453Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1941 · Medlock Dusters N45213Naval Aircraft Factory N3N-3 · S/N 1942Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1940 · Medlock Dusters N3137PPiper PA-23 · S/N 23-1062Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1957 · Bodoh Michael W N1174RRaven Industries RX6 · S/N RX6-230Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1977 · Molnar Kristy L N7469XCessna 172B · S/N 17247969Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1960 N177HKIrish Harley K CASSUTT IIIM · S/N 1Cancelled Aug 14, 2013 · Sale reported, canceled N7863Grumman Acft ENG Cor-Schweizer G-164A · S/N 992Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1972 · Watts Agricultural Aviation Inc N5720YRaven S55A · S/N S55A-715Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Pratt Nola D N221WPGrumman G-164 · S/N 99Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1963 · Yolo Dusters Inc N4290XRaven S55A · S/N S55A-1040Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1984 · Wallis John A N99661Engineering & Research ERCOUPE 415-C · S/N 2284Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1946 N735SDCessna 182Q · S/N 18265640Cancelled Feb 4, 2013 · First renewal notice · Built 1977 · Stewart Richard N5663ZPiper PA-22-108 · S/N 22-9486Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1962 N4357WBeech C23 · S/N M-1575Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1974 · Pynchon James W N28818Engineering & Research 415-C · S/N 6Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1940 · Eaton John M N2937WWeatherly 201B · S/N 604Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1972 · Medlock Dusters Inc N1239DCessna 170A · S/N 19793Cancelled Jun 7, 2012 · Sale reported, canceled · Built 1950 N2482RPiper PA-28-180 · S/N 28-5632Cancelled Aug 6, 2010 · Triennial form not returned · Built 1969 · Beck Phillip P Trustee N946XGrumman G-164A · S/N 460Cancelled Mar 23, 2010 · Triennial form not returned · Built 1967 · Growers Air Service Inc N23152Lewis Robert C BARNETT J4B · S/N 267Cancelled Apr 11, 2007 · Triennial form not returned · Built 1995 · Lewis Robert C N42224Raven S55A · S/N S55A-1018Cancelled Mar 1, 2004 · Triennial form not returned · Built 1983 · Carson William Scott N103MZCameron Balloons US V-90 · S/N 5776Cancelled Oct 16, 2002 · Triennial form not returned · Built 1992 · Morgan Donald G N2224HEngineering & Research 415-C · S/N 2847Cancelled Nov 2, 2001 · Triennial form not returned · Built 1946 · Hollman William E N53139Cessna A188B · S/N 18801642Cancelled Aug 16, 2000 · Exported to Argentina · Defty Peter A N592SPPiper PA-28-140 · S/N 28-22438Cancelled Mar 31, 2000 · Roland Ann J N55836Piper PA-28-140 · S/N 287325500Cancelled Jul 22, 1996 · Triennial form not returned · Simpson Barton D N93313Ercoupe 415-D · S/N 636Cancelled Oct 5, 1995 · Triennial form not returned · Hollman William E N6740HCessna 172M · S/N 17265560Cancelled Aug 29, 1995 · Yolo County Crime Prevention Neighbo N8574TCessna 182C · S/N 52474Cancelled Sep 15, 1994 · Triennial form not returned · Doug Koebel Trucking N1440BLuscombe 8A · S/N 6067Cancelled Mar 29, 1994 · Triennial form not returned · Hand Stephen H N60482Beech C23 · S/N M2180Cancelled Aug 21, 1991 · Triennial form not returned · Woodland Aviation Inc N84713Aeronca 7BCM · S/N 7AC3425Cancelled Jan 22, 1991 · Exported to Australia · Ingraham Jim N6689KGrumman Acft ENG Cor-Schweizer G-164B · S/N 420BCancelled Dec 27, 1990 · Growers Air Inc N3625MPiper PA-12 · S/N 12-2473Cancelled Jun 13, 1990 · Exported to Mexico · Castaneda Rachel N7060RPiper PA-28-140 · S/N 28-21760Cancelled Jun 27, 1985 · Hubman Edward E N405TBeech E18S · S/N BA-108Cancelled Aug 31, 1983 · Exported to Canada · Shanks Pamela E N9303SBeech B-19 SPORT · S/N MB764Cancelled Oct 16, 1981 · Woodland Aviation Inc N2537APiper PA-18-135 · S/N 18-2154Cancelled Sep 6, 1981 · Jessen Kenneth E N6182ZPiper PA-25 · S/N 25-215Cancelled Jun 8, 1981 · Medlock Dusters N9427DPiper PA-22-160 · S/N 22-6401Cancelled Mar 23, 1979 · Haynes John M N7929LBeech A23-24 · S/N MA-116Cancelled Sep 23, 1974 · M & J Distributors N44983Naval Aircraft Factory N3N-3 · S/N 2910Cancelled Aug 9, 1974 · Built 1943 · Watts Agricultral Service N4676YPiper PA-25-235 · S/N 25-4400Cancelled May 7, 1974 · Built 1967 · Medlock Dusters

Back to Woodland, CA