Cancelled registrations · 41

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

N3877DCessna 182A · S/N 34577Cancelled Jan 24, 2020 · Revoked, canceled · Built 1957 · Johnson Adolph C N4082KNavion L-17A · S/N NAV-4-1082Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1947 · Keith Kevin N N48699Taylorcraft DC-65 · S/N L5837Cancelled Sep 20, 2019 · Revoked, canceled · Built 1944 · Vega Flying Club Inc N71568Reno Gordon E TIERRA II · S/N 253Cancelled May 31, 2018 · Sale reported, canceled N988RHBeech F35 · S/N D-4131Cancelled Apr 6, 2018 · Registration expired, pending cancellation · Built 1955 · Davis Keith C N94185Cessna 152 · S/N 15285615Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1982 N5462KCessna 172P · S/N 17274128Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Cable Marilyn R Co Trustee N9957CCallair A-5 · S/N 212Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1958 · Odell Dale L N6029CCallair A-5 · S/N 142-5ACancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1954 · Odell Dale L N3261QBell 47G · S/N 1062Cancelled Jan 30, 2013 · Sale reported, canceled N6149CCallair A-4 · S/N 162Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1956 · Odell Dale L N732TKCessna T210M · S/N 21061760Cancelled Jun 7, 2011 · Exported to Mexico · Built 1977 · Brage Donald L N9748BCessna 180A · S/N 50046Cancelled Jul 9, 2009 · Registration revoked · Built 1957 · Askelson Eldon N2006VCessna 140 · S/N 14217Cancelled Feb 9, 2009 · Triennial form not returned · Built 1947 · Holmes Stephen L N8622ZCessna TP206C · S/N P206-0422Cancelled May 25, 2006 · Exported to Mexico · Built 1967 · Riffenburgh Ralph S N737TTCessna 172N · S/N 17269669Cancelled Feb 23, 2006 · Exported to Canada · Built 1977 · Cable Marilyn R Trustee N69088Cessna 152 · S/N 15282479Cancelled Jan 13, 2006 · Exported to Peru · Built 1978 · Cable Marilyn R Co-Trustee N6449BCessna T210M · S/N 21062767Cancelled Jan 11, 2006 · Exported to Mexico · Built 1978 · Olivera Paul N2733YBeech 95 · S/N TD-72Cancelled Sep 8, 2004 · Triennial form not returned · Built 1958 · Cable Marilyn R Co Trustee N99142Ercoupe 415-C · S/N 1765Cancelled Aug 28, 2004 · Triennial form not returned · Built 1946 · Payne Charles N25440Cessna 152 · S/N 15280660Cancelled Oct 24, 2003 · Exported to Panama · Built 1977 · Cable Marilyn R Co-Trustee N817RHHarrison Robin T PITTS S1S · S/N 02RHCancelled Nov 3, 1995 · Triennial form not returned · Harrison Robin T N5258DCessna 172N · S/N 17272476Cancelled Apr 1, 1993 · Triennial form not returned · Cable Walter D Co Trustee N149KSSchooley Kenneth L AVID FLYER · S/N 149Cancelled Dec 6, 1990 · Exported to Italy · Ring Robert III N2QSmith Miniplane DSA-1 · S/N MH-101Cancelled Apr 29, 1988 · Second triennial mailing, no response · Built 1968 · Batterton George B N6339FCessna 172N · S/N 17273196Cancelled Jan 17, 1986 · Garlett Jerry W N1857QCessna 177RG · S/N 177RG0257Cancelled Mar 12, 1981 · Built 1972 · Labarbera Vincent J N51139Cessna 150 · S/N 15069789Cancelled Jul 7, 1977 · Shupe Donald N2208FCessna 310L · S/N 310L-0008Cancelled Feb 7, 1977 · Foster Paul Wesley N2210VCessna 206 · S/N 206-0107Cancelled May 26, 1976 · Built 1964 · Borland Robert C N2970YCessna 182E · S/N 18253970Cancelled May 18, 1976 · Binnall Duane R N9435Pazmany PL1 · S/N 358Cancelled Feb 7, 1975 · Built 1972 · Sinclair R S N3667AStolp STARDUSTER 2 · S/N 125Cancelled Jan 27, 1975 · Meyer Robert E N4736EAeronca 7EC · S/N 7EC-79Cancelled Jul 16, 1973 · Exported to Canada · Porter George Or Mable Porter N4756ZPiper PA-22-108 · S/N 228312Cancelled Jun 12, 1965 · Howard E D N77099Cessna 140 · S/N 11557Cancelled Jun 5, 1965 · Built 1946 · Pierson Lenn M N2865EAeronca 7AC · S/N 7AC-6448Cancelled May 25, 1965 · Lenn M Pierson N1498EAeronca 7AC · S/N 7AC-5061Cancelled May 22, 1965 · Lenn M Pierson N21721Bowlus BABY ALBATROSS · S/N 102Cancelled Nov 17, 1941 · Shatzel Albert V N212KGreat Lakes 2T-1A · S/N 38Cancelled Jan 10, 1939 · Long James N N914YWolfe Claude PRIMARY GLIDER · S/N 1Cancelled Jun 17, 1933 · Built 1930 · Wolfe Claude

Back to Claremont, CA