Skip to content

Cancelled registrations · 56

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

N222NHDiamond Aircraft Ind DA20-C1 · S/N C0030Cancelled Aug 6, 2026 · Exported to Israel · Built 1998 · Kelly Gaston E N200WMCessna 421B · S/N 421B0332Cancelled Oct 12, 2024 · Registration pending, canceled · Built 1972 N414RJCessna 414 · S/N 414-0632Cancelled Mar 30, 2024 · Sale reported, canceled N684KTravel Air E-4000 · S/N 1274Cancelled Jul 14, 2022 · Sale reported, canceled N20395Bell 206B · S/N 3301Cancelled Apr 21, 2022 · Exported to Canada · Built 1981 · Rogers Helicopters Inc N12ELGlasflugel STD LIBELLE 201B · S/N 199Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1971 · Paoli Michael P N8473KStinson 108-1 · S/N 108-1473Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1946 · Hurley James Don N692RJDJI PHANTOM 3 PROFESSION · S/N MSIP-CRM-DJI-WM323Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Cenpac Images LLC N433MBeech 95-A55 · S/N TC-342Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1962 · Barber Lawson E N32358Porterfield CP-65 · S/N 812Cancelled Apr 22, 2019 · Revoked, canceled · Built 1940 · Watson Donald R N950CStinson 108-3 · S/N 108-3950Cancelled Mar 8, 2019 · Built 1947 · Hatch David G N586ZPDJI S900 · S/N SBD3Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Poss William A N201XTMooney M20J · S/N 24-0505Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1978 · Ultimate Athlete Corp LLC N9952Travel Air C-4000 · S/N 1150Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1929 N35SDBeech V35A · S/N D-8812Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1968 · Floyd Johnston Construction Co Inc N40222Raven S55A · S/N S55A-836Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Collins Douglas D Jr N2763MBell 206B · S/N 2646Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Tgr Helicopters N99085Engineering & Research ERCOUPE 415-C · S/N 1708Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Jackson Don N3518MPiper PA-31-350 · S/N 31-7952101Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Built 1979 · Wofford Aviation Inc N4533KRyan NAVION · S/N NAV-4-1533Cancelled Dec 2, 2014 · First renewal notice · Built 1948 · Flaugher Jonathan S N2328LBeech 23 · S/N M-159Cancelled Jun 24, 2014 · Third renewal notice · Built 1963 · Wajda Bradley T N224KFBeech V35B · S/N D-9686Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1974 N8046XPutnam Thomas S RAF GT 2000 · S/N H2-93-5-136Cancelled Aug 2, 2013 · Sale reported, canceled · Built 1994 N5890YPiper PA-23-250 · S/N 27-3043Cancelled Jun 13, 2013 · Sale reported, canceled N1768Lester & Knobloch FS-1 · S/N 2Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1968 · Weymouth Eldrige E N874Sikorsky S-55 · S/N 551004Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1956 N5164VStits-Scholl SA6B · S/N 113Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1959 N7118DBalloon Works FIREFLY 8B · S/N F8B-133Cancelled Aug 6, 2012 · Registration pending, canceled N31320Hanawalt BRIEGLEB BG-12/16 · S/N 266Cancelled Feb 25, 2012 · Sale reported, pending cancellation · Built 1976 N109WMesserschmitt ME 109 C4K · S/N 234Cancelled Nov 18, 2009 · Exported to Germany · Kindsvater Harold E Trustee N104GHHarris FLY BABY 1 · S/N 6616Cancelled Mar 11, 2009 · Triennial form not returned · Built 1974 · Harris Gene N6963RSikorsky S62A · S/N 62124Cancelled Mar 3, 2004 · Exported to Australia · Built 1968 · Rogers Leasing N108UNord 1002 · S/N 88Cancelled Feb 25, 2004 · Exported to Germany · Built 1945 · Kindsvater Harold E Trustee N911RABell 222B · S/N 47150Cancelled Aug 28, 2000 · Rogers Helicopters Inc N5013HBell 222 · S/N 47010Cancelled Aug 18, 1999 · Exported to Rwanda · Rogers Helicopters Inc N546SHSweet D L/House R G MUSTANG II · S/N MII546Cancelled Dec 17, 1998 · Sweet David L N53RHKaman HH-43F · S/N 591569Cancelled Nov 16, 1998 · Triennial form not returned · Rogers Leasing N41521Piper PA-28-151 · S/N 287415135Cancelled Apr 29, 1998 · Triennial form not returned · Adventure Aviation N9656NBittner John L SNS-8 HYPERLIGHT · S/N 108Cancelled Jan 27, 1998 · Triennial form not returned · Bittner John L N5007LBell 222 · S/N 47008Cancelled Jul 29, 1997 · Triennial form not returned · Rogers Helicopters Inc N49561S N I A S AS-350C ASTAR · S/N 1011Cancelled Jul 9, 1997 · Exported to Canada · Rogers Helicopters Inc N414RHCessna 414 · S/N 4140457Cancelled Nov 14, 1995 · Triennial form not returned · Rogers Helicopters Inc N45EZMikolashek Robert C LONG-EZ · S/N 905Cancelled Oct 20, 1995 · Mikolashek Robert C N523RRBell Helicopter Textron 206L-1 · S/N 45231Cancelled Sep 28, 1995 · Triennial form not returned · Rogers Helicopters Inc.N23CCFish Joe-Kermit SKY RANGER · S/N 8200Cancelled May 3, 1995 · Triennial form not returned · Fish Joseph F N83556Robinson Helicopter R22 · S/N 0300Cancelled Jan 5, 1993 · Burnstein Robert E N6958RSikorsky S62A · S/N 62123Cancelled Feb 20, 1992 · Triennial form not returned · Rogers Helicopters Inc N738PFCessna 172N · S/N 17270125Cancelled Dec 26, 1990 · Gawley Dale V N732TTCessna T210M · S/N 21061768Cancelled Jul 6, 1984 · Kesterson Investment Co N2482BPiel Emeraude CP-301A · S/N 1158Cancelled Jun 21, 1973 · Brown Floyd L Jr

Back to Clovis, CA