Oviedo, FL
Registered aircraft · 39
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 = 'OVIEDO' 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 = 'OVIEDO' 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.
N106CDCirrus Design SR20 · S/N 1015N1077CMooney M20A · S/N 1348N1106LDJI INSPIRE 1 · S/N W13DCB13020505N1173JAero Commander 112 · S/N 135N121JAAndrews James B DOE-GLASAIR · S/N 121N1620MMisch David M ROTORWAY EXEC 162-F · S/N 6520N19LVCessna T337G · S/N P3370012N20382Cessna 172M · S/N 17261242N26987Piper J5A · S/N 5-15N3513FCessna 172R · S/N 17281090N3841Glasflugel STANDARD LIBELLE · S/N 29N386LTTapert Warren F RANS S-12 · S/N 5145673N417CAPiper PA-28-161 · S/N 28-7816345N41DEBeech C-50 · S/N CH-305N448RBRobert E Blenden VAN'S RV-7A · S/N 72076N45662Cessna 150M · S/N 15077012N464CPLeon Ruben D VANS RV-9A · S/N 90626N4785NCessna 182Q · S/N 18267368N493GCClayton Neil K COZY MARK IV · S/N 493N552PADiamond Aircraft Ind DA 40 NG · S/N 40.NC322N55556Boeing A75N1(PT17) · S/N 75-344N55FSBell Helicopter Textron Canada 407 · S/N 54094N5981RCessna 172G · S/N 17253650N599BCCirrus Design SR22 · S/N 4037N61325Cessna 150J · S/N 15070965N627PKDJI INSPIRE 1 · S/N W21ACI12010059N6429LAmerican AA-1A · S/N AA1A-0429N645BKMooney M20K · S/N 25-0843N7161VMooney M20F · S/N 22-0070N756SRTom Ault SEAREY LSX · S/N 1LK523CN8003VSix Chuter SR7 XL · S/N 98-1984-SR7XLN8153WPiper PA-28-180 · S/N 28-2267N8379JCessna 150G · S/N 15066279N847RWEvans Robert L JR RV-10 · S/N 40012N8645EPiper PA-28-181 · S/N 28-7690183N87EJYakovlev YAK-55M · S/N 920502N917DAeropro CZ S R O A240 · S/N 65723N9223LAmerican AA-1A · S/N AA1A-0123N98211Joshua D Kovac VANS RV-7 · S/N 74564
Back to Oviedo, FL