Skip to content

Registered aircraft · 150

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

N26487Wade Karen H · Sulphur, LABuilt 1941 · S/N 40 N26489Schildberg Gregory M · Casey, IABuilt 1941 · S/N 42 N264NHall Charles L DBA · Manhattan, KSBuilt 1930 · S/N R-403 N272YPietsch Warren · Minot, NDBuilt 1941 · S/N 131 N275YLehner Christopher E · Battle Ground, WAS/N 101 N28521Carey Richard L · Hagerstown, INBuilt 1940 · S/N W40-135 N28636Natoli Nathaniel T · Rutland, VTBuilt 1940 · S/N W40-151 N28640Bormuth Alan R · Morganton, NCBuilt 1940 · S/N W40-160 N28648Lombardi Andrew J · Santa Paula, CAS/N W40-148 N28685Dienst Lon C · Poplar Grove, ILS/N W-40-168 N29010Gonzales Donald M · Columbia Station, OHBuilt 1940 · S/N W40-174 N34313Heckman Theodore K · Allegan, MIBuilt 1941 · S/N 57 N34318Jetblack Ventures LLC · Bakersfield, CABuilt 1942 · S/N 62 N34323Jones James R · Honea Path, SCBuilt 1942 · S/N 67 N34326West Larry L Trustee · Tumtum, WABuilt 1942 · S/N 71 N34327Hays Gary R · Chino Valley, AZS/N 72 N34335Shipp Donald E · Wyoming, MNBuilt 1942 · S/N 80 N34339Barg Michael D · Honea Path, SCBuilt 1942 · S/N 84 N34826Burklund Christopher L · Clearwater, FLBuilt 1941 · S/N 883 N410YLove Kenneth L · Ronda, NCFirst renewal noticeBuilt 1936 · S/N A742 N411WStarr Darrel N · Plymouth, MNS/N 12W2015 N413WSmith James E Trustee · Kalispell, MTBuilt 1931 · S/N 12W2017 N418WHendrickson Steve L · Lake Stevens, WAS/N 12W-2031 N420KBarr Myron · Spanaway, WAFirst renewal noticeBuilt 1929 · S/N 143 N434WZeiner Ty R · Marion, KSBuilt 1931 · S/N 12W-2002 N442KLiimatainen William J · Monroe, WIBuilt 1929 · S/N 165 N46207Caldwell Collection Inc · Oklahoma City, OKBuilt 1938 · S/N 211 N501WTaylor Benjamin L · Ottumwa, IAS/N 5W47 N532KRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1929 · S/N 115 N543WCoolbaugh Robert J · New Market, VABuilt 1930 · S/N 562 N546WLerille Red · Lafayette, LABuilt 1930 · S/N 5W95 N603YAyres Jayson L · Bettendorf, IABuilt 1930 · S/N 3316 N649MBarnstormer Aero LLC · Yorktown Heights, NYBuilt 1930 · S/N 233 N686YRare Aircraft Ltd · Faribault, MNS/N 3378 N6871Davis Trenten E · Brodhead, WIBuilt 1928 · S/N 1007 N766VShannon Air Museum LLC · Fredericksburg, VABuilt 1930 · S/N 347 N775WBowe Walter C Trustee · Sonoma, CABuilt 1930 · S/N 1 N8088Cilurso Michael F · Orefield, PAS/N W505 N830EThiel Roger N · Washington, DCBuilt 1938 · S/N 203 N848HBourgeois Shy Trustee · Santa Ynez, CABuilt 1929 · S/N 106 N854NBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1929 · S/N 127 N855VC2 Holdings 21 LLC · Chesapeake, VABuilt 1930 · S/N 3267 N859VSimply Living LLC · Fort Myers, FLBuilt 1930 · S/N 3271 N8616Price Ronald W · Shullsburg, WIBuilt 1929 · S/N 28 N8626Smith Peter C · Maplesville, ALS/N 39 N8627Augustyn Jan · Palatine, ILS/N 40 N86570Cournoyer John J · Ellsinore, MOBuilt 1935 · S/N D-122 N867HThun Karl J · Graham, WABuilt 1929 · S/N 107 N893KBrown Charles M · Sandpoint, IDBuilt 1930 · S/N 102 N9485Wilkens Daniel B · Fertile, MNS/N 1608

Back to Warner SS40&50