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

N124HAHiller UH-12E · S/N HA3024Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1975 · Marquis Aviation Inc N1732KSilvaire LUSCOMBE 8E · S/N 4459Cancelled Nov 27, 2020 · Registration pending, canceled · Built 1946 N17ECRoach/Sperry LANCAIR 320 · S/N 078Cancelled Apr 24, 2020 · Sale reported, canceled N5150TRichards Darrel Dean DRAGONFLY MK II · S/N 417Cancelled Jan 24, 2020 · Sale reported, canceled N7690MCessna 175 · S/N 55990Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Mallard Alma Duen N60SVBenson Ronald C SORRELL SNS-7 · S/N 236Cancelled May 30, 2018 · Sale reported, canceled N627RCWells Richard W 503 AIR COMMAND · S/N 0627Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1986 · Freund Michael R N36VRCooper Marcus F III RV-6 · S/N 24999Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1998 · Cooper Marcus F III N6053VWittman W-8 · S/N 1Cancelled Jan 14, 2014 · First renewal notice · Built 1958 · Williams Jerry M N1694GChampion 7KCAB · S/N 89Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1968 · Enloe Thomas S N5355GClacher Gregg Allison AIR COMMAND 532 · S/N 0405Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Clacher Gregg Allison N5101ZPiper PA-22-108 · S/N 22-8737Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1961 · Coelho Myron C N4049MRaven S55A · S/N S55A-856Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1982 · Thompson Martin N480AGAtac PREDATOR 480 · S/N X-1Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1984 · Advanced Technology Arcft Co Inc N5835CBeech C35 · S/N D-2787Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1951 · Derego Charles A N84045Caetano VOLKSPLANE VP2 · S/N V2-2352Cancelled Feb 27, 2013 · Sale reported, canceled N759DBeech C35 · S/N D-3029Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1951 N6312LAmerican AA-1A · S/N AA1A-0312Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1971 N62755Boeing A75N1(PT17) · S/N 75-2395Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1941 N4847APiper PA-22-150 · S/N 22-4000Cancelled Sep 18, 2012 · Revoked, canceled · Built 1956 · Mueller Corinne N9755VCessna A188 · S/N 188-0205Cancelled Mar 18, 2011 · Expired dealer · Built 1966 · H&S Agricultural Aviation N3530WPiper PA-32-260 · S/N 32-416Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1966 · Watson Leo A DBA N90086Jones Rodney V WITTMAN TAILWIND · S/N 001Cancelled Nov 19, 2009 · Built 2000 · Williams Jerry M N99751Calif Agricultural Aeronautics A75 · S/N 001Cancelled Oct 9, 2009 · Registration revoked · Built 1976 · California Agri Aero Inc N1851MBoeing E75 · S/N 75-8301Cancelled Jul 9, 2009 · Registration revoked · Built 1948 · California Agricultural Aero Inc N6286DThompson John O KITFOX IV · S/N 1714Cancelled Jun 15, 2007 · Triennial form not returned · Built 1996 · Thompson John O N129ACAmerican Champion 8KCAB · S/N 655-91Cancelled Jul 28, 2006 · Exported to Canada · Built 1991 · Mckinney Donald L N2764Okeefe-Pietenpol Aircamper OK · S/N 101Cancelled Nov 5, 2001 · Built 1969 · Van Allen Pat N516CARockwell International 114 · S/N 14076Cancelled Dec 28, 2000 · Triennial form not returned · Deremer Robert W N11919Cessna 150L · S/N 15075711Cancelled Oct 27, 2000 · Triennial form not returned · Sullivan Patrick C N6934ZNewport Wayne NIEUPORT 1 · S/N 001Cancelled May 10, 2000 · Triennial form not returned · Newport Wayne L N2246VPiper PA-28-161 · S/N 28-7916330Cancelled Apr 29, 1983 · Built 1979 · Calander Larry D Et Al N5862PPiper PA-24-250 · S/N 24-945Cancelled Feb 22, 1982 · Exported to Canada · Foster William J N80352Cessna 172M · S/N 17266542Cancelled Dec 28, 1981 · Sunset Aero Inc N62630Boeing A75N1 · S/N 75-2120Cancelled Oct 14, 1981 · Professionalair Care Inc N7405ZPiper PA-25-235 · S/N 25-3370Cancelled Aug 5, 1980 · Blair Air Service Inc N8463CAero Commander 680-E · S/N 680E-837-68Cancelled Sep 1, 1978 · Exported to Canada · Ellis Richard L N8581Anderson STARDUSTER SA-100 · S/N 1Cancelled Oct 20, 1976 · Anderson Clifford V N21775Cessna 188 · S/N 18801026Cancelled May 20, 1975 · Deroy Simpson Jr N21698Cessna A188B · S/N 18800965Cancelled Apr 26, 1974 · H & S Agricultural Aviation N3423WPiper PA-32-260 · S/N 32-284Cancelled Mar 12, 1974 · Baldrick George H N5663YPiper PA-23-250 · S/N 27-2729Cancelled Nov 15, 1972 · Roman Art N9327LAmerican AA-1A · S/N AA1A-0027Cancelled Aug 14, 1972 · Contreras Mario A N5125LPiper PA-28-180 · S/N 28-4408Cancelled Sep 20, 1971 · Hanford Aviation N7555ZPiper PA-25-235 · S/N 25-3605Cancelled Apr 15, 1971 · Exported to Canada · Kings Mosquito Abatement District N9630KUniversal Stinson 108-2 · S/N 108-2630Cancelled Mar 1, 1971 · O E Primrose N6864ZPiper PA-25-235 · S/N 25-2555Cancelled Jun 30, 1970 · George H Baldrick Inc N8191VCessna A188 · S/N 188-0441Cancelled May 25, 1970 · Exported to Canada · H & S Agricultural Aviation N2144CCessna 195B · S/N 16129Cancelled Jul 10, 1962 · Sur-Way Aviation Co N2055KLuscombe 8E · S/N 4782Cancelled Feb 21, 1956 · Smalley W T

Back to Hanford, CA