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.
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
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.
N111AHRobinson Helicopter R22 BETA · S/N 3531N11364Robinson Helicopter R22 BETA · S/N 2508N117LHScholz D E/Clarke A J LANCAIR IV-P · S/N LIV-226N123MVRobinson Helicopter R44 II · S/N 10664N131NWHughes Helicopters HUGHES 369D · S/N 1131DN13GHRobinson Helicopter R22 ALPHA · S/N 0388N155CPRobinson Helicopter R44 II · S/N 10933N155MBRobinson Helicopter R22 BETA · S/N 1550N1976BRobinson Helicopter R44 · S/N 0637N223VRRobinson Helicopter R44 II · S/N 10823N2334XRobinson Helicopter R22 BETA · S/N 2149N23UPRobinson Helicopter R66 · S/N 0270N2428VRobinson Helicopter R22 BETA · S/N 1677N26385Robinson Helicopter R22 BETA · S/N 0804N266WCRobinson Helicopter R66 · S/N 0509N310KDRobinson Helicopter R22 BETA · S/N 3028N316TCRobinson Helicopter R44 II · S/N 12303N329JKRobinson Helicopter R44 II · S/N 10674N339KBRobinson Helicopter R66 · S/N 0531N39BPRobinson Helicopter R22 BETA · S/N 2906N4010BRobinson Helicopter R22 MARINER · S/N 1418MN40338Robinson Helicopter R22 BETA · S/N 1556N40353Robinson Helicopter R22 BETA · S/N 1574N40398Robinson Helicopter R22 BETA · S/N 1590N4082JRobinson Helicopter R22 BETA · S/N 1794N4084TRobinson Helicopter R22 BETA · S/N 1863N41WBRobinson Helicopter R22 BETA · S/N 2034N422RXRobinson Helicopter R44 · S/N 1094N442CPRobinson Helicopter R44 II · S/N 10137N444ZZRobinson Helicopter R22 BETA · S/N 2126N447RCRobinson Helicopter R44 · S/N 0205N447SRobinson Helicopter R44 · S/N 1489N4945FRobinson Helicopter R44 II · S/N 10015N519GPRobinson Helicopter R22 BETA · S/N 2039N5200WHughes Helicopters 369E · S/N 0025EN54BARobinson Helicopter R22 BETA · S/N 1888N555BNRobinson Helicopter R44 · S/N 1079N605HARobinson Helicopter R22 ALPHA · S/N 0439N63990Robinson Helicopter R22 BETA · S/N 0664N670EWRobinson Helicopter R44 II · S/N 12849N674PBRobinson Helicopter R22 BETA · S/N 2687N700CXRobinson Helicopter R22 BETA · S/N 3162N70KARobinson Helicopter R44 · S/N 1058N7184GRobinson Helicopter R44 · S/N 0937N7189KRobinson Helicopter R22 BETA · S/N 3118N7190JRobinson Helicopter R22 BETA · S/N 3109N7198JRobinson Helicopter R22 BETA · S/N 3232N71FHRobinson Helicopter R22 MARINER · S/N 1724MN7265RCessna T206H · S/N T20608045N7371TRobinson Helicopter R44 II · S/N 10563
Back to Emerald City Aircraft Leasing Inc