Merritt Island, FL
Registered aircraft · 211
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 = 'MERRITT ISLAND' 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 = 'MERRITT ISLAND' 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.
N1007CAmerican General Acft AG5B · S/N 10089N104RBLockheed CF104D · S/N 104632N104RDLockheed CF-104G · S/N 104850N104RNLockheed CF-104G · S/N 104759N10632Cessna 172R · S/N 17281431N106VTDaniel J Mesnard VELOCITY TWIN · S/N VT6-777N1071UMooney M20J · S/N 24-3140N109WEPiper PA-34-200T · S/N 347870405N1102WBeech V35B · S/N D-9472N110FCBell OH-58A · S/N 71-20536N1126CCessna R182 · S/N R18201689N113PDBell OH-58A · S/N 72-21342N121CMCessna 208B · S/N 208B0336N13411Cessna 177B · S/N 17702419N13986Cessna 172R · S/N 17281503N140NDPiper PA-28-161 · S/N 2841206N142NDPiper PA-28-161 · S/N 2841229N143EYPiper PA-28-140 · S/N 28-24348N144VGRobinson Helicopter R44 · S/N 1101N146PTPiper PA-28-161 · S/N 28-7916307N147BZPiper PA-34-200T · S/N 34-7870359N155APPiper PA-28-161 · S/N 2842027N156EWPiper PA-28-161 · S/N 2842028N163CLCessna 210M · S/N 21062122N1747LCessna 172R · S/N 17281489N17FDGuiter Charles CHALLENGER II · S/N CH2-0809-2863N182CWCessna R182 · S/N R18200517N1875YCessna 172C · S/N 17249475N18WNKing Flite IBRAHIM · S/N 001N19419Cessna 177B · S/N 17702570N1958PPiper PA-22-160 · S/N 22-6008N1995DBeech C35 · S/N D-3265N2034NCessna 152 · S/N 15282073N203AWWerback Andrew R LANCAIR LEGACY FG · S/N LS-207N203FPiper PA-28-161 · S/N 288416083N207ABPiper PA-28-161 · S/N 2841284N2085MPiper PA-34-200T · S/N 34-7870063N211NJPiper PA-28-161 · S/N 2842043N212MBCessna 152 · S/N 15279920N21493Cessna T206H · S/N T20608423N2159SPiper PA-34-200T · S/N 34-7970144N230GGSocata TB200 · S/N 2079N234FYPiper PA-34-200T · S/N 347870428N235FYPiper PA-28-161 · S/N 2841285N236FYPiper PA-28-161 · S/N 2842023N237FYPiper PA-28-161 · S/N 2842015N238FYPiper PA-28-161 · S/N 2841175N242TBSocata TB200 · S/N 2073N242ZZSocata TB20 · S/N 2080N2498SCessna T210L · S/N 21061306
Back to Merritt Island, FL