Skip to content

Cancelled registrations · 38

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

N7373FTexas Aircraft Mfg COLT 100 · S/N TXA014Cancelled Oct 22, 2026 · Exported to Argentina · Built 2025 · Texas Aircraft Manufacturing Inc N22HJJakel Helmut L SONEX · S/N 0083Cancelled Aug 25, 2025 · Registration pending, canceled · Built 2000 N105TXTa Brasil Con EMP Ltda TA01 · S/N TXA002Cancelled Nov 27, 2024 · Exported to Brazil · Built 2018 · Texas Aircraft Group Inc N6221RRemenicky Albert KR-2 · S/N 1427Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1994 · Truitt Frank P N301CGBeech 300 · S/N FA-87Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1985 · Lister John N5365KCessna 172P · S/N 17274083Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1981 · Castroville Airport Inc N714NSCessna 150M · S/N 15079309Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1977 · Castroville Airport Inc N5651GCessna A188B · S/N 18801132Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1973 · Torkelson Charles A N1314EAeronca 7AC · S/N 7AC-4875Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1946 · Lindeman Rusty L N1703SSnow 600-S2C · S/N 600-1281CCancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1965 · Lindeman Russell L DBA N18671Cessna 150L · S/N 15074031Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1972 · Castroville Airport Inc N10652Cessna 150L · S/N 15074949Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1973 · Castroville Airport Inc N11515Cessna 150L · S/N 15075477Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1973 · Castroville Airport Inc N35771Piper J5A · S/N 5-755Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1941 · Castroville Airport Inc N260TPiper PA-18-105 SPECIAL · S/N 18-2374Cancelled Nov 22, 2017 · Revoked, canceled · Built 1953 · Texas Aviation Ind N7023JElisport Helicopters CH-7 · S/N 0005Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1998 · Callaway Kevin V N731STCessna A188B · S/N 18803125TCancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1978 · Torkelson Charles A N4988XRockwell International S-2R · S/N 5033RCancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1975 · Rustys Flying Service N1257WWeatherly 201B · S/N 611Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1973 N7020TCessna 172 · S/N 46620Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1959 · Torkelson Charles A N1894PPiper PA-22-150 · S/N 22-2637Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1955 · Decker Kirk K N5288LPiper PA-28-180 · S/N 28-4589Cancelled Jan 31, 2013 · Registration pending, canceled · Built 1968 N1765SAero Commander S2R · S/N 1417RCancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1968 · Rustys Flying Service N6215PPiper PA-24-250 · S/N 24-1317Cancelled Jan 23, 2007 · Triennial form not returned · Built 1959 · Lindeman Rusty N1730SAero Commander 600 S-2D · S/N 600-1330DCancelled Nov 23, 2004 · Triennial form not returned · Built 1966 · Lindeman Rusty N4888XRockwell International S-2R · S/N 2072RCancelled Nov 5, 2004 · Triennial form not returned · Built 1974 · Lindeman Rusty L N210SSCessna 210L · S/N 21059912Cancelled Oct 21, 2004 · Triennial form not returned · Built 1973 · Miller Mike W N3919JCessna A188B · S/N 18803687TCancelled Sep 21, 2004 · Triennial form not returned · Built 1980 · Rustys Flying Service N8985QAero Commander S2R · S/N 1655RCancelled Sep 20, 2004 · Triennial form not returned · Built 1972 · Lindeman Inc DBA N4917XRockwell International S-2R · S/N 2110RCancelled Aug 9, 2004 · Triennial form not returned · Built 1974 · Rustys Flying Service N1657SSnow 600-S2C · S/N 6001216CCancelled Jun 17, 1998 · Second triennial mailing, no response · Torkelson Charles N8848SAir Tractor AT-301 · S/N 3010215Cancelled Sep 23, 1996 · Exported to Mexico · Lindeman Rusty N6750ZPiper PA-25-235 · S/N 25-2369Cancelled Mar 24, 1986 · Exported to Yugoslavia · Torkelson Charles N12241Convair AT-29C · S/N 381Cancelled Jan 8, 1985 · Administratively canceled · Gary Aircraft Corporation N2143DPiper PA-28-181 · S/N 28-7990160Cancelled Oct 2, 1981 · Built 1978 · Gross L E N5654JCessna A188A · S/N 18800604Cancelled Apr 25, 1978 · Alaniz A L N336TPiper PA-18-105 SPECIAL · S/N 18-2450Cancelled Nov 23, 1970 · Texas Aviation Industries N5608Pheasant H-10 · S/N 125Cancelled Jul 7, 1937 · Turner Milton & Koch Stanley

Back to Hondo, TX