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.

N1025Kevin Eldridge · Tamarack, IDBuilt 1955 · S/N 112 N1043Eldridge Kevin · Donnelly, IDBuilt 1936 · S/N 114 N10721Antique Preservation Association Of Greenfield · Greenfield, IABuilt 1933 · S/N 401 N10730Lyons James P · Lake Suzy, FLBuilt 1931 · S/N 5W92 N110YRoberts David C · Scottsdale, AZBuilt 1930 · S/N 3298 N11202Johnson Daniel L · Westerville, OHBuilt 1930 · S/N 3389 N11210Senger Bruce D · Mount Solon, VABuilt 1930 · S/N 3393 N11237Dekle John B · Thomasville, GAS/N 3439 N11245Khalid Rauf J · Indianapolis, INBuilt 1931 · S/N 3405 N11256Bennett Robert M · Felton, DEBuilt 1931 · S/N 3460 N11259Leedom David A · Escondido, CABuilt 1931 · S/N 3462 N11264Cirone James R · Pampa, TXBuilt 1931 · S/N 3464 N11456Moloney Phillip M · Lexington, KYS/N 3471 N11713Zeiner Ty R · Marion, KSBuilt 1931 · S/N 12W-2038 N11725Womack Jeff M · Jackson, LABuilt 1934 · S/N D107 N11782Iler Elden · Van Nuys, CAS/N A707 N11795Gallarate Raymond D · Sonoma, CABuilt 1937 · S/N A-719 N12389Reid Robert W · Independence, ORBuilt 1934 · S/N D-108 N12444Mcclure Nancy Lee · North Liberty, IABuilt 1932 · S/N 3593 N1249Pietsch Warren A · Minot, NDBuilt 1937 · S/N 120 N12599Ala Doble Flying Collection · Livermore, CABuilt 1934 · S/N 254 N1286Pietsch Warren A · Minot, NDBuilt 1936 · S/N 106 N129YBowe Andrew J Jr · Poplar Grove, ILBuilt 1930 · S/N 3308 N13284Kowalik Wendy Trustee · San Antonio, TXBuilt 1934 · S/N 1702 N13576Hammond Clayton E · Marlborough, CTBuilt 1933 · S/N 702 N139YFuller Randy M · Mooresville, NCS/N 3313 N14339Grangruth Rory Allen · Wadena, MNBuilt 1934 · S/N 916 N14397Hoag Andrew J · Naples, FLBuilt 1934 · S/N 2638 N14725Thompson Richard E · Orlando, FLBuilt 1934 · S/N 2647 N14727Haley Robert J · Livermore, CABuilt 1934 · S/N 2649 N14749Air Heritage Inc · Beaver Falls, PABuilt 1934 · S/N 2655 N14794Lloyd Howard R Jr · Fredericksburg, PAS/N 2666 N14799Dakota Territory Air Museum · Minot, NDBuilt 1935 · S/N 2671 N14GNAllred Jimmie B III · Skaneateles, NYBuilt 1939 · S/N 263 N15038Boyer James A · Lancaster, OHBuilt 1935 · S/N 2675 N15345Spurgeon James R · Pisgah Forest, NCBuilt 1935 · S/N 2688 N15462Warner Aric D · Rosamond, CAS/N 301 N15465Lyons James Patrick · Lake Suzy, FLS/N 304 N15606Colton Frank D · Canby, ORBuilt 1935 · S/N 2708 N15784Combat Air Museum Inc · Topeka, KSBuilt 1935 · S/N 1 N15921Little Air Dream LLC · Mooresville, NCS/N 2724 N16258Cassada Marvin V · Clemmons, NCBuilt 1936 · S/N 2015 N16406Hickle William H · Inyokern, CABuilt 1936 · S/N 325 N16820Jenkins James L · Lake Stevens, WABuilt 1936 · S/N 2830 N16823Esch Joseph W · Carson, WABuilt 1936 · S/N 2833 N16848Foster Kent R · Manhattan, KSBuilt 1937 · S/N 2847 N16897Gifford Gary W · Lighthouse Point, FLS/N 2966 N16900Bischoff Ray H III · Flower Mound, TXS/N 2969 N17051Runyan Sally · Vancouver, WABuilt 1936 · S/N 334 N17057Heuer Qumn K · Bemidji, MNS/N 345

Back to Warner SS40&50