Skip to content

Cancelled registrations · 279

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

N8213ACessna 170B · S/N 25065Cancelled Aug 26, 2026 · Registration pending, canceled · Built 1952 N8222GPiper PA-32R-301T · S/N 32R-8129004Cancelled May 29, 2026 · Exported to Mexico · Fir Aircraft Trustee LLC Trustee N389KAGates Learjet 35A · S/N 389Cancelled Jun 26, 2025 · Exported to Mexico · Built 1981 · Indigo Aviation LLC N501MRCessna 501 · S/N 501-0062Cancelled Apr 1, 2024 · Exported to Mexico · Bowcat Aviation Trustee N1699UCessna 207 · S/N 20700299Cancelled Oct 21, 2023 · Revoked, canceled · Built 1975 · Davila Julio N519AJBeech C90 · S/N LJ-928Cancelled Oct 7, 2022 · Sale reported, canceled · Built 1980 N8622GCessna 182K · S/N 18258102Cancelled May 13, 2022 · Registration pending, canceled N3640BBeech C-50 · S/N CH-124Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1954 · Villaurrutia Carlos N599RJCessna 421C · S/N 421C1026Cancelled May 29, 2020 · Registration expired, pending cancellation · Jeffries Norman Henry N54024Boeing A75N1(PT17) · S/N 753777Cancelled Jan 31, 2020 · Revoked, canceled · Built 1942 · Dorsam V E N149EStinson SR-10C · S/N 35901Cancelled Aug 5, 2019 · Revoked, pending cancellation · Built 1939 · Tex Mex Avn N62114Boeing E75 · S/N 751731Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1941 · Dorsam V E N9343JPiper PA-28-180 · S/N 28-3441Cancelled Apr 30, 2019 · Exported to Mexico · Built 1966 · Lara-Meza Sergio Giovanni N4333SAir Tractor AT-301 · S/N 301-0012Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Built 1975 · Lopez Hugo E N31613Air Tractor AT-301 · S/N 301-0495Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Built 1983 · Lopez Hugo E N9194FPiper PA 46-350P · S/N 4622083Cancelled Feb 11, 2019 · Exported to Mexico · Built 1989 · Andonie Lourdes Carolina N213BAGulfstream American G-1159A · S/N 453Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1982 · Villaurrutia Carlos N39LFGulfstream American G-1159A · S/N 347Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1984 · Villaurrutia Carlos N2431JCessna 150G · S/N 15065531Cancelled Jul 24, 2018 · Built 1966 · Air Safety Aviation Institute And Services Inc N10FXCessna 414 · S/N 414-0082Cancelled May 30, 2018 · Sale reported, canceled · Built 1970 N15ERGates Learjet 25D · S/N 267Cancelled Apr 12, 2018 · Exported to Mexico · Built 1979 · Villaurrutia Carlos N3168AAir Tractor AT-301 · S/N 301-0571Cancelled Mar 27, 2018 · Exported to Mexico · Martinez Fernando Galvan N878SWGary N Wise RV-8A · S/N 82355Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 2016 · Wise Gary N N428BWValley Commercial WHEELER EXPRESS S 90 · S/N 1994-0807EDICancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2002 · Valley Commercial Inc N227MMHawker Siddeley HS.125 SERIES 700A · S/N NA 0258Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 1979 · Hd Equipment Inc N20SKCessna 421C · S/N 421C1096Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Saiba LLC N11887North American NA-265-80 · S/N 380-4Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1974 · Figueroa Jose Manuel N4656XCessna 150G · S/N 15064706Cancelled Jan 31, 2018 · Exported to Mexico · Built 1966 · Galvan Fernando J N992ASCessna 550 · S/N 550-0338Cancelled Jan 30, 2018 · Sale reported, pending cancellation · Built 1979 N3858YCessna 210D · S/N 21058358Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1964 · Salomon Pedro Uriel N5260BCessna 152 · S/N 15283820Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1979 · Areeckal Rejee P N22LACessna 310B · S/N 35576Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1957 · Cook Tico J N74KWDouglas DC3A · S/N 7317Cancelled Jul 13, 2017 · Registration expired, pending cancellation · Built 1942 · Chatlani Jhoti P N37529Douglas DC3 · S/N 42-108953Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Rodio Sam N75892Piper PA-18A · S/N 18-2176Cancelled Feb 4, 2017 · Revoked, canceled · Built 1950 · Upper Valley Aviation Inc N7998Grumman Acft ENG Cor-Schweizer G-164A · S/N 859Cancelled Feb 4, 2017 · Revoked, canceled · Built 1971 · Oliver Edward DBA N919BCCessna T182T · S/N T18208323Cancelled Mar 24, 2016 · Exported to Mexico · Built 2004 · Vica Aviation Inc N1349UCessna T210L · S/N 21060574Cancelled Mar 4, 2016 · Exported to Mexico · Built 1975 · Brotherton Erik N5292VCessna T210L · S/N 21060897Cancelled Feb 29, 2016 · Built 1975 · Barajas Abraham N50GKGlobal T & E LANCAIR IV-P · S/N LIV-342Cancelled Jan 21, 2016 · Built 2002 · Global T & E Inc N761FTCessna T210M · S/N 21062228Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1977 · Frazer Stephen N515BPCanadair CL-600 CHALLENGER · S/N 1006Cancelled Feb 26, 2015 · Exported to Mexico · Built 1980 N69SNLockheed 18-56 · S/N 2428Cancelled Dec 22, 2014 · Revoked, canceled · Built 1943 · Miller Aviation Inc N4987KBeech D18S · S/N A-817Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1952 · Shalkow Inc DBA N2288VBeech B-60 · S/N P-256Cancelled Dec 9, 2014 · Registration expired, pending cancellation · Built 1973 · Quantum Air Inc N3080Lockheed 1329 · S/N 5094Cancelled Dec 9, 2014 · Registration expired, pending cancellation · Built 1966 · Esquire Aviation Corp N645CCNorth American NA-265-60 · S/N 306-49Cancelled Dec 9, 2014 · Third renewal notice · Built 1969 · Air Siesta Inc N3737BBeech 77 · S/N WA-172Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1980 · Volare Aviation Inc N3851NBeech 35 · S/N D-1089Cancelled Nov 19, 2014 · Third renewal notice · Built 1947 · Gar-Sal Carriers LLC N77BDouglas DC3 · S/N 20433Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1944 · Tepito Inc

Back to Mcallen, TX