Skip to content

Cancelled registrations · 74

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 = 'YUBA CITY' 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 = 'YUBA CITY'
  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 = 'YUBA CITY'
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.

N4196ZSikorsky CH3E · S/N 65-12792Cancelled Apr 7, 2025 · Built 1965 · Siller Helicopters Inc N4197RSikorsky CH-53E · S/N 65-12796Cancelled Apr 7, 2025 · Siller Helicopters Inc N4230XSikorsky H3 · S/N 65-12787Cancelled Apr 7, 2025 · Siller Helicopters Inc N5770BCollison Roland B KILBURN COUGAR I · S/N WKICancelled Sep 27, 2022 · Sale reported, canceled N3630DSchweizer G-164B · S/N 756BCancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1984 · Andersons Flying Service Inc N3871LCessna 172G · S/N 17254040Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1965 · Hyatt Alexander J Jr N34658Stinson 10A · S/N 7958Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Ferguson John G N2460PSixchuter SR5XP · S/N 98-1986-SR5XPCancelled Aug 21, 2021 · Sale reported, canceled · Built 1986 N998NANorth American SNJ-5C · S/N 84998Cancelled Jul 17, 2020 · Sale reported, canceled N5136SArcturus T-16 · S/N 11060017Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Optec Solutions LLC N85RKKnight Roger E TAYLOR MONOPLANE · S/N KT-101Cancelled Jul 10, 2019 · Registration expired, pending cancellation · Built 1985 · Wilson Thomas E N696913D Robotics SOLO · S/N S111A5601306Cancelled May 4, 2019 · Registration expired, pending cancellation · Johnson Chris J N69692Yuneec International TYPHOON Q500 4K · S/N 3482812733Cancelled May 4, 2019 · Registration expired, pending cancellation · Johnson Chris J N7837XCessna 172B · S/N 17248337Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1961 · Hyatt Alexander J Jr N5304Grumman G-164A · S/N 593Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1969 · Twin Cities Aviation LLC N8011KGrumman Acft ENG Cor-Schweizer G-164B · S/N 538BCancelled May 15, 2017 · Registration expired, pending cancellation · Stadel Aircraft Inc N1877DBeech C35 · S/N D-3126Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1952 · Greene John P N68914Piper J3C-65 · S/N 9792Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Onstott Kenneth N80153Souza Henry T BANDIT · S/N 105Cancelled May 21, 2015 · Registration expired, pending cancellation · Souza Henry T N40DTBeech 95-B55 (T42A) · S/N TC-1134Cancelled Apr 8, 2015 · Second renewal notice · Built 1968 · Hilbers Inc N395SHoyle James I QUICKSLVR GT-500R912 · S/N 0371Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 2000 · Broce Donald S N5539WPiper PA-28-180 · S/N 28-629Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1962 · Baker Bradley R N614DRSikorsky H3 · S/N 66-13285Cancelled Apr 9, 2014 · Sale reported N778KACessna 172RG · S/N 172RG0251Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1980 · Skybound Aviation N67732Howard DGA-15P · S/N 1706Cancelled Sep 26, 2013 · Revoked, canceled · Built 1943 · Graham Leonard D N896RPGarlick Helicopters HH-1K · S/N 157198Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1970 · Rick Patterson Inc DBA N2968RPiper PA-28R-200 · S/N 28R-35353Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1969 · Clark Neil W N40108Raven Industries RALLY RX7 · S/N RX7-271Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1981 N5992Vonhuene HP-11A · S/N 46VHCancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1973 · Clark Arthur W N3347BPiper PA-22-135 · S/N 22-2162Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1954 · Krull Thomas E N9852LCessna 320B · S/N 320B0052Cancelled Mar 21, 2013 · Sale reported, canceled · Built 1964 N8113NTomei ED S12 XL · S/N 07960735Cancelled Mar 1, 2013 · First renewal notice · Built 1999 · Tomei Ed J N2708XCessna 335 · S/N 335-0034Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1979 · Bains Didar S N26381Aeronca 65-C · S/N L8430Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Built 1940 · Landis Lawrence L N3517EAeronca 7AC · S/N 7AC-6885Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1947 N63587Cessna T-50 · S/N 3043Cancelled Sep 5, 2012 · Revoked, canceled · Built 1942 · Rose Lester F N261KFTaylor J/Ellis D KITFOX IV SPDSTR · S/N ACS-091Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Taylor James L D N9754ACessna 170A · S/N 19215Cancelled Dec 19, 2011 · Exported to Canada · Built 1949 · Sunrise Dusters Inc N20686Luscombe 8 · S/N 840Cancelled Aug 19, 2011 · Revoked, pending cancellation · Built 1938 · Dutton Richard P N101JWWilson-James SKYBOLT · S/N 1Cancelled Jun 2, 2011 · Sale reported, canceled · Built 1979 N6491CStits Flutterbug SA6B · S/N 109Cancelled Dec 1, 2004 · Triennial form not returned · Built 1956 · Stadel Jim D N8351FHughes Helicopters HUGHES 369D · S/N 170008DCancelled Aug 31, 2000 · Triennial form not returned · A And P Helicopter Inc N8392KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 682BCancelled Aug 6, 1998 · Registration pending N6263UMooney M20C · S/N 2102Cancelled Dec 6, 1997 · Triennial form not returned · Hurd Byron L N1974APiper PA-20 · S/N 20883Cancelled Apr 6, 1993 · Triennial form not returned · Green Morley S N5501MAero Commander 200D · S/N 372Cancelled Mar 30, 1993 · Triennial form not returned · Vanderford Vinson G N4873HCessna 152 · S/N 15283993Cancelled Feb 7, 1991 · Second triennial mailing, no response · Carnes Stephen E N195RSStallins Raymond E CHRISTEN EAGLE-II · S/N STALLINS000195Cancelled Jan 4, 1991 · Triennial form not returned · Stallins Raymond E N99986Pilatus B-4 · S/N 113Cancelled Jan 14, 1982 · Administratively canceled · Brandt Dick W N8831BPiper PA-24-250 · S/N 24-1754Cancelled Oct 28, 1977 · Mccallum James F & Cheney Terry A

Back to Yuba City, CA