Skip to content

Arion LIGHTNING LS-1

Registered aircraft · 23

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 ('060006O', '069001H')
  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 ('060006O', '069001H')
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.

N125GDLino Lopez Pa · Eustis, FLBuilt 2010 · S/N 105 N142ALKt Resources Inc · Glendora, CABuilt 2011 · S/N 137 N282ASElliott James Richard · Florence, ALBuilt 2011 · S/N 126 N325ALRodgers Dustin · White, GABuilt 2009 · S/N 78 N329ALJenkins Lawrence · Deming, NMBuilt 2010 · S/N 100 N332ALSchweitzer Jay A · Missoula, MTBuilt 2010 · S/N 107 N335ALPerry Robert K · Buellton, CABuilt 2011 · S/N 133 N336ALHarris Robert J · Franklinton, LABuilt 2012 · S/N 139 N337ALReisman Evan · Columbus, OHBuilt 2012 · S/N 142 N338ALAircraft Leasing Service LLC · Lookout Mountain, TNBuilt 2012 · S/N 154 N339ALStewart Richard Linn · Lapeer, MIBuilt 2013 · S/N 163 N344ALSchnick Brian · Valparaiso, INBuilt 2015 · S/N 173 N346BRKonkle Nolan A · Sharpsburg, GABuilt 2010 · S/N 88 N46HMColvin Johnny L · Hoover, ALBuilt 2011 · S/N 130 N502MARegistered aircraftBuilt 2022 · S/N 196 N713MLMsl Aviation LLC · Saint Charles, MOBuilt 2011 · S/N 116 N72VRRed Rock Reef LLC · Las Vegas, NVBuilt 2013 · S/N 164 N81DJLamb Glenn · Myrtle Beach, SCBuilt 2009 · S/N 42 N897PRSix Knot Entertainment LLC · San Diego, CABuilt 2010 · S/N 96 N925GCKemnitz Jonathan L · Minnetonka, MNBuilt 2010 · S/N 102 N932CBBackes Alexander · Pennsburg, PAS/N 108 N977PWBruce Robert H · Boerne, TXBuilt 2014 · S/N 170 N97RBHilaman Chris T · Oak Hill, FLBuilt 2012 · S/N 153

Back to Arion LIGHTNING LS-1