Skip to content

Cancelled registrations · 33

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 = 'TX' AND d.registrant_city = 'ALLEN' 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 = 'TX' AND d.registrant_city = 'ALLEN'
  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 = 'TX' AND d.registrant_city = 'ALLEN'
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.

N3027JPiper PA-32RT-300T · S/N 32R-7987075Cancelled Jun 3, 2023 · Built 1978 · Jackson R Allen N93824Cessna 210L · S/N 21060422Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1974 · Higher Ground Aviation LLC N7193BPiper PA-22-150 · S/N 22-4389Cancelled May 9, 2022 · Registration expired, pending cancellation · Built 1956 · Thompson Thorpe Dow N26EJOlsen Edward H HKS-4S-HL · S/N 081Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Olsen Edward N4658XCessna 150G · S/N 15064708Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1966 · Wingnut Enterprises LLC N3512NPiper J3C-65 · S/N 22742Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Fitzgerald Chrarles W N5515PPiper PA-24-250 · S/N 24-578Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1958 · Malcom Doris Carolyn N5547ABeech B35 · S/N D-2396Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Smith Edwin A N3732WRose Kenneth WEEDHOPPER · S/N 001133Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2009 · Rose Kenneth R N6859FPiper PA-28-151 · S/N 28-7715183Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Bromstead James N4003PCameron Balloons US N-77 · S/N 5666Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1991 · Shafer Brian A N5658PPiper PA-24 · S/N 24-729Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1959 · Calhoun Kendall N191TGCessna 172S · S/N 172S11097Cancelled Jul 28, 2017 · Second renewal notice · Built 2011 · Tango Golf Aerospace LLC N20724Aerovodochody L-29 DELFIN · S/N 394974Cancelled Sep 8, 2016 · Registration pending, canceled N4944TCessna TR182 · S/N R18201799Cancelled Apr 26, 2016 · Exported to Mexico · Zappolo Rick A N525CBBeech B36TC · S/N EA-302Cancelled Jan 16, 2015 · Exported to Chile · Built 1982 · Tufino Gonzalo F N4043WHead Balloons AX8-105 · S/N 202Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Rose Michael T N36610Balloon Works FIREFLY 7 · S/N F7-049Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Rose Michael T N234EXDougherty Omar G CHALLENGER II · S/N CH2-0903-2377Cancelled Apr 9, 2013 · Built 2003 · Blair Fred N276SVBellanca 17-30A · S/N 76-30844Cancelled Sep 19, 2012 · Second renewal notice · Built 1976 · Blanton James R N833JBBurchfield Jerold L RAND-ROBINSON KR2 · S/N 7870Cancelled Jul 24, 2012 · Built 2006 · Burchfield Jerold L N2101MCessna 172S · S/N 172S9598Cancelled May 18, 2011 · Exported to Brazil · Built 2004 · North Bay Aviation Inc N90227Diamond-Robert KR-2 · S/N SP1Cancelled Jul 15, 2005 · Second triennial mailing, no response · Built 1982 · Burchfield Jerold L N9006HPerkins Michael HAWK ARROW II · S/N 2388477Cancelled Oct 1, 2002 · Perkins Michael B N1986VCameron Balloons US V-77 · S/N 5241Cancelled Mar 18, 2002 · Triennial form not returned · Built 1986 · Goldsberry Obrien N24239Cessna 152 · S/N 15280169Cancelled Jul 27, 1999 · Triennial form not returned · Trey Aviation Inc N103GEComegys Cornelius George TIERRA II · S/N 832103Cancelled May 19, 1997 · Second triennial mailing, no response · Comegys Cornelius George N60762Cessna 150J · S/N 15070557Cancelled Oct 26, 1992 · Triennial form not returned · Turquette Jack L II N67533Cessna 152 · S/N 15281895Cancelled Aug 10, 1991 · Triennial form not returned · Turquette Jack L II N3812JCessna 150G · S/N 15065112Cancelled Sep 27, 1985 · Administratively canceled · Hutchison Johnny D N6659LLake LA-4 · S/N 422Cancelled May 26, 1972 · Exported to Canada · Karels Russ N5223LPiper PA-28-180 · S/N 28-4517Cancelled Oct 28, 1970 · Built 1967 · Upper Valley Aviation Inc N6415HPiper J3C-65 · S/N 19599Cancelled Mar 29, 1954 · Exported to Mexico · Mccreery Aviation Co

Back to Allen, TX