Moriarty, NM
Cancelled registrations · 60
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 = 'MORIARTY' 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 = 'MORIARTY' 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.
N807Start & Flug H101 "SALTO" · S/N 13N603SCSceye AIRSHIP · S/N SSV 70.1N604SCSceye AIRSHIP · S/N SSV 70.2N605SCSceye AIRSHIP · S/N SSV 70.3N608SCSceye AIRSHIP · S/N TV-17N94BGBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3652N505MAFlight Design CTLS · S/N F-08-05-08N2762Flug & Fahrzeugwerke DIAMANT 16.5 · S/N 061N148MACessna 150L · S/N 15072811N202ZApplebay Sailplanes ZIA · S/N 2N22HLApplebay Sailplanes ZUNI II · S/N 26N445MSchleicher KA 6 CR · S/N 6506N841DRSchreder HP-12A · S/N 78N90624Let BLANIK L-13 · S/N 025620N916GBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3753N333XTNemesis Air Racing NXT · S/N 1AN4323NAerovodochody L-29 DELFIN · S/N 194145N429RBBeskow Charles R WOODSTOCK · S/N 429N770TATitan Aerospace Holdings SOLARA 50 · S/N 0003N470TATitan Aerospace Holdings SOLARA 50 · S/N 0002N950TATitan Aerospace Holdings SOLARA 50 · S/N 0001N4886YPiper PA-25-235 · S/N 25-4691N87TATitan Aerospace Holdings SOLARA 10 · S/N 0004N440TATitan Aerospace Holdings SOLARA 10 · S/N 0003N445TATitan Aerospace Holdings SOLARA 10 · S/N 0002N93RGMolino PIK-20B · S/N 20103N12ZWAero Tek ZUNI · S/N 12N112CCCampbell CSG-1 · S/N 112N53613Laister-Kauffman LK-10A · S/N 28N8661RSchweizer SGS 1-26A · S/N 194N68582Nelson PG-185-B · S/N 82N448ECPipistrel TAURUS G4 · S/N 2011G4N19PFApplebay Sailplanes ZUNI · S/N 19N791DSchleicher RHONLERCHE II · S/N 270N3837JBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3762N8752RScheibe L SPATZ-55 · S/N 759N7799COldershaw Jana Linn JANA LINN 0-2 · S/N 1N424ESSchleicher K 6 CR-PE · S/N 6350N1352Hoey-Johnson BG-12B · S/N 1000N9020CTaylor Fred G MONNETT-MONERAI-S · S/N 219N941WBSlingsby TYPE 21B SEDBERGH · S/N WB941N577TATitan Aerospace Holdings SOLARA 10 · S/N 0001N64JJSinclair John S SUPER ALBATROSS · S/N 003N7984Schleicher RHONLERCHE II · S/N 93/58N24AMMoore Arlen C SS-3 · S/N 1N500CKGlaser-Dirks DG-500M · S/N 5E 142 M56N897ENNierich HP-18 · S/N EN-1N8091VCessna A188 · S/N 188-0341N11BJMaupin-Barnhart BJ-1B · S/N 2N251FSchreder HP-11A · S/N 45
Back to Moriarty, NM