Skip to content

Wright 975E&F-2&3

Registered aircraft · 39

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

N10751Delaware Valley Historical Aircraft Association · Horsham, PABuilt 1931 · S/N 162 N11609Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1931 · S/N B-27 N128MWLegacy Flight Museum · Rexburg, IDBuilt 1942 · S/N 6475 N13BTFlabob Airport LLC · Riverside, CABuilt 1942 · S/N 11453 N16878Dudley Denise M · Santa Margarita, CABuilt 1937 · S/N 4014 N19155Oliver Steve · Tucson, AZBuilt 1937 · S/N 160J N216WRegistration Pending · Ottumwa, IARegistration pendingBuilt 1930 · S/N 3002 N2678Carlsbad Raceway Corp · Hemet, CAS/N 2678 N280WOld Style Aircraft LLC · Ellsinore, MOBuilt 1932 · S/N A-3596 N31KRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1930 · S/N 150 N3406Downing Eric D · Saint Charles, MOBuilt 1940 · S/N 64-2144 N35EQualitair LLC Trustee · MichelstadtBuilt 1937 · S/N D-17R-167 N3955BN3955b Corp Trustee · Wilmington, DEBuilt 1941 · S/N 75-5473 N411NBowe Walter C Trustee · Sonoma, CABuilt 1929 · S/N 6B2024 N436WStix Albert I III · St Louis, MOBuilt 1931 · S/N 15C-2001 N450HSLane Bill R · Azle, TXBuilt 1942 · S/N 75-3876 N4570NCroutch Marvin L · Encino, CABuilt 1942 · S/N 75-5383 N4611NWennersten Donald A · Ann Arbor, MIBuilt 1937 · S/N 5451 N4808VVintage Aviation LLC · Port Saint Lucie, FLS/N 75-5324 N500GBowe Walter C Trustee · Sonoma, CABuilt 1938 · S/N A22-1 N60009Doane Dale A · Moreland, GABuilt 1940 · S/N 75-170 N60387Pederson William K · Hillsboro, ORBuilt 1943 · S/N 744 N61931Trinkle Mark · Kingsburg, CAS/N 75-2549 N65364Registration Pending · Fort Worth, TXRegistration pendingBuilt 1945 · S/N 791216 N65466Mcfall Robert Leroy Trustee · Topeka, KSBuilt 1942 · S/N 3192 N67086Colville Inc · Anchorage, AKBuilt 1943 · S/N 9597 N68955Presby Aire LLC · Berlin, NHBuilt 1942 · S/N 5414 N69013Atmospheric Vehicle & Spacecraft Flight Exploratio · Rancho Palos Verde, CABuilt 1941 · S/N 7767 N69060Lopes Tom E · Hughson, CAS/N 75-7527 N69158Gullwing Aviation Holdings LLC · Lewes, DEBuilt 1942 · S/N 7377 N69605American Airpower Heritage Fly Museu · Dallas, TXBuilt 1941 · S/N 1258 N69987Wings Of The North Inc · Eden Prairie, MNBuilt 1943 · S/N 9536 N75004Juniata Valley Rv · Mifflintown, PABuilt 1942 · S/N 6720 N8865Timeless Air Classics LLC · Kalispell, MTBuilt 1929 · S/N 986 N888UWeeks Kermit A · Polk City, FLBuilt 1941 · S/N 3707 N9038Galpin Henry M · Kalispell, MTBuilt 1928 · S/N 839 N906HOld Style Aircraft LLC · Ellsinore, MOBuilt 1929 · S/N A-103 N9084Pole Pass Airways LLC · Seattle, WABuilt 1929 · S/N 865 N991HGreatest Generation Naval Museum · Colorado Springs, COBuilt 1929 · S/N D-3

Back to Wright 975E&F-2&3