Skip to content

Registered aircraft · 28

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

N2131CJoyce Edward R · Jefferson, OHBuilt 1940 · S/N 7723 N26200Ulmer Clarence G · Aladdin, WYBuilt 1940 · S/N 7501 N26219Ekin William A · Port Alsworth, AKBuilt 1940 · S/N 7505 N26223Park Derek B · Lyons, GABuilt 1940 · S/N 7510 N26246Pederson William K · Hillsboro, ORBuilt 1940 · S/N 7533 N26249Patrick Ronald A · Louisville, KYBuilt 1955 · S/N 7535 N26265Rogers B L · Martinsburg, WVBuilt 1940 · S/N 7552 N26275Bresser Jason R R · Soldotna, AKS/N 7559 N26279Dorris Terry E · Greenbrier, TNBuilt 1940 · S/N 7560 N26281Houghton Andrew P · Cypress, TXBuilt 1940 · S/N 7567 N26284Rupke Curtis · Winterville, NCS/N 7570 N26285Stinson 10 LLC · Owosso, MIBuilt 1940 · S/N 7576 N26290Black Stephen L · Urbandale, IABuilt 1940 · S/N 7575 N26295Mott William R · Beach Lake, PABuilt 1940 · S/N 7582 N26409Frick Gary A Trustee · Marion, INS/N 7600 N26419Blackwater Aviation LLC · Holt, FLBuilt 1940 · S/N 7610 N26439Warren John P · White Lake, MIBuilt 1940 · S/N 7617 N26441Historical Aircraft Squadron Inc · Carroll, OHS/N 7635 N26448Reid David · Houston, TXBuilt 1940 · S/N 7671 N26449Ritenour John · Knoxville, TNBuilt 1940 · S/N 7639 N27708Wightman Randy A · Owosso, MIBuilt 1940 · S/N 7643 N27710Airpower Museum Inc · Ottumwa, IABuilt 1940 · S/N 7655 N27732Shadwick Clarence R · Tunnel Hill, GAS/N 7670 N27740California Antique Aircraft Museum · San Martin, CABuilt 1940 · S/N 7690 N27757Davey Kenneth E · Lake Crystal, MNBuilt 1940 · S/N 7696 N27776Bauer Mark A · Palmer, AKS/N 7720 N31504Gendron Matthew · Port Orange, FLS/N 7749 N31507Hackenburg Jess P II · Montoursville, PABuilt 1940 · S/N 7727

Back to Stinson 10