Miami, FL

Registered aircraft · 801

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 = 'MIAMI'
  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.

N1400UCessna 150A · S/N 15059024Built 1960 · Tino Frank V JrN140NCPiper PA-28-140 · S/N 28-7525137Built 1975 · Ramirez Jesus NicolasN1415UCessna 172M · S/N 17267083Sale reportedBuilt 1976N142TVPiper PA-28RT-201T · S/N 28R8031020Built 1979 · Paulson Douglas WN143CCirrus Design SR22 · S/N 3224Built 2008 · Gavin Lauren Aviation LLCN143MDCirrus Design SR22T · S/N 10440Built 2025 · Egnazia Plane LLCN1446QCessna 150L · S/N 15072746First renewal noticeBeek Dudley ErnestN145ATAirtime CYGNET · S/N 00101Marinkovic Michael KN1479ECessna 172N · S/N 17271016Built 1978 · Aero Capital Lending LLCN148SCEurocopter EC120B · S/N 1469Built 2006 · Heli IncN14VBeech B90 · S/N LJ-411Double D International LLCN150PAConvair T-29B · S/N 278Built 1952 · Ultra Aviation Management IncN1526VCessna 172M · S/N 17263645Built 1974 · Rl Aviation LLCN15460Agustawestland Philadelphia AW139 · S/N 41323Built 2012 · Variety Childrens Hospital DBAN154FVGulfstream Aerospace GIV-X (G450) · S/N 4318Built 2014 · Genav 3 LLCN1550UBeech A36 · S/N E-2839Built 1994 · Maxwell Monroe Air LLCN155RDEurocopter EC 155B · S/N 6580Built 2000 · Castro Be LLCN158PTPiper PA-28-161 · S/N 2841150Built 1989 · Pilot Training Center LLCN15BYDassault FALCON 2000 · S/N 199Built 2002 · Jetmax Associates LLCN15CDAero Commander 690A · S/N 11177Commander N15cd LLCN15UGVans RV-12IS · S/N 121555Fly Jocko Fly LLCN160PTPiper PA-44-180 · S/N 44-7995161Built 1978 · Pilot Training Center LLCN1617GChampion 7ECA · S/N 621Built 1968 · Duch Jose MN161PTPiper PA-28-161 · S/N 2841156Built 1989 · Pilot Training Center LLCN162TSAerostar International S-51A · S/N S51A-3017Built 2001 · Dick Miller LLCN163RCessna 680 · S/N 680-0163Built 2007 · Summit Air LLCN164ERPiper PA-28-161 · S/N 2841180Built 1989 · Silver Express Co DBAN1653FCessna 172H · S/N 17255048Built 1966 · N1653f LLCN166MSBell 206B · S/N 1078Flyone USA CorpN166PBBuonfante Paolo SPORTSMAN GS-2 · S/N 7425Built 2015 · Buonfante PaoloN167CACirrus Design SR22 · S/N 11191Built 2026 · Goody For US Aviation LLCN16THBeech A23A · S/N M-994Built 1966 · Mosquera DanielN17101Cessna 150L · S/N 15073623Built 1972 · Vasquez Juan EN1714HTextron 208B · S/N 208B5861Built 2025 · Blue Flight II LLCN175BGGulfstream Aerospace G-1159A · S/N 396Built 1983 · Mile High Holdings LLCN18199Cessna 150L · S/N 15073856Built 1972 · Forthman Scott ChanceN181GDDassault FALCON 2000 · S/N 133Built 2001 · 330am Holding CorpN181RKDassault-Breguet MYSTERE FALCON 200 · S/N 515Built 1991 · 330 Am Holding CorpN18260Cessna T206H · S/N T20608543Built 2005 · Atc Trucking IncN184DGPiper PA-23-250 · S/N 27-2504Built 1964 · Martin Vicente Eduardo MisaN186AZCessna A185F · S/N 18503192Built 1976 · Iz Air LLCN18AAHawker Beechcraft HAWKER 900XP · S/N HA-0068Built 2008 · Atlantic Prime CorpN18NERobinson Helicopter R44 II · S/N 14386Built 2020 · 330am Holding CorpN1919Pilatus PC-12/47E · S/N 1919Built 2019 · Phase 2 Aviation LLCN19255Cessna 150L · S/N 15074278Built 1973 · Arnett Donald KN197CABeech 65-A80 · S/N LD-246Built 1965 · Nighthawk Air Systems IncN19837Cessna 172M · S/N 17260793Built 1972 · Kerrick Wallace Glenn LeeN19886Cessna 172M · S/N 17260834Built 1972 · Silver Express CoN198FTPiper PA-28-161 · S/N 28-8216198Built 1982 · Ortiz Santiago GilN19908Cessna 172M · S/N 17260852Sale reportedBuilt 1976
Back to Miami, FL