Skip to content

Registered aircraft · 87

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

N108ABOlree Richard N Jr · Hillman, MIBuilt 1948 · S/N 108-4171 N10CLDuffy James R · Boise, IDBuilt 1947 · S/N 108-2587 N1129NHirzel William J · Walbridge, OHS/N 3576 N1156VAmerican Airpower Heritage Flg Musm · Dallas, TXBuilt 1943 · S/N 60507 N122VTGordon William T · Evergreen, COBuilt 1976 · S/N 1046 N1252Iowa Military Aviation Heritage Museum · Ankeny, IABuilt 1942 · S/N 42-98196 N1421HNelson Chester C · Little Falls, MNBuilt 1950 · S/N 15AC-482 N147WBTriple Sss Aviation Inc · Muskegon, MIBuilt 1963 · S/N 2982 N14863Asher Gerald W · N Richland Hills, TXS/N 7666 N159MKDanford Michael S · Chickamauga, GAS/N MK-2 N198RBOflanagan Clancy H · Chowchilla, CABuilt 1942 · S/N 4298633 N22422American Airpower Heritage Flying Museum · Dallas, TXS/N 44-17191A N2243MHesse Stephen R · Anaheim, CAS/N 108-4127 N2280Grimm Lawrence S · Washington, PABuilt 1968 · S/N 10 N2462Registration Pending · Valdosta, GARegistration pendingBuilt 1975 · S/N 1 N2581BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1945 · S/N 120473 N2602Plantation Gin · Parker, AZBuilt 1970 · S/N 1 N28908Slikker Flying Service Inc · Buttonwillow, CABuilt 1962 · S/N 1332 N319AKKoski R Alan · Lincolnvl Ctr, MEBuilt 1996 · S/N 319 N31FGCoastal Helicopters Inc · Panama City, FLBuilt 1968 · S/N 3834 N3273LFolger Peter Joseph · Rockwood, TNS/N A35796 N332CMarks William D · Highland, MIBuilt 1948 · S/N 108-3332 N333CLJaggers Aviation LLC · Tupelo, MSBuilt 1973 · S/N M1 N3706CGustafson Gail M · White Hall, MDS/N 3861 N3787CArmstrong Michael K · Spokane, WAS/N 04002 N380BPenn-Tex Helicopters Inc · New Iberia, LAS/N MHTC-7 N3892August Aero LLC · Kalispell, MTBuilt 1978 · S/N 365 N40020Madden Russell · Graford, TXBuilt 1947 · S/N 76-3547 N402SBejvan David E · Milwaukee, WIS/N 1980 JFU N403JHRobinson Richard M · Dallesport, WABuilt 1990 · S/N SH1 N407CJames David R · Wayne, MIBuilt 1947 · S/N 108-2910 N40QWeiland Keith E · Chandler, AZBuilt 1946 · S/N 4611 N433WKingdom Air Corps · Sutton, AKBuilt 1953 · S/N 25962 N452WBDemark Aviation Inc · Wilmington, DES/N 76-3462 N4557DWoodhead Harold Kenneth Jr Trustee · Tulsa, OKBuilt 1979 · S/N AA5B1228 N458Koenig Robin A · Waunakee, WIBuilt 1975 · S/N 358 N4584Inzana Anthony F II · Hughson, CABuilt 1944 · S/N 42-99497 N46JBSchreiber Beck Cynthia K · Wahpeton, NDBuilt 1946 · S/N 76-269 N47077Knutson Flying Service Inc · Tioga, NDBuilt 1957 · S/N 947 N48083Texas Air Museum · Slaton, TXS/N 42-98801 N49324Vfr Ltd · Wilmington, DEBuilt 1943 · S/N 76-530 N501CHill Chad M · Makinen, MNBuilt 1947 · S/N 108-3501 N512ABurns Daryl R · Walker, IABuilt 1955 · S/N 2065 N519ALester John M · Okanogan, WABuilt 1950 · S/N 2072 N520ALentz Blaine D · Laramie, WYBuilt 1951 · S/N 2073 N536AScgi Inc · Griffin, GAS/N 2089 N538APontious Alfred A · Mojave, CABuilt 1951 · S/N 2091 N543ATsi Holdco Inc · Virginia Beach, VAS/N 6 N54921Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 76-366 N55ERCavanaugh Flight Museum · Denison, TXBuilt 1968 · S/N 67-17098

Back to Lycoming 0-435