Broussard, LA

Registered aircraft · 142

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 = 'BROUSSARD'
  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.

N11110Sikorsky S-76B · S/N 760429Arrow Aviation Co LLCN1170Bell Helicopter Textron Canada 407 · S/N 53478Built 2001 · Gm Leasing Co LLCN11783Monocoupe 90A · S/N A708Built 1935 · Goudeau Todd JN125TABell 206B · S/N 1315Built 1974 · Gm Leasing Company LLCN127APBell 206B · S/N 4460Built 1997 · Gm Leasing Co LLCN12MQLeonardo S P A AB139 · S/N 31041Arrow Aviation Company LLCN13MQSikorsky S-76C · S/N 760624Arrow Aviation Company LLCN140HLBell 407 · S/N 53575Built 2003 · Gm Leasing Company LLCN1416Bell 407 · S/N 53110Gm Leasing Company LLCN141APBell 407 · S/N 53441Built 2000 · Gm Leasing Co LLCN146LLFlaherty Dave LANCAIR LEGACY · S/N 222Built 2009 · Richard Richard DN153PABell Helicopter Textron Canada 407 · S/N 54455Built 2013 · Gm Leasing Company LLCN154TXDainys Henry P RANS S-19 · S/N 100800037Built 2008 · Ducote RyanN1612Bell 407 · S/N 53044Built 1996 · Gm Leasing Co LLCN161SFBell 206-L4 · S/N 52335Built 2006 · Gm Leasing Co LLCN163RLBell 407 · S/N 53163Rotorcraft Leasing Company LLCN164RLBell 407 · S/N 53140Built 1997 · Rotorcraft Leasing Company LLCN169RLBell 206-L4 · S/N 52063Built 1993 · Rotorcraft Leasing Co LLCN16MQSikorsky S-76C · S/N 760626Arrow Aviation Company LLCN173RLBell 206-L4 · S/N 52066Built 1993 · Rotorcraft Leasing Co LLCN173SFBell Helicopter Textron Canada 407 · S/N 53978Gm Leasing Company LLCN1751Bell 206B · S/N 3284Built 1981 · Gm Leasing Co LLCN179RLBell 206-L4 · S/N 52102Built 1994 · Rotorcraft Leasing Co LLCN1807Bell 206-L4 · S/N 52361Built 2007 · Gm Leasing Co LLCN1821Bell 206-L4 · S/N 52366Built 2007 · Gm Leasing Co LLCN184SFBell 407 · S/N 53087Built 1996 · Gm Leasing Co LLCN192RLBell 206-L4 · S/N 52192Built 1996 · Rotorcraft Leasing Co LLCN2009CBell Helicopter Textron 206L-1 · S/N 45678Built 1982 · Meridian Helicopters LLCN205FCBell 206L-3 · S/N 51130Built 1985 · Gm Leasing Co LLCN207MHBell 206L-3 · S/N 51303Built 1989 · Meridian Helicopters LLCN2119AKeystone Helicopter S-76C · S/N 760640Arrow Aviation Co LLCN2133XKeystone Helicopter S-76C · S/N 760638Arrow Aviation Co LLCN216MHBell 206-L4 · S/N 52296Built 2004 · Meridian Helicopters LLCN217FEurocopter Deutschland EC 135 P2 · S/N 0438Built 2005 · Arrow Aviation Company LLCN217MHBell 206-L4 · S/N 52226Built 1999 · Meridian Helicopters LLCN217TEurocopter Deutschland EC 135 P2 · S/N 0441Built 2005 · Arrow Aviation Company LLCN218BCCoit William R RANS S7 · S/N 1194143Nxbz Aircraft Holdings LLCN233MHBell 206L-3 · S/N 51250Built 1988 · Meridian Helicopters LLCN249CACessna 525 · S/N 525-0291Built 1998 · Lafayette Flight Service LLCN25740Sikorsky S-76C · S/N 760732Arrow Aviation Company LLCN282SSikorsky S-76A · S/N 760282Built 1985 · Arrow Aviation Company LLCN294VMBell 407 · S/N 53781Built 2007 · Gm Leasing Co LLCN295DCubcrafters CC11-160 · S/N CC11-00295Richard D RichardN307KHBell 407 · S/N 53172Built 1997 · Gm Leasing Company LLCN309RLBell 407 · S/N 53092Built 1996 · Rotorcraft Leasing Company LLCN311MQAgustawestland AW139 · S/N 31532Arrow Aviation Company LLCN3180LBell 206L-3 · S/N 51055Built 1983 · Gm Leasing Co LLCN3191Bell 407 · S/N 53211Built 1997 · Gm Leasing Co LLCN32GETextron 525C · S/N 525C0498Built 2026 · Ge Air IncN32GLRockwell International 500-S · S/N 3312Built 1978 · G E Air Inc
Back to Broussard, LA