Lake Placid, FL
Registered aircraft · 71
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 PLACID' 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 PLACID' 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.
N1033TPiper PA-23-250 · S/N 27-7405302N1154YSolensky James LANCAIR 360 · S/N 887-320-684SFBN1406LBeech A23 · S/N M-795N19978Cessna 172M · S/N 17260905N20291Cessna 172M · S/N 17261164N224EBCirrus Design SR22 · S/N 1287N2280UStanieich Brian V RANS S6-ES · S/N 1193556N228WChampion 7FC · S/N 7FC-255N23344Cessna 150H · S/N 15068888N235TACostruzioni Aeronautiche Tecna P92 TD · S/N 1413N239RJJohnson Rickie G CHALLENGER II · S/N CH2 2557N2512UCessna 172D · S/N 17250112N2582RCessna 182K · S/N 18258282N261ADDa Done MK4 · S/N 2025N2658HTwo Wings MARINER · S/N 002N2752CCPL CCX-2000 · S/N CCX-2000-0197N2850LCessna 172H · S/N 17256050N3096VBeech 35 · S/N D-513N314SLSilverlight DELTA JET-II · S/N 0001N31587Stinson 10A · S/N 7836N343EDMooney M20F · S/N 680006N34874Culver LFA · S/N 283N348ZBeech 35-A33 · S/N CD-235N3576YCessna 182F · S/N 18254476N36757Stinson 10A · S/N 8157N371WCClement William G PULSAR XP · S/N 371N37833Culver LFA · S/N 337N3FSmith AEROSTAR 601P · S/N 61P-0341-101N4066CStinson 108-3 · S/N 108-5066N409URPowrachute PC2000 · S/N A-229POWN414KHCessna 414 · S/N 414-0915N41556Piper J3F-65 · S/N 9045N42509Piper J3C-65 · S/N 14781N43714Taylorcraft BC12-D · S/N 7373N4386RCessna 172M · S/N 17263136N44194Taylorcraft BC12-D1 · S/N 9994N45LMGulfstream American AA-5A · S/N AA5A-0702N4646MLeigh A Moyer KITFOX SUPER SPORT · S/N KA11259205N46HKTerry Short Aircraft Svcs HAWK ARROW II · S/N HAII-330TRIN476RPSwilley James R CHALLENGER II · S/N CH2-0502-B-2221N506YSSam Shames CHALLENGER II · S/N CH2-0988-W-0359First renewal noticeN52765Cessna 177RG · S/N 177RG1267N543CTFlight Design CTSW · S/N 07-09-24N566LLElder William E JR KOLB MARK III CLSIC · S/N MT99-4-00012N6277VBeech V35A · S/N D-8601N6784MStinson 108-3 · S/N 108-4784N701AZBousquet Arthur R ZENITH CH701 SP · S/N 7-10944N7038ECessna 175A · S/N 56538N7183MCessna 175 · S/N 55483N739UBCessna 172N · S/N 17270807
Back to Lake Placid, FL