Brooksville, FL
Registered aircraft · 95
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 = 'BROOKSVILLE' 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 = 'BROOKSVILLE' 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.
N1013PBeech B24R · S/N MC-428N1040UPiper PA-34-200 · S/N 34-7250025N10GJGates Lear Jet 36 · S/N 010N113FTPiper PA46-500TP · S/N 4697280N1182MCessna 172K · S/N 17258682N11GJGates Learjet 35A · S/N 425N126AACessna 172S · S/N 172S10076N140BVCirrus Design SR22 · S/N 3780N1453NPiper J3C-65 · S/N 22982N1740CCessna 172S · S/N 172S10610N177JCCessna 177RG · S/N 177RG1156N17GJGates Learjet 35A · S/N 320N205GSSpicola Gregory A SPICOLA AIR COMMAND · S/N SP001N20GJGates Lear Jet 36A · S/N 026N2126SMooney M20R · S/N 29-0133N2127WLong Reggie D RAVEN · S/N 396RLN230CWS C Aerostar S .A. FESTIVAL R40S · S/N 05.03.06N2460ACessna 172R · S/N 17280932N2476YCessna 172S · S/N 172S10087N2519FPiper PA46-500TP · S/N 4697494N25426Cessna 152 · S/N 15280651N2558Roquet David W ROQUET ROTORWAY EXEC · S/N 6846N2754NCessna 140 · S/N 13012N280MECessna 172S · S/N 172S8536N2840PPiper PA-22-150 · S/N 22-3137N289JKCessna 172N · S/N 17267701N29379Cessna 177 · S/N 17700851N3129UBeech F33A · S/N CE-1255N31GJGates Lear Jet 36A · S/N 022N3209LRuff Robert Edward PROTECH PROSTAR PT-2 · S/N 2001N3260ZPiper PA-22-160 · S/N 22-7209N328CPCirrus Design SR22 · S/N 3248N3419UCessna 182F · S/N 18254819N342AJCessna 550 · S/N 5500050N3543GCessna 172R · S/N 17281079N35535Piper J-3 · S/N 6440N362DMPiper PA-32R-301T · S/N 3257362N362RMBeech A36 · S/N E-2194N36721Stinson 10A · S/N 8121N385PCessna 152 · S/N 15281108N400MPCirrus Design SR22T · S/N 11486N4014MPiper PA-12 · S/N 12-2892N4078NCessna 140 · S/N 13536N40SAPiper PA-32-260 · S/N 32-111N413AACessna 172S · S/N 172S8413N41GJGates Lear Jet 36A · S/N 055N422ASRaytheon C90A · S/N LJ-1714N427JLMaule M-7-260 · S/N 26013CN427SCJones Jeffrey A SUPERCUB · S/N 001N46020Cessna 152 · S/N 15282984Registration pending
Back to Brooksville, FL