Wingsleasing LLC
Registered aircraft · 117
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 = 'WINGSLEASING LLC' OR list_contains(g.other_registrant_names, 'WINGSLEASING LLC') 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 = 'WINGSLEASING LLC' OR list_contains(g.other_registrant_names, 'WINGSLEASING LLC') 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.
N446ERCessna 172S · S/N 172S10220N454JAEvektor-Aerotechnik A S HARMONY LSA · S/N 20232217N467ERCessna 172S · S/N 172S10287N472KKSling SLING LSA · S/N 437AN473CATextron 172S · S/N 172S11738N478CATextron 172S · S/N 172S11740N48FFTextron 172S · S/N 172S12875N491CBCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1172/USN491TCDiamond Aircraft Ind DA 40 · S/N 40.914N492CBCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1173/USN493CBCostruzioni Aeronautiche Tecna P-MENTOR · S/N 1174/USN496SPCessna 172S · S/N 172S8037N499DRCessna 172S · S/N 172S9167N499LPPipistrel D O O VIRUS SW 128 · S/N VSWX1280093N510BLPiper PA-28-181 · S/N 2881852N5121GPiper PA-28-180 · S/N 28-5005N512LPPipistrel D O O ALPHA TRAINER · S/N 1139 AT 912 LSAN513BLPiper PA-28-181 · S/N 2881855N518LPPipistrel D O O ALPHA TRAINER · S/N 1208 AT 912 LSAN528BLPiper PA-28-181 · S/N 2881766N532TACostruzioni Aeronautiche Tecna P2006T · S/N 132/USN5344FCessna 172S · S/N 172S9363N5367HCessna 172M · S/N 17265414N53FFTextron 172S · S/N 172S12876N561SACessna 172S · S/N 172S9638N56861Piper PA-28-180 · S/N 28-7405035N57FFTextron 172S · S/N 172S12927N58FFTextron 172S · S/N 172S12928N614BLPiper PA-28-181 · S/N 2881856N61EPDiamond Aircraft Ind DA 42 NG · S/N 42.N121N6348JPiper PA-28-180 · S/N 28-4757N634DFSling SLING LSA · S/N 438AN6365CPiper PA-28-181 · S/N 28-7890366N640TCPiper PA-28-181 · S/N 2843491N64962Cessna 172P · S/N 17275659N6823YPiper PA-23-250 · S/N 27-4163N734WSCessna 172N · S/N 17269178N734XRCessna 172N · S/N 17269201N73574Cessna 172M · S/N 17267551N73917Cessna 172N · S/N 17267744N7669GCessna 172L · S/N 17259369N787DMDiamond Aircraft Ind DA 40 · S/N 40.993N799THTextron 172S · S/N 172S12799N80790Cessna 172M · S/N 17266749N811BLPiper PA-28-181 · S/N 2881853N815ZFSling SLING LSA · S/N 439AN8218ZPiper PA-28-181 · S/N 28-8090320N8314WPiper PA-28-180 · S/N 28-2487N831TSPiper PA-28-151 · S/N 28-7415485N8390KPiper PA-44-180T · S/N 44-8107061
Back to Wingsleasing LLC