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.

N10686Martell Summer · Port Townsend, WABuilt 1931 · S/N 103 N107MReid Robert W · Independence, ORBuilt 1930 · S/N 1011 N107YTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1930 · S/N 3277 N11203Harter Michael R · Greenfield, INBuilt 1930 · S/N 3399 N11260Swindle Don · Collinsville, TXBuilt 1931 · S/N 3409 N11267Willford George A · Waterville, OHBuilt 1931 · S/N 3446 N11466Command Aire LLC · Sitka, AKBuilt 1931 · S/N 3519 N1238VPhilbrick Rodney C · Bishop, CABuilt 1948 · S/N 512 N12453Brown Daniel A · Gettysburg, PABuilt 1932 · S/N 3603 N13700Williams David R Jr · Bellevue, WABuilt 1933 · S/N 40 N13776Jenkins George Merritt · Wayne, PABuilt 1934 · S/N 102 N14201Simply Living LLC · Fort Myers, FLBuilt 1934 · S/N 122 N14288Lunger Eric K · Mifflintown, PABuilt 1935 · S/N 166 N14927Excalibur Air Service LLC · Windham, NHS/N 148 N1499TAirborne Adventures Inc · Kirkville, NYBuilt 1930 · S/N 300 N16BRAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1940 · S/N 383 N174RSRicci Moretti Luigi U · Swarthmore, PABuilt 1936 · S/N 62 N209VBowe Walter C Trustee · Sonoma, CABuilt 1930 · S/N 1032 N211KBartel Christopher H DBA · Williamsburg, PABuilt 1960 · S/N 387 N220KMountain Air Inc · Quincy, CAS/N 419 N226HBaxter Clay J · Coburg, ORBuilt 1929 · S/N 94 N235VRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1930 · S/N 1042 N236VReid Daniel G · Klamath Falls, ORBuilt 1930 · S/N 1043 N24197Rhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1941 · S/N 303 N288HTexas Barnstorming Museum · Hallettsville, TXBuilt 1929 · S/N 121 N29090Reed Gretchen M · Madison, OHBuilt 1941 · S/N 100 N331KSchrock Clifford B · Portland, ORBuilt 1929 · S/N 45 N34VMair F N · Keller, TXBuilt 1929 · S/N 18 N39601Texas Air And Space Museum Inc · Amarillo, TXS/N 301 N39604Grangruth Rory A · Wadena, MNBuilt 1941 · S/N 289 N39612Maxwell Joel E · Garrett, INS/N 339 N39617Merritt Dan · Graham, WABuilt 1940 · S/N 610 N39623Kaser William A · Vero Beach, FLBuilt 1944 · S/N 646 N411KJones Donald T Jr · Barrigada, GUBuilt 1929 · S/N 134 N413KFowler Robert E · Houston, TXBuilt 1985 · S/N 136A N422WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1931 · S/N 16K-2004 N424KBartel Christopher H DBA · Williamsburg, PABuilt 1929 · S/N 147 N431KElliott John David · Bethesda, MDBuilt 1929 · S/N 154 N432KMcgill Phil · Huntsville, ALBuilt 1929 · S/N 155 N446KNelson Harold G · Pendleton, ORBuilt 1929 · S/N 169 N448KEnglund Ronald E · Springfield, ORBuilt 1929 · S/N 171 N4512Feroldi Jack R · Longwood, FLBuilt 1941 · S/N 285 N53YPort Townsend Aero Museum · Port Townsend, WABuilt 1932 · S/N 412 N606MPowell Larry C · Fresno, CABuilt 1929 · S/N 182 N608MTerman Jerry · Bodega Bay, CABuilt 1929 · S/N 184 N615SCatalano James J · Wilmington, NYBuilt 1940 · S/N 506 N618YKing David T · Red Hook, NYBuilt 1930 · S/N 3352 N619YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1930 · S/N 3364 N63VMid Atlantic Air Museum · Reading, PABuilt 1931 · S/N 402 N648YJ & J Aero · Chuckey, TNBuilt 1930 · S/N 3384

Back to Kinner B5 series