Saint Cloud, FL
Registered aircraft · 46
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 = 'SAINT CLOUD' 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 = 'SAINT CLOUD' 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.
N1005LLake LA-4 · S/N 248N12PZGrumman American Avn. AA-5 · S/N AA5-0622N1847EAeronca 7AC · S/N 7AC-5414N1965WTom Karr EXCALIBUR · S/N 7921N1993QCessna 177RG · S/N 177RG0393N2056ECessna 172M · S/N 17261399N2063XBeech A23 · S/N M781N272VXLorne J Spence VANS ACFT RV-14A · S/N 140272N276LCDJI MAVIC 3 PRO · S/N 1581F67QE235S00A0SJN27CSCessna 172E · S/N 17251680N3086CBeech D55 · S/N TE-510N3156TCessna 177 · S/N 17700456N331JRAviat PITTS S-2B · S/N 5241N33PZPiper PA-28-151 · S/N 28-7615040N37716Porterfield CP-65 · S/N 945N3944QCessna 172L · S/N 17260044N42023Piper J-3 · S/N 9069N4270TPiper PA-32-300 · S/N 32-7240048N430BFDJI AGRAS T40 · S/N 1581F574B236E00100X0N4373KPzl-Swidnik PW-5 · S/N 17.10.009N444XSGibney Paul H RANS S7 · S/N PG0051286N493TWBalony Kubicek Spol Sro BB30Z · S/N 1213N5056TBellanca 7ECA · S/N 1319-79N514BConsolidated Aeronautics LAKE LA-4-200 · S/N 1014N5355RCessna 172F · S/N 17252885N555PKPiper J3C-65 · S/N 20662N5621JKemmeries ARV TANARG · S/N T07074N5781RCessna 172G · S/N 17253450N6210HPiper J3C-65 · S/N 19386N621PTGregory Todd Lodde PITTS MODEL 12 · S/N 225N6272ECessna 172 · S/N 46372N659FLPiper PA-28-140 · S/N 28-7125577First renewal noticeN68515Bellanca 7ECA · S/N 867-72N686DSCirrus Design SR22 · S/N 1957N7186VMooney M20F · S/N 22-1184N738HTCessna 172N · S/N 17269996N7JVPiper PA-31-310 · S/N 31-789N8279NPiper PA-28-140 · S/N 28-25495N837DSDiamond Aircraft Ind DA 40 · S/N 40.437N8518KStinson 108-1 · S/N 108-1518N85503Aerofab LAKE 250 · S/N 124N8611QBeech S35 · S/N D-7636N9053VMooney M20E · S/N 690004N9305LAmerican AA-1A · S/N AA1A-0005N951GLLinzmayer George John B1B BUCCANEER · S/N B1B 417 503N99720Ercoupe 415-C · S/N 2343
Back to Saint Cloud, FL