Ozark, MO
Registered aircraft · 48
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 = 'OZARK' 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 = 'OZARK' 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.
N101ZSKelley J Brow Z-STOL · S/N 101N1058JAero Commander 112 · S/N 58N1142GMooney M20J · S/N 24-1172N1213RCessna 150G · S/N 15064627First renewal noticeN1558ECessna 172N · S/N 17271046N1574RGrumman American Avn. AA-1B · S/N AA1B0674N181WAMorne Nortier X-350 · S/N WA15066N20045Cessna 172M · S/N 17260958N2008BBeech C24R · S/N MC-596N201JJMooney M20J · S/N 24-0051N2569TQuad City CH CHALLENGER II · S/N CH20789CW0442N3181VBeech 35 · S/N D-616N334TRBeech F33A · S/N CE-1499N3404TCessna 177 · S/N 17700704N345RBBarnett Russell L SH-2F · S/N R1063-2415BN3479XMooney M20E · S/N 1153N3512OTT SMITH MINIPLANE · S/N O-1N359JSSchrader Steve M HATZ CB1 · S/N 359N381FCPiper PA-28-151 · S/N 28-7615197N3977GGordon Scot A RV-6A · S/N 23877N42755Piper J3C-65 · S/N 15060N44231Taylorcraft BC12-D · S/N 10031N44845Piper PA-28R-201T · S/N 28R-7703331N465PFVan Flynn WAG-AERO SUPER SPORT · S/N 7865N4832DCessna 182A · S/N 34932N50012Cessna 150H · S/N 15069009N5016QGehring Thomas R AVID FLYER · S/N 0163N5467UBeech D95A · S/N TD-704N556CFCapella FW1C50 · S/N 001N58856Howard DGA-15P · S/N 998N604RDCessna 180J · S/N 18052417N6498PPiper PA-24-250 · S/N 24-1618N6933NMooney M-20G · S/N 680148N704QBeech H35 · S/N D-4883N71709Aerostar International RX 8 · S/N RX8-3273N73PFPiper PA-28-161 · S/N 28-8216092N750PBeech 35-B33 · S/N CD-624N7784ADavid Scott Aug CH 750 CRUZER · S/N 75-11261N800FUCessna T210M · S/N 21062792N8165PPiper PA-24-250 · S/N 24-3420N832DPBarnett Russell L SH-2R SUPER II RG · S/N R-2235-BN891ACDaniel C S/Maxwell T A LANCAIR SUPER ES · S/N ES-186N91242Mooney M20R · S/N 29-0236First renewal noticeN9329PPiper PA-24-260 · S/N 24-4827N95202Taylorcraft BC12-D · S/N 9602N953SSDelbert Sinor STOL CH750SD · S/N SD75-11751N95834Cessna 182Q · S/N 18266648N97679Stinson 108 · S/N 108-679
Back to Ozark, MO