OpenAirDocs.org
Ruston, LA

Registered aircraft · 40

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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 = 'LA' AND g.registrant_city = 'RUSTON'
  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.

N105TCPiper PA-32-300 · S/N 32-7940163Built 1979 · Mark Johnson And Sons Plumbing LLCN1112JRaytheon 58 · S/N TH-1822Built 1997 · Jedco Properties LLCN129GPCirrus Design SR22 · S/N 1366Built 2005 · Pafford Holdings LLCN20706Cessna 182P · S/N 18261142Built 1972 · Ahf Investments LLCN211ACCirrus Design SR22 · S/N 4787Built 2019 · James P Hill Distributor IncN24576Cessna 172R · S/N 17280892Built 2000 · Board Of Supervisors Of The University Of La SystN25MLCirrus Design SR22 · S/N 1571Built 2005 · Azalea Grove LLCN2948JCessna 150G · S/N 15065748Sale reportedBuilt 1966N301BZRaytheon G36 · S/N E-3642Built 2005 · Pin High LLCN383MAEnstrom 280FX · S/N 2048Vandenberg Herbert FN3898HMooney M20J · S/N 24-0893Built 1979 · True Course Holdings LLCN414PACessna 414A · S/N 414A0051Built 1978 · Pafford Emergency Medical Services IncN42BECirrus Design SR22 · S/N 3903Lasalle Management Company LLCN619PABeech B200 · S/N BB-1458Built 1993 · Pafford Air Of Mississippi LLCN654YBHerbert Vandenberg LANCAIR 4P · S/N LIV-609Built 2016 · Vandenberg HerbertN6920ECessna 175A · S/N 56420Shoemaker LoganN695PACessna 525 · S/N 525-0158Built 1996 · Pafford Air Of Mississippi LLCN714BMRaytheon A36 · S/N E-3345Built 2000 · Murphy RandallN7264FPiper PA-28-140 · S/N 28-25184Podyaire LLCN7461VMooney M20F · S/N 22-1238Built 1975 · Drake Robert LN781CMBurns Mark A VANS RV-7A · S/N 72183Built 2008 · Burns Mark AN82DHCirrus Design SR22T · S/N 0008Built 2010 · Bonlori Aviation LLCN844JBStony J Barron BARRON BEARHAWK · S/N 35-15Built 2026 · Barron Stony JN8725UCessna 172F · S/N 17252629Built 1965 · Arklamiss Aviation LLCN9153PPiper PA-24-260 · S/N 24-4639Built 1966 · A&E Aviation LLCN93AKCessna 525A · S/N 525A0368Built 2007 · Lasalle Management Company LLCN9486YBeech 95-55 · S/N TC-49Built 1961 · Robbins Donald Lee Jr DBAN961LTTextron 172S · S/N 172S12031Built 2017 · University Of La System DBAN962LTTextron 172S · S/N 172S12032Built 2017 · University Of La System DBAN963LTTextron 172S · S/N 172S12033Built 2017 · University Of La System DBAN964LTTextron 172S · S/N 172S12034Built 2017 · University Of La System DBAN965LTTextron 172S · S/N 172S12035Built 2017 · University Of La System DBAN966LTTextron 172S · S/N 172S12036Built 2017 · University Of La System DBAN967LTTextron 172S · S/N 172S12037Built 2017 · University Of La System DBAN968LTTextron 172S · S/N 172S12038Built 2017 · University Of La System DBAN969LTTextron 172S · S/N 172S12039Built 2017 · University Of La System DBAN970LTTextron 172S · S/N 172S12040Built 2017 · University Of La System DBAN972LTPiper PA-28R-201 · S/N 2844172Built 2017 · University Of La System DBAN973LTPiper PA-28R-201 · S/N 2844173Built 2017 · University Of La System DBAN9960ECessna 172N · S/N 17272299Arklamiss Aviation LLC
Back to Ruston, LA