Stuart, FL
Registered aircraft · 178
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'STUART' 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 = 'STUART' 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.
N1042GCessna 172 · S/N 36704N111SSBeech 300 · S/N FA-4N117MFBeech C90 · S/N LJ-779N118ENNichols Edson H III KIS-CRUISER TR-4 · S/N 4056N11GWGulfstream Aerospace G-V · S/N 507N124BHBoeing B75N1 · S/N 75-7606N1251DCessna 182T · S/N 18282023N128JKSouthern Cubs CCX-1865 · S/N CCX-1865-2011N130BVPiper PA-31-350 · S/N 31-7952216N13698Cessna 172M · S/N 17262952N1443VCessna 172M · S/N 17263580N1589DCessna 172R · S/N 17281255N1689QCessna 150L · S/N 15072989N1770XCessna 210L · S/N 21060791N1817SBeech 58 · S/N TH-1271N1838MCessna 182P · S/N 18264461N1942CCessna 170B · S/N 26087N200PPiper PA-31-350 · S/N 31-8052124N201FDCirrus Design SR22T · S/N 10391N201TYMooney M20J · S/N 24-0322N2060MAir Tractor AT-802A · S/N 802A-0437N20WWWhite William D LONG-EZ · S/N 1078N212STBeech C24R · S/N MC-566N216KWWright Kent S RV-6 · S/N 24778N221GHPiper PA-32R-300 · S/N 32R-7680502N225BKBombardier BD-700-1A10 · S/N 9876N2274TPiper PA-28R-200 · S/N 28R-7135176N228CCCirrus Design SR22T · S/N 0713N229DIsrael Aircraft Industries 1124A · S/N 427N22LCAmerican Legend AL18 · S/N AL-1224N2356ECessna 182S · S/N 18280423N235NSmalley Stephen LANCAIR 235 · S/N 071N2398XCessna 182H · S/N 18256298N23MMPiper PA-32-300 · S/N 32-40367N24WWCessna 210L · S/N 21060884N2501QCessna 182K · S/N 18257701N258RCBell OH-58A · S/N 71-20366N2651RCessna 172R · S/N 17280542N2721QCessna 182K · S/N 18257921N27DAPiper PA-32-300 · S/N 32-7840084N286MEPiper PA-34 · S/N 34-7250181N287LMBeech A36 · S/N E-2859N3080MPiper PA-12 · S/N 12-1768N308DDRaytheon HAWKER 800XP · S/N 258665N3136CCessna 180 · S/N 30935N315TPCessna 172R · S/N 172-80809N3232WBeech A36 · S/N E-2932N328NACessna 501 · S/N 501-0168N328YCubcrafters CC11-160 · S/N CC11-00410N33806Piper PA-28-151 · S/N 28-7515365
Back to Stuart, FL