Sanford, NC
Registered aircraft · 84
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 = 'NC' 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 = 'NC' 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.
N1031RMooney M20K · S/N 25-1216N103DRHosmer Jack MERLIN · S/N HV-40N1068XMooney M20J · S/N 24-3302N110YXSteffey Charles S WAIEX · S/N W0110Sale reported, canceledN1162KLuscombe 8E · S/N 3889N127MHHudson Marc RV-7 · S/N 72848N1289CPiper PA-22-135 · S/N 22-1110N131MPPiper PA-31P · S/N 31P-7400193N1435KLuscombe 8A · S/N 4162Registration revokedN1486KLuscombe 8A · S/N 4213N15767Dean James J MAUZY PAC 2 POLM · S/N 1N16360Taylor J-2 · S/N 589N180CVPiper PA-28R-180 · S/N 28R30693N1988BLuscombe 8A · S/N 6415N201HTMooney M20J · S/N 24-0239N20UKMooney M20F · S/N 22-1380N2114FPiper PA-28-161 · S/N 28-7916169N218EAeropro CZ S R O A240 · S/N 55018N2321FCessna 210E · S/N 21058521N2349EAeronca 7EC · S/N 7AC-5926N2468SCirrus Design SR22 · S/N 1090N25727Piper J3C-65 · S/N 3694N26045Piper PA-38-112 · S/N 38-81A0112N27571Taylorcraft BL-65 · S/N 2212N2781LCessna 170B · S/N 19266N2789EAeronca 7AC · S/N 7AC-6372N28664Grumman American Avn. AA-5B · S/N AA5B0738N28842Piper PA-28-161 · S/N 28-7916417N2893CPiper PA-28-161 · S/N 28-7916517N29640Taylorcraft BL-65 · S/N 2481N3000SFirefly Balloons 2010 FIREFLY 7B-15 · S/N F7B-2017N30617Cessna 172M · S/N 17264149N3191FBalloon Works FIREFLY 7-15 · S/N F71002N3210Piper PA-22-108 · S/N 22-8079N326BPPiper PA-32-300 · S/N 32-7540014N337UKReims CESSNA F337G · S/N 0084N35712Cessna 172I · S/N 17256926N3825MBeech A36 · S/N E-1813N394RACessna 210K · S/N 21059329N4079ARaytheon A36 · S/N E-3279N4138WPiper PA-34-220T · S/N 3449122N421GKCessna 421C · S/N 421C1053N4256Williams VOLKSPLANE · S/N SL-1N42658Piper J-3C · S/N 14952N4640BCessna 152 · S/N 15283560N4721QCessna A185E · S/N 185-1175N50155Cessna 150H · S/N 15069097N5077HNodorft Allen AC-5M · S/N 34N53587Cessna 172S · S/N 172S9407N5389MCessna 152 · S/N 15284576
Back to Sanford, NC