Skip to content

Registered aircraft · 59

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

N1525DHeintz John F · Los Angeles, CABuilt 1952 · S/N 7747 N1538DAdams Richard J · Mesa, AZS/N 7760 N1570DBoswell Kurt R · Renton, WABuilt 1952 · S/N 7792 N1574DWilliams Marc A · Ridgecrest, CABuilt 1952 · S/N 7796 N16203Woodburn Thomas J · Glen Allen, VABuilt 1936 · S/N 4422 N17725Perkins Dimmitt J · Sheridan, ARBuilt 1937 · S/N 4584 N17742Nurge Richard J · Gilroy, CABuilt 1937 · S/N 4580 N18555Wiltz Paul E · Opelousas, LABuilt 1937 · S/N 157 N18561Ladd Daniel T · Loudon, NHBuilt 1938 · S/N 210 N18577Jacobson Curtis · Prineville, ORBuilt 1937 · S/N 195 N18781Morrison Mark · Bloomingdale, ILBuilt 1938 · S/N 204 N19361Branam James G · Middletown, OHBuilt 1938 · S/N 5102 N19385Eisenbath Kevin R · Fort Myers, FLBuilt 1938 · S/N 5117 N19473See David M · Denton, TXBuilt 1938 · S/N 245 N195DCGrones John G · Port Orange, FLBuilt 1951 · S/N 7734 N195DSAbq421 LLC · Los Ranchos, NMBuilt 1948 · S/N 7272 N195DTAlldredge Aviation · Auburn, WABuilt 1948 · S/N 7287 N195GSalter Kevin L · Garden City, KSBuilt 1947 · S/N 7047 N195QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7743 N195WLRegistration Pending · Coldwater, MIRegistration pendingS/N 7620 N195YYoung Kenneth D · La Verne, CABuilt 1951 · S/N 7629 N20798Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1939 · S/N 333 N20908Registration Pending · Caldwell, IDRegistration pendingBuilt 1939 · S/N 5067 N20953Experimental Aircraft Association Inc · Oshkosh, WIBuilt 1939 · S/N 5080 N2213Kahl William E · Foxburg, PABuilt 1936 · S/N 4441 N2272Riffle George W · Auburn, WABuilt 1938 · S/N 5001 N2312Qualitair LLC Trustee · MichelstadtBuilt 1938 · S/N 5063 N238YWright Jeffrey C · Canby, ORBuilt 1939 · S/N 272 N252BBJagmin Michael · Chicago, ILBuilt 1950 · S/N 7571 N256CJ & N Endeavors LLC · Wilmington, DEBuilt 2005 · S/N 12066JC027A N2626Fletcher Flying Service 419 LLC · Labelle, FLS/N 283 N2663Nc2663 Inc · Wilmington, DEBuilt 1939 · S/N 330 N285DLeaders Bob · Clear Lake, MNS/N 256 N3023BWelch Thomas R · Modesto, CABuilt 1952 · S/N 7906 N3032BHendrix Todd M · Bakersfield, CABuilt 1952 · S/N 7915 N3170GHolbrook Maslen · Caldwell, IDS/N 7590 N41663Dow Jeff · Port Hadlock, WAS/N 196 N4319VBarron Jon M · Perry, MOBuilt 1948 · S/N 7226 N4335VMartin Edward I · Trinity Center, CABuilt 1948 · S/N 7241 N4344VBarron Aviation LLC · Perry, MOBuilt 1948 · S/N 7250 N4367NMajerle Joseph III · Anchorage, AKBuilt 1947 · S/N 7039 N4391NRoy Rodney E · Grand Marais, MNBuilt 1947 · S/N 7030 N46296L G Merriam Equipment LLC · Chowchilla, CABuilt 1939 · S/N 332 N49301Blue Sky Adventures LLC · Hanover, PAS/N 250 N50650Horstman Edward B · Bigfork, MTBuilt 1937 · S/N 143 N59700Auer Dale A · Harrisburg, PABuilt 1942 · S/N 413 N66206Venaleck John T Sr · Concord Township, OHS/N 5073 N6896CCurry Caleb C · Edmond, OKS/N 7340 N87AZBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1936 · S/N 178 N8860NBroussard Lewis A Jr · Morse, LABuilt 1948 · S/N 7232

Back to Jacobs L6