Jupiter, FL
Registered aircraft · 188
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 = 'JUPITER' 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 = 'JUPITER' 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.
N105ACHughes Helicopters HUGHES 369D · S/N 580316DN11042Champion 7ECA · S/N 24N1131VCessna LC41-550FG · S/N 411098N113ECEnrique Carrasco VELOCITY XL/RG-5 · S/N 3RX112N1171Bell Helicopter Textron 206L-1 · S/N 45234N11TTCirrus Design SF50 · S/N 0703N121AFBeech 58 · S/N TH-1254N139GXAero Vodochody L-39 · S/N 530515N1408XCirrus Design SF50 · S/N 0051N15961Piper PA-32-260 · S/N 32-7300022N162BAIcon A5 · S/N 00081N16735Schweizer 269C-1 · S/N 0231N171TGDassault-Breguet FALCON 50 · S/N 251N177CJCessna 177RG · S/N 177RG0018N1793KLuscombe 8E · S/N 4520Registration pendingN17GTGrumman American Avn. AA-5B · S/N AA5B-0011N17GWCessna 310R · S/N 310R0555N17VGPiper PA-17 · S/N 17-97N180JECessna 180J · S/N 18052451N181GMGame Aerospace GB1 GAMEBIRD · S/N 0112N186SBCirrus Design SR20 · S/N 8810N18CYCirrus Design SR22T · S/N 1740N1992EBarber Edward RANS S-6S · S/N 05081885N19MABeech V35 · S/N D-8173N1NKGulfstream Aerospace GV-SP (G550) · S/N 5534N1WRRyan William R VARI-EZE · S/N 1845N200HKRaytheon B200 · S/N BB-1772N200STRaytheon 390 · S/N RB-102N2019PAir Tractor AT-502B · S/N 502B-2792N2064SBell 206-L4 · S/N 52002N207HACessna 207A · S/N 20700742N2089WBeech 95-C55 · S/N TE-60N20AWTextron 208B · S/N 208B5534N210TACirrus Design SR22 · S/N 9077N210WSCessna 210J · S/N 21059135N221FSCirrus Design SR22T · S/N 10514N2229KLuscombe 8E · S/N 4956N224PDDJI AGRAS T40 · S/N 1581F574B235D00100KEN2272VCessna 172R · S/N 17280839N228AEBell Helicopter Textron 206L-1 · S/N 45697N2300EChampion AERONCA 7AC · S/N 7AC-5794N231SGCirrus Design SR20 · S/N 2280N23417Piper J4A · S/N 4-611N242HRMartin Tom HARMON ROCKET II · S/N 159N248KPiper PA-23-250 · S/N 27-7654004N24BKBeech A36 · S/N E-1145N261JDGulfstream Aerospace G-IV · S/N 1409N2692UHunting P66 PEMBROKE · S/N 76N269SACessna 182T · S/N 18282280N276DAHylio AG 230 · S/N 17906100264
Back to Jupiter, FL