Poplar Bluff, MO
Registered aircraft · 36
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 = 'MO' AND g.registrant_city = 'POPLAR BLUFF' 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 = 'MO' AND g.registrant_city = 'POPLAR BLUFF' 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.
N1057TCessna 182T · S/N 18281572N119MRRound Michael B CHALLENGER II · S/N CH2-0802-2253N182LNCessna 182P · S/N 18265048N1858YCessna 172C · S/N 17249458N22YATL Ultralight Sro STINGSPORT TL2000 · S/N TLUSA163First renewal noticeN2354GCessna 182B · S/N 51654N307BRAir Tractor AT-802 · S/N 802-0718First renewal noticeN31845Aeronca 65-LB · S/N L-11380N3503FM-Squared SPRINT 1000 · S/N 000710N37350Beech A36 · S/N E-1768N373BSPiper PA-28-140 · S/N 28-26555N414DWCessna 414A · S/N 414A0043N4204LCessna 172G · S/N 17254273N51147Cessna 150J · S/N 15069795N5123WPiper PA-28 · S/N 28-149N5330GPiper PA-32R-301T · S/N 3257232N6045GCessna 150K · S/N 15071545N66BZChris Wallen JA35 SUPERSTOL · S/N JA494-06-16Sale reportedN6810BBlank Joseph RV-6 · S/N 60363N718MLAir Tractor AT-802 · S/N 802-0830N729LHTextron G58 · S/N TH-2552N7816VMooney M20C · S/N 2800N781DLPilatus PC-12/45 · S/N 334N78253Cessna 172K · S/N 17257546N802DMAir Tractor AT-802 · S/N 802-0338N803ASAir Tractor AT-802 · S/N 802-1096N804AAAir Tractor AT-802 · S/N 802-0698N805ASAir Tractor AT-802 · S/N 802-1182N812ASAir Tractor AT-802 · S/N 802-1191N812EBAir Tractor AT-802A · S/N 802A-0867N829TBTextron B200GT · S/N BY-406N84096Aeronca 7AC · S/N 7AC-2783N8853NPiper PA-28-140 · S/N 28-25707N9330DJI AGRAS T25 · S/N 1581F6BUB245H001LPLRN941LAAir Tractor AT-802 · S/N 802-0941N952CLLindstrand Balloons 90A · S/N 231
Back to Poplar Bluff, MO