Skip to content

Kinner R5 series

Registered aircraft · 157

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

N10619Katzen Edmund · Westhampton, NYBuilt 1930 · S/N 206-45 N1267BWeeks Kermit A · Polk City, FLBuilt 1932 · S/N G-65 N12680Ranger Airfield Foundation · Ranger, TXBuilt 1932 · S/N G-67 N14963Bowe Walter C Trustee · Sonoma, CAS/N 228 N151YWestern Antique Aeroplane & Automobile Museum · Hood River, ORS/N 510 N15550Ruble Ronald · Port Saint Lucie, FLS/N 1579 N170PPt-22 Inc · Topeka, KSS/N 1566 N1799Qualitair LLC Trustee · MichelstadtBuilt 1942 · S/N 1799 N18926International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 1001 N1PBrookway Aviation LLC · Brookhaven, MSS/N 325 N2022Naca 130 LLC · Cameron Park, CABuilt 1941 · S/N 1054 N218KBLund Deborah A · Grand Blanc, MIBuilt 1990 · S/N 218 N22ALAmercian Airpower Heritage Fly Musm · Dallas, TXBuilt 1942 · S/N 1831 N22JKRoussopoulos Gary L · Santa Cruz, CABuilt 1942 · S/N 1697 N239Gertsen Ronald Hans · Glenwood, NJBuilt 1943 · S/N 1325 N26466Burwell Jeff S · Grand Island, NEBuilt 1940 · S/N 19 N26476Wheeler Jeffrey A · Elyria, OHBuilt 1941 · S/N 29 N26490Gutherie Deborah B Personal Representative · Worton, MDBuilt 1941 · S/N 43 N29375Waco Historical Society Aka · Troy, OHBuilt 1941 · S/N 6000 N2EREast Hampton Air LLC · Wainscott, NYBuilt 1941 · S/N 1645 N319JZAcv Group LLC · Mckinleyville, CABuilt 1942 · S/N 1823 N33GPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1942 · S/N 2078 N34307Trek Aviation LLC · Amsterdam, NYBuilt 1941 · S/N 51 N34310Freeman Heritage Collection LLC · Kingsbury, TXBuilt 1941 · S/N 53 N34317Grasshopper Aviation Inc · Geneseo, NYBuilt 1942 · S/N 61 N34321Griffin Terry M · Bridgeton, NJS/N 65 N34322Coughlin Brian T · Cazenovia, NYS/N 66 N34324Haldeman Enterprises LLC · Vancouver, WABuilt 1942 · S/N 69 N34325Gap Mountain Development LLC · Jaffrey, NHBuilt 1942 · S/N 70 N34331Wright Thomas L · Clyde, OHBuilt 1942 · S/N 76 N34332Hunt Tyson Bregistered · Saratoga Springs, NYS/N 77 N34334Arkawy Alan D · Fishkill, NYBuilt 1942 · S/N 79 N34336Warden Richard L · Canby, ORBuilt 1942 · S/N 81 N34341Jasper Ralph Lane · Diberville, MSBuilt 1943 · S/N 86 N34345Gomez Phil · Henniker, NHS/N 89 N34347Barg Michael D · Honea Path, SCBuilt 1943 · S/N 91 N34349Nebraska Antique Airplane Preservation Inc · Wynot, NEBuilt 1943 · S/N 93 N34350Vierhus Steven C · Fresno, CABuilt 1943 · S/N 94 N34351Platten Francis Douglas · Port Angeles, WABuilt 1943 · S/N 95 N34355Kropp Richard G · North Creek, NYBuilt 1943 · S/N 99 N34356Ingle Samuel C · Geneva, OHBuilt 1943 · S/N 101 N343SFMartin Stephen S · Huntington Station, NYBuilt 1940 · S/N 343 N34912Antique Preservation Association Of Greenfield · Greenfield, IABuilt 1941 · S/N 4 N38964Enk William A · Blue Springs, MOBuilt 1941 · S/N 1479 N39622Kew Ralph E · Chantilly, VAS/N 636 N39667Rezich James N · Winnebago, ILBuilt 1942 · S/N 667 N39672Peterson Thomas M · Lake In The Hills, ILBuilt 1942 · S/N 672 N41DJBragg Phill III · Windsor, NCBuilt 1941 · S/N 635 N435YGreat Lakes Aircraft LLC · Palmer Lake, COS/N 152 N440KMadden William L · Las Cruces, NMBuilt 1929 · S/N 163

Back to Kinner R5 series