Skip to content

Cancelled registrations · 45

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 = 'FAIR OAKS' 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 = 'FAIR OAKS'
  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 = 'FAIR OAKS'
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.

N56SZPdps Pzl-Bielsko SZD-59 · S/N B-2178Cancelled Dec 21, 2023 · Exported to Canada · Built 1998 · Acheson Guy E N55873Piper PA-28-140 · S/N 28-7325513Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Clinton Richard C N28348Grumman American Avn. AA-5B · S/N AA5B0577Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1977 · Whelpley Mark B N82LSSpannagel Lawrence E JR RV-8A · S/N 81013Cancelled Jan 11, 2022 · Sale reported, canceled · Built 2004 N141EWSementilli Richard MONOWHEEEL XS · S/N A141Cancelled Jun 4, 2021 · Exported to Argentina · Built 2005 · Johnson Todd L N31191Condrey Robert L DRIFTER · S/N 417Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 2007 · Condrey Robert L N97953Stinson 108 · S/N 108953Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Corl Arthur Duane N592GTDJI Innovations INSPIRE 1 · S/N W13DCC30030478Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Nelson Timothy N570CTDJI S1000 · S/N 00L0120625Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Nelson Timothy N78932Mooney M20A · S/N 1966Cancelled May 18, 2018 · Revoked, canceled · Built 1962 · Mathisen Eldred L N43001Taylorcraft BF · S/N 6660Cancelled Nov 28, 2017 · Revoked, canceled · Built 1945 · Tileston Thomas S N8549GCessna 150F · S/N 15062649Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1965 · Korsrud Brian P N3561HErcoupe 415-C · S/N 4186Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1946 · Lautamo Aimo E N88JDudley GLASS SLIPPER · S/N 1ACancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1973 · Smith James C N5210XCessna 320 · S/N 320-0110Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1962 · Cox Robert W N37459Interstate S-1A · S/N 307Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1942 · Borchert Lawrence K N3522BBeech E35 · S/N D-3739Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1954 N7952ACessna 172K · S/N 17258146Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1969 N88969Glasflugel H 301 LIBELLE · S/N 18Cancelled Jul 9, 2013 · Exported to Argentina · Built 1966 N7803TCessna 172A · S/N 47403Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1960 N36514Aeronca 65-CA · S/N C-15921Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1941 N15259Piper PA-32-300 · S/N 32-7340026Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1972 · Vukich Ronald R N19FDCessna 172 · S/N 28354Cancelled Aug 6, 2012 · Sale reported, canceled · Built 1956 N8793UCessna 172F · S/N 17252698Cancelled Aug 25, 2010 · Built 1965 · Low Flying Angels Inc N3350RGlaser-Dirks DG-600M · S/N 669M19Cancelled Jan 3, 2001 · Exported to Canada · Lipe J Steele N62199Wassom Warren Clarke CHRISTAVIA MK 1 · S/N 999Cancelled Feb 15, 2000 · Triennial form not returned · Wassom Warren C N8090BCessna 172 · S/N 29890Cancelled Jul 28, 1998 · Triennial form not returned · Manning Wayne E N66841Beech F33A · S/N CE888Cancelled Apr 9, 1991 · Triennial form not returned · Western Housing Development Co Inc N24470Cessna 152 · S/N 15280270Cancelled May 11, 1984 · Second triennial mailing, no response · Engle Flying Service Inc N50520Cessna 172M · S/N 17264208Cancelled Sep 24, 1982 · Exported to Australia · West Coast Estates Ltd N4689HPiper PA-17 · S/N 17-87Cancelled Jul 14, 1981 · Exported to United Kingdom · Olson Russell M N5386TCessna 172E · S/N 17251286Cancelled May 7, 1981 · Low Flying Angels Club Inc N4477MCunningham MONARCH · S/N 20Cancelled Dec 20, 1977 · Cunningham Donald N2855YCessna 182E · S/N 18253855Cancelled Apr 8, 1976 · Exported to Canada · Kdele C N30267Cessna 172M · S/N 172-64130Cancelled Oct 16, 1975 · Exported to Canada · Engle Flying Service Inc N3653Fleming VOLKSPLANE · S/N F1Cancelled Jul 31, 1974 · Fleming Wesley T N3908NBeech 35 · S/N 1162Cancelled Jun 22, 1973 · Built 1947 · V Tail Flyers Inc N2742GCessna 182B · S/N 52042Cancelled Aug 13, 1971 · Exported to Canada · Built 1959 · Crinklaw Ranch Co Crinklaw Shirley C & Robert H N69071Cessna T-50 · S/N 4784Cancelled Feb 3, 1971 · Strode Ted E N67069Stinson L-5 · S/N 4290Cancelled Oct 9, 1970 · Fleming Wesley T N3951FCessna 172 · S/N 36851Cancelled Jun 29, 1970 · Fair Oaks Flying Club Inc N3872MPiper PA-12 · S/N 122782Cancelled May 25, 1965 · Mcadams Dale L N48614Fairchild PT-19A · S/N T42-3319Cancelled Nov 15, 1955 · Mcadams L Dale N8890KStinson 108-1 · S/N 108-1890Cancelled Jun 27, 1950 · Harrison E E Jr N10150Bowlus PRIMARY GLIDER · S/N S37Cancelled Apr 19, 1943 · Built 1930 · Powell Louis Horace

Back to Fair Oaks, CA