Mulberry, FL
Registered aircraft · 40
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 = 'MULBERRY' 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 = 'MULBERRY' 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.
N103JAHiller UH-12C · S/N 782N1072LLake LA-4-200 · S/N 665N10937Cessna 150L · S/N 15075151N112FRFelipe R Rodriguez Reyes QUICKSILVER MXLII · S/N FR 0060N114MRRichard A Briggs VANS RV-14 · S/N 140545N135MJSchweizer SGS 1-35 · S/N 3N1546NPiper J3C-65 · S/N 23080N211RB-Z Aero S-20 RAVEN · S/N 01150032N217DJDuran D/Duran J RV-7 · S/N 72310N237LSSouth Florida Ultralights RV-6 · S/N 21242N238RTLake LA-4-200 · S/N 506N269BColonial C-2 · S/N 127N337RTCessna 337 · S/N 337-0089N3679HErcoupe 415-C · S/N 4304N36821Aeronca 65-TAF · S/N F1601TAN4056QHubbell Michael Cooper CHALLENGER II · S/N CH2-0102-R-2170N42659Piper J3C-65 · S/N 14953N43733Lamberty Paul L RANS S-6ES · S/N 05051666N4641JPiper PA-28R-180 · S/N 28R-30531N4GZGlade Bernard W JR RANS S-7S · S/N 0208495N5107ZBeech 35-B33 · S/N CD-396N61700Cessna 172M · S/N 17264741N620AMWaco UPF-7 · S/N 5525N6241NCessna 182R · S/N 18267807N6478TCessna 150 · S/N 17878N6895ECessna 175A · S/N 56395N71891Luscombe 8A · S/N 3318N7192NBeech E33 · S/N CD-1146N727GJKrucker Manufacturing TUNDRA 582 · S/N KLM003N7527WPiper PA-28-180 · S/N 28-1446N76458Cessna 120 · S/N 10890N770RVBelgau Robert J VANS RV7 · S/N 70827N810RLLawson Ronald S BEARHAWK LSA · S/N 001N8369PPiper PA-24-250 · S/N 24-3627N8871JPiper PA-28-180 · S/N 28-2843N8968DPiper PA-22-160 · S/N 22-6132N909LOwens Larry A VANS RV 8 · S/N 82357N94174Engineering & Research ERCOUPE 415-C · S/N 1497N957ARSwearingen SA226TC · S/N TC-371N965ARAero Commander 680-F · S/N 1195-100
Back to Mulberry, FL