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.
N79XCCirrus Design SR22T · S/N 1288N80440Cessna 172M · S/N 17266587N814CDCirrus Design SR22 · S/N 0143N8159APiper PA-32-301 · S/N 32-8006010N816LGCessna 172N · S/N 17268592N816SPGulfstream Aerospace G-IV · S/N 1452N81RHPiper PA-31-310 · S/N 31-7300909N821PJBRM Aero S R O BRISTELL LSA · S/N 465/2019N831JNTextron 182T · S/N 18283247N841PSPiper PA-24-260 · S/N 24-4684N848TPiper PA-32R-301 · S/N 3213027N869MPCirrus Design SR22 · S/N 1895N86DMMeade David N PITTS MEADE S1S · S/N 8-0015N87140Beech B24R · S/N MC-335N873KAEmbraer S A EMB-545 · S/N 55010127N886MCCessna T206H · S/N T20608861N888XAXtremeair XA42 · S/N 102N89968Cessna 140 · S/N 9020N905TJPiper PA-31-350 · S/N 31-7952204N9098YAerostar International RAVEN S49A · S/N S49A-3168N909AACessna 401 · S/N 401-0227N90ECCarris Edgar C ACRO SPORT · S/N EC-2N90HCDassault MYSTERE-FALCON 50 · S/N 208N912USSchmid URS RANS S-6ES · S/N 06061752N916GBIsrael Aircraft Industries GULFSTREAM 200 · S/N 067N916LSN916ls CCX-1865 · S/N CCX-1865-1003N926MSukhoi SU-26M · S/N 05-01N9304QBeech V35B · S/N D-9296N936JLRockwell International NA-265-65 · S/N 465-43N940EMCompagnie Daher TBM 700 · S/N 1339N9594SChampion 7GCAA · S/N 41N9599ZChristen Industries A-1 · S/N 1117N96814Cessna 182Q · S/N 18266860First renewal noticeN970SJGulfstream Aerospace GV-SP (G550) · S/N 5194N973ACGulfstream Aerospace GV-SP (G550) · S/N 5215N981ARCirrus Design SR22T · S/N 1159N990WRDassault-Breguet MYSTERE FALCON 900 · S/N 126N9984ACessna 170A · S/N 19556N999FACirrus Design SR22T · S/N 0252N99CWCirrus Design SR22 · S/N 10844
Back to Jupiter, FL