Skip to content

Interstate S-1A

Registered aircraft · 66

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

N28312Mattson Joshua C · Gardner, KSBuilt 1941 · S/N 4 N28315Holcomb Garry M · Point, TXS/N 7 N28318Robinson Stephen · Livermore, CABuilt 1941 · S/N 10 N28319Brooks Ronald Alan · Fairbanks, AKBuilt 1941 · S/N 11 N28329Brown Kevin C · Watsonville, CABuilt 1941 · S/N 17 N28332New Vision Aviation Inc · Fresno, CAS/N 20 N34926Pietsch Kent D · Burlington, NDBuilt 1941 · S/N 121 N34939Meeks David · Vineburg, CABuilt 1941 · S/N 34 N37203Birch Robert J · Tacoma, WABuilt 1941 · S/N 46 N37205Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1941 · S/N 48 N37210Coleman Aeromarine Inc · Lakeland, FLBuilt 1941 · S/N 53 N37217Weisberg Perry A · Minot, NDBuilt 1941 · S/N 60 N37219Omiecinski Walter F · Peninsula, OHBuilt 1941 · S/N 62 N37230Wrong Brothers Aviation LLC · Webster, MNS/N 73 N37231Wrong Brothers Aviation LLC · Webster, MNS/N 74 N37232Morris Todd W · Cozad, NEBuilt 1941 · S/N 75 N37235Chapman Gregory · Antioch, ILBuilt 1941 · S/N 78 N37239Westlake Chad C · Columbus, OHS/N 82 N37241Wendt Dan L · Olean, MOBuilt 1941 · S/N 84 N37248Larsen Kevin L · Firth, IDBuilt 1941 · S/N 91 N37262Phoenix Rocky D · Winnemucca, NVBuilt 1941 · S/N 105 N37266Lost Aviators Of Pearl Harbor LLC · Bellingham, WABuilt 1941 · S/N 109 N37271Jones Alva L · Craig, COBuilt 1941 · S/N 114 N37280Registered aircraftBuilt 1941 · S/N 123 N37286Brothers Mark R · Pinckney, MIBuilt 1941 · S/N 129 N37291Allen John B Jr · Sutter Creek, CABuilt 1941 · S/N 134 N37294Ladegard Paul E · Wasilla, AKBuilt 1941 · S/N 137 N37296Ballard Rickey G · Buckeye, AZBuilt 1941 · S/N 139 N37299Armstrong Kevin L · Corvallis, ORBuilt 1941 · S/N 142 N37301Riedener Chris J · Beaverton, ORBuilt 1941 · S/N 144 N37303Borror Tim A · Wshngtn Ct Hs, OHBuilt 1941 · S/N 146 N37304Bays Stuart B · Tyler, TXBuilt 1941 · S/N 147 N37309Pietsch Kent D · Burlington, NDBuilt 1941 · S/N 152 N37317Wildman Jeanne L · Independence, ORBuilt 1941 · S/N 160 N37327Stover Andrew C · Fullerton, CAS/N 170 N37330Westlake Chad · Columbus, OHBuilt 1941 · S/N 173 N37335Love Kenneth Jay · CombaningBuilt 1941 · S/N 178 N37340Horrell Charles G · Lyme, NHBuilt 1941 · S/N 183 N37357Mann Thomas A · Ford, WABuilt 1941 · S/N 200 N37369Northway Mathew W · Eugene, ORBuilt 1941 · S/N 212 N37370Wellenstein Nic J · Big Sky, MTBuilt 1941 · S/N 213 N37373Morris Justin · Cozad, NEBuilt 1941 · S/N 216 N37381Taylor Brent · Ottumwa, IABuilt 1941 · S/N 224 N37385Dawson Steven L · East Troy, WIBuilt 1941 · S/N 228 N37386Mann Thomas A · Ford, WABuilt 1941 · S/N 229 N37397Doyle James J · Hillsborough, NJBuilt 1942 · S/N 311 N37401Nevergall Michael · Brighton, COBuilt 1942 · S/N 244 N37403Pietsch Kent D · Burlington, NDBuilt 1942 · S/N 246 N37406Lander David W · Gilroy, CABuilt 1942 · S/N 249 N37407Bradford Murvin L · Hensley, ARS/N 250

Back to Interstate S-1A