OpenAirDocs.org
Broussard, LA

Cancelled registrations · 97

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'LA' AND d.registrant_city = 'BROUSSARD'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N237PABell Helicopter Textron Canada 407 · S/N 54127Cancelled Oct 26, 2026 · Built 2012 · Gm Leasing Company LLCN57499Bell 206B · S/N 3086Cancelled Aug 23, 2024 · Exported to Guatemala · Built 1980 · Gm Leasing Co LLCN59582Bell 206B · S/N 1460Cancelled Aug 21, 2024 · Exported to Guatemala · Built 1974 · Gm Leasing Co LLCN531BHSikorsky S-76C · S/N 760725Cancelled Mar 23, 2024 · Sale reported, canceled · Built 2008N595RLBell 407 · S/N 53595Cancelled Dec 15, 2023 · Sale reported, pending cancellation · Built 2004N171RLBell 206-L4 · S/N 52064Cancelled Dec 6, 2023 · Exported to Colombia · Built 1993 · Rotorcraft Leasing Co LLCN512RLBell 206L-3 · S/N 51078Cancelled Dec 6, 2023 · Exported to Colombia · Built 1984 · Rotorcraft Leasing Co LLCN167RLBell 407 · S/N 53167Cancelled Nov 8, 2023 · Built 1997 · Rotorcraft Leasing Company LLCN414RLBell 206-L4 · S/N 52006Cancelled Nov 8, 2023 · Built 1992 · Rotorcraft Leasing Co LLCN83TSikorsky S-76 · S/N 760117Cancelled Nov 8, 2023 · Rotorcraft Leasing Co LLCN5402TSikorsky S-76 · S/N 760140Cancelled Aug 5, 2023 · Rotorcraft Leasing Co LLCN665RLBell 407 · S/N 53491Cancelled Aug 5, 2023 · Built 2001 · Rotorcraft Leasing Company LLCN519ALSikorsky S-76A · S/N 760058Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Arrow Aviation Company LLCN6314KRepublic RC-3 · S/N 537Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Goudeau Todd JN218MHBell 206-L4 · S/N 52281Cancelled Dec 28, 2021 · Exported to Mexico · Meridian Helicopters LLCN80GHSikorsky S-76A · S/N 760205Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1981 · Arrow Aviation Company LLCN1144Sikorsky S-76A · S/N 760156Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Arrow Aviation Co LLCN1315Sikorsky S-76A · S/N 760107Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Arrow Aviation Co LLCN1471Sikorsky S-76A · S/N 760115Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Arrow Aviation Co LLCN1516Sikorsky S-76A · S/N 760097Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Arrow Aviation Co LLCN1631Sikorsky S-76A · S/N 760046Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Arrow Aviation Co LLCN1197Bell 407 · S/N 53151Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1997 · Gm Leasing Company LLCN707MYSikorsky S-76B · S/N 760327Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1986 · Arrow Aviation Co LLCN596SDDJI INSPIRE 1 · S/N W13DCB25020327Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Bartels Dacoda JN6121Sikorsky S-76A · S/N 760056Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Arrow Aviation Co LLCN274XSikorsky S-76C · S/N 760440Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1995 · Arrow Aviation Company LLCN276XSikorsky S-76C · S/N 760405Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1994 · Arrow Aviation Company LLCN430XBell 430 · S/N 49058Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1999 · Arrow Aviation Co LLCN430XMBell 430 · S/N 49073Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 2000 · Arrow Aviation Co LLCN89HSikorsky S-76C · S/N 760406Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1994 · Arrow Aviation Company LLCN3181JBell 206B · S/N 3771Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1983 · Arrow Aviation Co LLCN597SDDJI S1000 · S/N 02E0037749Cancelled Jan 22, 2019 · Registration expired, pending cancellation · Bartels Dacoda JN174RLBell 206-L4 · S/N 52067Cancelled Jan 10, 2019 · Built 1993 · Rotorcraft Leasing Co LLCN519EHBell Helicopter Textron 206L-1 · S/N 45429Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1980 · Gm Leasing Co LLCN204MHBell Helicopter Textron Canada 206L-4 · S/N 52005Cancelled Aug 29, 2018 · Exported to Mexico · Built 1992 · Meridian Helicopters LLCN311RLBell 407 · S/N 53069Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1996 · Gm Leasing Company LLCN2018RBell Helicopter Textron 206L-1 · S/N 45681Cancelled Jun 1, 2018 · Built 1981 · Gm Leasing Co LLCN1713Sikorsky S-76A · S/N 760026Cancelled May 3, 2018 · Registration expired, pending cancellation · Arrow Aviation Co LLCN207MYBell 206-L4 · S/N 52258Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2000 · Coy Leasing LLCN1210Bell Helicopter Textron 206L-1 · S/N 45524Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1980 · Gm Leasing Co LLCN744DBeech C35 · S/N D-3014Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1951 · Botts Eugene JN2735ACessna 414A · S/N 414A0463Cancelled Jan 2, 2018 · Third renewal notice · Built 1979 · Cessna 414 LLCN512RABell 206L-3 · S/N 51218Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Rotorcraft Assets LLCN5401GSikorsky S-76 · S/N 760137Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Rotorcraft Assets LLCN760RLSikorsky S-76A · S/N 760131Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Rotorcraft Leasing Co LLCN7817SBell 206B · S/N 17Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Rotorcraft Assets LLCN3RLBell 206B · S/N 396Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1969 · Rotorcraft Assets LLCN1371Bell 407 · S/N 53182Cancelled Oct 11, 2017 · Built 1997 · Gm Leasing Company LLCN610HGSikorsky S-76A · S/N 76-0016Cancelled Aug 30, 2017 · Third renewal notice · Built 1979 · Arrow Aviation Co LLCN742RTBell 206B · S/N 2742Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Rotorcraft Technologies Inc
Back to Broussard, LA