Skip to content

Cancelled registrations · 69

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

N9659MMooney M20F · S/N 670236Cancelled Mar 23, 2026 · Sale reported, canceled · Built 1966 N662WBBurris Richard ZODIAK 601XLB · S/N 6-6056Cancelled Mar 25, 2025 · Built 2017 · Burris Richard N7501TCessna 172A · S/N 47101Cancelled Nov 27, 2023 · Sale reported, canceled N1682GChampion 7KCAB · S/N 137Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1968 · Three Point Partners Inc N108ERPiper PA-28R-201 · S/N 2844147Cancelled Sep 8, 2021 · Exported to Costa Rica · Built 2014 · Collado Myrna Chang N8289MLawrence Bell/Howard Masquelie KR2 SPORT · S/N L&B2017Cancelled Aug 13, 2019 · Masquelier Howard W N777PACessna U206E · S/N U206-01629Cancelled Sep 26, 2016 · Exported to Canada · Built 1970 · Rti Aircraft Sales LLC N985SPCessna 172S · S/N 172S8189Cancelled Jun 22, 2016 · Exported to Thailand · Built 1999 · Rti Aircraft Sales LLC N2447SCessna 172R · S/N 17280886Cancelled Apr 25, 2016 · Exported to Thailand · Built 2000 · Rti Aircraft Sales LLC N9533DCessna 172R · S/N 17280476Cancelled Jul 29, 2015 · Exported to China · Built 1998 · Rti Aircraft Sales LLC N2317UCessna 172R · S/N 17280695Cancelled May 27, 2015 · Exported to Indonesia · Built 1999 · Rti Aircraft Sales LLC N624QFCessna 172R · S/N 17280111Cancelled May 27, 2015 · Exported to Indonesia · Built 1997 · Rti Aircraft Sales LLC N26495Cessna 172R · S/N 17280597Cancelled May 21, 2015 · Exported to South Korea · Built 1998 · Rti Aircraft Sales LLC N6796UMooney M20C · S/N 2508Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1963 · Ryan Vincent B N9034NDon Whilldin Parachute Service AX6DW1 · S/N 117888Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Whilldin Donald J DBA N122MSSparks Manuel KR-2 · S/N MS-2Cancelled Aug 28, 2014 · First renewal notice · Built 1982 · Sparks Manuel T N67142Bell 47G-3B-1 · S/N 7824Cancelled Sep 26, 2013 · Revoked, canceled · Built 1966 · San Diego Rotorcraft Co N6759TCessna 310D · S/N 39059Cancelled Sep 26, 2013 · Revoked, canceled · Built 1960 · Welch Frank G N16DLLatham Donald W KR-2 · S/N 5968Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1990 · Latham Donald W N17036Porterfield 35-70 · S/N 236Cancelled Apr 2, 2013 · Sale reported, pending cancellation · Built 1937 N3687CCessna 180 · S/N 31186Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1954 · Miller Frederic H N104PABeech AT-11 · S/N 3266Cancelled Sep 18, 2012 · Revoked, canceled · Built 1942 · Flying Unlimited N53285Schweizer SGS 2-8 · S/N 23Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1941 N5402ZPiper PA-22-108 · S/N 22-9173Cancelled Aug 21, 2012 · Revoked, canceled · Built 1961 · Johns William L N50230Cessna 150H · S/N 15069152Cancelled Aug 10, 2012 · Revoked, canceled · Built 1968 · El Cajon Flying Service Inc N50236Cessna 150H · S/N 15069158Cancelled Aug 10, 2012 · Revoked, canceled · Built 1968 · El Cajon Flying Service Inc N30973Piper J4A · S/N 41245Cancelled Aug 19, 2011 · Revoked, pending cancellation · Built 1940 · Mcmillen Aircrft Sales & Svc Inc N9827LCessna 320B · S/N 320B0027Cancelled Jul 19, 2011 · Expired dealer · Built 1963 · Western Sun Aviation Inc N3573BBeech B50 · S/N CH-33Cancelled Jul 5, 2011 · Revoked, canceled · Built 1954 · Cameron Bros Const Co Inc N10533Tupta Jospeh A STARDUSTER TOO SA300 · S/N 1586Cancelled Jun 28, 2011 · Sale reported, canceled · Built 1980 N32ZHSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 355Cancelled May 6, 2010 · Exported to Canada · Built 2002 · Davis John R N24516Cessna 152 · S/N 15283280Cancelled Jun 22, 2007 · Exported to Philippines · Built 1979 · Parisette Regina Marahrens N118DFBoeing 727-2A1 · S/N 21344Cancelled Sep 10, 2004 · John Hanson & Associates Inc N43BDI.C.A.-Brasov IS-32A · S/N 07Cancelled Mar 31, 2004 · Exported to Canada · Built 1985 · Smith Bruce Martin Trustee N210PAshley SP-5 · S/N 193466Cancelled Dec 4, 2003 · Triennial form not returned · Built 1937 · Mcallister Robert G N8364LCessna 172I · S/N 17256564Cancelled Dec 22, 1998 · Crutchfield Richard N6473QCessna 152 · S/N 15285258Cancelled Apr 13, 1998 · Exported to Mexico · Howard John E N70064Straightiff Gene SONERAI II L · S/N 1291Cancelled Jul 7, 1995 · Triennial form not returned · Straightiff Gene L N4847DCessna 182A · S/N 34947Cancelled Apr 14, 1995 · Triennial form not returned · Baggett Chester J N120SCBell 47G-3B-1 · S/N 3420Cancelled Aug 17, 1992 · Exported to Mexico N9129UThompson Roger Duane AVID FLYER · S/N 258Cancelled Dec 4, 1991 · Triennial form not returned · Thompson Roger D N6017EBeech C23 · S/N M2142Cancelled Sep 25, 1991 · Ineson Thomas N4158EPiper PA-25-235 · S/N 25-7856046Cancelled Aug 18, 1980 · Exported to Mexico · Jensen Lg DBA Jensen Marine Mart N9281HCessna 172M · S/N 172-66066Cancelled Jul 13, 1978 · Exported to Mexico · El Cajon Flying Service Inc N7755NPiper PA-28-180 · S/N 28-5202Cancelled Mar 10, 1978 · March Leo A N9935LAmerican AA-1B · S/N 0235Cancelled Nov 22, 1974 · Police Recreational Order Of Pilots N7964GCessna 172L · S/N 17259664Cancelled Nov 15, 1973 · El Cajon Flying Service Inc N46008Cessna 172I · S/N 17256985Cancelled Jun 25, 1973 · Built 1968 · El Cajon Flying Service Inc N1191YCessna 150B · S/N 15059591Cancelled Jun 16, 1972 · Exported to Mexico · Don Marks Aircraft Repair Service N2827FCessna 182J · S/N 18256927Cancelled Jan 25, 1972 · El Cajon Flying Service

Back to Santee, CA