Polk City, FL
Registered aircraft · 153
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'FL' AND g.registrant_city = 'POLK CITY' ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'FL' AND g.registrant_city = 'POLK CITY' ORDER BY g.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.
N102BLBuhl LA-1 · S/N 102N105WLockheed VEGA 5C · S/N 72N106EPSeversky P-35A · S/N 282-11N108KWMesserschmitt ME 108 TAIFUN · S/N 1914N10967Curtiss Wright JR CW1 · S/N 1145N11170Stinson SM-6000-B · S/N 5023N111VASikorsky S-55 · S/N 55433N116ATPiper PA-38-112 · S/N 38-78A0731N1204North American P-51C · S/N 103-26385N12048Moss Jim MOSS-LAIRD SUPER SOL · S/N 001N1214NGrumman J2F6 · S/N 33549N125JCCanon Jack HJ1 HORNET-VH-32 · S/N 13N1267BPitcairn PA-18 · S/N G-65N127NCrichton John A SAVANNAH S · S/N 22-01-54-0846N1290Nieuport 17 · S/N LCNC 1967N12BYRoy Rehm BOEING P-12B · S/N 1183N12CRoy Rehm P-12C · S/N 1333N13777Northrop DELTA 1D · S/N 28N14126Lockheed 14-H · S/N 1500N147DPBell 47G · S/N 1685N150MWhite NEW STANDARD D-25A · S/N 205N156FSFieseler F1-156-C2 · S/N 4642N1606Nord STAMPE SV4C · S/N 190N16PGGolias Paul RV6 · S/N 23918N174VCurtiss Wright TRAVEL AIR B-4000 · S/N 1365N181BUMoravan ZLIN 381 · S/N 461N1913BKermit A Weeks WEEKS/BENOIST · S/N TJ-1N19175Vintage Aviator Limited The ALBATROS DVA-1 · S/N 1267N1917TThomas Morse Scout S4C · S/N 633N1943JNorth American B-25N · S/N 43-28059AN1944ADouglas DC3C-S1C3G · S/N 19677N19RXCurtiss Wright 19R · S/N 19R-20N1HDBoulton Paul Acft HAWKER DEMON · S/N K8203N1NNNielsen Norman P STEPHENS SUPER ACRO · S/N 001N2009VWeeks Kermit DR-1 · S/N 065N2101Benjamin Delmar R GEE BEE R-2 · S/N GB-02N211NXCannavo RYAN NYP · S/N DC-001N2145Orenco BIPLANE · S/N 45N222FMGrumman FM-2 · S/N 5975N2276YLavochkin LA-11 · S/N 10142N229VTGloster METEOR F4 · S/N VT229N230MSMorane-Saulnier 230 · S/N 1049N2334NHead Balloons AX9-118 · S/N 378N2368RHead Balloons AX8-88 · S/N 383N2404Curtiss JN4D · S/N 5360N240GGeneral GENAIRCO · S/N 17N247KBoeing 100A · S/N 1094N2511QMiller Mac GLASAIR SUPER II S · S/N 1010N25929Piper PA-38-112 · S/N 38-81A0105N25CThompson Hal H P H POWELL · S/N 02
Back to Polk City, FL