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.
N47201Pond Warbirds LLC · Reno, NVN475AMPacific Coast Air Museum · Santa Rosa, CAN4971XPrecision Ag Air LLC · Pendleton, INN504Vi 1 LLC · Brewster, WAN504DHVan Surdam John R · Seneca, SCN52424Cavanaugh Flight Museum · Addison, TXN5254LP51 Mustang LLC · Beaverton, ORN528TCSandpiper Aviation LLC · Carson City, NVN5421XHaley Flying Service Inc · Tracy, CAN5440WRegional Air Inc · Lawton, OKN5443UTrojan Phlyers Inc · Midlothian, TXN548NABga Viation Inc · Bennettsville, SCN5832XEngler M Eric · Cass City, MIN587MBTm Aero Marine Inc · North Miami, FLN58918P51 Mustang LLC · Beaverton, ORN58HFVi 1 LLC · Brewster, WAN58KKVi 1 LLC · Brewster, WAN5HPTexas Wildcat LLC · Dover, DEN5SFComanche Warbirds Inc · Houston, TXN6193NTre Aviation Corp · Wilmington, DEN632NARivette Timothy · Beach City, TXN63850Glover William Scott · Mount Pleasant, TXN63NAUrban Scott J · Richland, WAN64606Classic Rotors Museum · Ramona, CAN648LWJurgensen Howard F · Ephrata, WAN649DFThree Generations Holding LLC · Augusta, GAN6535KJones Aviation Inc · Biggs, CAN661NAValkyrieaero LLC · Idaho Springs, CON662WWSea Horse Sportfishing LLC · Clinton, NCN670AMPlanes Of Fame Air Museum · Chino, CAN68803Quantum Leasing LLC · Scottsdale, AZN70133Deeside Trading LLC · Sparks, NVN7025JSky West Aviation Inc Trustee · Albuquerque, NMN7025NBussted LLC · Wilmington, DEN703SCVi 1 LLC · Brewster, WAN710VCCactus Air Force LLC · Dayton, NVN71456Lauridsen Hans O · Scottsdale, AZFirst renewal noticeN7171MPond Warbirds LLC · Reno, NVN736MAGarrison William E Jr · Nickerson, KSN745WLund Investments LLC · Newport Beach, CAN746SHMasone Joseph A · Tucson, AZN752WWHeritage Of Eagles Air Museum · Firebaugh, CAN75947Rodney William Debaun Family Limited Partnership · Midlothian, TXN766NAWilson Philip R · Irondale, OHN76TPCommercial Flight Services Inc · West Chester, PAN778SRChampaign Aviation Museum · Urbana, OHN78378Barton Aviation LLC · San Antonio, TXN7927Adventures Albatross Inc · Dover, DEN7936CVi 1 LLC · Brewster, WAN8009GBoudreaux James S · Pelham, AL
Back to Wright R-1820 series