Clermont, FL
Registered aircraft · 84
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 = 'CLERMONT' 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 = 'CLERMONT' 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.
N1106GHughes Helicopters HUGHES 369D · S/N 510955DN1109SSchweizer SGS 1-26D · S/N 479N110THHaler Theodore R HALLER SPECIAL · S/N 001N111BBCessna 500 · S/N 500-0248N122KYPiper PA-25-260 · S/N 25-4576N1255KCessna 550 · S/N 550-0505N129LSCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 107N1324JBaggett John M VANS RV8 · S/N 80571N142DACessna 500 · S/N 501-0004N17APAmerican AA-1A · S/N AA1A-0007N203SDDonahue Stephen J FIRESTAR II · S/N F1237Registration pendingN2116MDta VOYAGEUR II · S/N 110N232SPPiper PA-28-181 · S/N 28-7990205N241BFCessna 501 · S/N 5010214N257BALet L-23 SUPER BLANIK · S/N 917928N26496Cessna 550 · S/N 550-0607N269TJSchweizer 269C · S/N S1807N276CBBodine Charles A PROGSV ARODYN SEAREY · S/N 1DK192N27KZDG Flugzeugbau LS8-S · S/N 8525N290SBLet L-23 SUPER BLANIK · S/N 938029N305TJMooney M20K · S/N 25-1163N30NWPiper PA-30 · S/N 30-312N310EJRaytheon HAWKER 800XP · S/N 258767N31HBSchempp-Hirth VENTUS CM · S/N 20N32047Piper PA-28R-200 · S/N 28R-7535018N32768Piper J3C-65 · S/N 5603N3521HMooney M20F · S/N 22-1433N355YCessna T210N · S/N 21064137N3572XPiper PA-28-161 · S/N 28-8016213N365JPCirrus Design SR22 · S/N 3010N3690RPiper PA-28-180 · S/N 28-5715N381KDg-Flugzeugbau DG-1000T · S/N 10-77T16N4092TBeech A36 · S/N E-556N43915Taylorcraft BC12-D · S/N 7574N443KCRommel Kurt E ROMMEL MUSTANG M-II · S/N M-II-1491N44MKCessna 501 · S/N 501-0272N45XBeech C35 · S/N D-3060N4800SPiper PA-32-260 · S/N 32-1185N501SSCessna 500 · S/N 5000374N511TEBeech D55 · S/N TE511Non-citizen corporation, flight hours not reportedN5148RHighcraft Aeromarine BUCCANEER XA · S/N 2001-HW1N517RWWilhite Randy SEA REY · S/N 017N530RRBell 206B · S/N 1302N53608Burkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3861-K-107N565CCCessna 500 · S/N 500-0065N56MNCirrus Design SF50 · S/N 0509N5737JCessna 182P · S/N 18263506N620THAircraft Mfg & Development CH 601XL SLSA · S/N 601-013SN6223YPiper PA-25-235 · S/N 25-3296N6415TCessna 150 · S/N 17815
Back to Clermont, FL