Skip to content

Kinner B5 series

Registered aircraft · 75

Aircraft with this engine 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 engine_model_code IN ('37501')
  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 engine_model_code IN ('37501')
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.

N666JRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1941 · S/N 350 N684MNichols Charles F Trustee · Baldwin Park, CABuilt 1930 · S/N 234 N70CJHistoric Aircraft Preservation Society Inc · Midlothian, TXBuilt 1931 · S/N 805 N716VRouth Gary Lee · Lebanon, TNBuilt 1930 · S/N 311 N7188Coussens John P · Boise, IDBuilt 1942 · S/N 398 N726NGolden Age Air Museum · Bethel, PABuilt 1931 · S/N 4037 N727WStrine Russel A · Readingk, PABuilt 1934 · S/N 138 N751VHarris Mark · Rockford, ILBuilt 1932 · S/N 411 N758YSchulz Michael L · Norfolk, NEBuilt 1930 · S/N 1092 N765NJenkins George Merritt · Wayne, PABuilt 1932 · S/N CK4033 N769YCst Air LLC · Walworth, WIBuilt 1930 · S/N 2058-33 N774VToliver Robert E · Waco, TXBuilt 1930 · S/N 355 N776VAdkins Clint R · Corvallis, MTS/N 380 N797HLiimatainen William J · Monroe, WIS/N 6K19 N850WRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1931 · S/N 4012 N864VKuehl Alison L · Mount Pleasant, TXBuilt 1930 · S/N 3265 N86VLiimatainen William J · Monroe, WIBuilt 1931 · S/N 404 N8742Wehman Ernest A Jr · Summerville, SCBuilt 1939 · S/N 491 N9056LHempstead Plains Aviation · Garden City, NYBuilt 2000 · S/N 01 N939VWillis William P Trustee · New Palestine, INBuilt 1931 · S/N 503 N9427HKorta Stephen E · Poplar Grove, ILBuilt 1963 · S/N 539 N9433Godbehere John S · Ochlocknee, GAS/N 81 N95VScheffler Mark J · Burt, NYS/N 4024 N980MNc980m LLC · Hampton, NJBuilt 1931 · S/N CK4035 N99754Beinhauer Richard G · Naperville, ILBuilt 1931 · S/N 4006

Back to Kinner B5 series