Skip to content

Brownsville, TX

Cancelled registrations · 425

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

N6074APiper PA 46-350P · S/N 4636451Cancelled Jun 13, 2025 · Built 2008 · Alsa Aviation Inc N93438Cessna 152 · S/N 15285488Cancelled Mar 8, 2025 · Sale reported, canceled · Built 1982 N1548LAir Tractor AT-401 · S/N 401-0880Cancelled Feb 24, 2024 · Sale reported, canceled · Built 1992 N92838Cessna 182N · S/N 18260384Cancelled Jul 29, 2023 · Revoked, canceled · Built 1970 · Laake Lowell N756PLCessna R182 · S/N R18201124Cancelled May 25, 2023 · Sale reported, canceled · Built 1979 N315CCCessna 421B · S/N 421B0810Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Sandpiper Aviation LLC N1000KCessna 320D · S/N 320D0080Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Flores Martin N80SEKensrue M/Hillberg D/Wheeler G KITFOX II · S/N SW320Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Thiessen David N899HBJedinak Ron W HANNY B-1 · S/N 001Cancelled Aug 14, 2020 · Registration pending, canceled · Built 2012 N35455Piper J3F-65 · S/N 6359Cancelled Jul 6, 2020 · Revoked, canceled · Built 1941 · Arispe Edmundo N50559Interstate L-6 · S/N 5Cancelled Jan 10, 2020 · Revoked, canceled · Built 1945 · Trevino Tony N88679Piper J3C-65 · S/N 16307Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Parkhurst H N6202ZPiper PA-25 · S/N 25240Cancelled Jul 3, 2019 · Revoked, canceled · Built 1960 · Calderon Alfred O N67935Curtiss Wright C-46F · S/N 22383Cancelled Jul 19, 2018 · Revoked, canceled · Built 1944 · S E K Inc N46192Fairchild M-62A · S/N T437316Cancelled Apr 5, 2018 · Revoked, canceled · Built 1943 · Myrick B V N92267Cessna 182N · S/N 18260121Cancelled Nov 21, 2017 · Revoked, canceled · Built 1969 · Laake Lowell S N704TWCessna 150M · S/N 15078870Cancelled Nov 7, 2017 · Exported to Mexico · Built 1976 · Sampayo Ramon N3687KPiper PA-28-140 · S/N 28-23687Cancelled Oct 2, 2017 · Exported to Mexico · Built 1967 · Harris David W N377HQCessna 414A · S/N 414A0833Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Trans National Aviation LLC N2043DBeech C35 · S/N D-3396Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1952 · Copeland Ralph R N1493QCessna 150L · S/N 15072793Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1971 · Grace Flight Training N91876Cessna 182M · S/N 18259941Cancelled Feb 13, 2017 · Revoked, canceled · Built 1969 · Laake Lowell S N7390UCessna 207A · S/N 20700433Cancelled Feb 4, 2017 · Revoked, canceled · Built 1978 · Torres Mario N8850LPiper PA-25-235 · S/N 25-5361Cancelled Feb 4, 2017 · Revoked, canceled · Built 1971 · Hunt Pan Am Distributors Inc N25WJGates Lear Jet 25B · S/N 105Cancelled Nov 16, 2016 · Third renewal notice · Dominguez Luis N50EFMitsubishi MU-300 · S/N A081 S.A.Cancelled Aug 6, 2015 · Exported to Mexico · Built 1984 · Jaguar Aviation LLC N45547Cessna 150M · S/N 15076968Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1975 · Northwest Consolidated Inc N5823PPiper PA-24-250 · S/N 24-904Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1959 · Saykna Michael N41161Piper J3C-65 · S/N 7782Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1941 · Morgan August E N916DAAleson Darrel J Q-2 · S/N 2045Cancelled Dec 5, 2014 · Registration expired, pending cancellation · Built 1982 · Arroyo Richard C N17638Eichman Ellis V AEROBAT III · S/N 1003Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1985 · Eichman Ellis V N84442Aeronca 7AC · S/N 7AC3136Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Gonzalez Jorge N7718SSchweizer SGS 1-26D · S/N 418Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1968 · Whittemore Jamie D N7342UCessna 207A · S/N 20700408Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1977 · De Leon Javier T N50038Cessna 177RG · S/N 177RG1131Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1977 · Stevenson John DBA N25ACPiper PA-23-250 · S/N 27-3199Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1966 · Armendaris Hugo N216ZSBeech E18S · S/N BA-323Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1957 · Aircraft Leasng & Pilot Svcs Inc N1615CCessna 180 · S/N 30315Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1953 · Belmar Robert J N4366ECessna T207 · S/N 20700166Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1970 · Deleon Javier T N6912YPiper PA-23-250 · S/N 27-4267Cancelled Sep 3, 2014 · Revoked, canceled · Built 1969 · Rego Rafael A N4595LCessna 421 · S/N 421-0195Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1968 · Camel Leasing Co N6431KCessna 150M · S/N 15077701Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1975 · Gulf Coast Aviation Inc N18060Beech TC-45J · S/N 67108Cancelled Nov 1, 2013 · Registration expired, pending cancellation · Built 1944 · Singer John J N6250HCessna 207A · S/N 20700451Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1978 · Guerrero Cecilia S N228SMBeech 65 · S/N LC-115Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1961 · Soyka Michael N317SBeech D18S · S/N A-970Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1953 · Najar Albert S N1568UCessna 207 · S/N 20700168Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1970 · Zayas Miguel N425DAPiper PA-23-250 · S/N 27-7405338Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1974 · Sanchez Ruben N5689YPiper PA-23-250 · S/N 27-2807Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1965 · Cortes Eduardo N77FST Clair TEENIE TWO · S/N 51129Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1972 · St Clair John H

Back to Brownsville, TX