Cancelled registrations · 30

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 = 'SAN DIMAS' 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 = 'SAN DIMAS'
  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 = 'SAN DIMAS'
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.

N3530LCessna 150F · S/N 15062330Cancelled Nov 8, 2022 · Exported to China · Jenani Industries LLC N70CACessna 500 · S/N 500-234Cancelled Nov 8, 2022 · Exported to China · Jenani Industries LLC N9086HPiper PA-28-140 · S/N 28-7425209Cancelled Nov 8, 2022 · Exported to China · Built 1974 · Jenani Industries LLC N96LMAgusta AGUSTA A109 · S/N 7256Cancelled Nov 8, 2022 · Exported to China · Jenani Industries LLC N8153FCessna A150L · S/N A1500454Cancelled Aug 18, 2022 · Exported to Chile · Built 1973 · Campbell Donald B N325HBell 412EP · S/N 36251Cancelled May 6, 2021 · Exported to China · Altus Aviation Management N1257LRobinson Helicopter R44 · S/N 0713Cancelled Feb 10, 2020 · Exported to China · Built 2000 · Altus Aviation Management N417VImagination Visions RAPID PRO X8 · S/N 001Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Imagination Visions LLC N6588CMccain William A SWICK-T · S/N 1Cancelled Aug 15, 2019 · Exported to Canada · Built 1992 · Donnelly Francis A N6DTTellez David/Daniel ROTORWAY EXEC · S/N TNT 001Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Tellez David N129ABPiper PA-28-236 · S/N 28-7911303Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1979 · Netsense Inc N704WYCessna 150M · S/N 15078943Cancelled Dec 2, 2014 · Revoked, canceled · Built 1976 · Woods James M III N2222SSwann Lynn J GLASS GOOSE · S/N 145Cancelled Dec 4, 2013 · Built 1995 · Swann Lynn J N3124PPearson Brad SUPER KOALA · S/N SQB 008Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1992 · Pearson Brad N62RBBandfield Ray FALCON XP · S/N 600183Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1986 · Carril Ruben J N9655SChampion 7ECA · S/N 236Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1966 · Duricka Robert L N2417VGorsuch Robert R CJ-1 CORBY STARLET · S/N 752Cancelled Jul 24, 2012 · First renewal notice · Built 2007 · Gorsuch Robert R N239BJAero Vodochody L39C · S/N 931510Cancelled Apr 13, 2011 · Exported to Australia · Built 1979 · Sigtronics Corporation N26FLLaforge Fred William RV-4 · S/N VANS-2606Cancelled Jun 18, 2008 · Exported to Sweden · Built 1998 · Laforge Fred W N5843JCessna 182P · S/N 18263564Cancelled Jan 6, 2005 · Triennial form not returned · Built 1975 · Behr Albert L N9097NAero Commander 681 · S/N 6040Cancelled May 21, 2001 · Exported to Mexico · Davis George E N9843GCessna 172L · S/N 17259743Cancelled Sep 20, 1996 · Exported to Guatemala · Parker Dan N9198MCessna U206E · S/N U20601598Cancelled May 26, 1994 · Exported to Mexico · Davis George E N903RJPiper PA-24-260 · S/N 244403Cancelled Feb 25, 1993 · Triennial form not returned · Fuller Robert F N50161Hughes 269C · S/N 711061Cancelled Sep 3, 1992 · Exported to New Zealand N184DHeersema Daniel L THORP T-18 · S/N 1316Cancelled Oct 16, 1991 · Triennial form not returned · Heersema Daniel L N3490SCessna 182H · S/N 18255890Cancelled Jul 31, 1980 · Exported to Panama · Francis John W N50855Taylorcraft DCO-65 · S/N 4501Cancelled May 21, 1965 · Wallace Eugene Nally N4656VBeech C18S · S/N 3857Cancelled Jun 9, 1961 · Exported to Mexico · A Robert Rimpau N16ETimm COLLEGIATE · S/N 104Cancelled Dec 3, 1947 · Built 1930 · Stevens Arthur William

Back to San Dimas, CA