OpenAirDocs.org
Carlsbad, NM

Cancelled registrations · 65

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

N9938Hylio AG-272 · S/N 17906070268Cancelled Dec 27, 2025 · Sale reported, canceledN1339KLuscombe 8A · S/N 4066Cancelled Feb 1, 2025 · Sale reported, canceledN7091WPiper PA-28-180 · S/N 28-878Cancelled Jun 4, 2022 · Registration expired, pending cancellation · West Billy GN7157MCessna 175 · S/N 55457Cancelled May 6, 2019 · Revoked, canceled · Built 1958 · Beam C DN2674BCessna 340A · S/N 340A0758Cancelled Apr 19, 2018 · Registration expired, pending cancellation · J S P Resources LLCN8216FCessna 150F · S/N 15064316Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Paslay John AN9HHCessna 340 · S/N 3400237Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1973 · Paslay John AN1054Moore Paul J ZENITH 601 XL · S/N 6-5597Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Moore Paul JN70922Cessna 182M · S/N 18259421Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1968 · Parker Thomas DN84CJHeine Jerry L / Heine Randy L LONG-EZ · S/N 1037Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1996 · Heine Jerry LN48RVViolet Bob W DRAGONFLY · S/N 161Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1982 · Snow Mark DN4218ZCanion James L BENSEN B8M · S/N C7700Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Canion James LN5905XBrantly B-2 · S/N 41Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Canion James LN306LSPiper PA-31-310 · S/N 31-7300962Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1973 · Williams A WN9071PGreene Bill MINI-MAX · S/N MK-146Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Greene BillN713DGalle Jere R KR2 · S/N KR213GCancelled Apr 28, 2004 · Triennial form not returned · Galle Jere RN9037VBalloon Works FIREFLY 7 · S/N F7-607Cancelled May 16, 2002 · Triennial form not returned · Walker Robert JN7860XBeech B-60 · S/N P-446Cancelled May 25, 1999 · Exported to Germany · Courson CorporationN7256PPiper PA-24-180 · S/N 242432Cancelled Feb 7, 1997 · Triennial form not returned · Sigma Three Consulting IncN11HMBenham Howard C F8L FALCO · S/N 1057Cancelled Jan 4, 1996 · Benham Howard CN44680Culver V · S/N V-71Cancelled Nov 9, 1993 · Built 1946 · Grovers Robert EN119BBeech G35 · S/N D4427Cancelled Aug 26, 1991 · Second triennial mailing, no response · Sullivan Murt JN75707Cessna 172N · S/N 17267889Cancelled Jun 27, 1983 · Gregory Scott N& Morefield Danny WN6331KCessna R172K · S/N R172-2040Cancelled Aug 1, 1980 · Mccausland Aviation IncN2031XCessna 182H · S/N 15256131Cancelled Jun 4, 1980 · Exported to Canada · Built 1965 · Stoltzfus Jason EN7381DPiper PA-18A 150 · S/N 18-5746Cancelled Feb 9, 1971 · Pecos Valley IncN6939XCessna 172B · S/N 17247839Cancelled Feb 5, 1971 · Mccausland Aviation IncN8890WPiper PA-28-235 · S/N 28-10452Cancelled Jun 25, 1965 · Bit Grinding Service IncN96732Taylorcraft BL · S/N 9032Cancelled May 26, 1965 · Runyan L LN9087DPiper PA-18A 150 · S/N 18-6462Cancelled May 25, 1965 · S C LovejoyN1130KLuscombe 8A · S/N 3857Cancelled May 22, 1965 · Joe C MartinN2816MPiper PA-12 · S/N 12-1178Cancelled May 21, 1965 · Kindel FrankN2777DCessna 170B · S/N 25319Cancelled May 19, 1965 · May T LeonardN53017Cessna T-50 · S/N 5078Cancelled Jul 22, 1963 · Exported to Nicaragua · Pecos Valley IncN9433RSnow S2A · S/N 1063ACancelled Jul 31, 1962 · Exported to Mexico · Pecos Valley IncN5032KDouglas B-26B · S/N 44-34335ACancelled Nov 22, 1960 · Potash Co Of AmericaN3436CCessna 170A · S/N 26479Cancelled Jul 11, 1958 · Bruhn Henry HN4526BCessna 180 · S/N 31425Cancelled Jan 20, 1958 · Exported to Argentina · Mccausland Aviation IncN2867PPiper PA-18A 150 · S/N 18-4454Cancelled Mar 15, 1956 · Exported to Nicaragua · Built 1955 · Pecos Valley Flying ServiceN2543DCessna 170 · S/N 20695Cancelled Mar 5, 1956 · Carr John DN5703CCessna 170A · S/N 19823Cancelled Feb 27, 1956 · Menzdorf Marvin ON65330Consolidated Vultee BT-13A · S/N 6343Cancelled Feb 17, 1956 · Carlsbad Flying Service IncN9963ACessna 170A · S/N 19323Cancelled Jan 31, 1956 · Madera M RN3022NCessna 140 · S/N 13280Cancelled Jan 20, 1956 · Mccousland Aviation IncN2329HEngineering & Research ERCOUPE 415-C · S/N 2954Cancelled Nov 21, 1955 · Carlsbad Flying Service IncN2561HErcoupe 415-C · S/N 3186Cancelled Nov 21, 1955 · Built 1946 · Carlsbad Flying ServiceN20360Taylorcraft A · S/N 461Cancelled Oct 19, 1955 · Built 1937 · Spurrier Willie GeaterN3498BBeech E35 · S/N D-3716Cancelled Jun 30, 1955 · Sides JoeN25252Luscombe 8A · S/N 1159Cancelled May 25, 1955 · Hillhouse AllenN75763Consolidated Vultee SNV-1 · S/N 8644Cancelled Oct 23, 1951 · Built 1943 · Carlsbad Flying Service Inc
Back to Carlsbad, NM