Skip to content

Franklin 4AC176B series

Registered aircraft · 125

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

N20414Clark James R · Rhome, TXBuilt 1938 · S/N 1102 N2154MTrumbull Thomas A · Leland, MIS/N 20940 N21583Batte Randall · Forest, MSBuilt 1938 · S/N 2436 N21661Bracewell Brent E · Zebulon, GABuilt 1938 · S/N 2549 N22246Griswold Dean A · Belvidere, ILBuilt 1939 · S/N 1193 N22714Johnson Curtis · Somers, NYBuilt 1938 · S/N 2688 N23209Mitchell Asher · Senoia, GABuilt 1939 · S/N 2985 N23345Faulkner Ronnie L · Royal, ARBuilt 1939 · S/N 3089 N2364KEngler William O · Filion, MIBuilt 1939 · S/N 3108 N25032Nelson Bruce · Lutz, FLBuilt 1939 · S/N 3611 N25816Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1939 · S/N 3768 N25986Douglas R Herlihy LLC · Goldendale, WABuilt 1939 · S/N 3934 N26173Beaver Perry L · Vienna, OHBuilt 1940 · S/N 4100 N26620Mcbride David J · Rochester, NYBuilt 1940 · S/N 1962 N26720Donner Paul A · Hurst, TXBuilt 1940 · S/N 4143 N268183n6 J3 LLC · Jamesburg, NJBuilt 1940 · S/N 4197 N26858Ferreira James M · Dixon, CAS/N 4225 N27079Mincer Robert C · Middlesex, NYBuilt 1940 · S/N 4342 N27132Osborne Brian D · Shoreline, WABuilt 1940 · S/N 4380 N27307Hammond James F · Yellow Springs, OHBuilt 1940 · S/N 1210T N27974Crossroads Farms Inc · Aurora, NES/N 4486 N29042Stevann Farms Ltd · De Witt, IABuilt 1940 · S/N 6013 N29576Kelley Michael L Trustee · Wellington, KSS/N 2419 N29756Gilliam Spencer R · Carthage, NCBuilt 1941 · S/N 2604 N29864Mori Edward A · Union City, CABuilt 1941 · S/N 2715 N30272James Rick L · Fort Wayne, INBuilt 1940 · S/N 4751 N30459Dowd Darin R · Frisco, TXBuilt 1940 · S/N 4845 N30906Vesely Edward A · Houston, TXBuilt 1940 · S/N 5191 N31017Hicks Paul G · Lizton, INBuilt 1962 · S/N 5257 N31118Smith Walter E Jr · Villa Ric A, GABuilt 1940 · S/N 5336 N31150Executive Aero Inc · Tipp City, OHS/N 5364 N31178Budinich Jason H · Hartford, WIBuilt 1940 · S/N 5388 N31822Smith Roger L · Motley, MNBuilt 1941 · S/N 6831T N32433Stewart Thomas D · Cashmere, WABuilt 1941 · S/N 863 N32671Ricca Gregory F · Jonesboro, ARS/N 5530 N32818Flannery Bruce F · Gladstone, MIS/N 5626 N32946Williams Robert M · Red Hook, NYBuilt 1940 · S/N 5730 N33026Merritt Michael L · Acworth, GABuilt 1940 · S/N 5784 N33141Tarakji Mohamad H · Van Nuys, CABuilt 1940 · S/N 5859 N33201G L Leonard Aviation LLC · Anacortes, WAS/N 5909 N33227Cranwill Joseph H · Chatham, ILBuilt 1940 · S/N 5902 N33229Bowers Curt E · Jennings, LABuilt 1940 · S/N 5903 N33236Smith Ernest C · Cato, NYBuilt 1940 · S/N 5911 N33256Kourtis Vintage Aviation LLC · Owasso, OKBuilt 1940 · S/N 5930 N33442Chinlund Jeffrey B · Greenville, NCBuilt 1940 · S/N 5957 N33453Piper Gary S · Hendersonville, TNBuilt 1940 · S/N 5962 N33461Bennett Robert M · Felton, DEBuilt 1940 · S/N 5970 N33481Christie Ian A H · Limon, COBuilt 1940 · S/N 5991 N33769Knitter Edward R · Perry, NYBuilt 1941 · S/N F-9381T N33952Draveling Larry J · Wasilla, AKBuilt 1941 · S/N 2804

Back to Franklin 4AC176B series