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.
N255NABobcat Aviation LLC · South Hutchinson, KSN26KWWeeks Kermit A · Polk City, FLN27TNTransnorthern LLC · Anchorage, AKN2800GAircraft Guaranty Corp Trustee · Oklahoma City, OKN280CMHigar Air Service Inc · Redlands, CAN284MSFour Aces Aviations LLC · Greensboro, GAN289RDL&P Of Mke LLC · Milwaukee, WIN28CTErickson David A · Whitehall, WIN28CUKeenan Joseph F · Pleasanton, CAN28CVKamikaze Air LLC · Lake Mary, FLN28EVEvergreen Aviation & Space Museum & The Captain · Mcminnville, ORN28FUBagdasarian Walter DBA · El Cajon, CAN28LCCollins Roger · Woodinville, WAN28TYRegistration Pending · Spring Lake, MIRegistration pendingN28XCBailey Raymond J · Mansfield, TXN28XTEast Iowa Air Inc · Bennett, IAN28XXPoma Luis Eduardo · Pinecrest, FLN28YFCollins Roger D · Woodinville, WAN28ZZMosley Clint · Talent, ORN300JHFly Jive Fly LLC · Lake Wales, FLN306WWInternational Air Services Inc Trustee · Carson City, NVN312ASNorthern Aviation LLC · Palmer, AKN313WBQualitair LLC Trustee · MichelstadtN31428Eastern Stearman Inc Trustee · Leesburg, VAN31431Carlton John B · Lenoir, NCN3193GSomers Charles Michael · Hillsboro, ORN31957Marine Aviation Museum Inc · Wilmington, DEN31NANorthern Flight LLC · Bismarck, NDN321LNord Aviation Inc · Santa Teresa, NMN32257Melton Ricky N · Luttrell, TNN34NMidway Dauntless LLC · Bellevue, WAN351NASale Reported · Elaine, ARSale reportedN36NAComanche Warbirds Inc · Houston, TXN3703GMilitary Aircraft Restoration Corp · Costa Mesa, CAN372CPalm Springs Air Museum Inc · Palm Springs, CAN379DMBirrell Christopher J · Ottumwa, IAN37AMCavanaugh Flight Museum · Addison, TXN390THLiberty Foundation Inc · Miami, FLN392WBuno 138314 LLC · San Diego, CAN393WPlanes Of Fame Air Museum · Chino, CAN3HUTuthill James G · Burr Ridge, ILN4025PBob Ruhe Ag Service LLC · Leipsic, OHN404DKKalember Duane D · Suttons Bay, MIN416CHunt Lynn C · Windsor, CAN4225FAviation Business Corp · Saint Louis, MON43155Tactical Flight Ops LLC · Camarillo, CAN440Weeks Kermit A · Polk City, FLN44GHFlight Data Inc · Roanoke, TXN46273N46273 LLC · Alpine, WYN462NATopaero Aviation Consulting LLC · Coronado, CA
Back to Wright R-1820 series