Milton, FL
Registered aircraft · 91
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 = 'MILTON' 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 = 'MILTON' 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.
N1071XPiper PA-28-140 · S/N 28-7525274N111PPMoran Allen C CLIPPED WING CUB · S/N AM-3N1141TBailey Roger L RBB · S/N 6140347-PN12141Cessna 172M · S/N 17261837N1304YCessna 172C · S/N 17249004N14455Cessna R172E · S/N R-172-0143N1516VCessna 172M · S/N 17263638N1537XPiper PA-28-151 · S/N 28-7515418Sale reportedN1588VCessna 172M · S/N 17263683N1712MParks 3 · S/N 1N17451Roger L Bailey T-51 MUSTANG · S/N M12XXXC0HK0174N1818EAeronca 7AC · S/N 7AC-5385N192ASSchummer Walter A 3RD AVID BANDIT · S/N 1580EN1940TPiper PA-28R-200 · S/N 28R-7135138N1956EMiller Ronald E 601 XL · S/N 6-4560N201JBMooney M20J · S/N 24-0004N208NDFabian Gerald F JR KITFOX-4-1200 · S/N LCU134N2135TPiper PA-28R-200 · S/N 28R-7135139N2510GChampion 7ECA · S/N 403N2654ZBellanca 8KCAB · S/N 358-78N26TLLemen Charles E MM1 · S/N 171N277CGRisley/Wade/Sherwood SEAREY · S/N 1MK277CN27979Piper J3C-65 · S/N 4490N28574Luscombe 8A · S/N 1403N2YPPiper PA-30 · S/N 30-452N32211Arkin Daniel RANS S12 XL · S/N 07040992N33YPCessna 172N · S/N 17272269N36516Piper PA-32RT-300T · S/N 32R-7887048N38599Piper PA-28-161 · S/N 28-7716271N3951TPiper PA-28R-180 · S/N 28R-30294N3976VCessna 170 · S/N 18295N4122JPiper PA-28-140 · S/N 28-22440N4179UCessna 150D · S/N 15060179N422Kindig Richard K KINDIG/GLASSAIR-1 · S/N 777N422SMPiper PA-28-161 · S/N 28-8116127N4264EAeronca 7AC · S/N 7AC-7161N43PFPiper PA-28-161 · S/N 28-7916362N4626TAeronca K · S/N K-298N4975LPiper PA-28-180 · S/N 28-4349N522CAPiper PA-23-250 · S/N 27-4711N53JSPiper PA-28R-180 · S/N 28R-30840N5583DBeech H35 · S/N D-5158N56220Piper PA-28-140 · S/N 28-7325591N5768FPiper PA-28-140 · S/N 28-25072N6113SScottish BULLDOG SK61.013 · S/N BH100-113N61491Pro Sport SPORTLITE 2 · S/N E003MCN61495Sabre SABRE TRIKE 503 · S/N A03MJCN6221ACessna 182 · S/N 33021N6415VCessna 172RG · S/N 172RG0677N6479TCessna 150 · S/N 17879
Back to Milton, FL