Cancelled registrations · 17

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 = 'CITRUS HEIGHTS' 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 = 'CITRUS HEIGHTS'
  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 = 'CITRUS HEIGHTS'
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.

N2UCTL Ultralight Sro STINGSPORT · S/N TLUSA126Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 2005 · Wade Dennis E N5301ACameron Balloons US N-90 · S/N 6140Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1999 · Austin Daniel N5090HBardin William CHALLENGER II CWS · S/N CH2-1100-CW-2030Cancelled May 11, 2015 · Sale reported, canceled · Built 2007 N101PWWhite Peregrine P JN-1 · S/N 01Cancelled May 4, 2015 · Registration expired, pending cancellation · White Peregrine P N4557PCameron Balloons US 0-105 · S/N 5875Cancelled Jan 28, 2015 · Third renewal notice · Built 1993 · Austin Daniel J N96048Taylorcraft BC12-D · S/N 8348Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Carter William A N8756JThunder Balloons AX7-77 · S/N 1012Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1987 · Taggart Gregory M N2542HErcoupe 415-C · S/N 3167Cancelled Aug 22, 2013 · Sale reported, canceled N28380Walter SCORPION TOO · S/N 9841Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1976 · Walter Leonard F N72JNNunes Jesse J KR-II · S/N 4672Cancelled Jul 10, 2013 · Registration expired, pending cancellation · Bridges Rayford J N56497Piper PA-28-140 · S/N 28-7325642Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1973 N3442Garner JEANNIES TEENIE A · S/N GAR-5993Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1969 N551LLundgren Carl A 5151-RG · S/N 007Cancelled Feb 12, 2002 · Triennial form not returned · Built 1992 · Lundgren Carl A N8057TTaylor Troy SUPER BANDIT · S/N 108Cancelled Feb 5, 2002 · Triennial form not returned · Built 1998 · Taylor Troy P N512JBParisek John G LONG-EZ · S/N 719Cancelled Jan 28, 2002 · Triennial form not returned · Built 1985 · Parisek John G N999EBWilson Earl & Barbara VARI-EZE · S/N 1162Cancelled Dec 28, 1993 · Triennial form not returned · Wilson Earl K N213GGibson BEDE 4 · S/N 213Cancelled Aug 7, 1991 · Triennial form not returned · Pischke Harold A

Back to Citrus Heights, CA