North Salt Lake, UT
Cancelled registrations · 1,028
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 = 'UT' AND d.registrant_city = 'NORTH SALT LAKE' 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 = 'UT' AND d.registrant_city = 'NORTH SALT LAKE' 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.
N606SBLearjet 60 · S/N 184N4249Gulfstream Aerospace GIV-X (G450) · S/N 4249N583TDSupernal FSTD1 · S/N 001N650DJGulfstream Aerospace GVI (G650) · S/N 6312N280LMIai GULFSTREAM G280 · S/N 2054N660FBDehavilland Acft Of Canada DHC 6-300 · S/N 472N250AVBoeing 737-31S · S/N 29060N320FRAirbus S A S A320-214 · S/N 02937N247PFSkydweller S L SOLAR IMPULSE SI2 · S/N 1N919NXAirbus A321-231 · S/N 02919N458ACAirbus Industrie A320-232 · S/N 3332N610GWGulfstream Aerospace G-IV · S/N 1289N775KSDehavilland DHC-6 · S/N 244N33AUPilatus PC-24 · S/N 183N925BBRaytheon B200 · S/N BB-1704N900WSHawker Beechcraft HAWKER 850XP · S/N 258893N370HCTextron B300 · S/N FL-1370N80VLBritish Aerospace BAE JETSTREAM 3101 · S/N 796N88959Bombardier BD-700-2A12 · S/N 70037N40VLBritish Aerospace BAE JETSTREAM 3101 · S/N 779N641RSGulfstream Aerospace GIV-X (G450) · S/N 4171N165SLPiaggio Aero Industries P180 · S/N 1135N324ADDassault-Breguet MYSTERE FALCON 900 · S/N 67N58430Hughes Helicopters HUGHES 369D · S/N 1290636DN535DGAirbus Helicopters AS332L2 · S/N 2535N123ABBombardier BD-700-2A12 · S/N 70253N9098EBombardier BD-700-1A10 · S/N 9098N3394XAir Tractor AT-502B · S/N 502B-3394N600TNEmbraer EMB-135BJ · S/N 145505N181MMBombardier BD-700-1A10 · S/N 9772N22873Raytheon 1900 · S/N UE310N20077Textron 208B · S/N 208B5923N300TZEmbraer Executive EMB-505 · S/N 50500952N730SHAgustawestland Philadelphia AW119MKII · S/N 15031N30ABPilatus PC-12/47E NGX · S/N 2069N655JLBombardier BD-700-1A10 · S/N 60034N67NABombardier BD-700-1A11 · S/N 9586N464LSTextron 172S · S/N 172S13464N463LSTextron 172S · S/N 172S13463N444RJDassault FALCON 7X · S/N 295N17108Embraer EMB-145XR · S/N 145655N708GAGulfstream Aerospace GVIII-G700 · S/N 87008N18HABombardier BD-700-1A11 · S/N 9198N2959AAirbus Helicopters EC 225 LP · S/N 2959N390ELHawker Beechcraft 390 · S/N RB-284N975DXPiper PA-28-181 · S/N 2881975N978DXPiper PA-28-181 · S/N 2881978N637HNBombardier BD-700-1A10 · S/N 60037N657HNBombardier BD-700-1A10 · S/N 60057N974DXPiper PA-28-181 · S/N 2881974
Back to North Salt Lake, UT