Spring Hill, FL
Registered aircraft · 99
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.
N1009RNanchang China CJ-6A · S/N 2332072N1013ZNanchang China CJ-6A · S/N 2951290N10SUMahoney James R MONERAI P · S/N 0046N1255QCessna 150L · S/N 15072555N134GDirect Fly S R O ALTO · S/N DFUS-15-021N141TLDunning R Morton CHALLENGER II · S/N CH2-0710-Y-2881N17FBBrunot Frank A S-6S COYOTE II/TD · S/N 06001370N180PTCessna 180 · S/N 31051N19594Cessna 150L · S/N 15074516N19606Cessna 172L · S/N 17260605N197RCAero Commander 112 · S/N 197N198DPBrooklands Aerospace GRP OA7 OPTICA · S/N 019N2038HErcoupe 415-C · S/N 2661N2121SMooney M20R · S/N 29-0106N2209TPiper PA-32-300 · S/N 32-7140070N227BCStinson L-5 · S/N 76-868N22WTPiper J3C-65 · S/N 18977N2308VCessna 140 · S/N 14544N2757HErcoupe 415-C · S/N 3382N2903DPiper PA-28-181 · S/N 28-7990542N31540Stinson 10A · S/N 7789N3306YCessna 182E · S/N 18254306N330CSExtra Flugzeugproduktions-Und EA 300/LC · S/N LC015N330MLExtra Flugzeugproduktions-Und EA 300/LT · S/N LT010N345JGPiper PA-23-160 · S/N 23-1825N34676Stinson 10A · S/N 7976N383SBWooldridge Harry SACO P6-E HAWK · S/N HKW 021N3884LCessna 172G · S/N 17254053N3VGChristen Industries PITTS S-2B · S/N 5198N426HLCessna 172N · S/N 17269050N427HThorp T-18 · S/N 427N438PNanchang China CJ-6A · S/N 4632017N4424DNelson Joe Richard CHALLENGER II · S/N CH2CW0704N44288Aeronca 7BCM · S/N 7AC6746N466DCMitsubishi MU-2B-60 · S/N 1528SAN4678KCessna 182P · S/N 18263679N46896Aeronca 0-58B · S/N 058B-2872N471TTitus Richard L ARROW II · S/N H-11-140N474RSEurocopter AS 350 B2 · S/N 9012N4963WRockwell International 114 · S/N 14283N5097FPiper J3C-50 · S/N 4919N5383GHelio H-295 · S/N 1249N54563Boeing A75N1(PT17) · S/N 75-956N54GMBranson STARDUSTER II · S/N 1N55432Boeing A75N1(PT17) · S/N 75-2411N6033KCessna T206H · S/N T20608631N6034FCessna 172S · S/N 172S10196N6042TTarabocchia John W ZODIAC/CH 601-HDS · S/N 6-4085N60883Cessna 150J · S/N 15070644N6179PWoods Charles T RV-9A · S/N 90849
Back to Spring Hill, FL