Fort Denaud, FL
Registered aircraft · 46
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 = 'FORT DENAUD' 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 = 'FORT DENAUD' 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.
N11JGGeisz SENIOR AEROSPORT · S/N D295-1N14556Aeronca C-3 · S/N A-508N145RHHusted Dean MEYERS 145 REPLICA · S/N 1N14VPBeech B-60 · S/N P-576N15FLSpittal J Oberlerchner/Drau MG 19 STEINDLER · S/N 016N174SSBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3543N1PMSwift S1 · S/N P-06N212PWDwlkk PW-2D GAPA D · S/N U-12N21FLMarganski Edward MDM-1 FOX · S/N 202N2413WSchweizer SGU 2-22E · S/N 251N2588HSchweizer SGS 1-26E · S/N 668N2682GCessna 182B · S/N 51982N3098MPiper PA-12 · S/N 12-1784N3170XCessna 150G · S/N 15064570N31BMWings And Things ASCENDER II+2 · S/N 1224N33928Schweizer SGS 2-33A · S/N 408N37666Piper J3F-65 · S/N 6433First renewal noticeN38CSSarles Chandler W ACEY DUECY P-70 · S/N 404N410KTTerry F King ZENITH 701 · S/N 8565N44303Taylorcraft BC12-D1 · S/N 10103First renewal noticeN4525PPiper PA-23-250 · S/N 27-29N456CWCessna 210N · S/N 21064676Sale reportedN46499Fairchild 24W-41A · S/N W41A-577N5LGPiper PA-28-140 · S/N 28-22238N601GFetzer George 601XL · S/N 5192N63260Cessna 150M · S/N 15077211N6WGDehavilland DHC-1 CHIPMUNK · S/N WD-299N7034KAven Donald E BREEZY · S/N 2756N711SFAviat PITTS S-2B · S/N 5351N71232Luscombe 8A · S/N 2659N720SPEstumkeda Ltd DBA Micco Acft MAC-145A · S/N 301N72KPPeacock Howard K CUB-Y · S/N 1234N76998Edwards Lewis A HATZ CB-1 · S/N 238N7957GCessna 172L · S/N 17259657N833TESlingsby T67M-260 · S/N 2260N833UTSlingsby T67M-260 · S/N 2276N833YTSlingsby T67M-260 · S/N 2269N834GHSlingsby SLINGSBY T67M260 · S/N 2259N835SSSlingsby SLINGSBY T67M260 · S/N 2281N8558Waco DSO · S/N A-77N88WTCessna 140A · S/N 15438N8DKPilatus B4-PC11 · S/N 236N900NXBeech 58 · S/N TH-723N91807Schweizer SGU-1-19 · S/N 16N9260UCessna 150M · S/N 15078210N94367Ercoupe 415-C · S/N 1590
Back to Fort Denaud, FL