North Miami, FL
Registered aircraft · 35
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 = 'NORTH 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 = 'NORTH 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.
N101NLPiper PA-28-140 · S/N 28-23419N112NLCessna 182K · S/N 18258322N1200LCessna 150 · S/N 17785N12209Cessna 172M · S/N 17261881N143QCRaytheon 390 · S/N RB-114N159ATAirtime CYGNET · S/N 113N1EJCessna 501 · S/N 501-0191N2105UPiper PA-28-181 · S/N 28-7990328N210PCCessna T210M · S/N 21062801N21608Cessna 182T · S/N 18281286N224UCirrus Design SR22 · S/N 3129N24RECessna 182G · S/N 18255274N305HPHawker Beechcraft G36 · S/N E-3852N30HBCessna 340A · S/N 340-0786N323HWCirrus Design SR20 · S/N 2727N353WCessna 150M · S/N 15078799N4107PPiper PA-23-160 · S/N 23-1562N431GXMooney M20R · S/N 29-0431N529JHGrumman American Avn. AA-1B · S/N AA1B0669N587MBDouglas DC-3S/R4D-8 · S/N 43312N600HWCessna 550 · S/N 5500479N60257Cessna 150J · S/N 15070177N61AYBeech 200 · S/N BB575N622NLRobinson Helicopter R22 ALPHA · S/N 0386N704CNCessna 150M · S/N 15078507N714BAIcon A5 · S/N 00107N71CVCirrus Design SR22 · S/N 4976N758STTextron T206H · S/N T20609744N772ECLearjet 60 · S/N 257N777CACessna 172 · S/N 17268259N824BCCessna 340A · S/N 340A0306N830NRGulfstream Aerospace GV-SP (G550) · S/N 5201N83187Piper PA-32-301 · S/N 32-8106028N912DRHawker Beechcraft 4000 · S/N RC-37N99800Beech H-18 · S/N BA-759
Back to North Miami, FL