Clinton, AR
Registered aircraft · 34
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 = 'AR' AND g.registrant_city = 'CLINTON' 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 = 'AR' AND g.registrant_city = 'CLINTON' 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.
N128MCCessna 340A · S/N 340A1808N129TRBeech A36 · S/N E-2888N136BFBeech B36TC · S/N EA-465N1432RAeroprakt Mfg SP Z O O A32 · S/N 229N147PLBoozer C H LONGEZ · S/N 613N16QCCessna 421C · S/N 421C0689N17141Cessna 150L · S/N 15073638N1737MCessna 182P · S/N 18264423N302BMMcglaughlin Richard SPORTSMAN GS2 · S/N 7283N3882SCessna 172E · S/N 17251082N4106ZPiper PA-18-150 · S/N 188127N4167RPiper PA-32-300 · S/N 32-40483N516HMHester Maxey SPACEWALKERII · S/N SWII203-1N516RMHester Maxey SPACEWALKER 1 · S/N SW1-204-3N544DARobert Fitts FITTS CUB · S/N 100N544KGCessna T182T · S/N T18209006N5689ZPiper PA-22-108 · S/N 22-9522N5840ECessna 150 · S/N 17340N593APitts Special S-1C · S/N S-512N598LAAir Tractor AT-502B · S/N 502B-2598Sale reportedN60ECessna 340A · S/N 340A0663N63972Stinson L-5G · S/N 4622N678HCessna 414A · S/N 414A0678N6984VMooney M20F · S/N 22-1346N737FUCessna R182 · S/N R18200823N737ZTCessna 172N · S/N 17269808N778KFLiberty Aerospace LIBERTY XL-2 · S/N 0017N79473Cessna 172K · S/N 17258116N818RBRussell A Beers SPORTSMAN GS-2 · S/N 7064N8203WPiper PA-28-180 · S/N 28-2334N8436UCessna 172F · S/N 17252336N852GKKeith Grady KITFOX · S/N 1185N97984Cessna 172P · S/N 17276244N98698Piper J3C-65 · S/N 18928
Back to Clinton, AR