Santa Fe, NM
Cancelled registrations · 141
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 = 'SANTA FE' 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 = 'SANTA FE' 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.
N4075QCessna 401 · S/N 401-0175N778RBCessna P210N · S/N P210-00818N71690Cessna 182M · S/N 18259719N860JBeech B200 · S/N BB-1067N201MAEstumkeda Ltd DBA Micco Acft MAC-145B · S/N 260002N53RBRobert A Bristol JR LANCAIR EVOLUTION · S/N EVO-033N737NBCessna 172N · S/N 17269536N602QBeech K35 · S/N D-5825N8251MCessna T210K · S/N 21059251N3290NBalloon Works FIREFLY 8B-15 · S/N F8B-507N118LSCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 174N912JNRobert W Hassel VANS ACFT INC RV-12 · S/N 120706N9HNPipistrel VIRUS 912 · S/N 149V9120804KIT49N4292EAeronca 11CC · S/N 11CC164N31108Metcalf William Gay JR TEAM MINIMAX · S/N WM2N527TSFlight Design CTLS · S/N 08-02-04N993SSchmidt Donald L GS1 GLASTAR · S/N 5917N2325SCessna T337B · S/N 337-0625N7069JBell 47G-4A · S/N 7737N1181DHays Robert C AVID MARK IV · S/N 1349DN6242UMooney M20C · S/N 2081N99949Engineering & Research ERCOUPE 415-C · S/N 2572N606SLPilatus PC-12/47E · S/N 1020N234CTAMS Flight D O O CARAT A · S/N CA011N521JSShumaker Jack C SABRE · S/N N5WAUN3250SCessna 182G · S/N 18255750N100VLVerilite V-100 · S/N 001N608ASLockheed 749-79 · S/N 2600N28GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 356N14PSDiamond Aircraft Ind DA 40 · S/N 40.1100N80BHBumford-Royer CHRISTEN EAGLE II · S/N 0001N2243SGittens David IKENGA/GYGNUS 21P · S/N DK004N9088SBalloon Works FIREFLY 8B-15 · S/N F8B-401N5029RCessna 172M · S/N 17263270N65247Semco Balloon T · S/N SEM124N95SCAerostar International RX 8 · S/N RX8-3230N4125RPiper PA-32-300 · S/N 32-40443N5032Gittens David L DAKI 530Z/IKENGA · S/N DK001N52WDAero Commander 520 · S/N 520-141N63344Beech AT-11 · S/N 4639N117DGGittens David WIND DANCER MK-I · S/N WD001N909DCMiller D Charles KOLB TWINSTAR · S/N 1949N1135NBoeing A75 · S/N 75-5381N120WRDuncan Dan G BD-5B · S/N 2176N5127XHughes Helicopters HUGHES 369D · S/N 1191DN1900HGittens David CYGNUS 21 · S/N DK002N91374Douglas DC3C-S1C3G · S/N 50800N53930Piper J5A · S/N 5-672N72215Cessna U206D · S/N U206-1326N68408Boeing A75N1(PT17) · S/N 75-7687
Back to Santa Fe, NM