OpenAirDocs.org
Lake Charles, LA

Registered aircraft · 163

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 = 'LAKE CHARLES'
  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.

N103DEEmbraer Executive EMB-505 · S/N 50500735Built 2023 · Dore Aviation LLCN1050GDJI AGRAS T40 · S/N 64TBL2100200TMSouthern Marsh And Ag Drone LLCN108AGAgusta A119 · S/N 14053Built 2005 · Bristow LLCN108TAEurocopter AS 350 B2 · S/N 3080Built 1998 · Bristow LLCN109DRAgusta AW139 · S/N 31311Bristow LLCN119MWAgustawestland Philadelphia AW139 · S/N 41307Built 2012 · Bristow LLCN121KMCessna 550 · S/N 550-0273Built 1981 · Wings By Dkw LLCN127JLEurocopter Deutschland EC 135 P2+ · S/N 0976Built 2011 · Bristow LLCN1397UCessna 172M · S/N 17267068Built 1976 · Rock Solid Aviation LLCN13LMPiper PA-34-200T · S/N 34-7870075First renewal noticeTupelo Limited LcN143DGCessna 162 · S/N 16200029Built 2010 · Sowela Technical Community CollegeN145JWSikorsky S-92A · S/N 920300Built 2016 · Bristow LLCN156JSAgusta AW139 · S/N 41003Built 2007 · Era Leasing LLCN159RBAgustawestland Philadelphia AW139 · S/N 41281Built 2012 · Bristow LLCN183EHEurocopter AS 350 B2 · S/N 2752Built 1993 · Bristow LLCN185EHEurocopter AS 350 B2 ECUREUIL · S/N 2823Built 1994 · Bristow LLCN187EHAerospatiale AS350 B2 ECUREUIL · S/N 2839Built 1994 · Bristow LLCN189EHAgustawestland AW189 · S/N 49018Built 2015 · Bristow LLCN1900YMooney M20C · S/N 2684Built 1964 · Marrero Francisco JN193EHAerospatiale AS350 B2 ECUREUIL · S/N 2599Bristow LLCN1ZKCessna T337G · S/N P3370268Sowela Technical Community CollegeN2115KCessna 182T · S/N 18281322Built 2004 · Liprie Randal CN21461Cessna 182P · S/N 18261645Built 1972 · Acme Aviation IncN2149VCessna 140 · S/N 14378Built 1948 · Quirk Charles LN214EHEurocopter AS 350 B2 · S/N 3163Built 1998 · Bristow LLCN215EHEurocopter AS 350 B2 · S/N 3172Built 1998 · Bristow LLCN216EHEurocopter AS 350 B2 · S/N 3184Built 1999 · Bristow LLCN217EHEurocopter AS 350 B2 · S/N 3197Built 1999 · Bristow LLCN217FDEurocopter AS 350 B2 · S/N 4221Built 2007 · Bristow LLCN224LPDJI AGRAS T40 · S/N 5X5BLAU00205D5Registration pendingN228BJEurocopter Deutschland EC 135 P2+ · S/N 0982Built 2011 · Bristow LLCN247RQVans RV-12IS · S/N 12100Built 2021 · Blonde Voyage LLCN2513TNavion NAVION H · S/N NAV-4-2513Built 1968 · Pettaway J MichaelN2653JLeading Edge Aerial Tech PV35X · S/N 11198Calcasieu Parish Police JuryN279NDPiper PA-28R-201 · S/N 2844034Built 2000 · Sowela Technical Community CollegeN294PCChamberlain Phillip VANS RV-7 · S/N 70387Built 2007 · Chamberlain Phillip LN302NMEurocopter Deutschland EC 135 P2+ · S/N 0987Built 2011 · Bristow LLCN314SSAgustawestland AW189 · S/N 49019Built 2015 · Bristow LLCN317ERCirrus Design SR22T · S/N 2144Built 2020 · Horus Air LLCN31DMMooney M20C · S/N 20-1248Built 1977 · Lejeune David EN32015Piper PA-34-200T · S/N 34-7570007Built 1974 · Rock Solid Aviation LLCN320TVEurocopter Deutschland EC 135 P2+ · S/N 0467Built 2006 · Bristow LLCN321HTCirrus Design SR22 · S/N 4246Built 2015 · Partnairs LLCN323AHEurocopter AS 350 B2 · S/N 4649Built 2008 · Bristow LLCN324XMEurocopter Deutschland EC 135 P2+ · S/N 0991Built 2011 · Bristow LLCN325DBEurocopter Deutschland EC 135 P2+ · S/N 0985Built 2011 · Bristow LLCN326LSLeonardo S P A AW189 · S/N 49028Built 2016 · Bristow LLCN328HPPiper PA-32R-301T · S/N 3257166Built 2000 · Alan C Perry LLCN328SHAgustawestland Philadelphia AW139 · S/N 41309Built 2012 · Bristow LLCN330JNAgusta AW119MKII · S/N 14510Built 2006 · Bristow LLC
Back to Lake Charles, LA