Skip to content

Cancelled registrations · 23

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

N826GPZapponi Frederick John OSPREY II · S/N A1Cancelled Feb 10, 2025 · Built 2011 · Zapponi Frederick J N9747HCessna 182R · S/N 18267992Cancelled Dec 8, 2023 · Exported to Mexico · Built 1981 · Mashiair LLC N4793DCessna 182A · S/N 34893Cancelled Oct 23, 2021 · Third renewal notice · Built 1958 · Extreme Source Inc N202FDDJI INSPIRE 1 · S/N W21ACJ23010292Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Mckenna Glenn R DBA N7139VMooney M20E · S/N 21-0048Cancelled Dec 3, 2018 · Exported to Paraguay · Built 1974 · Mountain West Equities Inc N5760Hacker HACKER 40 · S/N HAC001Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1973 · Murai Koh I N186PAvia Stroitel AC-5M · S/N 014Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 2001 · App Frank J N50MCCessna P210N · S/N P21000044Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1978 · Debt Free LLC N228KKPiper PA-28-236 · S/N 28-7911056Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Johnson Russell N840APiper PA-22 · S/N 22-140Cancelled May 11, 2015 · Registration expired, pending cancellation · Wandt Steven J N9108QHispano Aviacion HA-200 SAETA · S/N HA-20-89Cancelled Dec 5, 2014 · Registration expired, pending cancellation · Sierra Warbirds Corp N65806Schweizer SGS 2-33A · S/N 296Cancelled Nov 20, 2013 · Second renewal notice · Built 1973 · Soar Truckee Inc N3178NHispano Aviacion HA-200 SAETA · S/N 20/42Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Sierra Warbirds Corp N447ESummers Mark A Q-200 · S/N 2345Cancelled Sep 11, 2013 · First renewal notice · Built 2004 · Summers Mark A N20775Cessna 182P · S/N 18261193Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1972 · Ruttledge Gray M N3967VCessna 170 · S/N 18286Cancelled Aug 23, 2010 · Triennial form not returned · Built 1948 · Tahoe Wings LLC N49JAero Commander 200D · S/N 352Cancelled Mar 16, 2009 · Triennial form not returned · Built 1966 · Cherokee Springs Golf Resort LLC N59SEPdps Pzl-Bielsko SZD-59 · S/N B-2166Cancelled Dec 5, 2001 · Triennial form not returned · Built 1995 · June Eric J N914SFStuder Richard M LANCAIR IV · S/N 001Cancelled Dec 8, 1999 · Triennial form not returned · Studer Richard M N8981GCessna 182N · S/N 18260521Cancelled Apr 3, 1995 · Triennial form not returned · Sikes Robert A N8534ABaron Helmut AMATUER BUILT · S/N HB1Cancelled Aug 16, 1991 · Triennial form not returned · Hall Lawrence D N8231MCessna T210K · S/N 21059231Cancelled Jan 19, 1978 · Built 1969 · Little William S N5916BCessna 182A · S/N 33916Cancelled Jan 18, 1968 · Exported to Nicaragua · Spalding Ray

Back to Truckee, CA