Sandia Park, NM
Cancelled registrations · 23
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 = 'SANDIA PARK' 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 = 'SANDIA PARK' 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.
N27APApollo DELTA JET AS-III912S · S/N 000011N4462VCameron Balloons US A-250 · S/N 6232N8762PPiper PA-24-260 · S/N 24-4212N709TCThunder & Colt Airborne Amer AX10-180S1 · S/N 2444N3354Nmtrikes JFD-03 · S/N NMT-05N2454Nmtrikes JFD-02 · S/N NMT-04N2054Nmtrikes AEROS-Z · S/N NMT-02N1354Nmtrikes AEROS-Z · S/N NMT-01N80617Dempsey James F AEROS-Z · S/N 065N2354Nmtrikes JFD-01 · S/N NMT-03N116TDRolladen-Schneider OHG LS3-A · S/N 3398N886PNCameron Balloons US 0-105 · S/N 5779N734KSchleicher ASW-20B · S/N 20624N8798Bellanca 7GCAA · S/N 257-73N3918DCessna 182A · S/N 34618N2FVRolladen-Schneider LS-3 · S/N 3299N1069RRaven S-50A · S/N S50A-265N5214NCessna 182Q · S/N 18267576N56084Griffith Travis R DELTA JET III 912S · S/N USA 240406N4043NCustom 9'S Design W-100-3 · S/N 033N36325Balloon Works FIREFLY 7 · S/N F7-167N51MWBeech A36 · S/N E-2355N2223HBalloon Works FIREFLY 7 · S/N 7780
Back to Sandia Park, NM