Miami Lakes, FL

Registered aircraft · 24

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 LAKES'
  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.

N103FDCirrus Design SR22 · S/N 9838Built 2024 · Midnight Echo LLCN113REVans RV-12 · S/N 120156Built 2010 · Eizmendiz Asley AlexanderN119PSIsrael Aircraft Industries GULFSTREAM 200 · S/N 009Built 1999 · N119ps LLCN1213FCessna 172N · S/N 17272972Built 1979 · Flight Answers LLCN126PKPiper PA-32R-301T · S/N 3257390Built 2005 · Ptk Equipment IncN130YBRaytheon HAWKER 800XP · S/N 258590Built 2002 · Mwl Aviation 1 LLCN212RAPiper PA-31 · S/N 317712057Built 1977 · Abin RicardoN218KAHawker Beechcraft G58 · S/N TH-2267Built 2009 · R3 Aviation LLCN222RAPiper PA-28R-200 · S/N 28R-7435127Built 1973 · Captain Rick LLCN341GSConvair C-131F · S/N 281Conquest Air IncN342GSConvair C-131F · S/N 299Built 1956 · Conquest Air IncN343GSConvair C-131F · S/N 305Built 1956 · Conquest Air IncN344GSConvair C-131F · S/N 311Conquest Air IncN345GSConvair C-131F · S/N 291Built 1955 · Conquest Air IncN36445Piper PA-32RT-300 · S/N 32R-7885188N36445 LLCN460WADouglas C54E-DC · S/N 44-9133Florida Air Transport IncN5045YPiper PA-23-250 · S/N 27-2054Wingsolutions CorpN507TTBeech B-60 · S/N P-558Campo Feliz Aircraft Services LLCN621SBRaytheon HAWKER 800XP · S/N 258531Built 2001 · Hundredfold Seraphim LLCN6KMBeech T-34B · S/N BG-249First renewal noticeBuilt 1956 · J Bird Enterprises LLCN70BFDouglas DC-6A · S/N 43720Built 1953 · Florida Air Transport IncN734WLCessna 172N · S/N 17269172Flight Answers LLCN808JGGulfstream Aerospace G-V · S/N 598Built 2000 · Two Weeks Notice LLCN8680TCessna 182C · S/N 52580D2w Enterprise LLC
Back to Miami Lakes, FL