Registered aircraft · 17

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

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 = 'STRAIGHT UP LEASING INC' OR list_contains(g.other_registrant_names, 'STRAIGHT UP LEASING INC') ORDER BY g.n_number

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 = 'STRAIGHT UP LEASING INC' OR list_contains(g.other_registrant_names, 'STRAIGHT UP 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 = 'STRAIGHT UP LEASING INC' OR list_contains(g.other_registrant_names, 'STRAIGHT UP 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.

N142AVRobinson Helicopter R44 II · S/N 14776Built 2024 · Medford, OR N257CKCirrus Design SF50 · S/N 0541Built 2024 · Medford, OR N309LWBell 407 · S/N 53553Built 2003 · Medford, OR N3546TBell 407 · S/N 53671Built 2006 · Medford, OR N429HRBell Helicopter Textron Canada 429 · S/N 57147Built 2013 · Medford, OR N454NCBell 407 · S/N 53382Built 1999 · Medford, OR N455NCBell Helicopter Textron Canada 407 · S/N 53941Built 2009 · Medford, OR N533NCBell 412EP · S/N 36403Medford, OR N602CKSikorsky UH-60A · S/N 81-23622Medford, OR N603NCSikorsky UH-60A · S/N 80-23462Built 1980 · Medford, OR N604NCSikorsky UH-60A · S/N 83-23909Built 1983 · Medford, OR N605NCSikorsky HH-60L · S/N 01-26894Built 2001 · Medford, OR N606NCSikorsky UH-60A · S/N 82-23695Built 1982 · Medford, OR N607CKSikorsky UH-60L · S/N 85-24424Built 1985 · Medford, OR N608NCSikorsky UH-60L · S/N 85-24406Built 1985 · Medford, OR N611ACBell Helicopter Textron Canada 407 · S/N 54086Built 2011 · Medford, OR N958TRBell 407 · S/N 53770Built 2007 · Medford, OR

Back to Straight Up Leasing Inc