Skip to content

Sherman Oaks, CA

Cancelled registrations · 48

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

N1119YCessna 150B · S/N 15059519Cancelled Jan 2, 2023 · Registration expired, pending cancellation · Built 1962 · Klein Harvey J N48704Fairchild M-62A · S/N 7373AECancelled Sep 27, 2019 · Revoked, canceled · Built 1943 · Erbes Dan P N6912CPiper PA-28-181 · S/N 28-8590051Cancelled Mar 6, 2019 · Registration expired, pending cancellation · Built 1985 · Potkin Brian E N420LCComposit Airplanes Spol Sro VIVA · S/N 01Cancelled Jun 8, 2017 · Registration expired, pending cancellation · Knutson Ty R N741ZMason BABY LAKES · S/N JM-4Cancelled Feb 4, 2017 · Revoked, canceled · Built 1975 · Rosenfield Richard Evans N54281Lockheed 382C · S/N 382-4281Cancelled May 11, 2015 · Registration expired, pending cancellation · Airplane Sales International Corporation N8042HBeech C18S · S/N 6572Cancelled Oct 6, 2014 · Revoked, pending cancellation · Built 1956 · Harling Donn N1300BLuscombe 8E · S/N 5927Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1948 · Peterson C W N6638Denny Reginald I · S/N 50131Cancelled Sep 26, 2013 · Revoked, canceled · Built 1924 · Denny Reginald N9090AEPP Robert HP-18 · S/N 18-82Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1980 N8231TPiper PA-28-161 · S/N 28-8016349Cancelled Aug 16, 2013 · Exported to Colombia · Swedgroup Inc N7619EBellanca 14-19-3 · S/N 4121Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1959 N74310Bellanca 14-13-2 · S/N 1423Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1947 · Lewis Reg R N386CXYuneec International YUNEEC E430 · S/N YN-E430-0905-001Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 2009 · Knutson Ty R N1885RRaven Industries RX6 · S/N RX6-267Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1977 · Barker Roger N69022Cessna UC-77B · S/N 3391Cancelled Feb 8, 2012 · Revoked, pending cancellation · Built 1943 · Standard Engng Corp N4495TPiper PA-34-200 · S/N 34-7250114Cancelled Sep 8, 2008 · Triennial form not returned · Built 1972 · Cobalt H20 Inc N19397Cessna 150L · S/N 15074392Cancelled Apr 22, 2008 · Exported to Philippines · Built 1973 · One Third Chow LLC N669SBInterplane SKYBOY · S/N 66 2002Cancelled Nov 8, 2007 · Triennial form not returned · Built 2002 · Proxi-Mate LLC N6780GCessna 150L · S/N 15072280Cancelled Mar 22, 2007 · Exported to Philippines · Built 1970 · Hovnanyan Ari N983USMcdonnell Douglas DC-9-32 · S/N 47282Cancelled Jul 27, 2006 · Exported to Venezuela · Built 1969 · Sierra Aircraft Leasing LLC N985USMcdonnell Douglas DC-9-32 · S/N 47479Cancelled Jul 27, 2006 · Exported to Venezuela · Built 1970 · Sierra Aircraft Leasing LLC N156UBeech V35A · S/N D-8840Cancelled Dec 19, 2002 · Triennial form not returned · Built 1968 · Bottlo Arpad I N30JYRDF Media.Com RDF-UK · S/N 0230Cancelled Sep 10, 2002 · Rdf Media.Com Ltd N31JYRDF Media.Com RDF-FR · S/N 0231Cancelled Sep 10, 2002 · Rdf Media.Com Ltd N32JYRDF Media.Com RDF-US · S/N 0232Cancelled Sep 10, 2002 · Rdf Media.Com Ltd N6791PBeech B36TC · S/N EA-404Cancelled Sep 8, 2000 · Triennial form not returned · Lofton William G N6272JPiper PA-28-181 · S/N 28-7690389Cancelled Apr 5, 2000 · Levy Leon N4030ARobinson Helicopter R22 BETA · S/N 1537Cancelled Nov 28, 1994 · Triennial form not returned · Klein Ray DBA N6879WPiper PA-28-140 · S/N 28-21035Cancelled Jan 30, 1979 · Exported to Mexico · Reid Theodore C N22177Cessna 150H · S/N 15068117Cancelled Sep 1, 1977 · Built 1967 · Schoeppe Hans J N9627SChampion 7ECA · S/N 386Cancelled Jul 15, 1977 · Built 1966 · Wooten Charles N8239MCessna 210K · S/N 21059239Cancelled May 26, 1976 · Argo Construction Co Inc N374SRCessna 172H · S/N 17256017Cancelled Jun 20, 1974 · Mulne Steve N7415PPiper PA-24-250 · S/N 24-2603Cancelled Sep 7, 1971 · Stine John O & Elizabeth N7494XCessna 172B · S/N 17247994Cancelled Jun 29, 1970 · Built 1960 · Knapp Forest N6482SCessna 150H · S/N 15067282Cancelled Jun 22, 1970 · Milton Hoffman N6767UMooney M20C · S/N 2489Cancelled Nov 15, 1967 · Monarch Flight Sales & Service Inc N91106North American NAVION · S/N NAV-4-8Cancelled Jul 29, 1965 · Built 1946 · Sterman Harvey N441JBeech 95-A55 · S/N TC-219Cancelled Jun 17, 1965 · Michelmore D D N9845ACessna 195A · S/N 7538Cancelled May 21, 1965 · Rose Sherman A N5836BCessna 182 · S/N 33836Cancelled May 20, 1965 · Hopkins Harold W N9658CDouglas A-26C · S/N 28901Cancelled May 14, 1962 · Exported to Germany · Skyways Ferrying Service N901TBeech E18S · S/N BA-497Cancelled May 26, 1960 · Exported to Japan · Skyways Aircraft Ferrying Service Inc N8205ACessna 170B · S/N 25057Cancelled Aug 12, 1957 · Deleonard John P N36TPiper PA-12 · S/N 122532Cancelled Apr 9, 1957 · Exported to Canada · Aberle Dan N2760VBeech 35 · S/N D 149Cancelled May 5, 1954 · Epstein Ray J N14595Stinson SR-5A · S/N 9330ACancelled May 3, 1951 · Built 1935 · Dodson Robert S & Quinn Robert V

Back to Sherman Oaks, CA