Key West, FL
Registered aircraft · 64
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 = 'KEY WEST' 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 = 'KEY WEST' 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.
N1019JAero Commander 112 · S/N 19N1041SCessna 172N · S/N 17268658N1122APiper PA-28-140 · S/N 28-25081N119ACBeech 58 · S/N TH-188N126SHBell 206B · S/N 1269N134STPiper PA46R-350T · S/N 4692038N136RTAeropilot S R O L 600 · S/N 1859N1448JRockwell International 112A · S/N 448N172FPCessna 172L · S/N 172-59815N17FGCessna 150M · S/N 15077906N189BAIcon A5 · S/N 00100N21047Cessna 182P · S/N 18261380N210FMCessna P210N · S/N P21000259N2131UCessna 182T · S/N 18281227N2140LMooney M20J · S/N 24-3425N2154GCessna 182 · S/N 51454N224EZGulfstream Aerospace 695B · S/N 96206N228WCPiper PA-28-161 · S/N 28-8416023N2629VCessna 177RG · S/N 177RG0635N313DWBeech C90A · S/N LJ-1434N31593Piper PA-32RT-300 · S/N 32R-7885108N32LLRobinson Helicopter R44 II · S/N 14441N34486Cessna 177RG · S/N 177RG1001N344CFRobinson Helicopter R44 II · S/N 10440N3476ABeech F33A · S/N CE-294N3781UCessna 182 · S/N 18255181N3794FCessna 172H · S/N 17255289N4075SEurocopter AS 350 BA · S/N 3043N414KSCessna 414A · S/N 414A0296N420KWPartenavia P.68C · S/N 294N43CWCessna 208 · S/N 20800175N448MAPiper PA-32R-301T · S/N 3257048N4857ZPiper PA-22-108 · S/N 22-8433N50354Cessna 150H · S/N 15069249N56MECessna 340A · S/N 340A0316N579KCessna 172B · S/N 17247827N587BCCessna 182Q · S/N 18267419N6178WCessna P210N · S/N P21000724N638LDBeech 58 · S/N TH765N684KWPartenavia P.68C · S/N 387N685KWPilatus Britten-Norman BN2T ISLANDER · S/N 2120N685LDAero Commander 685 · S/N 12020N686KWVulcanair P68C · S/N 364N6919WPiper PA-28-140 · S/N 28-21090N731TFSwearingen SA226-T(B) · S/N T321N7336JPiper PA-28-140 · S/N 28-24691N745TTLearjet 45 · S/N 099N74777Mooney M20B · S/N 1777N74AWBeech B200 · S/N BB-1233N751BAIcon A5 · S/N 00127
Back to Key West, FL