Skip to content

Cancelled registrations · 29

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 = 'OR' AND d.registrant_city = 'BANDON' 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 = 'OR' AND d.registrant_city = 'BANDON'
  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 = 'OR' AND d.registrant_city = 'BANDON'
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.

N148PCessna 305A · S/N 22554Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1952 · F 1 Systems Inc N7728XCessna 172B · S/N 17248228Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1960 · Adams Robert L N22632Cessna 150H · S/N 15068415Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1968 · Crook Brady G N210AMAero Commander 680 · S/N 680-517-187Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1957 · Wisby Merlin E N9732Beech UC-45J · S/N 12366Cancelled Jan 10, 2018 · Registration expired, pending cancellation · F 1 Systems Inc N5725ECessna 150 · S/N 17225Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1959 · Lively Walter A N201GHefner Stits SA6B · S/N P2101Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Reichlein John T N604WPPilatus PC-12/45 · S/N 604Cancelled Sep 6, 2016 · Third renewal notice · Built 2004 · Rooney Consulting & Aviation LLC N130RBMooney M20R · S/N 29-0114Cancelled May 8, 2015 · Registration expired, pending cancellation · Built 1997 · Reiner Bey N31706Beech F33A · S/N CE-1284Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1988 · Humphrey Bradley A N5996UPiper PA-28-140 · S/N 28-26821Cancelled Feb 14, 2014 · Exported to Mexico · Built 1970 · Excavators Leasing Corporation N3226PPiper PA-23 · S/N 23-1170Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1957 · Wisby Eugene R N3820NBeech 35 · S/N D-1050Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1947 · Myers Don A N4212ZChandler Charles QUICKIE · S/N CVC-1001Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1979 · Augsburger Will A N123AHPiper PA-34-200T · S/N 34-8070149Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Excavators Leasing Corp N440KWIssaquah Ultralite Center KASPERWING · S/N 4401Cancelled Dec 7, 2012 · Sale reported, pending cancellation N45797Luscombe 8A · S/N 2324Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1946 · Hardin Larry C N5705BCessna 182 · S/N 33705Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1956 N2086ZCessna 150C · S/N 15059886Cancelled Jun 14, 2012 · Registration pending, pending cancellation · Built 1963 N4965KCessna P210N · S/N P21000385Cancelled Dec 2, 2011 · Exported to Canada · Built 1979 · Gernandt Frederic G N5618UPiper PA-28-140 · S/N 28-26413Cancelled Dec 14, 2007 · Triennial form not returned · Built 1969 · Menje Alan E N6057BCessna 206 · S/N 206-0135Cancelled Mar 10, 2000 · Exported to Belize · Excavators Leasing Corporation N324PRaytheon 58 · S/N TH-1811Cancelled Dec 2, 1999 · Exported to Brazil · F I Systems Inc N4753APiper PA-22-150 · S/N 22-3900Cancelled Oct 1, 1999 · Kramer Justin F N3743NBeech 35 · S/N D-961Cancelled Feb 17, 1999 · Triennial form not returned · Wisby Martin O N2813UCessna 172D · S/N 17250413Cancelled Dec 15, 1995 · Triennial form not returned · Daoust Kenneth W N4135VCessna 170 · S/N 18467Cancelled May 24, 1993 · Sale reported N681QBeech G50 · S/N GH119Cancelled Aug 29, 1991 · Triennial form not returned · Crook Franklin T DBA N12730Truman John R TRUMAN 33 · S/N 1Cancelled Mar 15, 1936 · Built 1932 · Truman John R

Back to Bandon, OR