Skip to content

Cancelled registrations · 121

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 = 'NM' AND d.registrant_city = 'LAS CRUCES' 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 = 'NM' AND d.registrant_city = 'LAS CRUCES'
  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 = 'NM' AND d.registrant_city = 'LAS CRUCES'
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.

N690NMJoseph Millette/Ross Palmer ALIGN TREX 700L DFC · S/N UASFTC081Cancelled May 9, 2022 · Registration expired, pending cancellation · Regents Of New Mexico State University N104NMJoseph Millette X4 · S/N UASFTC0080Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Regents Of New Mexico State University N106NM3D Robotics Y6 MULTI-COPTER · S/N U434454Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Regents Of New Mexico State University N808NMAeronautics ORBITER · S/N 808Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Regents Of New Mexico State University N116EESaulsberry BOOTSTRAP B-2 · S/N B2ACancelled Jun 5, 2021 · Registration expired, pending cancellation · Saulsberry Regor Personal Representative N208NM3D Robotics X8 MULTI-COPTER · S/N U434455Cancelled May 8, 2021 · Registration expired, pending cancellation · Regents Of New Mexico State University N8520RBellanca 14-19-3 · S/N 4285Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1966 · Soules William P N8244RBellanca 17-30A · S/N 30446Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 1972 · Parish Inc N93660Engineering & Research ERCOUPE 415-C · S/N 983Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Gillihan Michael L N6141KCleveland Roland E 4OX · S/N 001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · Erhard Dan O N9043DAerostar International RAVEN S49A · S/N S49A-3139Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1992 · Boucher Phillip Larry N315BDDiven Robert NIEUPORT 17 · S/N 046Cancelled Jan 11, 2019 · First renewal notice · Built 2018 · Diven Robert N84638Aeronca 7AC · S/N 7AC-3343Cancelled May 21, 2018 · Revoked, canceled · Built 1946 · Gillex D M N8338SCessna 182H · S/N 18256438Cancelled May 10, 2018 · First renewal notice · Built 1965 · Aero Newton Inc N301NMMLB BAT 3 · S/N 1Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Usda Ars Jornada Experimental Range N377NMMLB BAT 3 · S/N 772Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Usda Ars Jornada Experimental Range N3270CBeech E35 · S/N D-3936Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1954 · Mattavich Matthew M N613LEBoring Robert Burton RV6A · S/N 23993Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Baker Seth A N6738TCessna 310D · S/N 39038Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1959 · Newton M Douglas N5HBButtles Harold SNS-7 · S/N 212Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1981 · Newton Garth C N617NMAeronautics Defense Systems LT AEROSTAR · S/N 617Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Regents Of New Mexico State University N149AAPZL 110 KOLIBER 160A · S/N 04980083Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Adventure Leasing N1482EAeronca 7BCM · S/N 7AC-5045Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1946 · Waid Fred M N17FUGoldsborough E Scott VIPER · S/N 0001Cancelled Jul 17, 2017 · Registration expired, pending cancellation · Built 1994 · Goldsborough E Scott N86KBeech D18S · S/N A247Cancelled Mar 27, 2017 · Built 1946 · Southwest Aviation Inc N9182NAerostar International RX 8 · S/N RX8-3194Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1994 · Kemp John D N199NMBuckeye Industries 582 DUAL · S/N 6099Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Evrage William N732TJCessna T210M · S/N 21061759Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Charter Enterprise N736CVCessna R172K · S/N R1722429Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Harkey Jack D N139Beech B-60 · S/N P-321Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1975 · Lasershield Systems Inc N55781Cessna 337 · S/N 337-0018Cancelled May 19, 2015 · Registration expired, pending cancellation · Schmitt Chrystain N29783Cameron Balloons US O-84 · S/N 5172Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Built 1985 · Buck Richard N57268Raven S55A · S/N S55A-776Cancelled Oct 30, 2014 · Registration expired, pending cancellation · Built 1981 · Haynes Robert E N5064PPiper PA-24-180 · S/N 24-70Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1958 · Dragon Robert A N2509QBalloon Works FIREFLY 7-15 · S/N F7-765Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1991 · Smith Brian N63709Aerostar International RAVEN S57-A · S/N S57A-3129Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Simpson Randall W N87677Dehavilland TIGER MOTH DH 82A · S/N A17-546Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1942 · Mattavich Matthew M N8NMSchoen Oscar W JR M-1 · S/N M1-1675Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Schoen Oscar W Jr N986TCThunder & Colt Balloons 77 SERIES I · S/N 1462USCancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Cox Charles Rick N8982XCessna 182D · S/N 18253382Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1961 · Booth Kevin H N63349Cessna 150M · S/N 15077255Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1975 · Baker Seth A N96084Callair A-9A · S/N 1048Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1964 · Dulin Jimmy A N7737Dean John W MINIMAX · S/N 105Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1997 N50651Cessna 150J · S/N 15069460Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1968 · Baker Seth A N22280Cessna 150H · S/N 15068189Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1968 · Baker Seth A N1356Richey-Bensen B-8M · S/N 1Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1968 · Richey Charles A N1485VCessna 172M · S/N 17263619Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1974 · Baker Seth A N3722HBalloon Works FIREFLY 7 · S/N F7-096Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1983 N4628QCessna 152 · S/N 15285043Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1981 · North American Inst Of Avn Of Sc N7411YCameron Balloons US A-105 · S/N 5860Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1993

Back to Las Cruces, NM