Sanford, FL
Registered aircraft · 119
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 = 'SANFORD' 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 = 'SANFORD' 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.
N1154WCessna 172S · S/N 172S10608N123CFPilatus PC-12/45 · S/N 286N123TJPiper PA-44-180 · S/N 44-7995045N125MLPiper PA-44-180 · S/N 4496480N126MLPiper PA-44-180 · S/N 4496481N134MLPiper PA-44-180 · S/N 4496483N139AGRobinson Helicopter R22 · S/N 0131First renewal noticeN1688CCessna 172S · S/N 172S10612N1735XCessna 172S · S/N 172S10648N175SCAirbus Helicopters AS350B3 · S/N 8430N176SCAirbus Helicopters AS350B3 · S/N 9495N1887QCessna 177RG · S/N 177RG0287N209LHayden Wallace B SEA REY · S/N 1MK261N21160Piper PA-34-200T · S/N 34-7870430N2210BLuscombe 8F · S/N 6637N225GPLearjet 60 · S/N 154N2418APiper PA-22-135 · S/N 22-784N25286Cessna 152 · S/N 15280573N2669WMooney M20E · S/N 994N2911GPiper PA-28-161 · S/N 28-7916537N3299RPiper PA-28R-180 · S/N 28R-31270N337WWright Cecil NIEUPORT 11 · S/N 337N33MNBeech 95-A55 · S/N TC-241N340MTCessna 172S · S/N 172S10374N34865Cessna 177B · S/N 17702053N3639LCessna 172G · S/N 17253808N378GPBeech F33A · S/N CE-602N38645Piper J5A · S/N 5-1030N40CWright Cecil/Duane ACEY DUECY P-70 · S/N AD-221N410MTCessna 172S · S/N 172S10426N415JABombardier CL-600-2B16 · S/N 5783N4217DBeech G35 · S/N D-4426N436EARaytheon B200 · S/N BB-1576N4481BBaldock James F CORBEN JR ACE-E · S/N 1N4592LLance Metcalfe VIA · S/N L1021MN470DACirrus Design SR20 · S/N 1786N471DACirrus Design SR20 · S/N 1787N473DACirrus Design SR20 · S/N 1798N474DACirrus Design SR20 · S/N 1799N475DACirrus Design SR20 · S/N 1800N476DACirrus Design SR20 · S/N 1818N477DACirrus Design SR20 · S/N 1819N478DACirrus Design SR20 · S/N 1820N479DACirrus Design SR20 · S/N 1821N480DACirrus Design SR20 · S/N 1822N4815KRyan NAVION A · S/N NAV-4-1815N481DACirrus Design SR20 · S/N 1823N4845GCessna 172N · S/N 17273392N4854HPiper PA-17 · S/N 17-153N487DACirrus Design SR20 · S/N 1832
Back to Sanford, FL