Skip to content

Six Chuter LEGEND XL

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 ('05901T0', '060005M', '069001E', '05903WP', '0600074')
  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 ('05901T0', '060005M', '069001E', '05903WP', '0600074')
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.

N102SCGood John S · Lancaster, PABuilt 2010 · S/N 3106 N147SCShields Michael A · Tucson, AZBuilt 2008 · S/N 3094 N149SCBiagioli Mark L · Fort Ogden, FLBuilt 2011 · S/N 3041 N153SCShinn Larry · Stanwood, WABuilt 2008 · S/N 3087 N156SCWhitley Randy · Carlsbad, NMS/N 3095 N158SCWaters Gwen M · Valley Falls, NYBuilt 2009 · S/N 3098 N159SCVisker Jeremy L · Lehi, UTBuilt 2009 · S/N 3103 N168SCStalter Luther · Cooperstown, NYBuilt 2008 · S/N 3082 N183SCTice James D · Gold Canyon, AZBuilt 2018 · S/N 3093 N2080HClark Timothy B · Ogden, IABuilt 2004 · S/N 2997 N218SCDiver Brian · Everett, WABuilt 2010 · S/N 3108 N2480ARegistration Pending · Eagle Mountain, UTRegistration pendingBuilt 2004 · S/N 3000 N2531GHarbuck Richard · Palmer, AKBuilt 2004 · S/N LEGEND XL-2981 N294PHHayden Paul A · Ellsworth, WIBuilt 2008 · S/N 3010 N536LLKoeppen Colin K · Albion, NEBuilt 2004 · S/N 2987 N5508HClaussen Larry S · Independence, ORS/N 3026 N659DGUskoski Neal E · Brush Prairie, WABuilt 2004 · S/N LEGEND XL-2970 N9185CJorgensen Ronald G · Touchet, WABuilt 2005 · S/N 3030

Back to Six Chuter LEGEND XL