Albuquerque, NM

Cancelled registrations · 1,253

Query with SQL
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 = 'NM' AND d.registrant_city = 'ALBUQUERQUE'
  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.

N130PCBritten-Norman BN-2A-21 · S/N 417Cancelled Feb 9, 2024 · Exported to Anguilla · Built 1974 · Sky West Aviation Inc TrusteeN352HSGates Learjet 35A · S/N 596Cancelled Feb 7, 2024 · Exported to Mexico · Critical Air Response Enterprises LLCN666KGCirrus Design SR22 · S/N 2488Cancelled Jan 29, 2024 · Exported to Germany · Built 2007 · Sky West Aviation Inc TrusteeN402LSCessna 402C · S/N 402C0086Cancelled Jan 26, 2024 · Exported to Anguilla · Sky West Aviation Inc TrusteeN229BWEclipse Aerospace EA500 · S/N 550-0264Cancelled Jan 5, 2024 · Built 2013 · Spj Aircraft LLCN1035TAlmazon Edward F VANS R-V-4 · S/N 4412Cancelled Nov 21, 2023 · Exported to Lithuania · Built 2005 · Sky West Aviation Inc TrusteeN780DLEurocopter Deutschland MBB-BK 117-B2 · S/N 7241Cancelled Nov 6, 2023 · Exported to South Africa · Built 1991 · Sky West Aviation Inc TrusteeN9066AAdams Balloons A55S · S/N 299Cancelled Oct 26, 2023 · Adams Balloons LLCN9069AAdams Balloons A55S · S/N 297Cancelled Oct 26, 2023 · Adams Balloons LLCN907QAAdams Balloons A-B · S/N 316Cancelled Oct 26, 2023 · Adams Balloons LLCN910GZAdams Balloons A55 · S/N 324Cancelled Oct 26, 2023 · Adams Balloons LLCN910KQAdams Balloons A55 · S/N 323Cancelled Oct 26, 2023 · Adams Balloons LLCN137ABAdams Balloons A-B · S/N 317Cancelled Oct 25, 2023 · Adams Balloons LLCN9063AAdams Balloons A55S · S/N 294Cancelled Oct 25, 2023 · Adams Balloons LLCN9065AAdams Balloons A55S · S/N 293Cancelled Oct 25, 2023 · Adams Balloons LLCN9067AAdams Balloons A55S · S/N 298Cancelled Oct 25, 2023 · Adams Balloons LLCN906VAAdams Balloons A55S · S/N 292Cancelled Oct 25, 2023 · Adams Balloons LLCN906ZDAdams Balloons A55S · S/N 296Cancelled Oct 25, 2023 · Adams Balloons LLCN9074EAdams Balloons A60-S · S/N 305Cancelled Oct 25, 2023 · Adams Balloons LLCN907BAAdams Balloons A55S · S/N 295Cancelled Oct 25, 2023 · Adams Balloons LLCN907EAAdams Balloons A60-S · S/N 302Cancelled Oct 25, 2023 · Adams Balloons LLCN907KBAdams Balloons A60-S · S/N 301Cancelled Oct 25, 2023 · Adams Balloons LLCN907MAAdams Balloons A-B · S/N 315Cancelled Oct 25, 2023 · Adams Balloons LLCN907VBAdams Balloons A-B · S/N 318Cancelled Oct 25, 2023 · Adams Balloons LLCN907XAAdams Balloons A-B · S/N 319Cancelled Oct 25, 2023 · Adams Balloons LLCN907ZBAdams Balloons A60-S · S/N 307Cancelled Oct 25, 2023 · Adams Balloons LLCN908BAAdams Balloons A60-S · S/N 304Cancelled Oct 25, 2023 · Adams Balloons LLCN908FAAdams Balloons A60-S · S/N 309Cancelled Oct 25, 2023 · Adams Balloons LLCN908GJAdams Balloons A-B · S/N 310Cancelled Oct 25, 2023 · Adams Balloons LLCN908JAAdams Balloons A60-S · S/N 308Cancelled Oct 25, 2023 · Adams Balloons LLCN908XAAdams Balloons A60-S · S/N 306Cancelled Oct 25, 2023 · Adams Balloons LLCN910FQAdams Balloons A55 · S/N 321Cancelled Oct 25, 2023 · Adams Balloons LLCN910JAAdams Balloons A55 · S/N 322Cancelled Oct 25, 2023 · Adams Balloons LLCN532VGSabre WILDCAT · S/N 2358Cancelled Oct 12, 2023 · Exported to Mexico · Kilgore Mark AN903BBB W Stone VOLKSPLANE VP-1 · S/N S-01Cancelled Oct 7, 2023 · Sale reported, canceled · Built 2012N369FBeech 300 · S/N FA-185Cancelled Oct 2, 2023 · Exported to Canada · Built 1989 · Sky West Aviation Inc TrusteeN140PBCameron Balloons O-140 · S/N 6756Cancelled Sep 28, 2023 · Built 2015 · Hot Air Balloonatics LLCN243KFPiper PA 46-350P · S/N 4636154Cancelled Sep 18, 2023 · Exported to Germany · Built 1998 · Sky West Aviation Inc TrusteeN839ARPiper PA-28R-200 · S/N 28R-7635372Cancelled Sep 8, 2023 · Exported to United Kingdom · Built 1976 · Sky West Aviation Inc TrusteeN9153RRubic Baloes RUBIC III · S/N 084/10Cancelled Aug 9, 2023 · Gabaldon Henry DN266HRPiper PA-46-600TP · S/N 4698258Cancelled Aug 8, 2023 · Exported to Germany · Sky West Aviation Inc TrusteeN53CLSikorsky S-76C · S/N 760660Cancelled Jul 27, 2023 · Exported to India · Built 2007 · Copter Lease LLC TrusteeN358EHBell 212 · S/N 31211Cancelled Jul 11, 2023 · Exported to South Africa · Built 1982 · Copter Lease LLC TrusteeN6502KAerostar International RX-7 · S/N RX7-3123Cancelled Jun 15, 2023 · Built 1987 · Gonzales-Saiz Aline YN2839MPiper PA-12 · S/N 12-1275Cancelled Jun 10, 2023 · Revoked, canceled · Built 1946 · Colglazier Roger DN4015LLindstrand Balloons 105A · S/N 5043Cancelled Jun 1, 2023 · Built 1997 · Hutchinson Terry ScottN5464SCessna P210N · S/N P21000043Cancelled May 25, 2023 · Exported to Germany · Built 1978 · Sky West Aviation Inc TrusteeN785HTWalkera SCOUT X4 · S/N BT2401NA-709Cancelled Apr 12, 2023 · Registration expired, pending cancellation · Integrated Design & ArchitectureN6477VCessna 172RG · S/N 172RG0722Cancelled Apr 4, 2023 · Exported to Hungary · Sky West Aviation Inc TrusteeN6158XCameron Balloons V-77 · S/N 6018Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1995 · Lawler Thomas W Jr
Back to Albuquerque, NM