Seattle, WA
Cancelled registrations · 1,563
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 = 'WA' AND d.registrant_city = 'SEATTLE' 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 = 'WA' AND d.registrant_city = 'SEATTLE' 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.
N985AMBoeing 737-823 · S/N 30901N379BJBoeing 737-8DR · S/N 32777N2062DBell 206B · S/N 3334N9179TPiper PA-31 · S/N 31-782N8283GCessna 177RG · S/N 177RG0183N373BJBoeing 737-7ED · S/N 32627N5767VBeech A23-19 · S/N MB-51N788BABoeing 737-85F · S/N 30476N235LPTriple S Aero LANCAIR IV P · S/N 235N4879BCessna 310 · S/N 35179N7771Boeing 777-200 · S/N 27116N305BHMooney M20K · S/N 25-0260N817LDehavilland DHC-6-300 · S/N 817N821LDehavilland DHC-6-300 · S/N 821N29YLSchempp-Hirth DISCUS B · S/N 67N757XBoeing 757-330 · S/N 29016N30ADAero Commander 1121B · S/N 143N92MKConsolidated Vultee LB-30 · S/N 55N257NWPiper PA-31-350 · S/N 317952014N22654Lau Alvin F STOLP STARLIT · S/N 01A28N903LEEmbraer EMB-110P1 · S/N 110397N902LEEmbraer EMB-110P1 · S/N 110400N8336QCessna TU206F · S/N U20603197N521DJDel Duca Dan J GOLDWING/STARFIRE · S/N 186N51816Cessna 402B · S/N 402B0816N644KStapleton William T RV-6 · S/N 217SSN852MADehavilland DHC-8-102 · S/N 349N14MKLet BLANIK L-13 · S/N 175213N1456WBell 206A · S/N 388N666HLPiper PA-34-200T · S/N 347770235N6226MConvair 580 · S/N 477N81PHOmac OMAC I · S/N 002N1253EBoeing 727-2L5 · S/N 21539N1261EBoeing 727-2L5 · S/N 21540N3736JCessna 150G · S/N 15065036N67759Cessna 152 · S/N 15282001N77779Boeing 777-236 · S/N 27105N877UMBoeing 727-230 · S/N 20525N4878XRaugust John A XTC · S/N 39N157JCAero L-39 ALBATROS · S/N 3549N161JCAero L-39 ALBATROS · S/N 8212N747BKBoeing 747-SP70 · S/N 21604N747BLBoeing 747-SP70 · S/N 21605N2357DRobinson Helicopter R22 MARINER · S/N 2294MN9290Enstrom F-28A · S/N 270N874UMUnknown model · S/N 20014N2784RFairchild FH-227D · S/N 573N6188ABeech C24R · S/N MC770N9190UCessna 150M · S/N 15078141N9124GCessna 182N · S/N 18260664
Back to Seattle, WA