Skywest Airlines Inc
Registered aircraft · 564
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 AIRLINES INC' OR list_contains(g.other_registrant_names, 'SKYWEST AIRLINES 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 AIRLINES INC' OR list_contains(g.other_registrant_names, 'SKYWEST AIRLINES 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.
N103SYEmbraer S A ERJ 170-200 LL · S/N 17000390N105SYEmbraer S A ERJ 170-200 LL · S/N 17000395N106SYEmbraer S A ERJ 170-200 LR · S/N 17000399N107SYEmbraer S A ERJ 170-200 LR · S/N 17000400N108SYEmbraer S A ERJ 170-200 LL · S/N 17000401N109SYEmbraer S A ERJ 170-200 LR · S/N 17000404N110SYEmbraer S A ERJ 170-200 LL · S/N 17000405N113SYEmbraer S A ERJ 170-200 LL · S/N 17000407N114SYEmbraer ERJ 170-200 LR · S/N 17000410N116SYEmbraer S A ERJ 170-200 LL · S/N 17000411N117SYEmbraer S A ERJ 170-200 LR · S/N 17000416N118SYEmbraer S A ERJ 170-200 LR · S/N 17000420N119SYEmbraer S A ERJ 170-200 LR · S/N 17000421N120SYEmbraer S A ERJ 170-200 LR · S/N 17000425N121SYEmbraer S A ERJ 170-200 LR · S/N 17000430N122SYEmbraer S A ERJ 170-200 LR · S/N 17000431N124SYEmbraer S A ERJ 170-200 LR · S/N 17000439N127SYEmbraer S A ERJ 170-200 LR · S/N 17000441N128SYEmbraer S A ERJ 170-200 LR · S/N 17000445N130SYEmbraer S A ERJ 170-200 LR · S/N 17000449N131SYEmbraer S A ERJ 170-200 LR · S/N 17000450N132SYEmbraer S A ERJ 170-200 LR · S/N 17000451N133SYEmbraer S A ERJ 170-200 LR · S/N 17000452N134SYEmbraer S A ERJ 170-200 LR · S/N 17000458N135SYEmbraer S A ERJ 170-200 LR · S/N 17000460N136SYEmbraer S A ERJ 170-200 LR · S/N 17000462N138SYEmbraer S A ERJ 170-200 LR · S/N 17000466N139SYEmbraer S A ERJ 170-200 LR · S/N 17000468N140SYEmbraer S A ERJ 170-200 LR · S/N 17000470N141SYEmbraer S A ERJ 170-200 LR · S/N 17000472N142SYEmbraer S A ERJ 170-200 LR · S/N 17000475N143SYEmbraer S A ERJ 170-200 LR · S/N 17000476N144SYEmbraer S A ERJ 170-200 LR · S/N 17000482N145SYEmbraer S A ERJ 170-200 LR · S/N 17000484N146SYEmbraer S A ERJ 170-200 LR · S/N 17000491N148SYEmbraer S A ERJ 170-200 LR · S/N 17000492N149SYEmbraer S A ERJ 170-200 LR · S/N 17000495N150SYEmbraer S A ERJ 170-200 LR · S/N 17000499N151SYEmbraer S A ERJ 170-200 LR · S/N 17000503N152SYEmbraer S A ERJ 170-200 LR · S/N 17000549N153SYEmbraer S A ERJ 170-200 LR · S/N 17000553N154SYEmbraer S A ERJ 170-200 LR · S/N 17000556N156SYEmbraer ERJ 170-200 LR · S/N 17000557N157SYEmbraer S A ERJ 170-200 LR · S/N 17000558N160SYEmbraer ERJ 170-200 LR · S/N 17000568N161SYEmbraer ERJ 170-200 LR · S/N 17000569N162SYEmbraer S A ERJ 170-200 LR · S/N 17000576N163SYEmbraer S A ERJ 170-200 LR · S/N 17000577N164SYEmbraer ERJ 170-200 LR · S/N 17000603N165SYEmbraer S A ERJ 170-200 LR · S/N 17000613
Back to Skywest Airlines Inc