Skip to content

Franklin 4AC199D&E series

Registered aircraft · 89

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

N10158Bohannon Joseph P · Waller, TXBuilt 1960 · S/N K-1 N10939Eagles Mere Air Museum Foundation · Wayne, PABuilt 1931 · S/N 1118 N1624EStadel Jim D · Yuba City, CABuilt 1946 · S/N 7AC-5189 N18192Sondey Charles S · Stow, MABuilt 1941 · S/N A-821 N18195Sale Reported · Ardmore, OKSale reportedBuilt 1941 · S/N A-823 N21BJSeven M Enterprises · Kalispell, MTS/N 001 N23MEProkes William J · Gilbert, AZBuilt 2016 · S/N PAF3 N2662596000 Aircraft LLC · Waller, TXS/N 1967 N27714Blanchard Robert W · Elverta, CABuilt 1941 · S/N 7761 N27740California Antique Aircraft Museum · San Martin, CABuilt 1940 · S/N 7690 N27770Sutton Bradley V · Dallas, TXBuilt 1940 · S/N 7703 N287RBBurtch Russell K · Red Creek, NYBuilt 1991 · S/N 01 N31528Wheeler Kevin M Trustee · Comstock Park, MIBuilt 1941 · S/N 7794 N31540Scott William M · Spring Hill, FLBuilt 1941 · S/N 7789 N31541Texas Air Museum · Slaton, TXS/N 7790 N31560Sutton Bradley V · Dallas, TXBuilt 1944 · S/N 7809 N31572Bone Robert R · Fort Wayne, INS/N 7821 N31587Snavely Deborah B · Lake Placid, FLS/N 7836 N31598Coulson Michael D · Zanesville, OHBuilt 1941 · S/N 7847 N32203Cook Robert G · Rensselaer, NYBuilt 1941 · S/N 7852 N32208Wirt Daniel E · Kalispell, MTS/N 7857 N32218Sutton Matt · Pottsboro, TXBuilt 1941 · S/N 7867 N32222Hewgley William F · Sandy, ORBuilt 1941 · S/N 7871 N32260Kjeldgaard Jim K · Fremont, NEBuilt 1941 · S/N 7908 N32263Coulson Michael D · Zanesville, OHS/N 7911 N34610Arno David M · Grand Rapids, OHBuilt 1941 · S/N 8010 N34618Vintage Flying Club LLC · Ankeny, IABuilt 1941 · S/N 8018 N34619Graham Terrance A · Central Lake, MIBuilt 1941 · S/N 8019 N34635Alsworth Glen R Jr · Port Alsworth, AKBuilt 1941 · S/N 8035 N34643Buttermore Jan T · Riverside, CABuilt 1941 · S/N 7964 N34670Sutton Bradley V · Dallas, TXBuilt 1941 · S/N 7970 N34676Scott William M · Spring Hill, FLBuilt 1941 · S/N 7976 N34686Domeyer David K · Washougal, WAS/N 7986 N34688Grasso Vaughn L · Oak Hill, FLBuilt 1941 · S/N 7988 N34693Range Douglasg · Burrton, KSBuilt 1941 · S/N 7993 N34696Buck Travis W · Bozeman, MTBuilt 1941 · S/N 7996 N34697Snavely Debbie B · Lakeplacid, FLBuilt 1941 · S/N 7997 N34783M3x Hangar Rats LLC · Fairfield, OHBuilt 1941 · S/N 239 N34788Naca 130 LLC · Cameron Park, CABuilt 1941 · S/N 248 N34793Burley Joseph D · Fayetteville, GABuilt 1941 · S/N 246 N34797Kellner Darlene D · Drums, PABuilt 1941 · S/N 258 N34855Mccann Michael · Springfield, ORBuilt 1941 · S/N 265 N34864Champaign Aviation Museum · Urbana, OHBuilt 1941 · S/N 274 N34883Rezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1941 · S/N 290 N34895Redding Steven R · Skiatook, OKBuilt 1941 · S/N 302 N36702Registration Pending · Stanford, KYRegistration pendingBuilt 1941 · S/N 8102 N36709Neal Sean · Freehold, NYBuilt 1941 · S/N 8109 N36729O'Brion Nathan W · Kingsford, MIS/N 8129 N36750Johnson Bette Jo · Roseville, MNBuilt 1942 · S/N 8150 N36757Snavely Deborah B · Lake Placid, FLBuilt 1941 · S/N 8157

Back to Franklin 4AC199D&E series