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.
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
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.
N1400UCessna 150A · S/N 15059024N140NCPiper PA-28-140 · S/N 28-7525137N1415UCessna 172M · S/N 17267083Sale reportedN142TVPiper PA-28RT-201T · S/N 28R8031020N143CCirrus Design SR22 · S/N 3224N143MDCirrus Design SR22T · S/N 10440N1446QCessna 150L · S/N 15072746First renewal noticeN145ATAirtime CYGNET · S/N 00101N1479ECessna 172N · S/N 17271016N148SCEurocopter EC120B · S/N 1469N14VBeech B90 · S/N LJ-411N150PAConvair T-29B · S/N 278N1526VCessna 172M · S/N 17263645N15460Agustawestland Philadelphia AW139 · S/N 41323N154FVGulfstream Aerospace GIV-X (G450) · S/N 4318N1550UBeech A36 · S/N E-2839N155RDEurocopter EC 155B · S/N 6580N158PTPiper PA-28-161 · S/N 2841150N15BYDassault FALCON 2000 · S/N 199N15CDAero Commander 690A · S/N 11177N15UGVans RV-12IS · S/N 121555N160PTPiper PA-44-180 · S/N 44-7995161N1617GChampion 7ECA · S/N 621N161PTPiper PA-28-161 · S/N 2841156N162TSAerostar International S-51A · S/N S51A-3017N163RCessna 680 · S/N 680-0163N164ERPiper PA-28-161 · S/N 2841180N1653FCessna 172H · S/N 17255048N166MSBell 206B · S/N 1078N166PBBuonfante Paolo SPORTSMAN GS-2 · S/N 7425N167CACirrus Design SR22 · S/N 11191N16THBeech A23A · S/N M-994N17101Cessna 150L · S/N 15073623N1714HTextron 208B · S/N 208B5861N175BGGulfstream Aerospace G-1159A · S/N 396N18199Cessna 150L · S/N 15073856N181GDDassault FALCON 2000 · S/N 133N181RKDassault-Breguet MYSTERE FALCON 200 · S/N 515N18260Cessna T206H · S/N T20608543N184DGPiper PA-23-250 · S/N 27-2504N186AZCessna A185F · S/N 18503192N18AAHawker Beechcraft HAWKER 900XP · S/N HA-0068N18NERobinson Helicopter R44 II · S/N 14386N1919Pilatus PC-12/47E · S/N 1919N19255Cessna 150L · S/N 15074278N197CABeech 65-A80 · S/N LD-246N19837Cessna 172M · S/N 17260793N19886Cessna 172M · S/N 17260834N198FTPiper PA-28-161 · S/N 28-8216198N19908Cessna 172M · S/N 17260852Sale reported
Back to Miami, FL