Franklin 6A-350SER
Registered aircraft · 74
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 ('27023')
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 ('27023')
ORDER BY n_numberRun 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.
N51621Johnson Lucas G · Pleasant Lake, MIN527CFischer Richard F · Aromas, CAN6162AMcgowan Dennis P DBA · Kearney, NEN62021Biotech Travel LLC · Pima, AZN62ALTsai Wade · Seattle, WAN639BHCane David · Eden, UTN688RRBooher Eddie R · Ottawa, KSN7558MPrice David B · Gallipolis, OHN776TBStephens Eric · Roswell, GAN78237Spencer Randall Bruce · Orangeville, UTN801BKRisch Robert E · Ouray, CON8155TChristen Richard P · Bend, ORN826VRRegistration Pending · Lakeland, TNRegistration pendingN82JBBirk Aircraft Sales LLC · South Orange, NJN832ABMcnair Grover C III · Raleigh, NCN888RFTao Engineering · Groveland, CAN9029DKemp Ted · Pleasant Shade, TNN904BDickson Robert T · Concord, NCN91PTClark Daniel E · Rio Linda, CAN952AVWanstedt Scott C · Spearfish, SDN97800Harvey Robert C · Hortonville, WIN97VEWillis Kevin · Mesa, AZN9817GLester Matthew J · Gouldsboro, MEN987VPFettig John · Whiteville, NC
Back to Franklin 6A-350SER