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.

N17086Pierce Charles M · Cheney, WABuilt 1937 · S/N 346 N17090Heuer Qumn K · Bemidji, MNBuilt 1937 · S/N 350 N17372Eaa Aviation Foundation Inc · Oshkosh, WIS/N 201 N17687Lerille Red · Lafayette, LABuilt 1941 · S/N D-128 N18035Heuer Quinn K · Bemidji, MNS/N 361 N18056Bowe Andrew J Jr · Poplar Grove, ILBuilt 1937 · S/N A-765 N18166Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 791 N18599Turner Steven G · Clearwater, KSBuilt 1938 · S/N 384 N18635Registered aircraftS/N 2608 N18684Walk Michael · Englewood, FLBuilt 1939 · S/N 201 N18794Budde Gregory L · Morgan Hill, CABuilt 1938 · S/N 401 N18797Engler William O · Filion, MIBuilt 1938 · S/N 405 N19100Pearlman Aircraft Co · Orlando, FLBuilt 1937 · S/N 2910 N19105Hawley Richard J · Moultonborough, NHBuilt 1937 · S/N 2970 N19107Smith Richard D · Williamstown, OHBuilt 1954 · S/N 2972 N19123Shannon Air Museum LLC · Fredericksburg, VAS/N 2983 N19139Mid Atlantic Air Museum · Reading, PABuilt 1937 · S/N 2987 N19146Eastern Stearman Inc Trustee · Leesburg, VABuilt 1937 · S/N 2994 N19164Malene John E · Cuyahoga Falls, OHS/N 2997 N19173American Aviation II LLC · Peyton, COBuilt 1937 · S/N 2958 N19177Lancaster Mark S · Ottumwa, IABuilt 1938 · S/N 3501 N19178Stuckle Eugene A · Davenport, WABuilt 1937 · S/N 3502 N19180Doyle Mary · Hampton, IABuilt 1938 · S/N 3503 N19182Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3505 N19457Twin Oaks Airpark Inc · Hillsboro, ORBuilt 1938 · S/N 410 N19458Hancock Glenn · Jackson, GABuilt 1938 · S/N 411 N19484Koelling William W · Great Bend, KSBuilt 1938 · S/N 454 N19489Port Townsend Aero Museum · Port Townsend, WABuilt 1938 · S/N 459 N1998JWilliams Jr David Russell · Bellevue, WABuilt 1941 · S/N 9 N19995Karlovich Brett A · San Diego, CABuilt 1940 · S/N 102 N20624Fulton Gordon D · Mackay, IDBuilt 1938 · S/N 3514 N20731Smith James E Trustee · Kalispell, MTBuilt 1937 · S/N 804 N20782Graham Mark L · Cashmere, WAS/N 470 N2088Mesmer Robert F · Grand Island, NYBuilt 1937 · S/N 2918 N20918Womack Cameron M · Jackson, LAS/N GW-27 N22036Miller David J · Fernandina Beach, FLBuilt 1940 · S/N W40-105 N237DFrost Barbara M Trustee · Le Sueur, MNBuilt 1941 · S/N 663 N23EWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 2926 N23VWomack Jeffrey · Jackson, LABuilt 1946 · S/N W46-134 N240HWingnut Inc · Wilmington, DEBuilt 1929 · S/N 108 N25183Smith Happy E · Rogersville, TNBuilt 1940 · S/N W40-107 N25323Zechini Marcus Kenneth · White Post, VAS/N W40-111 N25456Young Gregory · Spring, TXS/N 811 N25487Morris Thomas B · Imlay City, MIBuilt 1941 · S/N 582 N25547Calef Jere R Trustee · Mojave, CAS/N 824 N26453Daprato Michael A · Eureka, MOBuilt 1940 · S/N 6 N26460Www Enterprises LLC · Pella, IABuilt 1940 · S/N 13 N26469Barg Michael D · Honea Path, SCBuilt 1940 · S/N 22 N26475Mid Atlantic Air Museum · Reading, PABuilt 1940 · S/N 28 N26485Grangruth Rory A · Wadena, MNBuilt 1941 · S/N 38

Back to Warner SS40&50