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.

N56376Brown Christopher · Healdsburg, CAS/N 76-378 N60190Busha James P · Oshkosh, WIBuilt 1945 · S/N 76-91 N603BDChurchill Scott · Le Sueur, MNBuilt 1965 · S/N 3245 N6055CPlanes Of Fame Air Museum · Chino, CABuilt 1945 · S/N 45-34950 N605JCHustler Aviation LLC · Huntsville, TXBuilt 1969 · S/N 28R-31088 N62451Bryson Robert D · Bandon, ORBuilt 1942 · S/N 4214854 N62471Willis Dewitt W · Bedford, INS/N 76-392 N62AFowler Larry K · Harrison, ARBuilt 1951 · S/N NAV-4-2347B N6370LBergstrom Aircraft Inc · Pasco, WABuilt 1953 · S/N 91266 N6431CBarclay William G · Peyton, COBuilt 1944 · S/N 3424 N6560NVano Sally L · Carlos, MNBuilt 1950 · S/N 2013 N6578NOxford Sherman D · Flower Mound, TXBuilt 1950 · S/N 2031 N6582NPenney John C Trustee · Evergreen, COBuilt 1950 · S/N 2035 N68028Pattie Donald D · Zephyrhills, FLBuilt 1954 · S/N C1-0767 N68MHScott Jerry E · Houston, TXS/N 1039 N69892D & S Ventures Ltd LLC · Haiku, HIBuilt 1943 · S/N 2046 N7036Mcdonald Kenneth G · Vancouver, WABuilt 1973 · S/N KM-001 N723ENichols Charles F Trustee · Baldwin Park, CABuilt 1943 · S/N 76-189 N72573Hunter Tim W · Meadville, PABuilt 1954 · S/N 18-2772 N74466Weakley Byron D · Chapmansboro, TNBuilt 1948 · S/N 1579 N74487Pierce David J · Alpine, UTS/N 1600 N7491Vanwagnen Brian J · Jackson, MIBuilt 1942 · S/N 1240 N762CHutson Casey L · Virginia Beach, VABuilt 1947 · S/N 108-3762 N77HLBarton Bruce N · White Hills, AZS/N 1084 N8495KWeis Allen R · Chancellor, SDBuilt 1947 · S/N 108-1495 N853BBSaile Daniel K · Skiatook, OKBuilt 1958 · S/N 1147 N876DPassmore Stephen B · Lacrosse, WABuilt 1947 · S/N 108-2876 N9016HWorlds Greatest Aircraft Collection Inc · Polk City, FLBuilt 1957 · S/N 40-142 N9096TBassett Donald · Ashford, ALBuilt 1978 · S/N CCI-78-8 N91TVHamilton Verlon D · Roanoke, TXBuilt 1991 · S/N 76262 N9315HAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1949 · S/N 4215060 N93456Ward Mark P · Wasilla, AKBuilt 1958 · S/N 1062 N9503KStubblefield Matthew K · West Yellowstone, MTBuilt 1947 · S/N 108-2503 N9551KIowa Gen Svc Inc · Des Moines, IARegistration revokedBuilt 1947 · S/N 108-2551 N961JWAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1986 · S/N 44-88001 N97254Wightman John F · Sierra Madre, CABuilt 1946 · S/N 108-254 N9756KBradley Christopher · Juneau, AKS/N 108-2756

Back to Lycoming 0-435