Skip to content

Soaring Concepts SKY TREK

Registered aircraft · 18

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('05901JQ', '05903HN', '060004B', '05903YI')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('05901JQ', '05903HN', '060004B', '05903YI')
ORDER BY 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.

N1674TMccammack Clayton D · Cloverdale, INBuilt 2007 · S/N A054SCI N238KSStone Keith R · Ochlocknee, GAS/N 200 3018 N25149Ott Dustin D · Brillion, WIBuilt 2007 · S/N 2005044 N2526KJones Terry L · Halstead, KSBuilt 2002 · S/N 2002009 N2546LGeigley Arlin L · Montrose, COBuilt 2002 · S/N 2002010 N2563ADick Ronald J · Fort Wayne, INBuilt 2006 · S/N AO47SCI N261DKClampitt Kent V · Eckert, COBuilt 2006 · S/N SCI0492006 N3507UEaa · Oshkosh, WIBuilt 2004 · S/N 2004025 N4074AGonser Duane J · Sturgis, MIBuilt 2002 · S/N 2002008 N41074Bouche Kevin J · Pelican Lake, WIS/N 2004031 N5134SObad Saleh A · Howe, INS/N 2005041 N6178XMetcalf Jerry J · Sunrise Beach, TXS/N 2004029 N65558Allan Mike Jw · Constantine, MIBuilt 2002 · S/N 2002012 N69NPHodgson Peter C · Dansville, MIBuilt 2007 · S/N A057SCI N70077Wishnow Mark B · Hagerstown, MDBuilt 2004 · S/N 2004036 N75301Veenstra Ronald L · Hopkins, MIBuilt 2007 · S/N A056SCI N7530NVeenstra Michael S · Hopkins, MIBuilt 2002 · S/N 20013 N85474Keeslar David L · Sturgis, MIBuilt 2004 · S/N 2004027

Back to Soaring Concepts SKY TREK