Skip to content

Cancelled registrations · 217

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 = 'SAN ANGELO' 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 = 'SAN ANGELO'
  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 = 'SAN ANGELO'
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.

N827JDAirbus Helicopters AS350B2 · S/N AS2860Cancelled Oct 15, 2026 · Exported to Colombia · Built 1996 · Command Decisions Inc N70337Matesi Eugene E LANCAIR 320 · S/N 637Cancelled Jul 11, 2026 · Sale reported, canceled N6451FCessna 150F · S/N 15063051Cancelled Apr 4, 2026 · Sale reported, canceled · Built 1966 N85586Aeronca 7AC · S/N 7AC-4329Cancelled Feb 6, 2026 · Revoked, canceled · Built 1946 · West Robert M Jr N9729EAeronca 11BC · S/N 11AC-1374Cancelled Jun 21, 2023 · Sale reported, canceled · Built 1946 N225TGMaxsur SEEKER-SAR-640 · S/N 14558Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Tom Green County Sheriffs Office N622LRDJI INSPIRE 1 · S/N W13DCB12020540Cancelled Jan 12, 2023 · Sale reported, canceled N44636Piper PA-28-151 · S/N 28-7415691Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Salazar Arturo III N921LTCGS Hawk ARROW II · S/N HAII-317-3203-TRICancelled Jul 2, 2022 · Registration expired, pending cancellation · Taylor Larry L N62492Piper PA-18-150 · S/N 18-7709038Cancelled Jun 2, 2022 · Registration expired, pending cancellation · Built 1976 · Upton W H N20434Taylorcraft BC-65 · S/N 1123Cancelled Mar 15, 2022 · Registration expired, pending cancellation · Built 1963 · Reece Robert R N4DQCryer Don Q CHALLENGER II · S/N CH2-0994-1207Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1995 · Bryant Thomas A N9841DPiper PA-22-150 · S/N 22-6732Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1959 · Reece Robert R N68466Stinson L-5 · S/N 4474Cancelled Sep 4, 2020 · Revoked, canceled · Southwest Trading Co N39PKRockwell International 114A · S/N 14507Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1979 · Huffman Tommy N2742ACessna 414A · S/N 414A0620Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1980 · N2742a LLC N7923G3D Robotics SOLO · S/N S111A5800250Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Goodyear Tire & Rubber Co N850NKSocata TBM 700 · S/N 432Cancelled Jan 14, 2020 · Built 2007 · Mt Margaret LLC N961ARWalden Robert L LIBERTY X-2 · S/N 003Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 2003 · Deering Casey T N41916Piper PA-28-140 · S/N 28-7425296Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1974 · N223bt LLC N759WGolden Circle Air T-BIRD I · S/N 1953Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1995 N1709PPiper PA-22-150 · S/N 22-2496Cancelled May 11, 2018 · Revoked, pending cancellation · Built 1954 · Jacobs Jerrel Duane N7364BBeech E35 · S/N D-3827Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1954 · Jones Bobby J N89WLKeating Joseph M Q-200 · S/N 2820Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1985 · Lee Troy D N5768WPiper PA-28-160 · S/N 28-1554Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1964 · N223bt LLC N5439PPiper PA-24-180 · S/N 24-493Cancelled Nov 20, 2017 · Revoked, canceled · Built 1958 · Ranchaero Inc N55775Stinson VULTEE V-77 · S/N 77-366Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1944 · Shacklette Paul H N312DRBranum Marx H RANS S-12XL · S/N 05990880Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2000 · Baker Richard S N4450XCrellin Leland R CHALLENGER CLP WG SP · S/N 0597-CW-0646Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Crellin Leland R N4340TBlair Todd RAF 2000 · S/N H2-91-2-44Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1992 · Blair Dervin Todd N799WBeech F35 · S/N D-4388Cancelled Feb 4, 2017 · Revoked, canceled · Built 1955 · Barbutti Ronald V N81620Aeronca 7AC · S/N 7AC235Cancelled Feb 4, 2017 · Revoked, canceled · Built 1945 · Tatum Adolphus G N711NMPiper PA32-301FT · S/N 3232050Cancelled Dec 5, 2016 · Exported to Australia · Built 2005 · Adc Inc N1216XMooney M20C · S/N 2619Cancelled Aug 3, 2016 · Third renewal notice · Built 1963 · Shelby Aviation LLC N913RSAmerican AA-5 · S/N AA5-0211Cancelled May 10, 2016 · Exported to Dominican Republic · Built 1972 · Mccutchen Insurance Agency Inc N804DDCessna 310I · S/N 310I0041Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1964 · Airborne Emergency Physicians Inc N1694Sebring British WW1 Replica 4/5 SCALE SE5A · S/N 001Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1970 · Flaharity Tex Curtis N4117UCessna 150D · S/N 15060117Cancelled Apr 2, 2015 · Registration expired, pending cancellation · Built 1963 · Angelo Aero Club Inc N9183HCessna 172M · S/N 17265998Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1975 · Kelley Robert V N6662YBeech A36 · S/N E-1573Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1979 · Hartmann Warren J N3162VBeech 35 · S/N D-593Cancelled May 13, 2014 · Built 1947 · Dufresne Thomas J N5921UPiper PA-28-140 · S/N 28-26900Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1970 · Williams John B DBA Williams Acft Co N912RVHeiser Robert C JR PULSAR XP · S/N 394Cancelled Sep 18, 2013 · Second renewal notice · Built 2001 · Heiser Robert C Jr N95411Cessna 152 · S/N 15285889Cancelled Aug 15, 2013 · Sale reported, canceled · Built 1984 N34581Cessna 177B · S/N 17701886Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1973 · Murray Bill N1533YBeech F33A · S/N CE-1249Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1988 · 33 Yankee Inc N85WJJones W E QUICKIE 2 · S/N 2667Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Travland Christopher L N28198Cunningham Alan MITCHELL B-10 · S/N B-1287Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Cunningham Alan N4073YRaven S55A · S/N S55A-990Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Coats Nan N8715GCessna 150F · S/N 15062815Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1966 · Reece Robert R

Back to San Angelo, TX