Spring Hill, FL
Registered aircraft · 98
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 = 'SPRING HILL' 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 = 'SPRING HILL' 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.
N61YNMooney M20J · S/N 24-3320N63485Nanchang China CJ-6A · S/N 2832011N6404QNarkunas Dana A FOKKER DR 1 TRIPLANE · S/N 528189N65DPCessna 172K · S/N 17257299N66461Boeing B75N1 · S/N 75-6729N67RSCanadair CL-600-2B16 · S/N 5149N685JWBellanca 7ECA · S/N 868-72N6893FPiper PA-28-151 · S/N 28-7715185N68TWDoan Vernon D W10-WITTMAN TAILWIND · S/N 881N69UCirrus Design SF50 · S/N 0544N704WRCessna 150M · S/N 15078936N7214EShroyer Lonnie W VANS RV6A · S/N 22831N727DCCessna 177B · S/N 17702086N7377HCessna A185F · S/N 18503382N738TFCessna R182 · S/N R18200958N747PTCessna 172M · S/N 172-63247N759HXCessna 182Q · S/N 18266017N759JACessna 182Q · S/N 18266020N7617HPiper PA-12 · S/N 12-492First renewal noticeN765ERRadtke Jeffrey A RV-7A · S/N 74123N7692UCessna 150M · S/N 15077818N7862NPiper PA-28-180 · S/N 28-5319N78945Mooney M20C · S/N 1979N81630Aeronca 7AC · S/N 7AC-249N8184HPiper PA-32R-301 · S/N 32R-8013083N8291ACessna 170B · S/N 25143N8314HEmigh TROJAN A-2 · S/N 17N838Beech D17S · S/N 6731N8395HPiper PA-28-181 · S/N 28-8190249N8605GCessna 150F · S/N 15062705N86977Bellanca 7KCAB · S/N 458-74N869SAZlin Aviation Sro SAVAGE · S/N 0131N8848YPiper PA-30 · S/N 30-1907N88DMGlaser-Dirks DG-500M · S/N 5E97M43N88KKCirrus Design SR22 · S/N 4798N8946CPiper PA-28-181 · S/N 28-7690171N89658Cessna 120 · S/N 8706N8CMBellanca 17-31A · S/N 32-26N8EPCessna 310Q · S/N 310Q0967N8LMMohr SKYBOLT · S/N LM7N8TCCessna 310Q · S/N 310Q0264N9015BHelio H-395 · S/N 611N91019Piper PA-18-150 · S/N 18-8109063N92006Cessna 172M · S/N 17261535N9329BCessna 175 · S/N 55129N9771CCanadair CL-600-2B16 · S/N 5063N99055Ercoupe 415-D · S/N 1678N9999SMooney M20C · S/N 680166
Back to Spring Hill, FL