Fleming Island, FL
Registered aircraft · 42
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 = 'FLEMING ISLAND' 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 = 'FLEMING ISLAND' 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.
N100XNLiberty Aerospace LIBERTY XL-2 · S/N 0100N1100Cessna 172 · S/N 29178N11285Cessna 150L · S/N 15075299N124PJCessna 172F · S/N 17252491N12682Cessna 172M · S/N 17262172N142TSBellanca 7KCAB · S/N 486-74N1461QCessna 150L · S/N 15072761N15298Piper PA-28-140 · S/N 28-7425001N162CRRise Christopher B VANS RV-7A · S/N 72053N194KWKelly T Wilson VANS RV9A · S/N 90177N1962WBernard Peter C QUICKSILVER SPORT 2S · S/N 0252N2006YNational Ballooning 858 · S/N 134N200PFCessna 172P · S/N 17276085N214KSKenneth R Sizemore VANS RV-14A · S/N 140072N222DYRobert H Woolley WOOLLEY PANTHER · S/N P003N22958Piper J3L-65 · S/N 2855N237KDDunlap Kenneth RV9A · S/N 90224N272TCHong John A J+S GLASAIR II-SM · S/N 001N277DEFriesel Clarence Canetti David LONG-EZ · S/N 017N315PLLee Patrick D RV-7 · S/N 70990N3183BNational Ballooning 858 · S/N 177N32300Piper PA-28-151 · S/N 28-7515118N351GTCzech Aircraft Works PARROT · S/N 06PP002N387PRDJI MINI 4 PRO · S/N 1581F6Z9A2432ML3504FN444VYRichard S Bowers GLASTAR KT5741 · S/N 55151N4886LPiper PA-28-180 · S/N 28-4252N512MAPiper PA-28-161 · S/N 28-7716224N524TCConstantino Thomas F RV-6A · S/N 60547N5765FPiper PA-28-140 · S/N 28-25069N5VBeech V35A · S/N D-8914N60135Beech C23 · S/N M-2105N6101JCessna T206H · S/N T20608812N6936MCessna 182P · S/N 18263895N707JWPiper PA-32RT-300 · S/N 32R-7885168N71DYJames Mintz / Don Yoakley STOLP STARDUSTER TOO · S/N 001N7731VCessna 177RG · S/N 177RG0906N77PCPiper J3C-65 · S/N 16642N8121Dent Russell G RV-9A · S/N 91841N89572Cessna 140 · S/N 8615N97215Stinson 108 · S/N 108-215N97KDDonald W Yoakley GLASAIR III · S/N 3332N9XWCruce Andrew C LANCAIR IV P · S/N LIV-528
Back to Fleming Island, FL