Skip to content

Registered aircraft · 218

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

N10053Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1943 · S/N 75-4986 N10584Manley John A III · Remus, MIS/N 75-5918 N1067NRuby Begonia LLC · Whitefish, MTS/N 75-5313 N10883Rounds Nathan A · Zebulon, GABuilt 1931 · S/N 8059 N10886Hammond James F · Yellow Springs, OHBuilt 1931 · S/N 8058 N10KPDexter Fred H · Live Oak, FLBuilt 1942 · S/N 755247 N11168Sharp Frank J · Orlando, FLBuilt 1931 · S/N 8022 N11170Weeks Kermit A · Polk City, FLBuilt 1931 · S/N 5023 N11178Leahy Thomas J · Lksid Marblhd, OHBuilt 1931 · S/N 4123 N111CNNelson Craig K · Golden, COBuilt 1942 · S/N 75-5962 N1177Kma LLC · New Port Richey, FLBuilt 1942 · S/N 75-5046 N12143Arkansas Air And Military Museum Inc · Fayetteville, ARBuilt 1931 · S/N 8201 N12164Glover William S · Mount Pleasant, TXBuilt 1931 · S/N 8102 N12165Airpower Museum Inc · Ottumwa, IABuilt 1931 · S/N 8074 N12817Museum Of Flight Foundation · Seattle, WABuilt 2010 · S/N 10 N1339Brandt Terry R · Hood River, ORBuilt 1929 · S/N 214 N13459Alsworth Glen R Sr · Port Alsworth, AKBuilt 1955 · S/N 8712 N1349MSmith Robert F · Fort Valley, GAS/N 75-8743 N1357NGibbs Robert I · Ravenswood, WVBuilt 1943 · S/N 75-5423 N1363VLil Dawg Aviation LLC · Wilmington, DES/N 75-8704 N13822Lake Clark Holdings LLC · Port Alsworth, AKBuilt 1933 · S/N 8774 N1390NOnstott Norman V · Mt Pleasant, MIBuilt 1955 · S/N 75-5505 N14101Weaver Clifford A · East Berlin, PABuilt 1943 · S/N 75-4402 N1423MPeters D R II · Laurel, MSS/N 75-8190 N14GCJr Stearman LLC · Fairfield, CABuilt 1941 · S/N 75-6503 N1517Rhinebeck Aerodrome Museum · Red Hook Ny, NYBuilt 1929 · S/N M-267 N16142Ballen Bradely · Sky Valley, CABuilt 1936 · S/N 9710 N16635Jeepers LLC · New York, NYBuilt 1967 · S/N 758780 N1707MPetair Inc · Wilmington, DEBuilt 1943 · S/N 75-8534 N17144Launder Brian Lloyd · Whittier, CABuilt 1937 · S/N 5213 N17195Card Robert H II · Kenedy, TXBuilt 1937 · S/N 5300 N1720BSmith George B · Lexington, KYS/N 75-6017 N17NBeta Fleet LLC · South Burlington, VTBuilt 1943 · S/N 75-3667 N18353Malaro Michael C Trustee · East Taunton, MABuilt 1941 · S/N 75-1912 N18407Riedl Mark C · Roanoke, TXBuilt 1937 · S/N 5313 N18408Calvin James L · Hicksville, OHBuilt 1937 · S/N 5315 N18423Stoecklein Edmund H · Stanwood, WABuilt 1937 · S/N 5321 N18442Simply Living LLC · Fort Myers, FLBuilt 1937 · S/N 5354 N1856MGeringer Alan DBA · Selma, CABuilt 1943 · S/N 75-4675 N1943SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1943 · S/N 77-463 N2073Cournoyer John J · Ellsinore, MOBuilt 1926 · S/N 7 N22DHotel Charlie LLC · Lewes, DES/N 75-2910 N2388Beliveau Richard A · Carlsbad, CABuilt 1943 · S/N 75-8077 N23KFPowelson Mark · Pataskala, OHBuilt 1943 · S/N 75-5509 N2533Martin Aviation Inc · Santa Ana, CABuilt 1944 · S/N 42-17698 N2538BOld Aeroplane Company LLC · Lake Suzy, FLS/N 47-360 N258YBowe Walter C Trustee · Sonoma, CABuilt 2012 · S/N LAA-362-14892 N265RMMccullough Carol Charlene Trustee · Tulsa, OKBuilt 1943 · S/N 75-4524 N28700Tulsa Air And Space Museum Inc · Tulsa, OKS/N 47 N2JSManna Timothy J · BiggleswadeNon-citizen corporation, flight hours not reportedBuilt 1996 · S/N 75-1349JS

Back to Lycoming R680