Edgewater, FL
Registered aircraft · 103
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 = 'EDGEWATER' 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 = 'EDGEWATER' 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.
N55XNPerry Robert D XENOS B · S/N X0055N572DGCirrus Design SF50 · S/N 0257N577BWWhatley William PEGASUS · S/N 001N5792CCessna 170A · S/N 19746N591TTJMB Aircraft S R O VL-3LSA-912 · S/N VL-3-511N593TTJMB Aircraft S R O VL-3LSA-912 · S/N VL-3-520N594TTJMB Aircraft S R O VL-3LSA-912 · S/N VL-3-521N595TTJMB Aircraft S R O VL-3LSA-912 · S/N VL-3-533N600ZFDeborah P Van Treuren TWISTER · S/N S-0009K6N60WHCessna 340A · S/N 340A0083N6135DPiper PA-22-150 · S/N 22-4779N6205WPiper PA-28-140 · S/N 28-20237N62182Boeing A75L3 · S/N 75-3537N6228WPiper PA-28-140 · S/N 28-20270N6393HPiper J3C-65 · S/N 19583N6396XCessna 402B · S/N 402B1355N64655Ernst PITTS SPECIAL · S/N TB-1N65394Pilatus B4-PC11 · S/N 216N68231Howard DGA-15P · S/N 1734N68574Bellanca 8KCAB · S/N 45-72N687USchweizer SGS 1-26B · S/N 306N69ASLet BLANIK L-13 · S/N 026941N719ACAmerican Champion 7GCBC · S/N 1314-2001N7276ACessna 172 · S/N 29376N7390XCessna 150B · S/N 15059490N766MFGrumman American Avn. AA-5A · S/N AA5A-0076N786JGGriggs John V ZENITH CH-750 · S/N 75-7869First renewal noticeN7AMCessna 182S · S/N 18280497N80002Aerotek PITTS S-2 · S/N 2008First renewal noticeN8362TVans RV-12IS · S/N 121264N842BBBtbltg VANS RV8A · S/N 001N84434Cessna 172K · S/N 17258469N845LNProgressive Aerodyne SEAREY LSA · S/N 1014N89JTCirrus Design SF50 · S/N 0095N913RHRoy T Hanan MTO SPORT · S/N M01051N9142JPiper PA-28-180 · S/N 28-3196N91973Piper J3C-65 · S/N 16404N9413VMooney M20E · S/N 700023N945TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024-2258N946TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024-2259N947TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024 2260N948TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024 2261N949TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024-2262N950NMMac Miller GROPPO TRAIL · S/N 919N981TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024-2263N9823UGrumman American Avn. AA-5A · S/N AA5A0223N982TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024 2264N9837QPiper PA-18-135 · S/N 53-7765N983TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024 2265N984TBEvektor-Aerotechnik A S HARMONY LSA · S/N 2024 2266
Back to Edgewater, FL