Lake Worth, FL
Registered aircraft · 48
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 = 'LAKE WORTH' 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 = 'LAKE WORTH' 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.
N1124EMooney M20J · S/N 24-1338N129RJBeech A36 · S/N E-1752N149NNPiaggio FW9-149D-A3 · S/N 089N15726Piper PA-28-140 · S/N 28-7325147N161ACBell 206B · S/N 4571N1665HTharpe Donald E T-01 · S/N 01N173KSBeech 300 · S/N FA-82N182GMCessna 182T · S/N 18281635N182WTCessna 182Q · S/N 18266876N1HXBeech 200 · S/N BB-361N2012PAmerican Blimp A-60+ · S/N 001N2139WBeech C23 · S/N M-1509Registration pendingN2211ZPiper PA-28-161 · S/N 28-7916389N22784Cessna 150H · S/N 15068512N24765Cessna 152 · S/N 15280363N2567XInfinity Power Parachute INFINITY 2003 · S/N IPP3-146N2629YCessna 150M · S/N 15077311N26885Gulfstream American AA-5A · S/N AA5A0787N3211JCessna 150G · S/N 15065911N3636YCessna 210C · S/N 21058136N38692Piper PA-28-140 · S/N 28-7725263N38792Piper PA-28R-201T · S/N 28R-7703277N3KVCessna 172P · S/N 17274768N400PBPiper PA-42-1000 · S/N 425527005N409FPDiamond Aircraft Ind DA40 F · S/N 40.FC009Non-citizen corporation, flight hours not reportedN414JGCessna 414 · S/N 414-0611N4254DBeech G35 · S/N D-4471N47848Piper PA-34-200T · S/N 34-7870008N48757Cessna 152 · S/N 15280956N5254KCessna 172P · S/N 17274033N5617PPiper PA-24 · S/N 24-685N567RFCirrus Design SF50 · S/N 0486N607LGAmerican Blimp A-60+ · S/N 017N611CDCirrus Design SR22 · S/N 1599N62YRMooney M20C · S/N 2118N6490LCessna 152 · S/N 15284417N65225Cessna 182T · S/N 18281414N6690TCessna 150A · S/N 15059090N67487Cessna 152 · S/N 15281861N6775NMooney M20C · S/N 680085N760ABAmerican Blimp A-60+ · S/N 007N7879GCessna 172L · S/N 17259579N862TCPiper PA-28-161 · S/N 28-7716290N8948HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1582N917FACessna 172P · S/N 17274062N9232VMooney M20C · S/N 690056N9568QBeech V35 · S/N D-8203N981JADiamond Aircraft Ind DA 42 · S/N 42.280
Back to Lake Worth, FL