Emerald City Aircraft Leasing Inc

Registered aircraft · 74

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'EMERALD CITY AIRCRAFT LEASING INC' OR list_contains(g.other_registrant_names, 'EMERALD CITY AIRCRAFT LEASING INC')
  ORDER BY g.n_number"

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.

N111AHRobinson Helicopter R22 BETA · S/N 3531Built 2004 · Port Orchard, WAN11364Robinson Helicopter R22 BETA · S/N 2508Built 1995 · Port Orchard, WAN117LHScholz D E/Clarke A J LANCAIR IV-P · S/N LIV-226Built 1997 · Port Orchard, WAN123MVRobinson Helicopter R44 II · S/N 10664Built 2005 · Port Orchard, WAN131NWHughes Helicopters HUGHES 369D · S/N 1131DBuilt 1982 · Port Orchard, WAN13GHRobinson Helicopter R22 ALPHA · S/N 0388Built 1984 · Port Orchard, WAN155CPRobinson Helicopter R44 II · S/N 10933Built 2005 · Port Orchard, WAN155MBRobinson Helicopter R22 BETA · S/N 1550Built 1990 · Port Orchard, WAN1976BRobinson Helicopter R44 · S/N 0637Built 1999 · Port Orchard, WAN223VRRobinson Helicopter R44 II · S/N 10823Built 2005 · Port Orchard, WAN2334XRobinson Helicopter R22 BETA · S/N 2149Built 1992 · Port Orchard, WAN23UPRobinson Helicopter R66 · S/N 0270Port Orchard, WAN2428VRobinson Helicopter R22 BETA · S/N 1677Port Orchard, WAN26385Robinson Helicopter R22 BETA · S/N 0804Built 1988 · Port Orchard, WAN266WCRobinson Helicopter R66 · S/N 0509Built 2014 · Port Orchard, WAN310KDRobinson Helicopter R22 BETA · S/N 3028Built 1999 · Port Orchard, WAN316TCRobinson Helicopter R44 II · S/N 12303Built 2008 · Port Orchard, WAN329JKRobinson Helicopter R44 II · S/N 10674Built 2005 · Port Orchard, WAN339KBRobinson Helicopter R66 · S/N 0531Built 2014 · Port Orchard, WAN39BPRobinson Helicopter R22 BETA · S/N 2906Built 1999 · Port Orchard, WAN4010BRobinson Helicopter R22 MARINER · S/N 1418MBuilt 1990 · Port Orchard, WAN40338Robinson Helicopter R22 BETA · S/N 1556Port Orchard, WAN40353Robinson Helicopter R22 BETA · S/N 1574Built 1990 · Port Orchard, WAN40398Robinson Helicopter R22 BETA · S/N 1590Built 1990 · Port Orchard, WAN4082JRobinson Helicopter R22 BETA · S/N 1794Built 1991 · Port Orchard, WAN4084TRobinson Helicopter R22 BETA · S/N 1863Built 1991 · Port Orchard, WAN41WBRobinson Helicopter R22 BETA · S/N 2034Built 1991 · Port Orchard, WAN422RXRobinson Helicopter R44 · S/N 1094Built 2001 · Port Orchard, WAN442CPRobinson Helicopter R44 II · S/N 10137Built 2003 · Port Orchard, WAN444ZZRobinson Helicopter R22 BETA · S/N 2126Built 1992 · Port Orchard, WAN447RCRobinson Helicopter R44 · S/N 0205Built 1995 · Port Orchard, WAN447SRobinson Helicopter R44 · S/N 1489Built 2005 · Port Orchard, WAN4945FRobinson Helicopter R44 II · S/N 10015Built 2002 · Port Orchard, WAN519GPRobinson Helicopter R22 BETA · S/N 2039Built 1991 · Port Orchard, WAN5200WHughes Helicopters 369E · S/N 0025EPort Orchard, WAN54BARobinson Helicopter R22 BETA · S/N 1888Built 1991 · Port Orchard, WAN555BNRobinson Helicopter R44 · S/N 1079Built 2001 · Port Orchard, WAN605HARobinson Helicopter R22 ALPHA · S/N 0439Port Orchard, WAN63990Robinson Helicopter R22 BETA · S/N 0664Built 1987 · Port Orchard, WAN670EWRobinson Helicopter R44 II · S/N 12849Built 2009 · Port Orchard, WAN674PBRobinson Helicopter R22 BETA · S/N 2687Built 1997 · Port Orchard, WAN700CXRobinson Helicopter R22 BETA · S/N 3162Built 2001 · Port Orchard, WAN70KARobinson Helicopter R44 · S/N 1058Built 2001 · Port Orchard, WAN7184GRobinson Helicopter R44 · S/N 0937Built 2000 · Port Orchard, WAN7189KRobinson Helicopter R22 BETA · S/N 3118Built 2000 · Port Orchard, WAN7190JRobinson Helicopter R22 BETA · S/N 3109Port Orchard, WAN7198JRobinson Helicopter R22 BETA · S/N 3232Built 2001 · Port Orchard, WAN71FHRobinson Helicopter R22 MARINER · S/N 1724MBuilt 1991 · Port Orchard, WAN7265RCessna T206H · S/N T20608045Port Orchard, WAN7371TRobinson Helicopter R44 II · S/N 10563Built 2004 · Port Orchard, WA
Back to Emerald City Aircraft Leasing Inc