Natchez, MS
Registered aircraft · 49
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 = 'MS' AND g.registrant_city = 'NATCHEZ' 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 = 'MS' AND g.registrant_city = 'NATCHEZ' 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.
N1147JAero Commander 112 · S/N 132N124HJHonda HA-420 · S/N 42000124N126DPMaule M-7-235C · S/N 25004CN1645BBerg Allen C ALLEN BERG GLASTAR · S/N 5116N181ALDJI AGRAS T100 · S/N 1581F8ZLC25AE00274RMN1957YMooney M20D · S/N 222N19928Cessna 172M · S/N 17260866N244WWBell 206B · S/N 1962N3155JBalloon Works FIREFLY 7-15 · S/N F7-902N321GRRobinson Helicopter R66 · S/N 0738N33694Piper PA-32-260 · S/N 32-7500029N339SACessna 182S · S/N 18280508N3532ABeech E33A · S/N CE-289N366HCHarger Burton P RV-8 · S/N 80878N420KAHonda HA-420 · S/N 42000013N4311LCessna 172G · S/N 17254380N4522EHead Balloons AX8-88 · S/N 183N4523Tucker-Hurni STARDUSTER SA-300 · S/N 259N468TGDJI AGRAS T50 · S/N 1581F6BUB248U0011127N468UGDJI AGRAS T50 · S/N 1581F6BUB248U001FW6ZN469CDCirrus Design SR22 · S/N 1555N4730NCessna 182Q · S/N 18267319N4856GCessna 172N · S/N 17273403N491MMooney M-18C · S/N 244N516TGCessna 172N · S/N 17268889N523LUDJI AGRAS T40 · S/N 1581F574B239100100BLN5266ECessna 172N · S/N 17271805N550MPPiper PA-46-310P · S/N 4608041N567ATCirrus Design SR22 · S/N 2188N580TMPilatus PC-12/47E · S/N 1310N5994TCessna 150D · S/N 15060694N6358YAerostar International RAVEN S49A · S/N S49A-3078Registration pendingN6468LAerostar International S-66A · S/N S66A-3011N688DBLearjet 60 · S/N 097N6926DPiper PA-22-150 · S/N 22-4854N710PCCirrus Design SR22 · S/N 0754N713BGDJI PHANTOM 3 PROFESSION · S/N P76DCJ26A26872N733PDCessna 172N · S/N 17268435N733VACessna 172N · S/N 17268572N7527LRobinson Helicopter R44 II · S/N 11150N7537HPiper PA-12 · S/N 12-403N7850HPiper PA-12 · S/N 12-750N792JCHonda HA-420 · S/N 42000288N812PTMooney M20TN · S/N 31-0061N836EASocata TBM 700 · S/N 657N89850Cessna 140 · S/N 8584N9078ZAerostar International S-51A · S/N S51A-3009N918RGCessna T206H · S/N T20608682N9264FBeech 23 · S/N M-476
Back to Natchez, MS