Tampa, FL
Registered aircraft · 418
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 = 'TAMPA' 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 = 'TAMPA' 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.
N1008RMooney M20S · S/N 30-0055N101TNTextron 208 · S/N 20800587N10274Gulfstream Aerospace GV-SP (G550) · S/N 5210N102JFCessna T182T · S/N T18208579N102MUCessna 172R · S/N 17280285N1033ACessna 172R · S/N 17281238N1044AVans RV-12IS · S/N 12202N1097YCessna 172S · S/N 172S10296N109GLAgusta A109C · S/N 7623N109HPTextron 208B · S/N 208B5239N10FQJames T Lewis JR MTO SPORT · S/N M01282N1111KPiper PA-60-602P · S/N 60-8365021N111LHCessna 172N · S/N 17269965N111RXPiper PA-34-200T · S/N 347770134N113JKKusian James G VANS RV-6 · S/N 21369N1144ZPiper PA-28-181 · S/N 287890231N114JGCommander 114-B · S/N 14634N1150UMooney M20K · S/N 25-0623N121QPilatus PC-12/47E · S/N 1299N1234WCessna 414 · S/N 414-0043N1244GWaco UBF · S/N 3607N124KYCessna T182T · S/N T18208453N1259XMooney M20E · S/N 132N125BRCirrus Design SR22 · S/N 1221N128HBPiper PA-32R-301T · S/N 3257479N1299MCessna 210M · S/N 21061932N129XCCub Crafters CC19-180 · S/N CC19-0047N12XNPilatus PC-12/47E · S/N 2042N1302UCessna 172M · S/N 17266994N1312WMooney M20E · S/N 200N13376Cessna 172M · S/N 17262712N133TBByrnes Thomas A. LANCAIR 235 · S/N 133N13732Cessna 172M · S/N 17262978N13SYCessna 750 · S/N 750-0143N140RACessna 172S · S/N 172S8312N1432FCessna 172H · S/N 17254927N14486Rearwin 7000 · S/N 406N145SRCirrus Design SR22 · S/N 9010N148DWCessna T206H · S/N T20609091N14DABeech B95A · S/N TD-505N14HCDJI AGRAS T20 · S/N 35PBIAM0010WRPN1506TPiper PA-28-140 · S/N 28-7225538N1517MMichael Macelli DOMINATOR · S/N 001N15207Piper PA-28R-200 · S/N 28R-7335037N15363Piper PA-28-235 · S/N 28-7310039N154SDCirrus Design SR20 · S/N 1197N1554TCessna 414 · S/N 414-0269Registration pendingN1555MPiper PA-28R-201T · S/N 28R-7703146N15HRBombardier BD-100-1A10 · S/N 20072N15LXExtra Flugzeugproduktions-Und EA 300/LC · S/N LC020
Back to Tampa, FL