Tallahassee, FL
Registered aircraft · 228
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 = 'TALLAHASSEE' 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 = 'TALLAHASSEE' 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.
N10113Balony Kubicek Spol Sro BB30Z · S/N 1790N108RKBeech A36 · S/N E-1513N109FCPiper PA-31-325 · S/N 31-8012073N10ZBRobert W Moore RV-8 · S/N 83333N11025Champion 7ECA · S/N 7ECA-7N112FCAgustawestland Philadelphia AW119MKII · S/N 15032N1140JAero Commander 112 · S/N 140N114FCBell OH-58A · S/N 71-20620N115FCAgustawestland Philadelphia AW119MKII · S/N 15033N116FCAgustawestland Philadelphia AW119MKII · S/N 15034N1176YCessna 150B · S/N 15059576N117ECBeech A36 · S/N E-1118N117FCAgustawestland Philadelphia AW119MKII · S/N 15035N118FCAgustawestland Philadelphia AW119MKII · S/N 15020N119FCAgustawestland Philadelphia AW119 · S/N 14975N120FCBell UH-1H · S/N 70-16260N121RDCessna 180H · S/N 18052053N1235LColumbia Aircraft Mfg LC41-550FG · S/N 41741N124FCBell UH-1H · S/N 64-13750N125FCBell UH-1V · S/N 70-16439N1324HAeronca 15AC · S/N 15AC-359N13314Cessna 177B · S/N 17702412N1336SCessna 182P · S/N 18264899N134FCPiper PA-28-181 · S/N 28-8290169N136FCPiper PA-28-181 · S/N 28-8290171N138FCPiper PA-28-181 · S/N 28-8290102N139FCPiper PA-28-181 · S/N 28-8290174N13MSGulfstream Aerospace GVIII-G800 · S/N 88036N140FCPiper PA-28-181 · S/N 28-8290175N1417TPiper PA-28-140 · S/N 28-7225508N141FCPiper PA-28-181 · S/N 2881158N142FCPiper PA-28-181 · S/N 28-8290177N143FCPiper PA-28-181 · S/N 28-8290178N144EZPiper PA-32RT-300 · S/N 32R-7885184N148FCPiper PA-28-181 · S/N 2881520N149FCTextron 182T · S/N 18283002N1511BFirefly Balloons FIREFLY 8B-15 · S/N F8B-2011N151FCCessna 182T · S/N 18281874N152BFTextron T206H · S/N T20609201N153FCCessna 182T · S/N 18281774N153SMPiper PA-28-151 · S/N 28-7415167N154FCCessna 182T · S/N 18281785N155FCCessna 182T · S/N 18281789N157FCCessna 182T · S/N 18281875N158FCCessna 182T · S/N 18282062N159FCCessna 182T · S/N 18282065N169DBPiper PA-28R-200 · S/N 28R-35150N174CCCubcrafters CC11-160 · S/N CC11-00174N175EWEmbraer-Empresa Brasileira De EMB-500 · S/N 50000188N179WHBoemer Henry J RV-6 · S/N 25378
Back to Tallahassee, FL