Wright R-1820 series
Registered aircraft · 185
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 ('67020')
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 ('67020')
ORDER BY n_numberRun 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.
N80269Berry Jeffrey M · Palmetto Bay, FLN8039STrojan Phlyers Inc · Carrollton, TXN8114TValiant Air Command Inc · Titusville, FLN815SHZeus Flight LLC · Ketchum, IDN82GAAmerican Airpower Heritage Fly Museu · Dallas, TXN8331RWarbirds 1 LLC · Chattanooga, TNN83525Worlds Greatest Aircraft Collection Inc · Polk City, FLN83AWCem Aero LLC · Helena, MTN840Experimental Aircraft Association Inc · Oshkosh, WIN85303Duckbutt LLC · Castle Rock, CON862THHeligroup Waco LLC · Howell, MIN86572Wpp Nautical LLC · Helena, MTN866HAScott Edward · El Paso, TXN868KGAmphibian Aerospace Industries Inc · Leesburg, VAN87745Douglas 87745 LLC · Fort Worth, TXN887NCornett Jeffrey J · Sheboygan Falls, WIN888ACRegistered aircraftN88AWGorman Sean · Superior, CON89AWEuroaviation Inc Trustee · KematenN9019NHildebrandt Ken M · Bethune, CON9025YAg Air Inc · Sikeston, MON9039ZReed Steven W · San Marcos, TXN909WJSugarland Express Inc Trustee · Wilmington, DEN91AWTrojan Flight Operations LLC · Marion, INN9323ZAmerican Airpower Heritage Fly Museu · Dallas, TXN93RWN93rw LLC · Granite Falls, MNN9563ZMartin Aviation Inc · Santa Ana, CAN96334Rassawek Ventures Inc · Rockville, VAN9796NFourrier Foundation Inc · Dallas, TXN98TPTrousdale Aviation LLC · Wilmington, DEN990DBJackson Stacey B · Greer, SCN99153Doyle Duane S · Castro Valley, CAN99160Tsi Holdco Inc · Virginia Beach, VAN9924CRichter Aviation Inc · Maxwell, CAN99TPAmphibian Aerospace Industries Defense Inc · Leesburg, VA
Back to Wright R-1820 series