Skip to content

Franklin 2A4 series

Registered aircraft · 35

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

N10983Blakesley Eric R · Canandaigua, NYBuilt 1971 · S/N 42-72 N10985Lozier Kurt T · Albany, NYS/N 45-72 N12205Wilson Seth J · Glennallen, AKBuilt 1972 · S/N 48-72 N1919WWiley Dennis C DBA · Emmett, IDBuilt 1999 · S/N 002 N31270Kunkle James K · Santa Ynez, CABuilt 1972 · S/N 68-72 N31290Huntting Preston I · Camp Verde, AZBuilt 1972 · S/N 69-72 N4995Stein David E · Modesto, CABuilt 1971 · S/N 10-71 N62965Mckenna David M · Newell, IAS/N 53-72 N68516Brothers Aviation LLC · Black Rock, ARBuilt 1972 · S/N 54-72 N68529Jcads Inc · Tampa, FLBuilt 1972 · S/N 59-72 N68538Maneely Roy H · Wadsworth, OHBuilt 1972 · S/N 60-72 N7742Brewer Michael A · Fort Wayne, INBuilt 1971 · S/N TM-1 N7EZEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1975 · S/N 001 N8861Farabaugh Nano F · Elkhart, INBuilt 1973 · S/N 71-73 N88EVCarrier Timothy E · Waynesville, OHBuilt 1972 · S/N 64-72 N90979Keyes Roger S · Las Vegas, NVBuilt 1973 · S/N 70-73 N9133LThompson Clark J · Rosharon, TXBuilt 1971 · S/N 36-72 N9135LStudie Billy D · Wasilla, AKS/N 3-71 N9139LHurley William J III · Abingdon, ILBuilt 1971 · S/N 8-71 N9142LBrown Michael E Jr · Timmonsville, SCBuilt 1971 · S/N 11-71 N9150LKing Jessie M · Spring Valley, MNBuilt 1971 · S/N 12-71 N9155LBelisle Barry A · Lancaster, TXBuilt 1971 · S/N 16-71 N9156LLerner Michael M · Tehachapi, CABuilt 1971 · S/N 17-71 N9161LBredlow Farming Co Inc · England, ARBuilt 1971 · S/N 23-71 N9162LBranum Seth L · Jonesboro, ARBuilt 1971 · S/N 24-72 N9163LLewallen William J · Eloy, AZBuilt 1971 · S/N 25-71 N9164LHodges Robert J · Savannah, GABuilt 1971 · S/N 26-71 N9175LNeuroth Kurt V · Saint Charles, MOBuilt 1971 · S/N 32-72 N9176LMunoz Eduardo J · Acworth, GABuilt 1971 · S/N 35-72 N9177KBishop David · San Marcos, CAS/N 37-72 N9180LPoynter Everett B · Somerset, KYS/N 38-72 N9181LBrown Samuel L · Flatonia, TXBuilt 1971 · S/N 39-72 N9189LParker Jeffrey D · Chelsea, ALS/N 33-72 N9190LWilliamson Will R III · Florence, SCS/N 44-72 N9199LO Neill Mark B · Pinckney, MIS/N 34-72

Back to Franklin 2A4 series