Skip to content

Cancelled registrations · 37

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

N300CNPiper PA-31-325 · S/N 31-7512010Cancelled Apr 30, 2021 · Second renewal notice · Built 1975 · Blue Frog Charter Inc N8379MCessna A150K · S/N A1500079Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Pool Norman F N201SXMooney M20J · S/N 24-0308Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1977 · Rugger Investment Group LLC N612SPCessna 172S · S/N 172S8594Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2000 · Sohail Air Ventures LLC N234CVJohnsen Craig C AVID FLYER "B" · S/N 234Cancelled Jun 6, 2017 · Second renewal notice · Miller John F N736NXCessna R172K · S/N R1722668Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Stanzak David P N4326HMooney M20J · S/N 24-0707Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1978 · Ground Floor Design Inc N2827DHiller UH-12A · S/N 160Cancelled Dec 22, 2014 · Revoked, canceled · Built 1950 · Park Contractors Inc N8558JCessna 150G · S/N 15066458Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1967 · Fisher Eugene K N777TTBeech 35-B33 · S/N CD-678Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1964 · Harvey Thayer A N716TTemco D-16A · S/N TTN-84Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1948 · Hamilton Gay M N114DEPrizio David P TEXAS SPRT CUB TX11J · S/N TX1004Cancelled Mar 27, 2014 · Built 2008 · Prizio David P N505RGCessna 172R · S/N 17280340Cancelled Dec 12, 2013 · Exported to South Korea · Built 1998 · Haacker Thomas J Trustee N992ZZWard Robert Edward QUICKSILVER MXL II · S/N 1338Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Ward Robert E N2715KCarlson Jon B MONO-FLY · S/N 3408Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1982 · Plesetz James H N9572YBeech 95-A55 · S/N TC-352Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1962 · Klingensmith Cloyd H N919PWCessna 421C · S/N 421C0891Cancelled May 22, 2013 · Exported to Germany · Built 1980 · American Display Inc N7829SBell 47G-3B-1 · S/N 6622Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1967 · Goldenwest Funding Inc N60985Cessna 150J · S/N 15070716Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1969 · Zylstra Robert Harry N327NMCirrus Design SR22T · S/N 0338Cancelled Apr 8, 2013 · Exported to Slovenia · Built 2012 · Vlok Aviation LLC N410DSPiper PA-34-200 · S/N 34-7250240Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1972 · Lapin Ari D N4235KRyan NAVION · S/N NAV-4-1235Cancelled Jun 14, 2012 · Revoked, canceled · Built 1948 · Ford Birchard H N9638ZBensen B-8M · S/N 1Cancelled Sep 17, 2009 · Registration revoked · Built 1963 · Wright Patrick W N7361QCessna 182P · S/N 18261001Cancelled Jul 17, 2009 · Exported to Palau · Built 1972 · Ujiie Andrew Naoto N89158Cessna 152 · S/N 15282653Cancelled Oct 25, 2001 · Triennial form not returned · Built 1978 · Edwards John H N6377GCessna 150K · S/N 15071877Cancelled Sep 19, 2001 · Triennial form not returned · Edwards John H N5780AS N I A S AS350D ASTAR · S/N 1341Cancelled Nov 3, 1995 · Exported to New Zealand · Focus Growth Associates Inc N2314PPiper PA-38-112 · S/N 3879A0941Cancelled May 20, 1993 · Administratively canceled · Luttrell Howard N8537PYoung Ansel E JUNIOR ACE D · S/N 1Cancelled Oct 26, 1984 · Administratively canceled · Young Ansel E N7306BCessna A152 · S/N A1520742Cancelled Mar 26, 1982 · Ryan Dennis Michael N1025AReims CESSNA F337G · S/N 3370069Cancelled Aug 21, 1981 · Exported to Gambia · Gilbert Thomas A N98475Piper J3C-65 · S/N 18675Cancelled Aug 13, 1981 · Sale reported · Built 1946 N5963JCessna A150L · S/N A1500263Cancelled Jun 28, 1977 · George Robert N14BAAbernathy SG-1A · S/N BA1Cancelled May 5, 1975 · Abernathy Bill J N97444Stinson 108 · S/N 108-444Cancelled Jun 30, 1970 · Built 1946 · Brooks Lyle C N7157RPiper PA-28-140 · S/N 28-21865Cancelled Jun 9, 1970 · Forkner W G & Dorothy Forkner N877TBeech A35 · S/N D-2199Cancelled Aug 5, 1968 · Robert E Sharp

Back to Tustin, CA