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.
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
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.
N11110Sikorsky S-76B · S/N 760429N1170Bell Helicopter Textron Canada 407 · S/N 53478N11783Monocoupe 90A · S/N A708N125TABell 206B · S/N 1315N127APBell 206B · S/N 4460N12MQLeonardo S P A AB139 · S/N 31041N13MQSikorsky S-76C · S/N 760624N140HLBell 407 · S/N 53575N1416Bell 407 · S/N 53110N141APBell 407 · S/N 53441N146LLFlaherty Dave LANCAIR LEGACY · S/N 222N153PABell Helicopter Textron Canada 407 · S/N 54455N154TXDainys Henry P RANS S-19 · S/N 100800037N1612Bell 407 · S/N 53044N161SFBell 206-L4 · S/N 52335N163RLBell 407 · S/N 53163N164RLBell 407 · S/N 53140N169RLBell 206-L4 · S/N 52063N16MQSikorsky S-76C · S/N 760626N173RLBell 206-L4 · S/N 52066N173SFBell Helicopter Textron Canada 407 · S/N 53978N1751Bell 206B · S/N 3284N179RLBell 206-L4 · S/N 52102N1807Bell 206-L4 · S/N 52361N1821Bell 206-L4 · S/N 52366N184SFBell 407 · S/N 53087N192RLBell 206-L4 · S/N 52192N2009CBell Helicopter Textron 206L-1 · S/N 45678N205FCBell 206L-3 · S/N 51130N207MHBell 206L-3 · S/N 51303N2119AKeystone Helicopter S-76C · S/N 760640N2133XKeystone Helicopter S-76C · S/N 760638N216MHBell 206-L4 · S/N 52296N217FEurocopter Deutschland EC 135 P2 · S/N 0438N217MHBell 206-L4 · S/N 52226N217TEurocopter Deutschland EC 135 P2 · S/N 0441N218BCCoit William R RANS S7 · S/N 1194143N233MHBell 206L-3 · S/N 51250N249CACessna 525 · S/N 525-0291N25740Sikorsky S-76C · S/N 760732N282SSikorsky S-76A · S/N 760282N294VMBell 407 · S/N 53781N295DCubcrafters CC11-160 · S/N CC11-00295N307KHBell 407 · S/N 53172N309RLBell 407 · S/N 53092N311MQAgustawestland AW139 · S/N 31532N3180LBell 206L-3 · S/N 51055N3191Bell 407 · S/N 53211N32GETextron 525C · S/N 525C0498N32GLRockwell International 500-S · S/N 3312
Back to Broussard, LA