Chapmansboro, TN
Registered aircraft · 28
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 = 'TN' AND g.registrant_city = 'CHAPMANSBORO' 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 = 'TN' AND g.registrant_city = 'CHAPMANSBORO' 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.
N125RSAmerican Champion 8KCAB · S/N 657-91N12KLGlaser-Dirks DG-400 · S/N 4-260N133FCBeech 35-B33 · S/N CD-470N1700QCessna 150L · S/N 15073000N174ASNyman Stephen M VANS RV-7 · S/N 71086N260JGAerotek PITTS S-2B · S/N 5002N2738EAeronca 7AC · S/N 7AC-6319N27CTCessna 337H · S/N 33701888N300RWWilliams Ray L PITTS S2S · S/N 01N4088BBellanca 17-31ATC · S/N 75-31120N44507Piper PA-28-140 · S/N 28-7425419N4556Young Paul E CHRISTEN EAGLE II · S/N YOUNG 0001N5111BAviat S-1-11B · S/N 4003N51874Fairchild M-62A · S/N T42-3699N54GDRuschke Gerald J RUSCHKE ROCKET · S/N 006N55MCCulpepper Mark D RV-6 · S/N 60263N60108Cessna 150J · S/N 15070074N6230YPiper PA-23-250 · S/N 27-3459Registration pendingN65350Dehavilland DHC-1 CHIPMUNK · S/N C1-0746/568N6CJRequarth PITTS S-1S · S/N 10047N74466Bellanca 14-13-2 · S/N 1579N7478HPiper J3C-65 · S/N 20782N779TMCessna 180H · S/N 18052271N84ASNyman Stephen M RV-8 · S/N 83895N861JPJames J Patchett VANS RV8 · S/N 83881N88MCMark Culpepper F1 ROCKET · S/N 007N9218APinegar CORBIN BABY ACE D · S/N 101N98540Piper J3C-65 · S/N 18751
Back to Chapmansboro, TN