OpenAirDocs.org
San Fernando, CA

Cancelled registrations · 43

Query with SQL
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 = 'SAN FERNANDO'
  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.

N2164PPiper PA-23 · S/N 23-766Cancelled Aug 29, 2019 · Revoked, canceled · Built 1956 · Endress Gareth LN72443Cessna 140 · S/N 9608Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Brummitt James EN35591Piper J5A · S/N 5688Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Pan Air Flight Svc IncN6622BCessna 310B · S/N 35722Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1958 · Poly Products IncN6598MCessna 152 · S/N 15284771Cancelled Aug 6, 1982 · Shortfield Flying Service IncN3133YCessna 182E · S/N 18254133Cancelled Jun 11, 1975 · Poly Products IncN7004SCessna 150H · S/N 15067704Cancelled Aug 2, 1974 · Glendale School Of AeronauticsN67976Consolidated Vultee BT-13 · S/N 2982Cancelled Feb 2, 1971 · Kenneth LinthicumN53258Beech AT-10GF · S/N 535Cancelled Jan 25, 1971 · San Fernando Drag Strip And Airport CorpN9610CNorth American B-25J · S/N 44-30585Cancelled Oct 26, 1970 · San Fernando Drag StripN59651Cessna T-50 · S/N 4731Cancelled Aug 31, 1970 · Kellog William HN2195EAeronca 7AC · S/N 7AC-5769Cancelled Jul 21, 1970 · Built 1946 · Blair Milton CN6240GLockheed 1049G · S/N 4665Cancelled Jul 2, 1970 · California Airmotive CorpN7926ZCessna 150C · S/N 15060026Cancelled Jun 30, 1970 · Glendale School Of AeronauticsN8212SCessna 150F · S/N 15061812Cancelled Jun 10, 1970 · Glendale School Of AeronauticsN1270YCessna 150B · S/N 150-59670Cancelled Jan 18, 1966 · Glendale School Of AeronauticsN183BBell 47D · S/N 37Cancelled Jun 18, 1964 · Exported to Mexico · Comet CoptersN2718AAero Commander 520 · S/N 66Cancelled Oct 4, 1961 · Exported to Jordan · A & F Helicopter CoN4929VBell 47D · S/N D-6Cancelled Dec 2, 1960 · Exported to United Kingdom · A-F Helicopter IncN6213KRepublic RC-3 · S/N 416Cancelled Jan 21, 1960 · Exported to France · A-F Helicopter IncN94574Consolidated Vultee PBY-5A · S/N 1619Cancelled Dec 1, 1959 · Exported to Netherlands · A-F Helicopters IncN113BBell 47B · S/N 33Cancelled May 26, 1959 · Exported to Canada · Agricultural Helicopters IncN6152KRepublic RC-3 · S/N 340Cancelled Apr 1, 1959 · A-F Helicopters IncN68753Consolidated PBY-5A · S/N 180Cancelled Oct 14, 1957 · Exported to Austria · A-F Helicopters IncN68766Consolidated Vultee PBY-5A · S/N 1859Cancelled Aug 7, 1957 · Exported to Papua New Guinea · A-F Helicopters IncN6675CDehavilland DHC-2 · S/N 1019Cancelled Nov 29, 1956 · A-F Helicopters IncN3539EAeronca 7AC · S/N 7AC-6891Cancelled May 24, 1956 · Pan Air Flight Service IncN18992Mitchell Donald Smith 278 · S/N 100Cancelled Feb 20, 1956 · Donald Smith MitchellN57466Consolidated Vultee BT-13A · S/N 11881Cancelled Oct 24, 1955 · Jarett Granville SN15760Taylorcraft A · S/N 37Cancelled Oct 19, 1955 · Corbeil Ernest LN48500Fairchild M-62B · S/N T43-5420Cancelled Oct 11, 1955 · Brooks John JN3894NBeech 35 · S/N D-1139Cancelled Sep 7, 1955 · Built 1947 · Mock Theodore EN84502Aeronca 7AC · S/N 7AC-3199Cancelled Sep 9, 1954 · Built 1946 · Pan Air Flight Service IncN9064ACessna 170A · S/N 18823Cancelled Mar 24, 1954 · Exported to Brazil · Hilberg Steven MurrayN28389Bowlus Sailplanes BM-5 · S/N 101Cancelled May 8, 1951 · Bowlus Sailplane IncN1955Bowlus PRIMARY GLIDER · S/N 500Cancelled Feb 27, 1950 · Built 1945 · Bowlus William HawleyN47864Taylorcraft DCO-65 · S/N L5270Cancelled Nov 17, 1948 · Thomas F MorrisonN33624Bowlus BA-100 · S/N 150Cancelled Sep 20, 1948 · Bowlus Sailplanes IncN33686Nelson BB-1 · S/N 501Cancelled Sep 9, 1948 · Built 1946 · Nelson Aircraft CorpN28386Bowlus Sailplanes BM-5 · S/N 100Cancelled Aug 9, 1948 · Bowlus Sailplanes IncN13399Bowlus BA2S · S/N 100Cancelled Jul 19, 1948 · Built 1940 · Bowlus Sailplanes IncN21757Albert Criz M C 1 · S/N 1Cancelled Jun 10, 1948 · Built 1943 · Albert Criz CoN12248Marion Lee Stone/Frank Kerns SAILPLANE · S/N 2Cancelled Feb 1, 1939 · L H Morrison
Back to San Fernando, CA