Palm City, FL
Registered aircraft · 119
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 = 'PALM CITY' 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 = 'PALM CITY' 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.
N11479Cessna 150L · S/N 15075450N1151NMooney M20J · S/N 24-1228N1158QCessna 172S · S/N 172S10354N127TXBeech B100 · S/N BE-106N1327ZCessna 172S · S/N 172S9867N13601Cessna 172M · S/N 17262873N137LHRobinson Helicopter R44 II · S/N 11137N165HRRhyne Gene H RV-6 · S/N 20923N183VBBeech A36 · S/N E-1097Registration pendingN207RCCraig Sawka RV-7 · S/N 70533N225ALCirrus Design SR22T · S/N 2130N236SRaytheon A36 · S/N E3555N2441MPiper PA-23-250 · S/N 27-7954059N250LSMoravan ZLIN Z50 LS · S/N 0063N2649JCessna 172R · S/N 17280599N27405Piper PA-31-350 · S/N 31-7752164N27GCirrus Design SF50 · S/N 0348N2816NPiper PA-28-181 · S/N 28-7990452N285MEPiper PA-31-350 · S/N 31-7405410N300LMBoeing A75N1(PT17) · S/N 75-2855N3080MPiper PA-12 · S/N 12-1768N311LZLenard Iszak RV-10 · S/N 40803First renewal noticeN31TVPiper PA-23-250 · S/N 27-7954054N3221VCessna 150M · S/N 15076426N322WWPiper PA-46-600TP · S/N 4698133N324PWPilatus PC-12/45 · S/N 406N324WEpic E1000 · S/N K059N33079Piper PA-28-140 · S/N 28-7525150N338RBBallard Richard J STEWART 51 · S/N 103N33ZXBeech A36 · S/N E-920N360SPCessna 172S · S/N 172S8777N3653QBeech A23-24 · S/N MA-240N371MCPiper PA-31-350 · S/N 31-7405409Sale reportedN3777TPiper PA-28R-180 · S/N 28R-30089N384JPWaltman Theodore J MOOSE · S/N 303SRN38RBRB Aviation Enterprise CCX-2000 · S/N CCX-2000-0181N397ESCessna 172R · S/N 17280164N400WRReid Joseph W STEEN SKYBOLT · S/N 1N412RBPiper PA-32-300 · S/N 32-7940046N412YZCirrus Design SR22T · S/N 9089N4184RPiper PA-32-300 · S/N 32-40517N425QCDavid MF Giles RV-6 · S/N 21183N442MRRobinson Helicopter R44 · S/N 30063N4516QPiper PA-32R-300 · S/N 32R-7780331N4598XPiper PA-28-181 · S/N 28-7690048N4620CCessna 170B · S/N 25564N494UGhertner John L GLASAIR SUPER II FT · S/N 2422N4988VHawker Beechcraft 400A · S/N RK-572N507EAChristopher Lord ECLIPSE 10 · S/N 06164831014N507SACirrus Design SF50 · S/N 0025
Back to Palm City, FL