Skip to content

Interstate S-1B1

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 ('1850302')
  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 ('1850302')
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.

N2778QBeresford David M · Huntley, ILS/N 91 N30809Brooks Sondra · Callicoon, NYBuilt 1993 · S/N 231 N3771ZReed Gretchen M · Madison, OHBuilt 1943 · S/N 196 N43LGNoble Mitchell S · Carleton, MIS/N 156 N46023Lorenz John C · Edgewood, NMBuilt 1943 · S/N 155 N46243Goracke Terry R · Junction City, ORS/N 162 N46333Wilson Christopher W · Edgewood, NMBuilt 1943 · S/N 93 N46336Lewis Samuel K · Chicago, ILBuilt 1943 · S/N 159 N46962Soto Del Carpio Nhikitoa · Fairbanks, AKBuilt 1943 · S/N 195 N47513Sullivan Ronald E · Sterling, AKS/N 181 N47614Trombley Steve DBA · Worland, WYBuilt 1943 · S/N 44 N48027Bodine Douglas · Anchorage, AKBuilt 1942 · S/N 11 N48443Christian James B · Peyton, COBuilt 1943 · S/N 122 N48616Hall Stanley C · Sequim, WABuilt 1943 · S/N 78 N48652Lorenz John C · Edgewood, NMBuilt 1943 · S/N 135 N48966Kapellair LLC · Wickenburg, AZBuilt 1943 · S/N 230 N49061Pacific Coast Air Museum · Santa Rosa, CABuilt 1943 · S/N 65 N49105Carlyle Properties LLC · Columbia Falls, MTS/N 203 N49208Graf Eugene · Bozeman, MTS/N 214 N52413Beck Whitney S · Wahpeton, NDS/N 206 N53250Smith Leon Reese · Soldotna, AKBuilt 1943 · S/N 240 N537KTEvers Jeffrey D · Deer Park, WAS/N 48 N6513CZorn Tony P · Lyons, GAS/N 43-2653

Back to Interstate S-1B1