OpenAirDocs.org
Sulphur, LA

Registered aircraft · 27

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

N1003XColumbia Aircraft Mfg LC41-550FG · S/N 41748Kap Electric IncN1458GBeech 35-B33 · S/N CD-463Built 1962 · Bayles Peter TN178XPiper PA-30 · S/N 30-1950Ss Aviation LLCN207GSIXL 207C · S/N 207C 001Ixl IncN2101VCessna T182T · S/N T18208733Built 2007 · Well Hung Metal LLCN25725Piper J3C-65 · S/N 3692Built 1939 · Ixl IncN26487Meyers OTW-145 · S/N 40Built 1941 · Wade Karen HN277BGEmbraer EMB-500 · S/N 50000344Built 2014 · Kap Holdings Sulphur LLCN27DDCessna 680 · S/N 680-0267Built 2009 · Diamond D Aviation LLCN3024MPiper PA-28-181 · S/N 28-7890286Built 1977 · Tremie Chad MN341RHBeech T-34B · S/N BG-75Ixl IncN3510CFirst Strike BOBCAT · S/N 1001Cummings Tom LN40934Piper PA-32-300 · S/N 32-7440071Built 1974 · Southern Style Equipment LLCN414GPCessna 414A · S/N 414A0331Built 1979 · Ss Aviation LLCN4250ABell 47D1 · S/N 421Ixl IncN4442FCessna 172 · S/N 46144Registration pendingBuilt 1958N4604JPiper PA-28R-180 · S/N 28R-30483Trouth Kevin JN510SHTaylor Russell E TAYLOR FLYBABY 1 · S/N 80-5Built 1990 · Guillory Howard CN563HHPowrachute PEGASUS · S/N A-341-PEGBuilt 2004 · Portie Keith AN6579DBell 47D1 · S/N 895Ixl IncN65WDRobinson Helicopter R44 II · S/N 12635Built 2008 · Wade Ashley BryanN701RSRitchey Steven ZENAIR CH 701 SP · S/N 7-9362Built 2003 · Billiot Terry DN731RTextron T240 · S/N T24002133Built 2017 · Kap Holdings Sulphur L L CN89709Cessna 120 · S/N 8758Built 1946 · Guillory Howard CN910KDRyan NAVION E · S/N NAV-4-1535Briggs Stephen PN918DDRaytheon B200 · S/N BB-1677Built 1999 · Diamond D Aviation LLCN922MPCirrus Design SR22T · S/N 2400Built 2021 · Pw Holdings LLC
Back to Sulphur, LA