Skip to content

Cancelled registrations · 26

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 YSIDRO' 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 YSIDRO'
  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 YSIDRO'
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.

N1119Hogge Dennis Warren LANCAIR 320 · S/N 424Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Van Den Eeden Pedro E N107LVMartin Jorge W GT400 · S/N J101Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2005 · Martin Jorge W N7661CMartin Jorge W RACER · S/N J102Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2007 · Martin Jorge W N8278MCessna 210K · S/N 21059278Cancelled Jul 24, 2013 · Exported to Mexico · Built 1970 N64WSJohnson Dale A WOODSTOCK · S/N 64Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Johnson Dale N431QAContreras Vicente ROTORWAY A600 TALON · S/N 8037Cancelled Dec 10, 2010 · Exported to Mexico · Contreras Vicente N9374ZCessna TU206G · S/N U20606440Cancelled Feb 4, 2009 · Exported to Mexico · Built 1982 N6285YPiper PA-23-250 · S/N 27-3532Cancelled Dec 16, 2008 · Exported to Mexico · Zermeno Francisco T N8777QCessna U206G · S/N U20603529Cancelled Oct 28, 2008 · Exported to Mexico · Built 1976 · Contreras Vicente N4580XCessna TU206F · S/N U20602878Cancelled Apr 25, 2008 · Exported to Mexico N246PLCessna T210L · S/N 21059625Cancelled Apr 14, 2008 · Exported to Mexico N18VCCessna U206G · S/N U20605275Cancelled Feb 5, 2008 · Exported to Mexico · Contreras Vicente DBA N732RHCessna TU206G · S/N U20604711Cancelled Apr 27, 2007 · Exported to Mexico · Built 1978 · Contreras Vicente N5851FCessna 210G · S/N 21058851Cancelled Sep 15, 2006 · Exported to Mexico · Contreras Vicente DBA N525VCCessna T210N · S/N 21064136Cancelled Jul 24, 2006 · Exported to Mexico · Contreras Vicente N761HPCessna T210M · S/N 21062272Cancelled Jun 30, 2005 · Exported to Mexico · Contrerus Vicente N8301SCessna 182H · S/N 18256401Cancelled Jun 30, 2005 · Exported to Mexico · Contreras Vicente N3835GCessna TU206B · S/N U2060835Cancelled Jan 24, 2005 · Exported to Mexico · Contreras Vincente DBA N59238Cessna T210L · S/N 21060173Cancelled Mar 15, 2004 · Exported to Mexico · Built 1974 · Contreras Vicente N761VHCessna T210M · S/N 21062549Cancelled Nov 14, 2002 · Exported to Mexico · Built 1978 · Contreras Vicente N868CPartenavia P68 · S/N 214Cancelled Dec 23, 1993 · Exported to Mexico · San Diego Shipping & Research Co Inc N4117RPiper PA-32-300 · S/N 32-40436Cancelled Oct 19, 1973 · Exported to Mexico · Aviation E/C Inc N5204UCessna 206 · S/N 206-0204Cancelled Aug 13, 1973 · Exported to Mexico · Elias Alejandro N4024KRyan NAVION B · S/N 1024BCancelled Jun 25, 1973 · Wehber Selim N997PKPiper PA-32-300 · S/N 32-40416Cancelled Feb 13, 1973 · Exported to Mexico · Built 1967 · Baja Properties Leasing Inc N67666Piper J3C-65 · S/N 13970Cancelled Aug 31, 1970 · Built 1945 · Lower Robert F

Back to San Ysidro, CA