Skip to content

Franklin 6A8 series

Registered aircraft · 107

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

N12CXHinds Bruce R · Port Orchard, WABuilt 1947 · S/N 264 N12XEMacleod Edward N · Trenton, MEBuilt 1947 · S/N 1059 N15387Nelson Ranley R · Butler, PABuilt 1935 · S/N 3010 N191VMcgregor Carter III · Wichita Falls, TXBuilt 1946 · S/N 150 N209CRezin David L · Warrens, WIBuilt 1947 · S/N 108-3209 N20CBHayes Jack D · Kingman, AZBuilt 1947 · S/N 522 N217GHoag Tom E · Bellevue, WABuilt 1947 · S/N 797 N2319MAlquist Kevin B · Edwardsville, KSS/N 471 N27CBHuey Andrew G · Fulton, MOBuilt 1947 · S/N 262 N2TBWhalen Shenandoah · Amelia, OHBuilt 1947 · S/N 819 N2ZTBold William H Jr · Annapolis, MDBuilt 1947 · S/N 671 N328CBThorne Matthew L · Vicksburg, MIS/N 940 N451EMensing Roger G · Sarasota, FLBuilt 1946 · S/N 182 N461WWBeewitched LLC · Denver, NCBuilt 1947 · S/N 461 N5090JAttitude Toys LLC · Wilmington, DEBuilt 1946 · S/N 244 N6007KPark Richard A · Alameda, CABuilt 1946 · S/N 177 N6041KLudmerer Victor J · Greenwood Lake, NYBuilt 1946 · S/N 216 N6047KMummy Mountain Med LLC · Paradise Valley, AZS/N 222 N6048KWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1947 · S/N 223 N6072KWeiss Elliott · Fresno, TXBuilt 1947 · S/N 252 N6097KGuntly David A · Franksville, WIBuilt 1947 · S/N 280 N6102KSes Bee LLC · Appleton, WIBuilt 1947 · S/N 285 N6113KRegistered aircraftS/N 296 N6118KAllen Richard P · Southampton, NJBuilt 1947 · S/N 301 N6125KBolognese Joseph Jr · Las Vegas, NVBuilt 1947 · S/N 311 N6138KBassett Douglas C · Long Lake, NYBuilt 1947 · S/N 324 N6175KOptimus Aircraft Service Inc · Middletown, DEBuilt 1947 · S/N 363 N6190KMampel Gregory John · New Port Richey, FLBuilt 1947 · S/N 381 N6200KLunney Arthur T · Kilmarnock, VABuilt 1947 · S/N 396 N6201KLawson William E · Somerset, WIBuilt 1947 · S/N 397 N6202KMid Atlantic Air Museum · Reading, PABuilt 1947 · S/N 398 N6204KPvb36 Leasing LLC · Denton, TXBuilt 1947 · S/N 404 N6208KBishop Bruce L · Durango, COBuilt 1947 · S/N 408 N6209KNobleartaviation Inc Trustee · Wilmington, DEBuilt 1947 · S/N 409 N6222KBromschwig Kurt F Trustee · Montgomery, TXBuilt 1947 · S/N 425 N6224KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 430 N6230KCuny John B · Carlsborg, WABuilt 1947 · S/N 433 N6234KNab Air LLC · Idaho Springs, COBuilt 1947 · S/N 437 N6240KJanus William Walter · Belchertown, MABuilt 1947 · S/N 443 N62544Brown George H · Youngstown, NYBuilt 1947 · S/N 464 N6256KMiller Byron W · Rosburg, WABuilt 1947 · S/N 463 N6283KTraylor Robert B · Millersview, TXBuilt 1947 · S/N 496 N6294KHill Bruce J · Mc Alpin, FLBuilt 1947 · S/N 507 N6302KRandall Adam M · Au Sable Forks, NYS/N 518 N6317KCoutches Steven S · Cameron Park, CABuilt 1947 · S/N 540 N6323KKosir John · Chardon, OHBuilt 1947 · S/N 547 N6342KBjorlie Paul A · Pekin, NDBuilt 1947 · S/N 566 N6352KColeman Aeromarine Inc · Lakeland, FLBuilt 1947 · S/N 581 N6356KMonarch M Miller · Ocala, FLBuilt 1947 · S/N 585 N6373KWoodberry Robert A · Mineral, VABuilt 1947 · S/N 602

Back to Franklin 6A8 series