Southwest Airlines Co
Registered aircraft · 744
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 = 'SOUTHWEST AIRLINES CO' OR list_contains(g.other_registrant_names, 'SOUTHWEST AIRLINES CO') 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 = 'SOUTHWEST AIRLINES CO' OR list_contains(g.other_registrant_names, 'SOUTHWEST AIRLINES CO') 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.
N1776RBoeing 737-8 · S/N 42701N1801UBoeing 737-8 · S/N 60223N1802UBoeing 737-8 · S/N 60225N1803UBoeing 737-8 · S/N 60226N1804UBoeing 737-8 · S/N 60650N1805UBoeing 737-8 · S/N 60649N1806UBoeing 737-8 · S/N 60652N1807UBoeing 737-8 · S/N 60653N1809UBoeing 737-8 · S/N 60188N1810UBoeing 737-8 · S/N 60187N1811UBoeing 737-8 · S/N 60219N200WNBoeing 737-7H4 · S/N 32482N201LVBoeing 737-7H4 · S/N 29854N203WNBoeing 737-7H4 · S/N 32483N204WNBoeing 737-7H4 · S/N 29855N205WNBoeing 737-7H4 · S/N 34010N206WNBoeing 737-7H4 · S/N 34011N207WNBoeing 737-7H4 · S/N 34012N208WNBoeing 737-7H4 · S/N 29856N209WNBoeing 737-7H4 · S/N 32484N210WNBoeing 737-7H4 · S/N 34162N211WNBoeing 737-7H4 · S/N 34163N212WNBoeing 737-7H4 · S/N 32485N213WNBoeing 737-7H4 · S/N 34217N214WNBoeing 737-7H4 · S/N 32486N215WNBoeing 737-7H4 · S/N 32487N216WRBoeing 737-7H4 · S/N 32488N217JCBoeing 737-7H4 · S/N 34232N218WNBoeing 737-7H4 · S/N 32489N219WNBoeing 737-7H4 · S/N 32490N220WNBoeing 737-7H4 · S/N 32491N221WNBoeing 737-7H4 · S/N 34259N222WNBoeing 737-7H4 · S/N 34290N224WNBoeing 737-7H4 · S/N 32493N225WNBoeing 737-7H4 · S/N 34333N226WNBoeing 737-7H4 · S/N 32494N227WNBoeing 737-7H4 · S/N 34450N228WNBoeing 737-7H4 · S/N 32496N229WNBoeing 737-7H4 · S/N 32498N231WNBoeing 737-7H4 · S/N 32499N232WNBoeing 737-7H4 · S/N 32500N234WNBoeing 737-7H4 · S/N 32502N236WNBoeing 737-7H4 · S/N 34631N240WNBoeing 737-7H4 · S/N 32503N241WNBoeing 737-7H4 · S/N 32504N242WNBoeing 737-7H4 · S/N 32505N243WNBoeing 737-7H4 · S/N 34863N244WNBoeing 737-7H4 · S/N 34864N245WNBoeing 737-7H4 · S/N 32506N246LVBoeing 737-7H4 · S/N 32507
Back to Southwest Airlines Co