Skywest Leasing Inc
Registered aircraft · 112
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 = 'SKYWEST LEASING INC' OR list_contains(g.other_registrant_names, 'SKYWEST 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 = 'SKYWEST LEASING INC' OR list_contains(g.other_registrant_names, 'SKYWEST 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.
N104JADiamond Aircraft Ind DA 40 · S/N 40.440N117BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0614N117VAVulcanair S P A VULCANAIR V1.0 · S/N 1006N118BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0615N120BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0616N124BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0617N127BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0618N130BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0619N134BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0620N135BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0621N139BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0623N139DADiamond Aircraft Ind DA20-C1 · S/N C0619N140BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0624N147BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0631N149BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0633N154BFCzech Sport Aircraft A S SPORTCRUISER · S/N C0634N156PSDiamond Aircraft Ind DA 40 · S/N 40.492N169AGPiper PA-28-181 · S/N 2881810N175AGPiper PA-28-181 · S/N 2881753N195MAPiper PA-28-181 · S/N 2881029N22QQDiamond Aircraft Ind DA 40 · S/N 40.447N254AGPiper PA-28-181 · S/N 2881754N276AGPiper PA-28-181 · S/N 2881811N281TWPiper PA-28-181 · S/N 2881091N286PAPiper PA-44-180 · S/N 4496109N287PAPiper PA-44-180 · S/N 4496110N287SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0595N288PAPiper PA-28-181 · S/N 2843502N292PAPiper PA-44-180 · S/N 4496116N302PAPiper PA-44-180 · S/N 4496121N3044UPiper PA-28-181 · S/N 2843572N317PAPiper PA-44-180 · S/N 4496133N345AGPiper PA-28-181 · S/N 2881812N370SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0597N396AGNew Piper PA-28-181 · S/N 28-43163N401PAPiper PA-28-181 · S/N 2843444N404AGPiper PA-28-181 · S/N 2881813N404EPCessna 172S · S/N 172S11436N4131TPiper PA-28-181 · S/N 2843216N4143APiper PA-28-181 · S/N 2843217N4144XPiper PA-28-181 · S/N 2843267N41487Piper PA-28-181 · S/N 2843179N4148DPiper PA-28-181 · S/N 2843170N4167KPiper PA-28-181 · S/N 2843342N416PAPiper PA-28-181 · S/N 2843438N418PAPiper PA-28-181 · S/N 2843414N419PAPiper PA-28-181 · S/N 2843413N424PAPiper PA-28-181 · S/N 2843468N429TPDiamond Aircraft Ind DA 42 · S/N 42.090N433MAPiper PA-28-181 · S/N 28-43362
Back to Skywest Leasing Inc