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.

N37410Pietsch Kent D · Burlington, NDS/N 312 N37411Drolet Donald Wayne · Richardson, TXBuilt 1942 · S/N 254 N37412Alamo Liaison Group Inc · San Antonio, TXS/N 255 N37414Mock Jerry R · Winnemucca, NVBuilt 1942 · S/N 257 N37416Horrell Charles G · Lyme, NHBuilt 1942 · S/N 259 N37428Pietsch Kent D · Burlington, NDBuilt 1942 · S/N 273 N37432Lorenz John C · Edgewood, NMBuilt 1942 · S/N 277 N37435Magill Karen E · Edgemoor, SCBuilt 1942 · S/N 280 N37436Lander David W · Gilroy, CABuilt 1942 · S/N 281 N37438Merritt Daniel D · Graham, WABuilt 1942 · S/N 283 N37442Jj Aero LLC · Valley Center, KSBuilt 1942 · S/N 287 N37446Carpenter William R · Pocatello, IDBuilt 1942 · S/N 291 N37451Hawley Luther S · Saint Matthews, SCBuilt 1942 · S/N 296 N37452Wright Flight LLC · Medford, ORBuilt 1941 · S/N 297 N37453Parsons Lee E · Carrollton, OHBuilt 1942 · S/N 298 N903YThomas Stuart W · Coppell, TXBuilt 1941 · S/N 45

Back to Interstate S-1A