Jupiter, FL
Registered aircraft · 190
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.
N288PBeech 58 · S/N TH-1113N2CKCirrus Design SR22T · S/N 10355N2NKAirbus Helicopters Deutschland MBB-BK117 D-3 · S/N 21199N30ELLynch Edward J SEAWIND 3000 · S/N 54N3156XCessna T207A · S/N 20700376N323AKPiper AEROSTAR 600 · S/N 6007027961218Registration pendingN325WJBombardier BD-100-1A10 · S/N 20449N33252Piper J3L-65 · S/N 5927N33478DJI AGRAS T50 · S/N 1581F6BUB235N00100CYN334GMN924gm CCX-2300 · S/N CCX-2300-0021N3366PCessna 182J · S/N 18257084N33ALCirrus Design SF50 · S/N 0567N34121Cessna 177B · S/N 17701650N345CBBeech N35 · S/N D-6714N34GMN924gm CCX-1865 · S/N CCX-1865-0013N358FTJohn Easterling KALLITHEA/JOHN EASTE · S/N K0037N365JWCessna 510 · S/N 510-0183N369KVHughes Helicopters HUGHES 369D · S/N 300659DN37KCSouthern Cubs CCX-2000 · S/N CCX-2000-0222N39GXAero Vodochody L-39 · S/N 232205N411GTCirrus Design SR22 · S/N 1714N411NKCessna 750 · S/N 750-0311N412TFTextron 208 · S/N 20800611N415GPErcoupe 415-C · S/N 667N418KAnthony Klopp CW-11 · S/N 005N42283Piper J3C-65 · S/N 14533N427YScaglione Joseph A WAIEX · S/N 0475N433ALCirrus Design SR22 · S/N 11357N4380NCessna 195 · S/N 7026N442KYRobinson Helicopter R44 II · S/N 12309N444VCCessna 182S · S/N 18280483N450BTGulfstream Aerospace GIV-X (G450) · S/N 4065N45755Luscombe 8A · S/N 2282N4598TPiper PA-32-260 · S/N 32-7200024N459STCessna 150L · S/N 15074495N468CPartenavia P.68C · S/N 213N47FLAviat A-1C-180 · S/N 3429N4806JBeech V35 · S/N D-8353N48CKSouthern Cubs CCX-1865 · S/N CCX-1865-2036N499WMBell 206B · S/N 4376N49LCPerformance Air PA18WB · S/N PA18-0603N501MDMcdonnell Douglas Helicopter 369E · S/N 0485EN5044ACessna 172 · S/N 28044N5174BCessna 152 · S/N 15283790N517TWGulfstream Aerospace GV-SP (G550) · S/N 5209N530AGTextron 525B · S/N 525B0727N53737Bellanca 8KCAB · S/N 208-75N555BHHughes Helicopters HUGHES 369D · S/N 1200857DN56CJSchmid URS RV-8 · S/N 82781N576PVIsrael Aircraft Industries 1124 · S/N 383
Back to Jupiter, FL