Fullerton, CA

Cancelled registrations · 246

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

N8697CPiper PA-22-135 · S/N 22-1338Cancelled Jul 15, 1971 · Cox Carl AN9844XCessna 185 · S/N 185-0044Cancelled Apr 30, 1971 · Built 1961 · Missionary Aviation FellowshipN6015DPiper PA-22-150 · S/N 22-4668Cancelled Feb 9, 1971 · Meyers Terrence LN7511XCessna 172B · S/N 17248011Cancelled Jan 4, 1971 · Ful-Air ServiceN1457BLuscombe 8F · S/N 6084Cancelled Nov 30, 1970 · Carter Richard DN6684BCessna 310C · S/N 35784Cancelled Sep 4, 1970 · Gianetti John MdN8188SCessna 150F · S/N 15061788Cancelled Aug 14, 1970 · James G Gelder School Of FlightN1074CMooney M20A · S/N 1345Cancelled Aug 3, 1970 · Exported to Canada · Built 1959 · Air-O-Brokerage CorpN8387XCessna 172C · S/N 17248887Cancelled Jun 30, 1970 · Missionary Aviation FellowshipN9234VMooney M20C · S/N 690057Cancelled Jun 29, 1970 · American Aircraft Leasing IncN8594KStinson 108-1 · S/N 108-1594Cancelled Jun 2, 1970 · Built 1947 · Kahn T RN6219NBell 47G-3B-1 · S/N 6657Cancelled May 7, 1970 · Exported to Canada · Southern California Edison CoN946DStinson 108-2 · S/N 108-2946Cancelled Mar 6, 1970 · Built 1947 · Stoddard Ray LN8996JPiper PA-28-180 · S/N 28-3020Cancelled Feb 18, 1970 · Exported to Canada · Tri Aviation CorpN2462FCessna 180H · S/N 18051664Cancelled Sep 12, 1969 · Exported to Mexico · Missionary Aviation FellowshipN91385Cessna 180H · S/N 18052055Cancelled Aug 4, 1969 · Exported to Philippines · Missionary Aviation FellowshipN72054Cessna TU206D · S/N U206-1269Cancelled May 8, 1969 · Exported to Indonesia · Missionary Aviation FellowshipN4841FCessna U206A · S/N U206-0541Cancelled Mar 26, 1969 · Exported to Kenya · Missionary Aviation FellowshipN2290TCessna A185E · S/N 1851451Cancelled Mar 19, 1969 · Exported to Mexico · Missionary Aviation FellowshipN29200Cessna TU206C · S/N U206-1161Cancelled Mar 18, 1969 · Exported to Indonesia · Built 1968 · Missionary Aviation FellowshipN29124Cessna U206C · S/N U206-1094Cancelled Jan 10, 1969 · Exported to Brazil · Built 1968 · Missionary Aviation FellowshipN3479YCessna 180H · S/N 18051979Cancelled Nov 15, 1968 · Exported to Liberia · Missionary Aviation FellowshipN7257TCessna 172A · S/N 46857Cancelled Jul 12, 1968 · Exported to Zimbabwe · Missionary Aviation FellowshipN3356LCessna A185E · S/N 185-1308Cancelled Mar 27, 1968 · Exported to Venezuela · Missionary Aviation FellowshipN5094UCessna 206 · S/N 206-0094Cancelled Dec 5, 1967 · Exported to Australia · Missionary Aviation FellowshipN3847GCessna TU206B · S/N U206-0847Cancelled Aug 3, 1967 · Exported to Indonesia · Missionary Aviation FellowshipN7954VCessna 180H · S/N 18051854Cancelled Jun 29, 1967 · Exported to South Africa · Built 1967 · Missionary Aviation FellowshipN3402LCessna TU206B · S/N U206-0702Cancelled May 2, 1967 · Exported to Indonesia · Missionary Aviation FellowshipN2668QCessna 182K · S/N 18257868Cancelled Jan 31, 1967 · Exported to Democratic Republic of the Congo · Missionary Aviation FellowshipN4857FCessna U206A · S/N U206-0557Cancelled Jun 21, 1966 · Exported to Democratic Republic of the Congo · Missinary Avaition FellowshipN2427FCessna 180H · S/N 18051627Cancelled Feb 8, 1966 · Exported to Honduras · Missionar Aviation FellowshipN6873PPiper PA-24-250 · S/N 24-2008Cancelled Jan 19, 1966 · Air O Brokerage CorpN1550FCessna 185D · S/N 185-0913Cancelled Nov 23, 1965 · Missionary Aviation FellowshipN1569FCessna 185D · S/N 185-0946Cancelled Oct 22, 1965 · Exported to Indonesia · Missionary Aviation FellowshipN6390UAero Commander 500-B · S/N 1506-180Cancelled Aug 16, 1965 · Exported to Indonesia · Missionary Aviation FellowshipN5849TCessna 185C · S/N 185-0749Cancelled Jul 31, 1965 · Exported to Democratic Republic of the Congo · Missionary Aviation FellowshipN1530FCessna 185D · S/N 185-0873Cancelled Jul 20, 1965 · Exported to Indonesia · Missionary Aviation FellowshipN56359Consolidated Vultee BT-13A · S/N 1837Cancelled May 25, 1965 · Arbue W FulmerN2911DCessna 170B · S/N 26854Cancelled May 24, 1965 · Exported to Australia · Missionary Aviation FellowshipN5164HPiper PA-14 · S/N 14-173Cancelled May 24, 1965 · Exported to Honduras · Missionary Aviation FellowshipN1161BLuscombe 8A · S/N 5788Cancelled May 18, 1965 · Fallin Air ServiceN1548BLuscombe 8E · S/N 6175Cancelled May 18, 1965 · Fallin Air ServiceN7867ACessna 180A · S/N 32764Cancelled May 4, 1965 · Exported to Australia · Missionary Aviation FellowshipN1521FCessna 185D · S/N 185-0864Cancelled Apr 7, 1965 · Exported to Australia · Missionary Aviation FellowshipN4714UCessna 180G · S/N 18051414Cancelled Nov 30, 1964 · Exported to Venezuela · Built 1964 · Missionary Aviation FellowshipN4760UCessna 180H · S/N 18051460Cancelled Nov 20, 1964 · Exported to Ecuador · Missionary Aviation FellowshipN5872TCessna 185C · S/N 185-0772Cancelled Aug 21, 1964 · Exported to Indonesia · Missionary Aviation FellowshipN5862TCessna 185C · S/N 185-0762Cancelled Aug 14, 1964 · Exported to Australia · Missionary Aviation FellowshipN6483XCessna 180D · S/N 18050983Cancelled Jun 18, 1964 · Exported to Republic of the Congo · Missionary Aviation FellowshipN7657ACessna 180 · S/N 32554Cancelled May 20, 1964 · Exported to Kenya · Missionary Avaition Fellowship
Back to Fullerton, CA