Skip to content

Registered aircraft · 15

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

N10547Alfred And Lois Kelch Aviation Museum Inc · Brodhead, WIBuilt 1935 · S/N 283 N11785Revoir Richard E · Hastings, NYBuilt 1935 · S/N 320 N12627Brandt Terry R · Hood River, ORBuilt 1931 · S/N 32 N12628Shannon Air Museum LLC · Fredericksburg, VABuilt 1932 · S/N 33 N13146Dougherty Paul D Jr · Bethel, PABuilt 1932 · S/N 54 N13179Poplar Grove Aviation Education Assoc Inc · Poplar Grove, ILBuilt 1933 · S/N 60 N14373Middlebrook Reece · Penn Yan, NYS/N 117 N15009Stewart Mark W · Arnold, MDBuilt 1935 · S/N 174 N15083Mckinley Scott E · Spokane Valley, WAS/N 222 N15333Saint Stephen F · Dunnellon, FLBuilt 1935 · S/N 251 N15356Command Aire LLC · Sitka, AKBuilt 1935 · S/N 266 N15676Cournoyer John J · Ellsinore, MOBuilt 1935 · S/N 341 N2122Hofstra Joseph · Boise, IDS/N 84 N2414Martinez Anthony III · Great Bend, KSS/N 64 N42319Martinez Anthony · Great Bend, KSBuilt 1934 · S/N 303

Back to Piper E-2